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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB NYC92DEK01Accident · Minor injuriesFinal reportFlight Works Capella · Fredonia, OHAn in Flight collision with telephone wires while on approach for landing.NTSB 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.NTSB 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.NTSB SEA92FA077Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Briggsdale, COProper altitude was not maintained. Factors include ostentatious display.NTSB 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.NTSB 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.NTSB CHI92LA129Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Iron Mountain, MIThe presence of water in the air induction system.NTSB 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.NTSB 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.NTSB SEA92LA076Accident · No injuriesLimited investigationFinal reportAerospatiale SA315B · Magna, UTThe overheat of the engine combustion section, and the failure of the turbine blades.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB FTW92LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Stuttgart, ARThe pilot's failure to compensate for wind conditions. Factors were the crosswind and the downdraft.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB SEA92LA073Accident · No injuriesLimited investigationFinal reportEnstrom 280 FX · Mount Vernon, WAA hard landing by the pilot, after a power loss due to fuel exhaustion.NTSB FTW92LA113Accident · 1 fatalLimited investigationFinal reportBoeing A75N1 · Lawton, OKThe pilots'decision to fly into marginal VFR weather. A factor was the guy wire and fog.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB LAX92LA175Accident · Minor injuriesLimited investigationFinal reportHughes 369C · Pacific Ocean (Pacific Ocean)An undetermined failure in the rotor system.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB FTW92FA112Accident · 2 fatalField investigationFinal reportBell 206L-3 · Venice, LAThe pilot's incapacitation due to food poisoning.NTSB 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.NTSB 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.NTSB 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.NTSB 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.