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 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB MIA91LA153Accident · No injuriesLimited investigationFinal reportCessna 210N · Fernandina Bch, FLFailure of the pilot to obtain proper assistance while taxiing the airplane near a parked airplane.NTSB 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…NTSB 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.NTSB FTW91LA086Accident · No injuriesLimited investigationFinal reportGulfstream AA5B · La Grange, TXThe pilot's improper aircraft handling.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB BFO91LA051Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar STP1 · Quinton, VAThe pilot's failure to maintain adequate clearance from a moving aircraft.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX91LA223Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Chinle, AZFuel starvation due to fuel mismanagement by the pilot in command.NTSB FTW91FA085Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Claremore, OKThe instructor pilot (PIC) did not maintain clearance from obstacles during the maneuver.NTSB 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.NTSB 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.NTSB ANC91LA063Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Sterling, AKThe pilot's improper remedial action.NTSB 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.NTSB 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.NTSB 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…NTSB DEN91IA076Incident · No injuriesIncident investigationFinal reportAero Commander 690C · Denver, COFatigue failure of flap cable.NTSB 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.NTSB 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…NTSB 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.NTSB MIA91LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, FLPartial loss of engine power due to fuel exhaustion due to misjudged fuel consumption calculations.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ANC91LA059Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Smith Cove, AKA complete lose of engine power due to a total disintegration of the turbine wheel.NTSB 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.