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 FTW94LA133Accident · Minor injuriesLimited investigationFinal reportLaurel Aero Club Cassutt III M · Strasburg, COThe pilot's failure to attain the proper touchdown point. Factors were: a power failure due to a sheared accessory drive gear, excessive airspeed and altitude, and a soft field.NTSB CHI94FA137Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Marshfield, MOFailure of the pilot to maintain proper altitude during a VFR flight into IMC conditions.NTSB BFO94LA072Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Clarion, PAThe pilot's failure to maintain directional control which resulted in an overrun of the runway and collision with a berm.NTSB BFO94FA071Accident · 4 fatalField investigationFinal reportBell 412/SP · Bluefield, VAThe pilot's failure to intercept the final approach course, and his improper execution of the instrument approach procedure. Factors which contributed to the accident were: the weather conditions, and the failure of the air traffic controller to adequately…NTSB FTW94LA136Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Laredo, TXThe fuel exhaustion induced power loss due to the pilot's inadequate preflight and his failure to refuel the airplane prior to departure. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA131Accident · Minor injuriesLimited investigationFinal reportGulfstream G-164B · Delaplaine, ARThe loss of engine power for undetermined reasons. A factor was the low altitude at which the power loss occurred.NTSB CHI94LA138Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Fargo, NDthe pilot in command's improper autorotation technique. A factor associated with the accident is the FAA Inspector's delayed remedial action.NTSB SEA94LA105Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Auburn, WAClearance was not maintained by an other person. A factor to the accident was: procedures/directives were inadequate.NTSB LAX94FA198Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · Santa Monica, CAfuel starvation resulting from the failure of the pilot to select a tank containing fuel, and his failure to maintain adequate airspeed while maneuvering for a forced landing which resulted in an inadvertent stall.NTSB CHI94LA139Accident · No injuriesLimited investigationFinal reportCessna 172K · Howes, SDThe diverted attention of the pilot-in-command and his failure to maintain proper altitude.NTSB CHI94LA136Accident · No injuriesLimited investigationFinal reportCessna 150A · Angola, INthe on ground collision of the airplane with a deer. A factor was the dark night.NTSB BFO94T#001Accident · No injuriesClass 3Final reportCessna 210 · Augusta, MENTSB ATL94LA084Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Ozark, ALA loss of engine power for undetermined reasons. A factor was the soft terrain.NTSB CHI94DEE01Accident · 2 fatalFinal reportRemote Sensing Cirrus VK-30 · Lk In The Hills, ILfuel starvation resulting from the modification of the fuel system. A factor was the modification to the fuel system.NTSB SEA94LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Hanksville, UTThe excess airspeed maintained by the pilot on final approach, and his failure to attain the proper touchdown point. Factors include loose gravel, and a berm off the end of the intended landing strip.NTSB SEA94IA103Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-83 · Seattle, WAThe fatigue fracture of a main gear wheel hub.NTSB LAX94FA197Accident · 1 fatalField investigationFinal reportHughes 369D · Hanapepe, HIInadequate turbine engine compressor cleaning procedures based on information in the manufacturer's service letter, and loss of engine power due to blockage of the fuel nozzle strainer with foreign material (sodium). Factors related to the accident were: the…NTSB FTW94LA130Accident · No injuriesLimited investigationFinal reportBeech 95 · Greeley, COA failure of the right engine propeller governor oil line which was the incorrect line and improperly installed by maintenance personnel.NTSB FTW94LA128Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Monticello, ARThe loss of power for undetermined reasons and the inadvertant stall during the forced landing. A factor was the lack of suitable terrain.NTSB BFO94LA070Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Bedford, PAThe pilot's failure to maintain the proper descent rate which resulted in an undershoot of the runway.NTSB LAX94LA200Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Yuma, AZan uncommanded engine deceleration to idle due to the improper installation of the throttle arm on the carburetor shaft.NTSB LAX94LA194Accident · 1 fatalLimited investigationFinal reportPitts S-2A · Kahuku, HIThe failure of the pilot to maintain aircraft control due to spatial disorientation while performing an acrobatic routine. A factor in the accident was the low altitude at which the pilot was performing the acrobatic maneuvers.NTSB LAX94LA192Accident · No injuriesLimited investigationFinal reportCessna 172F · Arlington, CAFailure of the certified flight instructor to properly supervise the student pilot and perform the appropriate remedial action before the airplane descended to an altitude too low for recovery. Factors were the student pilot's handling of the airplane which…NTSB LAX94LA191Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Mt Home Village, CAA loss of engine power due to undetermined reasons. The failure of the student pilot to properly plan his airport traffic pattern to reach the runway or other suitable forced landing area in the event of a loss of engine power was a factor in the accident.NTSB LAX94LA190Accident · 2 fatalLimited investigationFinal reportBushby Mustang II · Byron, CAan abrupt maneuver by the pilot that initiated an in-flight separation of the tail and wing sections during acrobatic flight.NTSB LAX94FA193Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Nogales, AZa failure of the pilot to maintain adequate airspeed which resulted in an inadvertent stall.NTSB FTW94FA123Accident · 1 fatalField investigationFinal reportSIAI-Marchetti F.260C · Watson, ARThe pilot's failure to maintain adequate clearance from wires during low level flight which resulted in a severed aileron cable. Factors were the pilot's failure to maintain adequate altitude during the flight and his inability to control the airplane…NTSB CHI94LA135Accident · No injuriesLimited investigationFinal reportCessna 150J · Fredricktown, MOthe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the crosswind.NTSB CHI94IA134Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-146-200 · Chicago, ILa loose fuel nozzle.NTSB CHI94DER01Accident · Minor injuriesFinal reportJohnson Avid Flyer Mark IV · New Richmond, WICarburetor ice, and the owner/builder's inadequate airplane/equipment design, in that there was no carburetor heat/control installed in the airplane. Factors related to the accident were: the weather (carburetor icing conditions), and obstacles (trees) in the…NTSB BFO94LA068Accident · No injuriesLimited investigationFinal reportCessna 150H · Mount Vernon, OHThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and collision with the ground. Factors were transmission wires and the pilot's inadequate inflight decision.NTSB BFO94LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Butler, PAThe pilot's failure to select the proper fuel tank, which resulted in fuel starvation and the loss of engine power.NTSB ATL94LA083Accident · No injuriesLimited investigationFinal reportCessna 172K · Spartanburg, SCThe inadequate visual lookout by the pilot of Cessna 172K, N711GT.NTSB ANC94LA050Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Fairbanks, AKThe failure of the pilot to abort the takeoff when her foot interfered and restricted the movement of the rudder control system.NTSB SEA94LA160Accident · No injuriesLimited investigationFinal reportNewgard Kitfox III · Yelm, WAFuel starvation due to an inadequately installed fuel line.NTSB SEA94LA102Accident · No injuriesLimited investigationFinal reportCessna 172L · Colville, WAThe pilot's failure to attain a proper touchdown point, and his excessive airspeed at the point of touchdown. Factors include the student pilot's lack of recent experience, and a ravine off the end of the runway.NTSB MIA94LA123Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Spring Hill, FLUnsuitable terrain encountered during a forced landing. Contributing to the accident was the fatigue failure of one of the propeller blade's pitch change knob.NTSB MIA94LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Margate, FLFailure of the pilot-in-command to position the fuel selectors to the fullest tank before landing resulting in the total loss of engine power from both engines due to fuel starvation.NTSB LAX94LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hesperia, CALoss of engine power due to an air leak at the gascolator gasket, which was improperly installed during maintenance. Darkness was a related factor.NTSB FTW94LA137Accident · No injuriesLimited investigationFinal reportJacobson SE5A Replica · Rosenberg, TXThe pilot's improper compensation for the winds. A factor was the tailwind.NTSB FTW94LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe improper landing, abrupt lowering of the nose gear. A factor was the landing airspeed exceeded.NTSB FTW94LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Muskogee, OKThe pilot's failure to maintain clearance with the power line. Factors were a chemical spray contaminated windscreen, the resultant limitation to visibility, and sun glare.NTSB FTW94LA125Accident · Minor injuriesLimited investigationFinal reportHiller UH-12 · Alvin, TXThe pilot's failure to maintain rotor speed, delay of the flare, and the improper touchdown. A factor was the loss of engine power for undetermined reasons.NTSB CHI94LA132Accident · Serious injuriesLimited investigationFinal reportAerostar RX-7 · Augusta, KSThe improper touchdown performed by the balloon pilot.NTSB BFO94FA066Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Salem, OHVFR flight by the pilot into instrument meteorological conditions (IMC), his loss of aircraft control due to spatial disorientation, and exceeding the design stress limits of the aircraft. Factors related to the accident were: darkness, the adverse weather…NTSB SEA94LA101Accident · Minor injuriesLimited investigationFinal reportAsher RV-6 · Enterprise, ORA loss of power due to a partially blocked induction air filter. Factors include no suitable terrain on which to execute a forced landing.NTSB MIA94LA121Accident · 1 fatalLimited investigationFinal reportBack Forty Developments Tundra · Lakeland, FLIn-flight loss of control due to incapacitation (heart attack or stroke) resulting in an in-flight collision with tomato crates and terrain.NTSB FTW94LA129Accident · No injuriesLimited investigationFinal reportCessna 172P · Tulsa, OKThe pilot's failure to compensate for wind conditions. A factor was the gusting cross wind.NTSB FTW94LA124Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Englewood, COThe pilot's failure to maintain rotor RPM, his delayed flare, and improper touchdown. A factor was a failure of the fuel control/governor to the high side which required the pilot to perform a full autorotation.NTSB BFO94LA069Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Beverly, MAThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and collision with the ground.