# NTSB investigations: Cessna 182B, 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 MIA97LA241](https://openairdocs.org/ntsb/MIA97LA241.md): Cessna 182B · Paris, TN · Accident · No injuries · Limited investigation · Final report · Sep 7, 1997 · N2794G · Substantial damage
  > Temporary loss of engine power for undetermined reasons res ulting in a forced landing on unsuitable terrain.
- [NTSB MIA97LA127](https://openairdocs.org/ntsb/MIA97LA127.md): Cessna 182B · Tullahoma, TN · Accident · Serious injuries · Limited investigation · Final report · Apr 10, 1997 · N2515G · Substantial damage
  > Fuel exhaustion for undetermined reasons and unsuitable terrain encountered during the forced landing. Contributing to the accident was the failure of the pilot to divert to an alternate airport while en route after recognizing that the fuel consumed was…
- [NTSB MIA73AM077](https://openairdocs.org/ntsb/MIA73AM077.md): Cessna 182B · Townsend, TN · Accident · 3 fatal · Closed · Jan 27, 1973 · N7295E · Destroyed
- [NTSB MIA73DKW13](https://openairdocs.org/ntsb/MIA73DKW13.md): Cessna 182B · Gainesboro, TN · Accident · Minor injuries · Closed · Dec 12, 1972 · N2491G · Substantial damage
- [NTSB MIA67D0506](https://openairdocs.org/ntsb/MIA67D0506.md): Cessna 182 · Tullahoma, TN · Accident · No injuries · Closed · Apr 21, 1967 · N2285G · Substantial damage
- [NTSB UNK65X0120](https://openairdocs.org/ntsb/UNK65X0120.md): Cessna 182 · Celina, TN · Accident · No injuries · Closed · Oct 3, 1964 · N7222E · 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 ('2072706'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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