NTSB investigations, 2024
11 cases where the defining event was Runway incursion veh/AC/person.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 7 |
| 2010 | 1 |
| 2011 | 4 |
| 2012 | 4 |
| 2013 | 3 |
| 2014 | 1 |
| 2015 | 5 |
| 2016 | 7 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 4 |
| 2022 | 2 |
| 2023 | 9 |
| 2024 | 11 |
| 2025 | 15 |
| 2026 | 10 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE year(c.\"eventDate\") = 2024
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '320')
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 2024 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '320') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN25LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna 182T · Pearland, TXThe AA-5 pilot’s failure to maintain separation from the 182T during approach and landing, which resulted in a ground collision during the landing roll. Contributing to the accident was the failure of the AA-5’s electrical system, which prevented the AA-5…NTSB DCA25WA121Incident · No injuriesClass 5 · ForeignBoeing 737 · Dublin, IrelandNTSB OPS25LA008IncidentClass 4 · LimitedInvestigation openBoeing 737-832 · Miami, FLNTSB DCA25WA007IncidentClass 5 · ForeignBoeing 737 · Las Puntillas, SpainNTSB DCA24FA300Incident · No injuriesClass 3 · FieldPreliminary reportBoeing 737-9 · Nashville, TNOn September 12, 2024, about 0914 central daylight time (CDT), Alaska Airlines flight 369 (ASA369), a Boeing 737-900, N919AK, rejected their take-off on runway 13 at Nashville International Airport (BNA), Nashville, Tennessee, when Southwest Airlines flight…NTSB DCA24WA312Incident · No injuriesClass 5 · ForeignBoeing 727 · Curitiba, BrazilNTSB DCA24WA248IncidentClass 5 · ForeignBoeing 737 · Nouaceur, MoroccoNTSB DCA24FA164IncidentClass 2 · FieldFinal reportAirbus A330 · Queens, NYNonstandard crossing phraseology and ineffective coordination between local controller 1 (LC1) and local controller 2 (LC2) which resulted in degraded shared situation awareness, and a runway incursion.NTSB GAA24WA126IncidentClass 5 · ForeignBeech A36 · Geraldton, AustraliaNTSB DCA24WA090IncidentClass 5 · ForeignBoeing 787 · Singapore, SingaporeNTSB DCA24WA058OccurrenceClass 5 · ForeignAirbus A350 · Tokyo, Japan