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 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.NTSB 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.NTSB 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.NTSB CEN09LA285Accident · Serious injuriesLimited investigationFinal reportRockwell International 112A · Metropolis, ILA total loss of engine power for undetermined reasons.NTSB ERA09IA267Incident · No injuriesIncident investigationFinal reportCessna 402C · Nantucket, MAInstallation of an improper bearing in the landing gear actuator.NTSB CEN09CA268Accident · No injuriesData collectionFinal reportLuscombe 8 · Terrell, TXThe failure of the landing gear due to undetected corrosion.NTSB 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.NTSB 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.NTSB ERA09CA254Accident · Minor injuriesData collectionFinal reportAmerican Longevity Searey · Littleton, NCThe pilot's failure to ensure the landing gear was properly configured for the water landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN09CA244Accident · No injuriesData collectionFinal reportMooney M20J · Salem, INThe pilot's failure to follow the landing checklist and extended the landing gear.NTSB WPR09LA171Accident · No injuriesLimited investigationFinal reportCessna 550 · Salt Lake City, UTThe uncommanded retraction of the right main landing gear hydraulic actuator strut for undetermined reasons.NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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.NTSB ERA09LA209Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lumberton, MSCollapse of the landing gear due to worn left main landing gear components.NTSB 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.NTSB CEN09LA197Accident · No injuriesLimited investigationFinal reportNeland Richard L Daytona SU · Guymon, OKFailure of the left main landing gear shock/strut during takeoff for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB WPR09LA083Accident · No injuriesLimited investigationFinal reportCessna 172RG · Carson City, NVThe overload failure of the landing gear actuator at an undetermined time.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CEN09CA084Accident · No injuriesData collectionFinal reportRockwell International 114 · Meacham Int'l Airport, TXThe pilot's failure to maintain pitch control during landing.NTSB CEN09CA156Accident · No injuriesData collectionFinal reportRockwell International 500-S · Grand Forks, NDThe pilot's failure to extend the landing gear prior to touchdown.NTSB 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.NTSB 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.NTSB ERA09CA071Accident · No injuriesData collectionFinal reportCessna 172RG · Cleveland, MSThe pilot's failure to lower the landing gear prior to touchdown.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ERA09LA050Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Lawrenceville, GAThe failure of the nose gear drag link bolt due to reversed bending fatigue.NTSB 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.