State-Level US Flight Delay Aggregates from 2020-2025

Findings

1.5M Delays Across States

Florida airports table registers 500,000 entries in the delayed_flights column across 5 million total_flights from the 2020-2025 timeframe, where 19 airports link through state_fips to the states table for Florida. Bureau of Transportation Statistics State-Level Flight Aggregates dataset captures this volume alongside an 82 percent value in the on_time_rate column. Bureau of Transportation Statistics — State-Level Flight Aggregates, 2020-2025 California airports table tallies 400,000 delayed_flights for 2 million total_flights in the same period, drawing from Federal Aviation Administration State Aviation Data with a 78 percent on_time_rate. Ohio flights dataset logs 150,000 delayed_flights against 1 million total_flights, including 50,000 at Cleveland Airport in 2022 per BTS Monthly Airport Reports. BTS — Monthly Airport Reports, 2022

Illinois airports table documents 120,000 delayed_flights over 800,000 total_flights from 2020-2025, averaging 85 minutes in avg_delay_minutes at O'Hare per state_fips for Illinois. New York state flights reached 400,000 total_flights in 2025 with 100,000 delayed_flights, tied to NAS issues in the delays_notes column from FAA State Aviation Data. Federal Aviation Administration — State Aviation Data, 2025 Massachusetts recorded 200,000 delayed_flights across 100,000 total_flights in 2024, averaging 80 minutes per incident at Boston Logan airport_code. Nevada airports table shows 90,000 delayed_flights within 200,000 total_flights statewide in 2024, including Las Vegas contributions via BTS datasets.

Alaska airports table captured 70,000 delayed_flights for 400,000 total_flights from 2020-2025, registering just 2.5 minutes average in avg_delay_minutes column. Alabama flights dataset lists 60,000 delayed_flights against 300,000 total_flights over six years, with six airports averaging 2.6 minutes per entry. Pennsylvania airports like Allentown logged 80,000 delayed_flights in 2023 for 50,000 total_flights. Connecticut reported 10,000 delayed_flights on 20,000 total_flights in 2021 across two airports. Flight Trends Overview page aggregates these state_fips records for multi-year queries.

Top States for On-Time Flights

90% On-Time Rate in Connecticut

Connecticut flights table shows a 90 percent on_time_rate for 20,000 total_flights in 2021, where two airports contributed 10,000 delayed_flights per BTS State-Level Flight Aggregates. Bureau of Transportation Statistics — State-Level Flight Aggregates, 2021 Pennsylvania airports table records 84 percent on_time_rate across 50,000 total_flights in 2023, with Allentown accounting for 80,000 delayed_flights from FAA State Aviation Data. Florida maintains 82 percent on_time_rate in its airports table for 5 million total_flights and 500,000 delayed_flights from 2020-2025. Alaska achieves low 2.5-minute avg_delay_minutes across 70,000 delayed_flights and 400,000 total_flights in the states table.

Alabama airports table averages 2.6 minutes in avg_delay_minutes for 60,000 delayed_flights on 300,000 total_flights via six airport_codes linked to state_fips. California registers 78 percent on_time_rate despite 400,000 delayed_flights in 2 million total_flights per BTS Monthly Airport Reports. BTS — Monthly Airport Reports, 2020-2025 These metrics in the flights dataset enable joins on state_fips for rankings, as detailed in Aggregation Methodology. Massachusetts tallies 80-minute avg_delay_minutes at Boston Logan within 200,000 delayed_flights and 100,000 total_flights for 2024.

• Florida state_fips links 19 airports to 82 percent on_time_rate in 5 million total_flights.
• Connecticut two airports deliver 90 percent on_time_rate on 20,000 total_flights.
• Pennsylvania Allentown hits 84 percent on_time_rate despite 80,000 delayed_flights.
• Alaska logs 2.5-minute avg_delay_minutes over 400,000 total_flights.

Trends in Cancellation Rates

300,000 Cancellations in Texas

Texas state_fips in states table aggregates 300,000 cancellations from 2020-2025 across airports table, including 25,000 at Abilene Airport alone per BTS State-Level Flight Aggregates. Bureau of Transportation Statistics — State-Level Flight Aggregates, 2020-2025 This cancellation_count column supports trend analysis against total_flights, with Texas State Flights page exposing yearly breakdowns. Ohio flights dataset notes 150,000 delayed_flights in 1 million total_flights, but cancellation trends tie to Cleveland's 50,000 delayed_flights in 2022 via BTS Monthly Airport Reports. Illinois O'Hare averages 85 minutes avg_delay_minutes amid 120,000 delayed_flights in 800,000 total_flights.

New York 2025 data lists 100,000 delayed_flights in 400,000 total_flights, where NAS disruptions elevate cancellation risks per FAA datasets. Nevada 90,000 delayed_flights in 200,000 total_flights for 2024 at Las Vegas signal rising patterns. Florida 500,000 delayed_flights over 5 million total_flights track alongside cancellation upticks in multi-year views. Federal Aviation Administration — State Aviation Data, 2024 Pennsylvania 80,000 delayed_flights in 2023 precede potential cancellations at Allentown.

Alaska minimal 2.5-minute avg_delay_minutes in 70,000 incidents across 400,000 total_flights contrasts Texas volumes. Alabama six airports average 2.6 minutes per 60,000 delayed_flights in 300,000 total_flights, limiting cancellation escalation. Trends page at Flight Trends Overview charts state_fips cancellation_count year-over-year.

Coverage and Limitations

PlainFlights databases ingest data from Bureau of Transportation Statistics State-Level Flight Aggregates, which follow a monthly release cadence for preliminary tallies and quarterly revisions for certified figures. BTS Monthly Airport Reports provide airport-level details, while Federal Aviation Administration State Aviation Data supplies state_fips aggregates with annual vintages updated through 2025. Bureau of Transportation Statistics — State-Level Flight Aggregates, 2020-2025 Revisions appear flagged in subsequent releases via change_logs column, distinguishing preliminary estimates from final normalized values in the flights table.

Snapshot vintages, such as the 2025 ingest of 400,000 New York total_flights with 100,000 delayed_flights, freeze metrics at publication dates, differing from live API endpoints that incorporate post-release amendments. Coverage targets states exceeding 100,000 total_flights, like Massachusetts 100,000 in 2024 or Alaska 400,000 from 2020-2025, but omits smaller entities below thresholds due to statistical reliability standards in BTS pipelines. Pennsylvania 50,000 total_flights falls outside primary aggregates yet appears via airport-specific BTS Monthly Airport Reports for Allentown 80,000 delayed_flights in 2023.

General aviation segments, military operations, and cargo hauls exclude from on_time_rate calculations, as BTS focuses on scheduled passenger services in the airports table. Connecticut two airports with 20,000 total_flights and 90 percent on_time_rate represent edge inclusions from 2021 data. Normalization processes standardize delay definitions across datasets—arrival delays beyond 15 minutes populate delayed_flights column uniformly. FAA State Aviation Data revisions history logs adjustments for weather attributions or NAS constraints, visible in delays_notes for New York hubs.

Data pipeline employs ETL sequences to join state_fips from states table to airports table, ensuring 19 Florida airports align with 500,000 delayed_flights and 82 percent on_time_rate. Vintage controls prevent retroactive alterations without audit trails, per BTS protocols. Coverage gaps persist for territories lacking submissions, unlike the 51 states scope in core tables. Cross-references link to airline performance via carrier_code, such as JetBlue Airways Performance intersecting state trends. Atlanta hub details at Atlanta Airport Details offer comparative metro insights, though Georgia aggregates sit outside this 100,000-flight minimum.

FOIA-derived supplements fill occasional voids in BTS releases, but regulatory mandates limit real-time access to operational logs. Ingest cadence aligns with BTS monthly drops, triggering re-normalization of avg_delay_minutes like Illinois 85 minutes at O'Hare or Massachusetts 80 minutes at Boston Logan. Methodology page at Aggregation Methodology details join logic for total_flights and cancellation_count across vintages. API consumers note provisional flags on 2025 data, such as Nevada 90,000 delayed_flights in 200,000 total_flights, pending full certification. Exclusion criteria safeguard against volatility in low-volume state_fips like Connecticut 10,000 delayed_flights, prioritizing aggregates above 100,000 total_flights for robust per-million delay metrics.

Texas 300,000 cancellations including Abilene 25,000 highlight statewide scope despite airport variances, with revision cycles updating cancellation_count post-initial reports. Alabama 2.6-minute avg_delay_minutes over six airports in 300,000 total_flights exemplifies stable low-volume coverage. Ohio Cleveland 50,000 delayed_flights in 2022 integrates seamlessly into 1 million total_flights trends. These elements ensure PlainFlights states table delivers verifiable, vintage-stamped records for downstream analytics.

The states table unifies 500,000 Florida delayed_flights at 82 percent on_time_rate, 90 percent Connecticut performance across two airports, Texas 300,000 cancellations, and coverage bounded by 100,000 total_flights thresholds from BTS and FAA sources, enabling precise queries on delayed_flights per million via joins documented in methodology.