NTSB investigations
1,789 cases where the sequence of events included Landing gear collapse.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '094' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '094' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 SEA08CA131Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA-40 · Lakeview, ORThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control. Contributing to the accident was the crosswind was a factor.NTSB LAX08CA157Accident · No injuriesData collectionFinal reportPiper PA-34 · Blythe, CAThe pilot's failure to maintain directional control.NTSB LAX08CA132Accident · No injuriesData collectionFinal reportCessna 152 · Glendale, AZThe pilot's misjudged landing flare and inadequate recovery from a bounced landing.NTSB SEA08CA121Accident · No injuriesData collectionFinal reportExtra Flugzeugbau EA300/L · Great Falls, MTThe pilot's misjudged landing flare. A contributing factor was the glare from the sun.NTSB SEA08LA117Accident · No injuriesLimited investigationFinal reportRockwell 690C · Minden, NVThe collapse of both main landing gear for undetermined reasons.NTSB DFW08LA130Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Opelousas, LALoss of engine power due to starvation of the right fuel tank and the inability to select the left fuel tank. Contributing to airplane damage was the hidden obstruction in the field selected for the forced landing.NTSB DFW08IA126Incident · No injuriesIncident investigationFinal report2007 Savage Air Epic LT · Uvalde, TXThe pilot's excessive speed during a turn off the active runway to the taxiway which exceeded the lateral limits of the supporting landing gear structure resulting in the collapse of the left main gear.NTSB ANC08LA059Accident · No injuriesLimited investigationFinal reportCessna 560XL · Port Heiden, AKThe flying pilot’s failure to maintain directional control while landing in a crosswind. A factor contributing to the accident was a crosswind.NTSB LAX08CA096Accident · No injuriesData collectionFinal reportCessna T210N · Coaldale, NVThe pilot's failure to maintain directional control after encountering an unknown object on the dirt runway.NTSB DFW08TA128Accident · No injuriesFinal reportBeech C90 · Baton Rouge, LAStructural failure of the right main landing gear torque knee. A contributing factor was the failure to inspect the torque knee at the designated interval.NTSB DFW08CA109Accident · No injuriesData collectionFinal reportBeech C23 · Santa Fe, NMThe pilot's improper recovery from a bounced landing.NTSB CHI08CA121Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Vermillion, SDThe pilot's failure to adequately compensate for the crosswind condition. Contributing to the accident were the crosswind and the soft terrain.NTSB NYC08LA162Accident · No injuriesLimited investigationFinal reportCessna 560XL · White Plains, NYAn uncommanded landing gear retraction after touchdown for undetermined reasons.NTSB ANC08CA054Accident · No injuriesData collectionFinal reportCessna 172 · Tyndall AFB, FLThe pilot's misjudged flare and subsequent hard landing, and her inadequate recovery from a bounced landing.NTSB DFW08CA099Accident · No injuriesData collectionFinal reportCessna 310Q · Roswell, NMThe airframe and powerplant mechanic's incorrect reassembly of the landing gear.NTSB ANC08CA049Accident · No injuriesData collectionFinal reportCessna 185 · Big Lake, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion.NTSB MIA08LA086Accident · No injuriesLimited investigationFinal reportCessna 750 · New York, NYThe co-pilot's failure to maintain directional control during the landing roll. Contributing to the accident was a loss of system A hydraulic fluid for undetermined reasons and the flight crew's failure to follow the checklist sequence.NTSB LAX08IA093Incident · No injuriesIncident investigationFinal reportBennett Lancair 320 · Hillsboro, ORThe malfunction of the airplane's battery and alternator that resulted in the failure of the landing gear to extend and lock in place.NTSB ANC08CA044Accident · No injuriesData collectionFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to maintain directional control and inadequate compensation for wind conditions during a go-around. Contributing to the accident were wind gusts and a crosswind.NTSB LAX08CA084Accident · No injuriesData collectionFinal reportPiper PA32-301FT · Honolulu, HIThe pilot's inadequate compensation for the wind conditions and his subsequent failure to maintain an adequate airspeed during landing. A contributing factor was the weather windshear condition.NTSB NYC08CA147Accident · No injuriesData collectionFinal reportRans S12XL · Wauchula, FLThe malfunction of the fuel line, which resulted in a loss of engine power due to fuel starvation.NTSB LAX08CA091Accident · No injuriesData collectionFinal reportBeech F90 · Idaho Falls, IDthe pilot's misjudged distance and airspeed that led to a failure to attain the proper touchdown point and a runway overrun. Contributing factors were the snow and muddy conditions off the runway.NTSB CHI08CA092Accident · No injuriesData collectionFinal reportCessna 210N · Cincinnati, OHThe pilot's decision to operate the airplane with a "dead" battery contrary to guidance provided by the Pilot's Operating Handbook. An additional cause was the pilot's failure to verify that the landing gear was fully down and locked prior to landing.…NTSB CHI08CA091Accident · No injuriesData collectionFinal reportCessna 172R · Batavia, OHThe pilot's misjudgment of the landing flare and her inadequate recovery from the bounced landing.NTSB MIA08LA079Accident · No injuriesLimited investigationFinal reportCessna 402B · Fort Lauderdale, FLThe improper adjustment of the right main landing gear down lock by maintenance personnel resulting in the gear collapse during the landing roll..NTSB SEA08LA090Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-C1 · Spanish Fork, UTThe fatigue failure of the nose wheel fork assembly attachment stud/bolt during takeoff initial climb, and the collapse of the nose gear during landing.NTSB SEA08CA086Accident · No injuriesData collectionFinal reportMaule M-4 · Jerome, IDThe failure of both pilots to maintain directional control of the airplane during takeoff.NTSB NYC08CA122Accident · No injuriesData collectionFinal reportBeech B-55 · Brookhaven, MSThe pilot's improper flare, which resulted in a hard landing during the first attempt, and subsequent collapse of the nose landing gear during the second landing attempt. Contributing to the accident was the wind gusts.NTSB MIA08LA066Accident · No injuriesLimited investigationFinal reportCessna 210L · Tampa, FLThe malfunction of the right main landing gear down-and-locked switch.NTSB SEA08LA083Accident · No injuriesLimited investigationFinal reportCessna 180 · Moab, UTThe pilot's failure to maintain directional control of the tail wheel-equipped airplane during the flare/touchdown phase of a three-point landing.NTSB LAX08LA060Accident · No injuriesLimited investigationFinal reportCessna 305-A · Mokuleia, HIThe failure of the left main landing gear strut due to fatigue. Contributing to the failure was the side load placed on the landing gear while making a crosswind landing.NTSB DEN08LA057Accident · No injuriesLimited investigationFinal reportBeech A45 · Englewood, COThe pilot's improper decision to fly the airplane with a discharged battery, which resulted in a total electrical failure during takeoff climb. Contributing factors were the pilot's inability to verify the landing gear position, and the impact with the runway…NTSB SEA08LA079Accident · No injuriesLimited investigationFinal reportCessna P210N · Carefree, AZThe collapse of the landing gear during landing rollout for undetermined reasons.NTSB DEN08LA065Accident · No injuriesLimited investigationFinal reportPlocher SHA-Glasair · Telluride, COThe pilot's improper flare and his failure to maintain aircraft control, resulting in the design stress limits of the nose gear being exceeded. Contributing factors in this accident was the excessive airspeed, the pilot-induced porpoise of the airplane, and…NTSB MIA08LA053Accident · No injuriesLimited investigationFinal reportCessna C-172RG · Chamblee, GAA cracked nose gear actuator o-ring resulting in hydraulic fluid exhaustion, and collapse of the main gear.NTSB SEA08LA069Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Parowan, UTThe pilot's improper in-flight decision not to over fly/inspect the snow covered runway prior to landing, and his failure to align the airplane over the centerline of the runway. Contributing to the accident was the snow covered runway, the airport operator's…NTSB DFW08CA063Accident · No injuriesData collectionFinal reportCessna 177 · Picayune, MSThe pilot's misjudgement of the landing flare resulting in a hard landing.NTSB CHI08LA070Accident · No injuriesLimited investigationFinal reportBeech 58 · Cahokia, ILMaintenance personnel's improper replacement of the landing gear leg brace assembly which subsequently failed to keep the landing gear in the locked position.NTSB SEA08LA064Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Placerville, CAThe collapse of the right main landing gear during landing for undetermined reasons.