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 SEA93FA084Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Estacada, ORFailure of the pilot to maintain proper clearance (and/or altitude) from moutainous terrain. Factors related to the accident were: darkness, clouds, low ceilings, and the high (mountainous) terrain in the area of the accident site.Mar 29, 1993 · N63888 · DestroyedNTSB LAX93LA159Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Fresno, CAthe improper installation of an electrical wire bundle, and, the chaffing and subsequent arcing of the wires against a fuel line which resulted in a fire.Mar 29, 1993 · N758XY · Substantial damageNTSB CHI93LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Lyons, WIThe pilot's use of an unsuitable runway.Mar 29, 1993 · N7058P · Substantial damageNTSB NYC93FA066Accident · 6 fatalField investigationFinal reportPiper PA-23-250 · Elmwood Park, NJInadequate maintenance and inspection of the fuel injector system resulting in a loss of power of the left engine, and the failure of the pilot to maintain minimum control speed which resulted in a flat spin. A factor which contributed to the accident was the…Mar 28, 1993 · N6382Y · Substantial damageNTSB MIA93LA093Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Panacea, FLThe pilot's inadeqaute compensation for wind conditions. The downdraft was a factor.Mar 28, 1993 · N51600 · Substantial damageNTSB CHI93LA123Accident · Minor injuriesLimited investigationFinal reportRockwell 100 · Topinabee, MIthe total loss of engine power due to failure of the oil line to the oil pressure gauge. A factor relating to the accident was no suitable terrain on which to make a forced landing.Mar 28, 1993 · N4017X · Substantial damageNTSB CHI93LA121Accident · No injuriesLimited investigationFinal reportManville Avid Flyer · Lincoln, MOThe pilot's failure to maintain control of the airplane, and his operation of an airplane with known defects.Mar 28, 1993 · N714J · Substantial damageNTSB BFO93FA061Accident · 1 fatalField investigationFinal reportCessna A152 · Revere, PAThe CFI failed to adequately supervise the operation. Related factors were dark night, lost/disorientation of the pilot, and her lack of experience in type of operation (night flying).Mar 28, 1993 · N761XA · DestroyedNTSB FTW93LA112Accident · No injuriesLimited investigationFinal reportCessna 150C · El Paso, TXThe fuel exhaustion induced power loss and the failure of the pilot to refuel. A factor was the lack of suitable terrain.Mar 27, 1993 · N2015Z · Substantial damageNTSB DEN93IA050Incident · No injuriesIncident investigationFinal reportPiper PA-34-200 · Boulder, CONot determined.Mar 27, 1993 · N4519T · Minor damageNTSB CHI93LA120Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Lee'S Summit, MOThe pilot's improper procedures during ground operations.Mar 27, 1993 · N354KP · No damageNTSB CHI93LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Marysville, INThe pilot's failure to use carburetor heat while flying in carburetor icing conditions.Mar 27, 1993 · N3439Z · Substantial damageNTSB BFO93LA062Accident · Minor injuriesLimited investigationFinal reportKibiuk Quickie · Durhamville, NYThe loose battery cable to the negative terminal, resulting in total power loss. A factor related to the accident was the lack of suitable terrain for an emergency landing.Mar 27, 1993 · N12726 · Substantial damageNTSB SEA93LA083Accident · No injuriesLimited investigationFinal reportCessna 150 · Laurel, MTThe loss of engine power, undetermined.Mar 26, 1993 · N6581T · Substantial damageNTSB SEA93LA082Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Jordan Valley, ORThe pilot continued the VFR flight into IMC and failed to maintain clearance from obstacles on the ground. Factors relating to the accident were the clouds, low ceiling, and rain.Mar 26, 1993 · N3986J · DestroyedNTSB FTW93LA111Accident · No injuriesLimited investigationFinal reportCessna 182 · Washington, OKLoss of engine power for undetermined reason(s).Mar 26, 1993 · N5520B · DestroyedNTSB CHI93FA118Accident · 1 fatalField investigationFinal reportCessna 182N · Ludington, MIthe pilot's improper instrument procedures. Related factors are the below approach minima weather conditions, fog and dark night.Mar 26, 1993 · N8945G · DestroyedNTSB BFO93LA059Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lewisburg, OHThe pilot experienced spatial disorientation. Contributing to the accident was the dark night and inadvertent flight into instrument meteorological conditions.Mar 26, 1993 · N73436 · Substantial damageNTSB ATL93LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Knightdale, NCThe failure of the student pilot to maintain control of the aircraft.Mar 26, 1993 · N68276 · Substantial damageNTSB ATL93LA065Accident · No injuriesLimited investigationFinal reportHiller UH12E · Greeleyville, SCThe pilot's misjudgment of the helicopter's altitude during the landing flare.Mar 25, 1993 · N4029Z · Substantial damageNTSB ANC93LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Mekoryuk, AKPilot-in-command initiated VFR flight into IMC conditions. A factor in this accident was the whiteout weather conditions.Mar 25, 1993 · N9102Y · Substantial damageNTSB MIA93LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Walls, MSThe pilot-in-command's delay in aborting the landing.Mar 24, 1993 · N55919 · Substantial damageNTSB MIA93LA091Accident · No injuriesLimited investigationFinal reportBeech V35B · Key Largo, FLThe pilot-in-command's complacency and decision to leave the aircraft controls unattended with the engine operating and without setting the parking brake.Mar 24, 1993 · N18368 · Substantial damageNTSB LAX93LA166Accident · 1 fatalLimited investigationFinal reportBell 47G2A · Pacific Ocean (Pacific Ocean)The passenger's failure to adhere to the pilot's instructions. Factors which contributed to the accident were: the language/communications difficulty between the pilot & the passenger, and the bird strike.Mar 24, 1993 · N8493E · Minor damageNTSB DEN93LA035Accident · No injuriesLimited investigationFinal reportPitts S2B · Boulder, COThe pilot in command's failure to maintain a visual lookout. A factor was: the student pilot's restricted visual lookout.Mar 24, 1993 · N876CB · Substantial damageNTSB ATL93LA063Accident · No injuriesLimited investigationFinal reportBeech 58 · Blountville, TNThe intentional operation of the aircraft with a partial failure of the brake system and the failure of the pilot to attain the proper touchdown point. Factors in the accident were the sunglare and the partial loss of the aircraft brake system.Mar 24, 1993 · N8555R · Substantial damageNTSB NYC93IA065Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Newark, NJThe pilot's misunderstanding of landing runway, and the failure of the local controller to adequately monitor the progress of the flight. Factors which contributed to the incident were: the failure of tower personnel to notify TRACON of the ATIS change, the…Mar 23, 1993 · N107FE · No damageNTSB MIA93LA090Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-8-102 · Jacksonville, FLThe operator's lack of adequate instructions to crewmembers as to when flight attendants can resume cabin duties after being told to be seated by the captain.Mar 23, 1993 · N928HA · No damageNTSB BFO93LA056Accident · No injuriesLimited investigationFinal reportCessna 177RG · Corry, PAFailure of the pilot to maintain runway alignment during the landing roll. Factors related to the accident were: darkness, the pilot's lack of visual cues due to the runway lights being obscured by the plowed snow, and failure of airport personnel to issue a…Mar 23, 1993 · N7747V · Substantial damageNTSB BFO93IA057Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE3201 · Rochester, NYFailure of the main cabin door to be adequately secured for flight for an unknown REAS0N.Mar 23, 1993 · N496UE · Minor damageNTSB ATL93FA062Accident · 1 fatalField investigationFinal reportCessna 402B · Tullahoma, TNThe pilot's failure to maintain control of the airplane during takeoff. Factors which contributed to the accident were: the pilot's failure to ensure that the airplane maximum gross takeoff weight was not exceeded, the dark night, and rain.Mar 23, 1993 · N405PC · DestroyedNTSB SEA93LA081Accident · No injuriesLimited investigationFinal reportCessna U206F · Friday Harbor, WAThe improper use of flight controls by the pilot in command. Factors relating to the accident were the strong, tailwind weather conditions.Mar 22, 1993 · N8768Q · Substantial damageNTSB MIA93LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · La Belle, FLImproper in-flight planning/decision by the student pilot, and inadequate supervision of the flight by the instructor pilot (CFI). Factors related to the accident were: the tailwind, and the student pilot's improper flare and transition to an aborted landing,…Mar 22, 1993 · N94187 · Substantial damageNTSB LAX93LA158Accident · Serious injuriesLimited investigationFinal reportBoeing A75L3 · Carlsbad, CAThe pilot's inadequate preflight preparation in that he failed to refuel the aircraft prior to departure.Mar 22, 1993 · N58969 · Substantial damageNTSB FTW93FA108Accident · 2 fatalField investigationFinal reportChampion 7ECA · Dublin, TXThe pilot's attempted maneuver which led to his entry into an inadvertent stallMar 22, 1993 · N11052 · DestroyedNTSB BFO93LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Monticello, MEA disconnection of the fuel line, which resulted in fuel starvation and loss of engine power. A related factor was the lack of suitable terrain for an emergency landing.Mar 22, 1993 · N41422 · Substantial damageNTSB BFO93LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Babylon, NYThe loss of engine power due to the intake valve failure.Mar 22, 1993 · N56153 · Substantial damageNTSB MIA93LA088Accident · Minor injuriesLimited investigationFinal reportChristen Industries Pitts S1-T · Naples, FLThe installation of an improper designed intake tube and air filter by the nonmechanic rated pilot-in-command, which resulted in moisture build up and collapse of the air filter, which resulted in blockage of air flow to the engine and loss of engine power.…Mar 21, 1993 · N218MC · Substantial damageNTSB DEN93LA034Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Las Animas, COFailure by the pilot in command to maintain control of the aircraft. A factor was: wind gusts.Mar 21, 1993 · N4245R · Substantial damageNTSB CHI93IA127Incident · No injuriesIncident investigationFinal reportde Havilland SHD-6 · Chicago, ILThe local controller's failure to maintain 3 miles radar separation between two airplanes. A factor related to the incident was the local controller's delay in remedial action.Mar 21, 1993 · N374MQ · No damageNTSB LAX93LA157Accident · Minor injuriesLimited investigationFinal reportBell 47G5 · Greenfield, CAThe pilot's failure to maintain an adequate clearance from the power lines while performing an aerial application run.Mar 20, 1993 · N7080J · Substantial damageNTSB FTW93LA110Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Abbeville, LAThe pilot's failure to compensate for crosswind conditions and the subsequent loss of directional control. Factors were the gusting crosswinds and the soft wet groundMar 20, 1993 · N1337B · Substantial damageNTSB FTW93LA109Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Plainview, TXThe pilot's the improper flare prior to touchdown. Factors were the fuel starvation power loss and improper positioning of the fuel selector.Mar 20, 1993 · N4045B · Substantial damageNTSB CHI93LA116Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Demotte, INThe pilot's poor planned approach to the runway.Mar 20, 1993 · N8655N · Substantial damageNTSB BFO93LA053Accident · No injuriesLimited investigationFinal reportCessna 152 · Robbinsville, NJThe flight instructor's failure to successfully take remedial action to maintain control of the airplane during takeoff. A factor related to the accident was the student pilot's improper control of the airplane during liftoff, while practicing a soft field…Mar 20, 1993 · N714XH · Substantial damageNTSB ANC93LA046Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Drift River, AKThe pilots inadvertent VFR flight into IMC conditions. Factors were the rising terrain and the whiteout conditions.Mar 20, 1993 · N72999 · Substantial damageNTSB ANC93FA045Accident · 1 fatalField investigationFinal reportPiper PA-14 · Rainey Pass, AKThe pilot-in-command's attempt to fly VFR in IMC conditions. Factors were the mountainous terrain and whiteout conditions.Mar 20, 1993 · N5153H · Substantial damageNTSB SEA93LA080Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Hailey, IDThe pilot in command's failure to maintain directional control. A factor contributing to the accident was the snowbank.Mar 19, 1993 · N24WW · Substantial damageNTSB MIA93LA087Accident · No injuriesLimited investigationFinal reportCessna 402B · Opa-Locka, FLFailure of the pilot-in-command to perform weight and balance calculations, exceeding the gross weight of the airplane, and disregarding wind information provided by the tower controller.Mar 19, 1993 · N6383X · Substantial damageNTSB MIA93LA086Accident · Serious injuriesLimited investigationFinal reportCessna 180K · Madison, MSInduction air control/system partial failure, induction air control/system leak, and the lack of suitable terrain for the forced landing.Mar 19, 1993 · N66388 · Substantial damage