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 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB CHI96FA324Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Grosse Ile, MIthe pilot exceeding the critical angle of bank required to maintain altitude.NTSB 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.NTSB 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…NTSB 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…NTSB NYC96LA180Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, MEthe student pilot's improper flare, which resulted in at hard landing.NTSB 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.NTSB FTW96LA375Accident · No injuriesLimited investigationFinal reportHughes 269B · Frisco, TXThe pilot's improper touchdown procedure.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB ANC96LA133Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKthe pilot's premature liftoff and subsequent inadvertent stall.NTSB 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…NTSB LAX96LA323Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Globe, AZfuel starvation due to the pilot's inadequate preflight inspection and improper fuel tank selection.NTSB LAX96LA322Accident · Minor injuriesLimited investigationFinal reportCessna 305A · San Diego, CAFuel exhaustion due to the pilot's improper preflight planning, and an inadequate fuel supply.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ANC96FA139Accident · 1 fatalField investigationFinal reportCessna 206 · Yakutat, AKThe pilot's landing on the water with the landing gear inadvertently extended.NTSB 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.NTSB 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.NTSB 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.NTSB 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).NTSB 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.NTSB 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.NTSB MIA96LA220Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Chattanooga, TNclear air turbulence, which was encountered during cruise flight and resulted in injuries to passengers.NTSB 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.NTSB 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.NTSB IAD96WA141Accident · No injuriesForeign investigationCessna T-310P · Skiathos, GreeceNTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB LAX96LA315Accident · 1 fatalLimited investigationFinal reportBell 47-G4A · Guamloss of tail rotor control due to improper maintenance.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.