# NTSB investigations, FL: Ditching

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 MIA95LA084](https://openairdocs.org/ntsb/MIA95LA084.md): Bell 206L · Miami, FL · Accident · No injuries · Limited investigation · Final report · Mar 6, 1995 · N164BH · Substantial damage
  > The failure of the pilot-in-command to maintain adequate engine power while maneuvering, his failure to take remedial action to recover from the resulting descent, and his decision to make a precautionary landing on the water.
- [NTSB MIA84LA250](https://openairdocs.org/ntsb/MIA84LA250.md): Piper PA-31-350 · Marathon, FL · Accident · No injuries · Limited investigation · Final report · Sep 6, 1984 · N4499B · Substantial damage
  > The coast guard was alerted to a ditched acft in the atlantic ocean near Marathon, FL. The CG found the wreckage of a PA-31 and 27 bales of marijuana in and around the wreckage. Two men in a life raft, whose cover was still in the acft, were arrested.…
- [NTSB MIA84LA173](https://openairdocs.org/ntsb/MIA84LA173.md): Piper PA-32R-300 · Venice, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 24, 1984 · N1931H · Destroyed
  > The acft was ditched in the gulf of Mexico after being followed by U.S. Customs. The plt was picked up, but would not state his departure point or destination, nor did he submit a plt/operational acft accident report as requested by the NTSB.

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 150)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=150&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.