# NTSB investigations: Cessna 340A, 2007

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 SEA07LA156](https://openairdocs.org/ntsb/SEA07LA156.md): Cessna 340A · Ludlow, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 12, 2007 · N340WS · Substantial damage
  > The loss of engine power from both engines due to fuel starvation resulting from the pilot's improper fuel tank selector position. Contributing factors were the pilot's inadequate preflight inspection and the lack of suitable terrain for the forced landing.
- [NTSB LAX07CA182](https://openairdocs.org/ntsb/LAX07CA182.md): Cessna 340A · Chandler, AZ · Accident · No injuries · Data collection · Final report · Jun 1, 2007 · N8688K · Destroyed
  > fuel starvation due to the pilot's failure to adequately manage and monitor his fuel supply.
- [NTSB CHI07FA073](https://openairdocs.org/ntsb/CHI07FA073.md): Cessna 340A · Council Bluffs, IA · Accident · 4 fatal · Field investigation · Final report · Feb 17, 2007 · N111SC · Destroyed
  > The pilot's continued flight into adverse weather, and his failure to maintain altitude during the instrument approach. Contributing factors were the presence of severe icing, moderate turbulence, and low-level wind shear.

## 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 year(c."eventDate") = 2007
  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&year=2007

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