Airlines Report

The analysis is for different airports from which the airlines depart and arrive. The average delay time of an airline over a period of time and more.

Key Insights:

1.      On-Time Performance:

• 61.67% of flights are on time, which shows a decent overall performance. However, there's room for improvement in punctuality.

2.      Flight Delays:

•  35.99% of flights experience delays, with an average delay time of 26.92 minutes. This is a significant figure that could impact customer satisfaction

3.      Flight Cancellations:

• 2.43% of flights are cancelled, a relatively small percentage, but cancellations still disrupt operations and passenger plans

4.  Day of the Week Patterns:

• The bar chart reveals varying performance based on the day of the week. Some days may have higher on-time rates or delays, which can help identify operational bottlenecks.

5.  Airline-Specific Delays:

•   Different airlines exhibit varied delay times over the years, highlighting the need for targeted interventions for underperforming carriers.

6.  Flight Patterns by Departure Hour:

• The bar chart reveals that the majority of flights depart at 12:00 AM (306K flights). This starkly overshadows other time slots, with significantly fewer flights during hours like 4:00 PM (31K) or 8:00 PM (26K).

• The least popular departure time is 1:06 AM with only 2K flights

7.  Origin Airport Distribution:

•  Among the three origin airports:

o   BWI (43.45%) handles the largest share of flights

o   DCA (31.42%) comes next, while IAD (25.13%) manages the smallest proportion.

Observations:

• On-time performance could be improved by optimizing scheduling and addressing common delay factors such as weather or maintenance.

• Airlines with higher average delay times might need tailored strategies to improve efficiency

•  Identifying trends in day-specific performance can help airlines allocate resources more effectively on busier or delay-prone days

• Peak Hour Utilization: The heavy concentration of departures at 12:00 AM suggests potential inefficiencies or scheduling preferences. Investigating pass

•  Weekend Scheduling: The lower flight percentages on Saturdays might indicate untapped demand. Exploring promotional campaigns or adjusted schedules could boost weekend traffic

• Origin Airport Dynamics: With BWI handling the majority, it might face capacity challenges. Redistributing flights across DCA and IAD could balance the load