NTSB investigations, MI
41 cases where NTSB found Not determined, general.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 4 |
| 2010 | 8 |
| 2011 | 3 |
| 2012 | 4 |
| 2013 | 3 |
| 2015 | 1 |
| 2016 | 3 |
| 2018 | 4 |
| 2019 | 3 |
| 2020 | 1 |
| 2021 | 1 |
| 2024 | 3 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '05000000'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '05000000')) 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 CEN24LA336AccidentClass 4 · LimitedFinal reportCessna 182D · Coopersville, MIThe loss of airplane control while landing.NTSB CEN24FA298Accident · 1 fatalClass 3 · FieldFinal reportDeGraw DeBird · Napoleon, MISeparation of the gyroplane’s tail due to main rotor blade contact for reasons that could not be determined.NTSB CEN24LA249Accident · No injuriesClass 3 · LimitedFinal reportRotorway 162 F · Maybee, MIA partial loss of engine power for undetermined reasons.NTSB CEN21LA303Accident · No injuriesClass 3 · LimitedFinal reportAeronca 15AC · Hastings, MIA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN20LA187Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · West Branch, MIThe pilot's failure to maintain rotor rpm during a precautionary autorotation, which resulted in a hard landing. Contributing to the accident was the airframe vibration for reasons that could not be determined because examination of the helicopter revealed no…NTSB CEN20LA017Accident · Serious injuriesClass 3 · LimitedFinal reportSocata TB 30 Epsilon · Kalamazoo, MIA total loss of engine power for undetermined reasons, which resulted in an aerodynamic stall during the pilot’s attempted forced landing at low altitude and impact with terrain.NTSB CEN19FA165Accident · 2 fatalField investigationFinal reportBeech V35 · Frankfort, MIA loss of engine power for reasons that could not be determined based on the available information.NTSB GAA19CA258Accident · Serious injuriesData collectionFinal reportCessna 172 · Dexter, MIThe airplane's failure to maintain a climb for reasons that could not be determined based on the available evidence.NTSB CEN18FA387Accident · 1 fatalField investigationFinal reportBeech 200 · Oscoda, MIThe pilot's descent below minimum descent altitude during the nonprecision instrument approach for reasons that could not be determined based on the available information.NTSB CEN18LA307Accident · No injuriesLimited investigationFinal reportGerald Dan Coppock Bade-E · Escanaba, MIThe loss of control during the landing rollout for reasons that could not be determined based on the available evidence, which resulted in a ground loop and runway excursion.NTSB ANC18LA057Accident · 1 fatalLimited investigationFinal reportAeros Venture 2000 · Bad Axe, MIThe pilot's loss of aircraft control for reasons that could not be determined based on the available information.NTSB CEN18LA280Accident · Serious injuriesClass 3 · LimitedFinal reportBest Off Skyranger · Houghton Lake, MIA partial loss of engine power during takeoff for undetermined reasons.NTSB CEN16LA305Accident · Minor injuriesLimited investigationFinal reportGilchrist PA14EXP · Sparta, MIA total loss of engine power for reasons that could not be determined, since postaccident examination revealed no malfunctions or anomalies that would have precluded normal operation.NTSB CEN16LA264Accident · No injuriesLimited investigationFinal reportAlonso CH 701 · Dexter, MIThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN16FA240Accident · 2 fatalField investigationFinal reportAeronca 11AC · Frankenmuth, MIThe pilot's loss of control for undetermined reasons based on available information.NTSB CEN15LA185Accident · No injuriesLimited investigationFinal reportGiackino Donald W Rotorway 162F · Marquette, MIThe loss of helicopter control for reasons that could not be determined based on the available evidence.NTSB CEN13LA552Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Frankenmuth, MIAn intermittent loss of engine power for reasons that could not be determined because postaccident examinations revealed no anomalies that would have precluded normal operation.NTSB CEN13LA490Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D1 · Eastport, MIA fuel leak in the engine compartment and subsequent fire, the source of which could not be determined because of extensive postaccident fire damage.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 CEN13FA069Accident · 1 fatalField investigationFinal reportCessna 310B · Mancelona, MIThe pilot's failure to maintain control of the airplane after a loss of right engine power for reasons that could not be determined because postaccident examination revealed no preimpact malfunction or anomaly that would have precluded normal operation.NTSB CEN12FA487Accident · No injuriesField investigationFinal reportMooney M20TN · Adrian, MIAn initial nose-pitch-up event and out-of-trim condition, the reason for which could not be determined because the examinations of the airplane did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the…NTSB CEN12LA296Accident · Minor injuriesLimited investigationFinal reportMaule M-7-420AC · Hanover Township, MIA total loss of engine power for reasons that could not be determined during an exhaustive postaccident examination of the engine and its components.NTSB CEN12LA149Accident · 1 fatalLimited investigationFinal reportPipistrel Virus 912 · Ray, MIA loss of engine power due to fuel starvation for reasons that could not be determined because the postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA014Accident · Serious injuriesLimited investigationFinal reportPeck Zodiac 601XL · Traverse City, MIA loss of engine power for undetermined reasons.NTSB CEN11LA488Accident · Minor injuriesLimited investigationFinal reportDixon Volksplane VP-1 · Jackson, MIA partial loss of engine power during initial climb after takeoff for undetermined reasons.NTSB CEN11LA365Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Freemont, MIThe pilot’s failure to attain a positive climb rate following takeoff for reasons that could not be determined because the propeller was not provided for further examination. Contributing to the accident was the pilot's impairment from alcohol.NTSB CEN11FA029Accident · 2 fatalField investigationFinal reportAmerican Champion 8KCAB · Sebewaing, MIThe pilot's failure to maintain airspeed and aircraft control following a loss of engine power after takeoff.NTSB CEN11CA003Accident · Minor injuriesData collectionFinal reportCessna 310J · St. Johns, MIThe failure by the pilot to attain/maintain a climb rate for undetermined reasons during a go-around.NTSB CEN10LA571Accident · Serious injuriesLimited investigationFinal reportCa Tecnam P2004 Bravo · Mason, MIA total loss of engine power for undetermined reasons, which resulted in a forced landing to a bean field.NTSB CEN10LA531Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Buchanan, MIA failure of the engine's No. 3 and No. 4 cylinder valve lifters for undetermined reasons, which resulted in a total loss of engine power.NTSB CEN10CA500Accident · Minor injuriesData collectionFinal reportCessna 150K · Gaylord, MIA loss of engine power for undetermined reasons.NTSB CEN10LA432Accident · Serious injuriesLimited investigationFinal reportBeech A24R · Muskegon, MIA loss of engine power for undetermined reasons.NTSB CEN10FA394Accident · 4 fatalField investigationFinal reportBeech 58 · St. Ignace, MIThe pilot's failure to maintain aircraft control during takeoff for undetermined reasons.NTSB CEN10CA325Accident · No injuriesData collectionFinal reportCessna 172 · Traverse City, MIDamage to the firewall for undetermined reasons.NTSB CEN10FA063Accident · 1 fatalField investigationFinal reportPiper PA-31T2 · Harrison, MIA loss of aircraft control for undetermined reasons.NTSB CEN10FA029Accident · 1 fatalField investigationFinal reportBeech A36TC · Kalamazoo, MIThe loss of engine power for an undetermined reason.NTSB CEN09CA548Accident · No injuriesData collectionFinal reportPiper PA-15 · Plainwell, MIA loss of control on takeoff for undetermined reasons.NTSB CEN09LA512Accident · 1 fatalLimited investigationFinal reportHooper James A Bushby MUS · Gladwin, MIThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB CHI08LA191Accident · 1 fatalLimited investigationFinal reportDrochak Aventura II · Flushing, MIA loss of engine power for undetermined reasons.NTSB CHI08LA129Accident · No injuriesLimited investigationFinal reportCessna 208B · Ada, MIA loss of engine power for undetermined reasons.NTSB CHI08CA060Accident · No injuriesData collectionFinal reportAmerican Champion 7AC · Whitmore Lake, MIThe partial loss of engine power for undetermined reasons during cruise and the unsuitable terrain encountered during the precautionary landing. A factor was the snow-covered ground.