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 LAX07LA215Accident · No injuriesLimited investigationFinal reportCessna 172RG · Roche Harbor, WAThe pilot's failure to perform the emergency landing gear extension procedure prior to landing. A contributing factor in the accident was the failure of the electrical system.NTSB NYC07IA164Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Orlando, FLThe mechanic's failure to secure the right engine cowling fasteners. Contributing to the incident was the pilot's inadequate preflight inspection.NTSB DEN07CA118Accident · Minor injuriesData collectionFinal reportJohnson F11C-2PJ · Deming, NMTotal failure of the top engine mount bolts and subsequent engine separation from the airframe.NTSB CHI07LA204Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Edgerton, WIThe reported non-mechanical loss of engine power for undetermined reasons during cruise and the excessive airspeed the pilot maintained during the approach for the forced landing. Factors were the loss of electrical power during cruise and the high vegetation…NTSB LAX07LA210Accident · Minor injuriesLimited investigationFinal reportAviation International Rotors CH-54A · Los Olivos, CAThe company mechanic's inadequately performed maintenance and inspection, which resulted in a flight control malfunction and loss of control during takeoff.NTSB CHI07LA191Accident · 1 fatalLimited investigationFinal reportPiper PA-22-135 · Johnson, NEThe failure of the left wing's lift strut, which resulted in the separation of the left wing, and the subsequent airplane control not being possible. Factors were the overdue annual inspection, the overdue compliance with an Airworthiness Directive on the…NTSB ANC07LA060Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKA fracture and collapse of the main landing gear. Contributing to the accident was an inadequate annual inspection by other maintenance personnel, and corrosion.NTSB LAX07IA198Incident · No injuriesIncident investigationFinal reportBoeing 747-400 · Los Angeles, CAThe loss of pressure in the number 12 tire due to inadvertent contact with foreign object debris while taxiing prior to takeoff, which resulted the number 11 tire to over deflect and burst during takeoff roll. Contributing to the incident was the failure of…NTSB ANC07LA059Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Kotzebue, AKLocked parking brakes and the operator's maintenance personnel's failure to properly secure the parking brake cable at its fuselage attaching clamp.NTSB SEA07CA186Accident · No injuriesData collectionFinal reportCessna 182 · Bear Lake, IDThe separation of the bolt that holds the nosewheel steering torque arm to the nose wheel strut during the takeoff roll, resulting in no nosewheel steering being available during the landing roll at the pilot's destination. Factors include the pilot's failure…NTSB CHI07LA173Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Fergus Falls, MNThe propeller blade failure during climb due to a fatigue crack. The oil leak that obstructed the pilot's vision was a factor in the accident.NTSB SEA07CA159Accident · Serious injuriesData collectionFinal reportNelson Murphy SR3500 Moose · Roche Harbor, WAThe jamming of the left brake during landing. A factor was the kit manufacturer's design of the brake system.NTSB SEA07LA155Accident · No injuriesLimited investigationFinal reportQuad City Ultralight Challenger II · Lodi, CAThe improper assembly of the rony bracket which attached the right wing forward lift strut to the fuselage, the subsequent failure of that bracket, and separation of the right wing from the aircraft.NTSB MIA07LA109Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lantana, FLSeparation of a landing gear hydraulic line at the fitting for undetermined reasons.NTSB DFW07LA130Accident · No injuriesLimited investigationFinal reportCessna 172K · Amarillo, TXThe failure of the left main landing gear spring assembly as a result of an unapproved repair by an unknown person(s), which resulted in a loss of directional control during the landing roll.NTSB CHI07MA160Accident · 6 fatalClass 1 · MajorFinal reportCessna 550 · Milwaukee, WIThe National Transportation Safety Board determines that the probable cause of this accident was the pilots’ mismanagement of an abnormal flight control situation through improper actions, including failing to control airspeed and to prioritize control of the…NTSB SEA07LA140Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Shearer, IDA fracture and separation of the left main landing gear strut during the landing roll due to fatigue.NTSB LAX07LA173Accident · Minor injuriesLimited investigationFinal reportWestland Helicopters Wasp HAS MK1 · Ramona, CAFailure of the pilot to maintain clearance from a tree while performing a precautionary landing. Contributing to the accident was the failure of a snubber dampener that induced a severe vibration in the rotor system.NTSB CHI07CA152Accident · No injuriesData collectionFinal reportCessna 421C · Kokomo, INThe pilot not obtaining proper alignment with the runway during the emergency landing after takeoff, which imparted an excessive side load on the landing gear. Factors contributing to the accident were the unstabilized approach and engine shutdown due to the…NTSB DFW07CA122Accident · Minor injuriesData collectionFinal reportLuciani RV8 · Tomball, TXThe deflated right main landing gear tire, which resulted in a loss of control during the landing roll and a nose over. A factor associated with the accident was the pilot's decision to operate the airplane without having the leaking tire inspected.NTSB SEA07LA133Accident · No injuriesLimited investigationFinal reportBeech B-99 · Billings, MTThe total failure of the nose landing gear actuator and the subsequent nose gear collapse during landing.NTSB CHI07LA151Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Fishers, INThe fatigue separation of the engine mount's nose gear actuator attachment foot during landing.NTSB ANC07LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Kenai, AKThe left main landing gear attaching bolts sheared during landing, which resulted in the left main landing gear collapsing and the left wing and the stabilator striking the ground.NTSB MIA07FA098Accident · 1 fatalField investigationFinal reportHughes 369A · Moulton, ALThe separation of a main rotor blade from its tension torsion bar for an undetermined reason.NTSB DFW07LA108Accident · Serious injuriesLimited investigationFinal reportCessna A188A · Clinton, OKSeparation of the exhaust stack and resulting vapor lock. A contributing factor was the none suitable terrain for the forced landing.NTSB ATL07FA083Accident · 3 fatalField investigationFinal reportCessna 182Q · Asheville, NCThe failure of the directional gyro and attitude indicator due to a vacuum system leak caused by a loose fitting. Contributing to the accident was the pilot's failure to execute a partial panel, no-gyro approach.NTSB MIA07IA088Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-30 · Atlanta, GAThe improper overhaul of the horizontal stabilizer chain drive unit drive assembly.NTSB ANC07LA035Accident · No injuriesLimited investigationFinal reportCessna A185F · Haines, AKThe main landing gear attachment bolts to the right ski sheared during the landing roll in deep snow, resulting in a nose down, and structural damage to the right wing and aileron.NTSB CHI07CA124Accident · No injuriesData collectionFinal reportWilkinson Daniel V Rotorway Exec 90 · Kalamazoo, MIThe failure of the sprag clutch which resulted in the disengagement of the drive unit and the pilot's misjudged landing during the autorotation. A factor was the low altitude at which the failure occurred.NTSB NYC07LA104Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Richmond, VAThe improper installation of the right brake assembly by maintenance personnel.NTSB ATL07FA077Accident · 5 fatalField investigationFinal reportBeech 58 · Hamilton, GAThe pilot's exceeding the design stress limits of the airplane while performing aerobatics in a nonaerobatic airplane, which resulted in an in-flight overload failure of the airframe. A factor in the accident was the pilot's decision to perform aerobatics.NTSB MIA07LA076Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Fort Lauderdale, FLThe inadequate design of the engine mount by the manufacturer, resulting in collapse of the nose landing gear.NTSB CHI07LA104Accident · 1 fatalLimited investigationFinal reportPiper PA-22-108 · Ava, MOThe failure of the aileron cable eye splice during cruise flight. Contributing to the accident were improper installation and service of the crimped cable sleeve, which rendered the airplane uncontrollable.NTSB DEN07CA086Accident · No injuriesData collectionFinal reportCessna 170A · Watkins, COA total failure during landing roll of the right brake caused by severely worn shoes, causing the caliper pins to engaged misaligned. A contributing factor was the pilot's inability to maintain directional control.NTSB CHI07FA107Accident · No injuriesField investigationFinal reportCanadair CL-600-2B19 · Lake Michigan, MIIn-flight separation of the left engine thrust reverser translating cowling due to intermittent binding and jamming of the reverser on the accident flight and on previous flights. Contributing factors were the inadequate maintenance action by the operator due…NTSB NYC07IA092Incident · No injuriesIncident investigationFinal reportCirrus Design SR20 · Leesburg, VAThe airplane manufacturer's inadequate rudder-aileron interconnect rigging information. Contributing to the incident was the design of the rudder-aileron interconnect system.NTSB SEA07LA093Accident · No injuriesLimited investigationFinal reportChampion 7ECA · East Wenatchee, WASeparation of the left main landing gear shock absorbing strut during takeoff. A missing screw was a factor.NTSB SEA07LA098Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Ocala, FLThe failure of the left main axle during the landing roll, which resulted in the collapse of the left main landing gear. A crosswind on the landing runway was a factor.NTSB SEA07LA090Accident · 1 fatalLimited investigationFinal reportBurton Fly Baby · Arlington, AZThe pilot exceeding the design stress limits of the aircraft while maneuvering in intentional aerobatics.NTSB SEA07LA145Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · McCall, IDThe nosewheel steering system's uncommanded turn during the landing roll, making it impossible for the pilot to maintain directional control. Factors include a snow bank running parallel to the side of the runway.NTSB ATL07LA066Accident · 1 fatalLimited investigationFinal reportSzybowcowy Zaklad Do SZD-36A · Sylacauga, ALThe pilot's improper installation of the left wing attachment pin, which allowed it to disengage during cruise flight, resulting in wing separation.NTSB LAX07LA118Accident · 2 fatalLimited investigationFinal reportRyan Navion A · Los Banos, CAthe pilot's intentional performance of aerobatic maneuvers that exceeded the design stress limits of the airplane structure. Also causal was the pilot's impairment due to the effects of alcohol consumption. Contributory was the pilot's impairment due to the…NTSB LAX07IA115Incident · No injuriesIncident investigationFinal reportEurocopter AS 350 BA · Kahului, HIThe loss of tail rotor control due to wear damage to the pitch control input rod that resulted ultimately in the fatigue failure of the upper support yoke arm. Contributing factors were the improper maintenance inspection of the expansion pin assembly and the…NTSB DEN07FA079Accident · 2 fatalField investigationFinal reportRobinson R44 II · Ponte Vedra Bch, FLthe mechanic's improper installation of the attachment hardware for the servo to swashplate push-pull tube joint which resulted in a disconnection, subsequent loss of control, and impact with terrain. Contributing factors were the company management's…NTSB NYC07LA087Accident · No injuriesLimited investigationFinal reportGates Learjet 36A · Newport News, VAThe failure of the landing gear tires due to foreign object damage (FOD) on the runway. Contributing to the accident was the failure of the drag chute.NTSB ATL07LA064Accident · No injuriesLimited investigationFinal reportBeech BE-90 · Augusta, GAA total failure of the electrical system for undetermined reasons, which resulted in the pilot's inability to ensure that the landing gear was down and locked.NTSB ATL07CA058Accident · No injuriesData collectionFinal reportCessna 172K · Cornelia, GAThe failure of the owner/operator to repair or replace a known leaking brake system components resulting in a total loss of brakes while taxing and an on-ground collision with trees.NTSB ATL07LA054Accident · 1 fatalLimited investigationFinal reportJames Walter Hornet · Talbotton, GAThe failure of the right main fuel line, resulting in fuel starvation and a loss of engine power.NTSB LAX07CA107Accident · No injuriesData collectionFinal reportPietsch IT · Douglas, AZa loss of directional control during landing due to separation of the rudder cable. A factor was the soft dirt terrain.NTSB CHI07MA083Accident · 1 fatalMajor investigationFinal reportMcDonnell Douglas 369FF · Haena, HIThe fatigue failure of the tail rotor blade root fitting due to a manufacturing defect which resulted in the separation of the tail rotor system and loss of tail rotor control. A contributing factor to the accident were the trees that the helicopter struck…