NTSB investigations, MI
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 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 CEN20CA138Accident · No injuriesData collectionFinal reportChampion Aeronca 7FC · Hessel, MIThe pilot's loss of directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and impact with a snowbank.NTSB CEN20LA130Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Harrisville, MIThe pilot’s loss of directional control during landing rollout in gusty crosswind conditions, resulting in a runway excursion and collision with trees.NTSB CEN20CA100Accident · Minor injuriesData collectionFinal reportCommander 114 · Coldwater, MIThe flight instructor’s inadequate communication with the pilot under review about his intention to simulate a single-engine failure and his subsequent exceedance of the airplane’s critical angle of attack when the pilot did not respond as expected, which…NTSB CEN20CA089Accident · No injuriesData collectionFinal reportPiper PA28 · Sparta, MIThe student pilot's failure to maintain directional control while landing on the snow/slush-covered portion of the runway and the flight instructor's improper decision to allow the student to make his first solo flight from a snow/slush-covered runway.NTSB CEN20LA028Accident · No injuriesClass 3 · LimitedFinal reportBAE BAE125 · Detroit, MIThe pilots’ failure to increase approach speed as recommended for flight in icing conditions, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the failure of the stall warning system to advise the…NTSB CEN20CA027Accident · No injuriesData collectionFinal reportSkystar Kitfox · Williamston, MIThe pilot's improper decision to continue taxiing the airplane on unsuitable terrain, which resulted in a nose-over.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 CEN20FA001Accident · 5 fatalClass 3 · FieldFinal reportSocata TBM 700 · Lansing, MIThe pilot’s failure to maintain airspeed during final approach, which resulted in a loss of control and an aerodynamic stall at a low altitude, and his decision to operate the airplane outside of the approved weight and balance envelope.NTSB CEN19LA308Accident · 1 fatalClass 3 · LimitedFinal reportCessna 150 · Whitehall, MIThe pilot’s flight into a water tower while operating below minimum safe altitudes for reasons that could not be determined based on the available evidence for this investigation.NTSB GAA19CA534Accident · No injuriesData collectionFinal reportPiper PA28 · Sawyer, MIThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and an off-airport landing and impact with vegetation and a ditch. Contributing to the accident was the pilot's failure to follow the Emergency Power Loss…NTSB GAA19CA520Accident · No injuriesData collectionFinal reportPiper PA32RT · Mackinac Island, MIThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with a runway light.NTSB CEN19LA297Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C · Independence Charter Township, MIThe reduction in climb performance for reasons that could not be determined. Contributing to the accident was the pilot’s failure to maintain control of the airplane after the loss of performance.NTSB CEN19FA279Accident · 2 fatalClass 3 · FieldFinal reportAero Commander 200 · Howell, MIThe improper installation of the engine’s metal intake screen, which allowed the filter element to become displaced and subsequently lodge in the intake, blocking intake air and causing the total loss of engine power, at low altitude and low airspeed…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 CEN19FA247Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Ontonagon, MIThe non-instrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions with thunderstorm activity, which resulted in spatial disorientation and a loss of airplane control.NTSB CEN19LA242Accident · Serious injuriesLimited investigationFinal reportIcon A5 · Lake, MIThe pilot's improper decision to operate the airplane in exceedance of the airplane manufacturer’s operating limitations, which led to an aerodynamic stall. Contributing to the accident was the pilot's improper decision to continue attempting the takeoff…NTSB CEN19LA231Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Breckenridge, MIA total loss of engine power due to a lack of oil in the engine. The source of the inflight oil leak could not be determined based on the available information.NTSB CEN19LA217Accident · Minor injuriesLimited investigationFinal reportPiper PA34 · Ypsilanti, MIThe pilot's premature movement of the landing gear selector to the "up" position during takeoff, which allowed the landing gear to retract before a positive climb rate was established, and the lack of a positive climb rate, which led to the airplane settling…NTSB CEN19LA214Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA18 · Bay City, MIThe pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack during a banner drop and pickup, which resulted in an aerodynamic stall and a subsequent loss of control.NTSB CEN19LA179Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Cottrellville Township, MIThe partial loss of engine power due to carburetor icing and the pilot’s failure to use carburetor heat in weather conditions conducive to serious carburetor icing. The reason for the pilot’s inability to advance the throttle for the go-around could not be…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 CEN19FA134Accident · 1 fatalClass 2 · FieldFinal reportAlliant Destiny 2000 · New Era, MIThe pilot's failure to maintain aircraft control while maneuvering that resulted in collapse of the canopy and an uncontrolled descent into terrain.NTSB GAA19CA178Accident · No injuriesData collectionFinal reportPiper PA 12 · Mecosta, MIThe pilot's failure to maintain directional control during the landing roll, which resulted in impact with a windsock pole.NTSB CEN19CA062Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Iron Mountain, MIThe pilot's distraction and subsequent loss of situational awareness and visual horizon in overcast sky conditions, which led to an unrecognized descent during a low-level maneuver and subsequent impact with snow-covered terrain.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 CEN19LA059Accident · No injuriesLimited investigationFinal reportCessna T210 · Flint, MIThe failure of the nose landing gear actuator hydraulic hose, which resulted in the loss of hydraulic fluid and hydraulic system pressure and a subsequent gear-up landing.NTSB CEN19LA051Accident · 1 fatalLimited investigationFinal reportPiper PA 23 · Beaver Island, MIThe pilot's failure to maintain a positive rate of climb after takeoff which resulted in an impact with trees and terrain. Contributing to the accident was the pilot's inability to see a visible horizon due to the dark night lighting conditions and limited…NTSB CEN19LA050Accident · 1 fatalLimited investigationFinal reportCessna R172K · Chesaning, MIThe pilot's loss of airplane control for reasons that could not be determined based on the available information.NTSB GAA19CA028Accident · No injuriesData collectionFinal reportPiper PA28 · Hastings, MIThe student pilot's improper landing flare, which resulted in the airplane landing sideways and a subsequent runway excursion.NTSB WPR19TA009Accident · Serious injuriesFinal reportKreling Supercat · Three Rivers, MIThe pilot's failure to maintain the proper pitch attitude and adequate airspeed during takeoff, which resulted in an aerodynamic stall.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 GAA18CA560Accident · Minor injuriesData collectionFinal reportPiper PA22 · Hillsdale, MIThe pilot’s exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.NTSB CEN18FA371Accident · 1 fatalField investigationFinal reportCessna 340A · Port Huron, MIThe pilot's improper fuel management, which resulted in a total loss of right engine power due to fuel starvation; the pilot's inadequate flight planning; the pilot's failure to secure the right engine following the loss of power; and his failure to properly…NTSB CEN18LA365Accident · Serious injuriesLimited investigationFinal reportMD Helicopters MD-369 · Orchard Lake, MIThe pilot's failure to maintain helicopter control and terrain clearance while in a hover after performing an evasive maneuver to avoid wildlife.NTSB CEN18TA374Accident · Minor injuriesFinal reportBeech 35 · Harrisville, MIThe pilot’s delayed decision to abort the takeoff, which resulted in the loss of lateral control of the airplane and collision with trees at the end of the runway. Contributing to the accident was the pilot’s decision to depart with a center of gravity…NTSB CEN18FA368Accident · 1 fatalField investigationFinal reportPiper PA32RT · St Ignace, MIThe pilot's failure to maintain sufficient altitude after takeoff in dark night conditions which resulted in a collision with the water.NTSB CEN18FA339Accident · 1 fatalField investigationFinal reportAir Tractor AT502 · Bronson, MIThe pilot's failure to maintain airspeed while maneuvering, which resulted in exceedance of the airplane's critical angle of attack, an aerodynamic stall, and loss of control at an altitude too low for recovery.NTSB GAA18CA471Accident · Minor injuriesData collectionFinal reportCessna 172 · Dowagiac, MIThe pilot's failure to maintain bank control during takeoff.NTSB CEN18LA313Accident · No injuriesLimited investigationFinal reportBrantly B-2 · Midland, MIThe in-flight separation of the tail rotor blade due to fatigue, which resulted in the subsequent emergency landing and dynamic rollover.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 CEN18LA298Accident · Minor injuriesLimited investigationFinal reportExtra EA300 · North Fox Island, MIThe Extra pilot’s failure to see and avoid the Cessna, which resulted in an in-flight collision. Contributing to the accident was the failure of the Extra pilot to tune his radio to the correct frequency, which resulted in no common traffic advisories being…NTSB GAA18CA466Accident · No injuriesData collectionFinal reportVans RV9 · Holland, MIThe pilot’s failure to maintain yaw control during a go-around.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 GAA18CA391Accident · No injuriesData collectionFinal reportCessna 172 · Troy, MIThe student pilot’s failure to maintain a proper landing flare, which resulted in a hard, porpoised landing during an aborted go-around.NTSB GAA18CA407Accident · No injuriesData collectionFinal reportBeech 58 · Mackinac Island, MIThe pilot’s failure to remove the pitot tube cover during the preflight inspection, which resulted in his delayed decision to reject the takeoff with insufficient runway remaining to safely stop the airplane.NTSB CEN18FA236Accident · 2 fatalField investigationFinal reportCessna P210N · Detroit, MIA total loss of engine power due to fuel exhaustion. Also causal was the pilot's failure to divert earlier in the flight to another airport to ensure that the airplane had an adequate fuel reserve, and the malfunction of the landing gear extension system for…NTSB CEN18LA206Accident · Serious injuriesLimited investigationFinal reportHughes Aero Predator "C" · Copemish, MIThe pilot's improper decision to take off with a passenger in high-density altitude conditions from a runway with tall grass present, which resulted in the powered-parachute's poor takeoff performance and its inability to clear a tree line and led to a…