# NTSB investigations: Cessna 182A, 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 ATL99LA080](https://openairdocs.org/ntsb/ATL99LA080.md): Cessna 182 · Murfreesboro, TN · Accident · No injuries · Limited investigation · Final report · May 2, 1999 · N6382B · Substantial damage
  > The pilot's misjudgment of altitude and distance to the runway.
- [NTSB ATL85LA163](https://openairdocs.org/ntsb/ATL85LA163.md): Cessna 182A · Dover, TN · Accident · No injuries · Limited investigation · Final report · May 9, 1985 · N3937D · Substantial damage
  > The student plt and his pax, a private plt, flew to another arpt and made several takeoffs and landings. Then returned to the private airstrip where their flight had originated. The student plt was at the controls on this apch. After touchdown the acft became…
- [NTSB IAD76FLT19](https://openairdocs.org/ntsb/IAD76FLT19.md): Cessna 182A · Covington, TN · Accident · No injuries · Closed · Sep 5, 1976 · N2141G · Substantial damage
- [NTSB IAD76DKW25](https://openairdocs.org/ntsb/IAD76DKW25.md): Cessna 182 · Madisonville, TN · Accident · No injuries · Closed · Mar 28, 1976 · N3941D · Substantial damage
- [NTSB IAD75FLT11](https://openairdocs.org/ntsb/IAD75FLT11.md): Cessna 182A · Covington, TN · Accident · No injuries · Closed · May 24, 1975 · N6063B · Substantial damage
- [NTSB IAD75DKW10](https://openairdocs.org/ntsb/IAD75DKW10.md): Cessna 182 · Greeneville, TN · Accident · Minor injuries · Closed · Mar 1, 1975 · N9940T · Substantial damage
- [NTSB MIA71DKW19](https://openairdocs.org/ntsb/MIA71DKW19.md): Cessna 182 · Madisonville, TN · Accident · No injuries · Closed · Nov 7, 1970 · N4996D · Substantial damage
- [NTSB MIA71DKW14](https://openairdocs.org/ntsb/MIA71DKW14.md): Cessna 182 · Gainsboro, TN · Accident · No injuries · Closed · Oct 18, 1970 · N4732D · Substantial damage
- [NTSB MIA66D0517](https://openairdocs.org/ntsb/MIA66D0517.md): Cessna 182 · Shelbyville, TN · Accident · No injuries · Closed · Apr 22, 1966 · N6302B · 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 ('2072704'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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