NTSB investigations, 2024
18 cases where the sequence of events included Near midair/TCAS alert/loss of separation.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 1 |
| 2010 | 8 |
| 2011 | 7 |
| 2012 | 1 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 4 |
| 2018 | 6 |
| 2021 | 5 |
| 2022 | 7 |
| 2023 | 6 |
| 2024 | 18 |
| 2025 | 15 |
| 2026 | 9 |
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '260' 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") = 2024 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '260' 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 DCA25WA089Incident · No injuriesClass 5 · ForeignBoeing 737-832 · Belize City, BelizeNTSB DCA25WA087IncidentClass 5 · ForeignSikorsky S-92A · Hammerfest, NorwayNTSB DCA25WA017Incident · No injuriesClass 5 · ForeignBoeing 737 · Tenerife, SpainNTSB DCA24WA327IncidentClass 4 · ForeignEmbraer ERJ190 · MexicoNTSB DCA24LA316Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 757-224 · Dunnigan, CAThe abrupt pitch control input by the flight crew in response to a TCAS resolution advisory resulted in two serious passenger injuries.NTSB DCA24WA308IncidentClass 5 · ForeignBoeing 737-8 · San Francisco, CANTSB DCA24WA273IncidentClass 5 · ForeignBoeing 737 · Olandji, ChadNTSB DCA24WA270IncidentClass 5 · ForeignAirbus A320 · Purani, RomaniaNTSB DCA24WA250OccurrenceClass 5 · ForeignBoeing 737 · Chicago, ILNTSB DCA24WA253IncidentClass 5 · ForeignEmbraer ERJ190 · Ruston, LANTSB DCA24WA209IncidentClass 5 · ForeignAirbus A321 · Muscat, OmanNTSB DCA24WA307IncidentClass 5 · ForeignBoeing 787-8 · Madrid, SpainNTSB DCA24WA177Incident · No injuriesClass 5 · ForeignBoeing 737 · Miho, JapanNTSB DCA24WA162IncidentClass 5 · ForeignBoeing 777 · Mumbai, IndiaNTSB DCA24WA107IncidentClass 5 · ForeignBoeing 737 · Tapachula, MexicoNTSB DCA24WA111IncidentClass 5 · ForeignAirbus A320-232 · Merida, MexicoNTSB DCA24WA096Incident · No injuriesClass 5 · ForeignBoeing 777-3FX (ER) · Abu Dhabi, United Arab EmiratesNTSB DCA24WA106IncidentClass 5 · ForeignAirbus A319 · Barcelona, Spain