NTSB investigations, TN
10 cases where the sequence of events included Landing gear not configured.
Cases per year
| 2010 | 2 |
|---|---|
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2024 | 1 |
| 2025 | 2 |
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 c.\"eventStateOrRegion\" = 'TN' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'TN' AND c."eventCountry" = 'USA' 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 ERA25LA351Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Smyrna, TNThe pilot’s failure to extend the landing gear before landing.NTSB ERA25LA135Accident · Minor injuriesClass 4 · LimitedFinal reportIcon A5 · Smithville, TNThe pilot’s failure to retract the landing gear prior to landing in water. Contributing to the accident was the pilot’s failure to use the manufacturer’s provided checklist.NTSB ERA24LA155Accident · Minor injuriesClass 4 · LimitedFinal reportSouth Central Searey · Knoxville, TNThe pilot’s failure to retract the landing gear of the amphibious airplane prior to a water landing.NTSB ERA19LA239Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Chattanooga, TNThe improper maintenance of the airplane’s landing gear system, which resulted in a hydraulic fluid leak and insufficient pressure to extend and lock the landing gear during the accident flight.NTSB ERA16FA188Accident · 1 fatalField investigationFinal reportBeech D35 · Sevierville, TNThe pilot's failure to properly configure the landing gear and the pilot's inappropriate decision to abort the landing after the propeller had contacted the runway, which resulted in a loss of thrust and a subsequent loss of control of the airplane.NTSB ERA15LA333Accident · No injuriesLimited investigationFinal reportBeech E 90 · Fayetteville, TNA total loss of electrical power for reasons that could not be determined and the pilot's subsequent failure to properly follow the manual landing gear extension procedures, which resulted in the landing gear not extending.NTSB ERA14CA276Accident · Minor injuriesData collectionFinal reportSwearingen SA 226AT · Dayton, TNThe pilot's failure to extend the landing gear during the approach, which resulted in a gear-up landing.NTSB ERA12LA299Accident · No injuriesLimited investigationFinal reportCessna 210 · Gatlinburg, TNFailure of the nose landing gear down pressure hose, which resulted in the main landing gear being unable to lock and collapse of the main landing gear during the landing roll.NTSB ERA10CA201Accident · No injuriesData collectionFinal reportBeech 95-B55 (T42A) · Sevierville, TNThe pilot's inadvertent retraction of the landing gear on the ground during a touch-and-go landing.NTSB ERA10CA132Accident · No injuriesData collectionFinal reportSocata TBM 700 · Memphis, TNThe pilot’s failure to extend the landing gear before landing.