# NTSB investigations: Cessna 340, CA

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 WPR10FA116](https://openairdocs.org/ntsb/WPR10FA116.md): Cessna 340 · Lytle Creek, CA · Accident · 2 fatal · Field investigation · Final report · Jan 18, 2010 · N2217B · Substantial damage
  > The pilot’s loss of situational awareness while maneuvering under a cloud layer and failure to maintain sufficient clearance from mountainous terrain.
- [NTSB SEA08LA021](https://openairdocs.org/ntsb/SEA08LA021.md): Cessna 340 · Garberville, CA · Accident · 3 fatal · Limited investigation · Final report · Nov 6, 2007 · N5049Q · Destroyed
  > The pilot's intentional visual flight rules (VFR) flight into instrument meteorological conditions (IMC), and his failure to maintain clearance from the trees and terrain during climb. Contributing to the accident were the weather conditions of fog and a low…
- [NTSB LAX90LA242](https://openairdocs.org/ntsb/LAX90LA242.md): Cessna 340 · Salinas, CA · Accident · No injuries · Limited investigation · Final report · Jul 1, 1990 · N5411M · Substantial damage
  > The failure of maintenance personnel to reinstall the landing gear retract/extension linkage and the failure of inspection personnel to detect the improper installation.
- [NTSB LAX89LA224](https://openairdocs.org/ntsb/LAX89LA224.md): Cessna 340 · Paso Robles, CA · Accident · No injuries · Limited investigation · Final report · Jun 20, 1989 · N69549 · Substantial damage
  > Improper use (mismanagement) of the fuel system by the pilot, which resulted in fuel starvation. Related factors were: the lack of fuel quantity indicators (not installed) in the aircraft, flight by the pilot with this known deficiency, and trees in the…
- [NTSB LAX81FA067](https://openairdocs.org/ntsb/LAX81FA067.md): Cessna 340 · Santa Maria, CA · Accident · 1 fatal · Closed · Mar 25, 1981 · N24MH · Destroyed
- [NTSB LAX81FVD13](https://openairdocs.org/ntsb/LAX81FVD13.md): Cessna 340 · Santa Rosa, CA · Accident · No injuries · Closed · Mar 1, 1981 · N1701G · Substantial damage
- [NTSB LAX80FVG35](https://openairdocs.org/ntsb/LAX80FVG35.md): Cessna 340 · Weed, CA · Accident · No injuries · Closed · May 3, 1980 · N340RM · Destroyed
- [NTSB LAX78FUQ29](https://openairdocs.org/ntsb/LAX78FUQ29.md): Cessna 340 · Burbank, CA · Accident · Minor injuries · Closed · May 18, 1978 · N711CS · Destroyed
- [NTSB LAX77DUG54](https://openairdocs.org/ntsb/LAX77DUG54.md): Cessna 340 · Riverside, CA · Accident · No injuries · Closed · Jul 6, 1977 · N1701G · Substantial damage
- [NTSB LAX77FUQ11](https://openairdocs.org/ntsb/LAX77FUQ11.md): Cessna 340 · Santa Ynez, CA · Accident · No injuries · Closed · Dec 4, 1976 · N69476 · 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" = 'CA' 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 ('2076404'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2076404&state=CA

---
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.