NTSB investigations, 2013, MI
17 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\") = 2013
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") = 2013 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 CEN14LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Oscoda, MIThe student pilot’s loss of control during landing in gusting wind conditions. Contributing to the accident was the pilot’s decision to land with gusting wind.NTSB CEN13LA555Accident · Serious injuriesLimited investigationFinal reportBuckeye Industries Dream Machine · St. Joseph, MIThe pilot's failure to maintain control of the powered-parachute during takeoff.NTSB CEN13LA524Accident · Serious injuriesLimited investigationFinal reportStemme S10-VT · Mackinaw City, MIThe mechanic’s failure to inspect the tightness of the bolts that connected the flexible disk to the driveshaft, which resulted in the failure of these components.NTSB CEN13LA546Accident · Minor injuriesLimited investigationFinal reportBrantly B-2B · Rothbury, MIThe pilot’s failure to maintain helicopter control while turning to avoid trees during an aborted takeoff in gusting wind conditions.NTSB CEN13CA501Accident · No injuriesData collectionFinal reportMcdonnell Douglas Heli 369FF · Reese, MIThe failure of the temporary hoist holding the powerline wire which resulted in a brief loss of control and main rotor blade impacts with the tower.NTSB CEN13CA510Accident · No injuriesData collectionFinal reportErcoupe 415-C · Mackinac Island, MIThe pilot's failure to maintain aircraft control while on final approach.NTSB CEN13CA474Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Clare, MIThe flight instructor's failure to adequately monitor the landing approach, his delayed corrective action and his failure to maintain directional control that resulted in the airplane's collision with a ditch adjacent to the runway. The student pilot's…NTSB CEN13CA469Accident · No injuriesData collectionFinal reportCessna 182T · Mackinac Island, MIThe pilot's delayed response to abort the takeoff, which resulted in an excursion and collision with a fence. Contributing to the accident was the pilot's failure to check the pitot tube for debris during preflight.NTSB CEN13LA422Accident · Serious injuriesLimited investigationFinal reportGrumman Aircraft Cor-Schweizer G-164A · Elmira, MIThe pilot's failure to maintain clearance from a line of trees while applying agricultural product to a field.NTSB CEN13FA416Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-65 · Flushing, MIThe student pilot’s failure to maintain airspeed during the landing approach, which led to a stall/spin, and the flight instructor’s failure to monitor the approach and provide remedial action before the stall.NTSB CEN13LA383Accident · Serious injuriesLimited investigationFinal reportVink Robert D Youngster · Grand Haven, MIThe loss of engine power due to carburetor icing.NTSB CEN13FA364Accident · 4 fatalField investigationFinal reportCessna 172M · Waterford, MIThe pilot's failure to retract the wing flaps before attempting to take off, due to his lack of familiarity with the airplane make and model, which prevented the airplane from maintaining adequate altitude for takeoff.NTSB CEN13LA232Accident · No injuriesLimited investigationFinal reportCessna 172G · Reading, MIThe partial loss of engine power due to the improper securing of the throttle linkage by maintenance personnel.NTSB CEN13CA202Accident · No injuriesData collectionFinal reportCessna 172L · Pontiac, MIThe pilot's failure to maintain airplane control after an unexplained increase in engine power while taxiing.NTSB CEN13CA185Accident · Minor injuriesData collectionFinal reportPiper PA22 · Baraga, MIThe pilot’s failure to maintain directional control during taxi.NTSB CEN13CA161Accident · No injuriesData collectionFinal reportCessna 172M · Jenison, MIThe pilot's failure to maintain directional control while landing on an ice- and snow-covered runway in crosswind conditions.NTSB CEN13FA135Accident · 1 fatalField investigationFinal reportCessna 208B · Pellston, MIThe pilot's inadvertent controlled descent into terrain due to spatial disorientation. Contributing to the accident was lack of visual reference due to night conditions.