# NTSB investigations: Cessna 414: Airframe/component/system failure/malfunction

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 LAX93FA095](https://openairdocs.org/ntsb/LAX93FA095.md): Cessna 414 · Reno, NV · Accident · 2 fatal · Field investigation · Final report · Jan 15, 1993 · N4733G · Destroyed
  > The failure of the pilot to use pitot static system covers during icing conditions which resulted in a blocked pitot tube and subsequent loss of airspeed indications. This led to pilot disorientation and an invertant stall. Factors to the accident were…
- [NTSB CHI92FA104](https://openairdocs.org/ntsb/CHI92FA104.md): Cessna 414 · Freeland, MI · Accident · 3 fatal · Field investigation · Final report · Mar 5, 1992 · N69662 · Destroyed
  > The pilot's poor judgement in attempting flight after the airplane's fuselage was damaged during a loading operation. Factors which contributed to the accident were: the operator's failure to provide proper weight and balance data for the airplane, the…
- [NTSB LAX92FA017](https://openairdocs.org/ntsb/LAX92FA017.md): Cessna 414 · Long Beach, CA · Accident · 2 fatal · Field investigation · Final report · Oct 26, 1991 · N3843C · Destroyed
  > The pilot's improper emergency procedures by not retracting the landing gear when he shut the engine down and his failure to maintain airspeed. The scavenge pump failure, shutting down the engine and the inadvertent stall were factors in the accident.
- [NTSB MKC88LA036](https://openairdocs.org/ntsb/MKC88LA036.md): Cessna 414 · Fayetteville, AR · Accident · No injuries · Limited investigation · Final report · Jan 1, 1988 · N30ML · Substantial damage
  > During an instructional flt, the CFI and student plt heard a loud pop while attempting to lower the gear in preparation for landing. Several flybys past the control tower were made to confirm an unsafe nose gear configuration. They flew the aircraft an…

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

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

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