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 NYC95LA163Accident · No injuriesLimited investigationFinal reportHelio H-295 · Block Island, RIthe failure of the crosswind castering gear to remain locked on the right main gear during the takeoff roll which resulted in directional control not possible.NTSB LAX95IA229Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Elko, NVin-flight separation of the aileron as a result of inadequate bonding.NTSB SEA95FA128Accident · 2 fatalField investigationFinal reportLuscombe 8A · Hubbard, ORThe failure of the maintenance personnel who rebuilt the aircraft to properly install the wing lower lift strut attachment bolts. Contributing to the accident was the failure of another maintenance person to adequately inspect the aircraft for properly…NTSB SEA95LA126Accident · Serious injuriesLimited investigationFinal reportBell 47G-2 · Zillah, WAThe failure of company maintenance personnel to perform adequate inspections of the helicopter, and the failure of the cyclic control rod due to corrosion.NTSB FTW95LA258Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Kingston, OKA malfunction of the propeller governor due to a loose control cable.NTSB LAX95LA216Accident · No injuriesLimited investigationFinal reportBell 47-G5 · Coalinga, CAclutch slippage for undetermined reasons. A factor in the accident was the helicopter's low above ground altitude, which limited the pilot's time and ability to recover main rotor rpm.NTSB FTW95LA240Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Iowa, LAThe failure of the right brake due to the hydraulic fluid leaking. Factors were proper alignment not possible and the close proximity of the ditch.NTSB BFO95LA063Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Ft Washington, MDA loss of engine power for an undetermined reason(s).NTSB ATL95MA106Accident · Serious injuriesClass 1 · MajorFinal reportDouglas DC-9-32 · Atlanta, GAfailure of Turk Hava Yollari maintenance and inspection personnel to perform a proper inspection of a 7th stage high compressor disc, thus allowing the detectable crack to grow to a length at which the disc ruptured, under normal operating conditions,…NTSB CHI95LA186Accident · No injuriesLimited investigationFinal reportBeech A35 · Jacksonville, ILimproper maintenance and inspection of the airplane's ruddervators.NTSB ATL95LA117Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Columbia, SCThe misalignment of the nose gear centering track and roller assemblies which precluded landing gear extension.NTSB NYC95FA129Accident · 2 fatalField investigationFinal reportCessna T210N · Monkton, VTfailure of the pilot to maintain sufficient altitude or clearance from mountainous terrain. Factors related to the accident were: loss of electrical power for undetermined reason(s), darkness, and the mountainous terrain.NTSB FTW95LA239Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Falfurrias, TXInadvertent installation of an unapproved part (tail rotor gear/drive assembly), that became excessively worn since it did not conform to the manufacturer's specification, resulting in failure of the associated tail rotor bearing (also an unapproved part),…NTSB MIA95LA140Accident · No injuriesLimited investigationFinal reportMoncrief Zodiac 601 · Fernandina Bch, FLThe failure of maintenance personnel to adequately torque the propeller bolts during the last inspection resulting in the bolt failures and the loss of the propeller.NTSB FTW95LA219Accident · Minor injuriesLimited investigationFinal reportHispano Aviacion HB-200 · Fort Worth, TXThe failure of the hydraulic actuator for the right main landing gear. A factor was the false landing gear indications provided by the landing gear indicating system.NTSB FTW95LA216Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Rogers, ARThe failure of the right outboard tire for undetermined reason.NTSB MIA95LA131Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS-350B · Tampa, FLThe failure of the pilot to follow manufacturers procedures after failure of the hydraulic system resulting in loss of control of the helicopter. Contributing to the accident was the failure of maintenance personnel to follow manufacturers procedures for…NTSB FTW95LA212Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Owasso, OKThe failures of the landing gear hydraulic pump and the emergency gear extension system as result of inadequate maintenance by maintenance personnel.NTSB SEA95IA102Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Spokane, WAA shorted electrical wiring on the elevator trim system.NTSB LAX95LA189Accident · Minor injuriesLimited investigationFinal reportRyan Navion · Flagstaff, AZThe owner/pilot improper installation of the propeller by failing to properly connect the pitch change mechanism.NTSB NYC95LA108Accident · No injuriesLimited investigationFinal reportCessna 310J · Ararat, PAThe complete loss of electrical power for undetermined reasons, and the pilot's improper decision to make an off-airport landing.NTSB SEA95LA099Accident · Minor injuriesLimited investigationFinal reportCessna 310K · Sequim, WAFailure of an undetermined aircraft component, which resulted in a severe vibration, and subsequent ditching at sea. A factor relating to the accident was: the pilot's low cruising altitude (over water) of less than 1,000 feet, which limited his ability to…NTSB LAX95LA177Accident · Serious injuriesLimited investigationFinal reportBeech C23 · Red Bluff, CAthe separation of the throttle linkage due to improper installation, and the pilot's misjudgement of the glide path necessary to reach the runway prior to shutting down the engine.NTSB SEA95LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Twisp, WAThe improper installation of a nose landing gear assembly bolt (no cotter key installed) by unknown maintenance personnel. This led to a failure of the nose landing gear steering and subsequent noseover during landing rollout.NTSB CHI95IA342Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Minneapolis, MNinadequate design of the fly-by-wire flight control system which allowed false signals from the sidestick transducer units to generate uncommanded rolls.NTSB ATL95FA092Accident · 2 fatalField investigationFinal reportWittman O&O · Stevenson, ALAileron-wing flutter induced by separation at the trailing edge of an unbonded portion of wing fabric at an aileron wing station. The debonding of the wing fabric was a result of improper installation.NTSB MIA95LA129Accident · No injuriesLimited investigationFinal reportPitts S-2B · Naples, FLThe failure of the tail wheel landing gear system for undetermined reasons. This resulted in an on-ground loss of control on landing rollout, ground loop, and collapse of the right main landing gear.NTSB LAX95TA171Accident · No injuriesFinal reportBell 206-L4 · Thermal, CAThe CFI's failure to follow the flight manual procedures by using full up collective during an autorotation landing.NTSB SEA95LA078Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Walla Walla, WATotal failure of the freewheeling sprag unit. A factor to the accident was: suitable terrain was not available for landing.NTSB FTW95FA177Accident · 1 fatalField investigationFinal reportBeech 60 · Cheyenne, WYThe pilot's failure to maintain aircraft control. Factors were the instrument weather conditons and the excessive workload imposed on the solo pilot attempting to deal with an emergency situation while flying in instrument meteorological conditions.NTSB CHI95LA130Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Winfield, KSThe total failure of the rotor drive system clutch assembly due to excessive wear of the clutch assembly. A factor in this accident was the soft ground in the emergency landing area.NTSB SEA95IA082Incident · No injuriesIncident investigationFinal reportFairchild SA-227 · Pasco, WAImproper installation of the rudder trim actuator rod by company maintenance personnel which resulted in binding and fracture of the rod.NTSB LAX95LA158Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Lakeport, CAthe student's misjudged landing flare and his failure to verify the validity of the low rotor warning. Factors in the accident were the company management's continued use of the helicopter in flight training operations with a known discrepancy in the main…NTSB ATL95FA078Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Covington, TNThe pilot exceeded the design stress limits of the aircraft and subsequent overload failures of the stabilator and wing spars.NTSB CHI95IA119Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Chicago, ILthe inadequacy or deterioration of lubricating grease in the wheel bearing, which led to the total bearing failure and subsequent loss of the wheel. Factors were the insufficiently defined procedures for repacking the bearing, along with an insufficient…NTSB LAX95LA151Accident · Minor injuriesLimited investigationFinal reportAndris KR2 · Turlock, CAthe failure of the propeller attach bolt retaining cotter pin, and the pilot/builder's inadequate preflight inspection of the aircraft prior to the attempted flight.NTSB FTW95IA156Incident · Minor injuriesIncident investigationFinal reportBoeing 727-276 · Dfw Airport, TXThe improper use of the evacuation slide by the flight attendant. A factor was the short in the number 1 engine fire warning system, which motivated the captain to order an evacuation.NTSB CHI95IA116Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Moline, ILthe defective weld and the subsequent in flight failure of the welded plug located in the piston of the roll spoiler actuator. The manufacturer's inadequate design is a related factor.NTSB LAX95LA146Accident · Serious injuriesLimited investigationFinal reportBell 206B · Pacific Ocean (Pacific Ocean)the loss of tail rotor control for undetermined reasons.NTSB LAX95IA142Incident · No injuriesIncident investigationFinal reportBeech 1900C · Los Angeles, CAAn axial shift of the outer bearing roller for an undetermined reason, resulting in erosion and failure of the flap track hinge bracket/bearing assembly. Factors relating to the incident were: the roller bearing and associated bracket assembly within the…NTSB CHI95LA096Accident · No injuriesLimited investigationFinal reportCessna T210N · Rockford, ILA disconnect of the alternator belt, and failure of the pilot to attain a down and locked condition of the gear with the emergency extension system.NTSB NYC95IA065Incident · No injuriesIncident investigationFinal reportFokker F28-4000 · Huntington, WVThe fatigue fracture of the left main landing gear upper torque link.NTSB SEA95LA058Accident · No injuriesLimited investigationFinal reportMooney M20C · Omak, WAThe elevator push rod separation due to fatigue. Factors contributing to the accident were the pilot in command's failure to insure compliance with the airworthiness directive and the frozen push rod bearing.NTSB FTW95IA124Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Austin, TXThe failure of the misrouted rudder control cable due to improper installation during scheduled replacement to comply with an airworthiness directive.NTSB CHI95LA093Accident · No injuriesLimited investigationFinal reportBell 206L · Maryland Hts, MOFatigue failure of two attachment bolts that connected the driveshaft to the geared portion of a driveshaft coupling. Factors relating to the accident were: inadequate maintenance, uneven terrain in the touchdown area for the forced landing, and the…NTSB NYC95LA059Accident · Minor injuriesLimited investigationFinal reportBeech 95 · Millbrook, NYThe pilot's failure to manually extend the landing gear which resulted in the landing gear collapsing. A factor was the intermittent loss of electrical power.NTSB FTW95LA120Accident · No injuriesLimited investigationFinal reportCessna T210M · Montrose, COThe bent landing gear emergency extension assembly and the accumulation of airframe ice which interfered with landing gear activation. A factor was the alternator failure for unknown reasons.NTSB LAX95LA109Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Arvin, CAThe seizure of the transmission due to lack of lubrication from a plugged oil supply line.NTSB SEA95LA051Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58JT · Marblemount, WAFatigue failure of the main rotor driveshaft.NTSB ATL95FA049Accident · 1 fatalField investigationFinal reportCessna 150J · Piedmont, SCThe pilot's inappropriate 'buzzing' that resulted in exceeding the airplane's design stress limits, the failure of the windshield, and the pilot's subsequent loss of control and impact with the ground.