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 ERA09LA295Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Norwood, MAThe student pilot's failure to maintain directional control during the landing rollout, which resulted in excessive side loads to the right main landing gear and the separation of the outer main landing gear rib from the right wing.May 16, 2009 · N323JT · Substantial damageNTSB CEN09IA294Incident · Minor injuriesIncident investigationFinal reportBoeing 737 · Houston, TXThe pilot's inadvertent application of excessive braking after touchdown, which caused the right wheels to lock and several tires to blow and resulted in a subsequent brake fire.May 13, 2009 · N371SW · Minor damageNTSB WPR09LA236Accident · No injuriesLimited investigationFinal reportCessna 140 · Mesquite, NVThe pilot's loss of directional control during landing resulting from binding of the left wheel's brake actuating system for an undetermined reason.May 10, 2009 · N73017 · Substantial damageNTSB CEN09LA285Accident · Serious injuriesLimited investigationFinal reportRockwell International 112A · Metropolis, ILA total loss of engine power for undetermined reasons.May 10, 2009 · N1348J · Substantial damageNTSB ERA09IA267Incident · No injuriesIncident investigationFinal reportCessna 402C · Nantucket, MAInstallation of an improper bearing in the landing gear actuator.Apr 27, 2009 · N769EA · Minor damageNTSB CEN09CA268Accident · No injuriesData collectionFinal reportLuscombe 8 · Terrell, TXThe failure of the landing gear due to undetected corrosion.Apr 22, 2009 · N2330K · Substantial damageNTSB CEN09CA260Accident · No injuriesData collectionFinal reportCessna 210 · Richmond, INThe pilot under instruction's failure to lower the landing gear and the instructor pilot's inadequate supervision.Apr 22, 2009 · N7409E · Substantial damageNTSB WPR09FA212Accident · No injuriesField investigationFinal reportCessna T210L · Moab, UTThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident was the pilot's self-induced distraction by maneuvering on final to show a point of interest to passengers.Apr 20, 2009 · N367N · Substantial damageNTSB ERA09CA254Accident · Minor injuriesData collectionFinal reportAmerican Longevity Searey · Littleton, NCThe pilot's failure to ensure the landing gear was properly configured for the water landing.Apr 19, 2009 · N915TR · Substantial damageNTSB WPR09CA198Accident · Minor injuriesData collectionFinal reportBetter Burn LLC/Startube Div Exec 162F · Chandler, AZThe flight instructor's inadequate supervision of the flight and delay in taking remedial action to prevent the helicopter from touching down while drifting. Contributing to the accident was the design of the skid shoes.Apr 16, 2009 · N333ST · Substantial damageNTSB ERA09CA245Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Tampa, FLThe pilot's failure to confirm that the landing gear was retracted prior to the attempted water landing.Apr 11, 2009 · N1982P · Substantial damageNTSB WPR09LA189Accident · No injuriesLimited investigationFinal reportBeech A36TC · Roseburg, ORThe pilot's failure to follow the landing checklist, which resulted in a gear up landing. Contributing to the accident was the pilot's diverted attention.Apr 8, 2009 · N333HP · Substantial damageNTSB ERA09CA234Accident · No injuriesData collectionFinal reportCessna 172RG · Charleston, SCThe pilot's failure to extend the landing gear before landing. Contributing to the accident was the diversion of the pilot's attention to an airplane on a converging final approach course.Apr 5, 2009 · N6208V · Substantial damageNTSB WPR09LA179Accident · No injuriesLimited investigationFinal reportCessna 182 · Kalispell, MTA partial loss of engine power during a go-around for undetermined reasons. Contributing to the accident was a fatigue failure of the right main landing gear spring.Apr 4, 2009 · N6433A · Substantial damageNTSB ERA09CA227Accident · No injuriesData collectionFinal reportPiper PA-31-325 · Newark, NJThe pilot's decision to continue to operate the airplane with inoperative brakes on the airplane's right side.Apr 2, 2009 · N707AG · Substantial damageNTSB CEN09CA244Accident · No injuriesData collectionFinal reportMooney M20J · Salem, INThe pilot's failure to follow the landing checklist and extended the landing gear.Apr 1, 2009 · N115MS · Substantial damageNTSB WPR09LA171Accident · No injuriesLimited investigationFinal reportCessna 550 · Salt Lake City, UTThe uncommanded retraction of the right main landing gear hydraulic actuator strut for undetermined reasons.Mar 29, 2009 · N44FR · Substantial damageNTSB WPR09LA168Accident · No injuriesLimited investigationFinal reportCessna 182Q · Sedona, AZThe pilot's failure to achieve the proper touchdown point during a full-stop landing attempt. Contributing to the accident were the pilot's failure to ensure that the aircraft was properly configured for landing, his not initiating a go-around, and a…Mar 28, 2009 · N97467 · Substantial damageNTSB WPR09LA167Accident · No injuriesLimited investigationFinal reportCessna 180G · Wendover, UTA loss of directional control during landing as a result of the binding in one main landing gear brake assembly due to incorrect maintenance procedures. Contributing to the accident was the pilot's failure to correctly reconfigure the airplane during an…Mar 27, 2009 · N98FC · Substantial damageNTSB CEN09CA356Accident · No injuriesData collectionFinal reportBeech A36 · Charleston, MOThe pilot's inadvertent use of the landing gear selector handle instead of the flap handle during landing rollout, which resulted in the collapse of the nose landing gear.Mar 20, 2009 · N451S · Substantial damageNTSB WPR09LA151Accident · No injuriesLimited investigationFinal reportGates Learjet Learjet 55 · Casper, WYThe flight crew's failure to follow the manufacturer’s aircraft flight manual emergency procedures following a rejected takeoff that required a high energy stop inspection. Contributing to the accident was the flight's exceedence of the aircraft's maximum…Mar 17, 2009 · C-GCIL · Substantial damageNTSB CEN09CA223Accident · No injuriesData collectionFinal reportBeech D35 · Taos, NMThe failure of the student pilot to complete the before landing checklist. Contributing to the accident was his failure to lower the landing gear before landing.Mar 16, 2009 · N342R · Substantial damageNTSB ERA09LA209Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lumberton, MSCollapse of the landing gear due to worn left main landing gear components.Mar 8, 2009 · N8560Y · Substantial damageNTSB WPR09CA134Accident · No injuriesData collectionFinal reportKreps Thorp T-18-C · Palm Springs, CAA loss of directional control due to the fatigue failure of a tubular steel gear leg along a corroded weld line.Mar 1, 2009 · N118CK · Substantial damageNTSB CEN09LA197Accident · No injuriesLimited investigationFinal reportNeland Richard L Daytona SU · Guymon, OKFailure of the left main landing gear shock/strut during takeoff for undetermined reasons.Feb 26, 2009 · N170DN · Substantial damageNTSB WPR09CA136Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Ogden, UTThe loss of directional control during the landing roll due to the separation of the tailwheel spring retaining clip for unknown reasons.Feb 21, 2009 · N8637D · Substantial damageNTSB WPR09CA120Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Lincoln, CAThe pilot's failure to extend the landing gear for landing. Contributing to the accident was the pilot's diverted attention due to an open door and the airport's pilot activated runway lights turning off.Feb 20, 2009 · N8816P · Substantial damageNTSB CEN09CA169Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Mineral Wells, TXThe failure of the airframe and power plant mechanic to ensure proper lubrication of wire cables in the landing gear system during the annual inspection which precluded safe operation of the landing gear system.Feb 3, 2009 · N5451P · Substantial damageNTSB WPR09LA100Accident · No injuriesLimited investigationFinal reportCessna 210A · Henderson, NVAn undetermined failure of the hydraulic power pack to fully extend the main landing gear through both the normal and emergency systems.Jan 27, 2009 · N210TF · Substantial damageNTSB CEN09LA137Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMCollapse of the landing gear during landing due to the incorrect installation of the landing gear actuator. Contributing to the accident was the pilot's failure to initiate the abnormal procedures checklist prior to landing.Jan 18, 2009 · N8074P · Substantial damageNTSB WPR09CA084Accident · No injuriesData collectionFinal reportCessna U206E · Crane Island, San Juan Is., WAThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's improper application of brakes.Jan 14, 2009 · N9428G · Substantial damageNTSB WPR09LA083Accident · No injuriesLimited investigationFinal reportCessna 172RG · Carson City, NVThe overload failure of the landing gear actuator at an undetermined time.Jan 10, 2009 · N6272R · Substantial damageNTSB WPR09CA081Accident · No injuriesData collectionFinal reportParker 77 · Phoenix, AZThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's improper application of brakes.Jan 9, 2009 · N60DE · Substantial damageNTSB ERA09WA214Accident · No injuriesForeign investigationPiper PA31-350 · Lorenzo, BrazilOn March 23, 2009, at 1700 Atlantic standard time, a Piper PA31-350 Chieftain, PT-EHG, sustained minor damage from a landing-gear brake fire after landing at Lorenzo Airport (SNCL), Cairu, Brazil. The pilot and seven passengers were not injured. Visual…Dec 27, 2008 · PT-EHG · Minor damageNTSB CEN09CA118Accident · No injuriesData collectionFinal reportSocata TBM 700 · Clovis, NMThe pilot's failure to complete the before-landing checklist, which led to his failure to lower the gear before landing.Dec 23, 2008 · N70LR · Substantial damageNTSB CEN09FA098Accident · 2 fatalField investigationFinal reportPiper PA-46 · Hayden, COThe pilot's loss of situational awareness while maneuvering in adverse weather conditions, resulting in spatial disorientation.Dec 22, 2008 · N46SB · DestroyedNTSB CEN09CA109Accident · No injuriesData collectionFinal reportPiper PA28 · Ely, MNThe pilot's failure to maintain directional control during landing. Contributing to the accident were the reduced left main landing gear wheel rotation for undetermined reasons and the snow-covered runway.Dec 17, 2008 · N845D · Substantial damageNTSB DCA09IA017Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Philadelphia, PAthe failure of the maintenance personnel to properly complete the installation, and the inspection personnel to conduct the proper functional test, of the left main landing gear uplock assembly.Dec 14, 2008 · N407AW · Minor damageNTSB ERA09IA115Incident · No injuriesIncident investigationFinal reportCessna 402C · Fort Lauderdale, FLThe airplane manufacturer's inadequate inspection procedure resulting in undetected fatigue cracking of the main landing gear barrel of the upper barrel and trunnion assembly.Dec 11, 2008 · N522FA · Minor damageNTSB CEN09CA084Accident · No injuriesData collectionFinal reportRockwell International 114 · Meacham Int'l Airport, TXThe pilot's failure to maintain pitch control during landing.Dec 6, 2008 · N4920W · Substantial damageNTSB CEN09CA156Accident · No injuriesData collectionFinal reportRockwell International 500-S · Grand Forks, NDThe pilot's failure to extend the landing gear prior to touchdown.Dec 5, 2008 · N51RF · Substantial damageNTSB WPR09CA044Accident · No injuriesData collectionFinal reportCessna T210M · Hanford, CAThe failure of the pilot to use the before-landing checklist and extend the landing gear prior to landing.Nov 22, 2008 · N732XS · Substantial damageNTSB CEN09CA119Accident · No injuriesData collectionFinal reportPiper Aerostar 6 · Middletown, OHThe pilot's failure to verify that the landing gear was down and locked prior to landing.Nov 21, 2008 · N3640D · Substantial damageNTSB ERA09CA071Accident · No injuriesData collectionFinal reportCessna 172RG · Cleveland, MSThe pilot's failure to lower the landing gear prior to touchdown.Nov 19, 2008 · N941SM · Substantial damageNTSB ERA09IA056Incident · No injuriesIncident investigationFinal reportDeHavilland DHC-8-311 · Philadelphia, PAThe mechanical overload of the nosewheel steering links for undetermined reasons, which resulted in nose landing gear rotation and its subsequent wedging within the wheel well structure.Nov 16, 2008 · N326EN · Minor damageNTSB WPR09CA101Accident · No injuriesData collectionFinal reportBeech K35 · Port Townsend, WAThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident was the pilot's failure to use a checklist and the distraction caused by the discussion with the passenger.Nov 14, 2008 · N411B · Substantial damageNTSB CEN09CA058Accident · No injuriesData collectionFinal reportMooney M20E · San Antonio, TXThe failure of the pilot to lower the gear before landing. Contributing to the accident was the pilot's failure to complete the before landing checklist.Nov 11, 2008 · N1264X · Substantial damageNTSB CEN09IA057Incident · No injuriesIncident investigationFinal reportCessna T210N · Lubbock, TXAn unidentified anomaly within the airplane's electrical system. Contributing to the incident was the pilot's failure to manually extend the landing gear.Nov 9, 2008 · N6267Y · Minor damageNTSB ERA09LA050Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Lawrenceville, GAThe failure of the nose gear drag link bolt due to reversed bending fatigue.Nov 1, 2008 · N2214N · Substantial damageNTSB CEN09CA045Accident · No injuriesData collectionFinal reportHartter Lenny J Bearhawk · Mack, COThe collapse of the left main landing gear which resulted in the pilot's failure to maintain directional control.Nov 1, 2008 · N3119X · Substantial damage