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 CHI92DEM01Accident · No injuriesFinal reportRose Wesley Rotorway WR Exec · Hudsonville, MIThe failure of an intake valve spring. Factors related to the accident were the low altitude at which the autorotation was initiated and the soft terrain on which the helicopter was landed.Apr 18, 1992 · N6617L · Substantial damageNTSB ANC92LA062Accident · No injuriesLimited investigationFinal reportCessna 172M · Haines, AKThe pilot's delayed decision to abort the takeoff. Factors to the accident were: inadequate airspeed an soft/sandy terrain.Apr 18, 1992 · N80115 · Substantial damageNTSB SEA92LA081Accident · No injuriesLimited investigationFinal reportPiper J-5A · Broadus, MTFuel system exhaustion. Factors include an inadequate preflight, inadvertent fuel dumping, and a ditch in the landing area.Apr 17, 1992 · N35931 · Substantial damageNTSB NYC92FA079Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Hamburg, PAThe pilot's improper in-flight decision, his failure to follow proper IFR procedures, and an improperly planned approach, which resulted in an inflight collision with rising terrain during the execution of the missed approach procedure. Factors related to the…Apr 17, 1992 · N62774 · DestroyedNTSB FTW92LA115Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Acton, TXThe excessive airspeed during the landing. Factors were the carburetor icing conditions, the carburetor ice induced power loss, and the pilot's delayed use of carburetor heat.Apr 17, 1992 · N2430K · Substantial damageNTSB MIA92FA110Accident · 1 fatalField investigationFinal reportCessna 152 · Bushnell, FLThe pilot-in-command's failure to maintain airspeed (vso) while maneuvering during a forced landing. This resulted in an inadvertent stall, in flight loss of control, and collision with terrain. Contributing to the accident was the pilot-in-command's failure…Apr 16, 1992 · N47343 · DestroyedNTSB LAX92LA178Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Galt, CAThe pilot's poor in-flight decision by selecting an improper cruise altitude. Contributing to this accident was the pilot's fatigue due to lack of sleep.Apr 16, 1992 · N6213S · DestroyedNTSB LAX92LA177Accident · No injuriesLimited investigationFinal reportBeech E18S · Eloy, AZFailure of the pilot-in-command to maintain directional control and to properly compensate for the unfavorable wind conditions encountered during the takeoff ground run. Contributing to the accident was the unforecasted dust devil weather phenomena.Apr 16, 1992 · N711DN · Substantial damageNTSB ATL92LA081Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Elgin, SCThe improperly installed spark plug by an unknown person. The lack of suitable terrain for a forced landing was a factor.Apr 16, 1992 · N2901E · Substantial damageNTSB NYC92DEK01Accident · Minor injuriesFinal reportFlight Works Capella · Fredonia, OHAn in Flight collision with telephone wires while on approach for landing.Apr 15, 1992 · UNREG · Substantial damageNTSB ATL92IA080Incident · No injuriesIncident investigationFinal reportFokker F.28 MK4000 · Charlotte, NCThe pilot-in-command's decision to reject the takeoff at a speed in excess of V1, resulting in an inadequate distance to stop the aircraft.Apr 15, 1992 · N495US · No damageNTSB SEA92LA078Accident · No injuriesLimited investigationFinal reportMaule M-7 · Aravada, WYThe pilot's failure to maintain a visual lookout, and his diverted attention. Factors include a low pass, and a transmission wire in the path of flight.Apr 14, 1992 · N61043 · Substantial damageNTSB SEA92FA077Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Briggsdale, COProper altitude was not maintained. Factors include ostentatious display.Apr 14, 1992 · N2742M · DestroyedNTSB NYC92LA077Accident · No injuriesLimited investigationFinal reportCessna 172N · Sidney, OHThe failure of the pilot to maintain airplane directional control after landing, which resulted in a departure from the runway and encounter with rough terrain.Apr 14, 1992 · N5085G · Substantial damageNTSB FTW92LA116Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Welsh, LAPartial power loss due to the cracked engine cylinder. A factor was the lack of suitable terrain for the forced landing.Apr 14, 1992 · N9546 · Substantial damageNTSB CHI92LA129Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Iron Mountain, MIThe presence of water in the air induction system.Apr 14, 1992 · N51782 · Substantial damageNTSB ATL92LA079Accident · No injuriesLimited investigationFinal reportGuy Whisenant Skybolt · Gadsden, ALThe pilot's inadequate preflight planning and preparation, resulting in fuel exhaustion due to an inadequate fuel supply for the planned flight.Apr 14, 1992 · N12TJ · Substantial damageNTSB SEA92LA219Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Rockford, WAImproper use of rudder trim and poor preflight planning/preparation. Factors to the accident were: directional control was not maintained and lack of familiarity with aircraft.Apr 13, 1992 · N41891 · Substantial damageNTSB SEA92LA076Accident · No injuriesLimited investigationFinal reportAerospatiale SA315B · Magna, UTThe overheat of the engine combustion section, and the failure of the turbine blades.Apr 13, 1992 · N315DY · Substantial damageNTSB LAX92FA172Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Placerville, CAThe pilot's failure to maintain control of the airplane and his improper use of the flight controls which endured airframe loads that exceeded the aircraft's design stress limits. Factors which contributed to the accident related to the pilot's encounter with…Apr 13, 1992 · N2968R · DestroyedNTSB CHI92FA127Accident · 1 fatalField investigationFinal reportCessna 172P · Kellyville, OKAn inadvertent stall and misjudgement of an emergency procedure by the pilot in trying to stretch the forced landing approach to make it to the airstrip.Apr 13, 1992 · N54736 · DestroyedNTSB ATL92LA077Accident · No injuriesLimited investigationFinal reportCessna 172I · Knightdale, NCThe pilot's inadequate compensation for crosswind conditions, and his failure to maintain aircraft control. A factor was the crosswind conditions at the airport.Apr 13, 1992 · N8471L · Substantial damageNTSB SEA92FA075Accident · 5 fatalField investigationFinal reportCessna 172P · Englewood, COA loss of airplane control initiated by inadvertent control interference by the passenger pilot while apparently attempting to quell a disturbance of an unknown nature. As a result, the pilot did not, or was unable to, maintain sufficient control of the…Apr 12, 1992 · N63078 · DestroyedNTSB NYC92FA078Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Narrows, VAThe pilot's decision to attempt VFR flight into adverse weather conditions, and the subsequent loss of airplane control. Factors related to the accident were the pilot's lack of an instrument rating, and his disregard of forcasted adverse weather along the…Apr 12, 1992 · N16540 · DestroyedNTSB MIA92LA109Accident · Serious injuriesLimited investigationFinal reportStoltzfus Stileto MK II · Cross City, FLThe pilot-in-command's continued flight into adverse weather conditions resulting in a loss of control during a precautionary landing due to a loss of visual references. The weather was a factor.Apr 12, 1992 · N3169Q · Substantial damageNTSB LAX92FA174Accident · 5 fatalField investigationFinal reportCessna P210N · Baxter, CA1) A partial loss of the airplane's vacuum system which resulted in the total loss of the directional gyro and the attitude indicator, 2) the pilot not maintaining aircraft control due spatial disorientation, and 3) the pilot not correcting for a spiral by…Apr 12, 1992 · N9TG · DestroyedNTSB FTW92LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Stuttgart, ARThe pilot's failure to compensate for wind conditions. Factors were the crosswind and the downdraft.Apr 12, 1992 · N6934H · Substantial damageNTSB DEN92IA046Incident · No injuriesIncident investigationFinal reportCessna 310-L · Hugo, COFailure of the left voltage regulator. Factors were: failure of the pilot/mechanic to properly maintain the aircraft, and failure of the right alternator circuit breaker.Apr 12, 1992 · N331BX · No damageNTSB CHI92LA128Accident · Minor injuriesLimited investigationFinal reportLake LA-4 · Lee'S Summit, MOA delayed aborted takeoff by the pilot in command. A factor in the accident is the presence of carburetor icing conditions.Apr 12, 1992 · N2032L · Substantial damageNTSB ATL92FA076Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Young Harris, GAThe failure of the pilot to maintain clearance from terrain. Factors in the accident were the dark night, rain, and mountainous terrain.Apr 12, 1992 · N7248J · DestroyedNTSB SEA92LA074Accident · 1 fatalLimited investigationFinal reportMoore Sonerai 1 · Harrisburg, ORThe pilot's failure to maintain an altitude sufficient to avoid colliding with terrain while performing acrobatic maneuvers as a result of his alcoholic impairment of efficiency and judgement. Factors contributing to the accident were: the pilots disregard of…Apr 11, 1992 · N27127 · DestroyedNTSB SEA92LA073Accident · No injuriesLimited investigationFinal reportEnstrom 280 FX · Mount Vernon, WAA hard landing by the pilot, after a power loss due to fuel exhaustion.Apr 11, 1992 · N377JD · Substantial damageNTSB FTW92LA113Accident · 1 fatalLimited investigationFinal reportBoeing A75N1 · Lawton, OKThe pilots'decision to fly into marginal VFR weather. A factor was the guy wire and fog.Apr 11, 1992 · N52653 · Substantial damageNTSB CHI92LA126Accident · Serious injuriesLimited investigationFinal reportCessna 170B · St. James, MOThe pilot's failure to maintain clearance from terrain during the attempted takeoff and climb out. A related factor was the rising terrain.Apr 11, 1992 · N1966C · Substantial damageNTSB ATL92IA078Incident · No injuriesIncident investigationFinal reportMaule M-5-210 · Atlanta, GAThe failure of the engine cylinder as a result of cylinder overtemperature, which resulted from the improper procedure of use of the aircraft in a banner towing operation by the operator.Apr 11, 1992 · N51590 · Minor damageNTSB SEA92LA072Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Missoula, MTPartial blockage of the left engine induction air filter, inability to maintain the proper rate of descent, and delayed extension of the landing gear. Factors contributing to the accident were icing conditions, wing ice, and rough/uneven terrain.Apr 10, 1992 · N3494P · Substantial damageNTSB NYC92DHM02Accident · No injuriesFinal reportCarey Glassair SH2 · West Milford, NJImproper installation of the wheel brakes, which resulted in failure of a left brake line during the landing roll and subsequent loss of directional control and collision with an object after departing the runway.Apr 10, 1992 · N80004 · Substantial damageNTSB LAX92LA176Accident · No injuriesLimited investigationFinal reportMcewen Dick Glasair III · Casa Grande, AZA failure of the pilot to select the proper fuel tank and subsequent fuel starvation. Contributing to the accident was an inadequate design by the manufacturer that permitted the fuel selector to be rotated 360 degrees, and the pilot's lack of familiarity…Apr 10, 1992 · N115DM · Substantial damageNTSB LAX92LA175Accident · Minor injuriesLimited investigationFinal reportHughes 369C · Pacific Ocean (Pacific Ocean)An undetermined failure in the rotor system.Apr 10, 1992 · N8311F · Substantial damageNTSB LAX92LA171Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Tucson, AZThe total failure of the landing gear strut (trunnion) due to fatigue. A factor in the accident was related to the inadequately performed recent annual inspection.Apr 10, 1992 · N41632 · Substantial damageNTSB SEA92LA071Accident · No injuriesLimited investigationFinal reportCessna A185F · Billings, MTA worn tailwheel steering system and inadequate inspection of the airplane. A factor relating to the accident was the crosswind condition.Apr 9, 1992 · N135NC · Substantial damageNTSB NYC92LA076Accident · 1 fatalLimited investigationFinal reportMcdonnell Douglas DC-9-32 · Dayton, OHA failed wheel rim following an inadvertent over inflation by the mechanic. Additional causes were the failure of the mechanic to be aware of the pressure being used and his failure to follow procedures. A factor related to the accident was the failure of the…Apr 9, 1992 · N926L · Minor damageNTSB MIA92GA107Accident · 2 fatalFinal reportBeech C90 · St. Augustine, FLThe pilot's failure to properly adhere to the published instrument approach procedure which resulted in descent below the minimum descent altitude. Factors which contributed to the accident were the low ceiling and fog.Apr 9, 1992 · N105FL · DestroyedNTSB MIA92FA108Accident · 2 fatalField investigationFinal reportGlobe GC1-B · Miami, FLAn abrupt pitch up maneuver during acrobatic flight resulting in an overload failure of the right wing spar.Apr 9, 1992 · N90379 · DestroyedNTSB FTW92GA111Accident · 1 fatalFinal reportPiper PA-32R-301T · Albuquerque, NMFuel line failure due to vibratory fatigue. Factors were improper maintenance, manufacturer information for fuel line not available, and the pilots' failure to follow emergency procedures.Apr 9, 1992 · N8194X · Substantial damageNTSB FTW92FA112Accident · 2 fatalField investigationFinal reportBell 206L-3 · Venice, LAThe pilot's incapacitation due to food poisoning.Apr 9, 1992 · N6610L · DestroyedNTSB FTW92FA107Accident · Minor injuriesField investigationFinal reportCessna 150 II · Fort Worth, TXA fuel exhaustion induced engine power loss due to the pilot's failure to refuel. A factor was the pilot's inadvertent disorientation.Apr 9, 1992 · N67816 · Substantial damageNTSB CHI92DCQ01Accident · No injuriesFinal reportGeorge Adrian Rands/ Coyote · Agusta, KSFailure of the pilot to maintain a proper descent rate, and an airspeed above stalling speed during a VFR final approach.Apr 9, 1992 · N3181N · Substantial damageNTSB ATL92LA075Accident · No injuriesLimited investigationFinal reportKaman HH-43F · Manteo, NCThe pilot's improper use of the flight controls, in that he inadvertently activated the tail rotor pedals. Factors in the accident were the cross wind, and the slope of the landing area.Apr 9, 1992 · N100PL · Substantial damageNTSB SEA92LA070Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Hoquiam, WAThe inadequate preflight planning and preparation by the pilot, and his failure to remove a tie down rope before takeoff.Apr 8, 1992 · N393DB · Destroyed