NTSB investigations, MI
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 CHI93LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIFailure of the student pilot to maintain directional control.NTSB CHI93IA078Incident · No injuriesIncident investigationFinal reportFokker F-28 MK 1000 · Detroit, MIImproper lubrication of the horizontal stabilizer gearbox by company maintenance personnel. A factor was the manufacturer's inadequate service procedure.NTSB CHI93IA068Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Detroit, MIThe manufacturer's inadequate design of the fuel transfer tube system, which loosened/disconnected during engine operation.NTSB CHI93FA063Accident · 3 fatalField investigationFinal reportCessna T337G · Smiths Creek, MIThe pilot-in-command's failure to maintain control of the airplane during the approach. Factors which contributed to the accident were the adverse weather conditions and the dark night.NTSB CHI93FA054Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Gaylord, MIThe pilot-in-command exceeded the airplane's design stress limits.NTSB CHI93LA049Accident · No injuriesLimited investigationFinal reportCessna 150F · Oshtemo, MIImproper use of carburetor heat by the pilot-in-command.NTSB CHI93LA016Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Ludington, MIThe partial loss of engine power during the initial climb out on a night flight.NTSB CHI93LA018Accident · 1 fatalLimited investigationFinal reportAmerican Eagle 101 · New Hudson, MIThe pilot's failure to maintain aircraft control.NTSB CHI93LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Saline, MIThe pilot's failure to maintain aircraft control and airspeed.NTSB CHI93LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Hillsdale, MIInadequate preflight planning in not refueling the aircraft and a poorly planned forced landing by the pilot.NTSB CHI93LA008Accident · No injuriesLimited investigationFinal reportCessna 150M · Romeo, MIInadequate compensation for wind conditions by the pilot in command and failure to attain directional control of the airplane during landing flare and touchdown.NTSB CHI93LA002Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · West Branch, MIThe pilot's failure to maintain aircraft control during the landing roll.NTSB CHI92LA291Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lansing, MIThe pilot's inadequate planning and decision-making.NTSB CHI92FA280Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Pullman, MIThe pilot in command's exceeding the design stress limits of the aircraft.NTSB CHI92LA278Accident · No injuriesLimited investigationFinal reportCessna 172P · Yipslanti, MIThe pilot's premature flare during landing and not performing a recovery from a bounced landing.NTSB CHI92LA275Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Caledonia, MIFailure of the pilot in command to maintain directional control during a landing rollout.NTSB CHI92DEC04Accident · Serious injuriesFinal reportTennessee Engineering & Manf Z-MAX · Manchester, MIAn inadequate design of the rudder control system by the pilot/builder of the airplane, a pullup performed by the pilot, and a total failure of the rudder flight control system.NTSB CHI92LA274Accident · No injuriesLimited investigationFinal reportCessna 172P · St. Charles, MIThe jamming of the oil pressure pump caused by the failure of the oil pressure pump driven impeller. The lack of a suitable landing area was a factor.NTSB CHI92FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna 150H · Manistee, MIUndeterminedNTSB CHI92LA276Accident · No injuriesLimited investigationFinal reportCessna 150J · Marlette, MIThe pilot-in-command's (CFI) inadequate supervision of the dual student pilot and the dual student's inadvertent application of the brakes.NTSB CHI92LA270Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Petersburg, MIInadequate visual lookout by the pilot in command during final approach. A factor in the accident was the sunglare.NTSB CHI92LA265Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Moran, MIThe pilot-in-command's improper selection of fuel tank resulting in fuel starvation. A factor was the pilot-in-command's encounter with unsuitable terrain.NTSB CHI92LA263Accident · No injuriesLimited investigationFinal reportCessna 402B · Almont, MIExcessive fuel system pump pressure and corresponding excessive fuel pressure and the pilot not maintaining the best single engine climb speed.NTSB CHI92FA254Accident · 1 fatalField investigationFinal reportCessna 172N · Marquette, MIThe pilot's failure to maintain proper altitude during the approach.NTSB CHI92DEM05Accident · Serious injuriesFinal reportTaylorcraft H-2 · Holland, MINot maintaining a sufficient airspeed during the reversal turn and encountering a stall/spin maneuver.NTSB CHI92LA247Accident · No injuriesLimited investigationFinal reportCessna 152 · Houghton Lake, MIA premature lift-off.NTSB CHI92LA243Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Owosso, MIFuel starvation which resulted from the pilot having selected the wrong fuel tank. Factors related to the accident were poor aircraft preflight and the unreliable fuel quantity gauges.NTSB CHI92LA242Accident · No injuriesLimited investigationFinal reportCessna 182R · Litchfield, MIThe pilot-in-command's failure to use all available runway and his not aborting the takeoff when the wing contacted the corn. A factor was the corn along side the runway.NTSB CHI92LA253Accident · No injuriesLimited investigationFinal reportLake LA-4 · Pontiac, MIThe instructor pilot's directing a turn to change heading in the flare.NTSB CHI92LA238Accident · No injuriesLimited investigationFinal reportBeech A36 · Ann Arbor, MIFuel starvation for undetermined reasons. Factors related to the accident were in blown fuse which rendered the boost pump inoperative and the rough terrain in which the emergency landing was made.NTSB CHI92LA239Accident · No injuriesLimited investigationFinal reportCessna 182BTW · Plymouth, MIAn inadvertent ground loop.NTSB CHI92LA237Accident · No injuriesLimited investigationFinal reportBeech C90 · Pontiac, MIThe pilot's not understanding the fuel system, and his subsequent inadvertent discontinuance of fuel to both engines.NTSB CHI92LA226Accident · Serious injuriesLimited investigationFinal reportCessna 175A · East Lansing, MIThe pilot's inadequate preflight inspection of the aircraft which resulted in a loss of engine power during cruise flight. Related factors are the loose oil filler cap, and the short, wet grass strip used for the emergency landing.NTSB CHI92DEC03Accident · 1 fatalFinal reportJarrell RV-3 · Jackson, MIAn overload and total failure of the rear wing attach fitting.NTSB CHI92FA228Accident · 3 fatalField investigationFinal reportCessna 172H · Grayling, MIThe pilot's failure to maintain aircraft control.NTSB CHI92DEC02Accident · 1 fatalFinal reportRans S-9 · Mason, MIThe pilot's over-confidence in his personal ability, his lack of experience in the type airplane he was flying, and the fact the pilot did not maintain a proper airspeed.NTSB CHI92LA214Accident · No injuriesLimited investigationFinal reportCessna A185E · Cadillac, MIThe pilot's premature liftoff and subsequent stall mush.NTSB CHI92DEM04Accident · Serious injuriesFinal reportHauser, William C. Cassutt · Winn, MIThe ditch the airplane encountered during the landing roll phase of a forced landing.NTSB CHI92FAMS2Accident · 4 fatalMissing aircraftFinal reportCessna 172N · Lake Michigan, MIUndetermined.NTSB CHI92LA209Accident · No injuriesLimited investigationFinal reportBeech E35 · Escanaba, MIThe pilot's decision to fly into known adverse weather conditions.NTSB CHI92LA204Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Ortonville, MIImproper use of the fuel tank selector switch and inadequate emergency procedures by the pilot in command.NTSB CHI92DEM03Accident · Minor injuriesFinal reportJohansen Kitfox · Gowen, MIA total failure of the ignition system spark plugs and unsuitable terrain encountered by the pilot.NTSB CHI92LA197Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Manchester, MIThe pilot's improper inflight planning/decisions, failure to make a precautionary landing when he realized he was too low to reach the airport, and attempting to stretch his glidepath to reach the runway.NTSB CHI92LA191Accident · No injuriesLimited investigationFinal reportCessna 152 · East Tawas, MIThe pilot's failure to adequately compensate for the wind conditions and failure to properly flare the airplane. Contributing to the accident was the crosswind condition.NTSB CHI92LA186Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Napoleon, MIAn inadvertent stall on takeoff.NTSB CHI92LA185Accident · No injuriesLimited investigationFinal reportCessna 150H · Three Rivers, MIThe pilot-in-command's selection of a rough and uneven terrain. A factor related to the accident was the pilot-in-command's poor inflight decision making.NTSB CHI92FA183Accident · 1 fatalField investigationFinal reportPiper PA-28-180D · Troy, MIThe pilot's failure to maintain control of the airplane.NTSB CHI92LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Indian River, MIAn on ground collision with a deer during a landing ground roll.NTSB CHI92LA168Accident · No injuriesLimited investigationFinal reportCessna 172M · Hastings, MIThe pilot-in-command's misjudgement of the touchdown point which resulted in an undershoot and damage to the elevator. In addition, the pilot-in-command failed to properly inspect the airplane for damage prior to further flight.NTSB CHI92LA164Accident · Serious injuriesLimited investigationFinal reportGrumman AA5B · Charlotte, MIThe pedestrian's failure to maintain visual outlook and separation from the taxiing aircraft.