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 SEA06CA108Accident · Minor injuriesData collectionFinal reportGrumman AA-1B · Bountiful, UTAn obstructed windshield which resulted in the pilot misjudging the distance/altitude during an emergency landing. An oil leak as a result of a leaking crankshaft seal was a factor.NTSB NYC06LA121Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350BA · Goshen, NYImproper maintenance of the hydraulic pump/coupling, which resulted in a failure of the hydraulic flight control system. Factors included the substandard materials of the hydraulic pump drive shaft and coupling, and the pilot's failure to maintain an adequate…NTSB SEA06CA094Accident · No injuriesData collectionFinal reportHarold Vander Avid Flyer · Miles City, MTFailure of the engine to propeller reduction gearbox for undetermined reasons. High vegetation was a factor.NTSB CHI06CA125Accident · No injuriesData collectionFinal reportBangham Barracuda · Monett, MORupture of the hydraulic hose and deformation of the hydraulic cylinder piston rods for undetermined reasons, which resulted in a failure of the landing gear extension system. Contributing factors were the pilot's premature shutdown of the engine on short…NTSB LAX06LA161Accident · Minor injuriesLimited investigationFinal reportBell 206B3 · Fallbrook, CAFailure of the engine to transmission drive shaft forward coupling due to overheating from lack of lubrication. The cause of the lack of lubrication was a result of improper maintenance. A factor was the trees.NTSB CHI06LA124Accident · No injuriesLimited investigationFinal reportHughes 269B · Sullivan, OHFatigue failure of the fuselage-to-tail boom cluster fitting, and the secondary failure of the tail rotor drive shaft. An additional cause was the incomplete compliance with an applicable Airworthiness Directive. A factor was the ditch.NTSB ATL06CA073Accident · No injuriesData collectionFinal reportRobinson R44 Raven II · Rocky Point, NCThe pilot's inadequate visual lookout during a precautionary landing which resulted in an in-flight collision with a transmission wire.NTSB SEA06CA088Accident · Minor injuriesData collectionFinal reportPotts MA-5 · Kalispell, MTSeparation of the left main landing gear during the landing roll for an undetermined reason, which resulted in the airplane nosing down.NTSB DFW06CA111Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Ventus-2C · Midlothian, TXThe inadvertent deployment of the spoilers during the aero tow takeoff for undetermined reasons, resulting in a hard landing.NTSB SEA06CA078Accident · No injuriesData collectionFinal reportCessna 170B · Shelton, WAThe main landing gear wheel failure during the takeoff ground roll. A related factor was directional control of the aircraft was not possible after the wheel failure.NTSB MIA06LA091Accident · Serious injuriesLimited investigationFinal reportCessna 172R · Fort Myers, FLThe flight instructor's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall. Contributing to the accident was a malfunction of the elevator control for an undetermined reason, which required excessive forward pressure on the…NTSB CHI06LA112Accident · No injuriesLimited investigationFinal reportDassault Falcon 2000 · Stilesville, INThe separation of the left engine cowling during cruise flight for undetermined reasons.NTSB CHI06CA111Accident · No injuriesData collectionFinal reportLee SQ 2000 · Berrien Springs, MIFailure of the right main landing gear assembly during landing and the pilot's subsequent inability to maintain directional control of the airplane. Contributing factors were the collapse of the left and right main landing gear and the gusty, crosswind…NTSB DFW06LA097Accident · Serious injuriesLimited investigationFinal reportRocket Flyers Turbine Legend · Hammond, LAThe reported loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN06IA056Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Denver, COthe failure of the elevator down cable due to an improperly routed cable by unknown maintenance personnel. A contributing factor was the improper inspection of the elevator cable by the operator's maintenance personnel.NTSB DFW06LA094Accident · No injuriesLimited investigationFinal reportAviation Specialties Unlimited Challenger II · Coushatta, LAThe loss of control due to premature failure of the elevator's push-pull tube rod-end bearing.NTSB DEN06CA054Accident · No injuriesData collectionFinal reportCessna 170B · Benton, KSthe pilot's failure to maintain directional control of the airplane resulting in a ground loop. Contributing factors include the inadequate preflight inspection, the pilot's failure to properly latch the cowling, and the pilot's diverted attention to the open…NTSB ANC06LA041Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mammoth Lake, CAThe collapse of the right main landing gear during landing, which resulted in a loss of directional control and an on-ground encounter with a snowbank. A factor associated with the accident was other maintenance personnel's inadequate inspection of the…NTSB ANC06LA038Accident · No injuriesLimited investigationFinal reportMD Helicopters MD 900 · Mesa, AZThe manufacturer's inadequate design clearance of the main rotor blade grip pitch cases, which resulted in damage to the pitch cases when they contacted main rotor perimeter bolts during maneuvering flight.NTSB NYC06CA080Accident · Serious injuriesData collectionFinal reportPiper PA23-250 · Morristown, NJThe pilot's premature shutdown of both engines, which resulted in a forced landing short of the runway. A factor was a landing gear malfunction indication for undetermined reasons.NTSB SEA06LA065Accident · Minor injuriesLimited investigationFinal reportKaman K-1200 · Dexter, ORThe pilot's failure to identify the overspeed of the helicopter's main rotors due to a turbine governor malfunction, and his failure to take the appropriate actions described in the Flight Manual's emergency procedures section. Factors include the malfunction…NTSB SEA06CA062Accident · No injuriesData collectionFinal reportPiper PA-18A · Shady Cove, ORThe pilot's improper installation of the control stick during maintenance, which resulted in the control stick becoming disconnected during the initial takeoff climb, resulting in a loss of control and in-flight collision with the ground.NTSB CHI06LA088Accident · No injuriesLimited investigationFinal reportIrwin Sonex 2180 · Rockford, ILThe loss of engine power due to the restricted movement of the throttle cable during cruise flight. A factor in the accident was the trees contacted during the forced landing.NTSB DEN06LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Parker, COthe improper maintenance procedures resulting in the unseating of the number two main bearing. Contributing factors include the mechanic's improper troubleshooting procedures, and the pilot's improper decision to continue operating the airplane with known…NTSB DEN06IA042Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Casper, WYloss of directional control for undetermined reasons. A factor contributing to the incident was the runway maker light.NTSB CHI06LA080Accident · No injuriesLimited investigationFinal reportCessna 421C · Indianapolis, INThe main landing gear malfunctioned and failed to extend during the landing approach for an undetermined reason, which resulted in a main gear up landing.NTSB DEN06LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Greeley, COthe pilot's flight into adverse weather conditions, the airframe ice, and the wheels up landing. Factors contributing to the accident were the icing conditions, the frozen landing gear, the frozen alternate gear extension system, and the runway sign.NTSB DEN06LA039Accident · 1 fatalLimited investigationFinal reportSpane RV-4 · Wichita, KSThe pilot's inadequate preparation prior to takeoff, and his failure to maintain control of the airplane resulting in a stall and subsequent crash. Factors contributing to the accident were the unsecured canopy latch, the pilot's diverted attention, and the…NTSB MIA06LA057Accident · No injuriesLimited investigationFinal reportCessna 525A · Tampa, FLFailure of both the left main and auxiliary brake lines due to fatigue cracking, rendering directional control impossible. A contributing factor in this accident was the airport sign concrete pad.NTSB LAX06LA114Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Rancho Murieta, CAan electrical fault in the nose gear limit switch circuit, which lead to an intermittent failure of the landing gear extension system. Also causal was the pilot's failure to fully complete the emergency gear extension procedure. A factor in the accident was…NTSB LAX06FA113Accident · Serious injuriesField investigationFinal reportCessna 210M · Long Beach, CAan erroneous low fuel quantity indication that led the pilot to attempt a precautionary landing in a congested and less than ideal location. The erroneous fuel level indication was due to multiple anomalies with the alternator installation that precipitated a…NTSB SEA06CA051Accident · No injuriesData collectionFinal reportErcoupe 415-C · Arlington, WAThe pilot's excessive descent rate and his delay in taking action to reduce the descent rate which resulted in an in-flight collision with the runway during an emergency landing. Contributing factors were the total loss of engine oil pressure and the pilot's…NTSB LAX06LA105Accident · 2 fatalLimited investigationFinal reportHooker Zodiac 601XL · Oakdale, CAthe structural failure of the wings for undetermined reasons.NTSB SEA06CA048Accident · No injuriesData collectionFinal reportCessna A185E · Lewiston, IDThe failure of the left main landing gear attaching bolt, which resulted in the left main gear collapsing during the landing roll.NTSB LAX06FA080Accident · No injuriesField investigationFinal reportEurocopter EC 130B4 · Lahaina, HIAn intermittent electrical continuity failure and short of the DECU-XPC wiring harness, which resulted in an uncommanded and an initially undetected engine deceleration and a resulting loss of main rotor rpm. Also causal was the manufacturer's inadequate…NTSB NYC06IA044Incident · No injuriesIncident investigationFinal reportBoeing 717-200 · Boston, MAWater dilution of the grease, which resulted in the failure of the number 4 wheel bearing.NTSB LAX06FA063Accident · No injuriesField investigationFinal reportBoeing 747-400 · Los Angeles, CAthe incorrect installation of the inflation valve cores in the number 11 and number 12 wheel assemblies that allowed the tires to be operated in an over deflected condition that resulted in their failure.NTSB DCA06MA010Accident · 20 fatalClass 1 · MajorFinal reportGrumman G-73T · Miami, FLThe in-flight failure and separation of the right wing during normal flight, which resulted from (1) the failure of the Chalk's Ocean Airways maintenance program to identify and properly repair fatigue cracks in the right wing and (2) the failure of the…NTSB SEA06IA019Incident · No injuriesIncident investigationFinal reportGulfstream Aerospace G-5 · Hillsboro, ORThe failure of the right main landing gear (MLG) door uplock linkage actuator due to corrosion, which resulted in jamming of the right MLG during the initial takeoff climb.NTSB CHI06TA033Accident · No injuriesFinal reportSchweizer 269C · Manhattan, KSThe binding of the main rotor blade's tachometer cable during cruise flight resulting in an observed split tachometer indication/aural alarm and perceived mechanical emergency and the unsuitable terrain the pilot encountered during the emergency landing. A…NTSB DEN06LA015Accident · No injuriesLimited investigationFinal reportCessna 182 · Broomfield, COthe nose wheel assembly separation for reasons undetermined.NTSB LAX06LA030Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Rancho Murieta, CAa separation of the tail rotor assembly due to the reverse bending fatigue fracture of a tail rotor pitch change link bolt, resulting in a loss of control of the helicopter, and a hard landing during the uncontrolled descent.NTSB LAX06LA029Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Mesa, AZthe failure of the flap motor fuse that rendered the flaps inoperable during a critical phase of flight. Factors in the accident were the lack of suitable terrain to perform an emergency landing and the owner's use of nonapproved fuses for the flap motor…NTSB ANC06TA009Accident · Minor injuriesFinal reportCessna 185 · Cordova, AKA fracture and separation of the main landing gear strut during the landing roll, which resulted in a loss of control, and subsequent nose down. Factors contributing to the accident were the manufacturer's and the FAA's insufficient standards/requirements…NTSB LAX06CA027Accident · No injuriesData collectionFinal reportLee Kolb Mark III Classic · Tucson, AZthe fatigue failure of the attachment that secured the horizontal stabilizer to the fuselage.NTSB SEA06CA018Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Tacoma, WAThe collapse of the landing gear due to the pilot's failure to use the emergency gear extension system after his aircraft experienced a complete loss of electrical power. Factors include the malfunction of the voltage regulating system, which lead to the…NTSB DFW06CA018Accident · No injuriesData collectionFinal reportPiper PA28A · Lubbock, TXThe pilot's inability to maintain directional control of the airplane while landing due to the separation of the nose landing gear tire assembly.NTSB ATL06CA011Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Bennettsville, SCThe malfunction of the wheel brake assembly due to low fluid level that resulted in a loss of control during the landing roll.NTSB CHI06CA014Accident · No injuriesData collectionFinal reportCessna 210C · Kankakee, ILA hydraulic line leak causing a loss of hydraulic fluid and subsequent failure of the hydraulic system. An additional cause was the inoperative landing gear extension system, both normal and emergency, due to a complete loss of the hydraulic system.NTSB CHI06IA011Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · West Grove, PAThe separation of the left engine exhaust nozzle during cruise climb due to inadequately designed attachment hardware.