# Fatal NTSB investigations, 1981, 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 SEA82FA013](https://openairdocs.org/ntsb/SEA82FA013.md): Erco 415-C · Ashland, OR · Accident · 1 fatal · Closed · Dec 21, 1981 · N87307 · Destroyed
- [NTSB SEA82FA012](https://openairdocs.org/ntsb/SEA82FA012.md): Piper PA-32 · Brogan, OR · Accident · 2 fatal · Closed · Dec 12, 1981 · N4041R · Destroyed
- [NTSB SEA82FA010](https://openairdocs.org/ntsb/SEA82FA010.md): Piper PA-28 · Mill City, OR · Accident · 1 fatal · Closed · Dec 6, 1981 · N8415W · Destroyed
- [NTSB SEA82FA006](https://openairdocs.org/ntsb/SEA82FA006.md): Cessna 172M · Payette, OR · Accident · 5 fatal · Closed · Nov 26, 1981 · N9710H · Destroyed
- [NTSB SEA82FA003](https://openairdocs.org/ntsb/SEA82FA003.md): Maule M-5 · North Bend, OR · Accident · 1 fatal · Closed · Nov 7, 1981 · N62076 · Destroyed
- [NTSB SEA81FYM46](https://openairdocs.org/ntsb/SEA81FYM46.md): Druine D-31 · Corvallis, OR · Accident · 1 fatal · Closed · Sep 19, 1981 · N7193 · Destroyed
- [NTSB SEA81FA056](https://openairdocs.org/ntsb/SEA81FA056.md): Aeronca 7AC · Myrtle Creek, OR · Accident · 2 fatal · Closed · Sep 17, 1981 · N4323E · Destroyed
- [NTSB SEA81FA048](https://openairdocs.org/ntsb/SEA81FA048.md): Cessna 150H · Blue River, OR · Accident · 2 fatal · Closed · Jul 24, 1981 · N6551S · Destroyed
- [NTSB SEA81FYM32](https://openairdocs.org/ntsb/SEA81FYM32.md): Minicoupe Johnsn · Gaston, OR · Accident · 1 fatal · Closed · Jul 18, 1981 · N74BJ · Substantial damage
- [NTSB SEA81FA040](https://openairdocs.org/ntsb/SEA81FA040.md): Piper PA-24 · Riverside, OR · Accident · 1 fatal · Closed · Jun 12, 1981 · N9437P · Destroyed
- [NTSB SEA83FA056](https://openairdocs.org/ntsb/SEA83FA056.md): Cessna 170 · Azalea, OR · Accident · 2 fatal · Closed · Jun 6, 1981 · N3973V · Destroyed
- [NTSB SEA81FA036](https://openairdocs.org/ntsb/SEA81FA036.md): Bell 206B · Govt Camp, OR · Accident · 1 fatal · Closed · May 22, 1981 · N58004 · Substantial damage
- [NTSB SEA81FA023](https://openairdocs.org/ntsb/SEA81FA023.md): Piper PA28RT · Astoria, OR · Accident · 1 fatal · Closed · Mar 14, 1981 · N2853T · Destroyed
- [NTSB SEA81FA021](https://openairdocs.org/ntsb/SEA81FA021.md): Beech A36 · Eugene, OR · Accident · 2 fatal · Closed · Mar 4, 1981 · N17504 · Destroyed
- [NTSB SEA83FYM03](https://openairdocs.org/ntsb/SEA83FYM03.md): Piper PA-24 · Scappoose, OR · Accident · 1 fatal · Closed · Feb 9, 1981 · N8604P · Destroyed
- [NTSB SEA81FA015](https://openairdocs.org/ntsb/SEA81FA015.md): Aero Comdr 690B · Burns, OR · Accident · 3 fatal · Closed · Jan 7, 1981 · N81521 · 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 year(c."eventDate") = 1981
  AND c."eventStateOrRegion" = 'OR' AND c."eventCountry" = 'USA'
  AND c."highestInjuryLevel" = 'Fatal'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&state=OR&year=1981

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
