Dataset: Flight Delay From January 2017 - July 2022

About this Dataset

Flight Delay From January 2017 - July 2022

This is flights delay data in the U.S. For more information about the data, go to URL below.

source = https://www.transtats.bts.gov/OT_Delay/OT_DelayCause1.asp

year
Year data collected

month
Numeric representation of the month

carrier
Carrier.

carrier_name
Carrier Name.

airport
Airport code.

airport_name
Name of airport.

arr_flights
Number of flights arriving at airport

arr_del15
Number of flights more than 15 minutes late

carrier_ct
Number of flights delayed due to air carrier. (e.g. no crew)

weather_ct
Number of flights due to weather.

nas_ct
Number of flights delayed due to National Aviation System (e.g. heavy air traffic).

security_ct
Number of flights canceled due to a security breach.

late_aircraft_ct
Number of flights delayed as a result of another flight on the same aircraft delayed

arr_cancelled
Number of cancelled flights

arr_diverted
Number of flights that were diverted

arr_delay
Total time (minutes) of delayed flight.

carrier_delay
Total time (minutes) of delay due to air carrier

weather_delay
Total time (minutes) of delay due to inclement weather.

nas_delay
Total time (minutes) of delay due to National Aviation System.

security_delay
Total time (minutes) of delay as a result of a security issue .

late_aircraft_delay
Total time (minutes) of delay flights as a result of a previous flight on the same airplane being late.

Tables

Airline Delay Cause

@kaggle.jawadkhattak_us_flight_delay_from_january_2017_july_2022.airline_delay_cause

2.43 MB
101315 rows
21 columns


CREATE TABLE airline_delay_cause (
  "year" BIGINT,
  "month" BIGINT,
  "carrier" VARCHAR,
  "carrier_name" VARCHAR,
  "airport" VARCHAR,
  "airport_name" VARCHAR,
  "arr_flights" DOUBLE,
  "arr_del15" DOUBLE,
  "carrier_ct" DOUBLE,
  "weather_ct" DOUBLE,
  "nas_ct" DOUBLE,
  "security_ct" DOUBLE,
  "late_aircraft_ct" DOUBLE,
  "arr_cancelled" DOUBLE,
  "arr_diverted" DOUBLE,
  "arr_delay" DOUBLE,
  "carrier_delay" DOUBLE,
  "weather_delay" DOUBLE,
  "nas_delay" DOUBLE,
  "security_delay" DOUBLE,
  "late_aircraft_delay" DOUBLE
);