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 BFO94LA138Accident · No injuriesLimited investigationFinal reportCessna 172L · Springfield, OHThe pilot's premature liftoff, failure to attain adequate airspeed, and improper level off.Aug 12, 1994 · N19644 · Substantial damageNTSB BFO94LA133Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Freeport, PAThe student pilot's failure to maintain adequate airspeed and the instructor's inadequate supervision.Aug 12, 1994 · N2341L · Substantial damageNTSB BFO94FA134Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Grand Lake Strm, METhe pilot attempted a maneuver at an altitude insufficient for recovery. A factor in the accident was pilot physical impairment due to alcohol consumption.Aug 12, 1994 · N8588Y · DestroyedNTSB ANC94FA105Accident · 3 fatalField investigationFinal reportDe Havilland DHC-2 · Port Alsworth, AKImproper in-flight planning/decision by the pilot, and his failure to remain clear of mountainous terrain. The box/blind canyon and proximity of mountainous terrain were related factors.Aug 12, 1994 · N17394 · DestroyedNTSB SEA94FA208Accident · 2 fatalField investigationFinal reportPiper PA-22 · Butte Falls, ORThe pilot-in-command's failure to maintain adequate altitude and clearance from trees while maneuvering.Aug 11, 1994 · N3555A · DestroyedNTSB MIA94LA194Accident · Minor injuriesLimited investigationFinal reportAerosport Quail · Waynesboro, MSAn engine failure due to improper maintenance [overhaul] of the engine crankshaft.Aug 11, 1994 · N10JB · Substantial damageNTSB LAX94LA315Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Overgaard, AZthe pilot's failure to maintain an adequate airspeed margin, which resulted in an inadvertent stall. Factors in the accident were weather conditions, high density altitude, and shifting wind conditions.Aug 11, 1994 · N9044A · Substantial damageNTSB LAX94LA314Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fresno, CAthe pilot's failure to maintain directional control of the aircraft resulting in a ground loop/swerve and a subsequent overload failure of the right main landing gear.Aug 11, 1994 · N4374X · Substantial damageNTSB LAX94LA313Accident · No injuriesLimited investigationFinal reportSchweizer G-164-A · Laton, CAfailure of the No.7 cylinder for an unspecified reason.Aug 11, 1994 · N699Y · Substantial damageNTSB LAX94FA317Accident · No injuriesField investigationFinal reportAerospatiale AS350-D · Kukuihaele, HIa fatigue crack in the 'T' fitting on the power turbine governor pneumatic accumulator. A factor was the rough, rock-covered landing area.Aug 11, 1994 · N889AT · Substantial damageNTSB FTW94LA267Accident · No injuriesLimited investigationFinal reportWeatherly 201C · Pampa, TXThe pilot's decision to takeoff from unsuitable terrain following the forced landing. A factor was fuel starvation induced power loss resultant from the pilot's failure to select the proper fuel tank.Aug 11, 1994 · N9075W · Substantial damageNTSB CHI94LA276Accident · No injuriesLimited investigationFinal reportBell 47G3B1 · Sargeant, MNthe pilot's failure to maintain clearance from a transmission wire during an agricultural spray run. A factor in the accident is the transmission wire.Aug 11, 1994 · N64292 · Substantial damageNTSB BFO94LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Waynesboro, VAThe pilot's misjudgement of speed and distance which resulted in a landing overrun. A contributing factor is the pilot's delay in intiating a go-around.Aug 11, 1994 · N8505E · Substantial damageNTSB ATL94LA154Accident · Minor injuriesLimited investigationFinal reportAyres S2R · Vienna, GAThe loss of engine power because of a fractured cylinder.Aug 11, 1994 · N8914Q · Substantial damageNTSB MIA94LA193Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5 · Ormond Beach, FLThe improper maintenance work done on the carburetor by a local mechanic that resulted in loss of engine power over unsuitable terrain. A contributing factor was the dirt and moisture that contaminated the carburetor.Aug 10, 1994 · N1392R · Substantial damageNTSB LAX94LA311Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA316B · Stateline, NVthe failure of the pilot to maintain the proper rate of descent during the vertical descent into the landing zone, which resulted in a hard landing. Factors in the accident were high density altitude and dark night light conditions.Aug 10, 1994 · N981CF · Substantial damageNTSB FTW94T#A04Accident · No injuriesFinal reportChristen Industries A-1 · Tinnie, NMAug 10, 1994 · N2898D · Substantial damageNTSB FTW94LA266Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Matagorda, TXA power loss due to cracked engine cylinder. A factor was the lack of suitable terrain for the forced landing.Aug 10, 1994 · N8251K · DestroyedNTSB BFO94LA131Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Wolfeboro, NHThe pilot's inadequate inflight decision, which resulted in a downwnind landing and overrun of the runway.Aug 10, 1994 · N3372M · Substantial damageNTSB BFO94LA129Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · Bangor, METhe pilot's loss of aircraft control. Factors are dark night conditions, and the pilot's execution of an evasive maneuver.Aug 10, 1994 · N292Q · DestroyedNTSB ATL94LA155Accident · No injuriesLimited investigationFinal reportCessna 210A · Varnville, SCWater contamination in the fuel that resulted from inadequate maintenance inspection of the airplane. A factor was the rough terrain at the landing site.Aug 10, 1994 · N6601X · Substantial damageNTSB ATL94LA153Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Beaufort, SCThe pilot's improper use of the rudder during landing.Aug 10, 1994 · N44970 · Substantial damageNTSB ATL94LA152Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Vanceboro, NCThe pilot's improper use of wheel brakes.Aug 10, 1994 · N8896H · Substantial damageNTSB ANC94T#A02Accident · No injuriesClass 3Final reportPiper PA18 · Kotzebue, AKAug 10, 1994 · N91251 · Substantial damageNTSB ANC94FA104Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D · Eagle River, AKThe pilot's failure to maintain airspeed and operating at an inadequate altitude for recovery.Aug 10, 1994 · N95058 · DestroyedNTSB SEA94LA207Accident · No injuriesLimited investigationFinal reportCessna 182P · Nampa, IDFuel starvation due to the pilot-in-command's failure to verify the fuel tank selector position during the approach, and his failure to perform the published emergency procedures for an engine-out situation. A factor in the accident was a transmission wire.Aug 9, 1994 · N20818 · Substantial damageNTSB MIA94RA192Accident · No injuriesForeign investigationBell UH-1B · Salama, GuatemalaAug 9, 1994 · TGHUYNTSB LAX94WA341Accident · 1 fatalForeign investigationCessna 182 · Creel, MexicoAug 9, 1994 · N2160G · DestroyedNTSB LAX94LA312Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Warner Springs, CAthe pilot's inadequate visual lookout for livestock during takeoff.Aug 9, 1994 · N25871 · Substantial damageNTSB FTW94LA265Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Texarkana, TXFuel contamination and the improper adjustments made to the carburetor by unidentified maintenance personnel. A factor was the lack of suitable terrain to which a forced landing could be executed.Aug 9, 1994 · N1478S · Substantial damageNTSB CHI94LA274Accident · 1 fatalLimited investigationFinal reportNelson Benson B-8M · Sandwich, ILImproper planning/decision by the pilot (owner/pilot/mechanic), and his improper modification of the flight control system, which resulted in his failure (or inability) to maintain control of the gyrocopter. A factor related to the accident was: the pilot's…Aug 9, 1994 · N26063 · DestroyedNTSB CHI94LA273Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Romeoville, ILthe pilot's inadequate preflight planning/preparation and improper emergency procedure. Factors associated with the accident are the pilot's improper positioning of the fuel tank selector, and the rough, uneven terrain.Aug 9, 1994 · N3634R · Substantial damageNTSB CHI94LA271Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Marion, IAThe pilot's inadequate aircraft prelight and his failure to remove the frost from the windshield which obstructed his view.Aug 9, 1994 · N234KB · DestroyedNTSB BFO94LA128Accident · Serious injuriesLimited investigationFinal reportHankins/Dickerson Clipped Wings II · Laurel, MDThe failure of the engine ignition system capacitor discharge unit which caused loss of total engine power.Aug 9, 1994 · N4287R · Substantial damageNTSB ANC94LA115Accident · No injuriesLimited investigationFinal reportCessna 206 · Skwentna, AKThe pilots inadequate compensation for the high wind condition during takeoff. The wind was a factor.Aug 9, 1994 · N14C · Substantial damageNTSB ANC94LA103Accident · No injuriesLimited investigationFinal reportBell 206B · Chuit River, AKThe pilot's failure to maintain tail rotor effectiveness during hover.Aug 9, 1994 · N4604Y · Substantial damageNTSB ANC94LA102Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Bethel, AKThe pilot misjudged the strength of the tailwind and did not perform a go-around in a timely fashion so as to avoid landing the airplane halfway down the strip. Factors in the accident were the wet landing strip and the tailwind.Aug 9, 1994 · N756NG · Substantial damageNTSB NYC94LA159Accident · No injuriesLimited investigationFinal reportCessna 172P · Pottsville, PAThe pilot's failure to attain adequate airpseed, which resulted in a stall/mush and collision with a tree.Aug 8, 1994 · N52211 · Substantial damageNTSB NYC94LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Wellsboro, PAThe pilot's impairment of judgment and performance due to alcohol, which led to his misjudgment of altitude and distance to the runway and collision with terrain, while on final approach to land. A factor related to the accident was: darkness.Aug 8, 1994 · N9673C · Substantial damageNTSB LAX94LA310Accident · No injuriesLimited investigationFinal reportCessna 172M · Carson City, NVthe pilot's decision to attempt a landing in crosswind conditions which exceeded the capability of the aircraft.Aug 8, 1994 · N4390R · Substantial damageNTSB FTW94LA264Accident · No injuriesLimited investigationFinal reportCessna A188B · Sherman, TXThe pilot's failure to refuel the airplane. A factor was the leaking fuel caps.Aug 8, 1994 · N4826R · Substantial damageNTSB ANC94LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Deadhorse, AKThe separation of the landing gear tube at the spindle due to corrosion. An inadequate annual inspection was a factor in the accident.Aug 8, 1994 · N4450A · Substantial damageNTSB SEA94LA206Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Salmon, IDThe pilot's failure to adequately judge the distance and altitude to the runway during the night VFR approach. Factors in the accident were: fatigue, lack of recent night flying experience, the dark night, and the operator's inadequate supervision of the…Aug 7, 1994 · N47671 · Substantial damageNTSB NYC94LA158Accident · No injuriesLimited investigationFinal reportStulp Starduster SA 300 · Ottawa, OHinadequate maintenance which resulted in a corroded gascolator fuel screen restriction fuel flow and resulted in fuel starvation.Aug 7, 1994 · N2091 · Substantial damageNTSB NYC94LA157Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Pennington, NJThe pilot's misjudged distance and speed during an aborted takeoff which resulted in an overrun. A contributing factor was the wet grass.Aug 7, 1994 · N5758F · Substantial damageNTSB NYC94LA155Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4A · Cannan, NHThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and inflight collision with terrain. Factors were a loss of lift and the pilot's in-flight decision to maneuver too close to the ridge.Aug 7, 1994 · N245JD · Substantial damageNTSB MIA94LA190Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe pilot-in-command's decision to intentionally exit the airplane with the engine running, and failure to maintain a clearance from the propeller. The improper aircraft preflight was a factor.Aug 7, 1994 · N67334 · Minor damageNTSB LAX94FA308Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · San Luis Obispo, CAthe failure of the No. 4 cylinder connecting rod for undetermined reasons. The dark night lighting conditions, which hampered the ability of the pilots to detect the power lines, was a factor in this accident.Aug 7, 1994 · N6959J · DestroyedNTSB CHI94LA268Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Lone Rock, WIthe pilot's failure to attain a proper touchdown point on the runway.Aug 7, 1994 · N6205J · Substantial damageNTSB ANC94FA100Accident · 6 fatalField investigationFinal reportde Havilland DHC-2 · Kodiak, AKThe pilot of the VFR only flight intentionally entered instrument meteorological conditions. Factors in the accident were the inadequate procedures/directives by the company/operator management concerning continued VFR flight in marginal weather conditions…Aug 7, 1994 · N126UA · Destroyed