NTSB investigations, 2015
16 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\") = 2015
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") = 2015 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 GAA16LA087Accident · No injuriesLimited investigationFinal reportPiper PA 31 · Clearwater, FLThe pilot's failure to extend the landing gear before landing.NTSB WPR15LA264Accident · Minor injuriesLimited investigationFinal reportDouglas A4N · Phoenix, AZThe pilot’s failure to extend the landing gear before landing. Contributing to the accident were the pilot’s distraction during the downwind leg and his difficulty seeing the landing gear indicators due to the sun angle and shadows.NTSB GAA15CA259Accident · No injuriesData collectionFinal reportCessna T210L · Soda Springs, IDThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing.NTSB GAA15CA222Accident · No injuriesData collectionFinal reportCessna A185F · Emily, MNThe pilot's failure to retract the landing gear, which resulted in a gear down water landing and a nose over.NTSB GAA15CA206Accident · No injuriesData collectionFinal reportCessna T210L · Duluth, MNThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing. Contributing to the accident was the pilot's diverted attention to another airplane in the vicinity and that he inaccurately…NTSB ERA15LA273Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Wilmington, NCThe pilot's failure to ensure that the landing gear was in the down and locked position before touchdown, which resulted in a landing with the gear in transit.NTSB WPR15LA202Accident · No injuriesLimited investigationFinal reportShort Bros SD3 60 · Kapolei, HIThe pilots’ failure to extend the landing gear before landing. Contributing to the accident was the pilots’ failure to complete the Before Landing checklist.NTSB GAA15CA121Accident · No injuriesData collectionFinal reportCessna P210N · Bozeman, MTThe pilot's failure to complete the required before landing checks, resulting in the execution of a gear up landing causing substantial damage to the lower fuselage of the airplane.NTSB GAA15CA124Accident · No injuriesData collectionFinal reportBeech D35 · Sunriver, ORThe pilot's failure to extend the landing gear, which resulted in substantial damage to the fuselage during landing. Contributing to the accident was the pilot's distraction from completing his before landing checklist and inability to hear the gear warning…NTSB ANC15CA027Accident · No injuriesData collectionFinal reportPiper PA 31-350 · Homer, AKThe pilot's failure to extend the landing gear before landing. Contributing to the accident was the pilot's decision to continue the approach to landing while distracted and his failure to complete the landing checklist.NTSB GAA15CA080Accident · No injuriesData collectionFinal reportPilatus PC12 - 45 · Crownpoint, NMThe pilot's failure to extend the landing gear before landing.NTSB ERA15LA202Accident · No injuriesLimited investigationFinal reportBeech D95 · Jacksonville, FLThe pilot's failure to properly configure the airplane for landing. Contributing to the accident were pilot fatigue, distraction, and complacency and the failure of the landing gear warning horn to sound for reasons that could not be determined based on the…NTSB CEN15LA219Accident · No injuriesLimited investigationFinal reportSocata TBM700 · Evart, MIThe pilot's failure to follow the Before Landing checklist and to extend the landing gear and the flight instructor’s inadequate supervision, which resulted in a gear-up landing.NTSB ERA15CA169Accident · No injuriesData collectionFinal reportBellanca 17 31A · Siler City, NCThe pilot's failure to ensure that the airplane's landing gear was down and locked prior to touchdown.NTSB ERA15LA161Accident · Serious injuriesLimited investigationFinal reportLanshe Aerospace Lake 250 · Fernandina Beach, FLThe pilot's failure to extend the landing gear during the approach, which resulted in a gear-up landing.NTSB WPR15CA112Accident · No injuriesData collectionFinal reportCessna T210 - L · The Dalles, ORThe pilot's failure to extend the landing gear prior to touch down. Contributing to the accident was the pilot's failure to utilize the pre-landing checklist.