# NTSB investigations: Cessna 172P, WV

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 ERA13CA218](https://openairdocs.org/ntsb/ERA13CA218.md): Cessna 172P · Davis, WV · Accident · Serious injuries · Data collection · Final report · Apr 26, 2013 · N96178 · Substantial damage
  > The pilot’s improper glidepath as he approached the runway and his subsequent delayed decision to abort the landing.
- [NTSB IAD96FA132](https://openairdocs.org/ntsb/IAD96FA132.md): Cessna 172P · Summersville, WV · Accident · 3 fatal · Field investigation · Final report · Aug 11, 1996 · N65632 · Destroyed
  > The pilot's improper flare, his delay in aborting a landing, and his failure to maintain adequate airspeed, which resulted in a bounced landing and a stall during climb out in an attempt to avoid collision with trees.
- [NTSB NYC91LA059](https://openairdocs.org/ntsb/NYC91LA059.md): Cessna 172P · Charleston, WV · Accident · No injuries · Limited investigation · Final report · Jan 15, 1991 · N62960 · Substantial damage
  > Total loss of engine power in cruise flight due to failure of the accessory drive gear dowel pin resulting in a forced landing over unsuitable terrain and subsequent nose over on landing roll. A factor related to the accident was the improper procedure used…
- [NTSB BFO87FA062](https://openairdocs.org/ntsb/BFO87FA062.md): Cessna 172P · Cabin, WV · Accident · 2 fatal · Field investigation · Final report · Sep 5, 1987 · N65721 · Destroyed
  > The plt was on a VFR flight at 4500 ft MSL over a mountainous area when he encountered lowering clouds. The plt descended to stay below the clouds; however, he inadvertently entered the clouds. Afterwards he tried to turn around and as he did so, according to…
- [NTSB ATL86FA212](https://openairdocs.org/ntsb/ATL86FA212.md): Cessna 172 · Bridgeport, WV · Accident · 2 fatal · Field investigation · Final report · Jul 28, 1986 · N96701 · Destroyed
  > The aircraft collided with a tree while on final approach to runway 21. The flight had been cleared for the approach after the pilot reported having the airport in sight. There was no current weather observation available at that time, but a local air taxi…

## 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" = 'WV' 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 ('2072436'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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