# NTSB investigations, 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. Page 44 of 68 · 3,391 cases ## Cases, newest first - [NTSB SEA78FYM41](https://openairdocs.org/ntsb/SEA78FYM41.md): Piper PA-22 · Grand Ronde, OR · Accident · Serious injuries · Closed · Jun 29, 1978 · N5941D · Substantial damage - [NTSB SEA78DYM37](https://openairdocs.org/ntsb/SEA78DYM37.md): Cessna 188A · Enterprise, OR · Accident · No injuries · Closed · Jun 28, 1978 · N5633J · Substantial damage - [NTSB SEA78FA039](https://openairdocs.org/ntsb/SEA78FA039.md): Piper PA-28R · Baker, OR · Accident · 4 fatal · Closed · Jun 24, 1978 · N40048 · Destroyed - [NTSB SEA78FA038](https://openairdocs.org/ntsb/SEA78FA038.md): Navion A · Ashland, OR · Accident · 1 fatal · Closed · Jun 23, 1978 · N91504 · Destroyed - [NTSB SEA78FYM40](https://openairdocs.org/ntsb/SEA78FYM40.md): Piper PA-36 · Carlton, OR · Accident · Serious injuries · Closed · Jun 21, 1978 · N41324 · Destroyed - [NTSB SEA78FYM38](https://openairdocs.org/ntsb/SEA78FYM38.md): Piper PA-22 · Newberg, OR · Accident · No injuries · Closed · Jun 17, 1978 · N3651P · Substantial damage - [NTSB SEA78FYM39](https://openairdocs.org/ntsb/SEA78FYM39.md): Boeing E75N1 · John Day, OR · Accident · 1 fatal · Closed · Jun 16, 1978 · N4769V · Destroyed - [NTSB SEA78FYK17](https://openairdocs.org/ntsb/SEA78FYK17.md): Snow 600S2D · Malin, OR · Accident · No injuries · Closed · Jun 2, 1978 · N1726S · Substantial damage - [NTSB SEA78DYK18](https://openairdocs.org/ntsb/SEA78DYK18.md): Cessna 150 · Millican, OR · Accident · Minor injuries · Closed · Jun 2, 1978 · N11737 · Substantial damage - [NTSB SEA78DYK15](https://openairdocs.org/ntsb/SEA78DYK15.md): Temco D-16 · Redmond, OR · Accident · No injuries · Closed · May 26, 1978 · N91623 · Substantial damage - [NTSB SEA78DYM35](https://openairdocs.org/ntsb/SEA78DYM35.md): Cessna 210 · Waldport, OR · Accident · No injuries · Closed · May 23, 1978 · N29176 · Substantial damage - [NTSB SEA78DYM34](https://openairdocs.org/ntsb/SEA78DYM34.md): Piper PA-30B · Madras, OR · Accident · No injuries · Closed · May 20, 1978 · N7068Y · Substantial damage - [NTSB SEA78FYM36](https://openairdocs.org/ntsb/SEA78FYM36.md): Beech A24R · Salem, OR · Accident · Minor injuries · Closed · May 19, 1978 · N112FC · Substantial damage - [NTSB SEA78FYM33](https://openairdocs.org/ntsb/SEA78FYM33.md): Bell 206B · Tillamook, OR · Accident · Serious injuries · Closed · May 15, 1978 · N4ZH · Destroyed - [NTSB SEA78FYM32](https://openairdocs.org/ntsb/SEA78FYM32.md): S.N.I.A.S. SA316B · Portland, OR · Accident · No injuries · Closed · May 11, 1978 · N5954 · Substantial damage - [NTSB SEA78DYM30](https://openairdocs.org/ntsb/SEA78DYM30.md): Cessna 182 · Enterprise, OR · Accident · No injuries · Closed · May 8, 1978 · N71354 · Substantial damage - [NTSB SEA78DYM29](https://openairdocs.org/ntsb/SEA78DYM29.md): Beech 35 · Gresham, OR · Accident · No injuries · Closed · May 7, 1978 · N3927N · Substantial damage - [NTSB SEA78FYM31](https://openairdocs.org/ntsb/SEA78FYM31.md): Aeronca 7AC · Estacada, OR · Accident · Minor injuries · Closed · May 6, 1978 · N3479E · Substantial damage - [NTSB SEA78FYA06](https://openairdocs.org/ntsb/SEA78FYA06.md): Cessna 172 · Ontario, OR · Accident · Minor injuries · Closed · May 2, 1978 · N73347 · Substantial damage - [NTSB SEA78FYM28](https://openairdocs.org/ntsb/SEA78FYM28.md): Beech F33A · La Grande, OR · Accident · Serious injuries · Closed · Apr 26, 1978 · N4515A · Destroyed - [NTSB SEA78FYM27](https://openairdocs.org/ntsb/SEA78FYM27.md): Amer Avco AA-1 · Oregon City, OR · Accident · No injuries · Closed · Apr 23, 1978 · N6130L · Substantial damage - [NTSB SEA78DYK14](https://openairdocs.org/ntsb/SEA78DYK14.md): Cessna 172 · Medford, OR · Accident · No injuries · Closed · Apr 16, 1978 · N2434Y · Substantial damage - [NTSB SEA78FYM25](https://openairdocs.org/ntsb/SEA78FYM25.md): Bell 47G · Kings Valley, OR · Accident · No injuries · Closed · Apr 15, 1978 · N2919W · Substantial damage - [NTSB SEA78FA025](https://openairdocs.org/ntsb/SEA78FA025.md): Cessna 150L · Junction City, OR · Accident · 1 fatal · Closed · Apr 11, 1978 · N10627 · Destroyed - [NTSB SEA78FYM24](https://openairdocs.org/ntsb/SEA78FYM24.md): Cessna 180 · Estacada, OR · Accident · Minor injuries · Closed · Apr 8, 1978 · N4623B · Substantial damage - [NTSB SEA78FA023](https://openairdocs.org/ntsb/SEA78FA023.md): Piper PA-28 · Milton Frwtr, OR · Accident · 4 fatal · Closed · Mar 18, 1978 · N1844T · Destroyed - [NTSB SEA78FYK12](https://openairdocs.org/ntsb/SEA78FYK12.md): Conrad Daphne · Roseburg, OR · Accident · Minor injuries · Closed · Mar 17, 1978 · N29613 · Substantial damage - [NTSB SEA78DYM22](https://openairdocs.org/ntsb/SEA78DYM22.md): Cessna 305A · Troutdale, OR · Accident · No injuries · Closed · Mar 17, 1978 · N5236G · Substantial damage - [NTSB SEA78DYM21](https://openairdocs.org/ntsb/SEA78DYM21.md): Hughes 269C · The Dalles, OR · Accident · No injuries · Closed · Mar 17, 1978 · N7471F · Destroyed - [NTSB SEA78DYK13](https://openairdocs.org/ntsb/SEA78DYK13.md): Cessna 172 · Malin, OR · Accident · No injuries · Closed · Mar 15, 1978 · N7510T · Substantial damage - [NTSB SEA78FYM19](https://openairdocs.org/ntsb/SEA78FYM19.md): Hiller Acft UH-12E · Tillamook, OR · Accident · No injuries · Closed · Mar 13, 1978 · N5ZH · Substantial damage - [NTSB SEA78DYM20](https://openairdocs.org/ntsb/SEA78DYM20.md): Cessna 150G · Aurora, OR · Accident · No injuries · Closed · Mar 13, 1978 · N6699G · Substantial damage - [NTSB SEA78DYK11](https://openairdocs.org/ntsb/SEA78DYK11.md): Bell 47G3B1 · Myrtle Creek, OR · Accident · No injuries · Closed · Mar 6, 1978 · N73984 · Substantial damage - [NTSB SEA78DYM18](https://openairdocs.org/ntsb/SEA78DYM18.md): Cessna 172 · Brooks, OR · Accident · Minor injuries · Closed · Mar 5, 1978 · N5704A · Substantial damage - [NTSB SEA78FYK09](https://openairdocs.org/ntsb/SEA78FYK09.md): Cessna 210 · Sunriver, OR · Accident · Minor injuries · Closed · Feb 11, 1978 · N94162 · Substantial damage - [NTSB SEA78DYK10](https://openairdocs.org/ntsb/SEA78DYK10.md): Alon A-2 · Christmas Vly, OR · Accident · No injuries · Closed · Feb 11, 1978 · N6523Q · Substantial damage - [NTSB SEA78FYK08](https://openairdocs.org/ntsb/SEA78FYK08.md): Piper PA-18 · Ashland, OR · Accident · Serious injuries · Closed · Feb 7, 1978 · N83272 · Destroyed - [NTSB SEA78FA019](https://openairdocs.org/ntsb/SEA78FA019.md): Beech 35 · Cascade Locks, OR · Accident · 4 fatal · Closed · Feb 7, 1978 · N3087V · Destroyed - [NTSB SEA78FYM16](https://openairdocs.org/ntsb/SEA78FYM16.md): Hiller UH-12E · Cannon Beach, OR · Accident · No injuries · Closed · Jan 20, 1978 · N62346 · Substantial damage - [NTSB SEA78FYK07](https://openairdocs.org/ntsb/SEA78FYK07.md): Piper PA-25 · Christmas Vly, OR · Accident · 1 fatal · Closed · Jan 20, 1978 · N6559L · Destroyed - [NTSB SEA78FYK06](https://openairdocs.org/ntsb/SEA78FYK06.md): Hiller UH-12E · Reedsport, OR · Accident · 1 fatal · Closed · Jan 20, 1978 · N65149 · Minor damage - [NTSB SEA78FYM15](https://openairdocs.org/ntsb/SEA78FYM15.md): Smitts 77 · Elgin, OR · Accident · No injuries · Closed · Jan 17, 1978 · N99453 · Substantial damage - [NTSB SEA78FA018](https://openairdocs.org/ntsb/SEA78FA018-143374.md): Piper PA-23 · Medford, OR · Accident · 6 fatal · Closed · Jan 15, 1978 · N5675Y · Destroyed - [NTSB SEA78FYM14](https://openairdocs.org/ntsb/SEA78FYM14.md): Bell 47G3B2 · Milton-Freewtr, OR · Accident · Serious injuries · Closed · Jan 4, 1978 · N2906W · Substantial damage - [NTSB SEA78DYM13](https://openairdocs.org/ntsb/SEA78DYM13.md): Piper PA-28R · Aurora, OR · Accident · No injuries · Closed · Dec 26, 1977 · N4936J · 2 aircraft · Minor damage - [NTSB SEA78DYK05](https://openairdocs.org/ntsb/SEA78DYK05.md): Piper PA-28 · Agness, OR · Accident · No injuries · Closed · Dec 23, 1977 · N56759 · Substantial damage - [NTSB SEA78FA014](https://openairdocs.org/ntsb/SEA78FA014.md): Aero Cmdr 520 · Cheshire, OR · Accident · 7 fatal · Closed · Dec 22, 1977 · C-GHUN · Destroyed - [NTSB SEA78DYK04](https://openairdocs.org/ntsb/SEA78DYK04.md): Hiller Acft FH1100 · Walton, OR · Accident · Minor injuries · Closed · Dec 22, 1977 · N92484 · Destroyed - [NTSB SEA78FYM12](https://openairdocs.org/ntsb/SEA78FYM12.md): Beech A23 · Newberg, OR · Accident · Minor injuries · Closed · Dec 21, 1977 · N14311 · Substantial damage - [NTSB SEA78DYM11](https://openairdocs.org/ntsb/SEA78DYM11.md): Cessna 152 · Dayton, OR · Accident · No injuries · Closed · Dec 18, 1977 · N757JM · Substantial damage Next page: https://openairdocs.org/ntsb.md?state=OR&page=45 ## 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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb?page=44&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.