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.

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.Sep 8, 2009 · N670SW · Minor damageNTSB 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.Sep 7, 2009 · N54182 · Substantial damageNTSB CEN09LA567Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Marshall, MIThe failure of the main landing gear attach point.Sep 5, 2009 · N3383E · Substantial damageNTSB 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.Aug 30, 2009 · N4418 · Substantial damageNTSB 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.Aug 30, 2009 · N3278K · Substantial damageNTSB 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.Aug 28, 2009 · N682RC · Substantial damageNTSB 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.Aug 28, 2009 · N950TC · Substantial damageNTSB 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…Aug 27, 2009 · N4837T · Substantial damageNTSB 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.Aug 27, 2009 · N40VS · Substantial damageNTSB ERA09LA474Accident · No injuriesLimited investigationFinal reportCessna T210M · Dalton, GAThe failure of the right main landing gear actuator downlock spring.Aug 22, 2009 · N732MM · Substantial damageNTSB WPR09LA408Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tacoma, WAThe pilot's improper landing flare in crosswind conditions resulting in a gear leg collapse.Aug 21, 2009 · N6038D · Substantial damageNTSB 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.Aug 17, 2009 · N9467A · Substantial damageNTSB 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…Aug 16, 2009 · N548C · Substantial damageNTSB 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.Aug 16, 2009 · N8209U · Substantial damageNTSB CEN09CA548Accident · No injuriesData collectionFinal reportPiper PA-15 · Plainwell, MIA loss of control on takeoff for undetermined reasons.Aug 15, 2009 · N4380H · Substantial damageNTSB 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.Aug 13, 2009 · N540S · Substantial damageNTSB 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.Aug 10, 2009 · N2292E · Substantial damageNTSB WPR09LA383Accident · No injuriesLimited investigationFinal reportBeech 76 · Glendale, AZThe fatigue failure of the left main landing gear enhanced side brace assembly.Jul 30, 2009 · N83ER · Substantial damageNTSB 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…Jul 29, 2009 · N540RT · Substantial damageNTSB 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.Jul 27, 2009 · N1494X · Substantial damageNTSB 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.Jul 25, 2009 · N918ZZ · Substantial damageNTSB 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.Jul 24, 2009 · N87711 · Substantial damageNTSB 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.Jul 22, 2009 · N7504Y · Substantial damageNTSB 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.Jul 18, 2009 · N2991D · Substantial damageNTSB 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.Jul 15, 2009 · N506AU · Minor damageNTSB 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.Jul 14, 2009 · N544DS · Substantial damageNTSB 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.Jul 14, 2009 · N3714T · Substantial damageNTSB 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.Jul 13, 2009 · N93CA · Substantial damageNTSB 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.Jul 10, 2009 · N3106L · Substantial damageNTSB 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.Jul 7, 2009 · N777YA · Substantial damageNTSB 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.Jul 6, 2009 · N201FD · Minor damageNTSB 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.Jul 3, 2009 · N988AE · Substantial damageNTSB 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.Jul 1, 2009 · N2118S · Substantial damageNTSB 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.Jun 25, 2009 · N701PT · Substantial damageNTSB 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.Jun 24, 2009 · N6939M · Substantial damageNTSB 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.Jun 19, 2009 · N92VA · Substantial damageNTSB 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…Jun 19, 2009 · N14797 · Substantial damageNTSB WPR09CA295Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Dixie, IDThe pilot's excessive braking during the landing roll.Jun 18, 2009 · N4155U · Substantial damageNTSB 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.Jun 17, 2009 · N707XA · Substantial damageNTSB 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.Jun 14, 2009 · N7999H · Substantial damageNTSB ERA09CA342Accident · No injuriesData collectionFinal reportBeech F33A · Rock Hill, SCThe pilot's failure to correctly extend the landing gear before landing.Jun 13, 2009 · N266DC · Substantial damageNTSB 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.Jun 11, 2009 · N6561N · Substantial damageNTSB 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.Jun 11, 2009 · N857AS · Minor damageNTSB 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.Jun 8, 2009 · N43766 · Substantial damageNTSB ERA09CA327Accident · No injuriesData collectionFinal reportMeuer Mark SA900 V ST · Winchester, TNThe malfunction of the right brake during landing rollout.Jun 6, 2009 · N675MM · Substantial damageNTSB 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.May 24, 2009 · N17119 · Substantial damageNTSB 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.May 24, 2009 · N701MW · Substantial damageNTSB 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.May 23, 2009 · N42WT · Substantial damageNTSB 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.May 19, 2009 · N1945D · Substantial damageNTSB 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.May 17, 2009 · UNREG · Substantial damage