Loading dataset
Back to data
Updated

27.5 MB across 1 part, newest sealed 15 September 2026 at 05:39 UTC.

The last refresh changed nothing.

UNIQUE_FLIGHT passed.

COMPLETE_DEPARTURES passed.

WEATHER_COVERAGE passed.

ORIGIN_METADATA passed.

flight_date

date

BTS scheduled departure local date.

  • 2023-03-230%
  • 2023-03-090%
  • 2023-03-160%
  • Other (931)
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
943 · 0.1% of valid

carrier

string

Reporting operating carrier code.

  • YX21%
  • UA19%
  • DL15%
  • Other (2)
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
14 · 0% of valid

flight_number

string

Reporting carrier flight number.

  • 3230%
  • 15290%
  • 10320%
  • Other (4,903)
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
4,915 · 0.5% of valid

origin

string

Departure airport IATA code: JFK, EWR or LGA.

  • LGA38%
  • EWR32%
  • JFK30%
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
3 · 0% of valid

destination

string

Domestic destination IATA code.

  • ORD5%
  • BOS4%
  • ATL4%
  • Other (113)
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
125 · 0% of valid

scheduled_departure_hhmm

string

Scheduled departure local clock time, zero padded HHMM.

  • 06003%
  • 07002%
  • 08001%
  • Other (1,079)
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
1,091 · 0.1% of valid

departure_hour

integer

Scheduled local hour.

Histogram: 5 to 7.25, 159,106; 7.25 to 9.5, 148,140; 9.5 to 11.75, 118,911; 11.75 to 14, 110,385; 14 to 16.25, 200,466; 16.25 to 18.5, 131,088; 18.5 to 20.75, 123,977; 20.75 to 23, 64,824
523
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
19 · 0% of valid
Min
5
25%
9
Median
13
75%
17
Max
23

month

integer

Calendar month.

Histogram: 1 to 2.375, 191,590; 2.375 to 3.75, 104,336; 3.75 to 5.125, 205,568; 5.125 to 6.5, 99,859; 6.5 to 7.875, 103,962; 7.875 to 9.25, 142,626; 9.25 to 10.625, 72,732; 10.625 to 12, 136,224
112
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
12 · 0% of valid
Min
1
25%
3
Median
6
75%
9
Max
12

day_of_week

integer

Monday 1 through Sunday 7.

Histogram: 1 to 1.8571428571428572, 158,422; 1.8571428571428572 to 2.7142857142857144, 155,613; 2.7142857142857144 to 3.571428571428571, 155,801; 3.571428571428571 to 4.428571428571429, 157,412; 4.428571428571429 to 5.285714285714286, 156,791; 5.285714285714286 to 6.142857142857142, 123,128; 6.142857142857142 to 7, 149,730
17
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
7 · 0% of valid
Min
1
25%
2
Median
4
75%
6
Max
7

scheduled_elapsed_minutes

decimal

Scheduled flight duration.

  • 190.001%
  • 155.001%
  • 185.001%
  • Other (421)
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
433 · 0% of valid
Min
-5.00
25%
122.00
Median
167.00
75%
225.00
Max
1162.00

distance_miles

decimal

BTS nonstop flight distance.

  • 733.003%
  • 2475.002%
  • 184.002%
  • Other (250)
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
262 · 0% of valid
Min
11.00
25%
500.00
Median
765.00
75%
1372.00
Max
4983.00

departure_delay_minutes

decimal

Observed signed departure delay; negative is early. Outcome, not a predictor.

  • -5.008%
  • -6.007%
  • -4.007%
  • Other (1,175)
Valid
1,031,977 · 97.6%
Missing
24,920 · 2.4%
Distinct
1,187 · 0.1% of valid
Min
-50.00
25%
-6.00
Median
-3.00
75%
9.00
Max
2590.00

arrival_delay_minutes

decimal

Observed signed arrival delay; negative is early. Outcome, not a predictor.

  • -18.002%
  • -15.002%
  • -16.002%
  • Other (1,235)
Valid
1,027,585 · 97.2%
Missing
29,312 · 2.8%
Distinct
1,247 · 0.1% of valid
Min
-97.00
25%
-21.00
Median
-10.00
75%
10.00
Max
2586.00

departure_delayed_15

boolean

Observed departure at least 15 minutes late; outcome.

  • false79%
  • true21%
Valid
1,031,977 · 97.6%
Missing
24,920 · 2.4%
Distinct
2 · 0% of valid

arrival_delayed_15

boolean

Observed arrival at least 15 minutes late; outcome.

  • false78%
  • true22%
Valid
1,027,585 · 97.2%
Missing
29,312 · 2.8%
Distinct
2 · 0% of valid

cancelled

boolean

Observed cancellation; outcome.

  • false97%
  • true3%
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

diverted

boolean

Observed diversion; outcome.

  • false100%
  • true0%
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

scheduled_departure_utc

timestamp_utc

Scheduled departure converted from New York time; DST ambiguous hours left null.

  • 2024-12-20 11:00:00+000%
  • 2024-12-19 11:00:00+000%
  • 2025-02-20 11:00:00+000%
  • Other (383,403)
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
383,415 · 36.3% of valid

feature_cutoff_utc

timestamp_utc

One hour before scheduled departure.

  • 2024-12-20 10:00:00+000%
  • 2024-12-19 10:00:00+000%
  • 2025-02-20 10:00:00+000%
  • Other (383,403)
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
383,415 · 36.3% of valid

origin_name

string

Current airport metadata; not historically versioned.

  • LaGuardia Airport38%
  • Newark Liberty International Airport32%
  • John F. Kennedy International Airport30%
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
3 · 0% of valid

origin_latitude

number

Current airport latitude.

Histogram: 40.639447 to 40.656666, 317,069; 40.656666 to 40.673885, 0; 40.673885 to 40.691103999999996, 335,855; 40.691103999999996 to 40.708323, 0; 40.708323 to 40.725542000000004, 0; 40.725542000000004 to 40.742761, 0; 40.742761 to 40.75998, 0; 40.75998 to 40.777199, 403,973
40.63944740.777199
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
3 · 0% of valid
Min
40.639447
25%
40.639447
Median
40.6894
75%
40.777199
Max
40.777199

origin_longitude

number

Current airport longitude.

Histogram: -74.170545 to -74.12164150000001, 335,855; -74.12164150000001 to -74.072738, 0; -74.072738 to -74.0238345, 0; -74.0238345 to -73.974931, 0; -73.974931 to -73.9260275, 0; -73.9260275 to -73.87712400000001, 0; -73.87712400000001 to -73.8282205, 403,973; -73.8282205 to -73.779317, 317,069
-74.170545-73.779317
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
3 · 0% of valid
Min
-74.170545
25%
-74.170545
Median
-73.872597
75%
-73.779317
Max
-73.779317

destination_name

string

Current destination airport name.

  • Chicago O'Hare International Airport5%
  • Boston Logan International Airport5%
  • Hartsfield Jackson Atlanta International Airport4%
  • Other (108)
Valid
1,014,252 · 96%
Missing
42,645 · 4%
Distinct
120 · 0% of valid

destination_latitude

number

Current destination latitude.

Histogram: 20.896263 to 25.931605625000003, 45,150; 25.931605625000003 to 30.96694825, 177,299; 30.96694825 to 36.002290875, 266,542; 36.002290875 to 41.0376335, 266,546; 41.0376335 to 46.072976125, 245,537; 46.072976125 to 51.10831875, 12,791; 51.10831875 to 56.14366137500001, 0; 56.14366137500001 to 61.179004, 387
20.89626361.179004
Valid
1,014,252 · 96%
Missing
42,645 · 4%
Distinct
120 · 0% of valid
Min
20.896263
25%
32.896159
Median
36.09937
75%
41.337064
Max
61.179004

destination_longitude

number

Current destination longitude.

Histogram: -157.92567 to -146.78829475, 2,691; -146.78829475 to -135.6509195, 0; -135.6509195 to -124.51354425, 0; -124.51354425 to -113.376169, 121,536; -113.376169 to -102.23879375, 49,658; -102.23879375 to -91.1014185, 106,928; -91.1014185 to -79.96404325, 524,832; -79.96404325 to -68.826668, 208,607
-157.92567-68.826668
Valid
1,014,252 · 96%
Missing
42,645 · 4%
Distinct
120 · 0% of valid
Min
-157.92567
25%
-94.713893
Median
-83.353786
75%
-80.152702
Max
-68.826668

weather_station

string

NOAA USAF+WBAN station identifier matched through ICAO codes.

  • 7250301473238%
  • 7250201473432%
  • 7448609478930%
Valid
1,056,897 · 100%
Missing
0 · 0%
Distinct
3 · 0% of valid

weather_observed_utc

timestamp_utc

Latest routine METAR observation at or before feature cutoff, at most 3 hours old. Archive does not establish original publication time.

  • 2023-05-18 16:51:00+000%
  • 2023-05-16 16:51:00+000%
  • 2024-04-01 16:51:00+000%
  • Other (17,974)
Valid
1,056,513 · 100%
Missing
384 · 0%
Distinct
17,986 · 1.7% of valid

weather_age_minutes

decimal

Age of observation relative to feature cutoff.

  • 9.0017%
  • 39.0011%
  • 8.009%
  • Other (139)
Valid
1,056,513 · 100%
Missing
384 · 0%
Distinct
151 · 0% of valid
Min
0.00
25%
9.00
Median
24.00
75%
39.00
Max
179.00

temperature_c

decimal

NOAA temperature; missing and failed quality flags become null.

  • 10.002%
  • 23.302%
  • 22.802%
  • Other (92)
Valid
1,055,610 · 99.9%
Missing
1,287 · 0.1%
Distinct
104 · 0% of valid
Min
-15.00
25%
7.20
Median
14.40
75%
22.80
Max
39.40

dewpoint_c

decimal

NOAA dewpoint; missing and failed quality flags become null.

  • 13.302%
  • 12.802%
  • 14.402%
  • Other (90)
Valid
1,055,512 · 99.9%
Missing
1,385 · 0.1%
Distinct
102 · 0% of valid
Min
-27.20
25%
-1.70
Median
6.70
75%
14.40
Max
25.60

wind_speed_mps

decimal

NOAA wind speed; missing and failed quality flags become null.

  • 4.109%
  • 3.609%
  • 4.609%
  • Other (23)
Valid
1,055,760 · 99.9%
Missing
1,137 · 0.1%
Distinct
35 · 0% of valid
Min
0.00
25%
3.10
Median
4.60
75%
6.20
Max
19.00

visibility_m

integer

NOAA horizontal visibility; missing and failed quality flags become null.

Histogram: 0 to 2011.625, 10,729; 2011.625 to 4023.25, 28,348; 4023.25 to 6034.875, 12,341; 6034.875 to 8046.5, 8,688; 8046.5 to 10058.125, 28,958; 10058.125 to 12069.75, 17,756; 12069.75 to 14081.375, 16,102; 14081.375 to 16093, 926,764
016093
Valid
1,049,686 · 99.3%
Missing
7,211 · 0.7%
Distinct
19 · 0% of valid
Min
0
25%
16093
Median
16093
75%
16093
Max
16093

ceiling_m

integer

NOAA ceiling height; missing and failed quality flags become null.

Histogram: 0 to 2750, 368,024; 2750 to 5500, 97,483; 5500 to 8250, 184,180; 8250 to 11000, 3,083; 11000 to 13750, 0; 13750 to 16500, 0; 16500 to 19250, 0; 19250 to 22000, 400,902
022000
Valid
1,053,672 · 99.7%
Missing
3,225 · 0.3%
Distinct
81 · 0% of valid
Min
0
25%
1524
Median
7620
75%
22000
Max
22000