{"id":5252,"date":"2022-09-06T04:00:00","date_gmt":"2022-09-06T10:00:00","guid":{"rendered":"https:\/\/milesearnandburn.com\/?p=5252"},"modified":"2023-04-18T11:25:52","modified_gmt":"2023-04-18T17:25:52","slug":"gaming-alternate-flights-in-the-face-of-delays","status":"publish","type":"post","link":"https:\/\/milesearnandburn.com\/index.php\/2022\/09\/06\/gaming-alternate-flights-in-the-face-of-delays\/","title":{"rendered":"Gaming Alternate Flights in the Face of Delays"},"content":{"rendered":"<p><em>Editors note: Sometimes I can\u2019t help but get academic and nerdy; but stick with me, the results are good. <\/em><em>There\u2019s good stuff in the academic community, and we can apply it directly to your travel to make it better. I don\u2019t know of anyone else doing anything like this, so here we are.<\/em><\/p>\n<h4>Introduction<\/h4>\n<p>There\u2019s an interesting statistics thought experiment that comes up in academia called <a class=\"ek-link\" href=\"https:\/\/betterexplained.com\/articles\/understanding-the-monty-hall-problem\/\">The Monty Hall problem<\/a>. The gist of the problem is:<\/p>\n<ul>\n<li>You have three doors with something behind each door, 2 doors have something lame and 1 has something great<\/li>\n<li>You choose a door but don\u2019t yet know the results<\/li>\n<li>The game-master tells you that one of the doors you didn\u2019t pick has a lame prize, and shows you which door<\/li>\n<\/ul>\n<p>Ok, so there are two doors left: The one you picked and the other door. Unless you\u2019re trained in statistics, you probably think you\u2019ve got a 50% chance that your door has the great prize and a 50% chance that the other door has the great prize, because there are only two left. But, the math behind the Monty Hall problem says that your door is 33% likely at that point to have the great prize, and 67% likely to have the lame prize. (<a class=\"ek-link\" href=\"https:\/\/en.wikipedia.org\/wiki\/Monty_Hall_problem\">See the Wikipedia page for the math behind the result<\/a> if you\u2019re interested.) In other words, the other choice is now twice as likely to be the best choice, so choose it if you can!<\/p>\n<h4>Applying This Result to Flights<\/h4>\n<p>We can apply this result to airline delays with some fuzzy mapping: one door is your on-time departure (your original choice, a delayed flight might be un-delayed and is thus still an option), one door is your delayed departure, and the third door is a an alternate flight. <\/p>\n<p>Based on the math behind the Monty Hall problem, if you\u2019re told that your original flight is delayed, then switching to an alternate flight is more likely to get you to your destination without a late arrival; twice as likely all things being equal (which they\u2019re not). If you\u2019ve ever experienced rolling delays on your original flight, you\u2019ve got some intuitive feel that switching to another flight is probably less likely to lead to an arrival delay too.<\/p>\n<h4>Making it Real<\/h4>\n<p>There\u2019s a problem with that analysis though: It\u2019s highly unlikely that you\u2019ve got an alternative flight to switch to that leaves at the same time as your original flight. So, to make this actionable for real-world scenarios, we\u2019ve got to factor average delay time into our analysis. To do that, I downloaded <a class=\"ek-link\" href=\"https:\/\/www.transtats.bts.gov\/DL_SelectFields.aspx?gnoyr_VQ=FGK&amp;QO_fu146_anzr=b0-gvzr\">the last 12 months worth US airline flight on-time data<\/a> for a deeper-drive. <\/p>\n<p>First, let\u2019s assume that your airline posts a delay of 45 minutes or longer. In the last year, this is what each major carrier\u2019s average arrival delay looked like:<\/p>\n<figure class=\"wp-block-table\">\n<table>\n<thead>\n<tr>\n<th>Operating<br \/>Airline<\/th>\n<th>Average Arrival Delay, August 2021-July 2022<br \/>(For Departure Delay \u2265 45 Minutes)<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>AA<\/td>\n<td>2 hours 13 minutes<\/td>\n<\/tr>\n<tr>\n<td>Alaska<\/td>\n<td>1 hour 36 minutes<\/td>\n<\/tr>\n<tr>\n<td>Delta<\/td>\n<td>2 hours 1 minute<\/td>\n<\/tr>\n<tr>\n<td>Frontier<\/td>\n<td>1 hour 51 minutes<\/td>\n<\/tr>\n<tr>\n<td>JetBlue<\/td>\n<td>2 hours 17 minutes<\/td>\n<\/tr>\n<tr>\n<td>Spirit<\/td>\n<td>1 hour 49 minutes<\/td>\n<\/tr>\n<tr>\n<td>SkyWest<\/td>\n<td>2 hours 21 minutes<\/td>\n<\/tr>\n<tr>\n<td>Southwest<\/td>\n<td>1 hour 23 minutes<\/td>\n<\/tr>\n<tr>\n<td>United<\/td>\n<td>1 hour 53 minutes<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<p>So when your airline posts a delay of at least 45 minutes, if you\u2019ve got an alternate flight that leaves within an hour and a half or so, you should switch to that alternate flight (especially if your flight is operated by SkyWest).<\/p>\n<p>Next, let\u2019s assume your airline posts a delay of 90 minutes. In the last year, you\u2019re looking at an average arrival delay of:<\/p>\n<figure class=\"wp-block-table\">\n<table>\n<thead>\n<tr>\n<th>Operating<br \/>Airline<\/th>\n<th>Average Arrival Delay, August 2021-July 2022<br \/>(For Departure Delay \u2265 90 Minutes)<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>AA<\/td>\n<td>3 hours 23 minutes<\/td>\n<\/tr>\n<tr>\n<td>Alaska<\/td>\n<td>2 hours 35 minutes<\/td>\n<\/tr>\n<tr>\n<td>Delta<\/td>\n<td>3 hours 19 minute<\/td>\n<\/tr>\n<tr>\n<td>JetBlue<\/td>\n<td>2 hours 54 minutes<\/td>\n<\/tr>\n<tr>\n<td>Frontier<\/td>\n<td>2 hours 54 minutes<\/td>\n<\/tr>\n<tr>\n<td>Spirit<\/td>\n<td>2 hours 49 minutes<\/td>\n<\/tr>\n<tr>\n<td>SkyWest<\/td>\n<td>3 hours 36 minutes<\/td>\n<\/tr>\n<tr>\n<td>Southwest<\/td>\n<td>2 hours 19 minutes<\/td>\n<\/tr>\n<tr>\n<td>United<\/td>\n<td>2 hours 59 minutes<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<p>The conclusion from this one: If your departure delay is posted as 90 minutes or later, switch to an alternative if you can get one in the next three hours or so.<\/p>\n<p>Finally, let\u2019s look at the data by major airports instead of by airline, sorted by the total number of delayed flights (these major airports are also the airports most likely have alternative flights):<\/p>\n<figure class=\"wp-block-table\">\n<table>\n<thead>\n<tr>\n<th>Airport<\/th>\n<th>Average Arrival Delay, August 2021-July 2022<br \/>(For Departure Delay \u2265 90 Minutes)<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>DEN<\/td>\n<td>1 hour 42 minutes<\/td>\n<\/tr>\n<tr>\n<td>ORD<\/td>\n<td>1 hour 52 minutes<\/td>\n<\/tr>\n<tr>\n<td>DFW<\/td>\n<td>1 hour 49 minutes<\/td>\n<\/tr>\n<tr>\n<td>ATL<\/td>\n<td>1 hour 43 minutes<\/td>\n<\/tr>\n<tr>\n<td>MCO<\/td>\n<td>1 hour 50 minutes<\/td>\n<\/tr>\n<tr>\n<td>CLT<\/td>\n<td>1 hour 42 minutes<\/td>\n<\/tr>\n<tr>\n<td>LAS<\/td>\n<td>1 hour 37 minutes<\/td>\n<\/tr>\n<tr>\n<td>LAX<\/td>\n<td>1 hour 50 minutes<\/td>\n<\/tr>\n<tr>\n<td>PHX<\/td>\n<td>1 hour 40 minutes<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n<p>The statistics aren\u2019t very different for other major (top 50) US airports. However delays are much more likely to extend beyond two hours at small airports, where you likely don\u2019t have another option anyway.<\/p>\n<p>And for my last analysis, I looked at the reason for the delay when it was available. In cases where the data is available, the longest delays are caused by (from the biggest contributor to the smallest):<\/p>\n<ol>\n<li>Carrier delays (crew problems, mechanical, etc.)<\/li>\n<li>Late aircraft delays (delayed inbound flight)<\/li>\n<li>Airspace delays (ATC traffic management programs, etc.)<\/li>\n<li>Weather delays<\/li>\n<\/ol>\n<h4>tl;dr<\/h4>\n<p><em>The internet: <\/em>\u201cOk poindexter, enough with the nerdy stuff, how about a summary without all the goo?\u201d<\/p>\n<p><em>MEAB:<\/em> Sure thing boss, also <a class=\"ek-link\" href=\"https:\/\/milesearnandburn.com\/wp-content\/uploads\/2022\/09\/delays-meab-august2021-july2022.zip\">here\u2019s the data in CSV form<\/a> in case you want to be a nerd too:<\/p>\n<ul>\n<li>If your flight posts a delay of 45 minutes or longer, switch to an alternate if there\u2019s one available in the next two hours<\/li>\n<li>If your flight posts a delay of 90 minutes or longer, switch to an alternate if there\u2019s one available in the next two and a half hours<\/li>\n<li>If you\u2019re flying out of a major airport, a delay isn\u2019t likely to carry on past two hours<\/li>\n<li>If you\u2019re flying out of a small airport, that delay is probably going to be a long one, sorry<\/li>\n<li>If the reason for your delay is a carrier or late inbound aircraft issue, the delay is likely to be longer than for weather or other reasons<\/li>\n<\/ul>\n<p>Happy Tuesday friends!<\/p>\n<div class=\"wp-block-image is-style-editorskit-rounded\">\n<figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" alt=\"\" class=\"wp-image-5259\" sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"https:\/\/milesearnandburn.com\/wp-content\/uploads\/2022\/09\/United-Airlines-1520-flat-tire-Denver-Orlando.jpg-1024x768.webp\" srcset=\"https:\/\/milesearnandburn.com\/wp-content\/uploads\/2022\/09\/United-Airlines-1520-flat-tire-Denver-Orlando.jpg-1024x768.webp 1024w, https:\/\/milesearnandburn.com\/wp-content\/uploads\/2022\/09\/United-Airlines-1520-flat-tire-Denver-Orlando.jpg-300x225.webp 300w, https:\/\/milesearnandburn.com\/wp-content\/uploads\/2022\/09\/United-Airlines-1520-flat-tire-Denver-Orlando.jpg-768x576.webp 768w, https:\/\/milesearnandburn.com\/wp-content\/uploads\/2022\/09\/United-Airlines-1520-flat-tire-Denver-Orlando.jpg-800x600.webp 800w, https:\/\/milesearnandburn.com\/wp-content\/uploads\/2022\/09\/United-Airlines-1520-flat-tire-Denver-Orlando.jpg.webp 1280w\" width=\"420\"\/><\/figure>\n<\/div>\n<p class=\"has-text-align-center\" style=\"font-size:14px\">When United Express inevitably has a delay for something like this, switch flights (trust me, been there).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Editors note: Sometimes I can\u2019t help but get academic and nerdy; but stick with me, the results are good. There\u2019s good stuff in the academic<\/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":4,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","footnotes":""},"categories":[60,74,56],"tags":[],"class_list":["post-5252","post","type-post","status-publish","format-standard","hentry","category-airlines","category-avgeek","category-wisdom"],"_links":{"self":[{"href":"https:\/\/milesearnandburn.com\/index.php\/wp-json\/wp\/v2\/posts\/5252","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=5252"}],"version-history":[{"count":23,"href":"https:\/\/milesearnandburn.com\/index.php\/wp-json\/wp\/v2\/posts\/5252\/revisions"}],"predecessor-version":[{"id":6952,"href":"https:\/\/milesearnandburn.com\/index.php\/wp-json\/wp\/v2\/posts\/5252\/revisions\/6952"}],"wp:attachment":[{"href":"https:\/\/milesearnandburn.com\/index.php\/wp-json\/wp\/v2\/media?parent=5252"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/milesearnandburn.com\/index.php\/wp-json\/wp\/v2\/categories?post=5252"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/milesearnandburn.com\/index.php\/wp-json\/wp\/v2\/tags?post=5252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}