# NTSB investigations: Cessna 414A, FL

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 ERA26LA087](https://openairdocs.org/ntsb/ERA26LA087.md): Cessna 414A · Tampa, FL · Accident · No injuries · Class 4 · Limited · Final report · Jan 5, 2026 · N140KM · Substantial damage
  > The pilot’s failure to secure a bottle, which restricted movement of the right rudder pedal during landing.
- [NTSB ERA16FA279](https://openairdocs.org/ntsb/ERA16FA279.md): Cessna 414 · Destin, FL · Accident · 1 fatal · Field investigation · Final report · Aug 3, 2016 · N2735A · Destroyed
  > The pilot's loss of control due to spatial disorientation shortly after takeoff, while maneuvering over water during dark night conditions.
- [NTSB MIA06LA108](https://openairdocs.org/ntsb/MIA06LA108.md): Cessna 414A · Pompano Beach, FL · Accident · No injuries · Limited investigation · Final report · May 14, 2006 · N79NS · Substantial damage
  > The pilot's inadequate preflight/planning due to his failure to assure an adequate supply of fuel was available for the flight, resulting in the loss of engine power in both engines due to fuel exhaustion.

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

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

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