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 DEN90LA086Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Morgan, UTSeparation of the tow rope and the pilot's failure to establish an appropriate descent rate as he returned to land. Contributing to the accident were the tailwind and the unsuitable terrain for landing beyond the runway end.NTSB FTW90DRD04Accident · No injuriesFinal reportGrumman G-164B · Fenton, LAFailure of the elevator control rod end bearing.NTSB LAX90LA132Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B · Saipan (Pacific Ocean)The partial failure of a rotor system component for undetermined reasons.NTSB ATL90FA089Accident · 1 fatalField investigationFinal reportHiller UH-12D · Soddy-Daisy, TNFatigue induced failure of the collective pitch push rod (adjustable) during flight, and the failure of the pilot to provide routine maintenance. The pilot's lack of expereince and his failure to obtain required training and certification were factors in the…NTSB ATL90LA088Accident · No injuriesLimited investigationFinal reportMooney M20F · Murfreesboro, TNFatigue failure of the propeller blade which resulted in a forced off-airport landing.NTSB FTW90IA086Incident · No injuriesIncident investigationFinal reportBritish Aerospace HS125-800 · Atlanta, GAThe leaking aft lavatory water heater unit.NTSB FTW90DPJ03Accident · Minor injuriesFinal reportPiper PA36-400 · Temple, OKFailure of an aileron attachment (bolt) due to fatigue.NTSB FTW90IA085Incident · No injuriesIncident investigationFinal reportCessna Citation SII · Dallas, TXImproper installation of the air conditioning unit, which resulted in an electrical short which caused separation of an elevator control cable.NTSB MKC90LA069Accident · No injuriesLimited investigationFinal reportCessna 175 · Derby, KSFailure of the nose gear yoke.NTSB ATL90LA080Accident · Serious injuriesLimited investigationFinal reportLearjet 24 · Anderson, SCElectrical arcing which resulted from a short in the pilot's map light circuit; a chafted wire contacted the oxygen supply line at the oxygen control panel in the cockpit. A factor in the accident was the inadequate design of the oxygen panel plumbing and…NTSB ATL90IA076Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Atlanta, GAInadequate servicing of the airplane by operator maintenance personnel which resulted in the burst tire. Factors in the accident were hydraulic system lines which were fractured by debris from the burst tire and a total failure of the airplane hydraulic…NTSB ATL90LA078Accident · No injuriesLimited investigationFinal reportNorth American T-6 G · Albany, GAA locked brake which prevented the pilot from maintaining directional control during the landing roll. The brake material expanded after becoming water soaked while taxiing.NTSB DEN90LA071Accident · No injuriesLimited investigationFinal reportCessna 402B · Alamogordo, NMThe collapse of the right main landing gear as a result of the malfunction of the down lock assembly and failure of the torque tube bracket assembly.NTSB MIA90LA083Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Rolling Fork, MSThe in-flight separation of the left aileron due to improper maintenance procedures and an inadequate aircraft preflight.NTSB ANC90LA037Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKImproper installation of the gear axle (use of improper bolts & the wrong number of shims), which resulted in a subsequent failure and loss of control during the landing roll.NTSB ANC90LA036Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nome, AKThe failure of the left gear axle due to corrosion and fatigue.NTSB DEN90LA065Accident · No injuriesLimited investigationFinal reportCessna P206A · Logan, UTThe pilot flew the aircraft with an improper modification to the fuel system, which resulted in a fuel leak and subsequent fire.NTSB LAX90IA101Incident · Minor injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Los Angeles, CAThe failure of the weld holding the slip joint to the pneumatic dual compensator from the no. 2 engine.NTSB BFO90IA028Incident · No injuriesIncident investigationFinal reportBoeing B-727-29 · Washington, DCThe accident was fatigue failure of the right main landing gear support link shaft because of overtorque.NTSB SEA90IA042Incident · No injuriesIncident investigationFinal reportBoeing 747-446B · Everett, WAA break from pre-existing intergranular cracks which led to a fracture.NTSB FTW90DRD02Accident · No injuriesFinal reportC&J Sontheimer Rotorway · Lake Charles, LAFailure of the tail rotor drive belt.NTSB LAX90FA083Accident · 1 fatalField investigationFinal reportCessna 152 · Phoenix, AZDesign stress limits exceeded.NTSB DEN90LA054Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Provo, UTImproper installation by maintenance personnel and fatigue failure and leakage of the left intermediate exhaust pipe, which resulted in an in-flight fire in the engine compartment. Contributing factors were: inadequate service bulletin provided by the…NTSB ATL90IA060Incident · Minor injuriesIncident investigationFinal reportDouglas DC-9-31 · Louisville, KYThe disabling of the main landing gear torque link which allowed the truck to rotate freely. The torque link was disabled when excessive vibration was generated by excessive play of the torque link pins in their bushings.NTSB CHI90LA074Accident · No injuriesLimited investigationFinal reportMBB BK-117A-1 · Janesville, WIThe pilot-in-command failed to ensure that the engine cowling latches were properly secured prior to departing on the maintenance test flight; the cowling came loose during flight, and contacted the main rotor blades before it separated from the helicopter.NTSB MIA90LA063Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Orlando, FLThe pilot misjudged clearance between his aircraft and a parked aircraft, while turning on the taxiway. Factors related to the accident were: darkness and pilot fatigue.NTSB ATL90LA058Accident · No injuriesLimited investigationFinal reportBeech C24R · Greer, SCThe pilot in command's improper flare which resulted in a hard landing.NTSB CHI90DET03Accident · 1 fatalFinal reportPterodactyl Ascender II+2 · Lake Village, INIn-flight structural failure of the right wing spar.NTSB CHI90IA070Incident · No injuriesIncident investigationFinal reportBoeing B737-300 · Cedar Rapids, IAThe failure of all four main landing gear tires on takeoff due to the parking brake being locked.NTSB MIA90LA053Accident · No injuriesLimited investigationFinal reportBeech E185 · Wauchula, FLLoss of air pressure in the left main tire during flight, which resulted in a ground swerve during the landing and a nose over as the pilot was correcting with opposite brake and rudder.NTSB FTW90LA056Accident · No injuriesLimited investigationFinal reportCessna 170 · Crockett, TXThe failure of the main landing gear axle due to fatigue which led to a loss of control after touchdown.NTSB NYC90LA049Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Messena, NYThe airplane striking a light pole during an off airport landing on a road, due to a double power loss for unknown reasons. Factors related to the accident were: the pilots unfamiliarity with the airplane.NTSB MIA90FA049Accident · 1 fatalField investigationFinal reportLockheed L1329 · Miami, FLThe pilot's improper decision to reject the takeoff after the airplane had passed V1 speed and lifted off the runway. A factor was a malfunctioning #2 engine electronic engine conttrol which caused the unit to over-schedule fuel to the engine resulting in…NTSB MIA90IA047Incident · No injuriesIncident investigationFinal reportBoeing 727-251 · Madison, FLThe failure of company service personnel to properly service the airplane forward lavatory.NTSB BFO90FA017Accident · Serious injuriesField investigationFinal reportDouglas DC-10 · Baltimore, MDInjuries associated with the evacuation of the aircraft.NTSB FTW90LA044Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350B · Grand Prairie, TXManufacturer's failure to property install the left side components of the dual control system following its removal for additional completion work prior to delivery of the aircraft. Contributing to the accident was the failure of quality control personnel to…NTSB NYC90FA040Accident · 1 fatalField investigationFinal reportPiper PA-60-602P · Frenchtown, NJThe inadequate maintenance and inspection of the turbocharger tailpipe exhaust stack on the right engine by the mechanic(s). The failure of the tailpipe permitted heat from the exhaust to weaken the main spar of the right wing resulting in a catastrophic…NTSB SEA90FA030Accident · 1 fatalField investigationFinal reportCrawford-Gordon Thorp T-18 · Austin, NVAn improper major alteration performed by the pilot. As a result of this modification, the propeller failed in flight.NTSB MKC90LA039Accident · No injuriesLimited investigationFinal reportBeech 80 · Cape Girardeau, MOAn inoperative landing gear extension system due to failure of an electric motor and a misplaced emergency crank handle.NTSB LAX90DJA02Accident · Minor injuriesFinal reportBryce Duster BJ-1B · Haleiwa, Oahu, HIThe separation in flight of the vertical wood fin from the main structure. It was not determined if the separation was due to overload forces or fatigue.NTSB ANC90LA019Accident · No injuriesLimited investigationFinal reportMaule M-5 · Becky Lake, AKFatigue failure of the ski attach fitting due to being fabricated locally from the wrong steel which resulted in the airplane nosing over.NTSB CHI90DEP02Accident · Serious injuriesFinal reportRotec Panther 2+ · Holmen, WIInadvertent partial deployment of the emergency ballistic recovery parachute resulting in a loss of engine thrust and aerodynamic control of the aircraft.NTSB SEA90LA023Accident · No injuriesLimited investigationFinal reportHughes 369D · Stayton, ORThe maintenance personnel failed to record the previous flight time for the overrunning clutch on airworthiness certification documents when the assembly was overhauled. Also, causal to the accident was the operation of the aircraft by the operator for 175…NTSB FTW90FA031Accident · 3 fatalField investigationFinal reportCessna 210E · Matagorda 526The separation of the propeller system for unknown reasons. Contributing to the severity of the injuries was the pilot's failure to assure that a raft and/or lifevests were on the airplane during the overwater portion of the flight.NTSB CHI90LA032Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Howell, MIFailure of the mixture control cable, which resulted in a loss of power due to fuel starvation during a climb after takeoff. A factor related to the accident was: rough terrain in the emergency landing area.NTSB CHI90LA031Accident · No injuriesLimited investigationFinal reportHelio H-391B · Plainwell, MIFailure of the crosswind landing gear system to engage on the left main gear due to improper rigging adjustment by maintenance personnel. Factors related to the accident were: unfavorable wind conditions (gusts and quartering crosswind) and soft terrain in…NTSB MIA90LA029Accident · No injuriesLimited investigationFinal reportBeech 58 · Fernandina Bch, FLFailure of the pilot to perform the emergency gear extension procedure to assure that the gear was down and locked. Factors related to the accident were: low oil pressure in the right eng, failure of both voltage regulators, and the low level of charge in the…NTSB NYC90FA029Accident · 2 fatalField investigationFinal reportHughes 369HS · North Adams, MAFailure of the pilot-in-command (PIC) to assure proper rotor RPM and proper operation of the flight controls during an approach in gusty wind conditions. A factor related to the accident was: the pic's lack of experience in the type of operation.NTSB MKC90LA027Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Springdale, ARThe banner tow pick up equipment became entangled resulting in a jammed rudder and restricted aircraft control.NTSB FTW90LA025Accident · No injuriesLimited investigationFinal reportBeech 95 · Floydada, TXFailure of the propeller attachment bolts due to fatigue in four of the bolts and overload in another. A contributing factor was the loss of electrical power and the deteriorated airplane control/preformance.