# NTSB investigations: Cessna 172L, 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 ERA22LA103](https://openairdocs.org/ntsb/ERA22LA103.md): Cessna 150G · Knoxville, TN · Accident · No injuries · Class 4 · Limited · Final report · Jan 8, 2022 · N1308U · 2 aircraft · Substantial damage
  > The pilot of the Cessna 150’s failure to avoid the taxiing Cessna 172.
- [NTSB GAA18CA428](https://openairdocs.org/ntsb/GAA18CA428.md): Cessna 172 · Nashville, TN · Accident · No injuries · Data collection · Final report · Jul 17, 2018 · N7880G · Substantial damage
  > The pilot's improper landing flare, which resulted in a bounced landing.
- [NTSB GAA17CA329](https://openairdocs.org/ntsb/GAA17CA329.md): Cessna 172 · Nashville, TN · Accident · No injuries · Data collection · Final report · Jun 8, 2017 · N4284Q · Substantial damage
  > The pilot’s failure to maintain directional control during the landing roll.
- [NTSB ATL06CA084](https://openairdocs.org/ntsb/ATL06CA084.md): Cessna 172L · Lexington, TN · Accident · No injuries · Data collection · Final report · May 23, 2006 · N7624G · Substantial damage
  > The pilot's failure to attain the proper touchdown point during landing.
- [NTSB ATL95LA063](https://openairdocs.org/ntsb/ATL95LA063.md): Cessna 172L · Smyrna, TN · Accident · Serious injuries · Limited investigation · Final report · Mar 10, 1995 · N4383Q · No damage
  > The flight instructor's failure to ensure that the magnetos were not energized prior to positioning the propeller, and the dual student's failure to place the ignition switch in the off position after the first start attempt.
- [NTSB ATL88LA216](https://openairdocs.org/ntsb/ATL88LA216.md): Cessna 172L · Michie, TN · Accident · Serious injuries · Limited investigation · Final report · Jul 14, 1988 · N19632 · Substantial damage
  > Witness reported that the airplane engine was running rough during takeoff; the airplane subsequently disappeared from sight in a nose-down attitude. The plt later reported that he could not remember the events that led up to the power loss. Post-crash exam…
- [NTSB IAD75DKW05](https://openairdocs.org/ntsb/IAD75DKW05.md): Cessna 172 · Cleveland, TN · Accident · Minor injuries · Closed · Nov 5, 1974 · N2888Q · 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 ('2072432'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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