NTSB investigations
3,929 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
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 WHERE c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130) 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 WHERE c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) 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 MIA94LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Osteen, FLThe pilot-in-command's decision to land with excessive airspeed, and failure to obtain the proper touchdown point during a precautionary landing. The electrical short was a factor in the accident.NTSB BFO94LA159Accident · No injuriesLimited investigationFinal reportBell UH-1B · Carrabasset, MEFracture failure of the tail rotor drive intermediate gearbox.NTSB CHI94LA288Accident · No injuriesLimited investigationFinal reportBede BD-10 · Chesterfield, MOthe canopy lock pin design which allowed the pilot to receive a 'closed and locked' indication without the canopy lock pin being engaged. Factors were the pilots' intentional abort above rotation speed, the lack of developed takeoff and accelerate-stop…NTSB ATL94FA166Accident · 1 fatalField investigationFinal reportSchweizer SGS 1-34R · Maylene, ALThe pilot exceeding the design stress limits of the aircraft, resulting in an overload failure of the wing spar, and separation of the left wing from the aircraft. A factor was the pilot's lack of total flying experience in this model of aircraft.NTSB SEA94LA229Accident · No injuriesLimited investigationFinal reportBeech E-35 · Everett, WAThe nose gear extension assembly failure.NTSB SEA94LA213Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Nehalem, ORThe separation of the landing gear transmission assembly from its attach bracket rivets due to undetermined reasons. It was not possible for the landing gear to be locked down during the landing roll due to this separation.NTSB LAX94FA323Accident · 3 fatalField investigationFinal reportLockheed C-130A · Pearblossom, CAthe inflight failure of the right wing due to fatigue cracking in the underside right wing skin and overlying doubler. A factor contributing to the accident was inadequate maintenance procedures to detect fatigue cracking.NTSB CHI94LA272Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Spiritwood, NDthe failure of the fuselage tubing in the empennage.NTSB LAX94LA304Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Devore, CAwas the failure of the pilot to follow checklist and emergency procedures, which resulted in an improper decision to land on a dirt road within two miles of an airport.NTSB MIA94LA182Accident · Serious injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 601 · Atlantic Ocean (Atlantic Ocean)An electrical system short for undetermined reasons.NTSB NYC94FA123Accident · No injuriesField investigationFinal reportGates Learjet 35 · Atlantic City, NJUnder-inflation of the tires, due to improper maintenance, which resulted in overheating and subsequent tire failure; the incorrect checklist that was provided to the aircrew; and failure of the pilot-in-command to deploy the drag chute, when the thrust…NTSB FTW94FA231Accident · 4 fatalField investigationFinal reportAerospatiale AS-350B1 · Galveston, TXInadequate torquing of the left lateral servo by maintenance personnel, which allowed it to become disconnected from the controls, leading to an in-flight loss of control.NTSB MIA94LA176Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Sanford, FLThe failure of the tailrotor driveshaft for undetermined reasons resulting in loss of tailrotor drive. This resulted in the helicopter spinning uncontrolled and descending from a hover until it crashed in the water.NTSB FTW94IA227Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD80 · Denver, COFailure of the right main landing gear torque link assembly and shimmy dampener for unknown reasons.NTSB MIA94LA171Accident · No injuriesLimited investigationFinal reportPitts S2B · Fort Lauderdale, FLThe poor welding quality of the manufacturer, resulting in the fatigue failure of the aileron attachment bracket.NTSB LAX94LA274Accident · No injuriesLimited investigationFinal reportHayes Dickey E-RACER · Elko, NVa fatigue fracture and separation of the propeller flange from an improperly machined propeller extension assembly. Inadequate design, substantiation, and approval of the part design was a factor in the accident.NTSB FTW94LA219Accident · No injuriesLimited investigationFinal reportCameron V-77 · Littleton, COA total failure of the balloon's heater system (pilot light) for undetermined reasons. A factor was unsuitable terrain on which to make a forced landing.NTSB NYC94FA106Accident · No injuriesField investigationFinal reportSikorsky S-76B · Newport, RIthe failure of the left hand helical gear in the main gear box (MGB), due to undertorqued attaching bolts installed by the manufacturer, which resulted in a partial MGB failure. This failure resulted in the loss of the number one engine, illumination of the…NTSB CHI94FA212Accident · 3 fatalField investigationFinal reportBeech A35 · Lakeville, MNThe jamming of the elevator control which resulted in the pilot's inability to control the pitch attitude of the airplane. The airplane encountered a stall-spin and impacted level terrain in an uncontrolled descent.NTSB FTW94LA214Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Coy, ARThe separation of the landing gear due to failure of the landing gear axle bolts.NTSB SEA94LA149Accident · Minor injuriesLimited investigationFinal reportHiller-Soloy UH-12L4 · Clarkston, WADisconnection of the ballast bar aft retaining pin. Factor(s) were: tail rotor blade separation and reduced aircraft control.NTSB BFO94LA099Accident · 2 fatalLimited investigationFinal reportUpton Mustang II · Churchtown, OHThe pilot's performance of a maneuver that exceeded the design stress limits of the airplane.NTSB BFO94LA098Accident · Minor injuriesLimited investigationFinal reportBellah Rotorway Executive · Johnson City, NYThe failure of the tail rotor drive belt due to undetermined reasons. This led to a loss of directional control and an autorotation.NTSB SEA94LA142Accident · 1 fatalLimited investigationFinal report1ST FTR GP FOCKE-WULF 190 · Salt Lake City, UTImproper balancing of the ailerons resulting in aileron flutter.NTSB ATL94LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Flowery Branch, GAThe maintenance personnel's failure to properly secure the throttle linkage assembly that resulted in a reduction in engine power.NTSB LAX94LA236Accident · 1 fatalLimited investigationFinal reportSharp Scorpion TOO · Beckwourth, CAthe failure of the tail rotor 'V' drive belt for undetermined reasons and the subsequent failure and separation of the tail rotor.NTSB LAX94LA227Accident · Minor injuriesLimited investigationFinal reportPerth Amboy Bird BK · San Jose, CAthe separation of the right main landing gear axle from the gear strut for undetermined reasons related to component age.NTSB FTW94LA189Accident · No injuriesLimited investigationFinal reportBeech 35 · Mckinney, TXThe ailerons being locked by a foreign object.NTSB SEA94LA128Accident · Serious injuriesLimited investigationFinal reportBell 204B · Libby, MTThe fatigue fracture of the 42 degree gear box input pinion. Factors include unsuitable, mountainous/hilly terrain.NTSB MIA94LA154Accident · No injuriesLimited investigationFinal reportPitts S2B · Keystone Height, FLThe pilot-in-command's exceeding of the design limitations of the airplane.NTSB CHI94LA175Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Toulon, ILthe improper reassembly of the main rotor blade dampers and the underservicing of the landing gear skid hydraulic struts which resulted in ground resonance of the helicopter when the first takeoff after reassembly was attempted.NTSB FTW94FA176Accident · 1 fatalField investigationFinal reportPraker Thorp T18C · Phoenix, AZThe pilot's inability to prevent an inadvertent stall and his inability to recover due to a restriction in the movement of the stabilator for undetermined reasons. A factor was the failure of the owner/builder and the pilot to accomplish a control rigging…NTSB NYC94LA091Accident · No injuriesLimited investigationFinal reportCessna 305A · Franklin, VAThe loss of airplane directional control during landing as a result of a tire failure, and the subsequent collision with soft terrain.NTSB MIA94LA149Accident · Serious injuriesLimited investigationFinal reportBeech 65 · Pensacola, FLImproper installation of nuts on the nosewheel (split rim) through-bolts by unknown personnel, which resulted in a subsequent failure (separation of the wheel halves).NTSB LAX94LA223Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Torrance, CAa fatigue failure of the carburetor fuel inlet fitting. A fuel flow system modification and an inadequate annual inspection were factors in the accident.NTSB SEA94LA125Accident · Serious injuriesLimited investigationFinal reportKelly Long EZ · Lindon, UTPiston failure and unsuitable terrain for a successful forced landing.NTSB SEA94FA121Accident · 4 fatalField investigationFinal reportAero Commander 500A · Livermore, CAA fuel system leak, inadequate preflight by the pilot (PIC), and by the non-flying pilot/passenger intentionally allowing operation of the aircraft with a known deficiency (fuel leak). A factor related to the accident was: the lack of suitable terrain for a…NTSB MIA94LA144Accident · Minor injuriesLimited investigationFinal reportBell 206B · St. Petersburg, FLThe failure of the number five bearing, shaft, or thomas coupling for undetermined reasons. Contributing to the accident was the pilot-in-command's delayed response in conducting the emergency procedure by not reducing the throttle to idle position, and…NTSB MIA94LA140Accident · Minor injuriesLimited investigationFinal reportLuscombe 8E · Deland, FLCorrosion and subsequent failure of the left main landing gear strut.NTSB FTW94IA154Incident · No injuriesIncident investigationFinal reportSaab-Scania SF-34OB · Texarkana, ARThe pilot's inability to retard the power levers during a rejected takeoff due to his failure to perform the emergency procedures in accordance with the aircraft operating manual. A factor was the illumination of the configuration light as result of…NTSB LAX94IA206Incident · Minor injuriesIncident investigationFinal reportBoeing 737-209 · Honolulu, HIThe failure of the battery transfer relay resulting in multiple system failures.NTSB FTW94IA139Incident · No injuriesIncident investigationFinal reportBeech 1900C · Cheyenne, WYA partial failure of the leading edge tip portion of one of the left engine propeller blades due to previous impact damage from an unknown source.NTSB SEA94FA106Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Kellogg, IDFailure of the pilot to maintain aircraft control, due to spatial disorientation, while flying with partial panel, and the design stress limits of the aircraft being exceeded. Factors related to the accident were: failure of the vacuum system, which resulted…NTSB CHI94FA140Accident · 1 fatalField investigationFinal reportVavra, Martin A. Rebel 300 · Wonderlake, ILFatigue and catastrophic failure of the main wing spar resulting from the designer's excessive, unverified estimate of the strength of the spar cap material and the manufacturer's failure to attain the specified strength during the production process.NTSB MIA94FA125Accident · 2 fatalField investigationFinal reportBell 47D1 · Marathon, FLSeparation of the tail rotor gearbox and tail rotor blades for an undetermined reason. Factors related to the accident were: failure of maintenance personnel to follow the proper maintenance procedure after a previous tail rotor strike, and failure to conduct…NTSB SEA94IA103Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-83 · Seattle, WAThe fatigue fracture of a main gear wheel hub.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 LAX94LA177Accident · 2 fatalLimited investigationFinal reportGardner E-RACER Mark II · Parker, AZthe failure of the pilot to maintain control of the aircraft while maneuvering in the traffic pattern following a failure of the throttle control. A factor in the accident was a throttle linkage separation after takeoff.NTSB MIA94IA110Incident · No injuriesIncident investigationFinal reportBoeing 727-243 · Orlando, FLThe total failure of the left main landing gear door actuator fitting due to fatigue cracking in the fitting. Contributing to the accident was inadequate written inspection procedures by the aircraft manufacturer.NTSB SEA94LA092Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Levan, UTThe left main landing gear wheel bearing broke resulting in the wheel jamming and the airplane nosing over.