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 FTW93LA136Accident · Minor injuriesLimited investigationFinal reportTuttle Star Lite · Conroe, TXA power loss for undetermined reasons. A factor was the lack of suitable terrain for the forced landingApr 22, 1993 · N319JR · DestroyedNTSB CHI93LA145Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Port Huron, MIfailure of the landing gear actuator cable.Apr 22, 1993 · N654N · Substantial damageNTSB ATL93LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Lafayette, GAThe failure of the pilot to maintain control of the aircraft.Apr 22, 1993 · N5334F · Substantial damageNTSB ATL93IA079Incident · Minor injuriesIncident investigationFinal reportShort Brothers SD 3-60 · Charlotte, NCThe failure of the operator to provide applicable weather information to the flight crew. Factors were the clear air turbulence, and the captain's failure to use the weather information and assistance that was available to her.Apr 22, 1993 · N159CC · No damageNTSB MIA93LA107Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Starkville, MSThe pilot-in-command's failure to refuel the airplane, resulting in a total loss of engine power due to fuel exhaustion, resulting in a forced landing and in-flight collision with trees and terrain.Apr 21, 1993 · N7985Q · Substantial damageNTSB LAX93LA256Accident · No injuriesLimited investigationFinal reportCessna 150M · Lakeport, CAThe student pilot's delayed flare and improper bounced landing recovery technique which resulted in an inadvertent porpoise and a collision with the runway. A factor in the accident was the student's lack of total experience.Apr 21, 1993 · N6566G · Substantial damageNTSB FTW93LA135Accident · No injuriesLimited investigationFinal reportCessna 320C · No. Little Rock, ARThe failure of the pilot to follow the checklist. A factor was the popped circuit breakerApr 21, 1993 · N3057T · Substantial damageNTSB CHI93LA144Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Mineral Point, WIThe pilot in command's failure to maintain directional control of the aircraft.Apr 21, 1993 · N2352R · Substantial damageNTSB MIA93LA106Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Zephyrhills, FLThe pilot-in-command's failure to maintain best single-engine rate-of-climb speed which resulted in a forced landing. A factor which contributed to the accident was a possible exhaust system clamp failure.Apr 20, 1993 · N8056 · Substantial damageNTSB LAX93LA214Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Yuma, AZThe pilot's failure to maintain directional control on landing and her failure to maintain aircraft control during the attempted go around. Factors in the accident were: 1) the pilot's low total experience, 2) the fuel imbalance between the wing fuel tanks,…Apr 20, 1993 · N3656R · Substantial damageNTSB LAX93FA177Accident · Serious injuriesField investigationFinal reportBritish Aerospace BA 3101 · Merced, CAThe first officer's failure to maintain an adequate rate of climb after a single-engine loss of power was simulated, and the company check pilot's inadequate supervision and failure to note the descent. Darkness was a related factor.Apr 20, 1993 · N131CA · DestroyedNTSB NYC93LA088Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-150 · Nellysford, VAThe pilot's inadequate inflight decision and planning, and his failure to maintain an altitude adequate for terrain avoidance.Apr 19, 1993 · N1494P · Substantial damageNTSB NYC93LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Melville, NYThe pilot's improper inflight planning and decision, which resulted in fuel exhaustion and the subsequent forced landing.Apr 19, 1993 · N601MS · Substantial damageNTSB MIA93LA105Accident · Minor injuriesLimited investigationFinal reportSiegel Glasair III · Zephyrhills, FLContamination (fiberglass dust) in the fuel system and/or a piece of plastic (foreign) material in the fuel injector, which resulted in restricted flow of fuel to the engine, loss of engine power, and subsequent collision with trees and terrain during a…Apr 19, 1993 · N540PS · DestroyedNTSB MIA93LA103Accident · Minor injuriesLimited investigationFinal reportIseman Fokker VII · Tampa, FLLoss of engine power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.Apr 19, 1993 · N11VD · Substantial damageNTSB LAX93WA184Accident · No injuriesForeign investigationBruce RV-6 · Pvt Ranch Baja, MexicoApr 19, 1993 · N621BP · Substantial damageNTSB LAX93LA178Accident · Serious injuriesLimited investigationFinal reportMcreynolds Cassutt III · Napa, CAThe loss of engine power for undetermined reasons.Apr 19, 1993 · N7S · DestroyedNTSB DCA93GA042Accident · 8 fatalClass 1Final reportMitsubishi MU-2B-60 · Zwingle, IAThe fatigue cracking and fracture of the propeller hub arm. The resultant separation of the hub arm and the propeller blade damaged the engine, nacelle, wing, and fuselage, thereby causing significant degradation to aircraft performance and control that made…Apr 19, 1993 · N86SD · DestroyedNTSB ATL93LA078Accident · 2 fatalLimited investigationFinal reportDobbs VAN'S Aircraft RV-6 · Kingston, TNThe pilot's inadequate compensation for gusty wind conditions. A factor was the wind gust of 20-25 knots.Apr 19, 1993 · N316DD · Substantial damageNTSB NYC93LA086Accident · No injuriesLimited investigationFinal reportPitts S1T · Halifax, MADetachment of the throttle cable at the fuel injector arm. Soft terrain in the emergency landing area was a related factor.Apr 18, 1993 · N200ST · Substantial damageNTSB NYC93LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lakewood, NJThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and a collision with trees. The adverse wind was a related factor.Apr 18, 1993 · N3008F · Substantial damageNTSB FTW93LA134Accident · No injuriesLimited investigationFinal reportCessna 150F · Garrison, TXThe student pilot's failure to refuel the airplane. A factor was his becoming lostApr 18, 1993 · N8979S · Substantial damageNTSB FTW93FA132Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Henryetta, OKThe pilot's decision to fly into known adverse weather conditions and the ensuing spatial disorientation. Factors were the weather, and the pilot's decision to fly into IMC with inadequate flight and navigational equipment installed in the aircraft.Apr 18, 1993 · N4689P · DestroyedNTSB CHI93LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Festus, MOThe pilot-in-command's failure to maintain a proper glidepath during approach. Factors which contributed to the accident were: the pilot's motion sickness and the effect of the over-the-counter medication on his piloting performance.Apr 18, 1993 · N9298T · Substantial damageNTSB CHI93FAMS3Accident · 2 fatalMissing aircraftFinal reportLake LA-4 · Superior, WIundetermined.Apr 18, 1993 · N7608L · DestroyedNTSB CHI93FA139Accident · 2 fatalField investigationFinal reportCessna 172I · Ettrick, WIAn inflight explosion of a toluene-based fluid inside the airplane's cockpit.Apr 18, 1993 · N8337L · DestroyedNTSB ATL93LA077Accident · No injuriesLimited investigationFinal reportMyers Avid Aircraft Flyer · Winnsboro, SCThe pilot's failure to maintain the airspeed above the stall speed, during the forced landing. A factor was the undetermined engine malfunction.Apr 18, 1993 · N31187 · Substantial damageNTSB SEA93LA098Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Helena, MTThe inadequate lookout by the PIC and his failure to maintain clearance from electrical wires. A factor relating to the accident was the presence of electrical wires near the approach end of the airstrip.Apr 17, 1993 · N94142 · DestroyedNTSB NYC93LA084Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Buchanan, VAThe pilot's improper planning/decision, inadequate crew coordination, and failure to maintain directional control. The unfavorable wind and proximity of obstructions were related factors.Apr 17, 1993 · N33929 · Substantial damageNTSB MIA93LA108Accident · No injuriesLimited investigationFinal reportMonocoupe 110 · Lakeland, FLThe excessive application of brakes during the landing roll by the PIC. Contributing to the accident was his diverted attention while observing a flagman near the runway.Apr 17, 1993 · NC546W · Substantial damageNTSB MIA93LA104Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Fort Pierce, FLFailure of the no. 2 cylinder in fatigue for undetermined reasons, over unsuitable terrain. The lack of suitale terrain for the forced landing was a factor.Apr 17, 1993 · N7316L · DestroyedNTSB LAX93LA180Accident · No injuriesLimited investigationFinal reportBeech B24R · Aguila, AZThe loss of engine power due to fuel starvation. The fuel starvation was caused by the pilot's failure to select a tank containing fuel and the intermittent operation of the electric boost pump due to a faulty cockpit switch. A factor in the accident was the…Apr 17, 1993 · N9203S · Substantial damageNTSB LAX93LA179Accident · No injuriesLimited investigationFinal reportCessna 320 · Mesa, AZthe separation of the steering spring from the steering yoke assembly due to inadequate installation. A factor in the accident was inadequate maintenance on the aircraft.Apr 17, 1993 · N5711X · Substantial damageNTSB DEN93FA043Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Elbert, COThe pilot's inadvertent VFR flight into IMC. Factors were his lack of instrument training/experience, existing weather, and dark night conditions.Apr 17, 1993 · N38481 · DestroyedNTSB DEN93FA042Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Falcon, COInadequate supervision of the student pilot by the flight instructor. Factors were: IMC weather conditions, dark night, inaccurate weather evaluation by both the flight instructor and student pilot, and inadequate training of the student pilot.Apr 17, 1993 · N7536R · DestroyedNTSB CHI93LA141Accident · No injuriesLimited investigationFinal reportBeech V-35B · Bennington, KSThe pilot-in-command's failure to maintain directional control of the aircraft.Apr 17, 1993 · N38076 · Substantial damageNTSB BFO93FA063Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Edgewater, MDThe pilot's improper in-flight planning/decision after selecting the wrong runway for a precautionary landing , which resulted in an inadvertent descent into transmission lines, while attempting to maneuver back to the runway. Factors related to the accident…Apr 17, 1993 · N56430 · DestroyedNTSB ATL93LA076Accident · No injuriesLimited investigationFinal reportCessna 180 · Jonesboro, GAThe pilot's abrupt and excessive swerve to avoid a deer on the runway. A factor was the strong crosswind that precluded the pilot's directional control recovery.Apr 17, 1993 · N2738K · Substantial damageNTSB SEA93LA097Accident · No injuriesLimited investigationFinal reportCessna 182N · Anacortes, WAThe loss of control by the PIC when he selected the wrong runway, failed to attain the proper touchdown point, inadvertently stalled the acft attempting to abort the landing, and failed to maintain directional control after the aircraft mushed back onto the…Apr 16, 1993 · N71131 · Substantial damageNTSB FTW93LA133Accident · No injuriesLimited investigationFinal reportCessna T303 · Mena, ARThe pilot's failure to maintain directional controlApr 16, 1993 · N9481T · Substantial damageNTSB FTW93LA131Accident · No injuriesLimited investigationFinal reportHispano Aviacion HA-200 · Walnut Ridge, ARA corroded bleed air check valve and subsequent failure ot the right wing's fuel transfer system. A factor was the unfavorable windApr 16, 1993 · N554GA · Substantial damageNTSB ATL93LA075Accident · Minor injuriesLimited investigationFinal reportBell UH1F · Gatlinburg, TNThe loss of engine power for unknown reasons.Apr 16, 1993 · N4040P · Substantial damageNTSB ATL93LA074Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Concord City, NCThe failure of the pilot to maintain control of the aircraft and his delayed decision to execute a go around. A factor in the accident was the strong gusty wind condition.Apr 16, 1993 · N44BG · Substantial damageNTSB SEA93LA096Accident · Minor injuriesLimited investigationFinal reportCessna T-210N · Laurel, MTThe loss of engine power from fuel exhaustion due to the pilot's failure to ensure an adequate supply of fuel for the flt.Apr 15, 1993 · N9605Y · Substantial damageNTSB LAX93LA176Accident · No injuriesLimited investigationFinal reportCessna 172N · Flagstaff, AZThe pilot's poor aircraft handling techniques, his failure to correctly configure the carburetor heat control during the go around, and, his failure to maintain an adequate airspeed which resulted in an inadvertent stall mush condition. Factors in the…Apr 15, 1993 · N3443E · Substantial damageNTSB LAX93LA175Accident · No injuriesLimited investigationFinal reportCessna 150K · Boulder City, NVThe instructor's inadequate bounced landing recovery and airspeed management during the attempted go around, which led to an inadvertent stall and the instructor's inadequate supervision of the flight. A factor in the accident was the instructor's low total…Apr 15, 1993 · N5836G · Substantial damageNTSB FTW93LA130Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Searcy, ARThe pilot's improper flare and his improper recovery for a bounced landing. The crosswind and the pilot's improper compensation for the wind were factors.Apr 15, 1993 · N2150W · Substantial damageNTSB CHI93FA137Accident · 2 fatalField investigationFinal reportCessna 177B · Rensselaer, INThe pilot-in-command's failure to maintain aircraft control. Factors were fog and drizzle, and the pilot-in-command's continuing VFR flight into IMC conditions.Apr 15, 1993 · N973CQ · DestroyedNTSB ATL93LA081Accident · No injuriesLimited investigationFinal reportCessna 421B · Fort Payne, ALThe pilot's failure to compensate for winds during the initial takeoff that resulted in the airplane colliding with the runway, exceeding the design limits of the aircraft and upon landing at the destination airport, the collapse of the main landing gear.Apr 15, 1993 · N14A · Substantial damageNTSB ATL93LA073Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenville, TNThe pilot's improper procedures in that he landed with excessive flap extension, and his inadequate compensation for the gusting crosswind.Apr 15, 1993 · N70397 · Substantial damage