# NTSB investigations, 1979, 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 IAD80DKW03](https://openairdocs.org/ntsb/IAD80DKW03.md): Piper PA-28 · Rockwood, TN · Accident · No injuries · Closed · Dec 18, 1979 · N29218 · Substantial damage
- [NTSB IAD80FA016](https://openairdocs.org/ntsb/IAD80FA016.md): Piper PA-23 · Knoxville, TN · Accident · 1 fatal · Closed · Dec 14, 1979 · N3242P · Destroyed
- [NTSB IAD80FLT03](https://openairdocs.org/ntsb/IAD80FLT03.md): Cessna 172 · Collierville, TN · Accident · No injuries · Closed · Dec 11, 1979 · N1184U · Substantial damage
- [NTSB IAD80DKW02](https://openairdocs.org/ntsb/IAD80DKW02.md): Callair A-9 · Greeneville, TN · Accident · No injuries · Closed · Nov 6, 1979 · N8267H · Substantial damage
- [NTSB IAD80FA007](https://openairdocs.org/ntsb/IAD80FA007.md): Mitsubishi MU-2F · Nashville, TN · Accident · 5 fatal · Closed · Nov 1, 1979 · N873Q · Destroyed
- [NTSB IAD80FKW01](https://openairdocs.org/ntsb/IAD80FKW01.md): Cessna 150 · Collegedale, TN · Accident · No injuries · Closed · Oct 25, 1979 · N714BM · Substantial damage
- [NTSB IAD80FLT01](https://openairdocs.org/ntsb/IAD80FLT01.md): Bayles Spec 1 · Jackson, TN · Accident · 2 fatal · Closed · Oct 13, 1979 · N8237E · Destroyed
- [NTSB IAD80FA002](https://openairdocs.org/ntsb/IAD80FA002.md): Mooney M20J · Pikeville, TN · Accident · 2 fatal · Closed · Oct 4, 1979 · N201YY · Destroyed
- [NTSB IAD79FKW21](https://openairdocs.org/ntsb/IAD79FKW21.md): Mooney M-20K · Benton, TN · Accident · Minor injuries · Closed · Sep 30, 1979 · N231C · Substantial damage
- [NTSB IAD79FKW20](https://openairdocs.org/ntsb/IAD79FKW20.md): Lake 4-200 · Nashville, TN · Accident · Minor injuries · Closed · Aug 30, 1979 · N6175V · Destroyed
- [NTSB IAD79FA067](https://openairdocs.org/ntsb/IAD79FA067.md): Benson R8M · Fayetteville, TN · Accident · 1 fatal · Closed · Aug 19, 1979 · N86531 · Destroyed
- [NTSB IAD79DLT06](https://openairdocs.org/ntsb/IAD79DLT06.md): Piper PA-24 · Mckenzie, TN · Accident · No injuries · Closed · Aug 4, 1979 · N5345P · Destroyed
- [NTSB IAD79DKW19](https://openairdocs.org/ntsb/IAD79DKW19.md): Champion 7FC · Whitebluff, TN · Accident · No injuries · Closed · Jul 28, 1979 · N7580E · Substantial damage
- [NTSB IAD79DKW18](https://openairdocs.org/ntsb/IAD79DKW18.md): Beech A35 · Greeneville, TN · Accident · Minor injuries · Closed · Jul 19, 1979 · N534B · Substantial damage
- [NTSB IAD79FKW17](https://openairdocs.org/ntsb/IAD79FKW17.md): Grumman G-164 · Crossville, TN · Accident · Minor injuries · Closed · Jul 16, 1979 · N740Y · Destroyed
- [NTSB IAD79FA062](https://openairdocs.org/ntsb/IAD79FA062.md): Cessna 402 · Clarksville, TN · Accident · No injuries · Closed · Jul 15, 1979 · N4009Q · 2 aircraft · Substantial damage
- [NTSB IAD79DKW16](https://openairdocs.org/ntsb/IAD79DKW16.md): Cessna A185 · Elizabethton, TN · Accident · No injuries · Closed · Jul 5, 1979 · N70083 · Substantial damage
- [NTSB IAD79DLT05](https://openairdocs.org/ntsb/IAD79DLT05.md): Piper PA-25 · Covington, TN · Accident · No injuries · Closed · Jun 21, 1979 · N7260Z · Substantial damage
- [NTSB IAD79FKW13](https://openairdocs.org/ntsb/IAD79FKW13.md): Cessna 177RG · Nashville, TN · Accident · No injuries · Closed · Jun 10, 1979 · N35647 · Substantial damage
- [NTSB IAD79FKW15](https://openairdocs.org/ntsb/IAD79FKW15.md): Piper PA-22 · Dunlap, TN · Accident · Minor injuries · Closed · Jun 6, 1979 · N8619C · Destroyed
- [NTSB IAD79FKW12](https://openairdocs.org/ntsb/IAD79FKW12.md): Mooney M-20E · Oak Ridge, TN · Accident · Serious injuries · Closed · May 28, 1979 · N1254X · Substantial damage
- [NTSB IAD79FKW14](https://openairdocs.org/ntsb/IAD79FKW14.md): Schleicher KA8B · Benton, TN · Accident · No injuries · Closed · May 26, 1979 · N170DR · Destroyed
- [NTSB IAD79DKW11](https://openairdocs.org/ntsb/IAD79DKW11.md): Cessna 172 · Cleveland, TN · Accident · No injuries · Closed · May 25, 1979 · N5052H · Substantial damage
- [NTSB IAD79FKW10](https://openairdocs.org/ntsb/IAD79FKW10.md): Taylorcraft F-19 · Elk Valley, TN · Accident · Minor injuries · Closed · May 24, 1979 · N3679T · Substantial damage
- [NTSB IAD79FA046](https://openairdocs.org/ntsb/IAD79FA046.md): Cessna 421 · Sevierville, TN · Accident · No injuries · Closed · May 4, 1979 · N123SM · Substantial damage
- [NTSB IAD79FKW09](https://openairdocs.org/ntsb/IAD79FKW09.md): Cessna 172 · Murfreesboro, TN · Accident · No injuries · Closed · Apr 26, 1979 · N20388 · Substantial damage
- [NTSB IAF79FLT04](https://openairdocs.org/ntsb/IAF79FLT04.md): Cessna 150 · Memphis, TN · Accident · No injuries · Closed · Apr 17, 1979 · N6099G · Substantial damage
- [NTSB IAD79FLT03](https://openairdocs.org/ntsb/IAD79FLT03.md): Grumman G-164 · Newbern, TN · Accident · No injuries · Closed · Apr 10, 1979 · N6604 · Substantial damage
- [NTSB IAD79FA042](https://openairdocs.org/ntsb/IAD79FA042.md): Cessna 175 · Livingston, TN · Accident · 2 fatal · Closed · Apr 1, 1979 · N6734E · Destroyed
- [NTSB IAD79FKW08](https://openairdocs.org/ntsb/IAD79FKW08.md): Piper PA-28 · Mcdonald, TN · Accident · Serious injuries · Closed · Mar 17, 1979 · N8517F · Substantial damage
- [NTSB IAD79FLT02](https://openairdocs.org/ntsb/IAD79FLT02.md): Piper PA-25 · Ridgely, TN · Accident · No injuries · Closed · Mar 9, 1979 · N4381Y · Substantial damage
- [NTSB IAD79FKW07](https://openairdocs.org/ntsb/IAD79FKW07.md): Piper PA-25 · Sparta, TN · Accident · No injuries · Closed · Mar 6, 1979 · N4390Y · Destroyed
- [NTSB IAD79AA034](https://openairdocs.org/ntsb/IAD79AA034.md): Beech 3NM · Memphis, TN · Accident · Minor injuries · Closed · Feb 24, 1979 · N12VT · 2 aircraft · Destroyed
- [NTSB IAD79FKW06](https://openairdocs.org/ntsb/IAD79FKW06.md): Cessna 150F · Bristol, TN · Accident · 2 fatal · Closed · Feb 20, 1979 · N8555G · Substantial damage
- [NTSB IAD79FKW05](https://openairdocs.org/ntsb/IAD79FKW05.md): Piper PA-22 · Gatlinburg, TN · Accident · Minor injuries · Closed · Feb 12, 1979 · N3649Z · Destroyed
- [NTSB IAD79FKW04](https://openairdocs.org/ntsb/IAD79FKW04.md): Cessna 310Q · Sevierville, TN · Accident · No injuries · Closed · Feb 6, 1979 · N377WB · Substantial damage
- [NTSB IAD79FA028](https://openairdocs.org/ntsb/IAD79FA028.md): Piper PA-32 · Paris, TN · Accident · Serious injuries · Closed · Jan 15, 1979 · N4815S · Destroyed
- [NTSB IAD79FKW03](https://openairdocs.org/ntsb/IAD79FKW03.md): Cessna 210 · Crossville, TN · Accident · Minor injuries · Closed · Jan 6, 1979 · N6911R · Destroyed

## 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") = 1979
  AND c."eventStateOrRegion" = 'TN' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?state=TN&year=1979

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