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 SEA90FA072Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Jean, NVSevere downdrafts/windshear which exceeded the airplane's performance capabilities.NTSB MKC90LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Starbuck, MNCompensation for wind conditions were misjudged and aircraft control was not maintained by the pilot in command.NTSB MKC90LA102Accident · No injuriesLimited investigationFinal reportLightcap PITTS-S-1D · Larned, KSFailure of the main landing gear attachment strut, due to fatigue.NTSB LAX90LA177Accident · No injuriesLimited investigationFinal reportCessna 172N · Cottonwood, AZPremature raising of the flaps during the go-around maneuver.NTSB FTW90LA108Accident · No injuriesLimited investigationFinal reportCessna 152 II · Katy, TXThe cfi's inadequate supervision of the student and the airplane.NTSB BFO90LA044Accident · No injuriesLimited investigationFinal reportCessna 172A · Pocomoke, MDThe pilot's misjudgement of distance and speed during the approach to land, and his failure to attain the proper touchdowwn point during the landing. The ditch was a related factor.NTSB MKC90LA104Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Scott, ARPilot in command's failure to maintain directional control during the landing roll. Related to the accident was tall grass and soft terrain.NTSB MKC90DCQ02Accident · 1 fatalFinal reportBell UH-1B · Ulysses, KSThe pilot failed to maintain proper rotor RPM, while maneuvering over a high obstruction (power line) at the end of a swath run, which resulted in an inadvertent descent & collision with the terrain. The high obstruction was considered to be a related factor.NTSB LAX90LA167Accident · No injuriesLimited investigationFinal reportSiai-Marchetti SF 260 · Chandler, AZThe second pilot's over rotation and the failure of the pilot in command to adequately supervise the conduct of the flight and to make a timely corrective action.NTSB LAX90LA166Accident · Serious injuriesLimited investigationFinal reportCessna 172M · San Jose, CAThe pilot's improper preflight, improper raising of the flaps after becoming airborne, and failure to maintain adequate flying speed, which resulted in an inadvertent stall.NTSB LAX90LA165Accident · No injuriesLimited investigationFinal reportMooney M20 · Torrance, CAWater contamination introduced into the airplane fuel system when the airplane was washed. Contributing to the accident was an 18 knot tailwind during landing roll which resulted in the airplane overrunning the runway.NTSB LAX90DVG08Accident · No injuriesFinal reportSchweizer G-164-B · Richvale, CAThe pilot in command's failure to maintain a positive rate of climb during takeoff resulting in the aircraft descending into terrain.NTSB DEN90LA106Accident · No injuriesLimited investigationFinal reportCessna 337 · Broomfield, COThe pilot's failure to properly execute a precautionary approach following an engine failure.NTSB DEN90LA105Accident · No injuriesLimited investigationFinal reportCessna C-180E · Helena, MTThe malfunction of the tail wheel assembly.NTSB CHI90FA123Accident · 3 fatalField investigationFinal reportCessna 172N · New Richmond, WIFailure of the pilot to maintain sufficient airspeed to avoid a stall/spin. A factor related related to the accident was: the pilot's lack of familiarity with the make and model of aircraft.NTSB ANC90LA067Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot failed to maintain directional control of the airplane during the landing roll, which resulted in a ground swerve.NTSB MKC90LA103Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Hardin, MOPoor in-flight planning/decision and inadequate visual outlook by the pilot in command.NTSB LAX90DVA03Accident · Serious injuriesFinal reportNaval Aircraft Factory N3N-3 · Madera, CAThe pilot inadvertently descending into the ground. Contributing to the accident was the inflight opening of the hopper lid which partially obscured the pilot's vision.NTSB FTW90FA106Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Jacksonville, TXA fuel exhaustion induced power loss during the initial climb after takeoff.NTSB DEN90DQA01Accident · 1 fatalFinal reportMichael C. Quigley Velocity · Santa Teresa, NMFailure of the pilot in command to maintain airspeed on final approach resulting in an inadvertent stall and uncontrolled descent into the ground.NTSB DCA90RA025Accident · 27 fatalForeign investigationDouglas DC-6B · Guatemala City, GuatemalaNTSB CHI90DCA01Accident · Serious injuriesFinal reportZengel RV-4 · Columbia, ILThe pilot's failure to maintain a proper glidepath to touchdown on the runway.NTSB ATL90FA109Accident · 1 fatalField investigationFinal reportCessna 150L · Stockbridge, GAThe pilot's failure to maintain the proper clearance from objects on the ground.NTSB ANC90LA066Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Glennallen, AKThe pilot failed to maintain proper altitude and terrain clearance while maneuvering.NTSB LAX90LA164Accident · Minor injuriesLimited investigationFinal reportBell 47G · Riverside, CAThe pilot's failure to maintain control of the helicopter. A factor related to the accident was: the pilot's lack of experience in the type of aircraft.NTSB LAX90LA162Accident · No injuriesLimited investigationFinal reportHughes 369C · Kahului, HIThe pilots failure to ensure that adequate room existed to position the helicopter on the landing platform. Contributing to the accident was the failure of ground personnel to ensure that hazards to the landing helicopter were clear of the landing area.NTSB DEN90FA104Accident · 2 fatalField investigationFinal reportCanadair CT-133 · Roswell, NMThe pilot-in-command's performance of aerobatic maneuvers that exceeded the design stress limits of the aircraft, resulting in catastrophic failure of the wing.NTSB ATL90LA107Accident · No injuriesLimited investigationFinal reportBeech A36 · Hahira, GAThe failure of the right main landing gear tire on landing the failure of the pilot to detect an existing cut on the right main landing gear tire during preflight.NTSB ATL90FA108Accident · 2 fatalField investigationFinal reportGovernment Aircraft Fact N24A · Wilmington, NCThe pilot's failure to maintain sufficient altitude during a circling maneuver for landing. Factors related to the accident were: weather conditions below minimums for a circling approach, and failure of the pilot to follow IFR procedures.NTSB ANC90LA064Accident · No injuriesLimited investigationFinal reportCessna 180C · Anchorage, AKThe pilot failed to maintain directional control of the airplane.NTSB NYC90LA100Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Lawrence, MAThe pilot's improper use of flight controls, resulting in loss of control.NTSB LAX90TL#03Accident · Minor injuriesClass 3Final reportBell 206B · La Verne, CANTSB LAX90LA163Accident · No injuriesLimited investigationFinal reportCessna 140 · Paso Robles, CAThe pilot failed to maintain directional control.NTSB LAX90DVG05Accident · No injuriesFinal reportLerstang Long EZE · Willows, CAThe pilots misjudgement of the correct landing spot and allowed the aircraft to descend into the ground without taking proper and timely corrective action.NTSB FTW90LA105Accident · No injuriesLimited investigationFinal reportCessna 172H · San Angelo, TXThe student failed to maintain directional control of the aircraft during takeoff in variable wind conditions.NTSB CHI90LA121Accident · No injuriesLimited investigationFinal reportBeech 58P · Auburn, INThe pilot misjudged distance and speed during the approach and landing, which resulted in an overrun of the landing area. Factors related to the accident were: darkness and the ditch.NTSB ATL90LA106Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Cartersville, GAThe pilot's improper use of the engine fuel mixture control which resulted in fuel exhaustion.NTSB ANC90LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nenana, AKThe main wheels (or brakes) had locked for an unknown reason.NTSB MKC90LA100Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · St. Louis, MOInadequate maintenance and proper touchdown point not attained by the pilot in command.NTSB MIA90LA115Accident · No injuriesLimited investigationFinal reportWilliams, Robert G. AIR COMM. 532 Elite · Indian Rks Bch, FLLoss of power due to the overheated engine caused by a separated liquid coolant line which allowed the coolant to drain, resulting in the forced landing.NTSB LAX90LA206Accident · Serious injuriesLimited investigationFinal reportThunder and Colt AX9-140 · Napa, CAThe pilot's improper flare technique which resulted in a hard landing. A factor in the accident was the sudden appearance of a high wind condition.NTSB LAX90LA161Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Santa Rosa, CAThe pilot's improper recovery from a bounced landing.NTSB FTW90DRD07Accident · No injuriesFinal reportGrumman G-164A · Ville Platte, LAPartial loss of engine power due to a cracked number four cylinder intake rocker box housing. The lack of a suitable forced landing site was a related factor.NTSB CHI90LA122Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainfield, ILThe student's improper flare, improper recovery from a bounced landing, and failure to maintain directional control. The crosswind was a related factor.NTSB MIA90WA114Accident · No injuriesForeign investigationPiper PA-32-260 · Freeport, BahamasNTSB LAX90LA160Accident · No injuriesLimited investigationFinal reportPiper PA30 · Sedona, AZThe pilot's mismanagement of the fuel system.NTSB DCA90WA430Accident · 1 fatalForeign investigationBeech C99 Airliner · Moosonee, CanadaNTSB BFO90LA041Accident · No injuriesLimited investigationFinal reportHiller UH-12ET · Brookneal, VAThe pilot's improper preflight and improper in-flight planning/decision. Pilot fatigue was a related factor.NTSB SEA90LA070Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Port Orchard, WAImproper maintenance, and the installation of an improper carburetor. A factor related to the accident was the presence of trees and stumps in the emergency landing area.NTSB NYC90LA098Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Kutztown, PAThe student pilot's improper control input and the instructior's inadequate response. The student's interference with the flight controls as the instructor attempted recovery was a factor in the accident.