NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 LAX89LA180Accident · No injuriesLimited investigationFinal reportMooney M20C · Hesperia, CAThe pilot, the operator of the airplane, improperly maintained the airplane, and during the ensuing forced landing the pilot's inflight planning was poor and that he misjudeged the airplane's altitude.NTSB LAX89LA159Accident · No injuriesLimited investigationFinal reportBritish Aerospace HS125-700 · Scottsdale, AZThe captain misjudged distance and altitude to the runway and allowed the aircraft to touch down just short of the runway lip. The runway lip was a related factor.NTSB CHI89LA072Accident · No injuriesLimited investigationFinal reportBeech A60 · Indianapolis, INThe pilot misjudged altitude and/or distance to the runway wile on final approach to land. Factors related to the accident were: dark night and pilot fatigue.NTSB ATL89LA126Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Siler City, NCImproper engine overhaul procedures which resulted in the catastrophic failure of the engine crankshaft. Contributing to the accident was the lack of a suitable forced landing area.NTSB SEA89FA068Accident · 2 fatalField investigationFinal reportLake LA-4-200-EP · Bellevue, WALoss of engine power for an undetermined reason and failure of the instructor pilot (CFI) to maintain control of the aircraft, which resulted in a stall/spin.NTSB NYC89GA116Accident · 2 fatalFinal reportBell 206B · Airville, PAThe pilot was unable to see and avoid the unmarked power lines stretched across the river. A contributing factor was the lack of visual clues.NTSB MIA89RA134Accident · No injuriesForeign investigationBeech A80 · Santo Domingo, Dominican RepublicNTSB MIA89LA129Accident · No injuriesLimited investigationFinal reportLuscombe 8A · St Augustine, FLFuel contamination. A related factor was the tree.NTSB LAX89LA158Accident · No injuriesLimited investigationFinal reportCessna 172N · Eureka, CAThe improper in-flight planning by the instructor pilot when he allowed the private pilot student to land long. Additionally, the instructor delayed remedial action until the runway overrun was inevitable.NTSB DEN89LA107Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Aurora, COThe inadequate compensation for wind conditions by the pilot. Lack of recent experience in the type of aircraft is considered a contributing factor.NTSB ATL89LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Xenia, OHThe pilot's improper in-flight planning/decision and improper use of the flaps. Contributing was the downdraft.NTSB ANC89LA058Accident · No injuriesLimited investigationFinal reportCessna 185 · Trinity Lake, AKThe pilot's selection of unsuitable terrain on which to land.NTSB NYC89LA114Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Rosehayn, NJThe pilots failure to maintain control of the aircraft during landing. This resulted in an uncontrolled touchdown and rollover of the helicopter.NTSB LAX89LA156Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Scottsdale, AZThe pilot's loss of directional control of the airplane during the ground run and abrupt rotation to get airborne.NTSB LAX89FA157Accident · Serious injuriesField investigationFinal reportCessna 152 · Chino, CAThe pilot's failure to obtain an appropriate weather briefing in preparation for the cross country flight and his failure to maintain an altitude sufficient to clear the terrain along the indended route after entering reduced visibility conditions.NTSB CHI89FA071Accident · Serious injuriesField investigationFinal reportSikorsky S-58T · Milwaukee, WIDisconnect of the tailrotor drive shaft coupling.NTSB CHI89DET03Accident · No injuriesFinal reportNorth American F-51D · Fort Wayne, INPilot's failure to maintain aircraft control during the crosswind takeoff. Contributing to the accident was the premature lift off and the crosswind condition.NTSB NYC89LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · Bedford, MAImproper use of throttle and flight controls by the student and inadequate supervision by the CFI which resulted in a stall. The student's lack of total flying experience and the instructor's lack of experience in the type of operation (instructing) were…NTSB LAX89LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Irwindale, CAImproper procedure used by the certified flight instructor in simulating an engine failure. Contributing to this accident was the lack of total flight instruction experience of the flight instructor.NTSB DEN89LA106Accident · No injuriesLimited investigationFinal reportCessna A188B · Rapelje, MTThe inadequate compensation for the wind conditions by the pilot which resulted in a loss of directional control on landing and subsequent collision with a ditch.NTSB DEN89LA105Accident · No injuriesLimited investigationFinal reportCessna 172F · Morgan, UTInadequate servicing of the aircraft by the pilot, partial blockage of the fuel line and fuel filter, and fuel starvation. Contributing factors were: the downward sloping runway and a fence.NTSB ATL89MA123Accident · 3 fatalMajor investigationFinal reportBeech 200 · Pensacola, FLAn in flight cabin fire of undetermined origin, and smoke (toxic condition) in the crew compartment, which resulted in physical impairment of the flight crew.NTSB ATL89LA125Accident · No injuriesLimited investigationFinal reportCessna 150B · Hickory, NCThe pilot's failure to refuel the airplane prior to the flight resulting in fuel exhaustion during takeoff.NTSB ATL89LA124Accident · No injuriesLimited investigationFinal reportCessna 172RG · Miamisburg, OHIntermittant grounding of an electrical wire to the nose landing gear. The chafed wire resulted in the opening of the landing gear motor circuit breaker preventing full extension of the left main landing gear. A secondary failure of the throttle warning…NTSB NYC89LA045Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Gorham, MEFailure of the pilot to maintain adequate airspeed when he diverted his attention during a low pass and allowed the aircraft to enter a stall/spin. The unfavorable wind was a factor.NTSB MIA89LA128Accident · No injuriesLimited investigationFinal reportCessna 172M · West Palm Beach, FLFailure of the pilot to insure adequate wingtip clearance while taxiing.NTSB LAX89LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Taft, CAThe pilots improper use of carburetor heat in weather conditions which were conducive to the formation of carburetor ice.NTSB FTW89FA078Accident · Serious injuriesField investigationFinal reportMBB BK-117A-4 · Houston, TXFailure of the pilot to maintain clearance from the obstruction (garage). Factors related to the accident were: darkness, adverse weather conditions, personnel in the area of the temporary heliport, lack of security provided by hospital management, which…NTSB DEN89FA104Accident · 1 fatalField investigationFinal reportCessna T210F · Aspen, COThe engine falure due to undetermined reasons and the pilot's misjudgement of the wind conditions which resulted in the attempt to glide to the runway. The pilot also failed to maintain adequate airspeed during the glide which resulted in a stall.NTSB NYC89DGM01Accident · No injuriesFinal reportSharp FOX Model 1 · Loretto, PAThe loss of engine power for undetermined reasons.NTSB MKC89LA088Accident · No injuriesLimited investigationFinal reportMooney M20E · Lake Elmo, MNFuel tank selector improperly positioned, emergency procedure improperly performed by the pilot, and fuel starvation.NTSB MIA89LA126Accident · No injuriesLimited investigationFinal reportBeech F-33A · Reddington Bch., FLLoss of engine power for undetermined reasons.NTSB MIA89LA125Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Lakeland, FLImproper in-flight planning/decision, which resulted in fuel starvation, while the fuel selector was positioned to a tank with the least amount of fuel. A factor related to the accident was: the faulty fuel quantity indication for the right tank.NTSB MIA89FA124Accident · Serious injuriesField investigationFinal reportBeech C-45H · Tampa, FLFuel contamination of the left engine fuel system which resulting in a failure of the left engine.NTSB LAX89LA153Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Livermore, CADirectional control not maintained by the pilot. Unfavorable wind, high wind, and gusts were contributing factors.NTSB LAX89LA152Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Long Beach, CAImproper in-flight planning/decision by the pilot, which led to an inadequate supply of fuel to reach the airport and subsequent fuel exhaustion. The pilot's lack of flight time in this make and model of helicopter was considered to be a factor.NTSB LAX89LA151Accident · No injuriesLimited investigationFinal reportMooney M20F · Prescott, AZThe failure of the plt to lean the fuel mixture for the high density altitude. Contributing to the accident was the cfi's lack of familiarity with the airplane and engine operating procedures.NTSB LAX89DVG05Accident · No injuriesFinal reportMorse F85P-1 · Redding, CAAn animal on the runway. Factors were: the pilot's intentional ground loop and the resultant loss of control.NTSB FTW89LA079Accident · No injuriesLimited investigationFinal reportEnstrom F28C · Padre Island, TXThe pilot's decision to fly in adverse weather condition. The adverse weather was a related factor.NTSB DEN89LA103Accident · Minor injuriesLimited investigationFinal reportCessna P172D · Crested Butte, COThe pilot selected a runway with unsuitable conditions for taking off. The unfavorable wind and terrain conditions were related factors.NTSB ATL89LA128Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Barnwell, SCThe pilot's poor in-flight planning/decision in continuing flight to the destination airport without refueling which resulted in fuel exhaustion. Unfavorable winds and inadequate fuel consumption calculations were contributing factors.NTSB SEA89LA066Accident · No injuriesLimited investigationFinal reportThiessen RV-4 · Independence, ORFailure of the propeller. A related factor was the obstruction (transmission line) in the emergency landing area.NTSB SEA89FA186Accident · 1 fatalField investigationFinal reportAmerican AA-1A · Enumclaw, WAAttempted flight into known adverse weather conditions. Factors include clouds, downdrafts, high winds.NTSB FTW89DPJ03Accident · No injuriesFinal reportAir Tractor 301 · Jefferson, OKLoss of engine power, due to a cracked number 4 cylinder. A factor related to the accident was: the terrace (dirt bank) in the emergency landing area.NTSB CHI89LA070Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Bunker Hill, ILImproper preflight by the student pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: soft terrain.NTSB BFO89FA081Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Stuarts Draft, VAThe pilot's failure to maintain clearance above the terrain after flying VFR into IMC. Contributing to the accident were the low ceiling and fog conditions and the mountainous terrain.NTSB BFO89FA028Accident · 3 fatalField investigationFinal reportPiper PA-32-260B · Richmond, VAEngine lost power because of induction icing. Contributing factors are conditions conduvice to induction icing and unsuitable terrain.NTSB SEA89LA065Accident · No injuriesLimited investigationFinal reportCessna 150K · Seattle, WAThe decision of a student pilot to continue to land the aircraft with a crosswind that exceeded his ability level.NTSB NYC89LA113Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Utica, NYA fire in the cockpit from an unknown source.NTSB MKC89LA087Accident · No injuriesLimited investigationFinal reportCessna 180 · Marshall, MNThe failure of an unapproved weld between the exhaust system and muffler. The failed weld resulted in the muffler separating and an in-flight fire.