# Fatal NTSB investigations, 2008: Turbulence encounter

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 ERA09FA029](https://openairdocs.org/ntsb/ERA09FA029.md): Piper PA-24 · Red Hill, VA · Accident · 2 fatal · Field investigation · Final report · Oct 24, 2008 · N8820P · Destroyed
  > The pilot's failure to maintain aircraft control due to an improper repair to the stabilator, which resulted in an in-flight failure of the stabilator. Contributing to the accident was the descent in turbulence, at airspeeds above the maximum structural…
- [NTSB NYC08FA180](https://openairdocs.org/ntsb/NYC08FA180.md): Piper PA-32-260 · Cruso, NC · Accident · 2 fatal · Field investigation · Final report · May 12, 2008 · N64FP · Destroyed
  > The pilot's inadequate preflight planning and inadvertent flight into instrument meteorological conditions with moderate to severe turbulence prevailing. Contributing to the accident were the instrument meteorological conditions and turbulence.
- [NTSB DFW08FA080](https://openairdocs.org/ntsb/DFW08FA080.md): Cessna T210M · Abbeville, LA · Accident · 2 fatal · Field investigation · Final report · Mar 11, 2008 · N732RR · Destroyed
  > The pilot's failure to maintain aircraft control for undetermined reasons. Contributing to the accident were the prevailing clouds, rain, and turbulence.

## 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 year(c."eventDate") = 2008
  AND c."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '360' 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/360/sequence?fatal=1&year=2008

---
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.
