# NTSB investigations: Cessna 172D, 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 ERA13LA037](https://openairdocs.org/ntsb/ERA13LA037.md): Cessna 172D · Indian Trail, NC · Accident · No injuries · Limited investigation · Final report · Oct 20, 2012 · N2879U · Substantial damage
  > The pilot’s improper use of flaps for takeoff, which resulted in the airplane’s failure to attain adequate climb airspeed and subsequent collision will trees during takeoff.
- [NTSB ERA12LA101](https://openairdocs.org/ntsb/ERA12LA101.md): Cessna 172D · Belhaven, NC · Accident · No injuries · Limited investigation · Final report · Dec 4, 2011 · N2344U · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB ATL91FA077](https://openairdocs.org/ntsb/ATL91FA077.md): Cessna 172D · Mocksville, NC · Accident · 1 fatal · Field investigation · Final report · Apr 7, 1991 · N2936U · Substantial damage
  > The loss of engine power due to open circuits in the ignition wiring harness, and the pilot's failure to maintain flying airspeed during the forced landing attempt. Factors in this accident were the dark night lighting conditions at the time of the accident.
- [NTSB ATL86FA001](https://openairdocs.org/ntsb/ATL86FA001.md): Cessna 172 · Chapel Hill, NC · Accident · 2 fatal · Field investigation · Final report · Oct 1, 1985 · N2765U · Destroyed
  > N2765U crashed shortly after making a low pass over a private air strip near Chapel Hill. The aircraft was seen in a nose high attitude prior to impacting a tree about 40 above the ground. The aircraft also collided with a power transmission line. The…
- [NTSB IAD70FKM09](https://openairdocs.org/ntsb/IAD70FKM09.md): Cessna 172 · Mooresville, NC · Accident · Serious injuries · Closed · May 15, 1970 · N2600U · Substantial damage
- [NTSB IAD70D0104](https://openairdocs.org/ntsb/IAD70D0104.md): Cessna 172 · Benson, NC · Accident · No injuries · Closed · Sep 17, 1969 · N2070Y · Substantial damage
- [NTSB DIA67F0104](https://openairdocs.org/ntsb/DIA67F0104.md): Cessna 172 · New Bern, NC · Accident · Minor injuries · Closed · May 20, 1967 · N2512Y · Substantial damage
- [NTSB MIA66F0519](https://openairdocs.org/ntsb/MIA66F0519.md): Cessna 172 · Clemmons, NC · Accident · Minor injuries · Closed · May 5, 1966 · N2815U · 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 ('2072410'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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