# 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 68 of 68 · 3,393 cases ## Cases, newest first - [NTSB UNK64X2378](https://openairdocs.org/ntsb/UNK64X2378.md): Piper PA24 · Aurora, OR · Accident · No injuries · Closed · Jun 19, 1964 · N6297P · Substantial damage - [NTSB UNK64X2336](https://openairdocs.org/ntsb/UNK64X2336.md): Cessna 310 · Mcnary, OR · Accident · No injuries · Closed · Jun 17, 1964 · N3045D · Substantial damage - [NTSB UNK64X2312](https://openairdocs.org/ntsb/UNK64X2312.md): Cessna 210 · Klamath Falls, OR · Accident · No injuries · Closed · Jun 16, 1964 · N196T · Substantial damage - [NTSB UNK64X2311](https://openairdocs.org/ntsb/UNK64X2311.md): N.American F-51D · Roseburg, OR · Accident · 5 fatal · Closed · Jun 15, 1964 · N1451D · Destroyed - [NTSB UNK64X2172](https://openairdocs.org/ntsb/UNK64X2172.md): Piper PA24 · Siletz, OR · Accident · No injuries · Closed · Jun 7, 1964 · N6173P · Substantial damage - [NTSB UNK64X2100](https://openairdocs.org/ntsb/UNK64X2100.md): Piper PA18 · Bonanza, OR · Accident · No injuries · Closed · Jun 4, 1964 · N1019A · Substantial damage - [NTSB UNK64X2065](https://openairdocs.org/ntsb/UNK64X2065.md): Boeing PT17 · Silvers, OR · Accident · No injuries · Closed · Jun 2, 1964 · N9182Z · Substantial damage - [NTSB UNK64X1995](https://openairdocs.org/ntsb/UNK64X1995.md): Piper J3 · Sandy, OR · Accident · No injuries · Closed · May 28, 1964 · N7074H · Substantial damage - [NTSB UNK64X1982](https://openairdocs.org/ntsb/UNK64X1982.md): Boeing E75 · Waconda, OR · Accident · Minor injuries · Closed · May 27, 1964 · N1064N · Substantial damage - [NTSB UNK64X1961](https://openairdocs.org/ntsb/UNK64X1961.md): Aeronca 7AC · Burns, OR · Accident · Minor injuries · Closed · May 26, 1964 · N82569 · Substantial damage - [NTSB UNK64X1958](https://openairdocs.org/ntsb/UNK64X1958.md): Aeronca 11AC · Madras, OR · Accident · 1 fatal · Closed · May 26, 1964 · N9181E · Destroyed - [NTSB UNK64X1889](https://openairdocs.org/ntsb/UNK64X1889.md): Grumman TBM-3U · Rome, OR · Accident · 1 fatal · Closed · May 22, 1964 · N7848C · Destroyed - [NTSB UNK64X1865](https://openairdocs.org/ntsb/UNK64X1865.md): Bell 47G-2 · Enterprise, OR · Accident · Minor injuries · Closed · May 20, 1964 · N4021A · Substantial damage - [NTSB UNK64X1814](https://openairdocs.org/ntsb/UNK64X1814.md): Piper PA22 · The Dalles, OR · Accident · Serious injuries · Closed · May 17, 1964 · N3640P · Destroyed - [NTSB UNK64X1688](https://openairdocs.org/ntsb/UNK64X1688.md): Piper PA-22 · Mulino, OR · Accident · No injuries · Closed · May 9, 1964 · N8644D · Substantial damage - [NTSB UNK64X1633](https://openairdocs.org/ntsb/UNK64X1633.md): Piper PA30 · Mill City, OR · Accident · No injuries · Closed · May 6, 1964 · N246NW · Substantial damage - [NTSB UNK64X1554](https://openairdocs.org/ntsb/UNK64X1554.md): Cessna 170B · Prineville, OR · Accident · No injuries · Closed · May 2, 1964 · N2850C · Substantial damage - [NTSB UNK64X1551](https://openairdocs.org/ntsb/UNK64X1551.md): Piper PA28 · Hillsboro, OR · Accident · No injuries · Closed · May 1, 1964 · N5723W · Substantial damage - [NTSB UNK64X1534](https://openairdocs.org/ntsb/UNK64X1534.md): Piper J-5A · Paulina, OR · Accident · 1 fatal · Closed · Apr 30, 1964 · N28260 · Destroyed - [NTSB UNK64X1501](https://openairdocs.org/ntsb/UNK64X1501.md): Piper PA12 · Beaver Creek, OR · Accident · Minor injuries · Closed · Apr 28, 1964 · N98905 · Substantial damage - [NTSB UNK64X1377](https://openairdocs.org/ntsb/UNK64X1377.md): Mooney M-18 · Hood River, OR · Accident · No injuries · Closed · Apr 19, 1964 · N393A · Substantial damage - [NTSB UNK64X1345](https://openairdocs.org/ntsb/UNK64X1345.md): Piper PA18 · Blalock, OR · Accident · No injuries · Closed · Apr 17, 1964 · N1278A · Substantial damage - [NTSB UNK64X1324](https://openairdocs.org/ntsb/UNK64X1324.md): Piper PA22 · Crescent, OR · Accident · No injuries · Closed · Apr 15, 1964 · N934A · Substantial damage - [NTSB UNK64X1302](https://openairdocs.org/ntsb/UNK64X1302.md): Beechcraft 35 · Beaverton, OR · Accident · No injuries · Closed · Apr 13, 1964 · N3854N · Substantial damage - [NTSB UNK64X1279](https://openairdocs.org/ntsb/UNK64X1279.md): Cessna 140A · Burns, OR · Accident · No injuries · Closed · Apr 12, 1964 · N5309C · Substantial damage - [NTSB UNK64X1112](https://openairdocs.org/ntsb/UNK64X1112.md): Cessna 205 · Klamath Fall, OR · Accident · Minor injuries · Closed · Mar 30, 1964 · N8403Z · Substantial damage - [NTSB UNK64X1030](https://openairdocs.org/ntsb/UNK64X1030.md): Luscombe 8A · Hurora, OR · Accident · No injuries · Closed · Mar 24, 1964 · N71110 · Substantial damage - [NTSB UNK64X0955](https://openairdocs.org/ntsb/UNK64X0955.md): Cessna 205 · Roseburg, OR · Accident · Minor injuries · Closed · Mar 16, 1964 · N8172Z · Substantial damage - [NTSB UNK64X0873](https://openairdocs.org/ntsb/UNK64X0873.md): Piper PA22 · Condon, OR · Accident · Minor injuries · Closed · Mar 10, 1964 · N2938P · Destroyed - [NTSB UNK64X0852](https://openairdocs.org/ntsb/UNK64X0852.md): Piper PA22 · Idanha, OR · Accident · 1 fatal · Closed · Mar 8, 1964 · N5812Z · Destroyed - [NTSB UNK64X0847](https://openairdocs.org/ntsb/UNK64X0847.md): Piper PA22 · The Dallas, OR · Accident · No injuries · Closed · Mar 8, 1964 · N6852B · Substantial damage - [NTSB UNK64X0789](https://openairdocs.org/ntsb/UNK64X0789.md): Fairchild F-27 · Portland, OR · Incident · No injuries · Closed · Mar 2, 1964 · N2704 · Minor damage - [NTSB UNK64X0787](https://openairdocs.org/ntsb/UNK64X0787.md): Mooney M20B · Cave Junction, OR · Accident · 1 fatal · Closed · Mar 1, 1964 · N74743 · Destroyed - [NTSB UNK64X0750](https://openairdocs.org/ntsb/UNK64X0750.md): Cessna 175 · La Pine, OR · Accident · No injuries · Closed · Feb 29, 1964 · N6760E · Substantial damage - [NTSB UNK64X0714](https://openairdocs.org/ntsb/UNK64X0714.md): Mooney M20 · Albany, OR · Accident · No injuries · Closed · Feb 27, 1964 · N5294B · Substantial damage - [NTSB UNK64X0679](https://openairdocs.org/ntsb/UNK64X0679.md): Piper PA18 · Allegany, OR · Accident · No injuries · Closed · Feb 23, 1964 · N3875Z · Substantial damage - [NTSB UNK64X0623](https://openairdocs.org/ntsb/UNK64X0623.md): Beechcraft 35 · Pendleton, OR · Accident · No injuries · Closed · Feb 20, 1964 · N5241C · Substantial damage - [NTSB UNK64X0531](https://openairdocs.org/ntsb/UNK64X0531.md): Piper PA22 · Cascade Lock, OR · Accident · No injuries · Closed · Feb 10, 1964 · N3743A · Substantial damage - [NTSB UNK64X0458](https://openairdocs.org/ntsb/UNK64X0458.md): Maule M4 · Clackmans, OR · Accident · No injuries · Closed · Feb 4, 1964 · N12016 · Substantial damage - [NTSB UNK64X0313](https://openairdocs.org/ntsb/UNK64X0313.md): Cessna 182 · John Day, OR · Accident · Minor injuries · Closed · Jan 21, 1964 · N7236E · Substantial damage - [NTSB UNK64X0268](https://openairdocs.org/ntsb/UNK64X0268.md): Cessna 182 · Lakeview, OR · Accident · 4 fatal · Closed · Jan 17, 1964 · N5598B · Destroyed - [NTSB UNK64X0246](https://openairdocs.org/ntsb/UNK64X0246.md): Cessna 182A · Hood River, OR · Accident · No injuries · Closed · Jan 14, 1964 · N2135G · Destroyed - [NTSB SEA62A0003](https://openairdocs.org/ntsb/SEA62A0003.md): Boeing 720 · Portland, OR · Accident · No injuries · Closed · Feb 1, 1962 · N7206U · 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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb?page=68&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.