NTSB investigations, 2014, TN
13 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\") = 2014
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") = 2014 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 ERA15FA066Accident · 1 fatalField investigationFinal reportPiper PA28 · Sommerville, TNThe noninstrument-rated pilot's improper decision to attempt visual flight in instrument meteorological conditions, which resulted in an in-flight loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s impaired…NTSB ERA15CA007Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Maryville, TNThe pilot/owner's failure to maintain a stabilized approach during the final leg of the traffic pattern. Contributing to the accident was both pilot's lack of aeronautical decision making.NTSB ERA15CA005Accident · No injuriesData collectionFinal reportHPH 304CZ · Pikeville, TNA loss of aerodynamic lift, which resulted in an off-airport landing and subsequent impact with a pole.NTSB ERA14FA461Accident · 1 fatalField investigationFinal reportEagle R&D Helicycle · Gallatin, TNThe pilot's decision to fly the improperly balanced helicopter at high speed and low altitude, which resulted in a loss of control and collision with terrain. Contributing to the accident were the pilot's depression and resulting degradation of executive…NTSB ERA14CA458Accident · No injuriesData collectionFinal reportBeech C90 · Oneida, TNThe pilot's failure to properly configure the rudder trim for takeoff and his failure to maintain directional control during a precautionary landing, which resulted in a runway excursion and collision with terrain.NTSB ERA14FA421Accident · 1 fatalField investigationFinal reportKlaas Development Lancair IV P · Ooltewah, TNThe inadequate torque of the propeller mounting bolts and inspection of the propeller, which resulted in the fatigue fracture of the bolts and a subsequent in-flight separation of the propeller assembly.NTSB ERA14LA409Accident · 1 fatalLimited investigationFinal reportCessna A188B · Middleton, TNThe pilot’s failure to see and avoid power lines during a low-level aerial application operation.NTSB ERA14FA399Accident · 1 fatalField investigationFinal reportAir Tractor AT-802A · Parsons, TNThe pilot’s failure to see and avoid trees during a low-level aerial application operation.NTSB ERA14CA357Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Lafollette, TNThe pilot's failure to maintain directional control during a go-around in gusty crosswind conditions.NTSB ERA14LA281Accident · Serious injuriesLimited investigationFinal reportBelew Marshall D II Steen Skybolt · Chapmansboro, TNThe pilot's failure to maintain airspeed while performing an emergency landing, which led to the airplane exceeding its critical angle-of-attack and experiencing a subsequent aerodynamic stall. Contributing to the accident was a partial loss of engine power…NTSB ERA14CA169Accident · No injuriesData collectionFinal reportCessna 172M · Knoxville, TNThe student pilot's failure to maintain directional control during the takeoff roll, which resulted in a collision with an obstacle.NTSB ERA14LA142Accident · No injuriesLimited investigationFinal reportCessna 172R · Jackson, TNA total loss of engine power due to maintenance personnel’s improper installation of the lower vacuum pump.NTSB ERA14FA112Accident · 4 fatalField investigationFinal reportGulfstream AM Corp Comm Div 690 · Bellevue, TNThe pilot's failure to maintain airspeed with one engine inoperative, which resulted in a loss of control while on approach. Contributing to the accident were airframe ice accumulation due to conditions conducive to icing and the loss of engine power on one…