I offer you a complete dataset of US civil aviation 2023 containing :

• departure and arrival delays for each flight
• descriptions and delay times
• weather with rain, snow, pressure, temperature min/max/avg, wind speed and direction for each airport
• associated airlines
• information for each plane with manufacturer, model and age.

The information on flights comes from the BTS (Bureau of Transportation Statistics) website and I used the Meteostat Python library to scrape the information. I also developed a correspondence table for the airports, their identifiers and geolocation coordinates.

TABLES AND JUNCTIONS DESCRIPTION

US_flights_2023.csv

Main table containing all flight information except weather. Cancelled or diverted flights have been extracted in a dedicated table to avoid biasing delay statistics and analysis.

weather_meteo_by_airport.csv

Table containing weather data (temperatures, air pressure, snow cover, precipitation, wind strength and direction) for each airport and day of the year. This table can be joined to the main table, using either the departure or arrival airport ID, or both, to study in-flight variations.

Cancelled_Diverted_2023.csv

Table des annulations et vols déviés pour une analyse dédiée. Il est possible de créer une jointure avec la table météo pour identifier les causes probables.

Here's my dashboard associated with the analysis of civil aviation delays in the United States in 2023. You'll find some interesting indicators and an observation on the various correlations between delays. This dashboard was designed on a student version of Power Bi, with pre-processing in Python and Pandas. Thanks for your feedback.

CIVIL AVIATION US CONTEXT

COMPAGNIES DELAYS

LOCALIZING DELAYS

ANALYSIS OF CORRELATIONS

CAPACITY TO ABSORB DEPARTURE DELAYS

Thank you for your feedback