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 MIA91LA154Accident · Serious injuriesLimited investigationFinal reportLarocque, Raymond E. VARI-EZE · Lake Placid, FLImproper fuel selector position by the pilot-in-command resulting in the total loss of engine power due to fuel starvation.May 27, 1991 · N1344Z · Substantial damageNTSB LAX91LA227Accident · No injuriesLimited investigationFinal reportCessna R172K · Santa Clarita, CAFuel exhaustion due to the failure of the pilot to properly perform preflight planning and to ensure that an adequate fuel supply existed for the flight.May 27, 1991 · N736MR · Substantial damageNTSB LAX91LA226Accident · Serious injuriesLimited investigationFinal reportPiper PA28-140 · Truckee, CAThe failure of the pilot to maintain airspeed and the inadvertent entry into a stall mush which led to a loss of control and an uncontrolled descent. Factors in the accident were: the pilot's poor preflight planning and the high density altitude.May 27, 1991 · N5777F · Substantial damageNTSB DEN91LA077Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Ville Platte, LAPremature pull up from an aerial application swath run resulting in a collision with an electrical transmission line.May 27, 1991 · N48383 · Substantial damageNTSB CHI91LA166Accident · No injuriesLimited investigationFinal reportCessna 172N · Chicago, ILThe pilot in command (student)'s improper judgement of the proper touchdown point. A factor contributing was the pilot in command's delaying an aborted landing.May 27, 1991 · N5710E · Substantial damageNTSB CHI91DEP05Accident · No injuriesFinal reportPiper PA-25-235 · Neenah, WIThe pilot in command's failure to attain sufficient airspeed to achieve flight, and his failure to abort the takeoff.May 27, 1991 · N855SD · Substantial damageNTSB ATL91LA100Accident · No injuriesLimited investigationFinal reportCessna 177B · Huntsville, ALThe pilot's failure to remove the control lock prior to attempting flight and his failure to follow the 'before takeoff' checklist. A factor in the accident was the pilot's diverted attention.May 27, 1991 · N19823 · Substantial damageNTSB ATL91FA099Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Surf Side Beach, SCThe improper preflight inspection of the aircraft by the pilot, in that he failed to turn the aircraft fuel selector 'on' prior to starting the engine. A factor in the accident was the aircraft fuel selector valve leaking enough fuel to the engine in the…May 27, 1991 · N6634W · Substantial damageNTSB ANC91LA062Accident · No injuriesLimited investigationFinal reportCessna 172-N · Egegik, AKThe pilot's failure to maintain directional control of the airplane during the takeoff roll. Contributing to the accident was the high winds.May 27, 1991 · N2775E · Substantial damageNTSB SEA91LA115Accident · Serious injuriesLimited investigationFinal reportDave Ronneberg LONG-EZE · Kanab, UTLoss of aircraft control in flight which resulted from the pilot's diverted attention and his failure to maintain proper airspeed.May 26, 1991 · N515DR · Substantial damageNTSB NYC91DGT05Accident · Minor injuriesFinal reportAlexander Schleicher ASW-24 · Beaver Springs, PAThe pilot's loss of control in flight as the result of a strong downdraft and wind shift.May 26, 1991 · N24SN · Substantial damageNTSB MIA91LA153Accident · No injuriesLimited investigationFinal reportCessna 210N · Fernandina Bch, FLFailure of the pilot to obtain proper assistance while taxiing the airplane near a parked airplane.May 26, 1991 · N6555Y · Substantial damageNTSB LAX91LA225Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Kernville, CA1)The failure of the pilot to accurately assess and compensate for the prevailing wind conditions; 2) his failure to maintain a correct approach speed for the aircraft; 3) his failure to attain a proper touchdown point; and 4) his failure to initiate a go…May 26, 1991 · N2687G · Substantial damageNTSB LAX91LA224Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Palm Springs, CALack of total experience by the unqualified person at the controls; improper use of rotorcraft flight controls by an unqualified person. A factor in the accident was the fence.May 26, 1991 · N7033H · DestroyedNTSB FTW91LA086Accident · No injuriesLimited investigationFinal reportGulfstream AA5B · La Grange, TXThe pilot's improper aircraft handling.May 26, 1991 · N4554B · Substantial damageNTSB FTW91FA084Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Folsom, LAThe inadvertent stall. Factors were the pilot's poor judgement in performing the buzzing maneuver and his lack of experience.May 26, 1991 · N6181W · DestroyedNTSB FTW91DRD05Accident · No injuriesFinal reportBell 47-D1 · Sun, LAThe total loss of power for undetermined reasons and the failure of the pilot to maintain rotor RPM. A factor was the lack of suitable terrain.May 26, 1991 · N339MC · Substantial damageNTSB CHI91LA163Accident · No injuriesLimited investigationFinal reportCessna 180 · Devils Lake, NDDirectional control not maintained by the pilot. A factor related to the accident was a crosswind condition.May 26, 1991 · N115F · Substantial damageNTSB CHI91DTK01Accident · 2 fatalFinal reportPiper PA-18-125 · Newell, SDAn inadvertent stall/spin during maneuvering flight and inadequate remedial action by the pilot. Factors associated with the accident are the pilot's disregard for procedures and directives and inadequate initial training.May 26, 1991 · N1799A · DestroyedNTSB BFO91LA051Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar STP1 · Quinton, VAThe pilot's failure to maintain adequate clearance from a moving aircraft.May 26, 1991 · N949Z · 2 aircraft · Substantial damageNTSB SEA91FA119Accident · 2 fatalField investigationFinal reportStinson 108-2 · Gold Bar, WAThe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to remain clear of the obstacles (trees). The adverse weather condition (fog) was a related factor.May 25, 1991 · N9715K · DestroyedNTSB NYC91LA141Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Ossipee, NHAn inadequate annual inspection by the mechanic which resulted in the inflight failure of the elevator control cable.May 25, 1991 · N6342N · Substantial damageNTSB NYC91FA140Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Shelburne, VTPremature lift-off by the pilot, which resulted in a subsequent stall/mush and collision with trees. Factors related to the accident were: the pilot's inadequate preflight planning/preparation, and the unfavorable wind condition.May 25, 1991 · N8433C · DestroyedNTSB NYC91DHD02Accident · 1 fatalFinal reportBeamont Skybolt · Pennington, NJThe pilot's inadvertent lift off and failure to maintain aircraft control which resulted in an inadvertent stall. The pilot's lack of recent experience and lack of experience in type of airplane were factors in the accident.May 25, 1991 · N69JB · DestroyedNTSB MIA91LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Flamingo, FLPartial loss of engine power due to failure of the no. 3 cylinder exhaust valve for undetermined reasons. Contributing to the accident was lack of suitable terrain during the forced landing.May 25, 1991 · N56118 · Substantial damageNTSB MIA91LA151Accident · Minor injuriesLimited investigationFinal reportBeech 80 · Fort Lauderdale, FLThe improper maintenance work by an unknown person who crossthreaded a fuel nozzle injector fitting which allowed fuel to leak on the exhaust system initiating a fire. No reason for the right engine not to develop full power was found.May 25, 1991 · N5128Y · DestroyedNTSB LAX91LA229Accident · No injuriesLimited investigationFinal reportGlaser-Dirks DG-500M · Minden, NVAn engine failure produced as a result of the pilot improperly adjusting the carburetor mixture jet.May 25, 1991 · N503V · Substantial damageNTSB LAX91LA223Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Chinle, AZFuel starvation due to fuel mismanagement by the pilot in command.May 25, 1991 · N593B · Substantial damageNTSB FTW91FA085Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Claremore, OKThe instructor pilot (PIC) did not maintain clearance from obstacles during the maneuver.May 25, 1991 · N3609K · DestroyedNTSB FTW91DPG11Accident · No injuriesFinal reportGrumman G-164A · Holly Grove, ARThe pilot's failure to maintain directional control. Factors were the wet runway and the ditch struck after control was lost.May 25, 1991 · N5214 · Substantial damageNTSB BFO91LA050Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Danville, VAAn inadequate preflight inspection which resulted in water contaminated fuel. Contributing was noncompliance with an airworthiness directive.May 25, 1991 · N5931D · Substantial damageNTSB ANC91LA063Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Sterling, AKThe pilot's improper remedial action.May 25, 1991 · N4649E · No damageNTSB ANC91LA061Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Larsen Bay, AKThe pilot's decision to continue VFR into IMC conditions and failure to maintain proper altitude. Contributing to the accident was the low ceiling and fog.May 25, 1991 · N4851X · DestroyedNTSB SEA91LA118Accident · No injuriesLimited investigationFinal reportBeech A36TC · Ogden, UTLoss of control by the pilot due to inadequate preflight planning and preparation which resulted in over gross weight aircraft loading. A factor relating to the accident was the high density altitude weather conditions.May 24, 1991 · N3671F · Substantial damageNTSB LAX91FA222Accident · 1 fatalField investigationFinal reportCessna 150K · El Cerrito, CAFuel exhaustion due to improper preflight planning and inaccurate fuel consumption calculations. Factors related to the accident were the failure of the pilot to choose a proper emergency landing site and/or deviate from a straight course during the emergency…May 24, 1991 · N6003G · DestroyedNTSB DEN91IA076Incident · No injuriesIncident investigationFinal reportAero Commander 690C · Denver, COFatigue failure of flap cable.May 24, 1991 · N81TR · No damageNTSB CHI91LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · St. Charles, MOThe pilot's failure to maintain directional control of the airplane during the takeoff ground run. Factors related to the accident were the gusty crosswind conditions, the pilot's lack of total experience and the vehicles which the airplane contacted.May 24, 1991 · N931VN · DestroyedNTSB NYC91LA139Accident · No injuriesLimited investigationFinal reportBeech BE-23-B24R · Caribou, METhe failure of the engine driven fuel pump, which resulted in a total loss of engine power and subsequent forced landing on rough terrain. Factors related to the accident were the decision by the pilot to takeoff with known mechanical deficiencies; the…May 23, 1991 · N6968R · Substantial damageNTSB NYC91LA138Accident · No injuriesLimited investigationFinal reportCessna 172N · Canadensis, PAThe pilot's improper planning/decision. A factor related to the accident was the downhill slope of the runway.May 23, 1991 · N739GV · Substantial damageNTSB MIA91LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, FLPartial loss of engine power due to fuel exhaustion due to misjudged fuel consumption calculations.May 23, 1991 · N6495L · Substantial damageNTSB MIA91LA149Accident · 1 fatalLimited investigationFinal reportCessna 172M · Missing (Atlantic Ocean)The lose of engine power for undetermined reasons which resulted in a forced landing and ditching in the atlantic ocean.May 23, 1991 · N73186 · DestroyedNTSB FTW91DPG10Accident · No injuriesFinal reportWeatherly 201B · Mc Crory, ARLoss of the outboard portion of the propeller blade. A factor was the lack of suitable terrain for the forced landing.May 23, 1991 · N1260W · Substantial damageNTSB CHI91LA165Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Big Rapids, MIExcessive application of the flight controls by the student pilot. A factor related to the accident is delayed remedial action by the flight instructor.May 23, 1991 · N7209Y · Substantial damageNTSB ATL91LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Knightdale, NCThe student pilot's delay in aborting the takeoff. The pilot's continued operation of the airplane with a known discrepancy and the operator's previous improper maintenance/inspection of the pitot/static system were factors related to the accident.May 23, 1991 · N93002 · Substantial damageNTSB SEA91LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Laramie, WYThe pilot's failure to maintain an airspeed above the stall speed for the aircraft. Contributing to the accident was the high density altitude.May 22, 1991 · N2234A · Substantial damageNTSB CHI91LA172Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, ILThe pilot in command's misjudgment of the proper touchdown point. An associated factor is the pilot-in-command not performing remedial action.May 22, 1991 · N24394 · Substantial damageNTSB CHI91LA162Accident · No injuriesLimited investigationFinal reportCessna 177 · New Lothrop, MIFuel exhaustion and misjudged fuel calculations by the pilot. A factor was the lack of suitable terrain available for an emergency landing.May 22, 1991 · N548EC · Substantial damageNTSB ANC91LA060Accident · No injuriesLimited investigationFinal reportHughes 500-D · Togiak, AKThe pilot's failure to secure the cargo prior to the flight. Contributing to the accident was the rough, uneven terrain.May 22, 1991 · N5314D · Substantial damageNTSB ANC91LA059Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Smith Cove, AKA complete lose of engine power due to a total disintegration of the turbine wheel.May 22, 1991 · N87729 · Substantial damageNTSB ANC91DAG02Accident · Serious injuriesFinal reportDavid K. Maxwell MAX-1 · Sutton, AKThe pilot's failure in maintaining airspeed and not identifying the stall during the descent for landing.May 22, 1991 · N4921S · Substantial damage