NTSB investigations, 2017
36 cases where the sequence of events included Landing gear not configured.
Cases per year
| 2008 | 32 |
|---|---|
| 2009 | 27 |
| 2010 | 29 |
| 2011 | 30 |
| 2012 | 34 |
| 2013 | 27 |
| 2014 | 17 |
| 2015 | 24 |
| 2016 | 28 |
| 2017 | 36 |
| 2018 | 32 |
| 2019 | 35 |
| 2020 | 22 |
| 2021 | 31 |
| 2022 | 25 |
| 2023 | 37 |
| 2024 | 39 |
| 2025 | 47 |
| 2026 | 33 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2017
AND 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 year(c."eventDate") = 2017 AND 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 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.