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 FTW96LA272Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Holyoke, COthe total failure of the engine main bearing. A factor was the soft terrain condition on which the forced landing was made.Jun 22, 1996 · N4698 · Substantial damageNTSB FTW96LA271Accident · Serious injuriesLimited investigationFinal reportBoeing 737-201 · Granite, COAn encounter with clear air turbulence.Jun 22, 1996 · N207AU · No damageNTSB FTW96FA268Accident · 1 fatalField investigationFinal reportJones Peckerwood 1A1 · La Porte, TXimproper installation and subsequent failure of the elevator control cable clamps which led to the pilot's restricted pitch control and resultant stall/spin.Jun 22, 1996 · N92506 · DestroyedNTSB CHI96FA209Accident · 2 fatalField investigationFinal reportBeech 23 · Fulton, MOthe inadequate intake valve springs on the #1 cylinder.Jun 22, 1996 · N2397J · DestroyedNTSB SEA96FA134Accident · 2 fatalField investigationFinal reportCessna 150B · Hailey, IDthe pilot's improper planning/decision, and his failure to maintain adequate airspeed during a climb over rising terrain, which resulted in a stall and collision with terrain. Factors relating to the accident were: failure of the pilot to ensure the airplane…Jun 21, 1996 · N1236Y · DestroyedNTSB SEA96FA133Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Pomeroy, WAThe pilot's failure to maintain adequate clearance with the surrounding terrain while maneuvering to land. A factor was the rising terrain conditions.Jun 21, 1996 · N57514 · DestroyedNTSB LAX96LA240Accident · 1 fatalLimited investigationFinal reportExperimental Mini Mustang · Page, AZthe pilot's inadequate compensation for crosswind conditions, and his failure to maintain control of the aircraft. A factor relating to the accident was: the gusty/crosswind condition.Jun 21, 1996 · N61D · DestroyedNTSB LAX96LA239Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lamont, CAfailure of the pilot to see-and-avoid a guy wire along the border of a field that was being agriculturally treated. The sunglare, guy wire, and lack of visual cues were related factors.Jun 21, 1996 · N2456E · Substantial damageNTSB FTW96LA269Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-340-200 · Dfw Airport, TXThe flightcrew's abrupt maneuver/descent in response to a TCAS RA. Factors were the company assignment of the captain to the crew position with a lack of captain training.Jun 21, 1996 · DAIBE · No damageNTSB FTW96LA266Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Abilene, TXfuel mismanagement by the pilot, which resulted in fuel starvation; and the pilot's failure to reposition the fuel selector (follow emergency procedure) while attempting to restart the engine. A factor relating to aircraft damage was: concrete debris (rocks)…Jun 21, 1996 · N40954 · Substantial damageNTSB FTW96FA267Accident · 4 fatalField investigationFinal reportBeech 58 · Castle Rock, COfailure of the pilot to maintain sufficient altitude and/or clearance from terrain, while reversing course to exit adverse weather conditions. Factors relating to the accident were: the adverse weather conditions (thunderstorm, low ceiling and reduced…Jun 21, 1996 · N94ZR · DestroyedNTSB FTW96FA265Accident · 4 fatalField investigationFinal reportMbb BO-105 · Sabine Pass, TXThe failure of the sun gear within the main transmission resulting in the main rotor system not being driven.Jun 21, 1996 · N2906T · DestroyedNTSB CHI96LA212Accident · No injuriesLimited investigationFinal reportBeech C23 · Ainsworth, NEthe pilot's inadequate fuel consumption calculations which led to fuel exhaustion and the pilot's selection of an unsuitable landing area for the forced landing.Jun 21, 1996 · N6014F · Substantial damageNTSB SEA96LA132Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Hazleton, IDpartial loss of engine power for undetermined reason(s). Factors relating to the accident were: high density altitude; the pilot's delay in dumping the entire chemical load, when he first perceived a power loss; and rough/uneven terrain in the emergency…Jun 20, 1996 · N9970P · Substantial damageNTSB SEA96IA131Incident · No injuriesIncident investigationFinal reportBoeing 767-332 · Salt Lake City, UTfailure of maintenance personnel to properly disconnect (disengage) the right integrated drive generator (IDG) in compliance with the MEL dispatch procedure, which allowed the right IDG to overheat. Factors relating to the incident were: low oil pressure in…Jun 20, 1996 · N136DL · Minor damageNTSB LAX96LA238Accident · Minor injuriesLimited investigationFinal reportCessna 182RG · Page, AZthe pilot's inadequate compensation for wind conditions, and failure to maintain control of the aircraft. Factors relating to the accident were: the gusty and crosswind conditions.Jun 20, 1996 · N6309T · DestroyedNTSB FTW96LA264Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Littlefield, TXThe total loss of engine power due to the failure of the number 5 and 6 connecting rods. A factor was the lack of suitable terrain for the forced landing.Jun 20, 1996 · N57836 · Substantial damageNTSB FTW96LA263Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec AN-2 · Weir, TXengine seizure for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Jun 20, 1996 · N67AN · Substantial damageNTSB FTW96FA262Accident · Minor injuriesField investigationFinal reportDouglas DC3A · Cut And Shoot, TXThe flight instructor's failure to use the single engine best angle of climb airspeed resulting in a loss of control of the aircraft. Factors were the loss of power to the left engine for undetermined reasons, the flight instructor not being qualified to be…Jun 20, 1996 · N23WT · DestroyedNTSB CHI96LA208Accident · No injuriesLimited investigationFinal reportAerotechnik L-13 · Wichita, KSthe pilot's inadequate in-flight planning. Factors were the insufficient altitude and the dead battery.Jun 20, 1996 · N21400 · Substantial damageNTSB SEA96LA126Accident · No injuriesLimited investigationFinal reportPrice Berkut · Jackson, WYfailure of the electrically driven hydraulic pump; and the absence of the main landing gear over-center downlock springs, which were not installed by the previous owner/builder.Jun 19, 1996 · N538AJ · Substantial damageNTSB SEA96FA130Accident · 1 fatalField investigationFinal reportHughes 269C · Eldon, WAfatigue failure of the connecting rod cap, which resulted in loss of engine power and ditching at sea.Jun 19, 1996 · N7400F · DestroyedNTSB MIA96LA160Accident · No injuriesLimited investigationFinal reportCessna 150L · Sanford, FLfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in a ground swerve and subsequent nose over.Jun 19, 1996 · N11532 · Substantial damageNTSB LAX96FA236Accident · 3 fatalField investigationFinal reportBeech C23 · Los Angeles, CAcompany maintenance personnel's inadequate service of the magneto system, and their failure of to replace the electric fuel boost pump, which led to a malfunctioning right magneto and an inoperative fuel boost pump. The inoperative fuel boost pump made it…Jun 19, 1996 · N66343 · DestroyedNTSB IAD96FA100Accident · 1 fatalField investigationFinal reportPiper PA-31-325 · Springboro, OHthe pilot's impairment of judgment and performance due to drugs which led to spatial disorientation and a loss of aircraft control. The weather was a factor.Jun 19, 1996 · N62852 · DestroyedNTSB FTW96LA259Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Arlington, TXinadequate instruction by the flight instructor (CFI), and his inadequate supervision of the dual student. Factors relating to the accident were: the student pilot's failure to understand or select the normal (hand) brakes.Jun 19, 1996 · N6634J · Substantial damageNTSB CHI96TA260Accident · No injuriesFinal reportSchweizer SGS 2-33AK · Mattoon, ILthe pilot's failure to maintain directional control of the glider. Factors were the runway sign and the failure of the pilot to maintain a visual lookout.Jun 19, 1996 · N65809 · Substantial damageNTSB CHI96FA211Accident · 1 fatalField investigationFinal reportMcDonnell Douglas F/A-18C · Bethalto, ILthe pilot's failure to follow the preflight crew briefing and attain a proper altitude during an aerobatic maneuver. Factors in the accident were: the pilot's previous experience of flying similar airshow routines in a different airplane with substantially…Jun 19, 1996 · N16518 · DestroyedNTSB IAD96IA098Incident · No injuriesIncident investigationFinal reportBoeing 747-136 · Jamaica, NYfailure of the constant speed drive (CSD) to disconnect from the generator. Contributing to the cause was the failure of the FAA approved overhaul facility to follow the manufacturer's overhaul manual.Jun 18, 1996 · N606FF · Minor damageNTSB FTW96TA261Accident · Minor injuriesFinal reportBell 212 · Pagosa Springs, COThe pilot's failure to comply with performance data for hover out of ground effect. A factor was not attaining load jettison.Jun 18, 1996 · N91AL · DestroyedNTSB FTW96LA258Accident · Serious injuriesLimited investigationFinal reportAir Tractor 301A · Hunter, ARThe loss of engine power for undetermined reasons.Jun 18, 1996 · N7319C · DestroyedNTSB ANC96LA091Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe flight instructor's excessive application of the brakes during the landing roll. A factor in the accident was the flight instructor's restricted view of the landing area.Jun 18, 1996 · N27036 · Substantial damageNTSB MIA96LA159Accident · No injuriesLimited investigationFinal reportCessna 150M · Knightdale, NCfailure of the flight instructor (CFI) to ensure proper use of the carburetor heat, which resulted in carburetor ice, loss of engine power, and a subsequent emergency landing.Jun 17, 1996 · N47ES · Substantial damageNTSB LAX96LA232Accident · Minor injuriesLimited investigationFinal reportMoore Goshawk 350 · Livermore, CAan overstress failure of the left rudder cable.Jun 17, 1996 · N345RM · DestroyedNTSB LAX96FA244Accident · 2 fatalField investigationFinal reportCessna 152 · Carmel, CAThe pilot becoming lost and disoriented during a night VFR flight in marginal weather conditions. Factors in the accident were: the pilot's lack of night flying experience, his failure to obtain a preflight weather briefing, low ceilings, and his failure to…Jun 17, 1996 · N6198P · DestroyedNTSB FTW96LA260Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 · Prescott, ARThe loss of engine power due to improper fuel. Factors were the pilot's inadequate preflight and lack of suitable terrain for the forced landing.Jun 17, 1996 · N6210Z · Substantial damageNTSB FTW96LA253Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Leander, TXfailure of the pilot sufficiently slow the airplane, while landing on a grass runway.Jun 17, 1996 · N8129P · Substantial damageNTSB FTW96LA252Accident · No injuriesLimited investigationFinal reportHarmon RV-3 Rocket · Houston, TXThe improper installation of the fuel line with insufficient clearance from the exhaust system, resulting in a hole being burned into the fuel line.Jun 17, 1996 · N41HR · DestroyedNTSB ANC96LA090Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing and the failure to maintain directional control of the airplane. A factor in the accident was an airstrip that was rough and uneven.Jun 17, 1996 · N2848C · Substantial damageNTSB SEA96LA124Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Gardiner, WAthe pilot's inadequate compensation for wind conditions and failure to maintain the proper altitude/clearance from obstruction(s), while on final approach. Factors relating to the accident were: the downdraft, and the obstruction (tree).Jun 16, 1996 · N1159C · Substantial damageNTSB SEA96LA123Accident · No injuriesLimited investigationFinal reportCessna 182 · Roche Harbor, WAthe pilot's inadequate compensation for wind conditions and failure to attain a proper touchdown point for landing. Factors relating to the accident were: downdraft conditions and soft/uneven terrain short of the runway.Jun 16, 1996 · N5686B · DestroyedNTSB SEA96LA122Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Wilsonville, ORfailure of the pilot to maintain clearance from the static wire, which became shorted to a transmission wire and subsequently caused a fire to erupt on the balloon's envelope. Factors relating to the accident were: the obstructions (power line wires), and the…Jun 16, 1996 · N71233 · Substantial damageNTSB MIA96LA158Accident · Minor injuriesLimited investigationFinal reportAeronca 11-AC · Green Cove Spgs, FLThe pilot's improper planning/decision by failing to ensure that the airplane would be able to clear obstructions at the end of the runway, while taking off with a tailwind component; and his failure (or inability) to flare the airplane after turning back to…Jun 16, 1996 · N9261E · Substantial damageNTSB LAX96LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Avalon, CAthe pilot's failure to initiate a landing flare, which resulted in a bounced landing and porpoise, and his loss of directional control during an attempt to initiate a go-around with insufficient airspeed, which resulted in an inadvertent stall/mush and…Jun 16, 1996 · N6261D · Substantial damageNTSB LAX96LA234Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G102 · Mesquite, NVimproper in-flight planning/decision by the pilot, which resulted in his being forced to land in an area with unsuitable terrain. Factors relating to the accident were: the lack of available (thermal) lift, downdraft(s), and the resultant lack of suitable…Jun 16, 1996 · N154SS · DestroyedNTSB IAD96LA099Accident · No injuriesLimited investigationFinal reportAeronca L-3B · Morgantown, WVAn inadequate maintenance/annual inspection and failure of the muffler which resulted in melted insulation on the magneto 'P' leads and subsequent loss of engine power. A related factor was the lack of suitable terrain for the forced landing.Jun 16, 1996 · N46634 · Substantial damageNTSB IAD96LA097Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Ashton, MDthe pilot's inadequate fuel supply which resulted in a fuel exhaustion and a loss of engine power. A related factor was the pilot's inadequate fuel consumption calculations.Jun 16, 1996 · N58379 · Substantial damageNTSB FTW96LA257Accident · Minor injuriesLimited investigationFinal reportOwens/Smyth Sidewinder · Minden, LAThe pilot's improper fuel consumption calculations resulting in fuel exhaustion. A factor was the unsuitable terrain for the forced landing.Jun 16, 1996 · N177TJ · DestroyedNTSB FTW96LA255Accident · No injuriesLimited investigationFinal reportCessna 152 · Hobart, OKthe pilot became lost/disoriented, and failed to properly use information that was provided by ATC, which resulted in fuel exhaustion and an encounter with soft terrain during an emergency landing. A factor relating to the accident was: the lack of suitable…Jun 16, 1996 · N93139 · Substantial damageNTSB ATL96LA093Accident · No injuriesLimited investigationFinal reportCessna 177RG · Lake Placid, FLmaintenance personnel's failure to properly torque the cylinder installation bolts.Jun 16, 1996 · N2186Q · Substantial damage