NTSB investigations, 2024
13 cases where the sequence of events included Midair collision.
Cases per year
| 2008 | 13 |
|---|---|
| 2009 | 12 |
| 2010 | 11 |
| 2011 | 11 |
| 2012 | 12 |
| 2013 | 7 |
| 2014 | 8 |
| 2015 | 13 |
| 2016 | 13 |
| 2017 | 8 |
| 2018 | 13 |
| 2019 | 10 |
| 2020 | 11 |
| 2021 | 7 |
| 2022 | 8 |
| 2023 | 10 |
| 2024 | 13 |
| 2025 | 11 |
| 2026 | 7 |
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\" = '250' 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" = '250' 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 ERA25LA072Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Pahokee, FLThe pilots' failure to see and avoid the other airplane, which resulted in a midair collision during short final approach.NTSB GAA25WA025Accident · 1 fatalClass 5 · ForeignCessna 182P · The Oaks, AustraliaNTSB WPR24FA309Accident · 1 fatalClass 3 · FieldFinal reportNanchang China CJ-6A · Lancaster, CAThe CJ-6A pilot’s failure to maintain separation and the Yak pilot’s failure to monitor the other airplane during a detachment, which resulted in a midair collision.NTSB WPR24FA304Accident · 1 fatalClass 3 · FieldFinal reportGlobe Swift GC-1B · Minden, NVThe failure of the pilots of both airplanes to see and avoid the other airplane while operating in the airport traffic pattern, which resulted in a midair collision.NTSB DCA24LA328Incident · No injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Austin, TXThe unintended activation of the Emergency Autoland button on the overhead panel due to the airplane’s collision with an unknown object. Contributing to the incident was the pilot’s inability to initially deactivate the Emergency Autoland system due to a…NTSB WPR24LA302Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK30 · Pendleton, ORThe operator’s failure to maintain separation between two drones during dual simulated engine out recoveries, which resulted in a midair collision.NTSB ERA24LA332Accident · No injuriesClass 4 · LimitedFinal reportBucker Jungmann C.A.S.A. 1.131 · Red Hook, NYThe Great Lakes pilot's failure to maintain adequate clearance from the Bucker Jungmann while maneuvering during an air show, which resulted in a midair collision, the inability of the Bucker Jungmann to maintain altitude, and its subsequent forced landing.NTSB GAA24WA227Accident · 2 fatalClass 5 · ForeignRobinson R22 · Curtin, AustraliaNTSB CEN24FA260Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-502B · Bonita, LAThe failure of both pilots to see and avoid the other airplane while at low altitude enroute to their aerial application flights.NTSB WPR24FA201Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802 · Arco, IDA midair collision between two airplanes during aerial application operations due to both pilots’ insufficient awareness of their proximity to each other and their failure to see and avoid each other. Contributing to the accident was the operator and both…NTSB CEN24FA221Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT502 · Whiteface, TXBoth pilot’s failure to see and avoid the other airplane during simultaneous aerial application operations over the same area. Contributing to the accident was the operator’s poor decision to assign the pilots to conduct separate aerial application operations…NTSB GAA24WA091AccidentClass 5 · ForeignBeechcraft B · Vestmannaeyjar islands, IcelandNTSB CEN24LA110Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Taurus · Waller, TXThe failure of both pilots to see and avoid one another while maneuvering, which resulted in a mid-air collision.