# NTSB investigations: Cessna 340A, 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 WPR23LA221](https://openairdocs.org/ntsb/WPR23LA221.md): Cessna 340A · Bend, OR · Accident · No injuries · Class 4 · Limited · Final report · Jun 8, 2023 · N340SW · Substantial damage
  > The pilot’s failure to maintain clearance from the fuel station, resulting in a ground collision and fire.
- [NTSB SEA04FA006](https://openairdocs.org/ntsb/SEA04FA006.md): Cessna 340A · Scappoose, OR · Accident · 2 fatal · Field investigation · Final report · Oct 18, 2003 · N340P · Destroyed
  > The pilot's failure to maintain airspeed while maneuvering. An inadvertent stall, the pilot's failure to follow engine operation procedures and engine detonation were factors.
- [NTSB SEA86LA206](https://openairdocs.org/ntsb/SEA86LA206.md): Cessna 340 · Prairie City, OR · Accident · No injuries · Limited investigation · Final report · Aug 13, 1986 · N2696U · Substantial damage
  > The plt was attempting to land the acft on an unlit airstrip during dusk conditions. While attempting to align the acft with the center of the 30 foot wide airstrip the plt heard the stall warning horn sounding. During an attempted go around an inadvertent…
- [NTSB SEA82DA021](https://openairdocs.org/ntsb/SEA82DA021.md): Cessna 340A · Sunriver, OR · Accident · No injuries · Final report · Jan 28, 1982 · N4604N · Substantial damage
  > The instructor was providing dual instruction to a private pilot with no previous time in this nor any multi- engine aircraft. Also, the pirvate pilot had not flown within the previous 90 days. He initiated a takeoff on runway 18 with the wind from 210…

## 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 ('2076405', '2073325'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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