# NTSB investigations: Cessna 340: Loss of control - in flight

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 NYC92FA150](https://openairdocs.org/ntsb/NYC92FA150.md): Cessna 340 · Falmouth, KY · Accident · 1 fatal · Field investigation · Final report · Aug 8, 1992 · N194S · Destroyed
  > The improper decision by the non-instrument-rated pilot to attempt VFR flight into instrument meteorological conditions resulting in a loss of airplane control and subsequent inadvertent spiral and collision with the ground. Factors related to the accident…
- [NTSB FTW83FRG03](https://openairdocs.org/ntsb/FTW83FRG03.md): Cessna 340 · Benavides, TX · Accident · 2 fatal · Final report · Dec 17, 1982 · N5906M · Destroyed
  > A deer hunter saw the aircraft on a final approach to an open field at dusk, with the gear and flaps down. He stated that when it was at about 100 ft AGL, the nose pitched down and the plane struck the ground and burst into flames. The aircraft was loaded…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2076404')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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