# NTSB investigations: Cessna 210H, TN

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 ATL96FA029](https://openairdocs.org/ntsb/ATL96FA029.md): Cessna 210H · Columbia, TN · Accident · 1 fatal · Field investigation · Final report · Jan 6, 1996 · N44DJ · Substantial damage
  > failure of the pilot to follow procedures/directives by flying in instrument meteorological conditions (IMC) without proper training/certification; and his failure (or inability) to follow proper IFR procedures and maintain proper altitude during an…
- [NTSB ATL89FA173](https://openairdocs.org/ntsb/ATL89FA173.md): Cessna 210H · Piney Flats, TN · Accident · 4 fatal · Field investigation · Final report · Jul 1, 1989 · N5939F · Destroyed
  > The pilot's failure to maintain control of the aircraft after becoming spatially disoriented, and his exceeding the design stress limits of the aircraft while attempting to recover from an uncontrolled descent. Factors related to the accident were: darkness,…
- [NTSB IAD76AI097](https://openairdocs.org/ntsb/IAD76AI097.md): Cessna 210 · Athens, TN · Accident · 2 fatal · Closed · Sep 5, 1976 · N6111F · Destroyed
- [NTSB NYC76AN069](https://openairdocs.org/ntsb/NYC76AN069.md): Cessna 210H · Dyersburg, TN · Accident · 1 fatal · Closed · Jan 25, 1976 · N5945F · Substantial damage
- [NTSB MIA71DKW49](https://openairdocs.org/ntsb/MIA71DKW49.md): Cessna 210 · Clarksville, TN · Accident · No injuries · Closed · May 2, 1971 · N6161F · Substantial damage

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2073436'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2073436&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.