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 CHI93DCG01Accident · 2 fatalFinal reportEmory W. Greer, JR. VARI-EZE · Olathe, KSthe pilot's failure to secure a fuel cap during the preflight inspection of the airplane, and the pilot's failure to maintain aircraft control during the emergency landing. Factors associated with the accident are the unsecured fuel cap and the foreign object…Jun 13, 1993 · N222EG · DestroyedNTSB ANC93IA093Incident · No injuriesIncident investigationFinal reportCessna 206 · Portage, AKThe failure of the number two cylinder connecting rod bearing due to the shifting of the bearing within its journal race which produced an oil starvation/thermal distress event.Jun 13, 1993 · N4672U · Minor damageNTSB MIA93LA142Accident · No injuriesLimited investigationFinal reportSayer, Trevor A. Rans S-12 · New Smyrna Bch, FLFailure of the pilot to maintain adequate airspeed and inadvertent stall/spin. Contributing to the accident was total loss of engine power due to fuel starvation. This was due to improper placement of a component of the fuel system by the builder/pilot.Jun 12, 1993 · N162JT · Substantial damageNTSB MIA93FA141Accident · 1 fatalField investigationFinal reportCessna 150J · Niceville, FLThe inadequate annual inspection of the airplane by other maintenance personnel and the failure of the pilot to maintain airspeed above a stall.Jun 12, 1993 · N60366 · Substantial damageNTSB LAX93LA254Accident · No injuriesLimited investigationFinal reportCessna 150L · Yucaipa, CAthe flight instructor's selection of unsuitable terrain for the forced landing demonstration. A factor in the accident was the high density altitude existing at the time of the mishap.Jun 12, 1993 · N19507 · Substantial damageNTSB LAX93LA251Accident · No injuriesLimited investigationFinal reportAlon A2 · Goodyear, AZthe pilot's failure to maintain adequate obstruction clearance while taxiing. A factor in the accident was the pilot's attention being diverted by the movement of two trucks.Jun 12, 1993 · N6515Q · Substantial damageNTSB LAX93LA250Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Salida, CAthe pilot's failure to attain the proper touchdown point during the attempted landing. A factor in the accident was the unfavorable wind conditions for the balloon landing.Jun 12, 1993 · N71145 · Minor damageNTSB FTW93TA#07Accident · No injuriesFinal reportPiper PA-18-150 · Del Rio, TXJun 12, 1993 · N83325 · Substantial damageNTSB FTW93FA187Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Texas City, TXThe pilot's failure to recover from the intentional maneuver for undetermined reasons.Jun 12, 1993 · N2977A · DestroyedNTSB CHI93LA206Accident · Serious injuriesLimited investigationFinal reportClaude E. Merrin Zenair Stol CH-701 · Grayslake, ILThe pilot-in-command's failure to maintain aircraft control. The pilot-in-command's lack of total experience in aircraft type was a factor.Jun 12, 1993 · N701CM · DestroyedNTSB ATL93LA110Accident · Serious injuriesLimited investigationFinal reportAerotek Zuni · Brownsboro, ALThe pilot's misjudgment of distance and altitude which resulted in the collision with trees short of the runway.Jun 12, 1993 · N12ZW · Substantial damageNTSB ATL93LA109Accident · No injuriesLimited investigationFinal reportCessna 170 · Mooresville, NCPoor maintenance practices during the rebuilding of the aircraft which allowed the fuel system to become contaminated and resulted in the subsequent fuel starvation of the engine.Jun 12, 1993 · N1619D · Substantial damageNTSB ANC93LA090Accident · No injuriesLimited investigationFinal reportCessna 402 · Kivalina, AKThe failure of the pivot link for the downlock mechanism and the improper rigging of the landing gear locking mechanism by company maintenance personnel.Jun 12, 1993 · N222JA · Substantial damageNTSB ANC93LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-3 · Knik, AKThe improper use of the flight controls by the student pilot and inadequate supervision by the CFI pilot-in-command.Jun 12, 1993 · N91952 · Substantial damageNTSB ANC93LA088Accident · No injuriesLimited investigationFinal reportCessna 185 · Arctic Village, AKThe pilot's selection of unsuitable terrain for a landing. A factor related to the accident was: the soft/thin (weak) ice condition of the lake surface.Jun 12, 1993 · N8536L · Substantial damageNTSB ANC93IA087Incident · No injuriesIncident investigationFinal reportPZL Warzawa-Okecie PZL-104 Wilga 80 · Haines, AKThe parking brake failure due to a broken bracket; intentionally leaving the airplane unattended with the engine running by the pilot-in-command; and the improper planning and decision of the pilot-in-command by not using wheel chocks.Jun 12, 1993 · N909CC · No damageNTSB LAX93LA249Accident · No injuriesLimited investigationFinal reportHughes 369D · Kahului, HIThe failure of the pilot to maintain adequate ground obstruction clearance while engaged in a cattle herding operation.Jun 11, 1993 · N1113L · Substantial damageNTSB FTW93LA186Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Edgewood, NMPower loss to the right engine due to the magneto grounding leads being loose and an inadequate annual inspection. A factor was a lack of suitable terrain.Jun 11, 1993 · N8606M · Substantial damageNTSB DEN93LA068Accident · No injuriesLimited investigationFinal reportCessna 172N · Livermore, COA partial power loss when the rocker box for one cylinder disengaged. A factor was: unsuitable terrain for a forced landing.Jun 11, 1993 · N4829E · Substantial damageNTSB CHI93LA203Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Mc Laughlin, SDPilot in command's failure to maintain proper clearance.Jun 11, 1993 · N3890E · Substantial damageNTSB CHI93LA202Accident · No injuriesLimited investigationFinal reportCessna 170B · Janesville, WIThe pilot in command's failure to maintain directional control of the aircraft.Jun 11, 1993 · N1932C · Substantial damageNTSB CHI93LA201Accident · 1 fatalLimited investigationFinal reportBell 47G-2A-1 · Phlox, WIWas the pilot in command's failure to maintain aircraft control. A factor to the accident was the inadequate cyclic control.Jun 11, 1993 · N73988 · DestroyedNTSB CHI93GA204Accident · 2 fatalFinal reportBeech 95-C55 · Fort Madison, IAthe pilot-in command's failure to maintain control of the aircraft. Factors were door not secured, checklist not followed, diverted attention of the pilot-in-command, and emergency procedure not followed.Jun 11, 1993 · N301U · Substantial damageNTSB MIA93LA140Accident · No injuriesLimited investigationFinal reportMooney M20E · Miami, FLThe pilot-in-command's improper flare during a forced landing which resulted in a hard landing. Contributing to the accident was the total loss of engine power for undetermined reasons.Jun 10, 1993 · N1305W · Substantial damageNTSB CHI93LA198Accident · Serious injuriesLimited investigationFinal reportBeech 200 · Wonder Lake, ILThe failure of the pilot of the Beech 200, N210PH, to maintain sufficient runway alignment to prevent the airplane from departing the runway.Jun 10, 1993 · N210PH · 2 aircraft · Substantial damageNTSB ATL93LA108Accident · No injuriesLimited investigationFinal reportCessna 421B · Attalla, ALThe failure of the left engine turbocharger due to rotor shaft seizure, which resulted in a loss of engine power.Jun 10, 1993 · N699DT · DestroyedNTSB ATL93FA107Accident · 2 fatalField investigationFinal reportCessna TP206 · Epworth, GAThe pilot's failure to maintain vertical clearance above the trees while maneuvering which resulted in the collision with trees.Jun 10, 1993 · N5719J · DestroyedNTSB NYC93LA109Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Glen Mills, PAAn improperly planned approach in which the flare was not attained, and which resulted in a hard landing.Jun 9, 1993 · N51739 · Substantial damageNTSB NYC93LA108Accident · Serious injuriesLimited investigationFinal reportMooney M20J · New Haven, CTThe loss of airplane control as a result of the pilot encountering spatial disorientation. Factors in this accident were the low ambient light conditions and the lack of runway end identifier lightsJun 9, 1993 · N1157B · Substantial damageNTSB FTW93LA184Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Canyon Lake, TXThe movement of the pilot's seat aft which resulted in his loss of control, his inability to regain control, and the ensuing inadvertent stall. A factor was the inadequate inspection of the airplane.Jun 9, 1993 · N6446B · Substantial damageNTSB FTW93FA185Accident · No injuriesField investigationFinal reportConvair 440 · Greenville, TXThe pilot-in-command's failure to follow the published emergency procedures. Factors were engine fire warning system activating for undetermined reasons, and the resultant ac power loss when that engine was secured. The lack of recent expereince in type…Jun 9, 1993 · N580HH · Substantial damageNTSB FTW93FA183Accident · 1 fatalField investigationFinal reportEagle DW-1 · Goree, TXThe pilot's failure to maintain adequate airspeed. A factor was the pilot's lack of experience in the airplane.Jun 9, 1993 · N8808Z · DestroyedNTSB CHI93FA200Accident · 2 fatalField investigationFinal reportBeech A-36 · Tony, WIthe pilot's decision to continue flight into known adverse weather and exceeded the design strees limits of the airplane. Factors associated with the accident were inadequate preflight planning/preparation, clouds, turbulence, icing conditions, and the lack…Jun 9, 1993 · N236A · DestroyedNTSB NYC93LA106Accident · Serious injuriesLimited investigationFinal reportHenry J. Camacho Seahawk · Orange, MAThe pilot's excessive rotation and failure to obtain adequate airspeed which resulted in an inadvertent stall and inflight collision with the terrain. A factor was the pilot's inexperience in the type aircraft.Jun 8, 1993 · N5857X · DestroyedNTSB NYC93LA105Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Provincetown, MAThe pilot's failure to recover from a bounced landing and to maintain aircraft control which resulted in the airplane nosing over. Improper landing flare is a contributing factor.Jun 8, 1993 · N64932 · Substantial damageNTSB LAX93IA245Incident · No injuriesIncident investigationFinal reportBoeing 757-222 · Los Angeles, CAthe inadvertent deployment of an overwing emergency excape slide due to the inadequate latching of the slide compartment door following access by maintenance personnel. A factor in the accident was the inadequate door closing procedure specified by the…Jun 8, 1993 · N540UA · Minor damageNTSB FTW93LA181Accident · No injuriesLimited investigationFinal reportDrlik Falcon XC · Albuquerque, NMThe extraneous and uncommanded roll and yaw deviations caused by inadequate airplane design which precluded the pilot from taking corrective action and led to the ensuing hard landing.Jun 8, 1993 · N687RD · Substantial damageNTSB CHI93LA196Accident · No injuriesLimited investigationFinal reportCessna 172N · St. James, MIThe pilot landed too long on a wet runway.Jun 8, 1993 · N73630 · Substantial damageNTSB CHI93FA193Accident · 1 fatalField investigationFinal reportBeech E18S · Ypsilanti, MIThe pilot-in-command's inadequate preflight preparation, false indication (on/off) of attitude indicator, and attitude indicator switched off. Factors were fog, low ceiling, the pilot-in-command's improper use of the attitude indicator, and his lack of total…Jun 8, 1993 · N51FG · DestroyedNTSB NYC93LA104Accident · No injuriesLimited investigationFinal reportCessna 150J · West Caldwell, NJThe complete loss of engine power as a result of carburetor icing, the subsequent forced landing and impact with the terrain.Jun 7, 1993 · N60186 · Substantial damageNTSB NYC93LA100Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Cincinnati, OHThe pilot's improper inflight planning and decision resulting in fuel exhaustion, and the subsequent forced landing and collision with power lines.Jun 7, 1993 · N24938 · Substantial damageNTSB NYC93FA102Accident · 1 fatalField investigationFinal reportCessna 150E · Selbyville, DEThe pilot's failure to maintain proper airspeed resulting in an inadvertent stall/spin and collision with the terrain. A factor related to the accident was the pilot's lack of experience in the banner towing operation.Jun 7, 1993 · N3981U · DestroyedNTSB FTW93LA180Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Dumas, ARThe pilot's inadequate compensation for wind conditions.Jun 7, 1993 · N6622Q · Substantial damageNTSB BFO93GA102Accident · 2 fatalFinal reportBeech B24R · Manassas, VAFailure of the pilot to maintain adequate airspeed while maneuvering for a precautionary landing which resulted in an inadvertent stall. A related factor was that the pilot's attention was diverted by the open door.Jun 7, 1993 · N824V · DestroyedNTSB ANC93LA083Accident · No injuriesLimited investigationFinal reportBeech 56TC · Chistochina, AKThe pilot's improper decision to land on a rough airstrip.Jun 7, 1993 · N9194Q · Substantial damageNTSB ANC93IA084Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Anchorage, AKThe failure of the nose landing gear inner cylinder from an overload/overstress condition.Jun 7, 1993 · N673MA · Minor damageNTSB NYC93LA101Accident · No injuriesLimited investigationFinal reportCessna 172P · Lincoln Park, 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.Jun 6, 1993 · N97055 · Substantial damageNTSB MIA93LA139Accident · No injuriesLimited investigationFinal reportBeech 23 · Tampa, FLThe pilot-in-command's improper landing flare, which resulted in the aircraft bouncing and entering a porpoise maneuver. Contributing to the accident was his failure to recover from the bounced landing and perform a go-around.Jun 6, 1993 · N24693 · Substantial damageNTSB LAX93LA244Accident · 1 fatalLimited investigationFinal reportBeech K-35 · Eureka, NVThe pilot disregarding the advice that visual flight rules were not recommended; the pilot's inadequate weather evaluation along his route of flight; the pilot attempting flight into known adverse weather conditions; the pilot's loss of aircraft control due…Jun 6, 1993 · N672T · DestroyedNTSB LAX93FA242Accident · 2 fatalField investigationFinal reportPiper PA-23-150 · Diablo, CAThe pilot in command's continued flight into instrument meteorological conditions, and the improper in flight planning and decision making by the pilot.Jun 6, 1993 · N522T · Destroyed