NTSB investigations, MI
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 CHI91LA214Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Sparta, MIInadequate preflight by the pilot and the pilot's failure to reach a proper touchdown point.NTSB CHI91LA207Accident · No injuriesLimited investigationFinal reportHughes 300C · Whitehall, MIThe pilot's failure to maintain adequate clearance from the water. A factor was the dark night light condition.NTSB CHI91LA204Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Dexter, MIThe pilot's delay in aborting the landing. A factor in the accident was his excessive speed on final approach.NTSB CHI91LA203Accident · No injuriesLimited investigationFinal reportCessna 150G · Big Rapids, MIThe stall/mush which occurred during the go-around. A factor related to the accident was the pilot's abrupt pull-up maneuver.NTSB CHI91DEC02Accident · 2 fatalFinal reportHoward Tierra II · Cambridge Jct, MIEntanglement of the emergency ballistic parachute with the airplane's propeller shaft after it deployed for an undetermined reason. A factor related to the accident was: the aircraft's weight and balance limit was exceeded by the pilot.NTSB CHI91LA198Accident · No injuriesLimited investigationFinal reportCessna 180 · Grayling, MIThe pilot in command's failure to maintain directional control during landing roll.NTSB CHI91LA195Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Cadillac, MIImproper preflight, inattentiveness, failure to maintain airspeed, and poor inflight planning/decision.NTSB CHI91LA192Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Marquette, MIThe pilot-in-command's failure to maintain proper altitude.NTSB CHI91LA190Accident · No injuriesLimited investigationFinal reportCessna 195 · Detroit, MIFailure to maintain directional control, and inadequate aircraft preflight. A factor related to the accident is the instructor pilot's lack of experience in the type aircraft.NTSB CHI91LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grass Lake, MIA ruptured oil cooler line. A factor associated with the accident was the lack of suitable terrain for the precautionary landing.NTSB CHI91FA181Accident · 2 fatalField investigationFinal reportCessna U206F · Muskegon, MIInadequate remedial action by the pilot after exhausting all the fuel from a selected fuel tank. Factors associated with the accident are the pilots inadequate transition and upgrade training and a lack of familiarity with the accident airplane.NTSB CHI91LA179Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Battle Creek, MIAircraft control by the dual student was not maintained, remedial action by the CFI was delayed, which resulted in a stall/mush. A factor related to the accident was rough water caused by a power boat wake.NTSB CHI91LA176Accident · No injuriesLimited investigationFinal reportCessna 152 II · Holland, MIThe pilot's failure to maintain control of the airplane during the touchdown and landing roll on a sod runway. Factors in the accident are the uneven terrain at the runway intersection, and the pilot's improper recovery from a bounced landing.NTSB CHI91LA171Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hillsdale, MIFailure of the pilot to maintain directional control during the takeoff ground run. A factor associated with the accident is the pilot's lack total experience.NTSB CHI91LA169Accident · No injuriesLimited investigationFinal reportCessna 172M · Cadillac, MIThe pilot-in-command's maintaining excessive airspeed through the landing touchdown which resulted in overrunning the runway.NTSB CHI91LA165Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Big Rapids, MIExcessive application of the flight controls by the student pilot. A factor related to the accident is delayed remedial action by the flight instructor.NTSB CHI91LA162Accident · No injuriesLimited investigationFinal reportCessna 177 · New Lothrop, MIFuel exhaustion and misjudged fuel calculations by the pilot. A factor was the lack of suitable terrain available for an emergency landing.NTSB CHI91FA160Accident · 1 fatalField investigationFinal reportCessna 210 · Belleville, MIFailure of the engine driven fuel pump, the failure of the pilot to activate the electric auxiliary fuel pump, poor inflight decision, and poor execution of emergency procedures. A factor relating to the accident is the pilot's lack of experience in this…NTSB CHI91FA159Accident · 1 fatalField investigationFinal reportLuscombe 8E · Clinton, MIPhysical impairment of the pilot due to heart attack.NTSB CHI91LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIRecovery from a bounced landing was improper by the pilot. Factors related to the accident were lack of recent experience by the pilot.NTSB CHI91LA148Accident · No injuriesLimited investigationFinal reportCessna 182L · Port Huron, MIThe pilot's inadequate landing flare during the forced landing. The pilot's failure to use carburetor heat was a factor.NTSB CHI91DEM05Accident · Serious injuriesFinal reportGildersleeve RV-4 · Ionia, MIRemedial action not performed by the pilot and the pilot's failure to assure the fuel selector was on the proper tank.NTSB CHI91LA146Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Ann Arbor, MILoss of engine power due to carburetor ice, and the pilot's failure to use carburetor heat. Factors related to the accident were: carburetor icing conditions, and a false indication from the carburetor air temperature gage.NTSB CHI91LA139Accident · No injuriesLimited investigationFinal reportCessna 172 · Detroit, MIThe proper touchdown point was not attained and the pilot failed to perform a go around. A factor related to the accident was the tailwind condition in which the pilot was attempting to land.NTSB CHI91DEM04Accident · No injuriesFinal reportFred B. Stencel Falcon X P · St. Charles, MIA result of the pilot in command not maintaining directional control during the go around maneuver. Factors associated with the accident were the pilot in command's lack of total experience and familiarity with the airplane.NTSB CHI91LA133Accident · No injuriesLimited investigationFinal reportCessna TR182 · Jackson, MIFailure to the pilot to assure gear extension. Factors related to the accident were the electrical failure due to a seized alternator and diverted attention by the pilot.NTSB CHI91LA132Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Fibre, MIThe pilot attempting to taxi on unsuitable terrain.NTSB CHI91LA131Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Grand Ledge, MIThe student's failure to maintain a proper altitude and clearance from the terrain along with the cfi's failure to adequately supervise the student's actions. A factor contributing to the accident was the inadequate visual lookout available due to the night…NTSB CHI91LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · West Branch, MIThe pilot's failure to follow recommeded starting procedures/directives and precautions.NTSB CHI91LA109Accident · No injuriesLimited investigationFinal reportCessna 172K · Bridgman, MIThe pilot's failure to correct a descent. A factor in the accident was the pilot's maneuvering at an improper altitude.NTSB CHI91LA118Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Flushing, MIThe pilot's failure to attain proper runway alignment and not maintaining directional control which resulted in a ground loop. Factors relating to this accident were the gusty crosswind conditions which existed at the time.NTSB CHI91LA104Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Genesee, MIPositive liftoff airspeed was not attained, an aborted takeoff was not performed which resulted in a stall/mush descent to the terrain. Factors related to the accident were a dark raining night, soft, wet grass runway and a downwind surface wind.NTSB CHI91DEM03Accident · No injuriesFinal reportHuddleston/Becktold Glasair · Lansing, MIFailure of the instructor pilot (CFI) to maintain sufficient airspeed on final approach to flare the aircraft for landing. Factors related to the accident were: the landing gear malfunction, and the cfi's improperly planned approach.NTSB CHI91DEC01Accident · 1 fatalFinal reportMocock Avid Amphibian · Milford, MIThe pilot's failure to maintain adequate airspeed during takeoff which resulted in a stall. A factor related to the accident were the gusty wind conditions.NTSB CHI91LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pinconning, MIInadequate airspeed, wind shear and a stall.NTSB CHI91LA052Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIThe deer crossing the runway which the pilot was unable to avoid.NTSB CHI91LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, MIThe pilot-in-command (CFI)'s inadequate supervision of the dual student.NTSB CHI91LA049Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Monroe, MIDirectional control not maintained by the PIC.NTSB CHI91DEM02Accident · 1 fatalFinal reportTaylorcraft BC12-D1 · North Muskegon, MIThe pilot-in-command's not maintaining sufficient airspeed and entering into an inadvertent stall. Factors related to this accident were fuel starvation and the pilot-in-command's not selecting a proper fuel tank selector position.NTSB CHI91IA041Incident · No injuriesIncident investigationFinal reportBoeing 727-257 · Detroit, MIThe inadequate deicing procedures instituted by company management.NTSB DCA91MA010Accident · 8 fatalClass 1 · MajorFinal reportMcdonnell Douglas DC-9-14 · Romulus, MILack of proper crew coordn, including virtual reversal of roles by the DC-9 plts, which led to their failure to stop taxiing & alert gnd ctlr of their positional uncertainty in a timely manner bfr & after intruding onto the active rwy. Contribuing to cause of…NTSB CHI91LA040Accident · No injuriesLimited investigationFinal reportCessna 182 · Howell, MIFuel exhaustion due to re-fueling not performed by the PIC. Contributing factors were fuel consumption calculations misjudged by the PIC.NTSB CHI91LA038Accident · No injuriesLimited investigationFinal reportCessna 150 · Grand Haven, MIDelayed application of carburetor heat by the PIC. Contributing factors were carburetor icing conditions (weather) and none suitable terrain.NTSB CHI91LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Muskegon, MIDirectional control not maintained by the PIC.NTSB CHI91LA036Accident · No injuriesLimited investigationFinal reportCessna T210M · Marshall, MIDirectional control not maintained by the PIC.NTSB CHI91FA031Accident · 4 fatalField investigationFinal reportPiper PA-32-RT300 · Gaylord, MIThe pilot's failure to maintain adequate terrain clearance. Factors which contributed to the accident were: the dark night, adverse weather conditions, and the pilot's overconfidence in continuing VFR flight into these conditions.NTSB CHI91FA026Accident · 1 fatalField investigationFinal reportCessna 182D · Walker, MIVFR flight into IMC conditions. Factors related to the accident are failure to obtain a preflight weather briefing, becoming lost/disoriented, induction air filter icing, excessive workload, and lack of total experience in type of operation.NTSB CHI91DEM01Accident · 1 fatalFinal reportErcoupe 415C · Shelby, MIThe pilot's continued flight into IMC.NTSB CHI91FA022Accident · 2 fatalField investigationFinal reportCessna 195 · Flint, MIThe pilot-in-command's inadequate preflight inspection of the fuel tank system. Factor(s) were: water contamination in the fuel.NTSB CHI91LA016Accident · No injuriesLimited investigationFinal reportCessna 152 · Muskegon, MIThe pilot's improper remedial action. His lack of total expereince was a factor.