# NTSB investigations: Piper PA-28R-200, 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 GAA18CA145](https://openairdocs.org/ntsb/GAA18CA145.md): Piper PA28R · Milton-Freewater, OR · Accident · No injuries · Data collection · Final report · Feb 28, 2018 · N323MQ · Substantial damage
  > The pilot receiving instruction’s and flight instructor’s improper decision to enter a canyon surrounded by steep rising terrain and their subsequent failure to maintain clearance from terrain while maneuvering at a low altitude.
- [NTSB SEA97FA106](https://openairdocs.org/ntsb/SEA97FA106.md): Piper PA-28R-200 · Tigard, OR · Accident · 2 fatal · Field investigation · Final report · May 10, 1997 · N55676 · Destroyed
  > The pilot's failure to properly manage the aircraft fuel supply, which led to fuel exhaustion of the right tank and subsequent fuel starvation/power loss of the engine during the final approach. Factors contributing to the accident were the lack of sufficient…
- [NTSB SEA90FA074](https://openairdocs.org/ntsb/SEA90FA074.md): Piper PA28R-200 · Prairie City, OR · Accident · 2 fatal · Field investigation · Final report · Mar 2, 1990 · N2947R · Destroyed
  > Uncontrolled spiralling descent that the pilot did not adequately recover from. The pilots lack of total experience in this type of operation and the dark night condition are a factor.
- [NTSB SEA84LA038](https://openairdocs.org/ntsb/SEA84LA038.md): Piper PA28R-200 · Newport, OR · Accident · No injuries · Limited investigation · Final report · Jan 14, 1984 · N55624 · Substantial damage
  > The acft collided with a ditch during landing. The construction ditch ran across the rwy. The rwy had been notamed as out of service except for the last 2000 ft. the plt stated that the 3 white barriers marking the position of the construction ditch had blown…
- [NTSB SEA82DA081](https://openairdocs.org/ntsb/SEA82DA081.md): Piper PA-28R-200 · Hillsboro, OR · Accident · No injuries · Final report · May 31, 1982 · N8584N · Substantial damage
  > On touchdown the left main gear collapsed. No green down and locked light was observed prior to touchdown and the pilot made no attempt to go around, recycle the gear, OR other landing gear malfunction procedures. A retraction check after the accident showed…
- [NTSB SEA79FYK14](https://openairdocs.org/ntsb/SEA79FYK14.md): Piper PA-28R · Crescent Lake, OR · Accident · No injuries · Closed · Jun 3, 1979 · N6998N · Substantial damage
- [NTSB SEA79FYK09](https://openairdocs.org/ntsb/SEA79FYK09.md): Piper PA-28R · Grants Pass, OR · Accident · Minor injuries · Closed · May 8, 1979 · N9433N · Destroyed
- [NTSB SEA73DYC35](https://openairdocs.org/ntsb/SEA73DYC35.md): Piper PA-28R · Elgin, OR · Accident · No injuries · Closed · Jun 16, 1973 · N9456N · Substantial damage
- [NTSB SEA72AS036](https://openairdocs.org/ntsb/SEA72AS036.md): Piper PA-28R · Pendleton, OR · Accident · 2 fatal · Closed · Mar 3, 1972 · N9434N · Destroyed
- [NTSB SEA72AS030](https://openairdocs.org/ntsb/SEA72AS030.md): Piper PA-28R · Corvallis, OR · Accident · 1 fatal · Closed · Feb 4, 1972 · N2824R · Destroyed
- [NTSB SEA71AS021](https://openairdocs.org/ntsb/SEA71AS021.md): Piper PA-28R · Portland, OR · Accident · 1 fatal · Closed · Oct 9, 1970 · N5004S · 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" = '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 ('7102811'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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