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 ANC10CA092Accident · Minor injuriesData collectionFinal reportPiper J5A · Chickaloon, AKThe pilot's excessive use of brakes during a rejected takeoff, resulting in a nose over.Sep 11, 2010 · N35589 · Substantial damageNTSB WPR10LA457Accident · No injuriesLimited investigationFinal reportMyers THORP-18 · Jerome, IDThe pilot's failure to maintain directional control during the landing roll in gusty crosswinds.Sep 10, 2010 · N330JH · Substantial damageNTSB CEN10IA535Incident · No injuriesIncident investigationFinal reportEmbraer 500 · Brenham, TXThe pilots’ decision to depart with a known failed brake control unit.Sep 10, 2010 · N226CP · Minor damageNTSB WPR10CA480Accident · No injuriesData collectionFinal reportCessna A185 · Santa Ynez, CAThe pilot's failure to maintain directional control, likely due to the inadvertent control interference by a passenger. A finding in the accident was the pilot's improper pre flight briefing.Sep 6, 2010 · N4622C · Substantial damageNTSB CEN10CA540Accident · No injuriesData collectionFinal reportBeech E-90 · Colorado Springs, COThe pilot’s failure to ensure that the airplane’s parking brake was properly set before diverting his attention to other tasks.Sep 5, 2010 · N16LH · Substantial damageNTSB ANC10LA081Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Port Alsworth, AKThe overstress fracture and failure of a main landing gear wheel during landing, resulting in the right wing striking the ground.Aug 29, 2010 · N9569K · Substantial damageNTSB WPR10LA441Accident · No injuriesLimited investigationFinal reportCessna TR182 · Spanish Fork, UTThe pilot did not extend the landing gear due to his impairment from alcohol.Aug 28, 2010 · N738MP · Substantial damageNTSB CEN10CA510Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Basile, LAThe loss of directional control during landing due to failure of the right brake for undetermined reasons.Aug 27, 2010 · N63E · Substantial damageNTSB CEN10IA554Incident · No injuriesIncident investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Bloomington, ILThe cracked nose landing gear fork assembly found during the preflight inspection.Aug 26, 2010 · N409AM · Minor damageNTSB WPR10LA421Accident · No injuriesLimited investigationFinal reportCessna U206 · Grangeville, IDThe pilot’s decision to fly with a known defective nosewheel assembly, which resulted in a loss of directional control and nose-over on landing after the assembly shifted out of alignment during the flight.Aug 23, 2010 · N29100 · Substantial damageNTSB CEN10LA506Accident · No injuriesLimited investigationFinal reportAshcraft DR107 · Aurora, ILThe low cycle fatigue failure of the tail wheel spring during landing.Aug 21, 2010 · N123TA · Substantial damageNTSB WPR10CA414Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Buena, WAThe pilot’s excessive brake application, resulting in a nose over.Aug 19, 2010 · N1662P · Substantial damageNTSB ERA10LA423Accident · Serious injuriesLimited investigationFinal reportBeech C24R · Eastover, NCThe uncommanded retraction of the nose gear for undetermined reasons and the pilot's improper decision to continue the takeoff after the propeller began to contact the ground.Aug 15, 2010 · N792Y · Substantial damageNTSB CEN10LA457Accident · No injuriesLimited investigationFinal reportCessna 180B · Burnet, TXThe failure of the tailwheel compression spring, which resulted in a loss of directional control during landing.Aug 2, 2010 · N5177E · Substantial damageNTSB CEN10CA461Accident · No injuriesData collectionFinal reportWing Kitfox II · Park Rapids, MNA partial loss of engine power for undetermined reasons and the pilot's failure to adequately flare during the water landing.Aug 2, 2010 · N389HW · Substantial damageNTSB ERA10LA390Accident · 1 fatalLimited investigationFinal reportCessna A185F · Rockwood, METhe pilot's failure to retract the landing gear prior to a water landing. Contributing to the accident was the pilot's impairment due to medication.Aug 1, 2010 · N369E · Substantial damageNTSB ERA10IA384Incident · No injuriesIncident investigationFinal reportCessna 402C · San Juan, PRThe airplane manufacturer’s inadequate inspection procedures, resulting in the undetected fatigue cracking of the right upper barrel and trunnion assembly.Jul 27, 2010 · N402VN · Minor damageNTSB ERA10IA378Incident · No injuriesIncident investigationFinal reportCessna 402C · Hyannis, MAThe pilot's failure to extend the landing gear prior to landing flare and touchdown.Jul 26, 2010 · N26150 · Minor damageNTSB CEN10LA389Accident · No injuriesLimited investigationFinal reportCessna 210 · Houston, TXThe failure of a hydraulic fluid line, which caused a loss of hydraulic pressure to the landing gear extension system and resulted in the partial collapse of the right main landing gear during touchdown.Jul 9, 2010 · N2157S · Substantial damageNTSB WPR10LA340Accident · No injuriesLimited investigationFinal reportMooney M20F · Cottonwood, AZThe pilot’s failure to lower the landing gear prior to landing.Jul 2, 2010 · N6802V · Substantial damageNTSB CEN10TA355Accident · No injuriesFinal reportLockheed P2V-5 · Broomfield, COThe pilot’s failure to follow published emergency procedures by taxiing to the parking ramp with a known hydraulic system failure. Contributing to the accident was the co-pilot’s improper selection of the bypass position on the emergency nose gear extension…Jun 26, 2010 · N1386C · Substantial damageNTSB CEN10LA351Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Indianapolis, INThe pilot's inability to maintain directional control during landing due to the airplane not being equipped with a steerable or locking tailwheel as required by the airplane's design.Jun 26, 2010 · N469RH · Substantial damageNTSB CEN10CA358Accident · No injuriesData collectionFinal reportCessna 180K · Cahokia, ILThe fatigue failure of the axle's attaching bolts during landing.Jun 26, 2010 · N2785K · Substantial damageNTSB ERA10LA330Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Freehold, NYThe failure of the nosegear fork assembly due to fatigue. Contributing to the accident was an inadequate recent annual inspection.Jun 18, 2010 · N832LL · Substantial damageNTSB ERA10LA351Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Thomasville, GAThe improper reinstallation of the airplane’s oleo piston assembly during an annual inspection, resulting in the collapse of the right main landing gear during touchdown.Jun 17, 2010 · N73PC · Substantial damageNTSB WPR10CA291Accident · No injuriesData collectionFinal reportCessna 188B · Blackfoot, IDA loss of directional control during the landing roll as a result of a worn tail wheel locking mechanism.Jun 14, 2010 · N9357K · Substantial damageNTSB CEN10LA315Accident · No injuriesLimited investigationFinal reportBeech 1900D · Denver, COThe pre-existent damage of the right-hand landing gear actuator attachment lug which led to fatigue cracking and eventual overload failure resulting in a collapsed gear upon landing.Jun 12, 2010 · N195GL · Substantial damageNTSB CEN10CA321Accident · No injuriesData collectionFinal reportCessna A188B · Orange, TXThe loss of directional control during the takeoff roll due to an incorrectly maintained left main landing gear.Jun 9, 2010 · N9510J · Substantial damageNTSB CEN10CA301Accident · No injuriesData collectionFinal reportCessna 421B · Anderson, INThe pilot’s failure to establish proper rotation and liftoff speed during the takeoff roll.Jun 4, 2010 · N421KB · Substantial damageNTSB CEN10CA296Accident · Minor injuriesData collectionFinal reportMooney M20M · Port Clinton, OHThe pilot’s delayed decision to abort the landing and his failure to properly reconfigure the airplane during the aborted landing attempt.Jun 4, 2010 · N1054B · Substantial damageNTSB CEN10LA302Accident · No injuriesLimited investigationFinal reportBeech C90 · Fort Worth, TXThe failure of the nose gear actuator due to insufficient lubrication of the nut assembly threads.Jun 3, 2010 · N20 · Substantial damageNTSB WPR10CA270Accident · No injuriesData collectionFinal reportBeech C24R · Boise, IDThe pilot's failure to properly configure the landing gear for landing and the flight instructor's inadequate supervision.May 29, 2010 · N23995 · Substantial damageNTSB ANC10CA043Accident · No injuriesData collectionFinal reportPiper PA-12 · Tanana, AKThe pilot's excessive application of the brakes during the landing roll resulting in a nose over.May 24, 2010 · N2507M · Substantial damageNTSB WPR10IA256Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Ontario, CAFailure of the airplane’s nose landing gear to extend for undetermined reasons.May 23, 2010 · N925SW · Minor damageNTSB WPR10LA253Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Robbins, CAThe failure of the wheel hub flange, which allowed the over size tire to expand and impinge on the brake disc and caliper, which resulted in a loss of control during the landing.May 21, 2010 · N3633C · Substantial damageNTSB CEN10CA258Accident · No injuriesData collectionFinal reportCalcote Clarence E Glasair RG · Lee's Summit, MOThe failure of the landing gear to fully extend and lock in the down position for unknown reasons.May 18, 2010 · N236CC · Substantial damageNTSB ERA10LA266Accident · 2 fatalLimited investigationFinal reportAerostar S A YAK-52 · Jensen Beach, FLThe pilot's decision to perform an aerobatic maneuver at a low altitude, which resulted in insufficient clearance from the water to conduct a recovery. Contributing to the accident was the airplane’s extended landing gear, which resulted in a degradation of…May 15, 2010 · N6868Y · Substantial damageNTSB WPR10LA241Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Caldwell, IDA loss of directional control and runway excursion for undetermined reasons.May 14, 2010 · N3142C · Substantial damageNTSB ERA10LA263Accident · No injuriesLimited investigationFinal reportHachem Zachery S E7 · Homerville, GAThe pilot’s improper flare, which resulted in a hard landing.May 12, 2010 · N101RU · Substantial damageNTSB ANC10CA039Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cape Yakataga, AKThe uncertificated pilot's selection of an unsuitable landing site, resulting in a main landing gear collapse during the landing roll.May 6, 2010 · N90918 · Substantial damageNTSB WPR10LA221Accident · No injuriesLimited investigationFinal reportCessna 170A · Minden, NVA main landing gear collapse during the landing roll due to fatigue cracking and corrosion of the strut.Apr 30, 2010 · N5765C · Substantial damageNTSB WPR10LA219Accident · No injuriesLimited investigationFinal reportRogers Rutan Defiant 40 · Phoenix, AZThe failure of the pilot to ensure that the landing gear extension handle was firmly placed in the down position prior to landing.Apr 29, 2010 · N23TR · Substantial damageNTSB CEN10CA228Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Jamestown, NDThe pilot's failure to lower the landing gear, resulting in a gear-up landing.Apr 26, 2010 · N5868V · Substantial damageNTSB CEN10CA215Accident · No injuriesData collectionFinal reportMurray Starlite · Shelbyville, ILThe corrosion of the left landing gear rotor and brake, which resulted in the loss of directional control during the landing rollout, and the pilot's inadequate preflight inspection.Apr 21, 2010 · N4326D · Substantial damageNTSB WPR10LA207Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Fruitland, UTThe pilot’s improper landing flare.Apr 17, 2010 · N9019D · Substantial damageNTSB ERA10LA237Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Parkersburg, WVThe inadequate design of the engine mount by the manufacturer, resulting in collapse of the nose landing gear. Contributing to the accident was the failure of the operator to adhere to the manufacturer's suggested engine mount inspection schedule.Apr 16, 2010 · N779MA · Substantial damageNTSB WPR10CA206Accident · No injuriesData collectionFinal reportCessna 150L · Princeville, ORThe pilot’s failure to ensure that the parking brake was set prior to hand-starting the engine.Apr 15, 2010 · N6928G · Substantial damageNTSB CEN10LA210Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Three Rivers, MIThe pilot's inability to maintain directional control during landing due to the failure of the left main landing gear torque link as a result of fatigue.Apr 12, 2010 · N3470R · Substantial damageNTSB WPR10LA216Accident · No injuriesLimited investigationFinal reportCessna 210 · Show Low, AZInadequate clearance between a landing gear brake system line and airframe components, which precluded gear extension and resulted in an intentional gear-up landing.Apr 11, 2010 · N9527T · Substantial damageNTSB ERA10CA201Accident · No injuriesData collectionFinal reportBeech 95-B55 (T42A) · Sevierville, TNThe pilot's inadvertent retraction of the landing gear on the ground during a touch-and-go landing.Mar 31, 2010 · N43BS · Substantial damage