3 In-depth Views of Flight Delays and Cancellations

Have you ever rushed to the airport only to find that your flight was delayed or canceled?

In the most recent Data Expo at the annual Joint Statistical Meetings, data heads explored 120 million departures and arrivals in the United States, with the goal of finding “important features” such as:

  • When is the best time of day/day of week/time of year to fly to minimise delays?
  • Do older planes suffer more delays?
  • How does the number of people flying between different locations change over time?
  • How well does weather predict plane delays?

While there were several interesting entries, here are the first, second, and third place winners.

First Place. Congestion in the Sky by Rick Wicklin and Robert Allison


This was a comprehensive view of flight delays, but here’s the part I found most interesting. This is a view of flight cancellations. The more red a rectangle is, the higher the percentage of cancellations:


So following 9/11 there were actually fewer cancellations (and delays). My best bet is that this was because there were so few people flying after that event. Conversely, the longest delays occur during the summer and winter holidays.

Second Place. Delayed, Cancelled, On-Time, Boarding … Flying in the USA

This poster is from the Iowa State crew – one of my favorite stat groups – led by Heike Hofmann and Di Cook.


Here are delays over time by carrier. Delays are increasing for small carriers except for Aloha, and Delta and US Airways are improving, surprisingly I might add.


And here’s where all the carriers fly. Can you guess the carrier that each map belongs to without looking at the key above?


Third Place. A Tale of Two Airports by Charlotte Wickham

Instead of looking at it all, Charlotte explored flight traffic at Oakland International and San Francisco International.


Here are the flights per week from SFO (top) and OAK (bottom):


What’s with the jump for OAK in 1994? Southwest started flying outta there and now makes up the majority of outgoing Oakland flights.

Want to see more?

Visit the data expo page to see the above posters and all other entries in their full PDF glory. Very interesting work all around.



The Best Data Visualization Projects of 2014

It’s always tough to pick my favorite visualization projects. Nevertheless, I gave it a go.

Interactive: When Do Americans Leave For Work?

We don’t all start our work days at the same time, despite what morning rush hour might have you think.

Reviving the Statistical Atlas of the United States with New Data

Due to budget cuts, there is no plan for an updated atlas. So I recreated the original 1870 Atlas using today’s publicly available data.

Real Chart Rules to Follow

There are rules—usually for specific chart types meant to be read in a specific way—that you shouldn’t break. When they are, everyone loses. This is that small handful.