NTSB investigations, 2015, MI
9 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 14 |
|---|---|
| 2009 | 19 |
| 2010 | 17 |
| 2011 | 22 |
| 2012 | 19 |
| 2013 | 17 |
| 2014 | 15 |
| 2015 | 9 |
| 2016 | 13 |
| 2017 | 12 |
| 2018 | 14 |
| 2019 | 16 |
| 2020 | 5 |
| 2021 | 10 |
| 2022 | 7 |
| 2023 | 7 |
| 2024 | 3 |
| 2025 | 3 |
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.\"eventStateOrRegion\" = 'MI' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' 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."eventStateOrRegion" = 'MI' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' 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 GAA16CA054Accident · No injuriesData collectionFinal reportAeronca 7AC · Fowlerville, MIThe pilot's failure to maintain pitch control during the takeoff roll, which resulted in an impact with terrain.NTSB CEN16LA017Accident · Minor injuriesLimited investigationFinal reportComp Air CA8 · Ray, MIThe pilot's improper use of the trim, which created a cross-controlled situation and resulted in an aerodynamic stall during the attempted go-around.NTSB CEN15LA398Accident · Serious injuriesLimited investigationFinal reportBuckeye Dream Macine · Zeeland, MIThe noncertificated pilot's impairment due to alcohol consumption, which resulted in his failure to maintain clearance from a tree.NTSB CEN15LA332Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Holland, MIA total loss of engine power due to fuel starvation during cruise flight. Contributing to the accident was the pilot’s inadequate preflight fuel planning.NTSB GAA15CA143Accident · No injuriesData collectionFinal reportAventura II · Fenton, MIThe failure of the student pilot to ensure that the experimental seaplane was airworthy prior to take off.NTSB GAA15CA102Accident · No injuriesData collectionFinal reportBell 206 - B11 · Caledonia, MIA loss of tail rotor effectiveness while maneuvering at low altitude, resulting in a collision with trees.NTSB CEN15LA235Accident · Serious injuriesLimited investigationFinal reportLathrop Steven A B8M · Ravenna, MIA total loss of engine power due to carburetor icing.NTSB GAA15CA020Accident · Minor injuriesData collectionFinal reportCessna 150 · Flushing, MILoss of engine power due to fuel contamination. A factor contributing to the accident was the pilot's inadequate preflight.NTSB GAA15CA005Accident · No injuriesData collectionFinal reportCessna 208B · Muskegon, MIThe pilot's improper decision to continue the landing when the airplane was not in a safe position to land, resulting in the collision with ground-based approach lighting.