# NTSB investigations: Piper PA-32-300, OR

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 WPR19FA256](https://openairdocs.org/ntsb/WPR19FA256.md): Piper PA32 · La Grande, OR · Accident · 1 fatal · Class 3 · Field · Final report · Sep 8, 2019 · N6300Z · Destroyed
  > The pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.
- [NTSB SEA00LA162](https://openairdocs.org/ntsb/SEA00LA162.md): Piper PA-32-300 · Birkenfeld, OR · Accident · No injuries · Limited investigation · Final report · Jul 29, 2000 · N934PH · Substantial damage
  > The pilot's delayed go-around, which resulted in the aircraft not clearing the fence posts. A contributing factor was the fence posts.
- [NTSB SEA87LA040](https://openairdocs.org/ntsb/SEA87LA040.md): Piper PA-32-300 · Gates, OR · Accident · Minor injuries · Limited investigation · Final report · Dec 31, 1986 · N4116R · Destroyed
  > The plt was attempting to land the aircraft at night on an unlit grass airstrip. Prior to reaching the airstrip the plt collided with an apple tree. Both wings were severed from the aircraft and it went inverted before striking the ground in a slightly nose…
- [NTSB SEA83FYK01](https://openairdocs.org/ntsb/SEA83FYK01.md): Piper PA-32-300 · 27ne Rogue Rive, OR · Accident · Serious injuries · Final report · Nov 10, 1982 · N656ZM · Destroyed
  > At 9,500 ft the eng failed. The acft impacted a large tree while maneuvering to land on a rural road in heavily forested mountains. Eng examination revealed that the top of the case had a large hole on the rear portion. Pushrod housings were missing from #5 &…
- [NTSB SEA77DYC02](https://openairdocs.org/ntsb/SEA77DYC02.md): Piper PA-32 · Condon, OR · Accident · No injuries · Closed · Oct 12, 1976 · N8631N · Substantial damage
- [NTSB SEA76DYI18](https://openairdocs.org/ntsb/SEA76DYI18.md): Piper PA-32 · Bend, OR · Accident · No injuries · Closed · Jun 3, 1976 · N15326 · Substantial damage
- [NTSB SEA76DYI06](https://openairdocs.org/ntsb/SEA76DYI06.md): Piper PA-32 · Redmond, OR · Accident · No injuries · Closed · Sep 1, 1975 · N4092R · Substantial damage
- [NTSB SEA74DYC62](https://openairdocs.org/ntsb/SEA74DYC62.md): Piper PA-32 · Pacific City, OR · Accident · No injuries · Closed · Jun 23, 1974 · N4429T · Substantial damage
- [NTSB SEA71AS047](https://openairdocs.org/ntsb/SEA71AS047.md): Piper PA-32 · Meacham, OR · Accident · 5 fatal · Closed · Jun 14, 1971 · N4070W · Destroyed
- [NTSB SEA70DVQ09](https://openairdocs.org/ntsb/SEA70DVQ09.md): Piper PA-32 · Mckenzie Br., OR · Accident · No injuries · Closed · May 25, 1970 · N4171R · 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" = 'OR' 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 ('7103212'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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