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 CEN11CA523Accident · No injuriesData collectionFinal reportCessna 195 · Oshkosh, WIThe failure of the left brake which resulted in a ground-loop.Jul 28, 2011 · N195SM · Substantial damageNTSB WPR11LA364Accident · No injuriesLimited investigationFinal reportNicholson 2000 · Sedona, AZThe pilot’s improper landing flare, which resulted in a hard landing.Jul 27, 2011 · N671T · Substantial damageNTSB WPR11LA370Accident · No injuriesLimited investigationFinal reportPiper J5A · Biddle, MTFailure of the left main landing gear strut during the landing roll due to a preexisting crack.Jul 24, 2011 · N38AW · Substantial damageNTSB 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.Jul 24, 2011 · N85194 · Substantial damageNTSB 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.Jul 20, 2011 · N2056S · Substantial damageNTSB WPR11CA447Accident · No injuriesData collectionFinal reportCessna 120 · Pendleton, ORThe pilot's excessive brake application while landing on rough terrain.Jul 19, 2011 · N1705N · Substantial damageNTSB 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.Jul 10, 2011 · N325EE · Substantial damageNTSB ERA11CA382Accident · No injuriesData collectionFinal reportBeech A36 · Wauchula, FLThe pilot's failure to extend the landing gear during the approach.Jul 5, 2011 · N8036V · Substantial damageNTSB 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…Jun 26, 2011 · N9246M · Substantial damageNTSB 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.Jun 25, 2011 · N4106Q · Substantial damageNTSB 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.Jun 23, 2011 · N3152U · Substantial damageNTSB ANC11CA054Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Nikiski, AKThe pilot's improper use of brakes during landing.Jun 23, 2011 · N6248R · Substantial damageNTSB 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.Jun 21, 2011 · N6160Q · Substantial damageNTSB WPR11LA273Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Marysville, CAThe separation of the right main landing gear during takeoff, due to fatigue.Jun 21, 2011 · N3627G · Substantial damageNTSB ERA11CA351Accident · No injuriesData collectionFinal reportPerth Amboy Bird CK · New Castle, PAThe pilot's improper use of brakes during the landing rollout.Jun 17, 2011 · N914V · Substantial damageNTSB 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.Jun 16, 2011 · N8976R · Substantial damageNTSB 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.Jun 12, 2011 · N600UA · Substantial damageNTSB 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…Jun 7, 2011 · N866AS · Minor damageNTSB 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…Jun 3, 2011 · N607AE · No damageNTSB 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…Jun 2, 2011 · N712MK · Substantial damageNTSB 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.Jun 2, 2011 · N168TT · Substantial damageNTSB 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.Jun 1, 2011 · N340BG · Substantial damageNTSB 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…May 28, 2011 · N1742D · Substantial damageNTSB 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.May 27, 2011 · N749QS · Minor damageNTSB 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.May 22, 2011 · N457CF · Substantial damageNTSB 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.May 21, 2011 · N6850B · Substantial damageNTSB 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.May 21, 2011 · N4016X · Substantial damageNTSB 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…May 17, 2011 · N218YV · Minor damageNTSB 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.May 14, 2011 · N204ND · Substantial damageNTSB 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.May 3, 2011 · N46ME · Substantial damageNTSB ERA11CA281Accident · Minor injuriesData collectionFinal reportLuscombe 8E · Apex, NCThe pilot’s excessive application of the brakes, which caused the airplane to nose over.May 3, 2011 · N1902K · Substantial damageNTSB 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…Apr 22, 2011 · N2838D · Substantial damageNTSB 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.Apr 22, 2011 · N10674 · Substantial damageNTSB 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.Apr 11, 2011 · N777CV · Substantial damageNTSB 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.Apr 10, 2011 · N611JB · Substantial damageNTSB 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.Apr 10, 2011 · N899AE · Substantial damageNTSB 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.Apr 6, 2011 · N5284V · Substantial damageNTSB 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.Apr 2, 2011 · N6313T · Substantial damageNTSB ERA11LA221Accident · No injuriesLimited investigationFinal reportCessna 310F · Sanford, FLThe failure of the nose landing gear due to inadequate servicing of the nose gear strut reservoir.Apr 1, 2011 · N6781X · Substantial damageNTSB 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.Mar 30, 2011 · N8505Q · No damageNTSB CEN11CA277Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Kansas City, MOThe pilot's failure to extend the landing gear for a landing.Mar 29, 2011 · N8546P · Substantial damageNTSB 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.Mar 26, 2011 · N747AF · Substantial damageNTSB 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.Mar 19, 2011 · N2790K · Substantial damageNTSB 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.Mar 19, 2011 · N5182H · Substantial damageNTSB 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.Mar 15, 2011 · N74291 · Substantial damageNTSB 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.Mar 14, 2011 · N40NY · Substantial damageNTSB 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…Mar 10, 2011 · N930FE · Substantial damageNTSB 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.Mar 6, 2011 · N9400T · Substantial damageNTSB 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.Mar 4, 2011 · N82429 · Substantial damageNTSB 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.Feb 27, 2011 · N437D · Substantial damage