NTSB investigations, 2012
12 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 | 6 |
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\") = 2012
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") = 2012 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 CEN13WA092Accident · 8 fatalForeign investigationPiper PA-32-301 · Melbach, GermanyOn December 8, 2012, about 1513 coordinated universal time, a Piper PA-32, German registration, D-EUEU, and a Robin Regent DR400, German registration D-EHJP, collided while on cross country flights near Melbach, Germany. Visual meteorological conditions…NTSB ERA13LA054Accident · No injuriesLimited investigationFinal reportVans RV-12 · Williamson, GAThe inadequate visual lookout by the pilots of both airplanes, which resulted in a midair collision.NTSB ERA13LA022Accident · No injuriesLimited investigationFinal reportHughes/Helicopter Assocs 369A · West Chester, PAThe pilot’s failure to see and avoid the preceding helicopter while maneuvering for landing. Contributing to the accident were the flight lead pilot’s inadequate preflight briefing and in-flight instruction to the formation pilots, which resulted in the loss…NTSB WPR13LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe failure of both flight instructors to see and avoid the other airplane while providing instrument flight training, which resulted in a midair collision.NTSB ERA12WA530Accident · 4 fatalForeign investigationEmbraer EMB711 · Sta Barbara D'Oeste, BrazilOn August 18, 2012, at 1140 UTC an Embraer EMB-711C (Piper PA-28R-200), Brazilian registration PT-NKA, registered to a private owner, and a Embraer EMB-711C (Piper PA-28R-200), Brazilian registration PT-NIR, registered to a private owner, collided in cruise…NTSB CEN12LA553Accident · Minor injuriesLimited investigationFinal reportSchleicher ASG29-15M · Uvalde, TXThe glider pilot’s inadequate visual lookout and collision avoidance just after joining a thermal in which other gliders were operating, which resulted in a midair collision with another glider.NTSB WPR12LA250Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Sparks, NVThe failure of both pilots to see and avoid each other, which resulted in a midair collision.NTSB ERA12RA367Accident · 2 fatalForeign investigationBeech V35B · Sumerduck, VAOn May 28, 2012, about 1604 eastern daylight time, a Beech V35B, N6658R, and a Piper PA-28-140, N23SC, collided in flight in the vicinity of Sumerduck, Virginia. The Beech was destroyed, and the pilot and flight instructor were fatally injured; the Piper was…NTSB CEN12FA312Accident · 1 fatalField investigationFinal reportAir Tractor AT-802A · Sedgwick, ARThe inability of both pilots to see and avoid the other airplane, which resulted in a midair collision. Contributing to the accident was the distraction of the Air Tractor pilot by a cellular telephone conversation during the flight.NTSB WPR12CA163Accident · No injuriesData collectionFinal reportAvian Balloon Magnum IX · Sedona, AZThe pilot did not maintain adequate clearance during approach for landing between his basket and the envelope of another balloon that was also on approach, which resulted in a midair collision.NTSB CEN12FA199Accident · 2 fatalField investigationFinal reportCessna 172S · Longmont, COThe inadequate visual lookout by the pilots of both airplanes, which resulted in a mid-air collision.NTSB WPR12LA109Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Antioch, CAThe failure of both pilots to see and avoid each other during cruise flight, which resulted in a midair collision. Contributing to the accident was the failure of air traffic control personnel to issue the helicopter pilot a prompt and appropriate alternate…