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 FTW96FA151Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · New Orleans, LAThe in-flight loss of a bolt in the elevator control system due to improper installation by unknown person(s), which resulted in a disconnection of the elevator control system that rendered the airplane uncontrollable.NTSB ATL96LA068Accident · No injuriesLimited investigationFinal reportBell 205A-1 · Grove Hill, ALfatigue failure of the vertical fin forward spar in an area that was not accessible to inspection. A factor relating to the accident was: guidance for inspection of the area (where the fatigue occurred) was insufficiently defined by the manufacturer.NTSB CHI96IA109Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Detroit, MIa defective diode in the number two stabilizer actuator that produced an intermittent loss of electrical motor power during transient, closed loop control of the actuator. A factor was the intermittent open circuit in the elevator servo controller…NTSB ATL96LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Flamingo, FLThe student pilot's selection of unsuitable terrain for a precautionary landing. Failure of the #3 exhaust tube was a related factor.NTSB ATL96LA059Accident · No injuriesLimited investigationFinal reportCessna 172K · Asheville, NCfailure of the brake on the right main landing gear as a result of water (ice) in the brake fluid, which resulted in a loss of braking control.NTSB FTW96LA138Accident · No injuriesLimited investigationFinal reportCessna 182A · Walsenburg, COFailure of the pilot to maintain directional control of the airplane after the left main tire went flat during the landing roll. The flat tire was a related factor.NTSB MIA96LA087Accident · Serious injuriesLimited investigationFinal reportMarks Kitfox II · Panama City, FLthe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in an inadvertent ground swerve and subsequent collision with a ditch. Factors relating to the accident were: failure of the…NTSB MIA96IA084Incident · No injuriesIncident investigationFinal reportBoeing 707-323C · Miami, FLfailure of the flight engineer to follow the appropriate emergency procedure to manually extend the nose landing gear. Factors relating to the incident were: fatigue failure of the utility hydraulic system relief valve, which resulted in an inoperative normal…NTSB ATL96LA132Accident · No injuriesLimited investigationFinal reportBeech 35 · Griffin, GAfailure of maintenance personnel to properly balance the ruddervator assemblies after they had been reskinned and painted, which resulted in flutter and subsequent damage to the empennage.NTSB FTW96LA123Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Dallas, TXfailure of the pilot to use a more favorable runway, and his failure to go-around, when he realized the airplane would not touch down at the proper touchdown point. Factors relating to the accident were: the inoperative flap motor, failure of the pilot to…NTSB SEA96LA062Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332 · Portland, ORthe passenger's unsuccessful (improper) evacuation of the aircraft. The malfunctioning APU was a related factor in that it torched and produced smoke, due to a faulty fuel control unit and/or gearbox shutoff valve, thereby prompting an emergency evacuation of…NTSB NYC96LA063Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300B4-605R · Jamaica, NYunsuccessful use of the evacuation slides by passengers during an emergency evacuation of the aircraft. The hydraulic valve failure, subsequent hydraulic leak, and resultant smoke were related factors.NTSB ATL96IA053Incident · No injuriesIncident investigationFinal reportEmbraer 120 · Raleigh, NCThe operator's inadequate progressive inspection program that did not require periodic analysis of airplane hydraulic system fluid; and the failure of the operator to comply with the airplane manufacturer's maintenance manual resulting in contamination of the…NTSB ATL96FA051Accident · 1 fatalField investigationFinal reportSukhoi SU-31 · Immokalee, FLthe manufacturer's improper composite curing process, which resulted in wing spar voids and subsequent failure of the wing during aerobatic flight.NTSB SEA96LA057Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Puyallup, WAthe owner's failure to comply with requirements for annual inspections of the airplane, and the debonding of the right brake lining and subsequent jamming of the lining into the right main wheel.NTSB ATL96LA045Accident · No injuriesLimited investigationFinal reportPiper PA-32-RT-300 · Blountville, TNInadequate maintenance, and subsequent in-flight separation of the cowling, due to worn cowling components.NTSB ATL96FA043Accident · No injuriesField investigationFinal reportDouglas DC-9-32 · Nashville, TNthe failure of the right main landing gear shock strut cylinder due to preexisting fractures. Contributing to the accident was: the failure of the operator to inspect the shock strut cylinder for fractures following a previous failure of the torque links, and…NTSB FTW96LA106Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Belen, NMprevious damage, looseness of the main landing gear, and inadequate maintenance.NTSB FTW96LA095Accident · No injuriesLimited investigationFinal reportSchweizer 269C · San Ygnacio, TXFailure of the rotor drive system clutch assembly (separation of the swedge ball from the end of the clutch control cable), which resulted in disengagement of the rotor drive system, while the helicopter was in lateral movement at low altitude.NTSB MIA96FA059Accident · Minor injuriesClass 1 · FieldFinal reportDouglas DC-9-32 · Nashville, TNthe flight crew's improper procedures and actions (failing to contact system operations/dispatch, failing to use all available aircraft and company manuals, and prematurely resetting the ground control relay circuit breakers) in response to an in-flight…NTSB FTW96LA082Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Durango, COthe failure of the nose wheel steering mechanism which rendered the aircraft uncontrollable on the ground. A factor was the rough and uneven terrain.NTSB CHI96IA066Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Bemidji, MNinadequate maintenance installation and inspection of the elevator flight control system which led to restricted flight control elevator movement due to a loose bolt.NTSB FTW96IA080Incident · No injuriesIncident investigationFinal reportBeech 1900C · Denver, COfailure by the outside contractor to perform adequate maintenance, and failure by the operator to perform an adequate inspection.NTSB MIA96LA043Accident · 2 fatalLimited investigationFinal reportPro Star PRO Tech · Sebring, FLthe pilot-in-command(CFI) allowed the airplane's design limits to be exceeded which resulted in the overload failure and separation of the right wing.NTSB FTW96LA069Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · West Helena, ARBinding of the power lever linkage, due to corrosion, which resulted in a situation that led to an inadvertent shut-down of the engine at a critical point on the approach to land. A factor relating to the accident was: inadequate maintenance.NTSB LAX96IA065Incident · No injuriesIncident investigationFinal reportBeech 99 · Salt Lake City, UTimproper installation of the rudder control cable by company maintenance personnel, which resulted in chafing and/or fatigue and subsequent failure of the cable.NTSB SEA96LA025Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Scotts Mills, ORThe pilot's failure to maintain adequate clearance from the ground.NTSB FTW96LA052Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Fredericksburg, TXthe pilot's failure to maintain directional control. Factors were the binding tailwheel and the pilot's lack of experience in tailwheel airplanes.NTSB CHI96LA041Accident · No injuriesLimited investigationFinal reportMcclung SEA Hawk · Marengo, ILthe failure of the upper right wing due to the presence of unbonded areas between the spar cap and the bidirectional fiberglass. The unbonded areas were due to the inadequate manufacturing of the airplane by the owner/builder. A factor in the accident was the…NTSB FTW96FA046Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Cypress, TXThe pilot's failure to maintain aircraft control while flying in instrument meteorological conditions. Factors were the weather, and the failure of the airplane's vacuum pump which rendered the attitude indicator and the directional gyro inoperative.NTSB BFO96LA026Accident · No injuriesLimited investigationFinal reportCessna 210E · Newport News, VAthe failure of the engine-driven hydraulic pump drive shaft, the pilot's failure to properly engage the emergency landing gear handle.NTSB SEA96LA013Accident · No injuriesLimited investigationFinal reportCessna TR182 · Salt Lake City, UTmaintenance personnel improperly installed a landing gear system hydraulic line and the throttle cable which resulted in chaffing and subsequent loss of hydraulic fluid disabling the landing gear extention systems.NTSB FTW96IA024Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-72-212 · Dfw Airport, TX'O' ring failure in the fuel line to the left engine nozzle assemblies, which resulted in a fuel line leak and a left engine compartment fire.NTSB SEA96FA010Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Alta, WYthe corrosion, consequent fatigue cracking and ultimate separation of the right wing forward lift strut.NTSB NYC96LA014Accident · No injuriesLimited investigationFinal reportCessna 210C · Burlington, VTa fractured hydraulic line and loss of hydraulic fluid, which resulted in an inoperative landing gear extension system for both normal and emergency operation of the gear.NTSB CHI96LA010Accident · No injuriesLimited investigationFinal reportCrowley/Zenair Zodiac CH-600 · Columbia, MOA loss of elevator control as a result of the top elevator control cable working its way out of a fitting.NTSB CHI96LA011Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-31 · Cedar Rapids, IAinadequate installation of a thrust reverser, driver linkage arm pivot bolt and nut, which resulted in the nut and bolt becoming disconnected. A factor relating to the accident was: the manufacturer's unclear information regarding the type and number of…NTSB NYC96LA007Accident · No injuriesLimited investigationFinal reportTeague Pitts S-1S · Erwinna, PAthe pilot's misjudged flare and improper bounced landing recovery. Factors were the pilot's lack of recent experience and a false oil pressure gauge indication.NTSB SEA96LA005Accident · 1 fatalLimited investigationFinal reportChard RV-3A · Forest Grove, ORThe pilot exceeded the design stress limit of the aircraft, followed by the failure of the right wing main spar.NTSB FTW96LA011Accident · No injuriesLimited investigationFinal reportCessna 195A · Taos, NMseparation of the left main gear wheel as a result of improper maintenance.NTSB SEA95LA229Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Roberts, IDan improperly performed major rebuild and inadequate inspection of the aircraft by maintenance personnel. Inadequate preflight inspection by the pilot contributed to the accident.NTSB NYC95LA231Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Staten Island, NYFailure of the propeller blade due to fatigue, which resulted in severe vibration, subsequent separation of the engine, and a forced landing.NTSB MIA95LA236Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Union Church, MSinadequate maintenance lubrication and inspection of the main rotor head which resulted in the separation of a rod end bearing.NTSB SEA95LA226Accident · No injuriesLimited investigationFinal reportCessna 340 · Riverton, WYa partial loss of hydraulic fluid in the left brake system rendering the left brake inoperative.NTSB NYC95LA226Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Auburn, NYthe loss of airplane control as a result of a jammed rudder for undetermined reasons.NTSB MIA95TA230Accident · Serious injuriesFinal reportBell 206B · Culebra, PRthe failure of company maintenance personnel to insure the tail rotor gearbox attach bolts were properly torqued.NTSB SEA95LA227Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E · Yakima, WAFatigue failure of the bolt attaching the scissor arm assembly to the pitch control support assembly. The failure of the bolt led to a loss of collective pitch control and reduced rotor RPM.NTSB FTW95IA397Incident · No injuriesIncident investigationFinal reportMBB BO-105C · Lafayette, LAa short in the 'jam proof system' solenoid valve which prevented activation of the backup hydraulic system and resulting in a cyclic hardover. Factors were the contaminated hydraulic fluid and the resulting jammed actuator (longitudinal control slider).NTSB ANC95LA170Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKFailure of the main landing gear wheel that had been modified for a tundra tire.NTSB FTW95FA394Accident · No injuriesField investigationFinal reportMBB BO-105C · Houston, TXthe failure of the main transmission's #1 (left) input pinion assembly, due to the partially blocked oil passage which reduced oil flow, resulting in the disconnect of the drive shaft.