# NTSB investigations: Piper PA-28R-200, 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 NYC98LA045](https://openairdocs.org/ntsb/NYC98LA045.md): Piper PA-28R-200 · Fairplain, WV · Accident · Serious injuries · Limited investigation · Final report · Dec 19, 1997 · N9418N · Destroyed
  > an improper overhaul of the fuel servo by the manufacturer, which resulted in the loss of engine power. Factors in the accident were the dark night conditions and rough forced landing terrain.
- [NTSB BFO88LA080](https://openairdocs.org/ntsb/BFO88LA080.md): Piper PA-28R-200 · Charleston, WV · Accident · No injuries · Limited investigation · Final report · Aug 31, 1988 · N15948 · Substantial damage
  > The plt was executing the ILS rwy 5 apch when he entered fog about 350 ft above the dh. According to the plt, upon reaching the dh he sighted the rwy and continued the apch. Afterward the plt said he deviated left of the localizer centerline and as he was…

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

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