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 CHI97LA206Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Mackinac Island, MIthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing. Turbulence on short final was a related factor.NTSB CHI97LA194Accident · 2 fatalLimited investigationFinal reportCessna 170B · Karlin, MIthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his inadequate visual lookout while buzzing, which resulted in failure to see-and-avoid the top (ground/static) wires of an electrical power line.NTSB CHI97IA195Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-30 · Flint, MIAn electrical short in the wiring of the left wingtip oscillating position light auto transformer and a failure of the system circuit breaker.NTSB CHI97LA190Accident · Serious injuriesLimited investigationFinal reportDietrich Nieuport 12 · Byron, MIThe owner/pilot mechanic's inadequate inspection of the aircraft which led to contamination (other than water) of the fuel filter.NTSB CHI97LA189Accident · No injuriesLimited investigationFinal reportCessna 172P · Fowlerville, MIfailure of the pilot to either attain proper touchdown point for landing or go around while he had sufficient airspeed and runway remaining.NTSB CHI97LA186Accident · Minor injuriesLimited investigationFinal reportHulliberger Starduster II · Berrien Springs, MIthe failure of the landing gear axle due to fatigue.NTSB CHI97FA188Accident · Serious injuriesField investigationFinal reportCessna 172N · Canton, MIA loss of engine power due to fuel starvation from a binding throttle/power lever cable. Also causal was the improper maintenance, installation of the throttle arm. Contributing to the accident were the dark night and unsuitable terrain for the forced landing.NTSB CHI97FA187Accident · Serious injuriesField investigationFinal reportPiper PA-22-108 · Lenox Township, MIThe pilot's failure to follow the procedures and directives as listed on the placard in the aircraft resulting in fuel starvation and subsequent engine failure.NTSB CHI97LA181Accident · No injuriesLimited investigationFinal reportCessna 172M · Grosse Ile, MIthe instructor pilot's inadequate planning/decision, resulting in an inadvertent stall situation.NTSB CHI97LA172Accident · No injuriesLimited investigationFinal reportCessna 150K · Ypsilanti, MIthe pilot's failure to use carburetor heat, which resulted in carburetor ice, loss of engine power, and a forced landing. Factors relating to this accident were: the icing (weather) condition and sign(s) in the emergency landing area.NTSB CHI97LA171Accident · Serious injuriesLimited investigationFinal reportRoe-Wayne Mustang II · Portage, MIinadequate fuel system design by the owner/builder, which led to fuel starvation as the airplane was on a 'flat' approach to land. The pilot's inadequate flight planning was a factor, in that he did not fly the traffic pattern of this first test flight, in a…NTSB CHI97LA156Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Gregory, MIThe pilot's improper planning/decision. The tailwind and location of trees were related factors.NTSB CHI97LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Alanson, MIinadequate preflight by the pilot, which resulted in fuel starvation, due to an improper fuel tank selector position. A factor relating to the accident was: the pilot's improper inflight planning/decision, which resulted in his delay or inability to flare the…NTSB CHI97LA148Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Houghton, MIthe pilot's improper starting procedures and failure to set the parking brakes.NTSB CHI97LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Flushing, MIwas the pilot not maintaining sufficient altitude to clear obstructions. A factor associated with the accident was the pilot was inattentive to the airplane's altitude.NTSB CHI97LA136Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Flushing, MIthe pilot's misjudgment of distance and speed on final approach, his failure to attain the proper touchdown point for landing, and his delay in initiating a go-around (aborted landing). Factors related to the accident were: darkness, and the proximity of…NTSB CHI97LA139Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Rogers City, MIthe disconnection of the tailwheel spring which resulted in the pilot's inability to maintain directional control of the airplane.NTSB CHI97FA116Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Holland, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent impact with trees and then a residence. A related factor was turbulence.NTSB CHI97FAMS2Accident · 2 fatalMissing aircraftFinal reportBeech 95-C55 · Grand Haven, MIundetermined.NTSB CHI97FA083Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-9-87 · Detroit, MIthe captains failure to have the airplane deiced prior to takeoff which resulted in ice ingestion into both engines. Factors associated with the accident were the icing weather conditions, wing ice, an inadequate detection of the ice during the preflight, and…NTSB CHI97LA085Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Marquette, MImultiple oil leaks in the engine lubrication system. Factors were the disconnected wet vacuum pump line and the oil exhaustion.NTSB CHI97LA079Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Monroe, MIthe pilot failed to maintain directional control of the aircraft during landing. Factors included the inadequate compensation for the crosswind conditions, the crosswind, and gusts.NTSB CHI97IA073Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Romulus, MIa fractured fusion weld in the piston of the roll spoiler servoactuator, which allowed the plug at the base of the piston to separate and jam the piston. A factor relating to the incident was: the inadequate design of the airplane's roll spoiler servoactuator…NTSB CHI97LA064Accident · No injuriesLimited investigationFinal reportCessna 150G · Dowagiac, MIthe pilot's failure to maintain directional control. A factor was the snowbank.NTSB CHI97LA065Accident · No injuriesLimited investigationFinal reportCessna 182J · Gaylord, MIthe student pilot's inadequate compensation for the wind conditions which resulted in a failure to maintain proper runway alignment. Factors associated with the accident were: the gusty, crosswind condition, the pilot's failure to perform a go-around, and the…NTSB CHI97FA056Accident · 2 fatalField investigationFinal reportCessna 210N · Highland, MIin-flight breakup of the airplane for undetermined reason(s).NTSB CHI97LA051Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIthe pilot's failure to maintain proper runway alignment during the takeoff roll. A factor associated with the accident was the snowbank which the airplane contacted.NTSB DCA97MA017Accident · 29 fatalClass 1 · MajorFinal reportEmbraer EMB-120RT · Monroe, MIThe Federal Aviation Adminstration's (FAA) failure to establish adequate aircraft certification standards for flight in icing conditions, the FAA's failure to ensure that at Centro Tecnico Aeroespacial/FAA-approved procedure for the accident airplane's deice…NTSB CHI97LA048Accident · Minor injuriesLimited investigationFinal reportCessna 402A · Menominee, MIice restricting normal brake system, normal braking not possible for the pilot and the pilot's poor in-flight planning. A factor was the pilot not performing a flight to an alternate destination airport.NTSB CHI97LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · New Hudson, MIloss of engine power for undetermined reason(s). Darkness was a related factor.NTSB CHI97IA034Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320-211 · Romulus, MIrestricted movement of the autopilot mode engagement/disengagement lever bearing in the rudder artificial feel and trim unit. A factor relating to this incident was: company management not implementing the respective service bulletin.NTSB CHI97LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hart, MIthe pilot's failure to maintain directional control on rollout.NTSB CHI97FA030Accident · Serious injuriesField investigationFinal reportBoeing 737-222 · Grand Rapids, MIa passenger sustained a fractured ankle during an emergency evacuation for undetermined reasons.NTSB CHI97LA019Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-235 · Hubbard Lake, MIthe pilot's inadequate compensation for wind conditions, and failure to maintain proper alignment with the airstreip during the go-around (aborted landing). The crosswind and proximity of trees were related factors.NTSB CHI97LA018Accident · 1 fatalLimited investigationFinal reportFrost RAF 2000 GTX SE · Adrian, MIthe pilot's failure to maintain control of the aircraft. A factor was his lack of familiarity with the airplane.NTSB CHI97LA016Accident · 1 fatalLimited investigationFinal reportHughes 369 · Vestaburg, MIfailure of the pilot to maintain clearance with the wires.NTSB CHI97LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Jenison, MIthe pilot's inadequate compensation for the wind conditions. A factor was the crosswind condition.NTSB CHI97LA012Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Mancelona, MIthe worn fuel system pump (actuator arm). A factor was the unsuitable terrain encountered by the pilot.NTSB CHI97LA010Accident · 2 fatalLimited investigationFinal reportDellicker Starduster TOO SA300 · Eaton Rapids, MIthe pilot's failure to maintain adequate airspeed and subsequent inadvertent stall of the airplane. A factor was the ostentatious display.NTSB CHI97LA007Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Hillsdale, MIthe pilot's improper in-flight planning/decision and failure to refuel which led to fuel exhaustion.NTSB CHI97LA001Accident · No injuriesLimited investigationFinal reportCessna 140A · Allegan, MIthe pilot's failure to maintain directional control during landing.NTSB CHI96FA342Accident · Serious injuriesField investigationFinal reportGrumman F9F-2 · Kalamazoo, MIThe overrun of the runway as a result of the pilot's misjudgment of speed and distance because of an unreliable airspeed indication; reason for the unreliable airspeed indication was undetermined. Contributing to the accident was the pilot's perception of a…NTSB CHI96LA336Accident · Serious injuriesLimited investigationFinal reportKenoyer Horizon ONE · Owosso, MIthe pilot's failure to maintain aircraft control and airspeed. A factor was the pilot's lack of experience in type of aircraft.NTSB CHI96LA329Accident · No injuriesLimited investigationFinal reportCessna 172 · Wellston, MIThe pilot failed to maintain control of the aircraft. Factors were the rough road, the tree, and the tire.NTSB CHI96FA332Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12D · Bellaire, MIthe pilot's improper remedial action, while recovering from an intentional stall, which resulted in an inadvertent spin and collision with the terrain. The lack of altitude for recovery was a related factor.NTSB CHI96FA324Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Grosse Ile, MIthe pilot exceeding the critical angle of bank required to maintain altitude.NTSB CHI96LA325Accident · 1 fatalLimited investigationFinal reportKarr Titan Tornado · Union Pier, MIthe pilot not obtaining/maintaining altitude/clearance. Factors were the pilot not maintaining aircraft control and intentional aerobatics.NTSB CHI96LA308Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Grosse Ile, MIimproper attachment of the flight control cables to the ailerons by the mechanic who performed the last annual inspection. A factor relating to this accident was the pilot's failure to perform an adequate check of the flight controls before takeoff.NTSB CHI96FA316Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hartford, MIinaccurate fuel consumption calculations by the pilot before takeoff, and his improper decision not to land before his airplane ran out of fuel.NTSB CHI96LA304Accident · No injuriesLimited investigationFinal reportCessna 150M · Traverse City, MIthe failure of the pilot of the Cessna 180, N2406C, to maintaining proper spacing from the Cessna 150M, N9352U. A factor relating to this accident was the Cessna 180 pilot's diverted attention.