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 CHI91IA297Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Detroit, MIInadequate maintenance inspection of the main landing gear actuator assembly by company maintenance personnel. A factor in the incident is inadequate design of the landing gear actuator by the manufacturer.NTSB NYC91LA240Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Slippery Rock, PAThe on ground collision with a farm vehicle during landing roll out.NTSB CHI91LA300Accident · Serious injuriesLimited investigationFinal reportATR ATR 42-300 · Muskegon, MIThe failure, for reasons unknown, of the number four bearing in the high pressure spool of the engine.NTSB DCA91MA052Accident · 14 fatalClass 1 · MajorFinal reportEmbraer 120 · Eagle Lake, TXThe failure of Continental express maintenance and inspection personnel to adhere to proper maintenance and quality assurance procedures for the airplane's horizontal stabilizer deice boots that led to the sudden in-flight loss of the partially secured left…NTSB NYC91LA232Accident · No injuriesLimited investigationFinal reportPiper PA46-350P · Dayton, OHA malfunction of the elevator trim indicator and incorrect position of the trim tab which resulted in the pilot aborting the takeoff and a loss of directional control on the ground.NTSB NYC91LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Somerville, NJAn off airport landing in unsuitable terrain following a power loss due to oil exhaustion. A factor related to the accident was the operators decision not to follow the recommendations of the Piper cherokee service manual.NTSB FTW91FA155Accident · 1 fatalField investigationFinal reportBell 412 · Garden BanksOverheating and subsequent failure of the number one tail rotor hanger bearing for an undeterined reason, and failure of the tail rotor drive shaft.NTSB LAX91LA369Accident · No injuriesLimited investigationFinal reportHiller UH12D · Sparks, NVThe encounter with rough, unsuitable terrain during a precautionary landing. Contributing to the accident was the pilot's decision to make an autorotation after encountering an airframe vibration.NTSB NYC91LA219Accident · Serious injuriesLimited investigationFinal reportMooney M20F · Meadville, PAEngine failure resulting from the fatigue failure of the number 2 cylinder exhaust valve and the subsequent forced landing at night. A factor related to the accident was the restricted visibility.NTSB LAX91LA375Accident · Serious injuriesLimited investigationFinal reportBeierle Thunder Gull J · Santa Margarita, CAThe failure of the wing spar when the design limits of the airplane was exceeded by the pilot. Contributing to the accident was an inadequate airframe design and an abrupt movement of the flight controls by the pilot.NTSB CHI91LA263Accident · No injuriesLimited investigationFinal reportBeech 36 · Davenport, IAThe inadequate visual lookout and poor inflight planning and decision making by the pilot of N97867. Factors in the accident are inoperative exterior lights and radio communication not possible.NTSB CHI91MA260Accident · No injuriesMajor investigationFinal reportBritish Aerospace 3201 · St Louis, MOFailure of the pilot(s) to follow the correct emergency procedure. Factors related to this accident were: inadequate system design by the manufacturer, which allowed hydraulic line vibration, fatigue failure of the line, and loss of fluid from the normal…NTSB CHI91LA257Accident · No injuriesLimited investigationFinal reportBell 47G · Lake Ozark, MOFailure of the rotorcraft's tail boom in flight. Factors related to the accident were reduced aircraft control available to the pilot.NTSB FTW91IA143Incident · No injuriesIncident investigationFinal reportBell 412 · Rowan MidlandThe mechanic's failure to assemble the tail rotor drive shaft correctly and the subsequent failure of the tail rotor drive shaft. A factor was the lack of inspection procedures for offshore maintenance.NTSB LAX91LA340Accident · 2 fatalLimited investigationFinal reportChampion 7GCBC · Lake Elsinore, CAThe in-flight failure of the right elevator. Factors relating to this accident was the pilot's decision to perform aerobatics at an improper altitude.NTSB FTW91DRD07Accident · No injuriesFinal reportGrumman G-164B · Donaldsonville, LAThe mechanical failure of the propeller blade pitch positioning bolt. A factor was the lack of suitable terrain available for the forced landing.NTSB ATL91LA144Accident · No injuriesLimited investigationFinal reportBeech C24R · Morrisville, NCFailure of the left main landing gear uplock cylinder which precluded extension of the landing gear.NTSB LAX91LA328Accident · No injuriesLimited investigationFinal reportBeech 76 · Sacramento, CAA fatigue failure of the landing gear strut due to an inadequate design by the manufacturer. Contributing to the accident was maintenance personnel not having completed an inspection of the gear strut, in accordance with the manufacturer's service bulletin.NTSB LAX91FA324Accident · 3 fatalField investigationFinal reportBeech 95-C55 · Granada Hills, CAA loss of directional control following an undetermined autopilot failure, during which the pilot failed to perform the emergency procedure to correct a mis-trim condition. Contributing to the accident was a perceived elevator control problem; the inability…NTSB CHI91IA223Incident · No injuriesIncident investigationFinal reportBeech B200 · Greenbay, WIInadequate airframe design, which resulted in the in-flight separation of the left engine's outboard aft upper cowl door.NTSB DEN91LA102Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Albuquerque, NMThe failure of the right main landing gear tire.NTSB FTW91FA123Accident · 1 fatalField investigationFinal reportHughes 269B · Brickeys, ARThe failure of the clutch control cable due to fraying which initiated the forced landing and the operator's failure to perform recommended inspections on the aircraft. Factors were the pilot's failure to maintain rotor RPM and the unsuitable terrain.NTSB ATL91IA134Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Savannah, GAThe inadequate inspection procedures which allowed the loss of torque on the top retraction fitting attachment bolt which subsequently failed in fatigue. Factors were the loss of hydraulic fluid through a severed line, and the corrosion of a hydraulic…NTSB CHI91LA218Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Flint, MIPropeller pitch change mechanism sheared. Factors related to the accident were powerplant vibration and proper touchdown point not possible.NTSB LAX91IA308Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Los Angeles, CAThe failure of the number 2 engine's fire detection system, systron donner fire detector.NTSB CHI91LA217Accident · No injuriesLimited investigationFinal reportPiper PA22/20 · Stevens Point, WIThe improper installation of the flight control system rudder control rod (rudder cable bellcrank torque tube) by maintenance personnel. A factor contributing to this accident was the inoperative tailwheel steering.NTSB DEN91LA099Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Watkins, COA blown tire and both pilots' failure to maintain directional control.NTSB DEN91FA098Accident · No injuriesField investigationFinal reportBoeing 707-323C · Denver, COImproper overhaul of the nose gear assembly by other maintenance personnel.NTSB LAX91LA300Accident · No injuriesLimited investigationFinal reportCessna 320 · Reno, NVThe fatigue failure of the propeller feathering counter weight clamp assembly.NTSB MIA91LA182Accident · Minor injuriesLimited investigationFinal reportAerotek PITTS-S2A · Eustis, FLThe loss of elevator control in flight due to a screwdriver jamming the elevator control for unknown causes.NTSB CHI91LA215Accident · No injuriesLimited investigationFinal reportCessna 182A · Menomonee Falls, WIThe fatigue induced propeller blade failure. A related factor was the operator's delayed propeller overhaul.NTSB NYC91IA165Incident · No injuriesIncident investigationFinal reportBoeing 727-254 · Buffalo, NYChaffing fire detector loop on the number one engine.NTSB DEN91LA095Accident · No injuriesLimited investigationFinal reportBell 412 · Grand Junction, COThe pilot's failure to maintain adequate main rotor RPM prior to touchdown. Factors were: the disconnected engine to transmission drive shaft and the inadequate inspection by company maintenance personnel.NTSB CHI91DER10Accident · Serious injuriesFinal reportKolb Twinstar MK II · Staples, MNThe disconnected elevator trim cable. Related factors are the inadequate maintenance/installation, and the pilot's inability to maintain aircraft control.NTSB FTW91LA113Accident · No injuriesLimited investigationFinal reportCessna A188B · Lewisville, ARThe failure of the right brake line during a critical phase of operation.NTSB DEN91LA092Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Albuquerque, NMThe pilot's improper maintenance of the aircraft. Factors were: a loose oil filter and loss of engine oil.NTSB CHI91DEC02Accident · 2 fatalFinal reportHoward Tierra II · Cambridge Jct, MIEntanglement of the emergency ballistic parachute with the airplane's propeller shaft after it deployed for an undetermined reason. A factor related to the accident was: the aircraft's weight and balance limit was exceeded by the pilot.NTSB CHI91DCD01Accident · 1 fatalFinal reportHeal SONERAI-I · Davenport, IAFailure of the wing spar straps, as the aircraft was being maneuvered around a pylon in an air race.NTSB CHI91DEP09Accident · 1 fatalFinal reportBowers Flybaby 1A · Stoughton, WIThe inadequate design by the manufacturer to provide for adequate protection from moisture accumulation in the form of drain holes. Contributing factors were the deterioration (wood rot) of the wing spar attach and the lack of inspection access.NTSB CHI91DEP08Accident · 1 fatalFinal reportJack Thomas Pitts S-IT · Kenosha, WIImproper maintenance, by person or persons unknown, to the elevator control system which allowed a bolt attaching the elevator control rod to the pitch bellcrank to become disconnected during flight.NTSB DEN91LA082Accident · No injuriesLimited investigationFinal reportBoeing DHC-6-300 · Denver, COThe pilot's failure to perform an adequate preflight, I.e., not following the check list and the normal brake system was inoperative as a result of no hydraulic system pressure (hydraulic system circuit breaker not 'in').NTSB FTW91LA094Accident · No injuriesLimited investigationFinal reportPitts S1C · Houston, TXThe failure of the propeller due to improper installation.NTSB CHI91LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grass Lake, MIA ruptured oil cooler line. A factor associated with the accident was the lack of suitable terrain for the precautionary landing.NTSB CHI91LA182Accident · No injuriesLimited investigationFinal reportCessna 310L · Fort Wayne, INThe improper installation of a bearing by maintenance personnel.NTSB DEN91FA079Accident · 2 fatalField investigationFinal reportCessna 210M · Colorado City, TXThe pilot continuing flight into known adverse weather conditions and exceeding the design stress limits of the aircraft. Factors were: thunderstorm, updrafts and the pilot's disregard of the weather briefing.NTSB NYC91LA153Accident · No injuriesLimited investigationFinal reportCessna 310R · Westerly, RIImproper installation of the right propeller which resulted in thread failure in the propeller hub and separation of the propeller in flight. A factor related to the accident was the right propeller striking the right main landing gear causing its separation…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 DEN91IA076Incident · No injuriesIncident investigationFinal reportAero Commander 690C · Denver, COFatigue failure of flap cable.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 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.