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 SEA90FA072Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Jean, NVSevere downdrafts/windshear which exceeded the airplane's performance capabilities.May 7, 1990 · N2359L · DestroyedNTSB 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.May 7, 1990 · N1633H · Substantial damageNTSB MKC90LA102Accident · No injuriesLimited investigationFinal reportLightcap PITTS-S-1D · Larned, KSFailure of the main landing gear attachment strut, due to fatigue.May 7, 1990 · N64585 · Substantial damageNTSB LAX90LA177Accident · No injuriesLimited investigationFinal reportCessna 172N · Cottonwood, AZPremature raising of the flaps during the go-around maneuver.May 7, 1990 · N251ER · Substantial damageNTSB FTW90LA108Accident · No injuriesLimited investigationFinal reportCessna 152 II · Katy, TXThe cfi's inadequate supervision of the student and the airplane.May 7, 1990 · N94098 · Substantial damageNTSB 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.May 7, 1990 · N7746T · Substantial damageNTSB 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.May 6, 1990 · N5187T · Substantial damageNTSB 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.May 6, 1990 · N8142W · DestroyedNTSB 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.May 6, 1990 · N260CA · Substantial damageNTSB 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.May 6, 1990 · N1495V · Substantial damageNTSB 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.May 6, 1990 · N300MD · Substantial damageNTSB 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.May 6, 1990 · N6689K · Substantial damageNTSB DEN90LA106Accident · No injuriesLimited investigationFinal reportCessna 337 · Broomfield, COThe pilot's failure to properly execute a precautionary approach following an engine failure.May 6, 1990 · N2208X · Substantial damageNTSB DEN90LA105Accident · No injuriesLimited investigationFinal reportCessna C-180E · Helena, MTThe malfunction of the tail wheel assembly.May 6, 1990 · N8679X · Substantial damageNTSB 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.May 6, 1990 · N76089 · DestroyedNTSB 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.May 6, 1990 · N4538C · Substantial damageNTSB MKC90LA103Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Hardin, MOPoor in-flight planning/decision and inadequate visual outlook by the pilot in command.May 5, 1990 · N9555P · Substantial damageNTSB 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.May 5, 1990 · N45184 · DestroyedNTSB FTW90FA106Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Jacksonville, TXA fuel exhaustion induced power loss during the initial climb after takeoff.May 5, 1990 · N2468G · DestroyedNTSB 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.May 5, 1990 · N469Q · Substantial damageNTSB DCA90RA025Accident · 27 fatalForeign investigationDouglas DC-6B · Guatemala City, GuatemalaMay 5, 1990 · N84BLNTSB CHI90DCA01Accident · Serious injuriesFinal reportZengel RV-4 · Columbia, ILThe pilot's failure to maintain a proper glidepath to touchdown on the runway.May 5, 1990 · N371FZ · Substantial damageNTSB ATL90FA109Accident · 1 fatalField investigationFinal reportCessna 150L · Stockbridge, GAThe pilot's failure to maintain the proper clearance from objects on the ground.May 5, 1990 · N10790 · DestroyedNTSB ANC90LA066Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Glennallen, AKThe pilot failed to maintain proper altitude and terrain clearance while maneuvering.May 5, 1990 · N91117 · Substantial damageNTSB 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.May 4, 1990 · N9FK · Substantial damageNTSB 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.May 4, 1990 · N9219F · Substantial damageNTSB 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.May 4, 1990 · N233RK · DestroyedNTSB 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.May 4, 1990 · N6060N · Substantial damageNTSB 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.May 4, 1990 · N418NE · DestroyedNTSB ANC90LA064Accident · No injuriesLimited investigationFinal reportCessna 180C · Anchorage, AKThe pilot failed to maintain directional control of the airplane.May 4, 1990 · N9339T · Substantial damageNTSB NYC90LA100Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Lawrence, MAThe pilot's improper use of flight controls, resulting in loss of control.May 3, 1990 · N24577 · Substantial damageNTSB LAX90TL#03Accident · Minor injuriesClass 3Final reportBell 206B · La Verne, CAMay 3, 1990 · N59560 · Substantial damageNTSB LAX90LA163Accident · No injuriesLimited investigationFinal reportCessna 140 · Paso Robles, CAThe pilot failed to maintain directional control.May 3, 1990 · N2662N · Substantial damageNTSB 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.May 3, 1990 · N2069G · Substantial damageNTSB FTW90LA105Accident · No injuriesLimited investigationFinal reportCessna 172H · San Angelo, TXThe student failed to maintain directional control of the aircraft during takeoff in variable wind conditions.May 3, 1990 · N3941R · Substantial damageNTSB 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.May 3, 1990 · N91EE · Substantial damageNTSB ATL90LA106Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Cartersville, GAThe pilot's improper use of the engine fuel mixture control which resulted in fuel exhaustion.May 3, 1990 · N7868P · Substantial damageNTSB ANC90LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nenana, AKThe main wheels (or brakes) had locked for an unknown reason.May 3, 1990 · N1192C · Substantial damageNTSB MKC90LA100Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · St. Louis, MOInadequate maintenance and proper touchdown point not attained by the pilot in command.May 2, 1990 · N3986X · Substantial damageNTSB 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.May 2, 1990 · N70319 · Substantial damageNTSB 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.May 2, 1990 · N9112R · No damageNTSB LAX90LA161Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Santa Rosa, CAThe pilot's improper recovery from a bounced landing.May 2, 1990 · N4343F · Substantial damageNTSB 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.May 2, 1990 · N8938H · DestroyedNTSB 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.May 2, 1990 · N54093 · Substantial damageNTSB MIA90WA114Accident · No injuriesForeign investigationPiper PA-32-260 · Freeport, BahamasMay 1, 1990 · N41452 · Substantial damageNTSB LAX90LA160Accident · No injuriesLimited investigationFinal reportPiper PA30 · Sedona, AZThe pilot's mismanagement of the fuel system.May 1, 1990 · N7946Y · Substantial damageNTSB DCA90WA430Accident · 1 fatalForeign investigationBeech C99 Airliner · Moosonee, CanadaMay 1, 1990 · CGFAW · DestroyedNTSB 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.May 1, 1990 · N4034Z · Substantial damageNTSB 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.Apr 30, 1990 · N7127L · Substantial damageNTSB 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.Apr 30, 1990 · N112AW · Substantial damage