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 IAD96LA143Accident · No injuriesLimited investigationFinal reportCessna T210N · Wadsworth, OHthe pilot's misjudgment of distance and speed, and his failure to attain a proper touchdown point, during the landing. Factors related to the accident were: dusk light conditions, and a tailwind.Sep 2, 1996 · N6614Y · Substantial damageNTSB FTW96LA369Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Salida, COtotal failure of the induction air control linkage (bolt), which allowed the alternate air door to close and starve the engine of air.Sep 2, 1996 · N7640F · Substantial damageNTSB FTW96LA367Accident · Minor injuriesLimited investigationFinal reportJackson Sonerai I · Santa Fe, NMthe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. The lack of suitable terrain for the forced landing was a related factor.Sep 2, 1996 · N103HJ · Substantial damageNTSB FTW96FA368Accident · 2 fatalField investigationFinal reportCessna 150F · Jones, LAVFR flight into instrument meteorological conditions (VMC), and failure of the pilot (PIC) to maintain control of the airplane after becoming spatially disorientation. Factors relating to the accident were: darkness, the adverse weather condition (fog and…Sep 2, 1996 · N8380G · DestroyedNTSB CHI96LA326Accident · No injuriesLimited investigationFinal reportCessna 172 · Chicago, ILthe pilot's improper flare and improper recovery from a bounced landing. A factor relating to the accident was: the pilot's lack of experience (or lack of training) in recovery from bounced landings.Sep 2, 1996 · N65785 · Substantial damageNTSB CHI96FA324Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Grosse Ile, MIthe pilot exceeding the critical angle of bank required to maintain altitude.Sep 2, 1996 · N7082W · Substantial damageNTSB ANC96LA143Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Gakona, AKthe pilot's inadequate compensation for gusty crosswind conditions, which resulted in a loss of directional control and subsequent collision with trees/brush. Factors relating to the accident were: the crosswind and wind gusts.Sep 2, 1996 · N7669D · Substantial damageNTSB ANC96LA135Accident · No injuriesLimited investigationFinal reportCessna 206 · Port Alsworth, AKthe pilot's improper in-flight planning/decision, which resulted in intering a box canyon with insufficient altitude to either execute a turn to safety or outclimb rising terrain. A factor associated with the accident was: the pilot allowed the passenger to…Sep 2, 1996 · N733KD · Substantial damageNTSB ANC96FA137Accident · Serious injuriesField investigationFinal reportPiper PA-32 · Haines, AKthe pilot's inadvertent flight into instrument meteorological conditions (IMC) failure to maintain adequate altitude/clearance from terrain, while maneuvering to reverse the direction of flight. Factors associated with the accident were: the pilot's…Sep 2, 1996 · N2181Z · Substantial damageNTSB NYC96LA180Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, MEthe student pilot's improper flare, which resulted in at hard landing.Sep 1, 1996 · N2009A · Substantial damageNTSB IAD96LA142Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-26E · Elmira, NYthe pilot's failure to maintain adequate altitude and airspeed during the landing approach, resulting in a stall/spin and subsequent encounter with an embankment.Sep 1, 1996 · N1142S · Substantial damageNTSB FTW96LA375Accident · No injuriesLimited investigationFinal reportHughes 269B · Frisco, TXThe pilot's improper touchdown procedure.Sep 1, 1996 · N9558F · Substantial damageNTSB FTW96LA374Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Brownfield, TXThe pilot's failure to maintain directional control during landing roll. A factor was the crosswind.Sep 1, 1996 · N1502F · Substantial damageNTSB CHI96LA325Accident · 1 fatalLimited investigationFinal reportKarr Titan Tornado · Union Pier, MIthe pilot not obtaining/maintaining altitude/clearance. Factors were the pilot not maintaining aircraft control and intentional aerobatics.Sep 1, 1996 · N238PW · DestroyedNTSB ANC96LA140Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Skwentna, AKcorrosion and subsequent fatigue failure of the crankshaft, which resulted in engine failure and a forced landing. Factors related to the accident were: the lack of suitable terrain for a forced landing, and the operator's non-compliance with a service…Sep 1, 1996 · N4366Y · Substantial damageNTSB ANC96LA138Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mccarthy, AKThe pilot's inadequate compensation for gusty wind conditions, and his selection of an unsuitable landing/takeoff site. A factor associated with the accident was the gusty wind.Sep 1, 1996 · N1879A · Substantial damageNTSB ANC96LA133Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKthe pilot's premature liftoff and subsequent inadvertent stall.Sep 1, 1996 · N4393Z · Substantial damageNTSB NYC96FA178Accident · 1 fatalField investigationFinal reportCessna 177 · Youngstown, OHthe pilot's delay in aborting the landing, and his failure to attain adequate airspeed to fly out of ground effect, which resulted in a stall/mush and collision with the ground. Factors relating to the accident were: the pilot's improper recovery from a…Aug 31, 1996 · N2992X · DestroyedNTSB LAX96LA323Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Globe, AZfuel starvation due to the pilot's inadequate preflight inspection and improper fuel tank selection.Aug 31, 1996 · N2059S · Substantial damageNTSB LAX96LA322Accident · Minor injuriesLimited investigationFinal reportCessna 305A · San Diego, CAFuel exhaustion due to the pilot's improper preflight planning, and an inadequate fuel supply.Aug 31, 1996 · N5277G · Substantial damageNTSB FTW96LA366Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Conchas, NMThe pilot's inadvertent flight into hail which shattered the pilot's windshield and resulted in his incapacitation due to hypoxia.Aug 31, 1996 · N55HU · DestroyedNTSB FTW96GA365Accident · 2 fatalFinal reportPiper PA-23-250 · Jennings, LAThe pilot's failure to maintain clearance. Factors were the pilot's lack of recent experience in the make and model of airplane, the dark night, and fog.Aug 31, 1996 · N14196 · DestroyedNTSB CHI96LA333Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Chicago, ILthe pilot's improper fuel management, which resulted in fuel starvation and loss of engine power. A factor relating to the accident was: the pilot's improper flare during the forced landing.Aug 31, 1996 · N2087A · Substantial damageNTSB CHI96FA323Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Hampshire, ILimproper use of the mini-bike by the driver. Factors relating to the accident were: darkness, the unlighted mini-bike, and insufficient standards required by the residents of the airstrip concerning use of the taxiways at night.Aug 31, 1996 · N570SR · Minor damageNTSB ANC96FA139Accident · 1 fatalField investigationFinal reportCessna 206 · Yakutat, AKThe pilot's landing on the water with the landing gear inadvertently extended.Aug 31, 1996 · N7345N · Substantial damageNTSB SEA96LA206Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Ashland, ORinadequate inspection of the airplane by maintenance personnel,and a worn exhaust clamp, which resulted in a disconnected exhaust pipe, exhaust leak, burning and shorting of electrical wiring associated with the voltage regulator, and a cabin fire.Aug 30, 1996 · N4992Z · DestroyedNTSB LAX96LA326Accident · No injuriesLimited investigationFinal reportBell 47-G5 · Riverside, CAThe pilot's inaccurate perception of altitude which resulted in an improper flare and subsequent hard landing, and non use of the landing light.Aug 30, 1996 · N57RA · Substantial damageNTSB FTW96LA372Accident · No injuriesLimited investigationFinal reportHardie KIT FOX XL · Monticello, ARthe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Aug 30, 1996 · N42JH · Substantial damageNTSB FTW96LA370Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Plains, TXfailure of the pilot to maintain control of the airplane, while maneuvering after a swath run, which subsequently resulted in a collision with the terrain. A factor relating to the accident was: the adverse wind condition (gusty wind and possible windshear).Aug 30, 1996 · N1558N · Substantial damageNTSB CHI96FA322Accident · 1 fatalField investigationFinal reportMankovich Sonerai · Jeffersonville, INinadequate maintenance and inspection of the airplane by the pilot/owner and other airframe and powerplant mechanics, which failed to assure adequate sealing of the engine firewall, and led to the pilot's incapacitation due to carbon monoxide.Aug 30, 1996 · N7037J · DestroyedNTSB ANC96LA134Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKThe fuel starvation caused by the unporting of the right fuel tank, and the pilot's inadequate preflight by not dipping the fuel tank to ensure sufficient fuel quantity to prevent the unporting.Aug 30, 1996 · N8241V · Substantial damageNTSB MIA96LA220Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Chattanooga, TNclear air turbulence, which was encountered during cruise flight and resulted in injuries to passengers.Aug 29, 1996 · N392US · Minor damageNTSB MIA96LA219Accident · Serious injuriesLimited investigationFinal reportFlightstar 2SL · Kiln, MSfailure of the pilot to maintain adequate airspeed, while maneuvering after takeoff, which resulted in an inadvertent stall and subsequent in-flight collision with terrain.Aug 29, 1996 · UNREG · Substantial damageNTSB LAX96LA324Accident · No injuriesLimited investigationFinal reportCessna 172N · Auburn, CAthe pilot's misjudged landing flare and improper bounced landing recovery. A contributing factor was his lack of recent flying experience.Aug 29, 1996 · N9315E · Substantial damageNTSB IAD96WA141Accident · No injuriesForeign investigationCessna T-310P · Skiathos, GreeceAug 29, 1996 · N5758M · Substantial damageNTSB FTW96LA363Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Oklahoma City, OKthe student pilot's inadequate preflight planning/preparation, and subsequent fuel exhaustion due to an inadequate supply of fuel. Factors relating to the accident were: the student's lack of experience in this make and model of aircraft, darkness, and lack…Aug 29, 1996 · N9253U · Substantial damageNTSB CHI96LA321Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Grant City, MOlow oil level which resulted in the partial loss of engine power, the pilot's intentional operation of the airplane with a known mechanical deficiency, and the hay bale. Factors relating to this accident were the owner/pilot mechanic's failure to comply with…Aug 29, 1996 · N8456W · Substantial damageNTSB CHI96LA319Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Pittsburg, KSthe pilot diverted his attention and failed to maintain sufficient altitude and clearance with the terrain. Factors relating to the accident were: darkness, and the pilot performing low altitude flight at night.Aug 29, 1996 · N47558 · Substantial damageNTSB CHI96IA320Incident · No injuriesIncident investigationFinal reportCessna 525 · Milwaukee, WIan uncontained failure of a high pressure turbine disk blade retention post due to fatigue. A factor relating to the incident was: inadequate design of the high pressure turbine disk. Fretting on the leading side of the lobe near the fracture origin may have…Aug 29, 1996 · N123JN · Minor damageNTSB NYC96LA176Accident · Serious injuriesLimited investigationFinal reportTemco D-16A · Hainesport, NJthe pilot's improper inflight planning/decision and inadequate management of fuel, which resulted in fuel exhaustion and the loss of engine power.Aug 28, 1996 · N128N · Substantial damageNTSB LAX96LA318Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Minden, NVthe pilot's delayed remedial action when encountering downdrafts while approaching high terrain in high density altitude conditions. The pilot's inadequate supervision of the second pilot was a factor in the accident.Aug 28, 1996 · N788JG · DestroyedNTSB CHI96FA318Accident · 2 fatalField investigationFinal reportBeech 35-33 · Brownsburg, INfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall and subsequent impact on a roadway. Buzzing by the pilot was a contributing factor.Aug 28, 1996 · N963T · DestroyedNTSB MIA96FA218Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Lagrange, GAthe pilot's improper procedure by not placing the fuel selector on the tank with the most fuel, which resulted in fuel starvation and a forced landing in a pasture. Contributing factors in this accident were the pilot's inadequate pre-flight and in-flight…Aug 27, 1996 · N741RB · DestroyedNTSB LAX96LA316Accident · No injuriesLimited investigationFinal reportCessna 172F · Ocotillo, CAthe pilot's failure to maintain proper runway alignment. The sun glare and proximity of rocks were related factors.Aug 26, 1996 · N5543R · Substantial damageNTSB LAX96LA315Accident · 1 fatalLimited investigationFinal reportBell 47-G4A · Guamloss of tail rotor control due to improper maintenance.Aug 26, 1996 · N474GA · DestroyedNTSB CHI96LA317Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-301 · Stewartville, MNthe pilot's improper in-flight planning/decision, which resulted in a failure to reach the proper touchdown point for the landing. The fractured nose gear shimmy damper attaching collar and the jammed nose gear were related factors.Aug 26, 1996 · N801SP · Substantial damageNTSB CHI96FA314Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Medford, MNfailure of the pilot to maintain control of the airplane, due to spatial disorientation. Factors relating to the accident were: failure of the (primary) vacuum system and a restriction in the (standby) vacuum system.Aug 26, 1996 · N7133C · DestroyedNTSB ATL96LA125Accident · No injuriesLimited investigationFinal reportCessna T303 · Senoia, GAThe pilot's inadequate preflight planning to ascertain the conditions of the runway. Factors were the wet, grass runway.Aug 26, 1996 · N420FC · Substantial damageNTSB ANC96LA169Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Northway, AKThe pilot's premature lift-off. A factor associated with the accident was the rough and uneven airstrip.Aug 26, 1996 · N2683A · Substantial damageNTSB SEA96LA203Accident · No injuriesLimited investigationFinal reportForney F-1 · Bozeman, MTthe pilot's failure to adequately service the engine with oil before flight, which resulted in a loss of oil pressure and a subsequent forced landing. The high vegetation and embankment at the forced landing site were related factors.Aug 25, 1996 · N7551C · Substantial damage