Delay: Flights are rarely diverted to other destinations, but when it happens, diversion tends to cause longer delay hour. Flights between 0:00 to 6:00AM tend to perform worse than day time flights. Flights on Monday or weekend have higher risk of being delayed than other days of the week. Besides, several large airports such as LAX and SFO tend to have longer delay time than other large airports and UA performs worse in Delay Analysis than the other two airlines.
Oversell and Denied Boarding: Delta Airline has a higher percentage of people denied boarding (voluntarily) than the other two airlines, but it has a lower ratio of involuntarily denied boarding.
Customer Review: Among three selected airlines, Delta airline seems to have the best customer review regarding flight experiences. Economy class tends to give more negative feedbacks than other classes.
a. Match review with flight-related or airport-related data
b. Regression and topic models to find the reason behind
c. Apply our analysis to longer period data
d. Add in price/revenue variables