# NTSB investigations, TN: Thunderstorm

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 ERA23FA219](https://openairdocs.org/ntsb/ERA23FA219.md): Cessna 182 · Reliance, TN · Accident · 1 fatal · Class 3 · Field · Final report · May 7, 2023 · N725AS · Substantial damage
  > The pilot’s decision to continue an instrument flight into an area of forecast weather with severe to extreme turbulence associated with a line of thunderstorms, which resulted in an in-flight breakup. Contributing was the pilot’s operation of the airplane in…
- [NTSB ERA16FA006](https://openairdocs.org/ntsb/ERA16FA006.md): Columbia Aircraft Mfg LC41 550FG · Erwin, TN · Accident · 2 fatal · Field investigation · Final report · Oct 9, 2015 · N1058S · Destroyed
  > The pilot's decision to fly into a known area of adverse weather, which resulted in the airplane entering a severe thunderstorm and a subsequent loss of control.
- [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.
- [NTSB ERA10MA188](https://openairdocs.org/ntsb/ERA10MA188.md): Eurocopter AS-350-B3 · Brownsville, TN · Accident · 3 fatal · Major investigation · Final report · Mar 25, 2010 · N855HW · Substantial damage
  > The pilot's decision to attempt the flight into approaching adverse weather, resulting in an encounter with a thunderstorm with localized instrument meteorological conditions, heavy rain, and severe turbulence that led to a loss of 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03033010'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/03033010/cases?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, except the copies of manufacturers’ service documents, which belong to their rights holders.
