NTSB investigations, MI
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 CEN18FA160Accident · 2 fatalField investigationFinal reportBelair Raven · Sault Ste Marie, MIThe pilot's failure to maintain adequate airspeed during takeoff in gusty crosswind conditions, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.NTSB CEN18LA150Accident · 2 fatalLimited investigationFinal reportWolfe Kitfox V · Kalkaska, MIThe pilot's failure to maintain airplane control that resulted in a stall/spin following climb from the departure airport.NTSB CEN18LA123Accident · 1 fatalLimited investigationFinal reportMills Michael S1L · Dewitt, MIThe pilot's failure to see and avoid power lines due to sun glare.NTSB GAA18CA155Accident · No injuriesData collectionFinal reportLearjet 31 · Mount Pleasant, MIThe airplane’s collision with deer during the landing roll.NTSB CEN18LA112Accident · No injuriesLimited investigationFinal reportPiper PA 28 · Mackinac Island, MIThe improper reinstallation of the right main landing gear by maintenance personnel which resulted in the separation of the landing gear and the subsequent abnormal runway contact during the landing.NTSB CEN18LA106Accident · Minor injuriesClass 3 · LimitedFinal reportSchweizer 269D · Stockbridge, MIThe pilot’s failure to maintain adequate clearance from terrain while maneuvering the helicopter at a low altitude after departure. Contributing to the accident were the pilot’s distraction by the smoke in the cabin and the limited visible features in the…NTSB GAA18CA097Accident · No injuriesData collectionFinal reportCessna 172 · Monroe, MIThe student pilot’s improper yaw control during the landing flare and the flight instructor’s failure to take remedial action, which resulted in a hard landing.NTSB DCA18CA042Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD 88 · Detroit, MIfailure of the flight crew to confirm the left engine throttle lever was at idle during engine start.NTSB GAA18CA081Accident · No injuriesData collectionFinal reportPiper PA 32 · Cheboygan, MIThe pilot’s failure to maintain the airplane’s rate of descent in gusting wind conditions resulting in a hard landing and runway excursion.NTSB GAA18CA007Accident · No injuriesData collectionFinal reportCessna T210 · Waterford, MIThe pilot's unstabilized approach at night, which resulted in collision with trees.NTSB CEN18FA001Accident · 1 fatalField investigationFinal reportBrantly B 2B · Midland, MIThe pilot's failure to maintain control of the helicopter, which resulted in a loss of tail rotor effectiveness, and his failure to promptly initiate the proper recovery technique, which resulted in a descent that could not be arrested before impacting the…NTSB CEN17FA332Accident · Serious injuriesField investigationFinal reportCessna 180J · Gaylord, MIThe pilot's failure to use carburetor heat while operating in weather conditions that were conducive to carburetor ice formation, which resulted in a total loss of engine power due to carburetor ice accumulation.NTSB GAA17CA485Accident · No injuriesData collectionFinal reportCessna 182 · Sparta, MIThe pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN17LA316Accident · Serious injuriesLimited investigationFinal reportNavion Navion G · Adrian, MIA leak in the gascolator, which allowed air to enter the fuel system and resulted in a partial loss of engine power.NTSB GAA17CA416Accident · No injuriesData collectionFinal reportPiper PA 22 · Breckenridge, MIThe pilot’s loss of situational awareness during the approach over a corn field, which resulted in collision with corn stalks.NTSB CEN17LA257Accident · No injuriesLimited investigationFinal reportCessna 182T · Jackson, MIThe pilot's failure to maintain pitch control during the takeoff roll during an attempted takeoff. Contributing to the accident was the pilot's selection of takeoff flaps after he began the takeoff roll.NTSB GAA17CA347Accident · Minor injuriesData collectionFinal reportAeronca 11AC · Watervliet, MIThe flight instructor's inadequate preflight planning, which resulted in a takeoff over maximum gross weight from a turf runway in high density altitude conditions and the airplane’s inability to attain a climb rate and subsequent collision with trees.NTSB CEN17LA341Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Ray, MIThe pilot's failure to maintain a proper approach speed, which resulted in in a hard landing and a runway excursion. Contributing to the accident was the pilot's decision to fly the airplane without an instructor onboard.NTSB CEN17CA218Accident · Minor injuriesData collectionFinal reportCessna 177 · Plainwell, MIThe pilot's improper approach to landing and his failure to perform a go-around, which resulted in a runway overrun.NTSB CEN17LA184Accident · No injuriesLimited investigationFinal reportMooney M20E · Dowling, MIInnacurate airspeed indications due to contamination of the pitot-static system with insect remains, which resulted in a high approach and landing speed and subsequent runway overrun.NTSB GAA17CA271Accident · No injuriesData collectionFinal reportCessna A185 · Big Rapids, MIThe pilot’s failure to obtain updated weather information while practicing takeoffs and landings and his subsequent failure to maintain directional control during the landing roll in gusting crosswind conditions.NTSB CEN17LA178Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Manistee, MIThe failure of the airplane owner and maintenance personnel to follow the propeller manufacturer's recommend overhaul schedule, which resulted in a fatigue fracture of the propeller blade actuating pin and a loss of thrust in flight.NTSB CEN17LA150Accident · No injuriesLimited investigationFinal reportPiper PA 28R-201 · Pontiac, MIMaintenance personnel’s improper securing of an unused instrument lamp socket during recent maintenance, which resulted in an electrical short of the landing gear controls and stopped the landing gear while it was transitioning to the down position and led to…NTSB GAA17CA247Accident · No injuriesData collectionFinal reportGrumman American Avn. AA · Flushing, MIThe pilot’s unstabilized approach and subsequent failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB CEN17LA135Accident · 1 fatalLimited investigationFinal reportLuscombe 8F · Vicksburg, MIThe pilot's inadvertent contact with the propeller while hand propping the engine, which resulted in a fatal injury.NTSB DCA17FA076Accident · Minor injuriesClass 1 · FieldFinal reportMcdonnell Douglas MD80 · Ypsilanti, MIthe jammed condition of the airplane's right elevator, which resulted from exposure to localized, dynamic wind while the airplane was parked and rendered the airplane unable to rotate during takeoff. Contributing to the accident were (1) the effect of a large…NTSB GAA17CA142Accident · No injuriesData collectionFinal reportCessna T182 · Three Rivers, MIThe pilot’s failure to maintain sufficient airspeed during the landing flare, which resulted in a hard landing and a nose-over.NTSB CEN17LA078Accident · Serious injuriesLimited investigationFinal reportTextron 525C · Howell, MIThe pilot's attempted landing on the ice-covered runway, which resulted in a runway excursion and impact with terrain. Contributing to the accident was airport personnel's lack of training regarding issuance of NOTAMsNTSB CEN17LA070Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Pontiac, MIThe improper installation of the left wheel brake torque plate by maintenance personnel, which resulted in the separation of the torque plate from the axle endplate and a loss of directional control during landing.NTSB CEN17LA057Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ionia, MIA failure of the aft support cable on the left main landing ski due to an inadequately formed nicopress sleeve, which allowed the ski to rotate into a vertical position shortly after liftoff, and its unavoidable separation during the subsequent landing.NTSB CEN16LA366Accident · Serious injuriesLimited investigationFinal reportPiper PA 18 · Greenville, MIThe pilot's premature turn during the takeoff climb and subsequent turn to avoid trees, which resulted in his exceedance of the airplane’s critical angle-of-attack and a subsequent aerodynamic stall.NTSB CEN16LA363Accident · Serious injuriesLimited investigationFinal reportCGS Hawk Aero II · Holland, MIThe improper installation of quick release connectors in the fuel lines, which was not in accordance with the engine manufacturer's maintenance instructions and allowed air to be introduced into the fuel system and resulted in a partial loss of engine power.…NTSB CEN16LA322Accident · Serious injuriesLimited investigationFinal reportPiper J5C · Sandusky, MIThe pilot's improper landing flare, which resulted in a bounced landing, and a subsequent loss of control followed by a runway excursion.NTSB CEN16LA305Accident · Minor injuriesLimited investigationFinal reportGilchrist PA14EXP · Sparta, MIA total loss of engine power for reasons that could not be determined, since postaccident examination revealed no malfunctions or anomalies that would have precluded normal operation.NTSB GAA16CA401Accident · Minor injuriesData collectionFinal reportS C Aerostar S .A. Festival R40S · Frankfort, MIThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion, a nose gear collapse, and impact with terrain.NTSB CEN16FA269Accident · 2 fatalField investigationFinal reportAeronca 11AC · Ishpeming, MIThe pilot's failure to maintain airspeed following a loss of engine power due to carburetor icing while turning from base to final at a low altitude, which resulted in the airplane's wing exceeding its critical angle of attack and a subsequent aerodynamic…NTSB CEN16LA264Accident · No injuriesLimited investigationFinal reportAlonso CH 701 · Dexter, MIThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN16FA240Accident · 2 fatalField investigationFinal reportAeronca 11AC · Frankenmuth, MIThe pilot's loss of control for undetermined reasons based on available information.NTSB CEN16LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Houghton Lake Heights, MIThe pilot's delayed reaction to the variable wind condition, which resulted in an excessive descent rate and the airplane's subsequent collision with a wire fence short of the runway.NTSB CEN16LA245Accident · Serious injuriesLimited investigationFinal reportEvolution Revo · Holland, MIThe flight instructor's failure to maintain aircraft control during landing as a result of his failure to adjust the electric trim to the proper position for landing.NTSB CEN16LA236Accident · 1 fatalLimited investigationFinal reportCessna 150L · Detroit, MIThe pilot’s disregard of the banner-tow operator's policy regarding the maximum allowable flight duration, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN16IA238Incident · No injuriesIncident investigationFinal reportEnstrom 280 · Zeeland, MIThe exhaust band clamp failure, which resulted in an engine fire due to hot exhaust gases entering the engine compartment.NTSB GAA16CA346Accident · No injuriesData collectionFinal reportCessna 172 · Flushing, MIThe collision with a deer during touchdown of a night landing, which resulted in substantial damage to the horizontal stabilizer and elevator of the airplane.NTSB GAA16CA338Accident · No injuriesData collectionFinal reportNorth American SNJ · Jackson, MIThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion, right main landing gear collapse, and impact with the ground.NTSB GAA16CA275Accident · No injuriesData collectionFinal reportCessna 170 · Saginaw, MIThe pilot's exceedance of the critical angle of attack during the landing flare, which resulted in an aerodynamic stall, hard landing, right main landing gear collapse, runway excursion, and nose over.NTSB CEN16LA190Accident · No injuriesLimited investigationFinal reportBeech C24R · Marine City, MIThe misalignment of the right main landing gear, which resulted in the failure of the landing gear to retract and extend properly. Also causal was the pilot's failure to have the airplane inspected after a hard landing that had resulted in substantial damage…NTSB CEN16TA194Accident · No injuriesFinal reportNorth American AT6 · Mason, MIThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions, which resulted in a runway excursion and impact with a ditch.NTSB GAA16CA196Accident · Minor injuriesData collectionFinal reportCessna 182 · Moorestown, MIAn in-flight bird strike, which resulted in wind screen damage.NTSB DCA16CA094Accident · No injuriesData collectionFinal reportBoeing 737 · Detroit, MIN925NN flight crew's incorrect evaluation of the clearance between the two aircraft, leading to the inadvertent collision of the winglet with the horizontal stabilizer and elevator of N784SW.NTSB CEN16LA105Accident · No injuriesLimited investigationFinal reportEnstrom TH-180 · Menominee, MIThe failure of the torque meter mounting bolts, which resulted in a loss of engine power to the main drive belt and rotors.