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 ENG09IA014Incident · No injuriesIncident investigationFinal reportBoeing 737 · Los Angeles, CAThe failure of the right main landing gear inboard axle due to fatigue cracking as a result of fretting damage in one of the brake mounting bolt holes.NTSB ANC09CA094Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKA tailwheel malfunction that limited directional control, which resulted in a runway excursion, and collision with a building.NTSB CEN09LA567Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Marshall, MIThe failure of the main landing gear attach point.NTSB WPR09CA429Accident · No injuriesData collectionFinal reportCurtiss Wright Travel AIR · San Diego, CAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB CEN09CA553Accident · No injuriesData collectionFinal reportWarner Lewis Steen · Broomfield, COThe pilot's inability to maintain directional control due to an internal mechanical failure of the left wheel that caused the wheel to seize.NTSB WPR09LA423Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Ballard, WAThe pilot's precautionary water landing with partially extended landing gear. Contributing to the accident was the unidentified anomaly with the airplane's electrical system, which rendered the gear position indicator system inoperative.NTSB WPR09CA421Accident · No injuriesData collectionFinal reportMeyer Robert AIR CAM · Hamilton, MTThe separation of the right main landing gear wheel due to the flight's encounter with soft terrain while landing on an unimproved river sandbar. Contributing to the accident was the pilot's decision to attempt a landing on an unimproved off-airport surface.NTSB WPR09LA417Accident · No injuriesLimited investigationFinal reportPiper PA28R · Wendover, UTThe failure of the pilot to attain and maintain an airspeed sufficient for normal landing gear retraction during initial climb. Contributing to the accident was the pilot's failure to use the airplane's manual override landing gear system, misidentifying that…NTSB ERA09LA520Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Arcadia, FLThe pilot's bounced takeoff roll, which resulted in a collapsed landing gear. Contributing to the accident was the airplane's overweight condition.NTSB ERA09LA474Accident · No injuriesLimited investigationFinal reportCessna T210M · Dalton, GAThe failure of the right main landing gear actuator downlock spring.NTSB WPR09LA408Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tacoma, WAThe pilot's improper landing flare in crosswind conditions resulting in a gear leg collapse.NTSB ERA09LA467Accident · No injuriesLimited investigationFinal reportCessna 140A · White Plains, NYThe failure of the right main landing gear due to a preexisting crack adjacent to a weld line.NTSB ERA09LA471Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Sanford, FLThe fatigue cracking at the point the nose landing gear actuator attaches to the mount resulting in separation of the actuator and partial collapse of the nose landing gear. Contributing to the accident was the lack of specific inspection guidance for…NTSB ANC09LA083Accident · No injuriesLimited investigationFinal reportCessna 185 · McCarthy, AKThe separation of the right main landing gear wheel from the airplane during landing for undetermined reasons, which resulted in an inability to control the airplane.NTSB CEN09CA548Accident · No injuriesData collectionFinal reportPiper PA-15 · Plainwell, MIA loss of control on takeoff for undetermined reasons.NTSB CEN09CA520Accident · No injuriesData collectionFinal reportGrahn J/Grahn G Pitts S2S · Rifle, COThe pilot's excessive landing speed and subsequent excessive brake application which resulted in a loss of control and impact with an airport sign.NTSB ERA09LA480Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Donalsonville, GAThe failure of the right main gear strut due to an improper weld repair by maintenance personnel.NTSB WPR09LA383Accident · No injuriesLimited investigationFinal reportBeech 76 · Glendale, AZThe fatigue failure of the left main landing gear enhanced side brace assembly.NTSB ANC09CA075Accident · No injuriesData collectionFinal reportCessna 180 · Buckland, AKThe improper installation of the right brake cylinder, which allowed a portion of the cylinder to disengage and jam the right rudder/brake pedal, resulting in a loss of directional control during landing. Contributing to the accident was an inadequate…NTSB ERA09LA427Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Mount Holly, NJA hard landing on an unknown date, resulting in damage to the left main landing gear support fitting.NTSB WPR09CA365Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Hemet, CAThe student pilot’s failure to maintain directional control during the landing roll and excessive use of the brakes.NTSB CEN09CA474Accident · No injuriesData collectionFinal reportBeech H-18 · Dayton, OHThe pilot's failure to lock the tailwheel during landing resulting in the loss of directional control.NTSB WPR09LA372Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Walla Walla, WAA tripped landing gear motor circuit breaker, which prevented the gear from fully locking in the down position, and subsequent collapse during landing. Contributing to the accident was the disabled landing gear warning horn.NTSB CEN09CA450Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Waring, TXThe pilot's failure to maintain directional control during landing roll-out. Contributing to the accident was the worn left main landing gear brake.NTSB ENG09IA009Incident · No injuriesIncident investigationFinal reportBoeing 737-3B7 · Charlotte (CLT), NCThe failure of the left hand main landing gear was caused by heat induced cracks resulting from abusive grinding/polishing of the chrome plate that was applied during the last overhaul.NTSB CEN09CA493Accident · Minor injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Cape Girardeau, MOThe airplane's inoperative brakes while taxiing. Contributing to the accident was the pilot's inadequate preflight.NTSB CEN09CA439Accident · No injuriesData collectionFinal reportPiper PA-28R-201 · West Chicago, ILThe pilot's failure to extend the landing gear resulting in a wheels-up landing. Contributing to the accident was the pilot being distracted by mowers near the approach end of the runway.NTSB ANC09CA066Accident · No injuriesData collectionFinal reportBeech G18S · Yakutat, AKThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion, and main landing gear collapse.NTSB CEN09CA457Accident · No injuriesData collectionFinal reportCessna 310 · Fort Worth, TXThe failure of the pivot pin in the side brace of the right main landing gear resulting in the gear collapse during taxi for undetermined reasons.NTSB ANC09LA064Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Skwentna, AKA fracture of the airplane's tailwheel shock absorber linkage during taxi, resulting in the collapse of the tailwheel.NTSB CEN09IA416Incident · No injuriesIncident investigationFinal reportMooney M20J · Midland, TXThe pilot’s failure to ensure the airplane was properly configured, which resulted in a wheels-up landing.NTSB CEN09LA415Accident · No injuriesLimited investigationFinal reportCessna 441 · Albuquerque, NMA malfunction of the landing gear selector switch and a loose fitting on the emergency extension system which rendered the landing gear system inoperable.NTSB CEN09LA417Accident · No injuriesLimited investigationFinal reportCessna T210L · Santa Teresa, NMThe failure of the landing gear accumulator seal for undetermined reasons. Contributing to the accident was the pilot’s failure to confirm the status of the landing gear.NTSB CEN09LA389Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · St. Louis, MOThe pilot’s failure to establish and maintain a stabilized final approach which resulted in a hard landing and runway overrun.NTSB CEN09LA384Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Llano, TXThe pilot's inability to maintain aircraft control due to the failure of the left main landing gear wheel, which resulted in the separation of the wheel from the aircraft.NTSB WPR09LA307Accident · No injuriesLimited investigationFinal reportGunnoe Velocity · Livermore, CAThe failure of the right brake due to a restricted brake rotor and subsequent brake fluid line failure as a result of inadequate maintenance.NTSB WPR09LA297Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Roosevelt, UTThe retraction of the left main landing gear due to the failure of the extension and retraction actuator arm attach bolt. Contributing to the accident was the failure of maintenance personnel to discover the extensive elongation of the actuator attach fitting…NTSB WPR09CA295Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Dixie, IDThe pilot's excessive braking during the landing roll.NTSB WPR09CA294Accident · No injuriesData collectionFinal reportDornier ALPHA-JET · Arlington, WAThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident were the distractions created by the pilot incorrectly setting a radio frequency and by his fixation on an airplane that was on the runway during his approach.NTSB WPR09LA287Accident · No injuriesLimited investigationFinal reportHoward Long EZ · Placerville, CAThe pilot's inability to maintain directional control during the landing roll due to a jammed brake cable.NTSB ERA09CA342Accident · No injuriesData collectionFinal reportBeech F33A · Rock Hill, SCThe pilot's failure to correctly extend the landing gear before landing.NTSB WPR09LA290Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · Columbia, CAThe failure of the left main landing gear drag link as a result of overstress fracture. Contributing to the accident was maintenance personnel's failure to detect a small crack in the left main landing gear drag link during the most recent annual inspection.NTSB ERA09IA338Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B1 · Atlanta, GAThe failure of the left main landing gear to extend due to high levels of particulate contamination in the hydraulic fluid.NTSB ERA09CA336Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Somerville, NJThe loss of directional control during the landing roll due to the separation of the tailwheel centering spring for an undetermined reason.NTSB ERA09CA327Accident · No injuriesData collectionFinal reportMeuer Mark SA900 V ST · Winchester, TNThe malfunction of the right brake during landing rollout.NTSB WPR09CA260Accident · No injuriesData collectionFinal reportStinson SR-8B · Tacoma, WAThe application of unintended braking input due to the pilot's failure to keep his feet correctly positioned on the rudder pedals during the landing roll.NTSB CEN09LA319Accident · No injuriesLimited investigationFinal reportMileski Zenair · New Hudson, MIThe pilot's improper flare which resulted in a hard landing and subsequent failure of the nose landing gear.NTSB CEN09CA315Accident · No injuriesData collectionFinal reportHolsclaw Francis E Starduster · Ranger, TXThe pilot's inability to maintain directional control due to the buckling of the right landing gear as a result of corrosion.NTSB CEN09CA307Accident · No injuriesData collectionFinal reportBeech C35 · Englewood, COThe collapse of the landing gear due to the mechanic's failure to properly wire the landing gear squat switch.NTSB WPR09CA259Accident · Minor injuriesData collectionFinal reportVenus Trike · Kuna, IDThe complete loss of engine power for undetermined reasons, and the overload failure of the nose landing gear strut during the roll out over soft/rough terrain.