{"id":9412,"date":"2024-03-27T04:00:00","date_gmt":"2024-03-27T10:00:00","guid":{"rendered":"https:\/\/milesearnandburn.com\/?p=9412"},"modified":"2024-03-26T20:57:41","modified_gmt":"2024-03-27T02:57:41","slug":"geeking-out-with-airline-on-time-data","status":"publish","type":"post","link":"https:\/\/milesearnandburn.com\/index.php\/2024\/03\/27\/geeking-out-with-airline-on-time-data\/","title":{"rendered":"Geeking Out with Airline On-Time Data"},"content":{"rendered":"\n

The Bureau of Transportation Statistics has now released on-time data for all months in 2023,<\/a> 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.<\/p>\n\n\n\n

Marketing Carrier Arrival Stats<\/h4>\n\n\n\n

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.<\/p>\n\n\n\n

Marketing Carrier<\/th>90th Percentile Arrival Delay
(minutes)<\/th>		95th Percentile Arrival Delay
(minutes)<\/th><\/tr><\/thead>
American Airlines<\/td>51<\/td>83<\/td><\/tr>
Alaska Airlines<\/td>31<\/td>53<\/td><\/tr>
JetBlue<\/td>83<\/td>138<\/td><\/tr>
Delta<\/td>31<\/td>63<\/td><\/tr>
Frontier<\/td>73<\/td>120<\/td><\/tr>
Hawaiian<\/td>34<\/td>54<\/td><\/tr>
Spirit<\/td>66<\/td>113<\/td><\/tr>
United<\/td>43<\/td>85<\/td><\/tr>
Southwest<\/td>36<\/td>62<\/td><\/tr><\/tbody><\/table>
2023 Arrival statistics by marketing carrier.<\/figcaption><\/figure>\n\n\n\n

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 \u00bd hours, so I guess confirmed? Well played JetBlue.<\/p>\n\n\n\n

Operating Carrier Arrival Stats<\/h4>\n\n\n\n

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:<\/p>\n\n\n\n

Marketing Carrier<\/th>90th Percentile Arrival Delay
(minutes)<\/th>		95th Percentile Arrival Delay
(minutes)<\/th><\/tr><\/thead>
AA<\/td>51<\/td>97<\/td><\/tr>
Alaska<\/td>31<\/td>55<\/td><\/tr>
JetBlue<\/td>83<\/td>138<\/td><\/tr>
Delta<\/td>31<\/td>66<\/td><\/tr>
Frontier<\/td>73<\/td>120<\/td><\/tr>
Hawaiian<\/td>34<\/td>54<\/td><\/tr>
Spirit<\/td>66<\/td>113<\/td><\/tr>
United<\/td>43<\/td>85<\/td><\/tr>
Southwest<\/td>36<\/td>62<\/td><\/tr><\/tbody><\/table>
2023 Arrival statistics by operating carrier, major airlines.<\/figcaption><\/figure>\n\n\n\n

Note that AA’s operation has worse<\/strong> (!) 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.<\/p>\n\n\n\n

What about data for the regionals only, when they’re operating on behalf of one of the majors?<\/p>\n\n\n\n

Marketing Carrier<\/th>90th Percentile Arrival Delay
(minutes)<\/th>		95th Percentile Arrival Delay
(minutes)<\/th><\/tr><\/thead>
Endeavor<\/td>27<\/td>63<\/td><\/tr>
CommuteAir<\/td>36<\/td>82<\/td><\/tr>
GoJet<\/td>40<\/td>80<\/td><\/tr>
Envoy<\/td>32<\/td>62<\/td><\/tr>
PSA<\/td>32<\/td>70<\/td><\/tr>
SkyWest<\/td>32<\/td>70<\/td><\/tr>
Piedmont<\/td>25<\/td>62<\/td><\/tr>
Horizon<\/td>22<\/td>45<\/td><\/tr>
Mesa<\/td>68<\/td>129<\/td><\/tr>
Republic<\/td>23<\/td>53<\/td><\/tr>
Air Wisconsin<\/td>61<\/td>114<\/td><\/tr><\/tbody><\/table>
2023 Arrival statistics by operating carrier, regional airlines operating for another carrier.<\/figcaption><\/figure>\n\n\n\n

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.<\/p>\n\n\n\n

Major Hub Arrival Statistics<\/h4>\n\n\n\n

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.<\/p>\n\n\n\n

Airport<\/th>90th Percentile Arrival Delay
(minutes)<\/th>		95th Percentile Arrival Delay
(minutes)<\/th><\/tr><\/thead>
ATL<\/td>33<\/td>71<\/td><\/tr>
DEN<\/td>44<\/td>86<\/td><\/tr>
ORD<\/td>41<\/td>86<\/td><\/tr>
DFW<\/td>46<\/td>94<\/td><\/tr>
CLT<\/td>38<\/td>83<\/td><\/tr>
LAX<\/td>39<\/td>74<\/td><\/tr>
LAS<\/td>50<\/td>85<\/td><\/tr>
SEA<\/td>27<\/td>53<\/td><\/tr>
PHX<\/td>37<\/td>70<\/td><\/tr>
LGA<\/td>43<\/td>85<\/td><\/tr>
MCO<\/td>63<\/td>109<\/td><\/tr>
IAH<\/td>44<\/td>92<\/td><\/tr>
EWR<\/td>48<\/td>93<\/td><\/tr>
DCA<\/td>36<\/td>73<\/td><\/tr>
BOS<\/td>56<\/td>102<\/td><\/tr>
SFO<\/td>47<\/td>84<\/td><\/tr>
JFK<\/td>56<\/td>107<\/td><\/tr>
LBB<\/td>44<\/td>81<\/td><\/tr><\/tbody><\/table>
2023 Arrival statistics by airport, ordered by total number of air carrier flights in 2023.<\/figcaption><\/figure>\n\n\n\n

So I guess avoid positioning flights to Orlando, Boston, or JFK if you can help it.<\/p>\n\n\n\n

Also for fun, these are the worst airports for delays:<\/p>\n\n\n\n

Airport<\/th>90th Percentile Arrival Delay
(minutes)<\/th>		95th Percentile Arrival Delay
(minutes)<\/th><\/tr><\/thead>
PVU<\/td>87<\/td>160<\/td><\/tr>
PSE<\/td>93<\/td>152<\/td><\/tr>
BQN<\/td>86<\/td>137<\/td><\/tr>
SFB<\/td>73<\/td>130<\/td><\/tr>
TTN<\/td>83<\/td>129<\/td><\/tr><\/tbody><\/table>
2023 Arrival statistics by airport, ordered by biggest 95th percentile arrival delays.<\/figcaption><\/figure>\n\n\n\n

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<\/a>.<\/p>\n\n\n\n

By Season<\/h4>\n\n\n\n

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.<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

So, build extra time in for positioning flights in June and July.<\/p>\n\n\n\n

What about breaking this down by day of the week?<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

The takeaway here is probably that the day of week doesn’t matter much, unless it’s Tuesday.<\/p>\n\n\n\n

Conclusion<\/h4>\n\n\n\n

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!<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

MEAB today, prolly.<\/p>\n","protected":false},"excerpt":{"rendered":"

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<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_editorskit_title_hidden":false,"_editorskit_reading_time":0,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","footnotes":""},"categories":[60,25],"tags":[],"class_list":["post-9412","post","type-post","status-publish","format-standard","hentry","category-airlines","category-travel-hacking"],"_links":{"self":[{"href":"https:\/\/milesearnandburn.com\/index.php\/wp-json\/wp\/v2\/posts\/9412","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/milesearnandburn.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/milesearnandburn.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/milesearnandburn.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/milesearnandburn.com\/index.php\/wp-json\/wp\/v2\/comments?post=9412"}],"version-history":[{"count":10,"href":"https:\/\/milesearnandburn.com\/index.php\/wp-json\/wp\/v2\/posts\/9412\/revisions"}],"predecessor-version":[{"id":9438,"href":"https:\/\/milesearnandburn.com\/index.php\/wp-json\/wp\/v2\/posts\/9412\/revisions\/9438"}],"wp:attachment":[{"href":"https:\/\/milesearnandburn.com\/index.php\/wp-json\/wp\/v2\/media?parent=9412"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/milesearnandburn.com\/index.php\/wp-json\/wp\/v2\/categories?post=9412"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/milesearnandburn.com\/index.php\/wp-json\/wp\/v2\/tags?post=9412"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}