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 CHI08CA116Accident · Minor injuriesData collectionFinal reportMooney M20J · Howell, MIThe inadvertent stall and low airspeed while maneuvering back to the departure airport after the baggage door opened in flight. An additional cause was the plot's diverted attention to the opening of the baggage door.NTSB CHI08LA115Accident · No injuriesLimited investigationFinal reportCessna 182 · Romeo, MIThe misjudged landing flare by the pilot, and the inadequate landing gear inspection/repair procedure used by other maintenance personnel, resulting in the failure of the main landing gear strut during landing.NTSB CHI08CA110Accident · No injuriesData collectionFinal reportBeech 95-B55 · Lansing, MIThe pilot's inadvertent raising of the landing gear during rollout.NTSB CHI08IA109Incident · No injuriesIncident investigationFinal reportEclipse EA500 · Pontiac, MIThe inadvertent stalling of the rudder trim actuator motor during flight due to the pilot's unintentional exceedence of the motor's design limit for stalling while accelerating after completing a simulated engine-out maneuver.NTSB CHI08CA094Accident · No injuriesData collectionFinal reportCessna 182 · Traverse City, MIThe unstabalized approach performed by the student pilot and the go-around not performed by the student pilot. Additional causes were the inadequate recovery from a bounced landing and the directional control not obtained by the student pilot. Contributing…NTSB CHI08LA071Accident · No injuriesLimited investigationFinal reportAirbus Industrie A319-114 · Detroit, MIThe separation of the engine cowling which resulted from maintenance personnel failing to follow maintenance procedures in that they did not latch the engine cowling following the maintenance inspection. A factor associated with the accident was their…NTSB CHI08CA060Accident · No injuriesData collectionFinal reportAmerican Champion 7AC · Whitmore Lake, MIThe partial loss of engine power for undetermined reasons during cruise and the unsuitable terrain encountered during the precautionary landing. A factor was the snow-covered ground.NTSB CHI08CA058Accident · No injuriesData collectionFinal reportCessna 172F · Crystal Falls, MIThe rough, unsuitable terrain encountered during the landing which resulted in the total failure of the nose landing gear.NTSB CHI08FA055Accident · 1 fatalField investigationFinal reportCessna 310R · Traverse City, MIThe pilot's failure to maintain a proper glidepath during the instrument approach, which led to his loss of control and subsequent impact with trees and terrain.NTSB CHI08CA049Accident · No injuriesData collectionFinal reportCessna 172 · Hastings, MIThe student pilot failed to maintain directional control during landing. Factors were the ditch and the icy runway.NTSB CHI08FA033Accident · 1 fatalField investigationFinal reportCessna 172I · Gladwin, MIThe pilot's failure to maintain aircraft control while maneuvering at a low altitude. Contributing to the accident was the pilot's diverted attention while attempting to photograph ground objects.NTSB CHI08CA008Accident · Serious injuriesData collectionFinal reportVeltman, Robert CH701 · Owosso, MIThe pilot inadvertantly turned the fuel selector to the off position and failed to maintain aircraft control during the subsequent loss of engine power. A factor associated with the accident was the pilot's change in his normal habit pattern.NTSB CHI08CA024Accident · No injuriesData collectionFinal reportCessna C-182 · Cedar Springs, MIThe pilot's decision to takeoff with strong, gusty winds and his inability to stop the airplane prior to it traveling off the end of the runway during the delayed aborted takeoff. Factors associated with the accident were the wet, grass airstrip and gusty…NTSB CHI08LA016Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Muskegon, MILoss of engine power during initial climb after takeoff for undetermined reasons. A contributing factor was the unsuitable terrain for a forced landing available to the pilot due to the presence of a residential sub-division and trees.NTSB CHI07LA302Accident · Serious injuriesLimited investigationFinal reportSiebert RV-9A · Barton City, MIThe pilot's failure to maintain adequate airspeed and aircraft control during initial climb after takeoff. Contributing to the accident was the gusting wind condition.NTSB CHI07CA294Accident · No injuriesData collectionFinal reportCessna 172M · Pontiac, MIThe pilot's misjudgment of the landing flare and her improper recovery from the bounced landing.NTSB CHI07FA279Accident · 2 fatalField investigationFinal reportSocata TB-20 Trinidad · Pointe Aux Pins, MIUndetermined.NTSB CHI07CA282Accident · No injuriesData collectionFinal reportMooney M20M · Grand Rapids, MIThe pilot not maintaining directional control of the aircraft during the crosswind landing. Factors were the crosswind and the runway lights that were impacted.NTSB CHI07LA266Accident · No injuriesLimited investigationFinal reportCessna 172M · Marine City, MIA loss of engine power for undetermined reasons. Factors contributing to the accident were the insufficient runway remaining and the soft terrain.NTSB CHI07CA255Accident · No injuriesData collectionFinal reportButtles SNS-7 · Lapeer, MIThe fuel starvation for an undetermined reason, and the unsuitable terrain encountered during the forced landing. The trees were a factor.NTSB CHI07CA245Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe student pilot's improper flare, which resulted in a hard landing. An additional cause was the pilot's inadequate recovery from a bounced landing. Factors in the accident include the pilot's failure to maintain directional control during the landing roll…NTSB CHI07CA225Accident · Serious injuriesData collectionFinal reportRyan ST3KR · Coldwater, MIThe pilot's failure to maintain sufficient airspeed during the initial climb after takeoff, which resulted in an inadvertent stall/mush condition. A contributing factor was the low altitude at the time of the inadvertent stall.NTSB CHI07CA189Accident · Minor injuriesData collectionFinal reportCameron Balloons Z-77 · Battle Creek, MIThe whisper burner's fuel valve opening for undetermined reasons, which resulted in a fire after landing. A factor in the accident was the balloon envelope's parachute top not reseating.NTSB CHI07CA186Accident · No injuriesData collectionFinal reportPiper J3F-65 · Grand Ledge, MIThe pilot's failure to maintain directional control during takeoff resulting in a ground loop.NTSB CHI07CA178Accident · No injuriesData collectionFinal reportAeronca 7EC · Hillsdale, MIThe aircraft control not maintained by the pilot during landing rollout.NTSB CHI07CA172Accident · No injuriesData collectionFinal reportCessna 195 · Battle Creek, MIThe pilot's failure to maintain directional control of the aircraft during the landing roll which resulted in a ground loop.NTSB CHI07CA169Accident · Minor injuriesData collectionFinal reportCessna 150H · Bellaire, MIA loss of engine power for undetermined reasons. A factor in the accident was the deer fence.NTSB CHI07CA149Accident · Minor injuriesData collectionFinal reportPiper J3C · Waterford, MIThe pilot's failure to maintain control of the airplane, causing a water loop. A factor in the accident was the water loop encountered.NTSB CHI07CA137Accident · No injuriesData collectionFinal reportAeronca 7AC · Mason, MIThe pilot's failure to maintain directional control during the landing roll and failure to maintain sufficient airspeed during the aborted landing attempt, leading to an inadvertent stall. An additional factor was the tree.NTSB CHI07LA126Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Fruitport, MIThe flight instructor failed to use carburetor heat during takeoff in icing conditions. A factor was the power line pole.NTSB CHI07CA124Accident · No injuriesData collectionFinal reportWilkinson Daniel V Rotorway Exec 90 · Kalamazoo, MIThe failure of the sprag clutch which resulted in the disengagement of the drive unit and the pilot's misjudged landing during the autorotation. A factor was the low altitude at which the failure occurred.NTSB CHI07CA111Accident · Minor injuriesData collectionFinal reportCessna 150F · Paw Paw, MIThe student pilot's inadequate compensation for wind conditions while on final approach. Contributing factors to the accident were the gusting wind conditions and the trees.NTSB CHI07CA118Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Williamston, MIThe pilot's improper recovery from a bounced landing which resulted in the collapse of the nose landing gear. The hilly runway was a contributing factor.NTSB CHI07CA110Accident · No injuriesData collectionFinal reportEngineering & Research Ercoupe 415-C · Brighton, MIThe student pilot's failure to maintain proper glidepath to the runway. Contributing factors to the accident included the passenger vehicle, the rising embankment, and the airport perimeter fence.NTSB CHI07CA119Accident · No injuriesData collectionFinal reportJohnson-Whittman Tailwind JW9L · Saginaw, MIThe pilot's failure to maintain the proper glidepath and clearance from a fence while on final approach.NTSB DCA07FA037Accident · No injuriesClass 1 · FieldFinal reportBombardier CL-600-2B19 · Traverse City, MIThe pilots' decision to land at Cherry Capital Airport (TVC), Traverse City, Michigan, without performing a landing distance assessment, which was required by company policy because of runway contamination initially reported by TVC ground operations personnel…NTSB CHI07CA100Accident · No injuriesData collectionFinal reportCessna 210N · Charlotte, MIThe pilot's inadequate compensation for the wind conditions, inadequate landing flare, failure to maintain directional control, and encounter with a pilot-induced oscillation (porpoise. A contributing factor was the wind gust.NTSB CHI07FA107Accident · No injuriesField investigationFinal reportCanadair CL-600-2B19 · Lake Michigan, MIIn-flight separation of the left engine thrust reverser translating cowling due to intermittent binding and jamming of the reverser on the accident flight and on previous flights. Contributing factors were the inadequate maintenance action by the operator due…NTSB CHI07CA090Accident · No injuriesData collectionFinal reportCessna 172E · Big Rapids, MIThe student pilot's failure to maintain directional control of the airplane during takeoff which led to the impact with the snow banks adjacent to the runway. The snow banks were contributing factors in the accident.NTSB CHI07CA076Accident · No injuriesData collectionFinal reportCessna 172N · Holland, MIThe student pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during the takeoff, which caused the airplane to impact the snow bank and nose over. Contributing factors were the crosswind and the snow…NTSB CHI07LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Pellston, MIThe fatigue failure of the engine cylinder which resulted in a complete loss of engine power, and the unsuitable terrain encountered by the pilot during the subsequent forced landing. Contributing to the accident were the night lighting condition, and trees.NTSB CHI07LA070Accident · Minor injuriesLimited investigationFinal reportReisinger Sonerai II L · Alma, MIThe loss of engine power during takeoff-initial climb for an undetermined reason. A factor in the accident was the lack of suitable terrain for a forced landing.NTSB CHI07LA059Accident · Minor injuriesLimited investigationFinal reportCessna 425 · Harbor Springs, MIThe pilot's failure to maintain aircraft control and adequate airspeed during landing flare. Contributing to the accident was the aerodynamic stall/mush encountered at a low altitude.NTSB CHI07LA051Accident · 1 fatalLimited investigationFinal reportPiper PA-32-300 · Romeo, MIThe pilot's failure to maintain aircraft control and proper rate of descent during the VOR approach. Factors associated with the accident were the low cloud conditions and moderate to heavy rain.NTSB CHI07CA044Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Cheyboygan, MIA loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the lanidng.NTSB CHI07CA040Accident · No injuriesData collectionFinal reportSchleicher AS-K13 · Gregory, MIThe pilot's unexpected encounter with wind shear and his inability to remain clear of the trees while on final approach to land.NTSB CHI07CA033Accident · No injuriesData collectionFinal reportCessna C-425 · Menominee, MIThe pilot failed to maintain control of the aircraft while parking the aircraft, and failed to maintain clearance from the building as the airplane taxied forward. A factor was the terminal.NTSB CHI07CA029Accident · No injuriesData collectionFinal reportCessna 150J · South Haven, MIThe pilot's inadequate compensation for the crosswind during landing. Factors were the crosswind and the ditch.NTSB CHI07LA024Accident · 1 fatalLimited investigationFinal reportMaule MX-7-180B · Edenville, MIThe pilot's loss of control during landing on a lake resulting in the amphibian aircraft flipping over inverted.NTSB CHI07FA016Accident · 1 fatalField investigationFinal reportCessna 175 · Battle Creek, MIA loss of engine power while in cruise flight due to an oil leak from the nose seal of the reduction gear case. Contributing to the accident were the oil leak, the pilot's reduced visibility out the windscreen, and rising terrain.