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 MIA96LA155Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Wayside, MSFailure of the pilot to maintain the proper descent rate at touchdown resulting in collapse of the right main landing gear.Jun 10, 1996 · N8428V · Substantial damageNTSB IAD96LA094Accident · No injuriesLimited investigationFinal reportRotorway Exec 152 · Gretna, VAfailure of the bearing assembly shaft insert inside the main rotor shaft. Related factors are the jammed rotorcraft flight control which restricted the pilot's ability to control the helicopter and resulted in a hard touchdown.Jun 10, 1996 · N7182Z · DestroyedNTSB FTW96FA243Accident · 1 fatalField investigationFinal reportAeronca 65-CA · Lonoke, ARThe pilot's failure to maintain aircraft control.Jun 10, 1996 · N36513 · Substantial damageNTSB DCA96IA061Incident · No injuriesIncident investigationFinal reportBoeing B-737-201 · Richmond, VAThe yaw/roll upset of the airplane resulting from the movement of the rudder surface to its blowdown limit. The rudder surface most likely deflected in a direction opposite to that commanded by the pilots as a result of a jam of the main rudder power control…Jun 10, 1996 · N221US · No damageNTSB CHI96LA192Accident · No injuriesLimited investigationFinal reportCarrison-Seiman Schukert D-1 · Gardner, KSan aileron control malfunction of undetermined origin. A factor was the pilot's inability to control the airplane.Jun 10, 1996 · N51CQ · Substantial damageNTSB SEA96LA118Accident · No injuriesLimited investigationFinal reportCessna 180 · Kalispell, MTfailure of the pilot to maintain directional control, due to inadequate compensation for wind conditions. Factors relating to the accident were: the crosswind and soft/wet terrain near the edge of the runway.Jun 9, 1996 · N2411C · Substantial damageNTSB SEA96LA117Accident · Minor injuriesLimited investigationFinal reportHead Pitts S-1C · Everett, WAthe pilot's inadequate fuel management, which resulted in fuel starvation. The aircraft's lack of a fuel quantity gauge and trees in the forced landing area were related factors.Jun 9, 1996 · N7BH · Substantial damageNTSB MIA96LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Jasper, FLthe pilot's inaccurate fuel consumption calculations which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the unsuitable terrain encountered during the forced landing.Jun 9, 1996 · N9640J · Substantial damageNTSB LAX96LA227Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe failure of the pilot to adequately compensate for gusty crosswind conditions, which resulted in loss of aircraft control.Jun 9, 1996 · N737WR · Substantial damageNTSB LAX96FA223Accident · 3 fatalField investigationFinal reportCessna 172N · Bermuda Dunes, CAthe pilot's impairment of judgment and performance due to alcohol and drugs (methamphetamine, amphetamine, & marijuana), his excessive maneuvering (pull-up) after making a touch-and-go landing, and his failure to maintain sufficient airspeed, which resulted…Jun 9, 1996 · N734FB · DestroyedNTSB FTW96LA242Accident · Serious injuriesLimited investigationFinal reportAerostar S-60A · San Angelo, TXfailure of the pilot to maintain altitude or clearance from a tree, during an approach to land in a field.Jun 9, 1996 · N63286 · Minor damageNTSB CHI96LA195Accident · No injuriesLimited investigationFinal reportCessna 150M · Red Wing, MNthe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply. A factor relating to the accident was: soft terrain in the emergency landing area.Jun 9, 1996 · N9132U · Substantial damageNTSB ANC96LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe obstruction of the left rudder pedal and brake by the battery cable.Jun 9, 1996 · N8560C · Substantial damageNTSB SEA96LA116Accident · No injuriesLimited investigationFinal reportCessna 172L · Sisters, ORthe pilot's inadequate compensation for wind conditions during a go-around, which resulted in his failure to maintain proper runway alignment. Factors relating to the accident were: the variable/gusty crosswind condition, and the proximity of the hanger and…Jun 8, 1996 · N7849G · Substantial damageNTSB MIA96LA152Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · San Juan, PRFailure of the student pilot to maintain the proper descent rate resulting in a hard landing. Contributing to the accident was: the failure of other maintenance personnel to remove tape that was placed by company personnel over each static port before washing…Jun 8, 1996 · N821RR · Substantial damageNTSB FTW96LA244Accident · No injuriesLimited investigationFinal reportHughes 269 · Dallas, TXThe student pilot's encounter with dynamic rollover while hovering. Factors were the prevailing high winds and the inadequate supervision provided by the flight instructor.Jun 8, 1996 · N269A · Substantial damageNTSB FTW96LA241Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Dumas, TXThe failure of the right main gear torque link during landing roll as a result of its improper assembly by maintenance personnel.Jun 8, 1996 · N2004L · Substantial damageNTSB FTW96IA240Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Denver, COphysical impairment of the captain due to a probable cardiac event.Jun 8, 1996 · N11004 · No damageNTSB CHI96LA197Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Custer, SDthe pilot did not maintain aircraft control or abort the takeoff. The factors involved were the pilot encountered a stall/mush condition, exhaust valves were leaking, low compression on all cylinders, and all pistons were scored.Jun 8, 1996 · N39048 · Substantial damageNTSB SEA96LA115Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Tooele, UTfailure of the flight instructor (CFI) to ensure that adequate airspeed was maintained during initial climb after lift-off, which resulted in an inadvertent stall/mush. High density altitude was a related factor.Jun 7, 1996 · N9594V · Substantial damageNTSB SEA96LA114Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Roundup, MTfailure of the pilot to maintain adequate airspeed, during a turn-around maneuver after a swath run, which resulted in an inadvertent stall.Jun 7, 1996 · N4970J · DestroyedNTSB NYC96LA122Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Danbury, CTthe safety pilot's raising of the flaps, while the airplane was at an inadequate airspeed during the aborted landing, which resulted in a stall, uncontrolled descent, and subsequent collision with parked airplanes.Jun 7, 1996 · N11637 · DestroyedNTSB LAX96LA224Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Santa Clarita, CAthe pilot's failure to abandon the pinnacle approach after encountering an excessive rate of descent.Jun 7, 1996 · N40009 · Substantial damageNTSB LAX96LA222Accident · No injuriesLimited investigationFinal reportBoeing 737-322 · San Francisco, CAinadequate visual lookout by the United Airlines tug driver during the pushback operation. Contributing factors were: the driver's reduced ability to observe the American B-767 due to the nighttime condition, and United Airlines management's failure to ensure…Jun 7, 1996 · N371UA · 2 aircraft · Substantial damageNTSB LAX96LA221Accident · No injuriesLimited investigationFinal reportBeech 23-A24R · Modesto, CAfuel exhaustion due to the pilot's inadequate preflight inspection of the aircraft.Jun 7, 1996 · N102KB · DestroyedNTSB LAX96FA226Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Goleta, CAfailure of the flying pilot to maintain control of the airplane, due to spatial disorientation, which resulted in an uncontrolled descent and collision with the water. Factors relating to the accident were: the lack of recent instrument experience by the…Jun 7, 1996 · N4303X · DestroyedNTSB IAD96LA092Accident · No injuriesLimited investigationFinal reportBeech V35B · Westminster, MDThe fracture of the engine crankshaft which had a subsurface origin and progressed in fatigue until overload and separation occurred.Jun 7, 1996 · N369JR · Substantial damageNTSB FTW96FA239Accident · 2 fatalField investigationFinal reportFredenburg Challenger II · Longview, TXthe pilot-in-command's failure to maintain airspeed. A factor was the pilot's lack of total experience in the make/model.Jun 7, 1996 · N2087P · DestroyedNTSB SEA96LA113Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Aberdeen, IDpilot's improper planning/decision, and subsequent incapacitation, which resulted in a loss of aircraft control and collision with the terrain. Factors relating to the accident were: pilot fatigued from a long-distance drive with minimal rest, physical…Jun 6, 1996 · N5686X · Substantial damageNTSB SEA96LA112Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Prescott, WAfailure of the pilot to visually clear his flight path, after allowing his attention to be diverted, and his resultant failure to maintain sufficient altitude/clearance from a hill. The hilly terrain was a related factor.Jun 6, 1996 · N9793 · Substantial damageNTSB NYC96LA121Accident · No injuriesLimited investigationFinal reportPiper J-3 · Chester, CTthe pilot's improper use of rudder control to maintain directional control during landing.Jun 6, 1996 · N68952 · Substantial damageNTSB MIA96LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Crestview, FLFailure of the pilot-in-command to maintain the proper descent rate on landing resulting in separation of the nose landing gear after touchdown. Contributing to the accident was the pilot's lack of experience in the type of operation.Jun 6, 1996 · N5464B · Substantial damageNTSB LAX96FA228Accident · No injuriesField investigationFinal reportBritish Aerospace BA-3100/3201 · San Luis Obispo, CAThe flight crew's loss of directional control resulting from an attempted takeoff with the left propeller on the start lock. Factors in the accident were: the lack of cockpit caution/warning system/lights available to verify that the propellers are out of the…Jun 6, 1996 · N926AE · Substantial damageNTSB FTW96LA238Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Leadville, COInadequate preflight planning and preparation and failure to follow aircraft operating procedures and directives. Factors were high density altitude, inadequate training of the flight instructor and insufficient standards and requirements for flight…Jun 6, 1996 · N9431D · Substantial damageNTSB CHI96IA191Incident · No injuriesIncident investigationFinal reportBeech 1900 · Lansing, MIthe short in the windshield anti-ice low power braided copper lead wire caused a fire that had resulted from the manufacturer's inadequate design.Jun 6, 1996 · N81538 · Minor damageNTSB ATL96FA090Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Lawrenceville, GAThe pilot's inadequate fuel consumption calculations that resulted in fuel exhaustion. A factor was the pilot's failure to follow the emergency procedure for a forced landing, in that the flaps were not extended.Jun 6, 1996 · N8818J · Substantial damageNTSB ANC96IA085Incident · No injuriesIncident investigationFinal reportChampion 7GCBC · Naknek, AKThe inadequate visual lookout of the vehicle driver, and the inadequate visual lookout of the pilot. A factor was the State of Alaska's failure to provide taxiway hazard warning signs which would alert vehicles of the active aerodrome.Jun 6, 1996 · N9113L · Minor damageNTSB SEA96LA111Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Coquille, ORthe pilot's inadequate evaluation of wind conditions, and his subsequent failure to initiate a go-around in a timely manner, which resulted in his inability to maintain clearance with trees during the go-around. Factors relating to the accident included a…Jun 5, 1996 · N9875L · Substantial damageNTSB MIA96FA148Accident · 1 fatalField investigationFinal reportAeronca O-58B · Greenville, SCthe pilot's failure to maintain adequate altitude/clearance from power lines while maneuvering at a low altitude.Jun 5, 1996 · N49546 · DestroyedNTSB LAX96LA237Accident · No injuriesLimited investigationFinal reportCessna 172N · Ramona, CAthe pilot's misjudged and delayed landing flare, and inadequate recovery technique from a bounced landing (porpoise). Sun glare was a factor in the accident.Jun 5, 1996 · N738PS · Substantial damageNTSB LAX96LA219Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Paso Robles, CAthe student pilot's loss of control and subsequent dynamic rollover due to his abrupt and excessive use of the collective and anti-torque controls.Jun 5, 1996 · N2311R · Substantial damageNTSB IAD96LA091Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · New Carlisle, OHinadequate maintenance and inspection, and the pilot overshooting the approach to land.Jun 5, 1996 · N5984P · Substantial damageNTSB FTW96IA237Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 (MD-82) · Albuquerque, NMthe flightcrew's inadvertent encounter with windshear at low altitude. Factors were: variable winds, high density altitude, and the FAA's inadequate location/height of the LLWAS sensor.Jun 5, 1996 · N224AA · Minor damageNTSB ANC96LA084Accident · No injuriesLimited investigationFinal reportSwearingen SA-26 · Galena, AKthe pilot's selection of an unsuitable landing site. Factors associated with the accident were the soft and uneven airstrip conditions.Jun 5, 1996 · N501FS · Substantial damageNTSB ANC96LA083Accident · No injuriesLimited investigationFinal reportChampion 7AC · Clear, AKthe pilot's inadequate preflight inspection in that he failed to ensure that the cabin door was properly secured for takeoff. Factors associated with the accident were: the open cabin door and rough/uneven terrain.Jun 5, 1996 · N83995 · Substantial damageNTSB FTW96LA236Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Dumas, ARFailure of all personnel concerned to identify the unsafe/hazardous condition, which resulted from a visual restriction, due to trees near the intersection of the road and runway.Jun 4, 1996 · N3646X · Substantial damageNTSB CHI96LA190Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Oskaloosa, KSfailure of the pilot to maintain proper alignment with the roadway during the takeoff roll. A factor relating to the accident was: the selection of an unsuitable area for takeoff.Jun 4, 1996 · N9408R · DestroyedNTSB ANC96LA082Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Akiachak, AKThe pilot's inadequate compensation for the variable crosswind conditions. Factors associated with the accident were the variable crosswinds and the short runway.Jun 4, 1996 · N91052 · Substantial damageNTSB ANC96FA081Accident · 1 fatalField investigationFinal reportRobinson R-22 Mariner · Mekoryuk, AKA loss of engine power due to fuel contamination found in the fuel supply and helicopter fuel system. Factors in the accident were the pilot's inadequate filtration (servicing of the helicopter) of the fuel supply, and the pilot's inadequate performance of…Jun 4, 1996 · N113CF · DestroyedNTSB IAD96LA089Accident · No injuriesLimited investigationFinal reportPiper PA60-601P · Willard, OHthe pilot's inability to maintain directional control of the airplane during the landing flare/touchdown.Jun 3, 1996 · N86AT · Substantial damage