Airline Delays · The 7 a.m. Domino

When a plane lands late with under an hour before its next flight, that flight leaves late about 9 times in 10.

Role
Sole analyst
Stack
SQL (SQLite), Power BI
Data
U.S. DOT flight records · July 2026

Imagine you’re an airline executive reviewing schedules. Why are delays happening, how much are they costing us, and how can we improve?

  • Why are we late? 42% of delay minutes start with a plane that was already late (on flights arriving 15+ minutes late), and the delay grows on the ground.
  • What does it cost? Late planes with under an hour on the ground added 734,000 minutes in July, about $74M at stake.
  • How do we improve? Give late-arriving planes more turn time where delays snowball most, starting with Atlanta.

Why flights run late

Share of delay minutes by cause, flights arriving 15+ min late

Late-arriving aircraft
41.8%
Airline (crew, maintenance, etc.)
31.7%
Air traffic system
19.9%
Weather
6.5%
Security
0.1%

A late first flight makes finishing the day an hour or more late 1.7× as likely.

Where it costs the most

Millions of dollars at stake from tight turns after a late arrival, top 10 airports

ATL
$3.24M
BNA
$2.50M
DEN
$2.40M
DFW
$2.29M
DCA
$2.27M
MCO
$2.11M
BOS
$1.94M
CLT
$1.83M
BWI
$1.81M
AUS
$1.62M

At stake = minutes added × $100.76 per minute, Airlines for America’s 2024 average aircraft block-time cost. A yardstick, not an exact bill.

Source: U.S. DOT Bureau of Transportation Statistics, On-Time Performance, July 2026

View the Power BI dashboard (PDF) ↗ View on GitHub ↗

The question

I wanted a real business question, answered with real data. So I took one month of U.S. government flight records, every domestic flight the major airlines reported in July 2026, about 632,000 of them, and followed each plane through its day by tail number. The summary above has the short answers; the rest of this page is how I got there.

One plane’s journey

What turns one late flight into a late day?

Before the big numbers, one plane. The data has a tail number on every flight, so you can follow a single aircraft through its day. On July 1, N1776R hit an airline problem on its second flight, landing 92 minutes late, and the next flight inherited almost all of it. Two weeks later, the same plane picked up small delays and still landed in San Diego 25 minutes early. What made the difference?

July 1

Arrival delay at each stop, in minutes. An airline problem on flight 2 rides into flight 3.

Aircraft N1776R on July 1: arrival delay at each stop Dallas Love to Las Vegas lands 8 minutes early; Las Vegas to Long Beach lands 92 minutes late; Long Beach to Dallas Love lands 89 minutes late. −40 −20 0 20 40 60 80 100 −8 1. DAL → LAS 92 2. LAS → LGB 89 3. LGB → DAL

July 15

Arrival delay at each stop, in minutes. Small delays the schedule absorbed.

Aircraft N1776R on July 15: arrival delay at each stop Six flights land 9 early, 10 early, 21 early, 9 late, 15 late into Denver, then 25 minutes early into San Diego. −40 −20 0 20 40 60 80 100 −9 1. MDW → DCA −10 2. DCA → MDW −21 3. MDW → SMF 9 4. SMF → SEA 15 5. SEA → DEN −25 6. DEN → SAN

The domino effect

Does a late start ruin the day?

Across all 138,730 plane-days with two or more flights, a first flight that left 15 or more minutes late made finishing the day an hour or more late 1.7 times as likely: 30.9% of late starts, against 17.8% of on-time starts. But it wasn’t destiny. Almost 30% of planes that started late still landed their last flight early. So where does the time get made up, or lost?

How each plane’s day ended

Share of plane-days by how late the last flight arrived, July 2026

  • First flight left 15+ min late
  • First flight on time
Landed early
29.5%
44.0%
0–14 min late
14.4%
16.8%
15–59 min late
25.1%
21.3%
1–3 hrs late
23.0%
13.7%
3+ hrs late
7.9%
4.1%

The lever: time on the ground

How do late planes catch up, or fall further behind?

My first guess was that late planes catch up in the air: faster flying, quicker taxi. The data said partly. Planes that recovered won time back in both places, 37 minutes in the air and 45 on the ground, but planes that fell further behind roughly broke even in the air and lost 65 minutes at the gate. And the schedule decides a lot of that. After a late arrival with under an hour on the ground, the next flight left late about 9 times in 10; with 90 minutes or more, about half the time.

Where time is won and lost

Average minutes won back (+) or lost (−) over the day, planes whose first flight left 15+ min late

Recovered: landed early In the air
+37
On the ground
+45
Snowballed: finished 60+ min late In the air
+4
On the ground
−65

Next flight leaves late

Share of turns after a 15+ min late arrival where the next flight also left 15+ min late, by scheduled time on the ground

Under 45 min
94.5%
45–59 min
89.2%
60–89 min
75.0%
90 min–3 hrs
49.1%
3+ hrs
46.5%

Where to make changes

Which airports should get buffer time added?

Adding time to every schedule isn’t free: a plane sitting at the gate isn’t flying passengers. So the question is where extra time pays off. Atlanta is the clear first place to look, with the most delay minutes added of any airport (32,110, about $3.24M at stake) and the most added per turn among the 17 busiest. Denver adds a lot too, but mostly because it’s so busy. Smaller airports can add more per turn, but they have far fewer turns, so less is at stake.

Size vs. severity

Airports with 100+ tight late turns. Bubble size is dollars at stake; hover a bubble for its airport.

Airports by tight late turns and minutes added per turn Scatter plot of 111 airports with 100 or more tight turns after a late arrival. Atlanta sits apart toward the upper right: 1,577 turns and 20.4 minutes added per turn, the most at stake at $3.24 million. Denver has the most turns, 2,475, but adds 9.6 minutes per turn. The smallest airports reach 30 to 43 minutes per turn on far fewer turns. −10 0 10 20 30 40 0 500 1,000 1,500 2,000 2,500 Tight turns after a late arrival (under an hour on the ground) Minutes added per turn BNA: 1,831 tight late turns, 13.5 min added per turn, $2.50M at stake DEN: 2,475 tight late turns, 9.6 min added per turn, $2.40M at stake DFW: 1,421 tight late turns, 16.0 min added per turn, $2.29M at stake DCA: 1,519 tight late turns, 14.8 min added per turn, $2.27M at stake MCO: 1,186 tight late turns, 17.6 min added per turn, $2.11M at stake BOS: 1,136 tight late turns, 17.0 min added per turn, $1.94M at stake CLT: 1,067 tight late turns, 17.0 min added per turn, $1.83M at stake BWI: 1,007 tight late turns, 17.8 min added per turn, $1.81M at stake AUS: 1,182 tight late turns, 13.6 min added per turn, $1.62M at stake LGA: 1,003 tight late turns, 14.3 min added per turn, $1.44M at stake DAL: 1,122 tight late turns, 12.3 min added per turn, $1.39M at stake FLL: 731 tight late turns, 17.7 min added per turn, $1.31M at stake MDW: 934 tight late turns, 12.8 min added per turn, $1.20M at stake IAH: 511 tight late turns, 23.4 min added per turn, $1.20M at stake RDU: 616 tight late turns, 18.3 min added per turn, $1.14M at stake PHL: 626 tight late turns, 17.9 min added per turn, $1.13M at stake LAS: 1,499 tight late turns, 7.5 min added per turn, $1.13M at stake ORD: 1,651 tight late turns, 6.4 min added per turn, $1.06M at stake MIA: 380 tight late turns, 23.9 min added per turn, $0.92M at stake SAN: 1,542 tight late turns, 5.8 min added per turn, $0.91M at stake SEA: 721 tight late turns, 12.3 min added per turn, $0.89M at stake STL: 898 tight late turns, 9.7 min added per turn, $0.88M at stake PHX: 1,400 tight late turns, 6.2 min added per turn, $0.88M at stake BUF: 318 tight late turns, 26.1 min added per turn, $0.84M at stake SNA: 586 tight late turns, 13.9 min added per turn, $0.82M at stake CHS: 358 tight late turns, 22.4 min added per turn, $0.81M at stake MSY: 575 tight late turns, 13.0 min added per turn, $0.76M at stake JFK: 366 tight late turns, 19.0 min added per turn, $0.70M at stake DTW: 652 tight late turns, 10.7 min added per turn, $0.70M at stake PIT: 460 tight late turns, 14.9 min added per turn, $0.69M at stake ORF: 256 tight late turns, 26.8 min added per turn, $0.69M at stake JAX: 403 tight late turns, 16.8 min added per turn, $0.68M at stake HOU: 712 tight late turns, 9.3 min added per turn, $0.67M at stake ECP: 255 tight late turns, 26.2 min added per turn, $0.67M at stake CLE: 341 tight late turns, 19.3 min added per turn, $0.66M at stake TPA: 671 tight late turns, 9.5 min added per turn, $0.64M at stake MCI: 632 tight late turns, 9.8 min added per turn, $0.62M at stake PWM: 142 tight late turns, 42.7 min added per turn, $0.61M at stake MYR: 304 tight late turns, 19.8 min added per turn, $0.61M at stake SAT: 432 tight late turns, 13.8 min added per turn, $0.60M at stake IND: 478 tight late turns, 12.4 min added per turn, $0.60M at stake MKE: 359 tight late turns, 16.4 min added per turn, $0.59M at stake TYS: 202 tight late turns, 28.7 min added per turn, $0.58M at stake PBI: 186 tight late turns, 29.0 min added per turn, $0.54M at stake LAX: 928 tight late turns, 5.8 min added per turn, $0.54M at stake EWR: 386 tight late turns, 13.7 min added per turn, $0.53M at stake MSN: 154 tight late turns, 32.5 min added per turn, $0.50M at stake DSM: 167 tight late turns, 28.1 min added per turn, $0.47M at stake ILM: 117 tight late turns, 38.1 min added per turn, $0.45M at stake ABQ: 280 tight late turns, 14.8 min added per turn, $0.42M at stake PNS: 226 tight late turns, 17.5 min added per turn, $0.40M at stake BHM: 247 tight late turns, 15.9 min added per turn, $0.40M at stake SJU: 232 tight late turns, 16.5 min added per turn, $0.39M at stake HPN: 105 tight late turns, 34.7 min added per turn, $0.37M at stake OMA: 320 tight late turns, 11.1 min added per turn, $0.36M at stake RIC: 260 tight late turns, 13.3 min added per turn, $0.35M at stake CMH: 406 tight late turns, 8.6 min added per turn, $0.35M at stake BDL: 203 tight late turns, 16.9 min added per turn, $0.35M at stake PDX: 371 tight late turns, 9.1 min added per turn, $0.34M at stake MSP: 494 tight late turns, 6.9 min added per turn, $0.34M at stake ACK: 101 tight late turns, 33.3 min added per turn, $0.34M at stake SYR: 148 tight late turns, 22.1 min added per turn, $0.33M at stake SDF: 234 tight late turns, 13.0 min added per turn, $0.31M at stake SLC: 493 tight late turns, 6.0 min added per turn, $0.30M at stake VPS: 267 tight late turns, 10.5 min added per turn, $0.28M at stake COS: 143 tight late turns, 19.6 min added per turn, $0.28M at stake SFB: 172 tight late turns, 15.5 min added per turn, $0.27M at stake SAV: 263 tight late turns, 10.2 min added per turn, $0.27M at stake PVD: 190 tight late turns, 14.3 min added per turn, $0.27M at stake OKC: 295 tight late turns, 9.2 min added per turn, $0.27M at stake EYW: 117 tight late turns, 22.6 min added per turn, $0.27M at stake AVL: 149 tight late turns, 18.3 min added per turn, $0.27M at stake GSP: 198 tight late turns, 12.8 min added per turn, $0.26M at stake ALB: 165 tight late turns, 15.7 min added per turn, $0.26M at stake IAD: 207 tight late turns, 11.9 min added per turn, $0.25M at stake SMF: 540 tight late turns, 4.4 min added per turn, $0.24M at stake JAC: 103 tight late turns, 23.6 min added per turn, $0.24M at stake BZN: 193 tight late turns, 12.2 min added per turn, $0.24M at stake OAK: 386 tight late turns, 5.8 min added per turn, $0.23M at stake MEM: 310 tight late turns, 7.5 min added per turn, $0.23M at stake CVG: 295 tight late turns, 7.8 min added per turn, $0.23M at stake XNA: 201 tight late turns, 9.9 min added per turn, $0.20M at stake ICT: 129 tight late turns, 14.7 min added per turn, $0.19M at stake GRR: 192 tight late turns, 9.7 min added per turn, $0.19M at stake SFO: 1,925 tight late turns, 1.0 min added per turn, $0.18M at stake TUL: 208 tight late turns, 7.9 min added per turn, $0.16M at stake RSW: 230 tight late turns, 5.9 min added per turn, $0.14M at stake FAT: 150 tight late turns, 8.7 min added per turn, $0.13M at stake TVC: 153 tight late turns, 7.0 min added per turn, $0.11M at stake BOI: 165 tight late turns, 6.6 min added per turn, $0.11M at stake RNO: 250 tight late turns, 4.0 min added per turn, $0.10M at stake GEG: 190 tight late turns, 5.4 min added per turn, $0.10M at stake SGF: 123 tight late turns, 7.6 min added per turn, $0.09M at stake ROC: 151 tight late turns, 6.1 min added per turn, $0.09M at stake LIT: 147 tight late turns, 5.8 min added per turn, $0.09M at stake ELP: 226 tight late turns, 4.0 min added per turn, $0.09M at stake GSO: 131 tight late turns, 6.1 min added per turn, $0.08M at stake LGB: 153 tight late turns, 4.5 min added per turn, $0.07M at stake LEX: 153 tight late turns, 4.6 min added per turn, $0.07M at stake TUS: 167 tight late turns, 3.5 min added per turn, $0.06M at stake ASE: 143 tight late turns, 4.2 min added per turn, $0.06M at stake SRQ: 147 tight late turns, 3.2 min added per turn, $0.05M at stake BUR: 358 tight late turns, 1.3 min added per turn, $0.05M at stake SJC: 527 tight late turns, 0.5 min added per turn, $0.03M at stake ONT: 310 tight late turns, 1.0 min added per turn, $0.03M at stake PIE: 136 tight late turns, 1.1 min added per turn, $0.01M at stake OGG: 124 tight late turns, 0.5 min added per turn, $0.01M at stake LIH: 100 tight late turns, -0.7 min added per turn, −$0.01M at stake KOA: 107 tight late turns, -1.5 min added per turn, −$0.02M at stake HNL: 189 tight late turns, -4.2 min added per turn, −$0.08M at stake ATL: 1,577 tight late turns, 20.4 min added per turn, $3.24M at stake ATL DEN

What I’d recommend

Give late-arriving planes more time on the ground, but only where delays snowball, starting with Atlanta.

Blanket buffers would cost flights. The next step would be testing this on more months of data, including winter.

About the dollars: I converted minutes at $100.76 each, Airlines for America’s 2024 average direct cost of aircraft block time (taxi plus airborne). It’s a yardstick, not an exact bill, which is why the $74M is “at stake” rather than lost or saved.

How I did it

Data. The Bureau of Transportation Statistics’ on-time records for July 2026: every domestic flight by the reporting airlines, with tail numbers and delay causes. Real, public data. I loaded it into a SQLite database and kept 38 of the 110 columns.

Questions first, then SQL. I wrote seven queries, each answering one question, from “what causes the most delay minutes?” to “which airports add the most delay on tight turns?” I used window functions (ROW_NUMBER, LAG, COUNT OVER) to put each plane’s flights in order and follow delays from one flight to the next.

Checking the work. Each query had checkpoints: row counts and totals that had to match before I moved on. I checked one plane’s turn times by hand against the query. A few decisions changed the analysis, and I logged each one with what I gave up, for example leaving out about 2,100 late-arrival turns that looked like aircraft swaps.

AI-assisted. I built this with Claude as a guide: it explained the concepts and set up exercises, and I wrote, ran and checked the queries myself. When an autocomplete suggestion quietly changed a filter and inflated the headline number by about two-thirds, the checkpoints caught it.

Visuals. I built the report in Power BI with one accent color and takeaway titles; the PDF above has the original pages. The charts on this page are rebuilt in HTML from the same exported numbers, so they stay sharp and readable on any screen.

Caveats

  • One month, July, at peak travel season. These are July 2026 findings, not a full year.
  • Times are local, and each plane’s flights are ordered by scheduled departure, which can misorder red-eyes. As a check, the previous flight’s destination matched the next flight’s origin 96.9% of the time.
  • The dollar figure is a yardstick: a block-time cost applied to minutes at the gate, from Airlines for America, an industry trade group.
  • The turn-time results show a strong pattern, not proof that more buffer would win back every minute. Congestion, crews and gates matter too.
  • Cancelled flights and aircraft swaps are left out.
View the Power BI dashboard (PDF) ↗ View on GitHub ↗ Next Project →