NTSB investigations, 2018
23 cases where the defining event was Landing gear not configured.
Cases per year
| 2008 | 27 |
|---|---|
| 2009 | 17 |
| 2010 | 26 |
| 2011 | 23 |
| 2012 | 26 |
| 2013 | 20 |
| 2014 | 10 |
| 2015 | 16 |
| 2016 | 21 |
| 2017 | 26 |
| 2018 | 23 |
| 2019 | 27 |
| 2020 | 19 |
| 2021 | 26 |
| 2022 | 20 |
| 2023 | 28 |
| 2024 | 32 |
| 2025 | 42 |
| 2026 | 34 |
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\") = 2018
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '095')
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") = 2018 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '095') 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 GAA19CA046Accident · No injuriesData collectionFinal reportBeech 55 · Gainesville, FLThe pilot's inadvertent landing gear retraction during the landing roll, which resulted in a canted left main landing gear and the wing dragging during the subsequent landing following a go-around.NTSB GAA19CA032Accident · No injuriesData collectionFinal reportPiper PA24 · Madras, ORThe pilot’s failure to extend the landing gear, which resulted in an attempted go-around and subsequent pitchdown and impact with the runway.NTSB GAA19CA017Accident · No injuriesData collectionFinal reportCessna 177RG · Albermarle, NCThe pilot's improper decision to attempt a gear-up glide to the runway and his subsequent failure to extend the landing gear before landing. Contributing to the accident was the pilot's failure to use a checklist before landing.NTSB DCA18WA298Incident · No injuriesForeign investigationAirbus A320 · Sydney, AustraliaNTSB WPR18LA264Accident · No injuriesLimited investigationFinal reportCessna T210 · San Luis Obispo, CAThe failure of the landing gear extension motor due to wear, which resulted in the right main landing gear not fully extending and locking into place during landing. Contributing to the accident was the pilot’s failure to ensure that all three landing gear…NTSB GAA18WA585Accident · No injuriesForeign investigationPiper PA28R · Cuatro Vientos, Spain, SpainThe government of Spain has notified the NTSB of an accident involving a PIPER PA28R airplane that occurred on September 04, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions…NTSB GAA18CA531Accident · No injuriesData collectionFinal reportPiper PA44 · Centralia, ILThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to verify that the landing gear was extended before landing. Contributing to the accident was the flight instructor’s delayed remedial action and…NTSB GAA18CA540Accident · No injuriesData collectionFinal reportYakovlev YAK 52 · East Stroudsburg, PAThe pilot's failure to extend the landing gear during landing, which resulted in a runway excursion and subsequent impact with terrain.NTSB DCA18WA314Accident · No injuriesForeign investigationDe Havilland DHC8 · Callao, PeruThe Peru Comisión de Investigación de Accidentes Aviación ((CIAA) has notified the NTSB of an accident involving a De Havilland DHC8 that occurred on August 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA'S investigation…NTSB GAA18CA462Accident · No injuriesData collectionFinal reportPiper PA24 · Evanston, WYThe pilot's failure to extend the landing gear during landing. Contributing to the accident were the pilot's distraction and his failure to complete the appropriate checklist before landing.NTSB GAA18CA438Accident · No injuriesData collectionFinal reportMooney M20E · Great Falls, MTThe flight instructor’s incorrect use of the landing gear system and his and the pilot’s failure to ensure that the landing gear was extended, which resulted in a gear-up landing. Contributing to the accident was the flight instructor’s unfamiliarity with the…NTSB GAA18CA418Accident · No injuriesData collectionFinal reportPiper PA28R · Houston, TXThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to ensure that the landing gear were extended during landing. Contributing to the accident was the pilot receiving instruction's and instructor's failure…NTSB GAA18CA412Accident · No injuriesData collectionFinal reportBeech A36 · Spencer, IAThe pilot’s failure to extend the landing gear before landing. Contributing to the accident were the pilot’s failure to use the Before Landing checklist due to being distracted while communicating with other aircraft and controlling the airplane in the…NTSB WPR18LA209Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Fort Lauderdale, FLThe failure of the left starter relay, which resulted in a loss of electrical power during the flight and the failure of the T-handle from the cable led to a forced landing with the landing gear retracted.NTSB WPR18CA172Accident · No injuriesData collectionFinal reportDornier Alpha JET · Sacramento, CAThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s and the flight instructor’s failure to adequately monitor the workload.NTSB GAA18CA346Accident · No injuriesData collectionFinal reportPiper PA32R · Caddo Mills, TXThe student pilot’s failure to extend the landing gear before landing and to follow the Before Landing checklist, which resulted in an attempted go-around and subsequent hard landing.NTSB GAA18CA239Accident · No injuriesData collectionFinal reportBeech 76 · Vacaville, CAThe pilot under instruction’s failure to extend the landing gear and the flight instructor’s inadequate supervision and failure to ensure that the landing gear was extended.NTSB GAA18CA207Accident · No injuriesData collectionFinal reportPiper PA34 · San Diego, CAThe pilot receiving instruction and flight instructor’s failure to properly configure the landing gear before landing, which resulted in landing with the landing gear retracted.NTSB GAA18CA174Accident · No injuriesData collectionFinal reportCessna P210 · Jacksonville, FLThe pilot’s failure to extend the landing gear before landing. Contributing to the accident were pilot fatigue and his failure to use the before landing checklist.NTSB GAA18CA148Accident · No injuriesData collectionFinal reportHarris Pierce Velocity XL RG · Locust Grove, GAThe pilot’s failure to extend the landing gear due to his distraction by talking on the radio, which resulted in a gear-up landing.NTSB GAA18CA137Accident · No injuriesData collectionFinal reportBeech C90 · Montague, CAThe failure of pilot to extend the landing gear during landing.NTSB CEN18WA105Incident · No injuriesForeign investigationSikorsky S-92A · Shetland, United KingdomOn January 14, 2018, about 1413 universal time (UTC), a United Kingdom registered Sikorsky S-92A, G-CHHF, experienced a nose landing gear (NLG) anomaly during landing at Scatsta Airport, Shetland, United Kingdom. The NLG did not extend during the approach to…NTSB GAA18CA115Accident · No injuriesData collectionFinal reportCessna 210 · Sussex, NJThe pilot’s inadvertent landing gear retraction during approach.