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 LAX03IA199Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Phoenix, AZthe simultaneous failure of both horizontal stabilizer trim channels on two separate occasions for undetermined reasons.NTSB FTW03LA173Accident · 1 fatalLimited investigationFinal reportApex CAP 10B · Gladewater, TXThe failure of the left wing, which resulted from progressive compressive fractures in the upper wooden spar cap. Contributing the accident was the difficulty in performing adequate inspections of the spar caps in an attempt to detect the compressive…NTSB CHI03LA159Accident · No injuriesLimited investigationFinal reportCessna T210N · Tribune, KSThe in-flight separation of the turbocharger exhaust band clamp resulting in an in-flight fire and uncommanded landing gear extension. Also causal was the improper maintenance by unknown personnel.NTSB SEA03LA098Accident · No injuriesLimited investigationFinal reportCessna R182 · Kent, WAThe failure of the flaps to operate properly for undetermined reasons during the initial climb and subsequent aborted takeoff. A factor was the collapse of the main landing gear due to an inadequate amount of time for the gear extension process to be…NTSB DEN03FA099Accident · 1 fatalField investigationFinal reportAgusta A109K2 · Salt Lake City, UTFatigue of the tail rotor trunnion resulting in complete trunnion failure and subsequent tail rotor separation from the helicopter. Factors contributing to the accident were the low altitude, low airspeed, excessive tail rotor loading, and the worn tail-rotor…NTSB CHI03LA152Accident · No injuriesLimited investigationFinal reportZimmerman Glastar · Pierce, NEThe pilot's operation of the airplane with known deficiencies in equipment and his selection of unsuitable terrain for landing. Factors contributing to this accident were the overtemperature of the engine cooling system, the long grass, and the collapse of…NTSB CHI03IA153Incident · No injuriesIncident investigationFinal reportBeech 1900D · Milwaukee, WIFailure of the aileron sprocket assembly at the sprocket-to-shaft braze joint. Contributing factors were the improper braze procedure used by the part manufacturer at the time of fabrication which resulted in an inferior quality joint and the inadequate…NTSB FTW03LA164Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Grand Prairie, TXthe pilot's improper inspection of the aircraft after impacting trees on a previous flight which resulted in an in-flight separation of the lower left wing and aileron while performing aerobatic maneuvers.NTSB FTW03LA170Accident · No injuriesLimited investigationFinal reportNorth American T-28A · Houston, TXThe failure of the nose wheel landing gear shimmy damper for undetermined reasons.NTSB LAX03FA162Accident · 2 fatalField investigationFinal reportNorth American T28C · Sherman Oaks, CAThe pilot's in-flight loss of control due to spatial disorientation. Factors in the accident were the distraction caused by the malfunctioning mode C altitude reporting system, and the location of the transponder control head, which necessitated repeated…NTSB MIA03IA110Incident · No injuriesIncident investigationFinal reportCessna 402C · Miami, FLThe inadequate annual inspection of the airplane by other maintenance personnel for failure to note an incorrect washer was installed securing the upper and lower torque links, resulting in separation of the upper and lower links and subsequent rotation of…NTSB FTW03FA148Accident · No injuriesField investigationFinal reportBell 407 · Gulf Of MexicoThe short circuit of the C321capacitor in the Electronic Control Unit (ECU) that resulted in a single-point failure of the ECU's -15V power supply which disengaged/reverted the Hydro-mechanical Unit (HMU) from automatic to manual fuel control. Factors…NTSB ATL03IA090Incident · No injuriesIncident investigationFinal reportCanadair CL-600-2B19 · Chattanooga, TNExcessive wear on the bushings and the right aileron inboard and outboard power control unit output link resulting in the upward movement of the right aileron during cruise climb, uncommanded right roll. A factor in the accident was inadequate maintenance…NTSB FTW03FA145Accident · 2 fatalField investigationFinal reportBell Shelby Aero 47G2 · Ardmore, OKThe pilot's failure to control the rate of descent, which resulted in an improper touchdown of the helicopter. A contributing factor was the loss of throttle control for undetermined reasons.NTSB MIA03LA101Accident · No injuriesLimited investigationFinal reportCessna 177-RG · Clearwater, FLThe pilot's failure to maintain directional control during landing roll resulting in the failure and separation of the right main landing gear, partial collapse of the nose landing gear, and substantial damage to the airplane.NTSB LAX03LA143Accident · No injuriesLimited investigationFinal reportCessna 180A · Scottsdale, AZThe failure of a main landing gear axle bolt, and the subsequent separation of the right main landing gear wheel from the gear strut during the landing roll, which resulted in a collapse of the right main landing gear.NTSB SEA03LA066Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Plummer, IDThe jamming of the left parking brake locking tab on a burr on the left brake master cylinder activation rod during the landing roll, resulting in the left brake becoming locked in a position where excessive braking was applied.NTSB SEA03LA064Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Coos Bay, ORThe pilot's improper remedial action during takeoff and his failure to maintain airspeed. Contributing factors included the binding of the left brake and the trees.NTSB DEN03IA067Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Salt Lake City, UTtotal failure of a fuel flex line. A contributing factor was a fuel leak, resulting in an inflight engine compartment fire.NTSB FTW03LA132Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 (MD-82) · DFW Airport, TXAn inadvertent trauma to the passenger's ankle during an emergency evacuation.NTSB DEN03LA076Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Denver, COThe failure of the landing gear system and the flight crew's failure to ascertain that the landing gear was down and locked. A contributing factor was the inadequate maintenance inspections performed by maintenance personnel.NTSB SEA03LA061Accident · No injuriesLimited investigationFinal reportAvia Stroitel AC-5M · Richland, WAThe pilot's failure to maintain airspeed and the failure of the propeller drive assembly. A factor contributing to the accident was the inadvertent stall.NTSB LAX03LA123Accident · No injuriesLimited investigationFinal reportRobinson R-44 II · Willcox, AZThe failure of the alternator belt which resulted in the failure of the main drive belt.NTSB CHI03IA097Incident · No injuriesIncident investigationFinal reportBoeing 747-422 · Chicago, ILFailure of company maintenance personnel to fully comply with published maintenance/inspection procedures, as well as the resulting inoperative drain heaters and restricted movement of the aileron control cables. Contributing factors were the impeded waste…NTSB ATL03IA073Incident · No injuriesIncident investigationFinal reportCessna 182P · Eufaula, ALFatigue failure of end rib for the left canard flap.NTSB NYC03FA067Accident · Serious injuriesField investigationFinal reportBoeing 717-200 · Flushing, NYA failure of the left power control distribution unit (PCDU).NTSB IAD03LA041Accident · Serious injuriesLimited investigationFinal reportAeronca CH-7A · Cumberland, MDThe pilot/mechanic's failure to ensure the proper installation of the left wing's aft strut-to-spar attachment bolt, which resulted in a loss of control and a subsequent impact with terrain.NTSB FTW03FA117Accident · No injuriesField investigationFinal reportBell 407 · Houma, LAThe loss of tail rotor drive and anti-torque control resulting from the fracture and separation of the #5 tail rotor drive segment due to the overtemperature and subsequent failure of the #5 hangar bearing.NTSB FTW03LA115Accident · No injuriesLimited investigationFinal reportCessna FA150K · Houston, TXThe in-flight separation of the elevator trim tab.NTSB ATL03FA065Accident · 1 fatalField investigationFinal reportSikorsky S-61A · Kimble, TNThe interruption of rotor system drive power due to the input free wheeling unit malfunctioning , and the pilot's operation of the helicopter in the critical area of the height-velocity curve.NTSB ATL03FA064Accident · 2 fatalField investigationFinal reportCessna 172S · Monroe, GAThe pilot’s exceedence of the design limits of the airplane, which resulted in the overload failure of the horizontal stabilizers, followed by the overload separation of the right wing and subsequent loss of control.NTSB CHI03IA096Incident · Minor injuriesIncident investigationFinal reportCessna 208B · Saginaw, MIFailure of the engine bleed air pressure regulator. A contributing factor was the anti-chaffing tape on the air supply line.NTSB NYC03LA063Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Zelienople, PAThe failure of the tail rotor assembly due to improper maintenance by the owner/pilot.NTSB ATL03LA056Accident · No injuriesLimited investigationFinal reportFokker F.27MK 500 · Kinston, NCThe fatigue failure of the main drag stay tube. A factor is no inspection procedure required.NTSB ATL03LA059Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Gordo, ALFatigue failure of the crankshaft.NTSB LAX03LA106Accident · No injuriesLimited investigationFinal reportCessna 421C · Crescent City, CAThe separation of the upper and lower right main landing gear scissor links due to improper maintenance, which resulted in a ground loop, and the collapse of the right main landing gear during the landing roll.NTSB FTW03LA102Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Ruston, LAThe separation of the upper tail cone as a result of a fractured bolt due to fatigue.NTSB ANC03IA037Incident · No injuriesIncident investigationFinal reportCessna 206 · Homer, AKThe separation of the main landing gear spring strut during landing touchdown due to corrosion and fatigue. Factors contributing to the accident were the manufacturer's and the FAA's insufficient standards/requirements for inspection procedures.NTSB LAX03FA102Accident · 2 fatalField investigationFinal reportMitchell CH-801 · Nicholas, CAan in-flight structural failure due to the pilot exceeding the design limitations of the airplane. Drug impairment was a factor.NTSB MIA03LA070Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Sanford, FLThe intentional cutting of the hydraulic line by an unknown person resulting in the loss of hydraulic fluid and the inability of the pilot-in-command to extend and lock the main landing gear, and subsequent collapse of the main landing gear after touchdown.NTSB LAX03LA092Accident · 1 fatalLimited investigationFinal reportEverett BD-10 · Dana Point, CAin-flight breakup of the experimental airplane for undetermined reasons.NTSB FTW03LA099Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta II · Kent, TXThe loss of main rotor drive due to a drive belt separation resulting in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI03LA067Accident · No injuriesLimited investigationFinal reportBeech BE-G35 · Urbana, ILThe partial failure of the left stabilizer in overload.NTSB DEN03LA041Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS-350BII · Vernal, UTThe pilot's inadequate planning resulting in his inattentiveness of the attached longline. Contributing factors were the entanglement of the longline in the tail rotor, failure of the tail rotor drive shaft, and subsequent inability of the pilot to control…NTSB LAX03LA084Accident · Minor injuriesLimited investigationFinal reportCobb International Rotorway Exec 90 · Casa Grande, AZthe flight instructor's failure to maintain directional control of the helicopter during the flare and landing. Factors in the accident were the failure of the secondary drive shaft and inadequate tail rotor failure procedures specified by the manufacturer.NTSB FTW03FA093Accident · 3 fatalField investigationFinal reportCessna T210N · Mission, TXThe pilot's failure to maintain aircraft control, which resulted in his exceeding the airplane's design limitation. Contributing factors were the pilot's decision to fly the airplane with known deficiencies with the attitude indicator, and the failure of the…NTSB FTW03LA094Accident · No injuriesLimited investigationFinal reportCessna 210L · Morrilton, ARThe failure of the main landing gear to extend and lock, as a result of a hydraulic fluid leak caused by a chaffed and ruptured flex line.NTSB ATL03LA038Accident · No injuriesLimited investigationFinal reportBeech 200 · Jackson, MSThe failure of the landing gear system for undetermined reasons.NTSB MIA03CA053Accident · No injuriesData collectionFinal reportCessna 182R · Everglades City, FLstudent pilot's improper use of the brakes at the landing touchdown which caused the left main landing gear tire to burst, resulting in the student and certified flight instructor pilots not being able to maintain control of the airplane, and the subsequent…NTSB LAX03LA075Accident · No injuriesLimited investigationFinal reportCessna T210L · El Monte, CAthe alternator switch contact failure, which resulted in a complete electrical failure.