NTSB investigations, MI
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 CEN09LA567Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Marshall, MIThe failure of the main landing gear attach point.NTSB CEN09CA577Accident · No injuriesData collectionFinal reportKetonen Schreder · Ionia, MIThe pilot failed to maintain control of the glider during the aero-tow launch.NTSB CEN09LA557Accident · No injuriesLimited investigationFinal reportCessna 150F · Rosedale, MIThe pilot's failure to maintain directional control during the takeoff ground run. Contributing to the accident were the pilot's deteriorated physical and mental capabilities.NTSB CEN09CA568Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-1C · Holland, MIThe pilot's failure to maintain control of the airplane during the landing and subsequent go-around.NTSB CEN09CA554Accident · No injuriesData collectionFinal reportSocata TBM 700 · Ann Arbor, MIThe pilot's hard landing during gusty wind conditions.NTSB CEN09CA545Accident · Minor injuriesData collectionFinal reportDekkinga Vans RV-7A · Jenison, MIThe pilot's failure to maintain aircraft control during the landing.NTSB CEN09LA549Accident · 1 fatalLimited investigationFinal reportPiper PA-15 · Lakeview, MIThe pilot's failure to maintain control of the airplane.NTSB CEN09CA559Accident · No injuriesData collectionFinal reportNavion Navion G · Eau Claire, MIA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management.NTSB CEN09CA548Accident · No injuriesData collectionFinal reportPiper PA-15 · Plainwell, MIA loss of control on takeoff for undetermined reasons.NTSB CEN09CA517Accident · No injuriesData collectionFinal reportBell 47G-2A · Covert, MIA loss of engine power due to fuel starvation as a result of blocked fuel vents.NTSB CEN09CA513Accident · No injuriesData collectionFinal reportBeech A36TC · Brighton, MIThe pilot's failure to maintain airspeed and compensate for wind conditions during final approach.NTSB CEN09LA512Accident · 1 fatalLimited investigationFinal reportHooper James A Bushby MUS · Gladwin, MIThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB CEN09LA502Accident · Serious injuriesLimited investigationFinal reportCessna 337F · Frankfort, MIThe pilot intentionally attempting to take off with an inoperative engine, which lead to the airplane's inability to maintain airspeed in the initial climb, resulting in a stall and impact with trees.NTSB CEN09IA606Incident · No injuriesIncident investigationFinal reportSaab 340B · Traverse City, MIThe flight attendant's incapacitation due to an anxiety attack.NTSB CEN09CA485Accident · No injuriesData collectionFinal reportTaylorcraft BC12-65 · Flushing, MIThe pilot's failure to maintain adequate descent rate and airspeed on final resulting in a hard landing.NTSB CEN09LA467Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BF12 · Sawyer, MIThe pilot's failure to maintain adequate airspeed while taking off from a short, grass runway.NTSB CEN09CA426Accident · No injuriesData collectionFinal reportCessna A188B · South Haven, MIThe pilot's failure to maintain directional control during landing.NTSB CEN09LA353Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G103C Twin III Acro · Gregory, MIThe pilot's failure to maintain sufficient airspeed during the turn to return for landing, which resulted an inadvertent stall/spin. Contributing to the accident was the failure of the ground winch tow cable shortly after takeoff.NTSB CEN09CA338Accident · Minor injuriesData collectionFinal reportGarrett Rans S-6ES · Williamsburg, MIThe pilot/builder's improper installation of the fuel line cable-tie, which resulted in fuel starvation and the loss of engine power.NTSB CEN09LA319Accident · No injuriesLimited investigationFinal reportMileski Zenair · New Hudson, MIThe pilot's improper flare which resulted in a hard landing and subsequent failure of the nose landing gear.NTSB CEN09CA334Accident · Minor injuriesData collectionFinal reportAerotrike Safari · Lake City, MIThe pilot's failure to maintain adequate airspeed during the initial climb.NTSB CEN09LA311Accident · 2 fatalLimited investigationFinal reportThornton RV-6A · Plainwell, MIThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB CEN09LA291Accident · No injuriesLimited investigationFinal reportUnivair Ercoupe · Brighton, MIThe pilot's failure to attain the proper touchdown point, and his failure to initiate a go-around.NTSB CEN09CA269Accident · No injuriesData collectionFinal reportLet L-23 Super Blanik · Adrian, MIThe flight instructor's inadequate compensation for the strong, gusting crosswind during landing. Contributing to the accident was the flight instructor's decision to attempt flight with known adverse weather approaching the airport.NTSB CEN09LA122Accident · No injuriesLimited investigationFinal reportBeech A36TC · Three Rivers, MIThe pilot's decision to continue the flight into an area with conditions that were conducive to icing and the loss of engine power due to induction icing.NTSB CEN09FA083Accident · 1 fatalField investigationFinal reportCessna 206H · Kalkaska, MIThe pilot's failure to maintain clearance from trees and terrain during the instrument-flight-rules flight. Contributing to the accident was the pilot's failure to comply with instrument flight procedures and his lack of recent instrument flight experience.NTSB DCA09FA011Accident · Minor injuriesField investigationFinal reportBombardier CL-600-2B19 · Detroit, MIThe lack of vigilance on the part of the ramp agent driving the baggage tug. Contributing factors include the night conditions, and low visibility due to fog and rain.NTSB CEN09FA015Accident · 1 fatalField investigationFinal reportCessna 150G · Cedar Lake, MIThe student pilot's failure to maintain adequate clearance after takeoff. Contributing to the accident was the pilot's overall lack of flight experience.NTSB CEN09CA006Accident · Minor injuriesData collectionFinal reportBeech 23 · Chesaning, MIThe pilot's failure to adequately compensate for the gusting wind conditions during landing. Contributing to the accident were the gusting winds.NTSB CHI08CA278Accident · No injuriesData collectionFinal reportCessna 185 · Newberry, MIThe pilot's failure to maintain clearance from the wires on approach. Contributing to the accident was the sunshine, as reported by the pilot.NTSB CHI08CA271Accident · No injuriesData collectionFinal reportCessna T182T · Munising, MIThe inadequate preflight planning/preparation by the pilot to carry a hazardous material aboard an airplane that resulted in a fire during an after-landing taxi.NTSB CHI08CA275Accident · No injuriesData collectionFinal reportCessna 150H · Bay City, MIThe loss of engine power during descent due to carburetor icing. Contributing to the accident was the collapse of the nose landing gear due to rough terrain.NTSB CHI08CA263Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Greenville, MIThe deer that ran onto the runway contacting the airplane. A factor associated with the accident was the dark night conditions.NTSB CHI08CA264Accident · No injuriesData collectionFinal reportCessna 172 · Pullman, MIA complete loss of engine power for undetermined reasons. A contributing factor was the rough terrain encountered during the forced landing.NTSB CHI08CA298Accident · No injuriesData collectionFinal reportLake LA-4 · Algonac, MIThe amphibious airplane's collision with submerged debris during taxi for takeoff, and the resulting damage to the hull.NTSB CHI08CA259Accident · No injuriesData collectionFinal reportPiper PA-34-200T · East Tawas, MIThe pilot's failure to lower the landing gear prior to touchdown.NTSB CHI08TA239Accident · No injuriesFinal reportEurocopter AS-350-B3 · Mount Clemens, MIThe pilot's unintentional lowering of the collective control during approach to land, resulting in a hard landing.NTSB CHI08CA236Accident · No injuriesData collectionFinal reportBeech H35 · Bay City, MIThe checklist not followed and the inadvertent wheels up landing by the pilot.NTSB CHI08CA229Accident · No injuriesData collectionFinal reportPrendergast RV-7A · Manchester, MIThe pilot's inadequate flare during landing. Contributing to the accident was the uneven terrain.NTSB CHI08CA225Accident · Serious injuriesData collectionFinal reportAero Commander 200D · Tecumseh, MIThe pilot flaring too high, and his inadvertent pilot-induced oscillation during the landing flare/touchdown. Contributing to the accident was the collapse of the nose landing gear.NTSB CHI08CA206Accident · Minor injuriesData collectionFinal reportPiper PA-28-235 · Lowell, MIThe inadequate preflight planning/preparation and the short field takeoff procedure not followed by the pilot. An additional cause was the delayed aborted takeoff by the pilot. A contributing factor was the trees.NTSB CHI08LA191Accident · 1 fatalLimited investigationFinal reportDrochak Aventura II · Flushing, MIA loss of engine power for undetermined reasons.NTSB CHI08CA178Accident · No injuriesData collectionFinal reportMooney M20K · Howell, MIThe collision with a deer during the takeoff roll. Contributing to the accident was the dusk light condition.NTSB CHI08CA194Accident · Minor injuriesData collectionFinal reportCessna 150F · Johannesburg, MIThe pilot's failure to recognize the onset of carburetor icing resulting in a loss of engine power and the unsuitable terrain encountered during the forced landing. Contributing to the accident were the carburetor icing conditions, and the rough terrain.NTSB CHI08LA160Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Battle Creek, MIThe in-flight separation of the tip of a propeller blade due to metal fatigue that resulted from an inadequate inspection and repair.NTSB CHI08FA141Accident · Serious injuriesField investigationFinal reportSikorsky S-76A · Grand Rapids, MIThe pilot's failure to maintain tail rotor obstacle clearance from a tower during takeoff.NTSB CHI08FA132Accident · 1 fatalField investigationFinal reportFairchild Hiller FH-1100 · Comstock, MIA loss of engine power in flight due to fuel exhaustion resulting from the pilot's inadequate fuel management. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB CHI08LA129Accident · No injuriesLimited investigationFinal reportCessna 208B · Ada, MIA loss of engine power for undetermined reasons.NTSB CHI08CA136Accident · Serious injuriesData collectionFinal reportSchleicher AS-K13 · Gregory, MIThe pilot's failure to adequately secure his handheld radio prior to takeoff, which resulted in a restriction of the flight control stick and loss of control. Contributing to the accident was the stall/mush flight condition encountered after the glider…NTSB CHI08CA118Accident · No injuriesData collectionFinal reportLuscombe 8A · Remus, MIThe loss of engine power during approach due to fuel contamination. Contributing to the accident were the unsuitable terrain and a tree.