# NTSB investigations: Piper PA-28-235, VA

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 NYC93LA042](https://openairdocs.org/ntsb/NYC93LA042.md): Piper PA-28-235 · Cheriton, VA · Accident · No injuries · Limited investigation · Final report · Dec 10, 1992 · N9102W · Substantial damage
  > The pilot's improperly planned approach, resulting in a touchdown too FAR down the runway, with excessive airspeed, and the subsequent encounter with soft terrain and nose over.
- [NTSB BFO90LA026](https://openairdocs.org/ntsb/BFO90LA026.md): Piper PA-28-235 · Tappahannock, VA · Accident · No injuries · Limited investigation · Final report · Feb 14, 1990 · N8521W · Substantial damage
  > Failure of fixed base operator (FBO) personnel to assure that the fuel tank was free of water, and failure of the pilot to insure that the aircraft was properly preflighted. Soft/marshy terrain in the emergency landing area was a related factor.
- [NTSB ATL80FA068](https://openairdocs.org/ntsb/ATL80FA068.md): Piper PA-28 · Star Tannery, VA · Accident · 3 fatal · Closed · Jul 2, 1980 · N5908V · Destroyed
- [NTSB IAD76FID13](https://openairdocs.org/ntsb/IAD76FID13.md): Piper PA-28 · Hampton, VA · Accident · Serious injuries · Closed · Oct 11, 1975 · N8804W · Destroyed
- [NTSB IAD74FID31](https://openairdocs.org/ntsb/IAD74FID31.md): Piper PA-28 · Richmond, VA · Accident · Minor injuries · Closed · Apr 18, 1974 · N8543W · Destroyed
- [NTSB IAD71AI026](https://openairdocs.org/ntsb/IAD71AI026.md): Piper PA-28 · Missing Aircraft, VA · Accident · 1 fatal · Closed · Nov 13, 1970 · N9384W · Destroyed
- [NTSB NYC66A0033](https://openairdocs.org/ntsb/NYC66A0033.md): Piper PA-28 · Elkwood, VA · Accident · 2 fatal · Closed · Sep 11, 1965 · N8501W · Destroyed
- [NTSB UNK64X3450](https://openairdocs.org/ntsb/UNK64X3450.md): Piper PA-28 · Danville, VA · Accident · 1 fatal · Closed · Aug 18, 1964 · N8740W · 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" = 'VA' 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 ('7102810'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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