NTSB investigations, 2014, TN

6 cases where the sequence of events included Loss of control in flight.

Cases per year

20082026
NTSB investigations, 2014, TN per year, 2008–2026: 80 cases
20083
20096
20106
20114
20125
20133
20146
20156
20163
20175
20182
20194
20202
20216
20224
20232
20247
20254
20262

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\" = '240' 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.

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…Dec 2, 2014 · N8607W · DestroyedNTSB 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…Sep 28, 2014 · N7062U · Substantial damageNTSB 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.Aug 20, 2014 · N802BB · Substantial damageNTSB ERA14CA357Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Lafollette, TNThe pilot's failure to maintain directional control during a go-around in gusty crosswind conditions.Jul 24, 2014 · N8159Z · Substantial damageNTSB 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…Jun 8, 2014 · N863SB · DestroyedNTSB 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…Feb 3, 2014 · N840V · Destroyed