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 CHI94LA328Accident · No injuriesLimited investigationFinal reportMooney M20E · Plymouth, MIthe pilot's improper (maintenance) modification and his initiating an operation with known deficiencies in equipmentNTSB CHI94LA327Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-602P · Port Huron, MIInadequate preflight by the pilot resulting in fuel exhaustion. Inadequate maintenance and inspection was a factor contributing to the accident.NTSB CHI94LA323Accident · No injuriesLimited investigationFinal reportBeech D18S · Mt Pleasant, MIthe improper fuel selector position by the pilot-in-command which resulted in fuel starvation. A factor was rough/uneven terrain.NTSB CHI94LA318Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · West Branch, MIthe pilot's improper preflight planning in estimating the takeoff distance. The tall, wet grass on the runway was a factor.NTSB CHI94FA310Accident · 1 fatalField investigationFinal reportCessna 182H · Plymouth, MICarburetor ice, and improper use of (or failure to use) the carburetor heat. Factors related to the accident were: carburetor icing (weather) conditions, and the lack of suitable terrain for a forced landing.NTSB CHI94LA301Accident · No injuriesLimited investigationFinal reportCessna 172 · Whitehall, MIThe pilot in command's inadequate preflight planning. Factors related to the accident were the fuel exhaustion and the soft crop field.NTSB CHI94LA280Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW-20 · Ionia, MIno thermal lift available, and the lack of suitable terrain for landing. A factor related to the accident was the high wind condition.NTSB CHI94LA279Accident · No injuriesLimited investigationFinal reportHughes TH-55A · Houghton, MIfailure of the pilot to maintain control of the aircraft.NTSB CHI94LA269Accident · Serious injuriesLimited investigationFinal reportCessna 150F · East Tawas, MIinadequate prelight planning/preparation by the pilot and the subsequent inadequate fuel supply.NTSB CHI94LA267Accident · No injuriesLimited investigationFinal reportDe Havilland Tiger Moth DH-82A · Interlochen, MIthe failure of the pilot to obtain the proper climb rate, and inadequate compensation for wind conditions.NTSB CHI94FA262Accident · 1 fatalField investigationFinal reportGrumman HU-16 · St. Ignace, MIThe pilot's failure to follow good seaplane operating practices by taxiing with power at forward thrust, with a tailwind, at a speed that necessitated using reverse thrust to arrest the excessive speed, and the pilot's misjudgment of his distance from the…NTSB CHI94LA260Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Waterford, MIthe failure of the pilot to maintain directional control.NTSB CHI94LA252Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Flushing, MIthe pilot's improper touchdown position on the runway. A factor associated with the accident is the moving vehicle on the adjacent road.NTSB CHI94LA251Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Rockford, MIthe student pilot's failure to refuel the airplane prior to fuel exhaustion.NTSB CHI94LA249Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30 · Waterford, MIundetermined.NTSB CHI94LA234Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Traverse, MIpoor preflight planning and preparation by the pilot for not calculating the weight and balance of his airplane before departure. Factors associated with the accident were the airplane's weight and balance was exceeded, and the pilot's lack of recent…NTSB CHI94LA229Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Watersmeet, MIthe pilot's failure to maintain control of the airplane, and his inadequate preflight planning and preparation. Factors associated with the accident were the fog and the trees.NTSB CHI94LA226Accident · 2 fatalLimited investigationFinal reportCessna T210M · Beaver Island, MISpatial disorientation of the pilot-in-command due to flight into known instrument meteorological conditions; factors in the accident were the fog and low ceiling.NTSB CHI94LA225Accident · Minor injuriesLimited investigationFinal reportBeech K35 · Grand Rapids, MIthe pilot's improper fuel tank selection resulting in fuel starvation.NTSB CHI94LA217Accident · Minor injuriesLimited investigationFinal reportHunsberger Glasair · Lapeer, MIthe pilot's failure to maintain aircraft handling. A factor related to the accident was the gusty wind conditions.NTSB CHI94LA227Accident · No injuriesLimited investigationFinal reportCessna 441 · Flint, MIAn inadequate preflight inspection of the airplane by the pilot. Factors associated with this accident were unlatched nose cargo doors and the pilot's failure to extend the landing gear.NTSB CHI94LA213Accident · No injuriesLimited investigationFinal reportBeech 19 · Ionia, MIthe pilot's improper use of the throttle control. A factor related to the accident was the improper flare.NTSB CHI94LA211Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lambertville, MIthe pilot-in-command's not maintaining airspeed. A factor was the pilot-in-command's misjudging the flare.NTSB CHI94LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lambertville, MIThe inadequate maintenance of the airplane resulting in a foreign object in the induction system.NTSB CHI94LA201Accident · Serious injuriesLimited investigationFinal reportAeronca 15AC · Napoleon, MIa loss of engine power for unknown reasons. A factor related tot he accident were the trees encountered.NTSB CHI94LA198Accident · No injuriesLimited investigationFinal reportBeech 18 · Belleville, MIthe failure of the fuel line on the unique STC'd engine installation. A related factor is the improper installation of a fuel line by company maintenance personnel.NTSB CHI94DET01Accident · Minor injuriesFinal reportArthur Alan Blind FOX III Speedster · Watervliet, MIa total loss of engine power due to carburetor icing.NTSB CHI94LA195Accident · 1 fatalLimited investigationFinal reportCanadair T-33 · Mount Clemens, MIThe pilot's failure to maintain clearance from terrain during an aerobatic maneuver. His improper execution of the maneuver was a factor.NTSB CHI94DEM01Accident · No injuriesFinal reportGrumman G-164A · Muskegon, MIThe propeller not being able to be feathered by the pilot, inadequate altitude for a successful forced landing, and the failure of the combustion section. A factor associated with this accident was the stall/mush encountered by the pilot due to the…NTSB CHI94LA185Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lake City, MIThe pilot-in-command's inadequate compensation for wind conditions. Factors were the pilot-in-command's not using all available runway, premature lift off, and a crosswind.NTSB CHI94LA171Accident · No injuriesLimited investigationFinal reportCessna 172N · Mackinac Island, MIExcessive airspeed and a failure to attain the proper touchdown point on the runway. Factors related to the accident were the wet runway and the fence which was contacted.NTSB CHI94LA165Accident · No injuriesLimited investigationFinal reportBurkhart Grob BG 103 · Ionia, MIa hard landing as a result of the early disconnect of the glider launch/tow equipment.NTSB CHI94LA146Accident · No injuriesLimited investigationFinal reportCessna P210N · Bay City, MIThe pilot-in-command not following the airplane pre-landing checklist and the delay in landing gear extension.NTSB CHI94LA124Accident · No injuriesLimited investigationFinal reportCessna 177RG · Charlotte, MIthe deer which ran onto the runway. Factors related to the accident were the night conditions and the runway lights which were contacted.NTSB CHI94LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Romeo, MIthe pilot's improper use of carburetor heat. A factor in the accident is weather conducive to the formation of carburetor ice.NTSB CHI94LA112Accident · No injuriesLimited investigationFinal reportDassault-Breguet Falcon 900 · Detroit, MIthe nose landing gear jammed in the UP position due to low pressure in the nose gear strut. A factor associated with the accident is the manufacturer's insufficient standards/requirements for determining the amount of nose strut inflation.NTSB CHI94LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Harbor Springs, MIThe pilot's improper decision to continue flight into icing conditions after the conditions were first encountered. A factor related to the accident was the trees contacted during the landing roll.NTSB CHI94LA103Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Frankfort, MIThe pilot's inadequate preflight and failure to maintain adequate airspeed. A factor was fuel contamination resulting in total loss of engine power on takeoff.NTSB CHI94LA099Accident · No injuriesLimited investigationFinal reportCessna 172RG · Frankfort, MIThe failure of the pilot-in-command to maintain directional control. The snow covered runway was a factor.NTSB CHI94LA086Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Dowagiac, MIFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the pilot's lack of experience in this make and model of aircraft, the crosswind, and snow beside the runway.NTSB CHI94FA082Accident · 2 fatalField investigationFinal reportCessna A185F · Sterling Hgts, MIThe pilot's impairment of judgment and performance due to alcohol, which led to his intentional buzzing, and his failure to maintain sufficient altitude (or clearance) from obstacles. Factors related to the accident were: darkness and the unlighted tower.NTSB CHI94LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Sebewaing, MIwas the pilot-in-command's failure to maintain directional control. Factors were the icy runway and a snowbank.NTSB CHI94LA068Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Newberry, MIan engine fire which started as the result of an oil leak around the engine oil filter.NTSB CHI94LA064Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Dowagiac, MIwas the pilot not maintaining directional control during the takeoff ground roll. Factors related to the accident were the icy, snow covered runway and poor preflight planning/preparation.NTSB CHI94LA052Accident · No injuriesLimited investigationFinal reportCessna 404 · Big Rapids, MIThe pilot's descent below the minimum descent altitude.NTSB CHI94LA040Accident · Minor injuriesLimited investigationFinal reportSteven Ulrich Challenger II · Escanaba, MIInadequate directional stability of the aircraft (due to installation of lexan cockpit enclosure doors), which precipitated a loss of directional control.NTSB CHI94FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 172I · Kalamazoo, MIUndetermined.NTSB CHI94LA023Accident · No injuriesLimited investigationFinal reportCessna 140 · Frankenmuth, MIImproper use of the mixture control by the pilot. Factors related to the accident were: the similarity of shape, size, and color of the mixture and carburetor heat controls and the terrain condition (with crop) in the emergency landing area.NTSB CHI94LA028Accident · No injuriesLimited investigationFinal reportCessna 182 · Belleville, MIwas wind information not used by the pilot-in-command and a resultant exceeding of the airplane's performance capabilities.NTSB CHI94LA013Accident · No injuriesLimited investigationFinal reportHughes 269A · Coldwater, MIthe fatigue failure of the tailboom support strut attachment lug.