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 FTW96LA084Accident · No injuriesLimited investigationFinal reportLearjet 60 · Aspen, COThe pilot's improper in-flight decision to continue with the landing when the runway had not been positively identified. Factors were the snow-covered runway and landing area, sun glare, and the inadequate snow removal by airport personnel.Jan 6, 1996 · XAICA · Substantial damageNTSB ATL96FA029Accident · 1 fatalField investigationFinal reportCessna 210H · Columbia, TNfailure of the pilot to follow procedures/directives by flying in instrument meteorological conditions (IMC) without proper training/certification; and his failure (or inability) to follow proper IFR procedures and maintain proper altitude during an…Jan 6, 1996 · N44DJ · Substantial damageNTSB SEA96FA039Accident · Minor injuriesField investigationFinal reportConvair 340 · Spokane, WAthe pilot's improper management of the fuel/system, which resulted in loss of power in both engines, due to fuel starvation. Factors relating to the accident were: false indications of the cockpit fuel gauges, darkness, and the presence of a berm in the…Jan 5, 1996 · N358SA · DestroyedNTSB LAX96IA087Incident · No injuriesIncident investigationFinal reportBoeing 747-251B · Los Angeles, CAThe fatigue fracture of the number 4 bearing oil pressure tube due to an improper maintenance cleaning procedure by company maintenance personnel.Jan 5, 1996 · N628US · Minor damageNTSB SEA96LA038Accident · No injuriesLimited investigationFinal reportBeech B100 · Miles City, MTFailure of airport personnel to properly remove snow from the runway or issue an appropriate notam concerning the runway condition. Factors relating to the accident were: the low light condition at dawn, and the snowbank or berm that was left on the runway.Jan 4, 1996 · N924WS · Substantial damageNTSB NYC96WA049Accident · No injuriesForeign investigationLearjet 35A-305 · Ontario, CanadaJan 4, 1996 · N33NJ · Substantial damageNTSB CHI96LA071Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Zionsville, INthe pilot's failure to properly align the airplane for a safe landing on the runway. Related factors were: the pilot's inadequate preflight planning/preparation, snow, the snow-covered runway, and snowbanks on the sides of the runway.Jan 4, 1996 · N111UC · Substantial damageNTSB SEA96LA045Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Camas, WAFailure of the pilot to ensure that the landing gear was extended before landing.Jan 3, 1996 · N6297P · Substantial damageNTSB MIA96WA056Accident · 3 fatalForeign investigationCessna 182M · Trujillo, HondurasJan 3, 1996 · N91682 · Substantial damageNTSB SEA96LA037Accident · No injuriesLimited investigationFinal reportCessna 170B · Baker City, ORthe pilot's premature lift-off and inadequate airspeed following liftoff. His use of a public highway as a takeoff area, and a motor vehicle on the highway, were factors.Jan 2, 1996 · N2761D · Substantial damageNTSB SEA96FA036Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Lehi, UTcontinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude and/or clearance from mountainous terrain. Factors relating to the accident were: darkness, low ceiling, and snow.Jan 2, 1996 · N8870W · DestroyedNTSB NYC96LA048Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Silver Spring, PAA loss of engine power as a result of fuel exhaustion.Jan 1, 1996 · N1082P · Substantial damageNTSB MIA96FA051Accident · 2 fatalField investigationFinal reportCessna 550 · East Naples, FLThe pilot's disregard for the MDA for a specific segment of the VOR/DME approach which resulted in the inflight collision with a guy wire of an antenna and separation of 8.5 feet of the left wing.Dec 31, 1995 · N91MJ · DestroyedNTSB NYC96LA046Accident · No injuriesLimited investigationFinal reportCessna 172N · Wildwood, NJfailure of the student pilot to maintain directional control of the airplane. Factors relating to the accident were: the student's selection of the wrong runway, and the crosswind condition.Dec 30, 1995 · N733CL · Substantial damageNTSB MIA96LA052Accident · Minor injuriesLimited investigationFinal reportMooney M20 · Eastover, SCinadequate overhaul procedures by maintenance personnel resulting in an oil pump failure and subsequent loss of engine power.Dec 30, 1995 · N3750H · Substantial damageNTSB LAX96LA090Accident · Serious injuriesLimited investigationFinal reportATR ATR 42-300 · Honolulu, HIthe flight attendant's decision to leave her seat in an area of forecast and known moderate turbulence. The turbulence was a related factor.Dec 30, 1995 · N4202G · No damageNTSB LAX96LA089Accident · No injuriesLimited investigationFinal reportAerostar RX-8 · Lucerne Valley, CAthe balloon's encounter with unexpected high wind conditions, and the pilot's inability to stop the balloon prior to contacting ground obstructions.Dec 30, 1995 · N70107 · Substantial damageNTSB LAX96FA086Accident · 4 fatalField investigationFinal reportBeech V35B · Delano, CAFailure of the pilot to maintain control of the aircraft during an IFR circling approach. A factor relating to the accident was: the pilot's lack of instrument flight experience in high performance aircraft.Dec 30, 1995 · N7337R · DestroyedNTSB FTW96LA082Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Durango, COthe failure of the nose wheel steering mechanism which rendered the aircraft uncontrollable on the ground. A factor was the rough and uneven terrain.Dec 30, 1995 · N7356V · Substantial damageNTSB CHI96FA067Accident · 2 fatalField investigationFinal reportCessna 560 · Eagle River, WIthe failure of the pilot to maintain airspeed while executing the circling approach. Factors were the descent below minimum descent altitude, the fog, the low ceiling and the icing conditions.Dec 30, 1995 · N991PC · DestroyedNTSB BFO96LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Hudson, OHthe pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion and a loss of engine power due to an inadequate supply of fuel. Factors relating to the accident were: false fuel quantity indication from the left fuel quantity gauge,…Dec 30, 1995 · N47316 · Substantial damageNTSB BFO96FA034Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Louisville, KYfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall, loss of altitude, and subsequent collision with obstructions (utility pole and supporting cable).Dec 30, 1995 · N7676J · DestroyedNTSB ANC96LA024Accident · No injuriesLimited investigationFinal reportCessna 180 · Tanana, AKThe icing of the induction/intake screen and the pilot's improper planning/decision by electing to takeoff into suspended snow and ice crystals.Dec 30, 1995 · N4762B · Substantial damageNTSB NYC96LA045Accident · No injuriesLimited investigationFinal reportCessna 150J · Kutztown, PAthe student pilot's selection of an unsuitable runway for landing. The snow covered runway was a related factor.Dec 29, 1995 · N50836 · Substantial damageNTSB NYC96LA044Accident · 1 fatalLimited investigationFinal reportCessna 182E · Pymatuning, PAthe pilot's intentional suicide.Dec 29, 1995 · N3290Y · DestroyedNTSB LAX96LA092Accident · No injuriesLimited investigationFinal reportClassic Waco YMF · Kailua Kona, HIThe failure of the Waco pilot to see and avoid the opposite direction Cessna 172 while both aircraft were taxiing in a non-movement area of the airport. Factors in the accident were: the congested nature of the taxi lane, which limited the Waco pilot's…Dec 29, 1995 · N40115 · 2 aircraft · Substantial damageNTSB LAX96LA088Accident · No injuriesLimited investigationFinal reportCessna 150L · Quartzite, AZthe pilot's misjudgement of his distance and altitude relationship to the runway, which resulted in an undershoot and failure to achieve the proper touchdown point for landing.Dec 29, 1995 · N1246Q · Substantial damageNTSB CHI96LA070Accident · No injuriesLimited investigationFinal reportCessna 310R · Minocqua, WIthe pilot's failure to maintain adequate airspeed during the landing. The weather and ice accumulation on the airplane were factors.Dec 29, 1995 · N68300 · Substantial damageNTSB CHI96LA069Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12 · Winner, SDthe pilot's failure to maintain airspeed during takeoff. A factor was the pilot's diversion of his attention to a perceived engine problem.Dec 29, 1995 · N39244 · Substantial damageNTSB ATL96LA028Accident · No injuriesLimited investigationFinal reportBoeing 737-232 · Atlanta, GAFailure of the tug driver, who was towing the Lockheed L-1011, to ensure that clearance was maintained from the Boeing 737, which was standing.Dec 29, 1995 · N306DL · Substantial damageNTSB MIA96LA050Accident · 2 fatalLimited investigationFinal reportNanchang China CJ6A · Planterville, SCfailure of the pilot to maintain sufficient altitude or clearance from trees.Dec 28, 1995 · N3104U · DestroyedNTSB LAX96LA084Accident · Minor injuriesLimited investigationFinal reportNicholson Sonerai II · Ramona, CAan interruption of fuel flow to the engine due to a misrouted fuel vent line.Dec 28, 1995 · N68676 · Substantial damageNTSB FTW96LA081Accident · No injuriesLimited investigationFinal reportRepublic RC 3 · Whitewright, TXThe separation of a spark plug and 4 other spark plugs being 'finger' tight as a result of undertorquing by maintenance personnel when they were reinstalled following inspection. A factor was a lack of suitable terrain for the forced landing.Dec 28, 1995 · N6127K · Substantial damageNTSB CHI96LA064Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Munich, NDthe pilot allowed his airspeed to get too low and encountered a stall/mush condition. Factors associated with the accident were the pilot not being able to maintain directional control due to misuse of the controls for wind drift correction and improper use…Dec 28, 1995 · N88384 · Substantial damageNTSB CHI96IA066Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Bemidji, MNinadequate maintenance installation and inspection of the elevator flight control system which led to restricted flight control elevator movement due to a loose bolt.Dec 28, 1995 · N159MC · No damageNTSB BFO96LA033Accident · No injuriesLimited investigationFinal reportCessna 210 · Baltimore, MDfailure of the pilot to ensure that the landing gear was fully down and locked before landing.Dec 28, 1995 · N450EM · Substantial damageNTSB MIA96FA049Accident · Serious injuriesField investigationFinal reportPiper PA-46-310P · Ocala, FLoil starvation resulting in connecting rod failure in three of the six cylinders due to lack of lubrication. Contributing to the accident was the failure of the pilot to adhere to a ATC vector toward the nearest airport following engine failure which resulted…Dec 27, 1995 · N800SJ · Substantial damageNTSB LAX96LA100Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Folsom Lake, CAthe flight instructor's inadequate supervision of the dual student and improper remedial action. A factor relating to the accident was: failure of the student pilot to maintain directional control.Dec 27, 1995 · N5LY · Substantial damageNTSB LAX96FA082Accident · No injuriesField investigationFinal reportCessna 152 · Long Beach, CAa partial power loss due to carburetor icing resulting from existing environmental conditions and the pilot's failure to apply carburetor heat during descent.Dec 27, 1995 · N53321 · Substantial damageNTSB FTW96LA079Accident · No injuriesLimited investigationFinal reportMeyers MY-200A · Madill, OKthe deterioration of the fuel supply line resulting in line blockage, fuel starvation, and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.Dec 27, 1995 · N484C · Substantial damageNTSB FTW96LA078Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Kaufman, TXThe loss of engine power due to a bent push rod and the resultant loss of oil. Factors were the cockpit smoke and the lack of suitable terrain for the forced landing.Dec 27, 1995 · N5221P · Substantial damageNTSB FTW96LA077Accident · Minor injuriesLimited investigationFinal reportStinson ST-108-2 · Lake Dallas, TXthe failure of the #6 connecting rod assembly. A factor was the lack of suitable terrain for a forced landing which resulted in a water landing.Dec 27, 1995 · N135C · DestroyedNTSB CHI96LA062Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Excelsior Sprg, MOthe pilot's selection of the wrong runway for landing and the delayed aborted landing. Factors associated with the accident were the tailwind condition and the pilot's inadequate level-off.Dec 27, 1995 · N172DA · Substantial damageNTSB ANC96LA023Accident · No injuriesLimited investigationFinal reportCessna 337G · Stevens Village, AKThe pilot's failure to maintain proper runway alignment during the approach and landing roll. A factor associated with the accident is the reduced visibility created by the falling snow.Dec 27, 1995 · N990LB · Substantial damageNTSB NYC96LA043Accident · No injuriesLimited investigationFinal reportPiper J3F · Westerly, RIthe pilot's inadequate compensation for the wind condition, which subsequently resulted in the aircraft nosing over. The gusty crosswind condition was a related factor.Dec 26, 1995 · N28148 · Substantial damageNTSB LAX96LA081Accident · No injuriesLimited investigationFinal reportCessna 150M · Quartzsite, AZthe failure of the pilot to maintain directional control during landing.Dec 26, 1995 · N66172 · Substantial damageNTSB LAX96LA079Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fallbrook, CAthe pilot's inadequate preflight planning/preparation (failure to ensuring the flight information publication was current); his selection of the wrong runway for landing; his failure to achieve the proper touchdown point during the landing; and his failure to…Dec 26, 1995 · N97196 · Substantial damageNTSB LAX96FA080Accident · Minor injuriesField investigationFinal reportCessna 152 · Compton, CAa push rod failed from fatigue as a result of longitudinal stress corrosion cracking.Dec 26, 1995 · N6110Q · DestroyedNTSB ATL96FA027Accident · 2 fatalField investigationFinal reportPiper J-3-C65 · Belzoni, MSfailure of the student pilot to maintain adequate airspeed, while maneuvering, which resulted in a stall/spin and subsequent collision with the ground.Dec 26, 1995 · N3615K · Substantial damageNTSB FTW96IA080Incident · No injuriesIncident investigationFinal reportBeech 1900C · Denver, COfailure by the outside contractor to perform adequate maintenance, and failure by the operator to perform an adequate inspection.Dec 25, 1995 · N39019 · No damage