# NTSB investigations: Cessna 172I, 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 ERA25LA138](https://openairdocs.org/ntsb/ERA25LA138.md): Cessna 172I · Knoxville, TN · Accident · No injuries · Class 4 · Limited · Final report · Mar 3, 2025 · N35411 · Substantial damage
  > The student pilot’s failure to maintain clearance from a truck while taxiing.
- [NTSB ERA12LA148](https://openairdocs.org/ntsb/ERA12LA148.md): Cessna 172I · Springfield, TN · Accident · No injuries · Limited investigation · Final report · Jan 19, 2012 · N35571 · Substantial damage
  > The pilot did not apply carburetor heat during approach to landing, which resulted in a total loss of engine power due to carburetor icing.
- [NTSB ATL86FLT03](https://openairdocs.org/ntsb/ATL86FLT03.md): Cessna 172I · Millington, TN · Accident · Minor injuries · Final report · Nov 3, 1985 · N35469 · Substantial damage
  > The acft collaped the nose lndg bear during a forced lndg after the engine failed during takeoff. During post ace eng exam the wires disconnected from the magneto switch. The wires were resting on the 'p' leads. The fastening screw found on the bottom of the…
- [NTSB MIA71FKW42](https://openairdocs.org/ntsb/MIA71FKW42.md): Cessna 172 · New Tazewell, TN · Accident · No injuries · Closed · Mar 27, 1971 · N35469 · Substantial damage
- [NTSB MIA69D0209](https://openairdocs.org/ntsb/MIA69D0209.md): Cessna 172 · Raleigh, TN · Accident · Minor injuries · Closed · Oct 27, 1968 · N35534 · 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 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 ('2072426'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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