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 DCA99WA063Incident · No injuriesForeign investigationMcDonnell Douglas DC-10 · Pointe A Pitre, FranceJun 24, 1999 · N607GC · No damageNTSB CHI99LA193Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Veblen, SDwas the pilot not maintaining clearance from terrain. A factor was the pilot not performing a load jettison.Jun 24, 1999 · N3159M · Substantial damageNTSB ANC99LA082Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Mcgrath, AKA separation of the number 4 engine cylinder, and a fracture of the number 4 engine connecting rod.Jun 24, 1999 · N40677 · Substantial damageNTSB ANC99LA081Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Anchorage, AKThe pilot's failure to maintain an adequate airspeed, and subsequent inadvertent stall.Jun 24, 1999 · N5149X · Substantial damageNTSB ANC99LA080Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · North Pole, AKThe pilot's inadvertent ground loop during a high speed taxi. A factor associated with the accident is the pilot's decision to taxi the airplane at an excessive taxi speed.Jun 24, 1999 · N95064 · Substantial damageNTSB SEA99LA093Accident · Minor injuriesLimited investigationFinal reportModrow Avid Flyer · Poulsbo, WAEngine seizing due to failure of main bearing assemblies. Factors include foreign material in the labyrinth sleeve, and a stall encountered while the pilot was attempting his emergency landing.Jun 23, 1999 · N700RM · Substantial damageNTSB NYC99LA156Accident · Serious injuriesLimited investigationFinal reportCessna 185E · East Haddam, CTThe loss of engine power due to water in the fuel system.Jun 23, 1999 · N3385L · Substantial damageNTSB NYC99FA157Accident · 1 fatalField investigationFinal reportRobinson R-22 · Hurricane, WVA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain rotor rpm and the transmission wires.Jun 23, 1999 · N9070F · Substantial damageNTSB LAX99LA226Accident · Minor injuriesLimited investigationFinal reportEnstrom F28C · Kaunakakai, HIThe pilot encountered a dust devil during the takeoff transition from a dirt and grass area resulting in a loss of vision, disorientation, and subsequent collision with trees.Jun 23, 1999 · N595H · Substantial damageNTSB LAX99FA225Accident · Minor injuriesField investigationFinal reportCessna 402A · Van Nuys, CAThe pilot's inadequate fuel management that resulted in fuel exhaustion and the subsequent collision with vehicles during a forced landing on a city street.Jun 23, 1999 · N186BA · Substantial damageNTSB SEA99LA092Accident · No injuriesLimited investigationFinal reportHughes 369D · Shelton, WAThe pilot's failure to maintain rotor RPM during an autorotation.Jun 22, 1999 · N1089Y · Substantial damageNTSB NYC99WA206Accident · 4 fatalForeign investigationRobinson R22 · Grossenhain, GermanyJun 22, 1999 · N220WP · 2 aircraft · Substantial damageNTSB NYC99WA155Accident · No injuriesForeign investigationCessna A185F · Labrador, CanadaJun 22, 1999 · N185HC · Substantial damageNTSB DEN99LA115Accident · No injuriesLimited investigationFinal reportCessna 170 · Durango, COThe pilot's failure to maintain directional control of the aircraft during landing roll. A factor was the high density altitude and the high vegetation (sagebrush).Jun 22, 1999 · N4163V · Substantial damageNTSB CHI99WA194Accident · 2 fatalForeign investigationMaule M-5-220C · Lake St. John, CanadaJun 22, 1999 · N62041 · Substantial damageNTSB ANC99LA088Accident · No injuriesLimited investigationFinal reportCessna 140 · North Pole, AKThe pilot misjudged his altitude and airspeed, and his failure to maintain directional control of the airplane. Factors in the accident were a wet grass runway, and the pilot's excessive application of the brakes.Jun 22, 1999 · N4205N · Substantial damageNTSB SEA99LA094Accident · No injuriesLimited investigationFinal reportCessna 182 · Redmond, ORThe pilot's improper flare.Jun 21, 1999 · N91816 · Substantial damageNTSB SEA99LA089Accident · Minor injuriesLimited investigationFinal reportWeatherly 620B · Tetonia, IDA failure of the right magneto drive gear shaft. Factors include the absence of any suitable terrain on which to perform an emergency landing, and the rough/uneven condition of the terrain on which the pilot was forced to land.Jun 21, 1999 · N2033N · Substantial damageNTSB NYC99LA153Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Rising Sun, MDThe failure of the connecting rod end bolts, due to an overtemperature condition.Jun 21, 1999 · N937FB · DestroyedNTSB MIA99LA186Accident · Serious injuriesLimited investigationFinal reportRobert R. Callahan Exec 90 · Lutz, FLThe excessive cyclic input by the non-qualified passenger during the autorotative landing following a reported loss of engine power. A factor in the accident was the inadequate preflight of the helicopter by the unqualified pilot for his failure to detect…Jun 21, 1999 · N4359N · Substantial damageNTSB LAX99LA221Accident · Serious injuriesLimited investigationFinal reportCessna 172M · San Diego, CAThe mechanic's improper installation of nonapproved automotive electrical system parts, and his failure to ensure that all electrical connections were secure during the reinstallation, which resulted in the failure of the electrical system. The pilot's…Jun 21, 1999 · N61560 · DestroyedNTSB ANC99LA079Accident · No injuriesLimited investigationFinal reportCessna 180K · Kotzebue, AKThe pilot's failure to maintain directional control during takeoff.Jun 21, 1999 · N2958K · Substantial damageNTSB NYC99LA152Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Fayetteville, WVThe pilot's failure to maintain directional control during the aborted landing. A factor in this accident was the crosswind condition.Jun 20, 1999 · N20952 · Substantial damageNTSB FTW99LA173Accident · Serious injuriesLimited investigationFinal reportLibersat Kolb Mark 3 · Vidor, TXThe pilot's failure to maintain control of the airplane, which resulted in an inadvertent stall/spin.Jun 20, 1999 · N106RL · Substantial damageNTSB FTW99FA172Accident · 1 fatalField investigationFinal reportKeen Glasair I · Albany, TXThe pilot's inadvertent stall while performing an evasive maneuver to avoid colliding with powerlines. Factors were the night light condition and the pilot's decision to fly at low altitude.Jun 20, 1999 · N233TK · DestroyedNTSB DEN99LA105Accident · Serious injuriesLimited investigationFinal reportBell BH-206B · Telluride, COSettling with power and a loss of tail rotor effectiveness. Factors were an improperly planned approach by the pilot in command, high density altitude, and inadequate supervision by the safety pilot.Jun 20, 1999 · N39122 · Substantial damageNTSB CHI99LA191Accident · No injuriesLimited investigationFinal reportBeech B19 · Taylor, MOthe airplane pilot's and the helicopter pilot's failure to maintain visual clearance from each other while in the traffic pattern.Jun 20, 1999 · N282L · 2 aircraft · Substantial damageNTSB SEA99LA091Accident · No injuriesLimited investigationFinal reportCessna 180G · Kalispell, MTAn encounter with a crosswind gust, which was not possible to compensate for.Jun 19, 1999 · N4707U · Substantial damageNTSB SEA99LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Zillah, WAThe pilot's selection of unsuitable terrain for landing adjacent to the runway. Factors include sun glare encountered at the time of the landing attempt.Jun 19, 1999 · N9887W · Substantial damageNTSB NYC99FA150Accident · 1 fatalField investigationFinal reportCanadair F-86E · Mount Holly, NJA failure in the fuel transfer system which resulted in fuel starvation and subsequent loss of engine power.Jun 19, 1999 · N186JC · DestroyedNTSB LAX99LA228Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Barstow, CAThe loss of thermal lift that resulted in a forced landing and the pilot's improper glide path that resulted in a collision with a light pole.Jun 19, 1999 · N136AS · Substantial damageNTSB LAX99LA223Accident · Serious injuriesLimited investigationFinal reportDevor MXL II · Tonopah, AZThe failure of the uncertificated pilot to maintain control of the aircraft.Jun 19, 1999 · N98MD · Substantial damageNTSB LAX99LA222Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Elko, NVThe pilot's failure to reject the takeoff after noting that the engine would not produce takeoff power.Jun 19, 1999 · N26842 · Substantial damageNTSB LAX99FA220Accident · 4 fatalField investigationFinal reportCessna 182A · Paso Robles, CAthe pilot's failure to set the trim as prescribed by the published check list. This led to a steep climb angle which caused the airspeed to decay, resulting in a stall at an altitude too low to allow recovery.Jun 19, 1999 · N4824D · DestroyedNTSB CHI99LA189Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Cirrus · Hartford, WIthe reason for the occurrence was undetermined. Factors were the pilot's deploying of the drogue chute, the drogue chute malfunctioning, a dirt embankment, and encountering unsuitable terrain during landing.Jun 19, 1999 · N8145 · Substantial damageNTSB CHI99FA190Accident · 1 fatalField investigationFinal reportCessna 182J · Satanta, KSthe preflight planning/preparation and the missed approach not performed by the pilot. The obstruction clearance not maintained by the pilot was an additional cause. Contributing factors were the low ceiling and the fog.Jun 19, 1999 · N2711F · Substantial damageNTSB ATL99LA101Accident · No injuriesLimited investigationFinal reportCessna A188B · Glen Allan, MSThe improper installation of a nut and bolt assembly by a maintenance personnel that resulted in the in-flight loss of control of the left ailiron.Jun 19, 1999 · N53198 · Substantial damageNTSB ANC99LA078Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Skwentna, AKThe pilot's selection of an unsuitable takeoff area. A factor associated with the accident was high vegetation.Jun 19, 1999 · N4292H · Substantial damageNTSB MIA99WA187Accident · 2 fatalForeign investigationCessna U206F · Ciudad Bolivar, VenezuelaJun 18, 1999 · YV239 · DestroyedNTSB LAX99FA214Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Bass Lake, CAInadequate in-flight planning and decision making resulted in a failure to maintain clearance from terrain. A factor in the accident was the pilot's low total time and lack of experience in this make and model of airplane.Jun 18, 1999 · N2706R · DestroyedNTSB FTW99LA170Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Basile, LAThe separation of the right wing forward spar lower attachment fitting due to a fatigue fracture, which emanated from corrosion as a result of maintenance not being performed.Jun 18, 1999 · N7075D · Substantial damageNTSB FTW99FA171Accident · 1 fatalField investigationFinal reportHeilig-Reading Emeraude CP 301A · Altus, ARThe pilot's failure to maintain clearance with a wire, during an approach to a private airstrip.Jun 18, 1999 · N3751 · Substantial damageNTSB DEN99LA106Accident · No injuriesLimited investigationFinal reportCessna 172N · Platteville, COThe pilot misjudging the flare altitude, resulting in a hard landing, and his subsequent loss of aircraft control. A factor was overload forces collapsing the nose landing gear assembly.Jun 18, 1999 · N5266J · Substantial damageNTSB SEA99LA088Accident · No injuriesLimited investigationFinal reportRyan Navion B · Klamath Falls, ORThe pilot's failure to reinstall the engine oil filler cap during preflight, resulting in engine oil loss and the necessity for an immediate landing.Jun 17, 1999 · N870DR · Substantial damageNTSB SEA99LA087Accident · No injuriesLimited investigationFinal reportLet L-13 · Belgrade, MTThe pilot in command's failure to maintain clearance from a parked airplane during his attempt to avoid a person on the runway.Jun 17, 1999 · N70741 · Substantial damageNTSB NYC99LA147Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · Tinicum, PAThe pilot's failure to maintain a proper altitude above the water.Jun 17, 1999 · N94WF · Substantial damageNTSB NYC99LA144Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-65 · Corinna, METhe pilot-in-command's failure to maintain adequate airspeed which resulted in an inadvertent stall.Jun 17, 1999 · N36205 · Substantial damageNTSB LAX99LA241Accident · No injuriesLimited investigationFinal reportRockwell 690B · Monterey, CAThe failure of maintenance personnel to properly adjust the drag brace preload during recent landing gear maintenance, which resulted in the overload failure and separation of the hydraulic cylinder attach boss.Jun 17, 1999 · N480K · Substantial damageNTSB LAX99LA224Accident · No injuriesLimited investigationFinal reportCessna 180K · Santa Monica, CAThe pilot's misjudged landing flare which resulted in a hard landing and the subsequent porpoising of the airplane; and his failure to maintain directional control that resulted in a ground loop and substantial damage to the airplane.Jun 17, 1999 · N181RC · Substantial damageNTSB CHI99LA188Accident · No injuriesLimited investigationFinal reportCessna 172N · Cloquet, MNa fire which initiated from an undetermined origin.Jun 17, 1999 · N9419E · Destroyed