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 LAX96LA053Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Fresno, CAfailure of the pilot to maintain proper control of the helicopter, while in a hover.Nov 24, 1995 · N90452 · Substantial damageNTSB FTW96LA052Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Fredericksburg, TXthe pilot's failure to maintain directional control. Factors were the binding tailwheel and the pilot's lack of experience in tailwheel airplanes.Nov 24, 1995 · N9899B · Substantial damageNTSB FTW96LA051Accident · Minor injuriesLimited investigationFinal reportCessna 310J · Englewood, COfailure of the pilot to feather the propeller on the inoperative engine in accordance with the emergency procedure. Factors relating to the accident were: loss of power in the left engine for undetermined reason(s), and rough/uneven terrain in the emergency…Nov 24, 1995 · N1147M · Substantial damageNTSB CHI96LA041Accident · No injuriesLimited investigationFinal reportMcclung SEA Hawk · Marengo, ILthe failure of the upper right wing due to the presence of unbonded areas between the spar cap and the bidirectional fiberglass. The unbonded areas were due to the inadequate manufacturing of the airplane by the owner/builder. A factor in the accident was the…Nov 24, 1995 · N391SP · DestroyedNTSB NYC96FA027Accident · 1 fatalField investigationFinal reportBeech A36 · Atlantic City, NJthe pilot's failure to maintain control of the airplane. A factor was the pilot's diverted attention due to an open aft cargo door.Nov 23, 1995 · N550RR · DestroyedNTSB MIA96LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Lauderdale, FLThe pilots failure to follow the visual approach slope indicator and maintain a proper glidepath during approach. Contributing to the accident was pilot fatigue.Nov 23, 1995 · N44CQ · Substantial damageNTSB LAX96FA052Accident · 2 fatalField investigationFinal reportCessna 210L · Grand Canyon, AZthe pilot's loss of aircraft control as a result of spatial disorientation. Factors were: the pilot's lack of experience in instrument and night flight conditions, inadequate transition/upgrade training, and the dark night light condition.Nov 23, 1995 · N5138Q · DestroyedNTSB FTW96LA053Accident · No injuriesLimited investigationFinal reportCessna 182H · Eagle Lake, TXa loss of engine power for undetermined reasons. Factors were the lack of suitable terrain for the forced landing and the dark night.Nov 23, 1995 · N8493S · DestroyedNTSB CHI96FA038Accident · 4 fatalField investigationFinal reportPiper PA-28-201T · Belvidere, SDthe pilot's attempted visual flight into instrument meteorological conditions, his failure to maintain control of the airplane, and exceeding the design stress limits of the airplane. Factors in the accident were: the snow and fog, and the aft airplane center…Nov 23, 1995 · N3966M · DestroyedNTSB MIA96LA027Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Ocala, FLThe failure of the pilot-in-command (CFI) of the Cessna, N210PW, to see and avoid the Piper, N2114P.Nov 22, 1995 · N2114P · 2 aircraft · Substantial damageNTSB CHI96LA037Accident · 1 fatalLimited investigationFinal reportKrugler Sonerai II · Belleville, MIa loss of aircraft control due to the owner/builder's improper loading of the aircraft.Nov 22, 1995 · N36AL · DestroyedNTSB SEA96FA022Accident · 1 fatalField investigationFinal reportCessna 152 · Provo, UTpilot suicide (intentional in-flight collision with rising terrain). A factor relating to the accident was: pilot anxiety/apprehension.Nov 21, 1995 · N6392Q · DestroyedNTSB LAX96LA051Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA20-A1 · San Carlos, CAthe pilot's improper recovery from a bounced landing and failure to maintain directional control, while landing at night.Nov 21, 1995 · N402KT · Substantial damageNTSB FTW96LA050Accident · Minor injuriesLimited investigationFinal reportBeech M35 · Estancia, NMimproper maintenance and inspection of the engine, ingestion of an air intake bypass door into the engine intake, detonation (or preignition), and failure of the #1 and #2 piston and connecting rod assemblies. A factor relating to the accident was: the lack…Nov 21, 1995 · N9886R · Substantial damageNTSB FTW96FA048Accident · 1 fatalField investigationFinal reportBeech A35 · Hudson, COThe pilot's failure to maintain clearance. A factor was improper in-flight planning.Nov 21, 1995 · N8759A · DestroyedNTSB CHI96LA036Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Lacon, ILwas the compensation for wind conditions inadequate and aircraft control not maintained. A factor was directional control inadequately maintained.Nov 21, 1995 · N714QH · Substantial damageNTSB LAX96FA050Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Fullerton, CAthe pilot-in-command's failure to follow IFR procedures in that he descended below the minimum descent altitude and failed to execute a missed approach. Contributing to the accident was the pilot-in-command's self-induced pressure to get to work.Nov 20, 1995 · N888JK · DestroyedNTSB CHI96LA035Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Montrose, MIa loss of engine power as a result of the separation of the throttle push-pull cable.Nov 20, 1995 · N2296J · Substantial damageNTSB BFO96LA025Accident · No injuriesLimited investigationFinal reportSellors Kitfox IV · Pasadena, MDThe pilot's improper (abrupt) application of brakes during the landing roll. Factors relating to the accicent were: the pilot's failure to attain the proper touchdown point during the landing, and his lack of experience in the make and model of airplane.Nov 20, 1995 · N86548 · Substantial damageNTSB ATL96LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Durham, NCThe aircraft mechanic's failure to follow engine overhaul procedures which resulted in the failure of the camshaft drive gear.Nov 20, 1995 · N5057Z · Substantial damageNTSB MIA96LA025Accident · No injuriesLimited investigationFinal reportCessna 150L · Lantana, FLThe failure of the pilot-in-command to use the checklist and to set the parking brakes prior to engine start.Nov 19, 1995 · N18201 · Substantial damageNTSB LAX96FA049Accident · 1 fatalField investigationFinal reportBeech S35 · Oxnard, CAfailure of the pilot to maintain adequate airspeed during a missed approach, after encountering an undetermined propeller malfunction, which resulted in a stall and collision with the terrain. Factors relating to the accident were: darkness, fog, and the…Nov 19, 1995 · N5795K · DestroyedNTSB BFO96LA024Accident · No injuriesLimited investigationFinal reportCessna 210J · Bellefontaine, OHThe pilot unknownly left the ignition switch in right magneto-only position, while moving the propeller by hand, which allowed an inadvertent start of the engine. The weak battery was a related factor.Nov 19, 1995 · N3328S · Substantial damageNTSB BFO96LA023Accident · No injuriesLimited investigationFinal reportBeech A23-24 · New Carlisle, OHthe pilot-in-command's failure to reach the proper touchdown point. Related factors were the pilot's failure to obtain/maintain the proper glidepath during the approach, and the rough/uneven terrain encountered after the airplane touched down short of the…Nov 19, 1995 · N4758J · Substantial damageNTSB BFO96FA022Accident · 3 fatalField investigationFinal reportBeech 58 · Cleveland, OHthe pilot's improper IFR procedure, by failing to maintain a positive rate of climb (and terrain clearance) after takeoff. Factors relating to the accident were: darkness, and the lack of visual references over water and under overcast cloud conditions.Nov 19, 1995 · N721MD · DestroyedNTSB ATL96LA013Accident · No injuriesLimited investigationFinal reportFleet ONE · Holly Springs, NCa loss of engine power due to a cracked crankshaft. A factor was the rough/uneven terrain encountered during the forced landing.Nov 19, 1995 · N638M · Substantial damageNTSB SEA96FA021Accident · 3 fatalField investigationFinal reportCessna 210D · Yellow Pine, IDimproper planning/decision by the pilot, his resultant VFR flight into instrument meteorological conditions (IMC), and his failure to maintain altitude and clearance from mountainous terrain. Factors relating to the accident were: the adverse weather…Nov 18, 1995 · N3741Y · DestroyedNTSB LAX96LA048Accident · 1 fatalLimited investigationFinal reportCessna 150H · Imperial, CAthe student pilot's misreading of the altimeter while in the traffic pattern, which put the aircraft in dangerous proximity to the ground and obstructions. A factor in the accident was the pilot's inability to see the power pole due to sun glare as the…Nov 18, 1995 · N23102 · DestroyedNTSB FTW96FA046Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Cypress, TXThe pilot's failure to maintain aircraft control while flying in instrument meteorological conditions. Factors were the weather, and the failure of the airplane's vacuum pump which rendered the attitude indicator and the directional gyro inoperative.Nov 18, 1995 · N51593 · DestroyedNTSB CHI96FA034Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Stafford, KSthe pilot misjudged his distance and altitude and flew into transmission wires. A factor was the pilot's lack of recent night flying experience.Nov 18, 1995 · N93726 · DestroyedNTSB ATL96LA012Accident · No injuriesLimited investigationFinal reportWaco ASO · Ridgeland, SCFailure of the ignition system after takeoff, which resulted the loss of engine power.Nov 18, 1995 · N950E · Substantial damageNTSB ANC96LA017Accident · No injuriesLimited investigationFinal reportCessna 207 · Aniak, AKfatigue failure of the engine crankshaft at the number 2 main bearing journal, where rubbing contact had occurred with the number 2 main bearing. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.Nov 18, 1995 · N70076 · Substantial damageNTSB LAX96LA047Accident · No injuriesLimited investigationFinal reportBeech D-50 · Jackson, CAthe failure of the pilot-in-command to follow the pre-landing checklist which resulted in his failure to extend the landing gear and an inadvertent wheels-up landing.Nov 17, 1995 · N100AV · DestroyedNTSB FTW96WA342Accident · No injuriesForeign investigationPiper PA-23-160 · Tipejuanes, MexicoNov 17, 1995 · N3283P · Substantial damageNTSB FTW96IA045Incident · No injuriesIncident investigationFinal reportSaab-Scania 340B · Corsicana, TXTotal loss of power in the left engine from ice ingestion; and failure of the left-engine auto-relight system caused by an open fuse in the Digital Electronic Control Unit (DECU), which prevented an automatic relight of the left engine. Factors relating to…Nov 17, 1995 · N344SB · No damageNTSB ATL96LA011Accident · No injuriesLimited investigationFinal reportCessna 421 · Peachtree City, GADeer on the runway during a night landing that resulted in the collision.Nov 17, 1995 · N707WC · Substantial damageNTSB SEA96LA020Accident · No injuriesLimited investigationFinal reportSnow S2C · Dufer, ORA loss of engine power due to a cracked cylinder head. A factor was the evasive maneuver to avoid a ditch.Nov 16, 1995 · N1694S · Substantial damageNTSB LAX96TA046Accident · No injuriesFinal reportPiper PA-28-181 · Edwards, CAthe pilot's failure to completely release the parking brakes prior to taxi, which produced a brake over temperature condition and brake fire.Nov 16, 1995 · N92505 · Substantial damageNTSB FTW96LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Heber Springs, ARFailure of the pilot to maintain directional control of the airplane during transition from landing roll to taxi. A factor relating to the accident was: a soft area in the grass runway.Nov 16, 1995 · N6551J · Substantial damageNTSB SEA96LA019Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Wisdom, MTThe pilot's failure to maintain clearance from the fence post. Factors include sunglare, slush covered terrain, and the pilot's selection of unsuitable terrain for takeoff.Nov 15, 1995 · N5646Z · Substantial damageNTSB SEA96LA018Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Seeley Lake, MTThe pilot's selection of unsuitable terrain for landing. The snow covered runway was a factor.Nov 15, 1995 · N8431D · Substantial damageNTSB SEA96LA017Accident · No injuriesLimited investigationFinal reportPiper PA-22 · La Grande, ORThe pilot's poor judgment in attempting flight in the existing wind conditions.Nov 15, 1995 · N932A · Substantial damageNTSB MIA96LA028Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Jasper, FLImproper maintenance and inspection of the carburetor system by maintenance personnel during the last annual inspection which resulted in a partial loss of engine power due to carburetor ice. Contributing to the accident were: the pilot's failure to perform…Nov 15, 1995 · N4702S · Substantial damageNTSB SEA96LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Syracuse, UTFuel exhaustion due to the pilot's failure to refuel.Nov 14, 1995 · N4496F · Substantial damageNTSB NYC96LA025Accident · No injuriesLimited investigationFinal reportCessna 150J · Norwood, MAthe student's inadvertent use of the mixture control and the flight instructor's inadequate supervision during the final approach resulting in the loss of engine power due to fuel starvation and the subsequent nose over during the forced landing.Nov 13, 1995 · N51197 · Substantial damageNTSB MIA96LA024Accident · 2 fatalLimited investigationFinal reportRans S-12 · Plant City, FLfailure of the non-certificated pilot (unqualified person) to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall and collision with the terrain.Nov 13, 1995 · UNREG · Substantial damageNTSB MIA96LA023Accident · No injuriesLimited investigationFinal reportCessna 150 · Saltillo, MSThe failure of the pilot-in-command to perform fuel comsumption calculations before and during the flight.Nov 13, 1995 · N61040 · Substantial damageNTSB FTW96LA043Accident · Minor injuriesLimited investigationFinal reportBeech F35 · Berryville, ARThe pilot's failure to conduct an adequate preflight and remove the control locks.Nov 13, 1995 · N3299C · Substantial damageNTSB BFO96LA021Accident · Minor injuriesLimited investigationFinal reportBeech E55 · Manassas, VAfailure of the pilot to maintain control of the airplane, when the left engine lost power shortly after liftoff. Related factors were the pilot's failure to follow the checklist procedure, and his failure to ensure that the fuel selector was in the proper…Nov 13, 1995 · N36SV · DestroyedNTSB SEA96LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Douglas, WAThe pilot fell asleep.Nov 12, 1995 · N3900J · Substantial damage