# NTSB investigations: Cessna 172K, 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 ERA14LA158](https://openairdocs.org/ntsb/ERA14LA158.md): Cessna 172K · Elizabethton, TN · Accident · Minor injuries · Limited investigation · Final report · Mar 18, 2014 · N46603 · Substantial damage
  > The pilot’s delayed decision to maneuver around rising terrain, which resulted in a collision with trees and terrain. Contributing to the accident was the pilot’s failure to calculate the performance requirements needed to climb over mountainous terrain…
- [NTSB ATL07CA050](https://openairdocs.org/ntsb/ATL07CA050.md): Cessna 172K · Paris, TN · Accident · Minor injuries · Data collection · Final report · Mar 12, 2007 · N46588 · Substantial damage
  > The pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion.
- [NTSB ATL05LA031](https://openairdocs.org/ntsb/ATL05LA031.md): Cessna 172K · Smyrna, TN · Accident · No injuries · Limited investigation · Final report · Nov 29, 2004 · N78402 · Substantial damage
  > The pilot's inadequate preflight planning of fuel required for the flight, and his inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.
- [NTSB ATL05CA002](https://openairdocs.org/ntsb/ATL05CA002.md): Cessna 172K · Knoxville, TN · Accident · Serious injuries · Data collection · Final report · Oct 9, 2004 · N78211 · No damage
  > The pilot's failure to maintain airspeed on initial take off climb resulted in an inadvertent stall and an uncontrolled descent into the ground.
- [NTSB ATL03LA093](https://openairdocs.org/ntsb/ATL03LA093.md): Cessna 172K · Bristol, TN · Accident · Minor injuries · Limited investigation · Final report · May 15, 2003 · N7412G · Substantial damage
  > The pilot's improper use of the rudder controls during the takeoff roll resulting in a loss of directional control, and the on-ground collision with an embankment.
- [NTSB ATL96LA079](https://openairdocs.org/ntsb/ATL96LA079.md): Cessna 172K · Lebanon, TN · Accident · No injuries · Limited investigation · Final report · Apr 10, 1996 · N7479G · Substantial damage
  > the student pilot's failure to maintain directional control during landing.
- [NTSB ATL91LA175](https://openairdocs.org/ntsb/ATL91LA175.md): Cessna 172K · Greeneville, TN · Accident · No injuries · Limited investigation · Final report · Sep 15, 1991 · N78239 · 2 aircraft · Substantial damage
  > The inadequate visual lookout by the pilot of N78239, and his failure to accurately judge the distance between the two aircraft. Factors in the accident were the dark night conditions and the resulting visual perception of aircraft lighting in dark conditions.
- [NTSB IAD78FLT01](https://openairdocs.org/ntsb/IAD78FLT01.md): Cessna 172 · Covington, TN · Accident · Minor injuries · Closed · Oct 13, 1977 · N79322 · Substantial damage
- [NTSB IAD73FKW29](https://openairdocs.org/ntsb/IAD73FKW29.md): Cessna 172 · Crossville, TN · Accident · Serious injuries · Closed · Jun 28, 1973 · N84368 · Destroyed
- [NTSB MIA73AM040](https://openairdocs.org/ntsb/MIA73AM040.md): Cessna 172K · Oliver Spgs, TN · Accident · 3 fatal · Closed · Oct 13, 1972 · N79433 · Destroyed
- [NTSB MIA73FKW05](https://openairdocs.org/ntsb/MIA73FKW05.md): Cessna 182N · Gatlinburg, TN · Accident · No injuries · Closed · Aug 23, 1972 · N7265G · Substantial damage
- [NTSB MIA72FKW03](https://openairdocs.org/ntsb/MIA72FKW03.md): Cessna 172 · Gallatin, TN · Accident · No injuries · Closed · Aug 11, 1971 · N46531 · Substantial damage
- [NTSB MIA71FKW39](https://openairdocs.org/ntsb/MIA71FKW39.md): Cessna 172K · Oneida, TN · Accident · No injuries · Closed · Mar 6, 1971 · N79434 · 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 ('2072430'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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