Fatal NTSB investigations: Piper PA-22-150, OR

8 cases on aircraft the registry lists as Piper PA-22-150. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Cases per year

19642026
Fatal NTSB investigations: Piper PA-22-150, OR per year, 1964–2026: 8 cases
19641
19661
19711
19771
19881
19891
20092

Latest cases

Query with SQL
duckdb -csv -c "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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102210'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB WPR09FA428Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Canyonville, ORThe non-instrument-rated and non-certificated pilot’s decision to continue visual flight into instrument meteorological conditions in mountainous terrain, which resulted in controlled flight into terrain.Aug 30, 2009 · N2967P · Substantial damageNTSB WPR09FA175Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Sherwood, ORThe pilot’s continued visual flight into instrument meteorological conditions, resulting in spatial disorientation and a loss of control.Apr 1, 2009 · N9996D · Substantial damageNTSB SEA89FA126Accident · 3 fatalField investigationFinal reportPiper PA-22-150 · Elgin, ORFailure of the pilot to obtain/maintain adequate airspeed during takeoff/initial climb, which resulted in a stall. Factors related to the accident were: quartering tailwind, high density altitude, and the pilot's lack of recent experience in the aircraft.Jul 3, 1989 · N6941B · DestroyedNTSB DEN88FA213Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Curtin, OROn 9/20/88, the plt & his wife depd montaque, CA, on a flt to silverdale, WA, with a planned refueling stop at cottage grove, OR. When the acft did not arrive, a search was made, but to no avail. On 1/24/90, a tree planting crew found the acft, where it had…Sep 20, 1988 · N3863P · DestroyedNTSB SEA77DYM33Accident · 1 fatalClosedPiper PA-22S · Madras, ORMay 28, 1977 · N2563P · No damageNTSB SEA72AS025Accident · 1 fatalClosedPiper PA-22 · Portland, ORDec 19, 1971 · N3535Z · DestroyedNTSB SEA67A0009Accident · 2 fatalClosedPiper PA-22 · Seaside, ORAug 7, 1966 · N7629D · DestroyedNTSB UNK64X2989Accident · 2 fatalClosedPiper PA22 · Klamath Falls, ORJul 23, 1964 · N3257Z · Destroyed