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 CHI89DEM06Accident · No injuriesFinal reportCessna 152 · Manistee, MIThe partial loss of power during initial climbout, and the aircraft's subsequent nose over during the forced landing roll.NTSB CHI89LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Troy, MIThe pilot-in-command failed to properly compensate for unfavorable wind conditions.NTSB CHI89LA158Accident · No injuriesLimited investigationFinal reportBeech S35 · Lindon, MIThe restricted movement of the ruddervator control due to undetermined reasons.NTSB CHI89DEM05Accident · Minor injuriesFinal reportGatzemeyer 88 ACRO-SPORT II · Escanaba, MIA loose fuel line between the carburetor and engine which resulted in fuel starvation. A factor related to the accident was: no suitable terrain.NTSB CHI89LA149Accident · No injuriesLimited investigationFinal reportCessna 172M · Wixom, MICarburetor ice due to the pilot's improper use of carburetor heat. Factors related to the accident were: weather conditions conducive to carburetor ice, dark night, and tree(s) in the emergency landing area.NTSB CHI89DEM04Accident · No injuriesFinal reportCessna 175 · Lawton, MIThe pilot's delay in aborting takeoff and his excessive rate of descent at touchdown. A factor in the accident was the pilot's inadequate preflight planning.NTSB CHI89LA136Accident · No injuriesLimited investigationFinal reportCessna 335 · Pontiac, MIFailure of the right main landing gear extension/retraction component resulting from unacceptable loads incurred due to improper adjustment.NTSB CHI89LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Grosse Ile, MIThe student pilot's not correcting the porpoise on the first landing. A factor in the accident is the lack of experience of the student pilot.NTSB CHI89FA129Accident · 2 fatalField investigationFinal reportPiper PA-18 · Roscommon, MILoss of control in flight while maneuvering and the failure to perform remedial action by the PIC.NTSB CHI89FA128Accident · 3 fatalField investigationFinal reportBeech 58 · Battle Creek, MIThe flight crew inadvertently shut down the left engine after the right engine lost power, and the copilot failed to maintain control of the aircraft while maneuvering the aircraft back toward the runway. Factors related to the accident were: improper…NTSB CHI89LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Gladwin, MIFailure of the pilot seated in the left seat of the airplane to use brakes to correct for a left turn caused by a bent tail wheel.NTSB CHI89LA123Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Tecumseh, MILoss of engine power for an undetermined reason. The embankment (dirt bank) was a contributing factor.NTSB CHI89LA126Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Sebewaing, MIPilot's inattentive aircraft handling which resulted in his failure to detect and prevent the aircraft's descent into the wheat field.NTSB CHI89DEM03Accident · 2 fatalFinal reportBeneteau Steen Skybolt · Elk Rapids, MIThe pilot's failure to maintain aircraft control while attempting an aerobatic maneuver. Factors related to the were: inadequate altitude and lack of total experience in type of aircraft.NTSB CHI89LA116Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Port Huron, MIImproper in-flight planning/decision by the student pilot and his inadvertent encounter with wake turbulence from the transport aircraft. The student's lack of total experience was considered a contributing factor.NTSB CHI89LA107Accident · Serious injuriesLimited investigationFinal reportCessna 172I · New Era, MIThe pilot's misjudgement of the proper touchdown point.NTSB CHI89LA108Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Cedar, MIPilot in command attempting to land with too high an aispeed and with insufficient runway remaining to allow either a go around or the ability to bring the airplane to a stop in the space remaining.NTSB CHI89DEC05Accident · Serious injuriesFinal reportJob Sonerai II · Fowlerville, MIThe pilot's discontinuing visual lookout to scan gages before clearing a known obstacle on the departure path from the runway. A factor in the accident is the pilot's lack of experience in this model airplane.NTSB CHI89DEM02Accident · Minor injuriesFinal reportAeronca 15AC · Plainwell, MIThe pilot's decision to fly the airplane which had not been properly maintained which resulted in the fuel system blockage.NTSB CHI89LA103Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Milan, MIThe pilot's excessive rotation, which resulted in an inadvertent mushed stall and collision with trees.NTSB CHI89DEM01Accident · Serious injuriesFinal reportCessna 188A · Belding, MIThe pilot's poor preflight assessment of the runway condition/aircraft performance capabilities, and the aircraft's resultant failure to attain flying speed. Soft terrain is a factor in the accident.NTSB CHI89LA102Accident · No injuriesLimited investigationFinal reportCessna 206 · Flushing, MIPilot's inadequate aircraft control during the aborted takeoff attempt, and the aircraft's resultant collision with trees. The wet runway was a factor in the lack of normal braking action.NTSB CHI89LA100Accident · No injuriesLimited investigationFinal reportCessna P206B · New Hudson, MIPilot's inadequate preflight which resulted in an engine failure due to water contamination of the fuel system. The wires, trees, and utility pole were related factors.NTSB CHI89LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Houghton, MIImproper planning/decision by the pilot, which resulted in fuel exhaustion from lack of fuel. Factors related to the accident were: obstructions (road sign & guard rail) in the emergency landing area.NTSB CHI89DET05Accident · 2 fatalFinal reportBillings/White Avid Flyer · Niles, MILoose carburetor(s) due to improper maintenance/installation, which resulted in fuel starvation and loss of engine power; and failure of the pilot to maintain adequate airspeed while maneuvering for a forced landing, which resulted in an inadvertent stall and…NTSB CHI89LA093Accident · No injuriesLimited investigationFinal reportCessna 140 · Linden, MIThe pilot's poor judgement, poor aircraft handling, and the resultant hard touchdown.NTSB CHI89LA090Accident · No injuriesLimited investigationFinal reportCessna 150 L · Eureka, MIStudent pilot's improper aircraft control during the takeoff roll, and the subsequent aborted takeoff was performed with insufficient runway remaining to successfully stop the aircraft before the departure end of the runway.NTSB CHI89LA088Accident · No injuriesLimited investigationFinal reportAvions Max Holste MH 1521 · Big Rapids, MIInadequate compensation for wind conditions by the pilot and his failure to maintain directional control. The the variable/gusty/crosswind condition was considered to be a contributing factor.NTSB CHI89LA086Accident · No injuriesLimited investigationFinal reportPorterfield CP-55 · Tecumseh, MIPilot's inadequate preflight operatins, which failed to detect the presence of water contamination in the fuel system, and resulted in the substantial loss of power and subsequent forced landing. The aircraft encountered soft, loose soil during the forced…NTSB CHI89LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Flint, MIThe pilot-in-command's failure to follow proper procedures and directives and his premature decision to initiate an emergency procedure. Contributing factors were the pilot's lack of total experience and his selection of unsuitable terrain for the emergency…NTSB CHI89LA082Accident · Minor injuriesLimited investigationFinal reportCessna 320D · Wixom, MIPilot's inattention to the fuel system during preflight and inadequate fuel system monitoring throughout the flight.NTSB CHI89LA080Accident · No injuriesLimited investigationFinal reportCessna 411 · Detroit, MIFailure of a bolt in the left main landing gear assembly.NTSB CHI89LA076Accident · No injuriesLimited investigationFinal reportWaco YMF · Lansing, MIPilot's failure to maintain directional control during the landing roll, and his excessive brake application as the aircraft departed the runway, which resulted in the aircraft nosing over. The pilot's inexperience in taildragger aircraft, and the inadequate…NTSB CHI89DEC04Accident · Minor injuriesFinal reportBridges LONG-EZ · Rochester Hills, MIThe pilot's decision to takeoff from unsuitable terrain which resulted in damage to the propeller and nose gear.NTSB CHI89LA067Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Allegan, MIImproper use of flight controls by the student pilot, which resulted in his loss of directional control and an inadvertent ground swerve; and the instructor pilot's (cfi's) inadequate supervision. Factors related to the accident were: the crosswind condition,…NTSB CHI89FA064Accident · 1 fatalField investigationFinal reportCessna 150L · Clawson, MIThe pilot allowing the airspeed to decay below the airplanes stall speed.NTSB CHI89FA061Accident · 1 fatalField investigationFinal reportCessna 150M · Corunna, MIThe failure of the student pilot to maintain sufficient altitude to recover from a practice stall maneuver. A factor related to the accident was: the pilot's visual perception over snow covered terrain.NTSB CHI89DEC03Accident · Minor injuriesFinal reportPiper PA-28 · Birmingham, MIAn undetermined fuel system blockage. Contributing to the accident was the lack of a suitable forced landing area.NTSB CHI89DEC02Accident · Serious injuriesFinal reportPiper PA-28R-201 · Brighton, MIInstallation of an improper oil drain valve by other maintenance personnel and their failure to follow the applicable airworthiness directive (AD 81-11-02/R1), resulting in subsequent interference between the landing gear and oil drain valve. This caused the…NTSB CHI89LA043Accident · No injuriesLimited investigationFinal reportCessna T303 · Romeo, MIThe failure of the left main landing gear assembly due to stress corrosion.NTSB CHI89LA041Accident · No injuriesLimited investigationFinal reportCessna 152II · Grand Rapids, MIPilot's total lack of experience in this type of operation.NTSB CHI89DET02Accident · No injuriesFinal reportCessna 150H · Benton Harbor, MIA misjudged approach during the execution of an emergency landing resulting in an encounter with unsuitable terrain. Contributing factors are inaccurate fuel consumption calculations and fuel starvation due to contamination.NTSB CHI89LA033Accident · No injuriesLimited investigationFinal reportCessna 414 · Pontiac, MINTSB CHI89LA028Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Marquette, MIAfter encountering unforecast adverse wx at his intended destn, the plt circled the area a couple of times, then diverted to Marquette, MI. However, before reaching the alternate arpt, the eng lost power due to fuel exhaustion. Subsequently, the acft collided…NTSB CHI89LA025Accident · No injuriesLimited investigationFinal reportCessna 172P · Samaria, MINTSB CHI89LA022Accident · No injuriesLimited investigationFinal reportCessna 150J · Carson City, MINTSB CHI89LA013Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Big Rapids, MIThe pilot stated that he failed to maintain sufficient airspeed and altitude during an IFR circle-to-land maneuver. The pilot reported that when he thought he was going to overshoot final, he tightened up the bank. The aircraft stalled and the left wing…NTSB CHI89DEC01Accident · No injuriesFinal reportExperimental Barracuda · Ypsilanti, MIPilot's failure to maintain control of the aircraft during landing and inability to appropriately correct for the porpoise action of the aircraft.NTSB CHI89FA009Accident · 2 fatalField investigationFinal reportMooney M20J · Ludington, MIThe pilot in command failed to maintain proper altitude utilizing basic flight instruments while experiencing a loss of gyro instruments.NTSB CHI89DET01Accident · 1 fatalFinal reportVolksplane VP-1 · Coldwater, MIA stall with entry into the incipient stage of a spin with insufficient altitude for recovery.