Monthly data on passenger boarding and involuntary denied boarding counts for commercial airlines. The dataset includes over 25 columns detailing carrier information, passenger compensation status, and downgrade/upgrade events. It is published by the U.S. Bureau of Transportation Statistics via data.bts.gov, with a last recorded update in March 2022.
Use Cases
- Analyze trends in TOT_DEN_BOARDING by MKT_CARRIER_NAME and YEAR to identify airlines with frequent overbooking issues.
- Model the relationship between TOT_BOARDING, PAX_COMP_1, PAX_COMP_2, and PAX_COMP_3 to estimate compensation costs for denied passengers.
- Cluster airlines using OP_UNIQUE_CARRIER based on PAX_UPGRADE and PAX_DOWNGRADE rates to assess customer service practices.
- Forecast quarterly denied boarding volumes using MONTH, QUARTER, and historical TOT_DEN_BOARDING data for resource planning.
Strengths
- Contains over 25 distinct columns for detailed carrier and passenger event analysis.
- Provides temporal granularity with YEAR, MONTH, and QUARTER columns for time-series examination.
- Distinguishes between operating (OP_CARRIER) and marketing (MKT_CARRIER) carriers for partnership analysis.
Limitations
- Sample size and total row count are unknown, limiting assessment of statistical significance.
- Data freshness is uncertain as the last platform update was over two years ago in March 2022.
- Lacks explicit geographic coverage details, potentially limiting spatial analysis.
Provenance
- Source
- U.S. Bureau of Transportation Statistics (data.bts.gov).
- Collection Method
- null
- Time Range
- null
- Freshness
- Last known update was 2022-03-31; update frequency is null.
- Geography
- null