# NTSB investigations: Piper PA-31, 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 ATL83AA031](https://openairdocs.org/ntsb/ATL83AA031.md): Piper PA-31-310 · Spencer, VA · Accident · 8 fatal · Final report · Nov 14, 1982 · N3538R · Destroyed
  > The pilot filed an IFR clearance and took off on runway 30 after dark. At that time, the airport manager was in his living quarters, getting ready to eat his evening meal. He reported that from his position, the takeoff height looked normal. As the aircraft…
- [NTSB ATL80FA092](https://openairdocs.org/ntsb/ATL80FA092.md): Piper PA-31 · Culpeper, VA · Accident · 1 fatal · Closed · Sep 10, 1980 · N6702L · Destroyed
- [NTSB DIA69F0080](https://openairdocs.org/ntsb/DIA69F0080.md): Piper PA-31 · Fredericksburg, VA · Accident · No injuries · Closed · Oct 3, 1968 · N9054Y · 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" = '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 ('7103103'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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