# NTSB investigations, TN: Structural icing

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ERA24FA176](https://openairdocs.org/ntsb/ERA24FA176.md): Piper PA-32R-301 · Knoxville, TN · Accident · 1 fatal · Class 3 · Field · Final report · Apr 12, 2024 · N9236J · Destroyed
  > The pilot’s decision to depart into an area of instrument meteorological and icing conditions, which resulted in loss of airplane control and a subsequent in-flight breakup.
- [NTSB DCA14FA058](https://openairdocs.org/ntsb/DCA14FA058.md): Embraer EMB145 - EP · Memphis, TN · Accident · No injuries · Class 3 · Field · Final report · Feb 5, 2014 · N802HK · Substantial damage
  > the failure of the flight crew to adequately monitor the system for proper operation and manually activate the system during the flight in icing conditions. Contributing to the accident was the crew's limited training on the manual operation of the anti-ice…
- [NTSB ERA14FA112](https://openairdocs.org/ntsb/ERA14FA112.md): Gulfstream AM Corp Comm Div 690 · Bellevue, TN · Accident · 4 fatal · Field investigation · Final report · Feb 3, 2014 · N840V · Destroyed
  > The 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…
- [NTSB ERA11LA344](https://openairdocs.org/ntsb/ERA11LA344.md): Beech A100 · Gray, TN · Accident · No injuries · Limited investigation · Final report · Jun 15, 2011 · N15L · Substantial damage
  > An encounter with convectively-induced turbulence and icing, which resulted in an in-flight upset and a loss of airplane control.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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" = '210' 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
```

This list as a web page: https://openairdocs.org/ntsb-events/210/sequence?state=TN

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.