NTSB investigations, 2015
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 | 6 |
Where
Latest 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\") = 2015
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") = 2015 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 WPR16LA016Accident · No injuriesLimited investigationFinal reportCessna 310C · Primm, NVThe inadequate visual lookout by the pilots of both airplanes, which resulted in a midair collision. Contributing to the accident was the pilots' failure to tune to, monitor, and communicate over the common traffic advisory frequency their relative positions…NTSB CEN15WA429Accident · 4 fatalForeign investigationPiper PA28 · Sandstedt, GermanyOn September 26, 2015, at 1138 universal coordinated time, a Piper PA-28, German registration D-EBVM and a Reims F172, German registration D-EGJA, collided over Sandstedt, Germany. The pilot on board the PA-28 was fatally injured. The pilot and two passengers…NTSB DCA15WA188Accident · 7 fatalForeign investigationBoeing 737 · Tambacounda, SenegalNTSB WPR15MA243Accident · 5 fatalMajor investigationFinal reportCessna 172M · San Diego, CAThe local controller's (LC) failure to properly identify the aircraft in the pattern and to ensure control instructions provided to the intended Cessna on downwind were being performed before turning Eagle1 into its path for landing. Contributing to the LC's…NTSB ERA15WA303Accident · 9 fatalForeign investigationCessna U206F · Istra, RussiaOn August 8, 2015, at 1708 universal coordinated time, a Cessna U206F airplane, Russian registration RA- 67523 registered to a private owner, and a Robinson R44 II helicopter, Russian registration RA- 04383, registered to a private owner, collided while…NTSB ERA15MA259Accident · 2 fatalClass 2 · MajorFinal reportCessna 150M · Moncks Corner, SCThe approach controller's failure to provide an appropriate resolution to the conflict between the F-16 and the Cessna. Contributing to the accident were the inherent limitations of the see-and-avoid concept, resulting in both pilots' inability to take…NTSB GAA15CA157Accident · Minor injuriesData collectionFinal reportBalloon Works FIREFLY8 - 24 · Provo, UT**This report was modified on 4/21/2016. Please see the public docket for this accident for more information.** The failure of the Balony balloon pilot to see and avoid the Balloon Works balloon during an ascent, which resulted in the basket of the Balony…NTSB ANC15WA043Accident · 2 fatalForeign investigationCessna 172 · Fort McMurray, CanadaNTSB ANC15LA033Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe other pilot’s failure to maintain an adequate visual lookout, which resulted in a midair collision. Contributing to the accident was the other pilot’s failure to follow Federal Aviation Administration-recommended traffic pattern procedures.NTSB ERA15WA233Accident · 1 fatalForeign investigationVans RV8 · Corropoli, ItalyOn May 31, 2015, about 1430 universal coordinated time, a Vans RV8, I-LOVI, and a Vans RV7, I-AMEL, were destroyed after colliding midair and then subsequently colliding with the Adriatic Sea, near Corropoli, Italy. The Italian certificated pilot of the RV8…NTSB ERA15LA172Accident · No injuriesClass 3 · LimitedFinal reportMerian Richard F RV 8 · Tuscaloosa, ALThe RV-8 pilot's failure to maintain adequate clearance from the RV-6 while maneuvering during an air show, which resulted in a midair collision.NTSB ANC15FA009Accident · Serious injuriesField investigationFinal reportPiper PA 18 · Wasilla, AKBoth pilots’ inadequate visual lookout and failure to see and avoid each other while in level cruise flight, which resulted in a midair collision. Contributing to the accident was the obscuration of the other pilot’s visibility due to sun glare.NTSB ERA15LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · West Palm Beach, FLThe failure of the airplane pilots to maintain an adequate visual lookout for known traffic in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the failure of the airplane pilots to announce their intentions before…