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 CHI94LA313Accident · Serious injuriesLimited investigationFinal reportWilliam P. Bouda Varieze · Millard, NEthe loss of engine power due to fuel starvation from vapor lock. A factor associated with the accident is the soft terrain the pilot was forced to land upon.Sep 5, 1994 · N54WB · Substantial damageNTSB CHI94LA311Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · Cassoday, KSthe attempted low level flight/maneuver with inadequate visual lookout by the pilot-in-command.Sep 5, 1994 · N82114 · DestroyedNTSB ANC94FA130Accident · 1 fatalField investigationFinal reportPiper PA-18 · Gulkana, AKThe pilot's failure to maintain clearance from terrain.Sep 5, 1994 · N7867D · Substantial damageNTSB NYC94LA169Accident · No injuriesLimited investigationFinal reportDonald E. Kovol Quickie 2 · Akron, OHThe failure of the pilot to maintain airspeed which resulted in an inadequate flare and a hard landing. A factor was the pilot's lack of experience in the airplane.Sep 4, 1994 · N4327V · Substantial damageNTSB NYC94LA168Accident · No injuriesLimited investigationFinal reportBeech C35 · Rhinebeck, NYThe pilot's inadequate preflight planning and inaccurate fuel consumption calculations, resulting in fuel starvation and engine failure, and the subsequent collision with trees during a forced landing. A factor related to the accident was the turbulent air…Sep 4, 1994 · N5291C · Substantial damageNTSB LAX94LA352Accident · Minor injuriesLimited investigationFinal reportHughes 369E · Volcano, HIthe pilot's failure to maintain adequate main rotor rpm and the resultant inadvertent skid contact with the ground.Sep 4, 1994 · N279F · Substantial damageNTSB LAX94LA351Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Twentynine Palm, CAthe cause of the loss of engine power could not be determined. The dirt berm was a factor in this accident.Sep 4, 1994 · N8431T · Substantial damageNTSB LAX94LA350Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Rescue, CAThe pilot's delayed go-around. His inadequate compensation for the wind was a factor.Sep 4, 1994 · N9699Q · Substantial damageNTSB FTW94FA287Accident · Serious injuriesField investigationFinal reportAerostar RX-7 · Fountain, COThe pilot's improper aircraft handling during landing in high wind conditions. A factor was the high wind.Sep 4, 1994 · N3578D · No damageNTSB CHI94LA312Accident · No injuriesLimited investigationFinal reportCessna 172 · Milwaukee, WIthe pilot's improper flare during touchdown. A factor in the accident was the rupture of the nose landing gear tire.Sep 4, 1994 · N9955V · Substantial damageNTSB SEA94T#A05Accident · No injuriesClass 3Final reportBell 206L3 · Libby, MTSep 3, 1994 · N206LB · Substantial damageNTSB SEA94LA232Accident · No injuriesLimited investigationFinal reportCessna 210D · Paris, IDAn inadvertent wheels up landing.Sep 3, 1994 · N3759Y · Substantial damageNTSB SEA94LA230Accident · No injuriesLimited investigationFinal reportCessna 182B · Lummi Island, WAInadequate compensation for wind conditions. A factor to the accident was: tailwind.Sep 3, 1994 · N2356G · Substantial damageNTSB NYC94FA166Accident · 2 fatalField investigationFinal reportCessna 310R · Blain, PAThe pilot's impairment of judgment and performance due to drugs, failure to maintain control of the airplane, and exceeding the design stress limits of the airplane, which resulted in an in-flight breakup of the airplane. A factor related to the accident was:…Sep 3, 1994 · N502SB · DestroyedNTSB MIA94LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Englewood, FLThe failure of the number four connecting rod and rod bolts due to oil starvation (extreme heat) for undetermined reasons, resulting in a total loss of engine power, forced landing, and subsequent in-flight collision with trees and terrain.Sep 3, 1994 · N10187 · Substantial damageNTSB MIA94LA205Accident · No injuriesLimited investigationFinal reportCessna 172N · Orlando, FLThe pilot-in-command's improper landing flare/touchdown, resulting in a hard landing, and subsequent separation of the nose gear.Sep 3, 1994 · N734QA · Substantial damageNTSB LAX94LA369Accident · No injuriesLimited investigationFinal reportCessna T210L · Kettleman City, CAThe pilot's selection of the wrong runway for takeoff and his failure to maintain runway alignment. The sun glare was a factor in this accident.Sep 3, 1994 · N732DT · Substantial damageNTSB LAX94LA349Accident · 1 fatalLimited investigationFinal reportCessna 172M · Jackpot, NVthe pilot's failure to maintain aircraft control due to spatial disorientation during a moonless night departure over an area without ground reference lights. A factor in the accident was the pilot's lack of instrument training and experience.Sep 3, 1994 · N21704 · DestroyedNTSB LAX94LA348Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Orland, CAThe pilot's failure to follow checklist procedures to assure that the fuel selector was in the both fuel tanks position. Fuel starvation and the dark night were factors in this accident.Sep 3, 1994 · N5449B · Substantial damageNTSB 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.Sep 3, 1994 · N8470S · DestroyedNTSB ANC94LA128Accident · No injuriesLimited investigationFinal reportMaule M5 · Port Alsworth, AKThe pilot's selection of unsuitable terrain.Sep 3, 1994 · N51637 · Substantial damageNTSB NYC94FA165Accident · 1 fatalField investigationFinal reportBellanca 8-KCAB · Chatsworth, NJThe pilot's inadequate preflight that failed to detect water- contaminated fuel which resulted in the loss of engine power and the pilot's decision to conduct flight at an altitude too low to initiate emergency procedures.Sep 2, 1994 · N8670V · DestroyedNTSB LAX94LA347Accident · No injuriesLimited investigationFinal reportCessna 182P · Mesa, AZthe pilot's failure to properly secure the aircraft prior to a start attempt by handpropping.Sep 2, 1994 · N58645 · Substantial damageNTSB FTW94LA291Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Hurst, TXThe certificated flight instructor's inadequate supervision. A factor was the pilot's failure to maintain proper landing alignment.Sep 2, 1994 · N2064J · Substantial damageNTSB FTW94LA289Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Ardmore, OKThe partial loss of power due to a cylinder head separation. Factors were the lack of suitable terrain for the forced landing and the low ceiling.Sep 2, 1994 · N3413R · Substantial damageNTSB FTW94LA286Accident · No injuriesLimited investigationFinal reportCessna 150M · Mesquite, TXThe unfavorable gusting winds. A factor was the pilot's failure to maintain directional control.Sep 2, 1994 · N66322 · Substantial damageNTSB CHI94LA309Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7-15 · Storm Lake, IAthe pilot's excessive rate of descent to landing. Factors in the accident were the gusts and downdraft.Sep 2, 1994 · N2597S · Substantial damageNTSB CHI94LA308Accident · No injuriesLimited investigationFinal reportThalman Thorp T-18 · Kenosha, WIthe pilot's failure to use carburetor heat in carburetor icing conditions. A factor associated with the accident is the prevailing carburetor icing conditions.Sep 2, 1994 · N2911 · Substantial damageNTSB CHI94FA307Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Lincoln, ILThe pilot's failure to maintain airspeed while performing a go-around.Sep 2, 1994 · N4362F · DestroyedNTSB ANC94LA131Accident · No injuriesLimited investigationFinal reportCessna 180B · Fort Yukon, AKThe pilot's improper use of the flaps and flight controls, and a delay in aborting the takeoff. A factor in the accident was glassy water conditions.Sep 2, 1994 · N5143E · Substantial damageNTSB ANC94LA129Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tok, AKThe worn cam shaft lobe and worn valve lifter.Sep 2, 1994 · N8597D · Substantial damageNTSB SEA94LA228Accident · Minor injuriesLimited investigationFinal reportSikorsky S-64F · Libby, MTThe flight crew allowed the helicopter's weight and balance to be exceeded, and the external load (tank) jettison system failed to operate. A factor related to the accident was: the false indication on the retardant quantity indicator.Sep 1, 1994 · N165AC · DestroyedNTSB NYC94LA164Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Block Island, RIThe pilot maintaining excessive airspeed during the landing, resulting in a touchdown on the runway with insufficient distance to stop, and a subsequent intentional ground loop and collision with the terrain. Also causal was the pilot's failure to abort the…Sep 1, 1994 · N445B · Substantial damageNTSB NYC94LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Vine Grove, KYThe pilot's (1) inadequate compensation for wind conditions and (2) failure to align with the runway during landing touch down.Sep 1, 1994 · N3256R · Substantial damageNTSB NYC94LA162Accident · No injuriesLimited investigationFinal reportCessna 310Q · Salem, OHThe pilot misjudged altitude and distance which resulted in a undershoot of the runway and collision with objects.Sep 1, 1994 · N7579Q · Substantial damageNTSB MIA94LA204Accident · No injuriesLimited investigationFinal reportCessna 188B · Indian River, FLThe total loss of engine power for undetermined reasons over terrain unsuitable for a forced landing.Sep 1, 1994 · N53184 · DestroyedNTSB LAX94LA345Accident · Minor injuriesLimited investigationFinal reportCessna 310L · Agua Dulce, CAthe pilot's failure to maintain control of the aircraft while reaching cross cockpit for the flap control.Sep 1, 1994 · N3272X · DestroyedNTSB ANC94LA126Accident · No injuriesLimited investigationFinal reportCessna 208 · Cape Sabine, AKThe pilot's improper preflight planning, inadequate compensation for the wind conditions, not following procedures and directives, and overconfidence in his abilities, and the operators inadequate surveillance of the operation.Sep 1, 1994 · N9825F · Substantial damageNTSB SEA94LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Everett, WAThe pilot failed to maintain directional control.Aug 31, 1994 · N1329C · Substantial damageNTSB LAX94LA344Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Five Points, CAthe pilot's inadequate compensation for the existing crosswind condition and his failure to maintain the proper runway alignment.Aug 31, 1994 · N80642 · Substantial damageNTSB LAX94LA343Accident · No injuriesLimited investigationFinal reportCessna 195 · Palo Alto, CAthe pilot's improper use of the airplane's brakes during the landing rollout.Aug 31, 1994 · N195LS · Substantial damageNTSB LAX94LA342Accident · No injuriesLimited investigationFinal reportTexas Helicopter M74 · Salinas, CAfuel exhaustion due to the pilot's inadequate preflight planning and in-flight fuel consumption monitoring.Aug 31, 1994 · N51852 · Substantial damageNTSB BFO94LA159Accident · No injuriesLimited investigationFinal reportBell UH-1B · Carrabasset, MEFracture failure of the tail rotor drive intermediate gearbox.Aug 31, 1994 · N204JB · Substantial damageNTSB ATL94LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Headland, ALThe failure of the student pilot to maintain control of the aircraft during a crosswind landing.Aug 31, 1994 · N64903 · Substantial damageNTSB ANC94LA125Accident · No injuriesLimited investigationFinal reportCessna 170B · Fort Yukon, AKThe fatigue failure of the right main landing gear spring.Aug 31, 1994 · N4457B · Substantial damageNTSB ANC94LA117Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Anchorage, AKThe binding in the mechanical fuel selector valve, and lack of suitable terrain for a forced landing.Aug 31, 1994 · N9130K · Substantial damageNTSB ANC94LA110Accident · No injuriesLimited investigationFinal reportBell B-206 · Gustavus, AKThe pilot misjudged his distance/altitude from the landing area, and his lack of recent night flying experience. Factors which contributed to the accident were: the pilot's failure to assure that he would be landing with sufficient light, and the dusk/dark…Aug 31, 1994 · N382EH · Substantial damageNTSB SEA94LA226Accident · No injuriesLimited investigationFinal reportCessna 182P · Yamhill, ORThe pilot's failure to maintain directional control. A factor to the accident was: an inadequate recovery from a bounced landing.Aug 30, 1994 · N1316S · Substantial damageNTSB MIA94LA203Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Egypt, MSPilot-in-command's inadvertent stall during an agricultural turn resulting in the loss of control and subsequent in flight collision with terrain.Aug 30, 1994 · N4811R · Substantial damageNTSB MIA94LA202Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12-D · Punta Gorda, FLThe failure of the pilot-in-command to tiedown the airplane prior to attempting an engine start by hand propping. Contributing to the accident was the pilot's complacency.Aug 30, 1994 · N39283 · Substantial damage