# NTSB investigations: Piper PA-31: In flight collision with object

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 DEN84FA303](https://openairdocs.org/ntsb/DEN84FA303.md): Piper PA-31-310 · Paonia, CO · Accident · 1 fatal · Field investigation · Final report · Sep 28, 1984 · N7205L · Destroyed
  > The acft was flying at a very low alt over mountanous terrain. As the acft approached a crest of a ridge the acft started to buffet and then encountered a downslope wind condition. The combination of approaching a stall and encountering a downdraft forced the…
- [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…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103103')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7103103&occurrence=220

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