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 ERA21LA251Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24 · Monticello, NYThe pilot’s inadequate preflight inspection which resulted in a failure of the right main landing gear tire on landing rollout, a subsequent loss of directional control, and landing gear collapse.NTSB ERA21LA246Accident · No injuriesClass 3 · LimitedFinal reportHonda HA-420 · Kennesaw, GAThe mechanic’s improper installation of the left main wheel assembly.NTSB CEN21LA259Accident · No injuriesClass 3 · LimitedFinal reportCessna 560XL · Aspen, COThe malfunction of the landing gear handle for reasons that could not be determined, which caused the right main landing gear to collapse during the landing roll.NTSB CEN21LA256Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-161 · San Angelo, TXInadequate maintenance of the left main landing gear strut, which resulted in a landing gear collapse.NTSB CEN21LA248Accident · No injuriesClass 3 · LimitedFinal reportBeech 1900 · Denver, COThe pilot’s failure to properly configure the airplane for landing, which resulted in a gear-up landing.NTSB WPR21LA209Accident · No injuriesClass 4 · LimitedFinal reportCessna TR182 · Prescott, AZThe pilot’s delayed deployment of the landing gear, which resulted in the collapse of the main landing gear.NTSB ANC21LA042Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Birchwood, AKThe pilot's use of excessive braking during the landing roll, which resulted in a nose-over.NTSB ERA21LA235Accident · No injuriesClass 4 · LimitedFinal reportMeyers Industries 200A · Marathon, FLThe failure of the right main landing gear to fully extend during landing as a result of the underinflated right main landing gear oleo strut.NTSB CEN21LA244Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland DHC-2 MK.I · Oak Island, MNThe failure of an O-ring in the landing gear system, which resulted in the inadvertent extension of the main wheel in the amphibious float. Contributing to the accident was the pilot’s decision to depart with a known hydraulic leak in the landing gear system.NTSB CEN21LA218Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Tulsa, OKThe pilot’s inability to extend the main landing gear due to incomplete maintenance, which resulted in a partial wheels-up landing and the mechanic’s failure to follow proper maintenance procedures that led to the loss of main landing gear system hydraulic…NTSB ANC21LA039Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Kenai, AKThe pilot's excessive application of the airplane’s wheel brakes while landing, which resulted in a nose over.NTSB ERA21LA219Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Miami, FLThe collapse of the left main landing gear for reasons that could not be determined.NTSB ANC21LA036Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Willow, AKThe pilots over application of the brakes while landing on a wet grass runway, which resulted in a loss of control and nose-over.NTSB WPR21LA178Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 · Brigham City, UTThe student pilot's unintentional selection of raising the landing gear instead of the flaps during a touch-and-go landing, and the flight instructor's delayed remedial action, which resulted in the landing gear retracting during the landing roll.NTSB ERA21LA198Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Fredericksburg, VAThe student pilot reported that, during the landing roll, he applied brakes and the airplane veered right. He was unable to correct back to the centerline or brake effectively; the airplane exited the runway and struck an embankment before coming to rest. The…NTSB CEN21LA205Accident · No injuriesClass 4 · LimitedFinal reportCessna 310N · Carrollton, OHThe pilot’s failure to confirm the landing gear was down before landing due to distraction during the Before Landing checks, which resulted in a gear-up landing.NTSB WPR21LA162Accident · No injuriesClass 4 · LimitedFinal reportThrush S2R-T660 · Hermiston, ORThe pilot’s loss of directional control due to a blown tire, which resulted in a runway excursion and impact with terrain.NTSB ERA21LA352Accident · No injuriesClass 4 · LimitedFinal reportHine T L/Johnson R Bush Wacker · Thomaston, GAA loss of directional control upon landing for reasons that could not be determined as a result of a delayed report. Contributing was the pilot’s decision to continue a flight with an unknown airworthiness issue.NTSB WPR21LA362Accident · No injuriesClass 3 · LimitedFinal reportMaule MX-7-235 · Ontario, ORA loss of hydraulic fluid and failure of the right brake for reasons that could not be determined due to a lack of available evidence.NTSB ERA21LA211Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Burlington, VTA fire that originated in the right main landing gear brake assembly for reasons that could not be determined based on the available information.NTSB ERA21LA221Accident · No injuriesClass 4 · LimitedFinal reportCessna T337G · Patuxent River, MDThe pilot’s failure to extend the landing gear during approach, which resulted in a gear up landing.NTSB ERA21LA159Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Marianna, FLThe failure of the alternator control unit housing plug connection, which resulted in insufficient battery power to fully extend the landing gear. Contributing to the accident was the pilot’s decision to not use the emergency gear extension handle to secure…NTSB WPR21LA131Accident · No injuriesClass 3 · LimitedFinal reportCessna T210M · Leadore, IDThe pilot’s failure to attain the proper touchdown point on a graveled surfaced runway with insufficient landing performance and subsequent loss of control during the landing roll.NTSB ANC21LA022Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Skwentna, AKInstallation of improper hardware on the ski check cable. Contributing to the accident was the inadequate inspection of the ski yokes, which resulted in the subsequent failure of the right main landing gear ski yoke and collapse of the right main landing gear…NTSB ERA21LA147Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Johnstown, NYA failure of the landing gear system hydraulic pump assembly for reasons that could not be determined based on available evidence. Contributing was the pilot’s failure to confirm that the landing gear was down and locked before landing.NTSB CEN21LA147Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-23 · Oshkosh, WIThe failure of the nose landing gear lower drag link for reasons that could not be determined based on available information, which resulted in the collapse of the nose landing gear.NTSB ERA21LA138Accident · Serious injuriesClass 3 · LimitedFinal reportDassault Mirage F1 B · Panama City, FLNose landing gear contact with a raised aircraft arresting system during takeoff, which damaged components of the nose wheel steering system and resulted in an uncommanded left turn and loss of directional control.NTSB CEN21LA137Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46R-350T · Kansas City, MOThe loss of directional control during landing for reasons that could not be determined.NTSB ERA21LA146Accident · No injuriesClass 3 · LimitedFinal reportCessna P210 · Bartow, FLA leaking left main landing gear down lock actuator, which resulted in a loss of hydraulic fluid and a subsequent landing gear collapse during landing.NTSB WPR21LA117Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-44-180 · Redmond, ORFailure of the landing gear strut piston tube due to fatigue cracking from corrosion pitting.NTSB CEN21LA129Accident · No injuriesClass 3 · LimitedFinal reportColumbia Aircraft Mfg LC42-550FG · Larned, KSThe pilot’s failure to allow sufficient time for the brakes to cool after a previous aborted takeoff, resulting in a runway excursion during a second aborted takeoff due to degraded braking performance. Contributing to the accident was the contact of the hot…NTSB ERA21LA114Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A1 · Terrell, NCThe pilot’s failure to retract the landing gear on the amphibious airplane prior to a water landing, resulting in a nose over and structural damage to the airframe. The mechanic’s failure to remove electrical tape from the pitot tube, the pilot’s inadequate…NTSB ERA21LA100Accident · No injuriesClass 4 · LimitedFinal reportMurphy Rebel · O'Brien, FLA partially engaged right wheel brake, which restricted the airplane’s acceleration and the pilot’s ability to pitch to takeoff attitude, and resulted in an aborted takeoff and subsequent runway excursion.NTSB ERA21LA099Accident · No injuriesClass 3 · LimitedFinal reportDiamond DA 40 · Portsmouth, NHThe instructor’s multiple applications of the airplane’s brakes during high-speed taxi over a short duration, which overheated and ignited the right main landing gear wheel brake assembly.NTSB ERA21LA093Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Westfield, MAThe pilot’s failure to maintain control of the airplane during the landing and his failure to confirm that the landing gear was extended before landing.NTSB CEN21LA105Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Navasota, TXThe pilot’s failure to extend the landing gear before landing.NTSB ERA21LA065Incident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Leesburg, VAThe pilot’s loss of directional control during landing in crosswind conditions. Contributing to the loss of control was the significantly underinflated nose landing gear tire.NTSB CEN21LA065Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Canon City, COThe failure of the alternator drive belt, which resulted in insufficient electrical power to extend the landing gear and a subsequent gear-up landing. .NTSB ERA21LA044Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Ellenville, NYThe failure of the right brake master cylinder lock seal spring washer.NTSB CEN21LA108Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Fort Worth, TXA failure of the nose wheel landing strut for reasons that could not be determined based on available information.NTSB CEN21LA233Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Edinburg, TXThe collapse of the airplane’s left main landing gear for a reason that could not be determined based upon the available evidence.NTSB WPR21LA028Accident · No injuriesClass 4 · LimitedFinal reportCessna T210K · Los Alamos, NMThe pilot’s failure to extend the landing gear, which resulted in the airplane landing with the landing gear retracted.NTSB ERA21LA021Accident · No injuriesClass 3 · LimitedFinal reportBeech 99 · Waterville, MEA failure of the right main landing gear drag leg support fitting and angle bracket as a result of multiple areas of fatigue cracking.NTSB CEN21LA016Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox Classic 4 · New Carlisle, OHThe pilot’s failure to maintain pitch control of the airplane during landing, which caused the airplane to nose over during landing roll. Contributing to the accident was the main landing gear modification which increased the airplane’s tendency to nose over…NTSB CEN21LA023Accident · No injuriesClass 4 · LimitedFinal reportEvolution Revolt · Durango, COThe pilot’s loss of directional control during landing following a hard landing and failure of the right main tire.NTSB CEN21LA009Accident · No injuriesClass 4 · LimitedFinal reportMooney M20F · Denver, COFailure of the landing gear motor that prevented the gear from extending fully to the down and locked position, which resulted in a gear collapse on landing and a subsequent loss of directional control.NTSB ANC20LA100Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Tok, AKThe mechanic’s failure to properly repair the tailwheel, which resulted in a malfunction of the tailwheel and a loss of directional control.NTSB ERA20LA342Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCB · DeFuniak Springs, FLThe failure of the left landing gear airframe cross tube during landing, due to corrosion hidden under riveted fairing.NTSB CEN20CA416Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172RG · Lafayette, INThe separation failure of a landing gear system hydraulic line and its compression fitting during cruise flight, which resulted in a partial gear up landing.NTSB CEN20CA411Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna R182 · Marksville, LAThe pilot’s inadequate preflight inspection, during which he failed to ensure the landing gear handle in the “down” position which resulted in the landing gear retracting during takeoff, a loss of directional control, and a runway excursion.