NTSB investigations
585 cases where the sequence of events included Landing gear not configured.
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '095' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '095' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN18LA086Accident · No injuriesLimited investigationFinal reportSwearingen SA227 TT · Houston, TXThe failure of the left starter relay during engine start, which resulted in a loss of electrical and battery power during the flight and led to a forced landing with the nose landing gear not fully extended, causing substantial damage to the engines.NTSB WPR18LA058Accident · No injuriesLimited investigationFinal reportCessna 210 · San Bernardino, CAThe fatigue failure of the left main landing gear (MLG) saddle, which resulted in the pilot's inability to extend the left MLG. Contributing to the accident was the pilot's improper decision to fly the airplane before the annual inspection was completed and…NTSB ERA18LA058Accident · No injuriesLimited investigationFinal reportMooney M20K · Venice, FLA failure of the normal landing gear extension system for reasons that could not be determined due to damage to the system and the pilot's failure to ensure that the landing gear was down and locked before touchdown. Contributing to the accident was the…NTSB CEN18LA048Accident · No injuriesLimited investigationFinal reportPiper PA 31-310 · Jeffersonville, INThe right main landing gear’s failure to fully extend for reasons that could not be determined because postaccident testing revealed no mechanical anomalies that would have precluded normal operation.NTSB ANC18LA005Accident · No injuriesLimited investigationFinal reportRaytheon B200 · Anchorage, AKThe pilot's failure to extend the landing gear before landing, which resulted in a gear-up landing. Contributing to the accident was the pilot's fatigue and complacency.NTSB ENG18RA009Accident · No injuriesForeign investigationDe Havilland DHC8 · Belfast, IrelandThe UK AAIB has notified the NTSB of an accident involving a Bombardier DHC-8-402, which occurred on October 11, 2017. The crew diverted to Belfast International Airport and landed with the nose landing gear retracted. The NTSB has appointed a U.S. Accredited…NTSB WPR17LA217Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Los Angeles, CAThe pilot's failure to extend the landing gear before landing.NTSB GAA17CA543Accident · No injuriesData collectionFinal reportCessna T210 · St George, UTThe pilot’s failure to extend the landing gear before landing.NTSB CEN17LA352Accident · No injuriesLimited investigationFinal reportCessna 210G · Hallsville, MOThe total loss of engine power due to a fatigue failure of the engine mixture control cable.NTSB CEN17WA379Incident · No injuriesForeign investigationCessna 172RG · Balchik, BulgariaOn August 21, 2017, at 1150 coordinated universal time, a Cessna 172RG, Bulgarian registration LZ-SPD, operated by Aviootryad Varna Ltd, collided with the runway during a gear-up landing at the Balchik Airfield (LBWB), Balchik, Bulgaria. The pilot and…NTSB ERA17LA287Accident · No injuriesLimited investigationFinal reportCessna R182 · Clearwater, FLThe improper maintenance of the landing gear system and subsequent failure of the hydraulic landing gear down return line, which resulted in a loss of hydraulic fluid and the pilot’s inability to extend and lock the main landing gear.NTSB GAA17CA483Accident · No injuriesData collectionFinal reportRockwell International 114 · Cairo, ILThe pilot's failure to extend the landing gear before landing, which resulted in a gear-up landing and a runway overrun.NTSB GAA17CA481Accident · No injuriesData collectionFinal reportMooney M20C · Clearwater, FLThe pilot’s distraction before landing by a helicopter that was transitioning to the airport and his subsequent failure to extend the landing gear before touchdown.NTSB GAA17CA457Accident · No injuriesData collectionFinal reportSwearingen SA26 · Hondo, TXThe pilot’s failure to extend the landing gear before landing.NTSB GAA17CA425Accident · No injuriesData collectionFinal reportPiper PA28R · Bowling Green, OHThe pilot’s and flight instructor’s failure to extend the landing gear.NTSB GAA17CA409Accident · No injuriesData collectionFinal reportProgressive Aerodyne Searey LSA · Spicewood, TXThe pilot’s failure to retract the landing gear before landing on water.NTSB ERA17CA236Accident · Serious injuriesData collectionFinal reportProgressive Aerodyne Searey LSA · Lake Ashby, FLThe pilot's incorrect configuration of the landing gear for a water landing in an amphibious airplane, which resulted in a nose-over.NTSB GAA17CA423Accident · No injuriesData collectionFinal reportCessna T210L · Yuba City, CAThe pilot’s failure to extend the landing gear before landing.NTSB GAA17CA418Accident · No injuriesData collectionFinal reportPiper PA32 · San Antonio, TXThe pilot’s failure to extend the landing gear before touchdown.NTSB GAA17CA372Accident · No injuriesData collectionFinal reportCessna 172RG · El Cajon, CAThe pilot's failure to extend the landing gear with sufficient time to allow the landing gear to fully extend and the flight instructor's failure to visually check to see if the right main landing gear were extended.NTSB CEN17LA212Accident · No injuriesLimited investigationFinal reportCessna 210F · Anoka, MNThe failure of the landing gear to fully extend due to insufficient hydraulic fluid in the hydraulic system as a result of inadequate maintenance by the airplane owner.NTSB ERA17LA189Accident · No injuriesLimited investigationFinal reportBeech 58 · Augusta, GAThe pilot’s failure to properly configure the airplane for landing. Contributing to the accident were the pilot’s fatigue and self-induced distractions.NTSB ERA17LA188Accident · Minor injuriesLimited investigationFinal reportMaule M7 · Colton, NYThe pilots' initiation of an uncoordinated right turn with the fuel selector positioned to the right main fuel tank, which had a low quantity of fuel in it and resulted in a total loss of engine power due to the unporting of the fuel and subsequent fuel…NTSB WPR17LA104Accident · Minor injuriesClass 3 · LimitedFinal reportEvolution Air Lancair Evolution · Firebaugh, CAA failure in the windshield, frame, or windshield-to-frame bond, which resulted in a rapid decompression during cruise flight.NTSB GAA17WA582Accident · No injuriesClass 5 · ForeignPiper PA 46-350P · Nyíregyháza, HungaryNTSB GAA17CA233Accident · No injuriesData collectionFinal reportPiper PA 34 · Llano, TXThe pilot’s complacency during the en route phase of flight, which resulted in fuel mismanagement and a subsequent gear-up landing.NTSB WPR17IA086Incident · No injuriesClass 3 · IncidentFinal reportBeech A36TC · Livermore, CAA mistrim condition while the autopilot was engaged for reasons that could not be determined based on available evidence, and the pilot’s subsequent failure to confirm the command bar status before disengaging the autopilot. Contributing to the accident were…NTSB ERA17LA151Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Atlanta, GAThe pilot's diverted attention during the landing approach, which resulted in his failure to configure the landing gear and a subsequent a gear-up landing.NTSB GAA17CA221Accident · No injuriesData collectionFinal reportCessna P210 · Granby, COThe pilot's failure to extend the landing gear before landing.NTSB ERA17LA134Accident · No injuriesClass 3 · LimitedFinal reportBeech 95B55 · Islip, NYThe pilot's failure to lower the landing gear before touchdown, which resulted in the gear-up landing.NTSB GAA17CA197Accident · No injuriesData collectionFinal reportCessna R182 · Colorado Springs, COThe pilot’s failure to complete the landing checklist and to extend the landing gear before touchdown.NTSB WPR17LA076Accident · No injuriesLimited investigationFinal reportPiper Aerostar 602P · Reno, NVThe failure of the left main landing gear to fully extend for reasons that could not be determined because postaccident examination and testing did not reveal any evidence of preimpact mechanical failures or malfunctions that would have precluded normal…NTSB WPR17LA061Accident · No injuriesClass 3 · LimitedFinal reportBeech 95 B55 (T42A) · Cameron Park, CAFailure of the landing gear to extend as a result of excessive wear within the landing gear gearbox and motor, which resulted in a gear-up landing.NTSB ERA17LA105Accident · No injuriesLimited investigationFinal reportS C Aerostar S A YAK 52 · St. Elmo, ALThe failure of the right main landing gear uplock actuator due to corrosion.NTSB ERA17LA096Accident · No injuriesLimited investigationFinal reportBeech 200 · West Palm Beach, FLThe pilot's failure to ensure that the landing gear were down and locked before touchdown. Contributing to the accident was the pilot’s self-reported fatigue at the time of the accident.NTSB GAA17CA126Accident · No injuriesData collectionFinal reportPiper PA32R · Fort Mohave, AZThe pilot's failure to extend the landing gear for landing.NTSB CEN17LA091Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Delta, COThe failure of the landing gear to extend during landing approach due to the interference between the landing gear motor's sector and worm gears.NTSB WPR17LA032Accident · Minor injuriesLimited investigationFinal reportHoskins Lonnie F Velocity XL RG · Petaluma, CAThe pilot’s failure to maintain adequate airspeed during an aborted landing, which resulted in an exceedance of the airplane’s critical angle of attack and an inadvertent aerodynamic stall. Contributing to the accident was the pilot’s distraction while on…NTSB ANC17LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-300 · McGrath, AKThe failure of the nose landing gear to extend and lock due to the failure of the alternator and reduced battery power due to the cold ambient temperature, which prohibited the electrically-driven hydraulic pump from supplying adequate hydraulic pressure to…NTSB GAA17CA074Accident · No injuriesData collectionFinal reportRaytheon 58 · Lancaster, PAA collision with deer on the runway during the takeoff roll.NTSB GAA17CA031Accident · No injuriesData collectionFinal reportBellanca 17 30 · Burnet, TXThe pilot’s decision to continue the unstabilized approach and his failure to extend the landing gear before landing.NTSB GAA17CA023Accident · No injuriesData collectionFinal reportNorth American Navion · Palmer, AKThe pilot's failure to extend the landing gear for landing.NTSB DCA16CA226Accident · No injuriesData collectionFinal reportBombardier DHC 8 202 · Dulles, VAincorrect installation of the frangible towing fuse that prevented the nose landing gear from extending.NTSB GAA16CA506Accident · No injuriesData collectionFinal reportNew Piper PA-28R · East St. Louis, ILThe pilot's failure to extend the landing gear, which resulted in a gear-up landing.NTSB WPR16LA187Accident · No injuriesLimited investigationFinal reportJurcan Seawind 3000 · Renton, WAThe failure of the landing gear system to either fully retract or extend due to a cracked hydraulic fitting flare, which resulted in the loss of hydraulic pressure.NTSB GAA16CA509Accident · Minor injuriesData collectionFinal reportGrumman G44 · Lakeport, CAThe pilot's failure to retract the landing gear, which resulted in a gear-down water landing and a nose over.NTSB GAA16CA519Accident · No injuriesData collectionFinal reportBeech G35 · Kooskia, IDThe pilot’s failure to extend the landing gear during landing.NTSB ERA16WA342Accident · No injuriesForeign investigationCessna 172RG · Amalfi, ItalyThe government of Italy has notified the NTSB of an accident involving a Cessna Aircraft Company 172RG airplane that occurred on September 07, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation…NTSB CEN16LA336Accident · No injuriesLimited investigationFinal reportBeech E-55 · Wichita Falls, TXThe failure of the landing gear assembly snap ring, which prevented the pilot from being able to extend the landing gear and resulted in a gear-up landing. Also causal was the lack of the assembly's overhaul in accordance with the airplane maintenance manual.NTSB WPR16FA154Accident · 1 fatalField investigationFinal reportSperling Richard G Lancair 360 · The Dalles, ORThe pilot's loss of control during an aborted landing. Contributing to the accident was the pilot's failure to extend the landing gear before touchdown.