Interesting Findings


Trends - Correlations

  • If a flight arrives after 1am at Midway, it is delayed
  • If the number of cancelled flights is higher than average, the number of delayed flights is also higher than average
  • For both O’Hare and Midway, the least number of flights are on Saturday
  • California has the maximum number of flights to and from Illinois
  • Least favourite time of the month for travel is february.
  • Number of arrivals and departures take a dip on the day before christmas
  • Number of arrivals and departures take a dip on the day before Thanksgiving day.
  • Spring Break Month the Orlando Airport has more arrivals and departures than any other month.
  • People prefer travelling in summer.

Insights - Causations

  • On 3/14/2017, there was a heavy snowfall that caused the most number of cancellations
  • On December 4, a lot of delays happened at Chicago Airports due to high winds.
  • There’s is an increase in the number of flights between O’hare and San Diego International Airport in March, possibly due the introduction of a new flight
  • Hurricane Harvey in Texas had similar effect on 25th August’s week with half the flights to Houston cancelled.
  • September 2nd week due to hurricane Irma almost all flights were cancelled to florida.
  • Air Travel was largely unaffected by the LA fires.
  • Number of flights were low so there was not a significant effect dues to flooding in Arkansas and Oklahoma

10 Interesting Days

Interesting Days Description
February 9 Major snow storm hit the northeastern parts of USA. All flights to and from the area were cancelled
March 14 Maximum number of flights cancelled at O'Hare Internation Airport due to heavy snowfall
July 19 Busiest day for Midway airport with 546 flights in and out of the airport
August 15 Busiest day for O'Hare International airport with 1733 flights in and out of the airport
August 28 Effect of Hurricane Harvey. All flights to and from Houston cancelled
September 10 Effect of Hurricane Irma. All flights to and from airports in FLorida cancelled
September 21 Hottest day recorded in 47 years for Chicago with temperature 94 F (34.5 C)
November 23 - Thanksgiving Day Minimum number of flights in and out of both O'hare and Midway airports
Christmas Eve Less than averege number of flights
December 31 Coldest day of the year for Chicago with temperature 94 F (34.5 C)