NTSB investigations, 2025
15 cases where the sequence of events included Runway incursion veh/AC/person.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 7 |
| 2010 | 1 |
| 2011 | 4 |
| 2012 | 4 |
| 2013 | 3 |
| 2014 | 1 |
| 2015 | 6 |
| 2016 | 8 |
| 2017 | 1 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 5 |
| 2022 | 2 |
| 2023 | 10 |
| 2024 | 13 |
| 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\") = 2025
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '320' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2025 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '320' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 DCA26WA257IncidentClass 5 · ForeignGippsAero GA8 · Whitemark, AustraliaNTSB DCA26WA032IncidentClass 5 · ForeignFairchild 22C7 · South Mackay, AustraliaNTSB DCA26WA034IncidentClass 5 · ForeignBoeing 787 · Pasay City, PhilippinesNTSB DCA26WA010Incident · No injuriesClass 5 · ForeignBoeing 767 · Ezeiza, ArgentinaNTSB DCA25WA340Incident · No injuriesClass 5 · ForeignAirbus Canada A220 · Toronto, CanadaNTSB DCA25WA335IncidentClass 5 · ForeignEmbraer ERJ190 · Gran Canaria, SpainNTSB DCA25WA332IncidentClass 5 · ForeignBoeing 737 · Alicante, SpainNTSB DCA25WA309IncidentClass 5 · ForeignAirbus A320-214 · Villahermosa, MexicoNTSB DCA25WA299IncidentClass 5 · ForeignBoeing 737 · Bickenhill, United KingdomNTSB DCA25WA292Incident · No injuriesClass 5 · ForeignBoeing 737-832 · Ciudad de México, MexicoNTSB DCA25WA280Incident · No injuriesClass 5 · ForeignBoeing 777 · Singapore, SingaporeNTSB DCA25WA225IncidentClass 5 · ForeignBoeing 777 · Singapore, SingaporeNTSB DCA25WA224IncidentClass 5 · ForeignBoeing 737 · Singapore, SingaporeNTSB DCA25LA141Occurrence · No injuriesClass 3 · LimitedPreliminary reportBoeing 737-800 · Chicago, ILOn February 25, 2025, about 0848 central standard time (CST), Flexjet flight 560 (LXJ 560), a Bombardier Challenger 350 CL-35, registration N560FX and Southwest Airlines flight 2504 (SWA2504), a Boeing 737-800, registration N8517F, were involved in a runway…NTSB WPR25LA087Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Upland, CAThe pilot’s failure to maintain adequate separation during landing, which resulted in a runway collision with another airplane.