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 MIA96FA168Accident · 2 fatalField investigationFinal reportHiller FH-1100 · Webster, FLinadequate compliance with AD 77-07-08 (and SB FH1100-55-2A) by other maintenance personnel, and subsequent fatigue failure of plates in the tail rotor torsion tension bar. Factors related to the accident were: manufacturing discontinuities…NTSB FTW96LA284Accident · No injuriesLimited investigationFinal reportBeech B35 · Portales, NMfailure by maintenance personnel to perform proper maintenance on the aircraft during an annual inspection, and failure to comply with an airworthiness directive.NTSB LAX96LA248Accident · Minor injuriesLimited investigationFinal reportCessna 150H · San Carlos, CAThe failure of the flaps to retract due to the installation of an incorrect fuse and the inadequate maintenance/inspections performed on the system; and the pilot-in-command's failure to maintain an adequate airspeed while maneuvering for a forced landing,…NTSB CHI96LA217Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ness City, KSthe failure of a counterweight bolt in the propeller for reasons undetermined. Factors were the wet landing area and the encounter with unsuitable terrain during the forced landing.NTSB NYC96IA131Incident · No injuriesIncident investigationFinal reportBoeing 767-332ER · Jamaica, NYthe improper installation of the generator feed cable by the manufacturer, which resulted in a severed aileron cable due to arcing between the generator feed cable and aileron cable.NTSB FTW96LA276Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · El Paso, TXloss of directional control due to the failure of the tailwheel lock. A factor was the crosswind.NTSB CHI96LA235Accident · No injuriesLimited investigationFinal reportBeech B35 · Chesterfield, MOimproperly balanced ruddervators and improperly installed ruddervator (elevator) trim tabs, due to improper maintenance, which resulted in ruddervator flutter and substantial damage in the area of the aft fuselage. Factors relating to the accident were:…NTSB MIA96FA162Accident · No injuriesField investigationFinal reportEmbraer 120 · Orlando, FLthe aircraft manufacture's inadequate written procedures in the airplane flight manual/quick reference handbook, which resulted in a failure of the landing gear to extend and a wheels up emergency landing, due to hydraulic blockage in the landing gear…NTSB FTW96FA268Accident · 1 fatalField investigationFinal reportJones Peckerwood 1A1 · La Porte, TXimproper installation and subsequent failure of the elevator control cable clamps which led to the pilot's restricted pitch control and resultant stall/spin.NTSB FTW96FA265Accident · 4 fatalField investigationFinal reportMbb BO-105 · Sabine Pass, TXThe failure of the sun gear within the main transmission resulting in the main rotor system not being driven.NTSB SEA96IA131Incident · No injuriesIncident investigationFinal reportBoeing 767-332 · Salt Lake City, UTfailure of maintenance personnel to properly disconnect (disengage) the right integrated drive generator (IDG) in compliance with the MEL dispatch procedure, which allowed the right IDG to overheat. Factors relating to the incident were: low oil pressure in…NTSB CHI96LA208Accident · No injuriesLimited investigationFinal reportAerotechnik L-13 · Wichita, KSthe pilot's inadequate in-flight planning. Factors were the insufficient altitude and the dead battery.NTSB SEA96LA126Accident · No injuriesLimited investigationFinal reportPrice Berkut · Jackson, WYfailure of the electrically driven hydraulic pump; and the absence of the main landing gear over-center downlock springs, which were not installed by the previous owner/builder.NTSB IAD96IA098Incident · No injuriesIncident investigationFinal reportBoeing 747-136 · Jamaica, NYfailure of the constant speed drive (CSD) to disconnect from the generator. Contributing to the cause was the failure of the FAA approved overhaul facility to follow the manufacturer's overhaul manual.NTSB LAX96LA232Accident · Minor injuriesLimited investigationFinal reportMoore Goshawk 350 · Livermore, CAan overstress failure of the left rudder cable.NTSB FTW96LA252Accident · No injuriesLimited investigationFinal reportHarmon RV-3 Rocket · Houston, TXThe improper installation of the fuel line with insufficient clearance from the exhaust system, resulting in a hole being burned into the fuel line.NTSB CHI96IA207Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-320 · Boston, MAan undetermined intermittent fault in the trimmable horizontal stabilizer actuator system.NTSB DCA96IA061Incident · No injuriesIncident investigationFinal reportBoeing B-737-201 · Richmond, VAThe yaw/roll upset of the airplane resulting from the movement of the rudder surface to its blowdown limit. The rudder surface most likely deflected in a direction opposite to that commanded by the pilots as a result of a jam of the main rudder power control…NTSB CHI96LA192Accident · No injuriesLimited investigationFinal reportCarrison-Seiman Schukert D-1 · Gardner, KSan aileron control malfunction of undetermined origin. A factor was the pilot's inability to control the airplane.NTSB FTW96LA241Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Dumas, TXThe failure of the right main gear torque link during landing roll as a result of its improper assembly by maintenance personnel.NTSB CHI96FA185Accident · 1 fatalField investigationFinal reportCorey Cirrus VK-30 · Lapeer, MIincomplete cure of the bonding material in the cruise flap, improper material in the cruise flap hinge, and improper welding of the cruise flap push rod end caps. Factors were delamination of the cruise flap, partial failure of the cruise flap hinge, and…NTSB MIA96IA146Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · Miami, FLfatigue failure of a segment of the elevator trim cable.NTSB CHI96LA196Accident · No injuriesLimited investigationFinal reportCessna 140 · Potter, NEa fatigue fracture of the landing gear axle.NTSB MIA96LA144Accident · No injuriesLimited investigationFinal reportBell UH1B · West Palm Beach, FLthe failure of the tail rotor drive shaft which resulted in a loss of tail rotor control.NTSB SEA96LA103Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Moscow, IDinflight loss of an unsecured access plug from the engine crankcase, which resulted in a loss of engine oil and a forced landing. Factors relating to the accident were: hilly terrain, and foreign material (engine oil) on the windscreen which limited forward…NTSB SEA96IA104Incident · No injuriesIncident investigationFinal reportDornier 328 · Billings, MTpaint overspray on the elevator trim actuator push rods, which damaged the actuator quad rings during normal operation and allowed water to enter the actuators; and the resultant freezing of the actuators. Factors relating to the incident included the…NTSB NYC96IA116Incident · No injuriesIncident investigationFinal reportBoeing 767-31AER · Boston, MANumerous electrical anomalies as a result of a loose main battery shunt connection and undetermined electrical system causes.NTSB CHI96IA170Incident · No injuriesIncident investigationFinal reportBeech 1900D · Indianapolis, INfailure of a forward cabin ventilation blower motor bearing, which resulted in binding of the blower motor; and inadequate design of the electrical system, which allowed overheating of the electrical circuit and smoke in the cabin of the aircraft.NTSB ANC96FA078Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Point Hope, AKThe pilot's inadequate preflight to ensure the nose baggage door was properly latched, and the subsequent opening of the baggage compartment door, which allowed items to collide with the left propeller, resulting in propeller damage and loss of thrust from…NTSB CHI96FA171Accident · No injuriesField investigationFinal reportCessna 401 · Great Bend, KSthe failure of the exhaust header. Additional factors include the visual restrictions which prevented a detailed examination of the exhaust system, and the inadequate inspection procedures required in AD 75-23-08 R5.NTSB LAX96IA199Incident · No injuriesIncident investigationFinal reportBoeing 747-273C · Los Angeles, CAthe operator's failure to adopt a manufacturer's stipulated ultrasonic inspection procedure, which led to the in-flight separation of the wing panel.NTSB FTW96LA207Accident · Minor injuriesLimited investigationFinal reportBowers Midget Mustang M-1 · Mesquite, TXThe pilot's failure to maintain aircraft control following the separation of the propeller spinner installed by the pilot. A factor was the pilot's failure to obtain the required FAA inspection for the installation.NTSB IAD96LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-600 · Syracuse, NYthe pilot's failure to ensure that his hand would remain clear of the propeller, while attempting to take remedial action to secure the clam shell door. The unlatching and separation of the clam shell door from the aircraft were related factors.NTSB NYC96LA099Accident · No injuriesLimited investigationFinal reportElves Rotorway Exec 90 · Somerset, PAthe kit manufacturer's inadequate design of a throttle bushing, which resulted in insufficient clearance after the bushing became heated, restricted throttle movement, lack of engine response, hard landing, gear (skid) collapse, and rollover.NTSB MIA96LA136Accident · No injuriesLimited investigationFinal reportBeech UC45J · Opa Locka, FLinadequate inspection of the fuel line connector by company maintenance personnel, and failure of a connector resulting in a fuel leak and fire.NTSB FTW96TA195Accident · No injuriesFinal reportRockwell NA-265-80 · Albuquerque, NMoverdeflection of the left outboard main landing gear tire, probably due to underinflation and inadequate inspection, which resulted in fatigue failure of the left outboard tire and subsequent failure of the left inboard tire.NTSB FTW96LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Peyton, COthe failure of the right main tire due to valve stem separation.NTSB LAX96IA184Incident · No injuriesIncident investigationFinal reportBoeing 737-300-3H4 · Ontario, CAThe repair facility's improper assembly of the landing gear oleo strut during overhaul.NTSB MIA96FA130Accident · 1 fatalField investigationFinal reportHelio H-295 · Gaffney, SCfailure of the pilot to remove the control lock during the preflight, and his failure to check the flight controls before taking off.NTSB LAX96FA169Accident · 2 fatalField investigationFinal reportCameron A-210 · Cave Creek, AZthe pilot's failure to follow the flight manual procedure by not turning off the burner's pilot shutoff valves. Factors relating to the accident were: the installation of improper (unapproved wooden) upright rods by company maintenance personnel, subsequent…NTSB IAD96FA061Accident · 1 fatalField investigationFinal reportCessna P206C · Hartwood, VAthe inadvertent/premature deployment of the first skydiver's parachute, which resulted in contact with the airplane's horizontal stabilizer by the first skydiver and his parachute, loss of integrity of the empennage to the aft fuselage, loss of aircraft…NTSB MIA96IA114Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2G-30 · Columbia, SCfailure of the nose landing gear bearing due to improper assembly and staking (inadequate quality control) by the manufacturer; which prevented the nose gear from retracting and the main gear from extending, and resulted in a subsequent landing on the nose…NTSB MIA96LA113Accident · 2 fatalLimited investigationFinal reportSnowbird 636D4 · Okeechobee, FLthe failure of the main rotor control connecting rod, which rendered the control stick unusable and led to a loss of control.NTSB NYC96GA083Accident · 2 fatalFinal reportBell 206L-1 · Charleston, WVthe helicopter manufacturer's inadequate maintenance service bulletin inspection interval which failed to provide timely detection of preexisting fatigue cracks in the tail boom. Factors were: the manufacturer's failure to develop a modification of the failed…NTSB ATL96LA073Accident · No injuriesLimited investigationFinal reportCanadair CL-600S · Raleigh, NCthe flight crew's inadequate emergency procedure in that they did not manually extend the landing gear, as specified in the airplane flight manual. A factor relating to the accident was: the intermittent operation of the extend solenoid in the nose gear…NTSB SEA96IA074Incident · No injuriesIncident investigationFinal reportDornier DO 328-100 · Eugene, ORdelamination of the wing de-icing boot, due to the boot reaching its life limit.NTSB LAX96LA150Accident · Minor injuriesLimited investigationFinal reportLampert Revolution M500 · San Carlos, CAthe pilot's failure to recognize a drive train disengagement and initiate an autorotation. The inadequate engine-to-transmission drive belt/pulley design, and the pilot's limited training and experience in rotorcraft operations were factors in this accident.NTSB CHI96LA127Accident · No injuriesLimited investigationFinal reportSocata TBM-700 · Eau Claire, WIfatigue fracture and subsequent failure of the gear door hinge bracket.NTSB MIA96IA109Incident · No injuriesIncident investigationFinal reportBeech 1900D · Jacksonville, FLFailure of a blade counterweight clamp retaining screw due to cadmium embrittlement which occurred during the manufacture process. This resulted in the counterweight clamp separating and striking the adjacent blade causing it to separate.NTSB MIA96LA108Accident · No injuriesLimited investigationFinal reportBoeing 737-200 · Jacksonville, FLfailure of the nose gear taxi light support bracket due to in service damage, which resulted in debris being ingested by the engines. Contributing to the accident was the failure of company maintenance personnel to comply with a Grimes Service Bulletin and a…