NTSB investigations
1,788 cases where NTSB found Landing gear system.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010232')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010232')) 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 MIA08CA095Accident · No injuriesData collectionFinal reportChampion 7KCAB · Alexander City, ALThe separation of the right tail wheel spring on landing roll out for undetermined reasons, resulting in a loss of directional control and collision with a ditch.NTSB ANC08LA055Accident · No injuriesLimited investigationFinal reportCessna 180 · Kodiak, AKA loss of control during the landing roll due to a failure or malfunction of the brake system, resulting in a loss of control, and structural damage to the airplane.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 LAX08CA100Accident · Minor injuriesData collectionFinal reportQuestair Venture · Salt Lake City, UTThe failure of the left side master brake cylinder that led to a loss of braking capability during landing rollout. A contributing factor was the presence of a ditch next to the runway's end.NTSB DFW08CA099Accident · No injuriesData collectionFinal reportCessna 310Q · Roswell, NMThe airframe and powerplant mechanic's incorrect reassembly of the landing gear.NTSB DFW08CA096Accident · No injuriesData collectionFinal reportCessna C-182 · Porter, TXThe pilot's loss of directional control due to the partial failure of the left brake.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 DFW08IA087Incident · No injuriesIncident investigationFinal reportBoeing 737-524 · Houston, TXThe flight crew's improper landing technique for an inoperative anti-skid system resulting in locked brakes and four blown main landing gear tires.NTSB LAX08LA086Accident · No injuriesLimited investigationFinal reportCessna 402 · Henderson, NVThe failure of the left main landing gear torque link assembly for undetermined reasons.NTSB LAX08LA080Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Portland, ORThe failure of company maintenance personnel to install the upper pivot bolt through the pivot hole in the upper end of the landing gear actuating rod, and the company maintenance inspector's inadequate inspection of the work performed.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 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 LAX08CA076Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll. Contributing to the accident was the crosswind condition.NTSB DEN08LA064Accident · No injuriesLimited investigationFinal reportSpartan 7W · Santa Fe, NMFatigue failure of the right main landing gear, rendering directional control impossible and causing an overload failure of the left main landing gear.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 MIA08CA074Accident · No injuriesData collectionFinal reportCessna 525B · Stuart, FLThe flight crew's failure to reset the brakes circuit breaker resulting in a loss of brakes during taxi and an on ground collision with an unoccupied parked airplane.NTSB SEA08CA092Accident · No injuriesData collectionFinal reportPiper PA-24 · Bountiful, UTThe pilot's failure to extend the landing gear.NTSB SEA08CA086Accident · No injuriesData collectionFinal reportMaule M-4 · Jerome, IDThe failure of both pilots to maintain directional control of the airplane during takeoff.NTSB NYC08CA123Accident · No injuriesData collectionFinal reportMaule MT-7-235 · Leonardtown, MDThe pilot's inadequate recovery from a bounced landing.NTSB LAX08CA070Accident · No injuriesData collectionFinal reportCessna 170B · Truckee, CAThe pilot's continued operation with a known mechanical problem and failure to maintain directional control.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 DCA08IA044Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A320 · Jackson, WYthe loss of braking action on the left main landing gear due to the cross connection of the wheel speed tachometer wires that was caused by inadequate maintenance performed on the airplane during the installation of the main landing gear.NTSB MIA08CA067Accident · Minor injuriesData collectionFinal reportWaco CTO · Venice, FLThe pilot's improper use of brakes during the landing roll.NTSB CHI08CA088Accident · No injuriesData collectionFinal reportShaffer KR-2 · Fremont, OHThe loss of engine power for undetermined reasons during takeoff.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 SEA08LA079Accident · No injuriesLimited investigationFinal reportCessna P210N · Carefree, AZThe collapse of the landing gear during landing rollout for undetermined reasons.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 CHI08CA076Accident · No injuriesData collectionFinal reportAmerican AA-1A · Grantsburg, WIThe seizure of the left brake due to a buildup of ice between the rotor and brake pad. Contributing to the accident was the snow and slush covered runway, and the snowbank.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 LAX08CA051Accident · No injuriesData collectionFinal reportLuscombe 8E · Brigham City, UTThe failure of the landing gear/ski attachment assembly due to inadequate maintenance.NTSB DEN08CA051Accident · No injuriesData collectionFinal reportPiper PA-32-301XTC · Taos, NMThe pilot's excessive airspeed during the approach and loss of control during the landing. Contributing factors were the mountain turbulence and the snowbank.NTSB SEA08LA060Accident · No injuriesLimited investigationFinal reportDeSousa Jabiru J400 · Santa Monica, CAThe pilot's failure to attain the proper touchdown point, and loss of the wheel brake system.