NTSB investigations, MI
7 cases where the defining event was Powerplant sys/comp malf/fail.
Cases per year
| 2008 | 1 |
|---|---|
| 2015 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2023 | 1 |
| 2024 | 1 |
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 c.\"eventStateOrRegion\" = 'MI' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '340')
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 c."eventStateOrRegion" = 'MI' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '340') 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 CEN24LA185Accident · Serious injuriesClass 3 · LimitedFinal reportTitan T51 · Novi, MIA failure of the electrical system, resulting in a loss of fuel injection and subsequent loss of engine power.NTSB CEN23LA165Accident · No injuriesClass 3 · LimitedFinal reportPipistrel Lsa Sinus · Kingsford, MIThe failure of maintenance personnel to properly secure the left carburetor bowl cover, which resulted in an engine fire before takeoff.NTSB CEN20LA377Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-3 · Coleman, MIThe pilot’s improper installation of the generator drive gear, which resulted in a total loss of engine power.NTSB CEN19LA249Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A185 · Saginaw, MIMaintenance personnel’s failure to properly align the crankshaft during an engine reassembly which led to a fatigue failure of the crankshaft and the loss of all engine power.NTSB CEN19LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Adrian, MIThe airframe and powerplant mechanic's lack of experience in the overhaul of the engine model and the improper torque of the crankshaft gear bolt, which resulted in fatigue failure of the bolt and a total loss of engine power during an approach for landing.NTSB CEN16LA035Accident · Minor injuriesLimited investigationFinal reportGlimn Kitfox 2-3 · Escanaba, MIThe airplane owner's inadequate maintenance and servicing of the propeller gearbox, which resulted in oil starvation, failure of the gearbox in flight, and a subsequent loss of propeller thrust. Contributing to the outcome was the airplane's low altitude at…NTSB CHI08LA160Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Battle Creek, MIThe in-flight separation of the tip of a propeller blade due to metal fatigue that resulted from an inadequate inspection and repair.