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 CEN11CA523Accident · No injuriesData collectionFinal reportCessna 195 · Oshkosh, WIThe failure of the left brake which resulted in a ground-loop.NTSB WPR11LA364Accident · No injuriesLimited investigationFinal reportNicholson 2000 · Sedona, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR11LA370Accident · No injuriesLimited investigationFinal reportPiper J5A · Biddle, MTFailure of the left main landing gear strut during the landing roll due to a preexisting crack.NTSB ANC11CA072Accident · No injuriesData collectionFinal reportAeronca 7AC · McCarthy, AKThe separation of the right main landing gear oleo strut assembly, resulting in the collapse of the main landing gear during the landing roll.NTSB CEN11LA494Accident · No injuriesLimited investigationFinal reportCessna T210L · Columbia, MOThe collapse of the right main landing gear during landing due to a lack of component lubrication, which resulted in the failure of the landing gear to lock once extended.NTSB WPR11CA447Accident · No injuriesData collectionFinal reportCessna 120 · Pendleton, ORThe pilot's excessive brake application while landing on rough terrain.NTSB ERA11CA396Accident · No injuriesData collectionFinal reportPiper PA-30 · Plant City, FLThe failure of a screw in the nose landing gear aligner assembly for undetermined reasons, which prevented the landing gear from fully extending.NTSB ERA11CA382Accident · No injuriesData collectionFinal reportBeech A36 · Wauchula, FLThe pilot's failure to extend the landing gear during the approach.NTSB WPR11LA313Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Flagstaff, AZFatigue failure of an engine mount attachment foot, which resulted in collapse of the nose landing gear during landing. Contributing to the accident was the failure of the owner/operator to adhere to the manufacturer's suggested engine mount inspection…NTSB CEN11LA418Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Rantoul, ILThe pilot did not use the emergency landing gear extension system, which resulted in a wheels-up landing. Contributing to the accident was the inoperative landing gear power pack motor.NTSB ERA11LA357Accident · No injuriesLimited investigationFinal reportCessna 182F · Warrenton, VAThe fatigue failure of the left main landing gear due to inadequate maintenance inspection that did not detect and correct corrosion pitting.NTSB ANC11CA054Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Nikiski, AKThe pilot's improper use of brakes during landing.NTSB WPR11LA292Accident · No injuriesLimited investigationFinal reportCessna 320F · Phoenix, AZThe mechanic's failure to properly secure the nose landing gear actuator push-pull tube to the landing gear door hinge clevis, which resulted in the gear jamming and not fully retracting after takeoff.NTSB WPR11LA273Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Marysville, CAThe separation of the right main landing gear during takeoff, due to fatigue.NTSB ERA11CA351Accident · No injuriesData collectionFinal reportPerth Amboy Bird CK · New Castle, PAThe pilot's improper use of brakes during the landing rollout.NTSB ANC11CA049Accident · No injuriesData collectionFinal reportChampion 7HC · Kenai, AKThe pilot's selection of unsuitable terrain for landing, resulting in the collapse of the main landing gear, and a nose over.NTSB ANC11CA044Accident · No injuriesData collectionFinal reportDouglas DC-6B · Cold Bay, AKThe flight crew's failure to extend the landing gear, which resulted in an inadvertent wheels up landing. Contributing to the accident was the flight crew's diverted attention.NTSB CEN11IA379Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Milwaukee, WIThe failure of the right main landing gear (MLG) to extend normally, which resulted from the combination of a slightly worn uplock pin, the operation of the hydraulic pumps below their specified operating pressures, and contamination within the landing gear…NTSB CEN11IA369Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145 · Chicago, ILThe overheat and failure the brake during landing due to oxidation of the brake rotors, which went undetected by maintenance personnel. Contributing to the accident was maintenance personnel’s lack of familiarity with detailed brake oxidation inspection…NTSB WPR11LA245Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Lake Havasu, AZThe failure of the low pressure switch in the normal landing gear system, which prevented normal operation of that system, and the misrigging of the emergency extension gear release valve, which prevented the system from being depressurized to allow for the…NTSB ANC11LA041Accident · No injuriesLimited investigationFinal reportEclipse EA500 · Nome, AKThe pilot landed without lowering the landing gear. Contributing to the accident was the pilot's decision to fly the airplane with an inoperative wing flap system.NTSB WPR11LA363Accident · No injuriesLimited investigationFinal reportCessna 340A · Fullerton, CAThe pilot's inability to maintain directional control during landing due to the left brake's degraded performance due to oil contamination, which resulted from the fatigue failure of an oil line component.NTSB ANC11LA039Accident · No injuriesLimited investigationFinal reportCessna 170A · Wasilla, AKThe pilot's loss of directional control during landing, which resulted in a runway excursion. Contributing to the accident were the effects of multiple modifications to the main and tailwheel landing gear through the supplemental type certificate and FAA…NTSB ERA11IA316Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries Gulfstream 200 · Newburgh, NYThe flight crew did not ensure that the landing gear selector handle was in the full down (extend) position. Contributing to the incident was inadequate checklist information.NTSB CEN11LA361Accident · No injuriesLimited investigationFinal reportFlournoy Martin R Flournoy MR S1S · Colorado Springs, COThe pilot’s loss of directional control during the landing rollout due to failure of the tailwheel assembly for undetermined reasons.NTSB CEN11LA357Accident · No injuriesLimited investigationFinal reportCessna T210M · Pueblo, COFailure of the landing gear to fully extend due to a failed o-ring in the nose gear actuator piston and a broken seal in the emergency landing gear extension system.NTSB CEN11LA352Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Athens, OHThe pilot's failure to maintain adequate airspeed in the flare which resulted in a stall and a hard landing.NTSB CEN11IA341Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COThe fatigue failure of the nose landing gear (NLG) end cap, which resulted in insufficient hydraulic pressure to secure the left main landing gear into the down and locked position. Contributing to the fatigue failure was the NLG end cap’s non-optimum grain…NTSB CEN11LA390Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Grand Forks, NDThe flight instructor’s inadequate supervision of the landing, which resulted in an inadequate flare and subsequent hard landing.NTSB WPR11LA218Accident · No injuriesLimited investigationFinal reportPiper PA46-500TP · Rock Springs, WYThe overstress fracture of the right aileron midspan hinge bracket due to modal vibrations created by a deflated right main landing gear tire during the takeoff roll.NTSB ERA11CA281Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Apex, NCThe pilot’s excessive application of the brakes, which caused the airplane to nose over.NTSB ERA11LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Meriden, CTMaintenance personnel's inadequate inspection of the main landing gear, which resulted in a failure of the right main landing gear’s inboard torque link lug due to a fatigue fracture. Contributing to the accident was owner's lack of compliance with a factory…NTSB ERA11CA261Accident · No injuriesData collectionFinal reportPiper J3C-65 · Westfield, MAThe pilot's sole reliance on the passenger for securing the airplane during the engine start and the passenger's inability to maintain braking after the engine started.NTSB ERA11CA238Accident · No injuriesData collectionFinal reportMooney M20K · Augusta, GAThe pilot's failure to extend the landing gear prior to landing. Contributing to the accident was the pilot’s reported fatigue.NTSB WPR11LA205Accident · Minor injuriesLimited investigationFinal reportBennett Midjet Mustang I · Ramona, CAThe pilot's inability to maintain directional control during the landing roll due to the overload separation of the left brake master cylinder from the left rudder pedal assembly.NTSB ERA11LA239Accident · No injuriesLimited investigationFinal reportBeech BE99 · Cedartown, GAThe failure of the left main landing gear bearings and supports due to inadequate lubrication by unknown maintenance personnel.NTSB ERA11LA231Accident · No injuriesLimited investigationFinal reportCessna 172RG · Okeechobee, FLThe failure of the main landing gear to lock in the extended position for undetermined reasons and both pilots’ failure to ensure that the landing gear was down and locked prior to landing.NTSB CEN11LA281Accident · No injuriesLimited investigationFinal reportReeves Avid Mark IV · Brookfield, MOThe pilot’s failure to maintain directional control during landing, which resulted in the airplane departing the runway.NTSB ERA11LA221Accident · No injuriesLimited investigationFinal reportCessna 310F · Sanford, FLThe failure of the nose landing gear due to inadequate servicing of the nose gear strut reservoir.NTSB CEN11IA264Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Detroit, MIThe mechanic's incomplete securing of all the wheel well bin's fasteners, which resulted in separation of the bin from the airplane.NTSB CEN11CA277Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Kansas City, MOThe pilot's failure to extend the landing gear for a landing.NTSB CEN11LA254Accident · No injuriesLimited investigationFinal reportNorth American B25 · Encinal, TXThe co-pilot’s premature retraction of the landing gear during takeoff, which resulted in a gear collapse and impact with the runway surface.NTSB ERA11CA199Accident · No injuriesData collectionFinal reportLuscombe 8E · Taunton, MAThe pilot's inadvertent application of the brakes during recovery from a ground loop which resulted in a nose over.NTSB ANC11CA018Accident · No injuriesData collectionFinal reportCessna A185F · Aniak, AKThe inadvertent contact with a rut in the snow while taxiing, resulting in the collapse of the right main landing gear.NTSB WPR11CA165Accident · No injuriesData collectionFinal reportBellanca 14-13-2 · Mesquite, NVThe malfunction of the brake system which led to the pilot's failure to maintain directional control during the landing roll.NTSB ERA11LA191Accident · No injuriesLimited investigationFinal reportCessna 414 · New York, NYThe improper rigging of the right main landing gear, which resulted in ovestress fractures of a bolt and aft lug on the trunnion assembly.NTSB WPR11FA158Accident · No injuriesField investigationFinal reportCessna 208B · Bakersfield, CAThe malfunction of a master brake cylinder, which resulted in a loss of braking action and subsequent loss of directional control and collision with three vehicles during taxi. Contributing to the accident was the inappropriate design and manufacture of the…NTSB WPR11LA154Accident · No injuriesLimited investigationFinal reportCessna 210 · Pahrump, NVThe pilot's failure to extend the landing gear prior to touchdown and his improper decision to abort a gear-up landing following a propeller strike.NTSB CEN11LA219Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Delphi, INThe pilot's loss of directional control, resulting in a runway excursion, and the subsequent separation of the left main landing gear for undetermined reasons.NTSB CEN11CA212Accident · No injuriesData collectionFinal reportBeech G35 · Brenham, TXThe pilot’s failure to extend the landing gear during the approach resulting in a gear-up landing.