# NTSB investigations: Cessna 172F, NC

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 ERA21LA176](https://openairdocs.org/ntsb/ERA21LA176.md): Cessna 172F · Fayetteville, NC · Accident · No injuries · Class 4 · Limited · Final report · Apr 6, 2021 · N5424R · Substantial damage
  > The pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion and subsequent noseover.
- [NTSB ERA14CA398](https://openairdocs.org/ntsb/ERA14CA398.md): Cessna 172F · Oxford, NC · Accident · No injuries · Data collection · Final report · Aug 14, 2014 · N8432U · Substantial damage
  > The student pilot's improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot's improper compensation for wind conditions.
- [NTSB ERA13LA075](https://openairdocs.org/ntsb/ERA13LA075.md): Cessna 172F · Albemarle, NC · Accident · Serious injuries · Limited investigation · Final report · Dec 2, 2012 · N8475U · Minor damage
  > The student pilot's failure to remain clear of the airplane’s rotating propeller.
- [NTSB ATL02LA081](https://openairdocs.org/ntsb/ATL02LA081.md): Cessna 172 · Smithfield, NC · Accident · Serious injuries · Limited investigation · Final report · Apr 13, 2002 · N8458U · Substantial damage
  > The pilot's inadequate in-flight planning that resulted in fuel exhaustion and the subsequent loss of engine power.
- [NTSB ATL89LA132](https://openairdocs.org/ntsb/ATL89LA132.md): Cessna 172F · Elkin Arpt., NC · Accident · No injuries · Limited investigation · Final report · Apr 23, 1989 · N7908U · Substantial damage
  > The failure of the pilot to properly compensate for the gusty wind conditions during takeoff and the delay in his decision to abort the takeoff before colliding with trees. Contributing to the accident were the gusty wind conditions and the pilot's lack of…
- [NTSB ATL88LA051](https://openairdocs.org/ntsb/ATL88LA051.md): Cessna 172F · Eden, NC · Accident · No injuries · Limited investigation · Final report · Dec 2, 1987 · N8674U · Substantial damage
  > The student plt attempted to land in a farm pasture adjacent to his brother's farm. The airplane ldg gear 'dug in' on ldg, and the airplane nosed over. The student plt described the terrain as 'wet & soggy'. The student did not have an instructor's…
- [NTSB IAD76FLJ33](https://openairdocs.org/ntsb/IAD76FLJ33.md): Cessna 172 · Apex, NC · Accident · No injuries · Closed · Aug 17, 1976 · N5539R · Substantial damage
- [NTSB IAD76FLJ03](https://openairdocs.org/ntsb/IAD76FLJ03.md): Cessna 172F · Burlington, NC · Accident · Serious injuries · Closed · Jul 22, 1975 · N8845U · Substantial damage
- [NTSB IAD74DLJ21](https://openairdocs.org/ntsb/IAD74DLJ21.md): Cessna 172F · Raeford, NC · Accident · No injuries · Closed · Nov 14, 1973 · N5652R · Substantial damage
- [NTSB DIA69F0144](https://openairdocs.org/ntsb/DIA69F0144.md): Cessna 172 · Mooresville, NC · Accident · Serious injuries · Closed · Feb 10, 1969 · N371LA · Substantial damage
- [NTSB DIA69D0092](https://openairdocs.org/ntsb/DIA69D0092.md): Cessna 172 · Burnsville, NC · Accident · Minor injuries · Closed · Oct 25, 1968 · N8262U · Substantial damage
- [NTSB MIA66F0563](https://openairdocs.org/ntsb/MIA66F0563.md): Cessna 172 · Hendersonville, NC · Accident · Minor injuries · Closed · Jun 2, 1966 · N5498R · Substantial damage
- [NTSB MIA65F0086](https://openairdocs.org/ntsb/MIA65F0086.md): Cessna 172F · Aurora, NC · Accident · No injuries · Closed · Apr 14, 1965 · N8395U · 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" = 'NC' 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 ('2072414'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072414&state=NC

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