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.

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.Apr 13, 1989 · N5909Q · Substantial damageNTSB 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.Apr 13, 1989 · CGPCC · Substantial damageNTSB 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.Apr 13, 1989 · N4445W · Substantial damageNTSB 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.Apr 13, 1989 · N28990 · Substantial damageNTSB 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.Apr 12, 1989 · N8521Z · DestroyedNTSB 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.Apr 12, 1989 · N157P · DestroyedNTSB MIA89RA134Accident · No injuriesForeign investigationBeech A80 · Santo Domingo, Dominican RepublicApr 12, 1989 · HI563NTSB MIA89LA129Accident · No injuriesLimited investigationFinal reportLuscombe 8A · St Augustine, FLFuel contamination. A related factor was the tree.Apr 12, 1989 · N311P · Substantial damageNTSB 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.Apr 12, 1989 · N6253D · Substantial damageNTSB 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.Apr 12, 1989 · N993C · Substantial damageNTSB 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.Apr 12, 1989 · N4898G · Substantial damageNTSB ANC89LA058Accident · No injuriesLimited investigationFinal reportCessna 185 · Trinity Lake, AKThe pilot's selection of unsuitable terrain on which to land.Apr 12, 1989 · N9850X · Substantial damageNTSB 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.Apr 11, 1989 · N1093Y · Substantial damageNTSB 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.Apr 11, 1989 · N5523C · DestroyedNTSB 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.Apr 11, 1989 · N24807 · Substantial damageNTSB CHI89FA071Accident · Serious injuriesField investigationFinal reportSikorsky S-58T · Milwaukee, WIDisconnect of the tailrotor drive shaft coupling.Apr 11, 1989 · N4247U · Substantial damageNTSB 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.Apr 11, 1989 · N51TK · Substantial damageNTSB 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…Apr 10, 1989 · N94822 · Substantial damageNTSB 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.Apr 10, 1989 · N25884 · Substantial damageNTSB 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.Apr 10, 1989 · N731XG · Substantial damageNTSB 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.Apr 10, 1989 · N7847U · Substantial damageNTSB 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.Apr 10, 1989 · N30PC · DestroyedNTSB 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.Apr 10, 1989 · N1214Y · Substantial damageNTSB 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…Apr 10, 1989 · N9688B · Substantial damageNTSB 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.Apr 9, 1989 · N43561 · DestroyedNTSB MIA89LA128Accident · No injuriesLimited investigationFinal reportCessna 172M · West Palm Beach, FLFailure of the pilot to insure adequate wingtip clearance while taxiing.Apr 9, 1989 · N80440 · Substantial damageNTSB 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.Apr 9, 1989 · N4602L · Substantial damageNTSB 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…Apr 9, 1989 · N120HH · DestroyedNTSB 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.Apr 9, 1989 · N6812R · DestroyedNTSB NYC89DGM01Accident · No injuriesFinal reportSharp FOX Model 1 · Loretto, PAThe loss of engine power for undetermined reasons.Apr 8, 1989 · N8387S · Substantial damageNTSB MKC89LA088Accident · No injuriesLimited investigationFinal reportMooney M20E · Lake Elmo, MNFuel tank selector improperly positioned, emergency procedure improperly performed by the pilot, and fuel starvation.Apr 8, 1989 · N9424V · Substantial damageNTSB MIA89LA126Accident · No injuriesLimited investigationFinal reportBeech F-33A · Reddington Bch., FLLoss of engine power for undetermined reasons.Apr 8, 1989 · N599WB · Substantial damageNTSB 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.Apr 8, 1989 · N2326W · Substantial damageNTSB 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.Apr 8, 1989 · N711BF · Substantial damageNTSB LAX89LA153Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Livermore, CADirectional control not maintained by the pilot. Unfavorable wind, high wind, and gusts were contributing factors.Apr 8, 1989 · N6662M · Substantial damageNTSB 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.Apr 8, 1989 · N9456F · Substantial damageNTSB 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.Apr 8, 1989 · N9705M · Substantial damageNTSB 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.Apr 8, 1989 · N611AA · Substantial damageNTSB 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.Apr 8, 1989 · N51774 · Substantial damageNTSB 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.Apr 8, 1989 · N8562X · Substantial damageNTSB 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.Apr 8, 1989 · N7504V · Substantial damageNTSB 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.Apr 7, 1989 · N504JT · Substantial damageNTSB SEA89FA186Accident · 1 fatalField investigationFinal reportAmerican AA-1A · Enumclaw, WAAttempted flight into known adverse weather conditions. Factors include clouds, downdrafts, high winds.Apr 7, 1989 · N9473L · DestroyedNTSB 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.Apr 7, 1989 · N4369S · Substantial damageNTSB 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.Apr 7, 1989 · N66988 · Substantial damageNTSB 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.Apr 7, 1989 · N44510 · DestroyedNTSB 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.Apr 7, 1989 · N766RW · DestroyedNTSB 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.Apr 6, 1989 · N6395G · Substantial damageNTSB NYC89LA113Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Utica, NYA fire in the cockpit from an unknown source.Apr 6, 1989 · N90437 · Substantial damageNTSB 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.Apr 6, 1989 · N7510K · Substantial damage