NTSB investigations, 2016, TN
15 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 9 |
| 2010 | 10 |
| 2011 | 13 |
| 2012 | 19 |
| 2013 | 9 |
| 2014 | 13 |
| 2015 | 16 |
| 2016 | 15 |
| 2017 | 7 |
| 2018 | 8 |
| 2019 | 13 |
| 2020 | 9 |
| 2021 | 6 |
| 2022 | 8 |
| 2023 | 5 |
| 2024 | 11 |
| 2025 | 6 |
| 2026 | 1 |
Where
Latest 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\") = 2016
AND 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\" = '470' 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") = 2016 AND 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" = '470' 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 GAA17CA105Accident · No injuriesData collectionFinal reportPiper PA 46 · Nashville, TNThe pilot’s loss of directional control during the aborted landing in gusting crosswind conditions, which resulted in a runway excursion.NTSB GAA17CA096Accident · No injuriesData collectionFinal reportPiper PA28 · Madisonville, TNThe student pilot’s failure to maintain directional control during landing with a gusting crosswind.NTSB ERA17CA012Accident · Minor injuriesData collectionFinal reportBellanca 8KCAB · Knoxville, TNThe pilot's intentional low-altitude operation, which resulted in his failure to maintain clearance from unmarked utility wires.NTSB ERA17LA019Accident · No injuriesLimited investigationFinal reportCessna 182 · Toone, TNA stuck No. 3 cylinder exhaust valve, which resulted in failure of the cylinder's valvetrain components, breach of the cylinder's rocker box cover, and partial loss of engine power due to oil starvation.NTSB ERA16LA320Accident · No injuriesLimited investigationFinal reportBeech B100 · Jackson, TNThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA16CA438Accident · No injuriesData collectionFinal reportCessna A185 · Fayetteville, TNThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a runway excursion and a ground loop.NTSB ERA16LA272Accident · No injuriesLimited investigationFinal reportHarrity William V Glasair (SH2F) · Maynardville, TNThe in-flight failure of the No. 3 cylinder connecting rod for reasons that could not be determined during postaccident examination.NTSB ERA16LA228Accident · Serious injuriesLimited investigationFinal reportAmerican AA1 · Knoxville, TNThe pilot's failure to maintain directional control during the landing roll in a quartering headwind.NTSB ERA16LA226Accident · Serious injuriesLimited investigationFinal reportRockwell International 112A · Dayton, TNA total loss of engine power due to the failure of the engine-driven fuel pump.NTSB ERA16FA208Accident · 3 fatalField investigationFinal reportMooney M20E · Collegedale, TNThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack while maneuvering after a go-around, which resulted in an aerodynamic stall.NTSB ERA16LA191Accident · Minor injuriesLimited investigationFinal reportSikes Zenith CH750 Stol · Lawrenceburg, TNThe pilot's failure to perform an adequate preflight inspection, which resulted in a loss of control due to an improperly-rigged rudder. Contributing to the accident was the pilot's failure to implement and follow proper flight-testing plans.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 ERA16FA144Accident · 5 fatalField investigationFinal reportBell 206 · Pigeon Forge, TNAn inflight loss of engine power due to a failure of the engine fuel pump, which resulted in a collision with trees and terrain during the subsequent autorotation. The failure of the engine fuel pump resulted from the absence of adequate grease leading to…NTSB ERA16LA090Accident · No injuriesLimited investigationFinal reportBeech A23 · Kingston, TNThe pilot's inadequate preflight inspection and fuel planning and his improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA16FA084Accident · 1 fatalField investigationFinal reportEros 1600 · Lebanon, TNA failure of the front cylinder piston due to the pilot's improper maintenance, which resulted in a total loss of engine power after takeoff. Contributing to the accident was the pilot's decision to return to the runway at low altitude following the loss of…