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 ANC92LA137Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Port Alsworth, AKThe loss of engine power due to fuel starvation associated with fuel contamination due to an inadequate aircraft preflight by the pilot. The unsuitable terrain encountered during the landing was a factor.Aug 19, 1992 · N7509K · Substantial damageNTSB NYC92LA167Accident · No injuriesLimited investigationFinal reportCessna A188A · Felton, DEThe pilot's failure to abort the takeoff at a timely point which resulted in an inadequate climb rate an a collision with trees.Aug 18, 1992 · N6664G · DestroyedNTSB NYC92LA166Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2-60 · Philadelphia, PAThe in-flight separation of a propeller blade as a result of fatigue cracking initiated from multiple sites located at corrosion pits in the balancing hole. Contributing factors in the accident were: the failure to detect the corrosion during the last…Aug 18, 1992 · N66LA · Substantial damageNTSB LAX92LA355Accident · No injuriesLimited investigationFinal reportCessna T210L · Fallbrook, CAFuel exhaustion due to the failure of the pilot to refuel the aircraft prior to departure.Aug 18, 1992 · N60856 · Substantial damageNTSB FTW92WA236Accident · No injuriesForeign investigationPiper PA-32-260 · Punta China, MexicoAug 18, 1992 · N3330W · DestroyedNTSB FTW92LA213Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Clarendon, ARThe pilot's failure to consult the airplane's performance data and ensure that adequate field length was available for takeoff.Aug 18, 1992 · N2357N · Substantial damageNTSB FTW92LA211Accident · No injuriesLimited investigationFinal reportBeech G35 · La Porte, TXThe loss of engine power for undetermined reasons. Factors were the dark night and the lack of suitable terrain available for the forced landing.Aug 18, 1992 · N4604D · Substantial damageNTSB CHI92LA246Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Chillicothe, MOThe pilot's improper use of the airplanes brakes.Aug 18, 1992 · N72379 · Substantial damageNTSB ATL92LA161Accident · No injuriesLimited investigationFinal reportCessna 172N · New Bern, NCThe student pilot's failure to maintain directional control on the landing roll. Factors were the pilot's lack of total experience and the crosswind conditions at the airport.Aug 18, 1992 · N5415J · Substantial damageNTSB ANC92LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Mackey Lake, AKA loss of power for undetermined reasons. A factor which contributed to the severity of the accident was the pilot inadvertently stalled the airplane.Aug 18, 1992 · N4714Y · Substantial damageNTSB SEA92LA187Accident · No injuriesLimited investigationFinal reportCessna 182F · Alderwood Manor, WAThe pilot selected the wrong runway for wind conditions.Aug 17, 1992 · N3551Y · Substantial damageNTSB SEA92LA181Accident · 1 fatalLimited investigationFinal reportR.P. Williams Acro Sport II · Herriman, UTInadequate remedial action and poor inflight planning/decision. A factor to the accident was: an uncontrolled stall/spin.Aug 17, 1992 · N122RW · DestroyedNTSB SEA92LA180Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Pocatello, IDAn undetermined loss of engine power. A factor to the accident was: an in flight planning/decision delay.Aug 17, 1992 · N736PS · Substantial damageNTSB MIA92WA164Accident · No injuriesForeign investigationCessna 172L · Virgin Gorda, British Virgin IslandsAug 17, 1992 · N3955Q · Substantial damageNTSB LAX92LA353Accident · No injuriesLimited investigationFinal reportFleet II · Long Beach, CAThe pilot's improper compensation for the wind condition, and improper use of the flight controls. Contributing to this accident was the crosswind condition and the collapsing of the main landing gear due to overload.Aug 17, 1992 · NC413K · Substantial damageNTSB LAX92LA352Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103 Flugzeugbau · Truckee, CAThe pilot's poorly planned approach. Lack of supervision in the type of aircraft was a factor.Aug 17, 1992 · N3872H · Substantial damageNTSB LAX92FA356Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Incline Village, NVWas the pilot's in flight loss of airplane control due to physical incapacitation.Aug 17, 1992 · N2406J · DestroyedNTSB FTW92LA210Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Russellville, ARThe pilot's improper flare. Factors were the propeller system's pitch change mechanism disconnected due to improper overhaul and failure to install the staking pins by other maintenance personnel.Aug 17, 1992 · N5981P · Substantial damageNTSB FTW92DRD05Accident · Minor injuriesFinal reportGrumman G-164 · Thibodaux, LAThe pilot's failure to maintain clearance from the wires.Aug 17, 1992 · N8916H · Substantial damageNTSB DEN92FA085Accident · 3 fatalField investigationFinal reportPiper PA-32-301T · Kit Carson, COThe pilot becoming spatially disoriented and exceeding the design stress limits of the aircraft. Factors were: the pilot's failure to obtain a weather briefing, his attempted VFR flight into a level six thunderstorm, and his lack of instrument time.Aug 17, 1992 · N8175Z · DestroyedNTSB ANC92FAMS3Accident · 2 fatalMissing aircraftFinal reportBeech 35 · Missing, AKMissing aircraft due to undetermined causes and factorsAug 17, 1992 · N216JB · DestroyedNTSB LAX92LA350Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Stockton, CAThe pilot's poor inflight planning and visual lookout.Aug 16, 1992 · N4623E · Substantial damageNTSB LAX92FA351Accident · 2 fatalField investigationFinal reportPiper PA-20-135 · Fort Bidwell, CAAn inadvertent stall while maneuvering. Contributing to the accident was pilot's diverted attention.Aug 16, 1992 · N1974A · DestroyedNTSB FTW92LA212Accident · No injuriesLimited investigationFinal reportMBB BO 105CBS-4 · Ship Shoal 90Loss of power to both engines from fuel starvation due to the pilot's failure to switch on the main fuel boost pumps.Aug 16, 1992 · N295EH · Substantial damageNTSB CHI92LA252Accident · Serious injuriesLimited investigationFinal reportCameron N-90 · Centralia, ILAbrupt touchdown.Aug 16, 1992 · N75250 · No damageNTSB CHI92LA247Accident · No injuriesLimited investigationFinal reportCessna 152 · Houghton Lake, MIA premature lift-off.Aug 16, 1992 · N68741 · Substantial damageNTSB CHI92LA244Accident · No injuriesLimited investigationFinal reportBeech 19A · Park Rapids, MNA hard landing due to excessive descent rate.Aug 16, 1992 · N6055N · Substantial damageNTSB CHI92DET01Accident · Serious injuriesFinal reportFrost Briegleb/BG-12A · Lake Village, INInadvertent stall and spin with inadequate altitude for recovery.Aug 16, 1992 · N163MF · Substantial damageNTSB ANC92T#A10Accident · No injuriesClass 3Final reportCessna 206 · Shishmaref, AKAug 16, 1992 · N9798Z · Substantial damageNTSB ANC92LA149Accident · No injuriesLimited investigationFinal reportCessna 182P · Montague Island, AKThe pilot in command did not properly align the airplane with the airstrip landing zone. A factor which contributed to the accident were the trees.Aug 16, 1992 · N7388Q · Substantial damageNTSB SEA92LA182Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Miltonfreewater, ORAn inadvertent stall while maneuvering in mountainous terrain. Factors include lack of experience in this type of operation.Aug 15, 1992 · N85425 · Substantial damageNTSB NYC92LA165Accident · No injuriesLimited investigationFinal reportSchweizer 269C · London, OHThe failure of the pilot to properly judge his altitude during a practice autorotation, which resulted in a tail rotor ground strike and roll over upon touchdown.Aug 15, 1992 · N63SS · Substantial damageNTSB LAX92LA349Accident · Minor injuriesLimited investigationFinal reportHiller UH12-E, Saloy Conver · Arvin, CAThe failure of the tension torsion bar pin due to fatigue. Contributing to this accident was that it was not possible for the pilot to flare the helicopter on landing.Aug 15, 1992 · N9753C · Substantial damageNTSB FTW92LA209Accident · Serious injuriesLimited investigationFinal reportThunder and Colt Special Shape · Tyler, TXThe pilot's failure to maintain adequate altitude and clearance from obstacles.Aug 15, 1992 · GPATY · DestroyedNTSB FTW92IA208Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-88 · Dfw Airport, TXThe loss of engine power due to the fracture of a fan blade resulting from a manufacturing defect.Aug 15, 1992 · N956DL · Minor damageNTSB FTW92DRD06Accident · No injuriesFinal reportCessna A188B · Mathew, LAThe pilot's failure to maintain directional control of the aircraft. A factor was the pilot's lack of experience in the type operation.Aug 15, 1992 · N731AR · Substantial damageNTSB CHI92LA243Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Owosso, MIFuel starvation which resulted from the pilot having selected the wrong fuel tank. Factors related to the accident were poor aircraft preflight and the unreliable fuel quantity gauges.Aug 15, 1992 · N5749P · Substantial damageNTSB CHI92LA242Accident · No injuriesLimited investigationFinal reportCessna 182R · Litchfield, MIThe pilot-in-command's failure to use all available runway and his not aborting the takeoff when the wing contacted the corn. A factor was the corn along side the runway.Aug 15, 1992 · N5446N · Substantial damageNTSB CHI92DEP03Accident · Serious injuriesFinal reportStuart J. Carter Moni · Eau Claire, WIThe pilot-in-command's failure to maintain airspeed.Aug 15, 1992 · N3944C · Substantial damageNTSB ATL92LA160Accident · Serious injuriesLimited investigationFinal reportBell 47G-2 · Slocomb, ALA hard landing due to a power loss from fuel exhaustion. A factor in the accident was the lack of sustable terrain for the landing.Aug 15, 1992 · N2880B · Substantial damageNTSB ANC92T#A08Accident · No injuriesClass 3Final reportCessna 180 · Eielson Afb, AKAug 15, 1992 · N3119D · Substantial damageNTSB SEA92LA183Accident · No injuriesLimited investigationFinal reportJohn S. Holzemer Rotorway Exec · Kirkland, WACyclic control movement was restricted. A factor to the accident was: directional control was not possible.Aug 14, 1992 · N7014N · Substantial damageNTSB NYC92FA164Accident · Serious injuriesField investigationFinal reportBeech D55 · Oxford, METhe pilot's improper preflight and fuel tank selection for takeoff, which resulted in fuel starvation and loss of power in both engines during takeoff.Aug 14, 1992 · N14WW · Substantial damageNTSB LAX92LA354Accident · No injuriesLimited investigationFinal reportHughes 269C · Corona, CAThe flight instructor's improper supervision of the flight; the dual student pilot's failure to use carburetor heat; and the flight instructor's improper use of the tail rotor pedals. Contributing to this accident was the engine failure due to carburetor…Aug 14, 1992 · N9297F · Substantial damageNTSB CHI92LA241Accident · Serious injuriesLimited investigationFinal reportBeech A36TC · Valentine, NEThe pilot's failure to maintain adequate airspeed. Factors related to the accident were the weather obscuration and failure to attain proper runway alignment.Aug 14, 1992 · N1812E · DestroyedNTSB CHI92DTG04Accident · No injuriesFinal reportGrumman G-164B · Grandin, NDThe cracked cylinder which resulted in a forced landing. The lack of suitable terrain on which to make an emergency landing was a factor.Aug 14, 1992 · N48687 · Substantial damageNTSB ANC92LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Talkeetna, AKThe pilot's improper in flight planning/decision, and his premature touch down. Contributing to the accident were the downdraft and the unsuitable terrain.Aug 14, 1992 · N3042M · Substantial damageNTSB ANC92LA132Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Iliamna, AKThe pilot failed to maintain airspeed and stalled the airplane. Contributing to the accident was the unfavorable wind condition.Aug 14, 1992 · N3906Z · DestroyedNTSB SEA92LA179Accident · No injuriesLimited investigationFinal reportCessna A185F · Ennis, MTDirectional control was not maintained. Factors to the accident were: a loose gravel airstrip, wind gusts and inadequate remedial action.Aug 13, 1992 · N1207Q · Substantial damageNTSB NYC92LA178Accident · Serious injuriesLimited investigationFinal reportBeech 76 · Nantucket, MAThe pilot's failure to use carburetor heat, resulting in carburetor ice and loss of engine power and subsequent forced landing in the ocean.Aug 13, 1992 · N67052 · Substantial damage