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 SEA04LA050Accident · 2 fatalLimited investigationFinal reportCessna 170 · Herron, WAThe failure of the left muffler while maneuvering, resulting in a carbon monoxide leak into the cabin rendering the pilot incapacitated, and the subsequent uncontrolled descent and impact with water.NTSB NYC04LA079Accident · Serious injuriesLimited investigationFinal reportGeoffrion Rotorway Exec 162 · Medina, OHA failure of the helicopter's tail rotor drive system for undetermined reasons.NTSB CHI04LA081Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Jackson, MIThe left main tire failed which resulted in the CFI's inability to maintain directional control of the airplane during the landing. A factor associated with the accident was the snow bank which the airplane contacted.NTSB LAX04IA133Incident · No injuriesIncident investigationFinal reportEurocopter AS 350B · Las Vegas, NVthe tail rotor pitch change lever failed in fatigue due to improper installation by company maintenance personnel.NTSB LAX04IA135Incident · No injuriesIncident investigationFinal reportBell 407 · Madera, CAthe failure of the number 6 hangar bearing due to overheating. A factor in the accident was the operator's likely inadequate compliance with service bulletins and airworthiness directives on this issue, along with an inadequate maintenance inspection program…NTSB FTW04IA078Incident · No injuriesIncident investigationFinal reportBeech C90 · Oklahoma City, OKThe failure of the right main landing gear to extend due to an improperly installed attachment bolt by other maintenance personnel.NTSB ANC04IA025Incident · No injuriesIncident investigationFinal reportBoeing 767-300 ER · Miami, FLThe inadequate quality of material in the main landing gear bogie pivot pin, which resulted in a premature fracture of the pin.NTSB NYC04FA223Accident · 1 fatalField investigationFinal reportAero Commander 112 · Vieques, PRThe pilot's inadequate preflight and in-flight planning and decision making which resulted in the airplane entering instrument meteorological conditions. Contributing to the accident was the pilot's lack of instrument experience, a vacuum pump failure, and…NTSB LAX04LA123Accident · Minor injuriesLimited investigationFinal reportBalloon Works Firefly 11 · Phoenix, AZthe failure of the deflation vent line, which resulted in the pilot not being able to control the balloon in the increased wind conditions.NTSB SEA04LA039Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · McCall, IDThe failure of the right rear ski cable and the owner's improper substitution of the right rear ski cable with an unapproved ski cable. A factor was the slushy snow.NTSB ATL04IA073Incident · No injuriesIncident investigationFinal reportCessna 208B · Auburn, ALThe fatigue fracture of the wire rope portion on the rudder control cable assembly due to improper installation and inadequate procedures by the aircraft manufacturer.NTSB ANC04LA020Accident · No injuriesLimited investigationFinal reportCessna 172 · Girdwood, AKThe pilot's delay in aborting the takeoff, which resulted in an overrun and collision with a snowbank. A factor in the accident was an inoperative airspeed indicator.NTSB NYC04LA061Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · College Park, MDThe loss of hydraulic fluid due to chaffing of a brake line by a strut fairing rivet, resulting in the failure of the braking system.NTSB DEN04FA041Accident · No injuriesField investigationFinal reportDassault DA-20 Falcon Jet · Pueblo, COthe pilot's improper in-flight planning/decision to land on the contaminated runway, the stuck thrust reverser solenoid resulting in partial deployment of the right engine thrust reverser, and the pilot's inability to maintain directional control of the…NTSB DCA04IA018Incident · No injuriesIncident investigationFinal reportEmbraer 135 · Bangor, MASevere wear of the internal threads of the rudder interconnection contol rod which led to disengagement.NTSB LAX04LA108Accident · No injuriesLimited investigationFinal reportCessna P210N · Tucson, AZthe failure of the electrical charging system and pilot's failure to verify that the gear was down-and-locked prior to the complete electrical system failure.NTSB LAX04LA094Accident · No injuriesLimited investigationFinal reportCessna 305A · Casa Grande, AZThe failure of a tail wheel steering component (spring), which resulted in a loss of directional control and a ground loop during the landing roll. A contributing factor was the soft terrain adjacent to the runway.NTSB ATL04LA065Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Allendale, SCThe failure of the hydraulic brake system accumulator due to a ruptured diaphragm. A factor was the ditch.NTSB LAX04LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · California City, CAthe pilot's decision to continue taxiing during dark night conditions without an operable taxi/landing light or taxiway lights and his failure to maintain taxiway alignment. Contributing factors to the accident were the dark night light conditions, the failed…NTSB FTW04LA056Accident · No injuriesLimited investigationFinal reportPitts S-1S · Burleson, TXThe separation of the right main gear wheel, during landing, due to the improper maintenance by unknown maintenance personnel on the right main landing gear assembly.NTSB LAX04LA079Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Oxnard, CAthe failure of the pin that secured the right rudder pedal to the brake cylinder arm due to improper installation of the pin. Also causal was the manufacturer's confusing maintenance instructions regarding the installation of the right rudder pedal pin and…NTSB ATL04IA067Incident · No injuriesIncident investigationFinal reportSabreliner NA-265-60 · Birminghham, ALThe lack of lubrication of the right main wheel bearing which resulted in the overheating.NTSB CHI04LA046Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · St. Paul, MNThe failure of the worm drive bearing that resulted in the failure of the landing gear extension/retraction gearbox, which ultimately resulted in the extension of the landing gear not being possible. A factor to the accident was the airport sign that the…NTSB DEN04IA026Incident · No injuriesIncident investigationFinal reportBoeing 737-3M8 · Denver, COThe restricted movement of the flight control yoke and tiller wheel steering for reasons undetermined.NTSB SEA04FA022Accident · 4 fatalField investigationFinal reportBeech S35 · Warren, ORThe vacuum pump failure and the pilot's failure to maintain control of the airplane. Factors contributing to the accident included the instrument meteorological weather conditions and the pilot's improper recovery from the descent.NTSB LAX04TA052Accident · No injuriesFinal reportEurocopter France AS 350 B3 · Yuma, AZThe malfunction of the rotor drive system due to improper maintenance, which resulted in the uncoupling of the drive shaft during takeoff-initial climb. A factor associated with the accident is the undertorqued drive system bolts.NTSB ATL04IA048Incident · No injuriesIncident investigationFinal reportCessna 560XL · Savannah, GAThe malfunction of the nose wheel gear for undetermined reasons.NTSB NYC04LA040Accident · No injuriesLimited investigationFinal reportBeech H-18 · Westminster, MDThe pilot's failure to maintain control of the airplane after a failure of one propeller system. Factors in the accident were the failure to perform maintenance inspection and the failure of a bolt in the left propeller blade system.NTSB SEA04LA019Accident · 1 fatalLimited investigationFinal reportKaman K-600 · Nordman, IDThe total failure of the helicopter's right main rotor shaft while in an ascending hover due to the propagation of a fatigue crack that initiated in a corrosion pit on the surface of a slot in the wall of the subject shaft. Factors include accumulation of…NTSB FTW04FA025Accident · 2 fatalField investigationFinal reportBeech A45 · Montgomery, TXThe non-compliance with applicable Airworthiness Directives which required wing spar inspections, and the continued operation of the aircraft beyond the compliance time extension granted as per the approved alternate means of compliance (AMOC). Also causal…NTSB CHI04LA032Accident · Serious injuriesLimited investigationFinal reportHughes TH-55A · West Lafayette, INThe fractured cluster fitting resulting in a loss of directional control during initial climb and the improper repair of cluster fitting by unknown personnel. The night conditions were a contributing factor.NTSB FTW04IA023Incident · No injuriesIncident investigationFinal reportBell 407 · Eugene Is. 27The loss of engine power due to the failure of the 3rd stage turbine wheel and subsequent catastrophic failure of the turbine assembly.NTSB ANC04LA011Accident · No injuriesLimited investigationFinal reportCessna 402 · Galena, AKWater contamination and freezing of the landing gear actuator that prevented the extension of the right main landing gear, resulting in a gear-up landing. Factors contributing to the accident were freezing temperatures at the accident location, and inadequate…NTSB CHI04FA031Accident · No injuriesField investigationFinal reportCessna 560XL · Wheeling, ILThe flight crew's intentional operation with know deficiencies in the aircraft and their delay in aborting the takeoff when a no-takeoff warning was presented. An additional cause was the crew's failure to comply with flight manual procedures concerning…NTSB ATL04LA035Accident · No injuriesLimited investigationFinal reportCessna 210D · Millington, TNThe malfunction of the main hydraulic landing gear system actuator resulting in an emergency gear up landing.NTSB LAX04LA035Accident · No injuriesLimited investigationFinal reportEurocopter AS350 B3 · Mesa, AZThe pilot's inadvertent activation of the hydraulic test switch, which resulted in a loss of the hydraulic system pressure, and his failure to maintain directional control.NTSB ATL04IA028Incident · No injuriesIncident investigationFinal reportPiper PA-32RT-300T · Fayetteville, NCFlight control elevator attachment turnbuckle corrosion and fracture resulting in the loss of aircraft control in flight.NTSB DEN04IA014Incident · No injuriesIncident investigationFinal reportLearjet 45 · Denver, COthe failure of the airplane's spoiler system when used as speed brakes due to high resistances in the spoilers' actuator coils.NTSB CHI04IA018Incident · No injuriesIncident investigationFinal reportEnstrom F-28C · Lapeer, MIComplete failure of the right anti-torque cable while on final approach for landing. A factor was the diminished tail rotor control resulting from the broken cable.NTSB LAX04LA021Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Mesa, AZthe pilot's failure to maintain an adequate airspeed, which resulted in an inadvertent stall. Also causal, was the pilot's inadequate preflight and failure to secure the right side of the engine cowling prior to departure.NTSB LAX04LA020Accident · No injuriesLimited investigationFinal reportCessna 170 · San Diego, CAthe pilot's inadequate preflight inspection which failed to determine the security of his seat, and his failure to maintain directional control.NTSB ANC04LA004Accident · No injuriesLimited investigationFinal reportCessna 195B · North Pole, AKA fracture of the left brake master cylinder actuator rod, which resulted in failure of the left brake, a loss of directional control and an inadvertent ground loop during landing, and the separation of the left main landing gear strut due to fatigue. Factors…NTSB MIA04LA004Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-319-112 · Tampa, FLAn intermittent fault with the airplane's Brake Steering Control Unit (BSCU) for undetermined reasons, which resulted in a momentary loss of brakes and steering, and a serious injury to a flight attendant during the resultant sudden stop during taxi for…NTSB LAX04TA017Accident · No injuriesFinal reportMD Helicopter 900 · Fredonia, AZthe pilot's in-flight loss of control due to the fatigue fracture and separation of the force limiting control rod (an integral part of the anti-torque system), which resulted in the helicopter's uncommanded yaw/spin and subsequent collision with terrain.NTSB CHI04LA009Accident · No injuriesLimited investigationFinal reportBeech A33 · Grandview, MOSeparation of the fuel selector handle which resulted in fuel exhaustion and the subsequent loss of engine power. A factor was the hay bale that the airplane contacted during the forced landing.NTSB LAX04LA011Accident · No injuriesLimited investigationFinal reportCessna 172RG · Camarillo, CAThe fracture and failure of the left landing gear actuator. Contributing to the accident was the operator's failure to comply with the manufacturer's service bulletin.NTSB DEN04IA012Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Denver, COthe manufacturer's improper installation of the inboard slat drive mechanism's lower left hand anti-torque strut, which resulted in the axial migration of the rod-end bearing, the binding of the anti-torque strut, and the subsequent activation of the slat…NTSB SEA04IA010Incident · No injuriesIncident investigationFinal reportBoeing 747-100 · Lyon, FranceAn undetermined malfunction in an aircraft system while in cruise flight leading to a fire in the engine number four B Loop portion (Card A16) of the fire detection controls cardfile.NTSB FTW04LA001Accident · Serious injuriesLimited investigationFinal reportBratton Experimental Homebuilt Swearingen SX300 · Floresville, TXThe separation of one propeller blade while in cruise flight. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB LAX03LA290Accident · No injuriesLimited investigationFinal reportCessna 172RG · Santa Ana, CAthe failure of the right main landing gear pivot assembly.