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 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.NTSB 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.NTSB FTW96FA243Accident · 1 fatalField investigationFinal reportAeronca 65-CA · Lonoke, ARThe pilot's failure to maintain aircraft control.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB ANC96LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe obstruction of the left rudder pedal and brake by the battery cable.NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB FTW96IA240Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Denver, COphysical impairment of the captain due to a probable cardiac event.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB LAX96LA221Accident · No injuriesLimited investigationFinal reportBeech 23-A24R · Modesto, CAfuel exhaustion due to the pilot's inadequate preflight inspection of the aircraft.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB NYC96LA121Accident · No injuriesLimited investigationFinal reportPiper J-3 · Chester, CTthe pilot's improper use of rudder control to maintain directional control during landing.NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB IAD96LA091Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · New Carlisle, OHinadequate maintenance and inspection, and the pilot overshooting the approach to land.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB IAD96LA089Accident · No injuriesLimited investigationFinal reportPiper PA60-601P · Willard, OHthe pilot's inability to maintain directional control of the airplane during the landing flare/touchdown.