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 DEN07FA068Accident · Minor injuriesField investigationFinal reportFlight Design USA CT-SW · Albuquerque, NMThe total failure of the left main landing gear strut due to overload during the landing resulting in the loss of control and subsequent nose over. A factor contributing to the accident was the chief pilot 's inability to maintain directional control of the…NTSB LAX07LA106Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Monmouth, ORThe failure of the main drive belt tension assembly shaft due to high cycle, low stress fatigue.NTSB DEN07IA066Incident · No injuriesIncident investigationFinal reportDiamond Aircraft Industries DA-20-C1 · Pueblo, COThe failure of the horizontal stabilizer forward bracket bolts due to insufficent preload during factory installation.NTSB CHI07LA080Accident · 1 fatalLimited investigationFinal reportWood Quickie Q-2 · Edwardsville, ILThe loss of engine power during cruise due to loose cylinder head bolts/loose cylinders.NTSB MIA07IA052Incident · No injuriesIncident investigationFinal reportLiberty Aerospace XL-2 · Ormond Beach, FLThe improper manufacturing of the nose undercarriage leg by the vendor, and the inadequate surveillance of the vendor by the airplane manufacturer.NTSB ANC07LA021Accident · No injuriesLimited investigationFinal reportCessna 402C · Cordova, AKThe failure of the right main landing gear linkage during the landing roll, which resulted in a loss of directional control and the collapse of the right main landing gear. A factor associated with the accident was the failure of company maintenance personnel…NTSB LAX07IA093Incident · No injuriesIncident investigationFinal reportColumbia LC41-550FG · Banning, CAJammed aileron flight control during cruise flight due to the presence of foreign object debris, which resulted from the manufacturer's improper processes.NTSB MIA07LA049Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369FF · Placida, FLThe in-flight separation of the tail rotor pitch change control rod and bellcrank during takeoff-initial climb.NTSB SEA07LA062Accident · No injuriesLimited investigationFinal reportCessna 172RG · Daytona Beach, FLThe fracture and failure of the right landing gear actuator, which resulted in a gear collapse during the landing roll.NTSB CHI07LA064Accident · No injuriesLimited investigationFinal reportCessna 414A · Dickinson, NDThe undetermined failure of the emergency landing gear system and the retraction of the right main landing gear during landing.NTSB NYC07LA061Accident · No injuriesLimited investigationFinal reportCessna 310Q · Atlantic City, NJThe inoperative safe gear indicator light switch. Contributing to the accident was the pilot hand-cranking the landing gear past the physical stop.NTSB SEA07LA055Accident · No injuriesLimited investigationFinal reportCessna 421 · Pocatello, IDThe separation of the bolt that attaches the elevator trim tab actuator rod to the elevator trim tab horn, resulting in violent flutter of the elevator, and eventually to the separation of the inboard half of the right elevator.NTSB DEN07IA055Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Cripple Creek, COA fatigue fracture, which resulted in the separation of the No.1 engine fan disk. Contributing factors in the accident were the operators' maintenance personnel lack of training to be able to detect arc-out damage on the fan disk, and the fan disk…NTSB NYC07CA059Accident · No injuriesData collectionFinal reportCessna 182E · Ashland, VAThe pilot's failure to properly secure the seat locking pin.NTSB MIA07LA039Accident · No injuriesLimited investigationFinal reportCessna 177 · Carrabelle, FLThe failure of maintenance personnel to detect corrosion and a fatigue crack during the last annual inspection.NTSB MIA07LA038Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Tampa, FLThe inadequate design of the engine mount by the manufacturer, resulting in fatigue failure at the actuator attach foot and partial collapse of the nose landing gear.NTSB CHI07CA058Accident · No injuriesData collectionFinal reportLearjet 35A · Columbus, OHThe pilot's failure to maintain aircraft control during an inflight maneuver which resulted in the design stress limits of the airplane being exceeded. A factor was the excessive airspeed encountered during recovery.NTSB DEN07IA048Incident · No injuriesIncident investigationFinal reportRaytheon B300 · Englewood, COThis case was modified 10/30/2007 Failure of the nose landing gear upper torque knee due to overstress, and the pilot's inability to maintain aircraft control.NTSB MIA07LA041Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Immokalee, FLThe failure of the glider towing "weak link," for undetermined reasons, at an inadequate altitude to effect a normal landing, resulting in a hard landing.NTSB DEN07LA044Accident · Serious injuriesLimited investigationFinal reportMarino Exec 162F-1995 · Baldwin City, KSthe failure of the tail rotor drive belt for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN07CA046Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Walden, COThe pilot experiencing lateral flight control stiffness for undetermined reasons and the pilot's intentional wheels up landing. Factors were the snow covered and rough/uneven terrain.NTSB CHI07LA056Accident · No injuriesLimited investigationFinal reportPiper PA-24-260B · Belleville, ILThe failure of the torque link bolt which resulted in the right main landing gear strut scissors separating and becoming jammed in the wheel well. Contributing to the accident was the seized torque link bolt due to surface corrosion.NTSB ANC07LA009Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Nashville, TNThe pilot's inadequate compensation for gusty crosswind conditions during landing, which resulted in a loss of control and collision with the runway. Factors contributing to the accident were the failure of the aileron augmentation (spoiler) flight control…NTSB DEN07CA039Accident · No injuriesData collectionFinal reportCessna T210M · Broomfield, COthe failure of the mechanic to comply with the required replacement schedule resulting in the failure of the hydraulic line and the resulting gear up landing.NTSB MIA07CA030Accident · No injuriesData collectionFinal reportMorgan, Marvin R. Zenair CH701 Stol · Lithia, FLCollapse of the nosegear for undetermined reasons.NTSB CHI07LA043Accident · No injuriesLimited investigationFinal reportCessna 560 · North Canton, OHThe rupture of the hydraulic pressure hose assembly, which was caused by internal wear between the hose's fire sleeve and stainless steel braid, and the failure of the emergency landing gear assembly to deploy the right main landing gear during approach.…NTSB SEA07CA032Accident · No injuriesData collectionFinal reportRiley D-16A · Point Roberts, WAthe pre-existing crack in the nose wheel fork, which allowed separation of the nose wheel during the takeoff roll, resulting in collapse of the nose landing gear.NTSB LAX07LA045Accident · No injuriesLimited investigationFinal reportNanchang CJ-6A · Queen Creek, AZThe total loss of engine power resulting from the failure of the engine's air compressor due to a seized piston, which resulted in the stoppage of the oil pump, fuel pump, and tachometer generator, in addition to the compressor. The underlying reason for the…NTSB SEA07LA022Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Lyons, ORA severing of the helicopter's cyclic and collective rods by one of the load lifting slings following the failure of the other sling. A contributing factor was the hard landing due to the fact that an autorotation was not possible.NTSB DFW07CA031Accident · No injuriesData collectionFinal reportCessna 210 · Baytown, TXThe failure of the main landing gear to fully extend for an undetermined reason during takeoff-initial climb, which resulted in a gear-up landing.NTSB LAX07LA039Accident · No injuriesLimited investigationFinal reportCessna 172RG · San Diego, CAAn undetermined total electrical failure. The pilot's failure to extend the landing gear to the down and locked position was a factor.NTSB NYC07LA030Accident · No injuriesLimited investigationFinal reportStump Rotorway Exec 90 · Manchester, NHAn improperly installed oil line, which resulted in oil line fatigue failure and a subsequent loss of oil to the engine. A contributing factor was the sloping terrain at the forced landing site.NTSB CHI07IA067Incident · No injuriesIncident investigationFinal reportPiper PA-46-500TP · Fort Wayne, INThe fatigue failure/separation of the engine mount's nose gear actuator attachment foot, and the manufacturer's inadequate engine mount/nose gear actuator attachment design.NTSB CHI07CA023Accident · Minor injuriesData collectionFinal reportMooney M20J · Akron, OHThe pilot's failure to maintain sufficient airspeed during final approach resulting in an inadvertent stall. Contributing factors were the airplane's low altitude at the time of the stall and the asymmetric flap configuration.NTSB DEN07LA024Accident · Serious injuriesLimited investigationFinal reportBell UH-1H · Melrose, NMthe in-flight failure and separation of both tail rotor blades. Contributing factors in this accident were the check pilot interferring with the controls and his failure to relinquish control to the pilot-in-command.NTSB MIA07LA013Accident · Minor injuriesLimited investigationFinal reportWinter J.T/Johnson Kitfox III · Southwest Ranch, FLThe owner/builder's improper maintenance/installation of the propeller which resulted in a propeller blade coming loose and separating from the hub.NTSB DFW07CA025Accident · No injuriesData collectionFinal reportEiben Theodore Quickie Q-200 · Denton, TXThe loss of control during takeoff as result of the failure of the right wing for undetermined reasons.NTSB LAX07FA026Accident · 2 fatalField investigationFinal reportAircraft Mfg & Dev. CH601XL Slsa · Yuba City, CAIn-flight structural failure of the horizontal stabilizer and wings for undetermined reasons.NTSB CHI07FA016Accident · 1 fatalField investigationFinal reportCessna 175 · Battle Creek, MIA loss of engine power while in cruise flight due to an oil leak from the nose seal of the reduction gear case. Contributing to the accident were the oil leak, the pilot's reduced visibility out the windscreen, and rising terrain.NTSB NYC07CA019Accident · No injuriesData collectionFinal reportCessna 172M · Wakefield, VAThe student pilot's failure to maintain control during the landing. A factor to the accident was the wind gusts.NTSB CHI07LA011Accident · No injuriesLimited investigationFinal reportCessna R182 · Ames, IAThe fatigue failure of the landing gear actuator pin and the exterior visual maintenance inspection for cracks not possible by company maintenance personnel.NTSB LAX07IA014Incident · No injuriesIncident investigationFinal reportBoeing 737-790 · Los Angeles, CAA complete failure and depressurization of both hydraulic systems due to two separate events: 1) the failure of a engine driven pump on the 'A' system, and 2) the fatigue fracture and failure of a hydraulic line on the 'B' system.NTSB LAX07FA012Accident · 5 fatalField investigationFinal reportPiper PA-42 · Prescott, AZThe failure of the pilot following a jet aircraft to maintain adequate separation from the high velocity jet core exhaust. The separation of the T-tail upper section vertical stabilizer of the following aircraft due to contact with the high velocity jet core…NTSB LAX07CA010Accident · No injuriesData collectionFinal reportMonocoupe 110 Special · Chandler, AZthe failure of the forward left main landing gear attach point resulting in loss of control.NTSB DFW07FA004Accident · 4 fatalField investigationFinal reportAero Commander 690A · Antlers, OKThe pilot's failure to reduce airspeed while operating in an area of moderate turbulence, resulting in an in-flight break up. Contributing factors were the pilot's decision to exceed the maximum takeoff weight, and the prevailing turbulence.NTSB NYC07LA006Accident · No injuriesLimited investigationFinal reportBeech BE-200 · Leonardtown, MDThe airplane manufacturer's inadequate landing gear downlock plate maintenance orientation information, and the disengaged main landing gear.NTSB DEN07FA008Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD-90-30 · Denver, COA fractured nose gear assembly spray deflector that blocked the nose gear from extending during landing, and resulted in an intentional nose gear up landing.NTSB SEA07LA002Accident · No injuriesLimited investigationFinal reportCessna 340A · Kalispell, MTThe fracture of the adjusting bellcrank in overstress due to binding in a linkage forward of the bell crank.NTSB CHI07LA002Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marshall, MNThe failure of the nose gear to properly extend for undetermined reasons, which resulted in damage to the forward fuselage during landing.NTSB CHI06LA273Accident · Minor injuriesLimited investigationFinal reportDaub Pawnee Chief · McCook, NEThe failure of a welded joint at a cyclic control cable bracket located on the main rotor mast which made control of the helicopter impossible for the pilot.