Geeking Out with Airline On-Time Data

The Bureau of Transportation Statistics has now released on-time data for all months in 2023, which means I get to play data geek, specifically with an eye toward positioning flights and how much time to build in to connections to have a great chance of everything working out, at least as long as this year is like data from 2023.

Marketing Carrier Arrival Stats

First, let’s look look at the 90th and 95th percentile for arrival delays by marketing carrier (or, in other words, how many minutes past scheduled arrival captures 90% or 95% of all carrier arrivals)? Note that this includes regional jets operated by partner airlines like SkyWest, Endeavor, and United Express.

I’m most surprised by JetBlue here, given that to have a 95% chance of arriving in time for your connection, you need to pad your connection time by nearly 2 hours and 20 minutes. On the other hand, I wrote this on a JetBlue flight that was delayed by about 3 ½ hours, so I guess confirmed? Well played JetBlue.

Operating Carrier Arrival Stats

Now, let’s look at the same thing for major airlines flying mainline aircraft, excluding any regional jets, since often we’re able to avoid regional jets for positioning flights or connections and historically they don’t perform as well:

Note that AA’s operation has worse (!) performance when its regional partner airlines are excluded from the statistics and we only consider mainline flights. I had to go triple check this data because wow, that sucks AA.

What about data for the regionals only, when they’re operating on behalf of one of the majors?

My mental model for regional jet carriers is usually: avoid GoJet and Mesa, SkyWest is most likely to get you there. The data proves that’s only somewhat correct for 2023 though.

Major Hub Arrival Statistics

Ok, but what about a given hub? We all know that some function better than others, so let’s look at arrival delays at the top 15 airports by total number of commercial flights, plus one bonus airport.

So I guess avoid positioning flights to Orlando, Boston, or JFK if you can help it.

Also for fun, these are the worst airports for delays:

So, don’t expect to fly to Provo, UT in any timely fashion. Maybe the late arrivals explain why Provo, part of what’s affectionally called “Happy Valley”, is the number one spot in the nation for anti-depressant prescriptions per capita.

By Season

We can dissect this data in a million different ways, but we know winter storms make things worse and summer thunderstorms don’t help either. So let’s look at when you’re most likely to be delayed, by month.

So, build extra time in for positioning flights in June and July.

What about breaking this down by day of the week?

The takeaway here is probably that the day of week doesn’t matter much, unless it’s Tuesday.

Conclusion

If you’re interested in seeing the raw CSV data (which ended up in an SQL database), let me know, I’m happy to share. Otherwise, good luck on those award flights!

MEAB today, prolly.