# NTSB investigations, FL: Missing aircraft

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 MIA01FAMS1](https://openairdocs.org/ntsb/MIA01FAMS1.md): Cessna 150 · Missing, FL · Accident · 1 fatal · Missing aircraft · Final report · Oct 27, 2000 · N11214 · Destroyed
  > undetermined.
- [NTSB MIA95FAMS1](https://openairdocs.org/ntsb/MIA95FAMS1.md): Piper PA-28-161 · Missing, FL · Accident · 1 fatal · Missing aircraft · Final report · Dec 25, 1994 · N5916V · Destroyed
  > Undetermined.
- [NTSB MIA93FAMS2](https://openairdocs.org/ntsb/MIA93FAMS2.md): Cessna 152 · FL · Accident · 1 fatal · Missing aircraft · Final report · Sep 30, 1993 · N93261 · Destroyed
  > undetermined.
- [NTSB MIA91FAMS1](https://openairdocs.org/ntsb/MIA91FAMS1.md): Piper PA-24-260 · Missing, FL · Accident · 1 fatal · Missing aircraft · Final report · Apr 24, 1991 · N8938P · Destroyed
  > Undetermined.
- [NTSB MIA90LA061](https://openairdocs.org/ntsb/MIA90LA061.md): Cessna 152 · Missing, FL · Accident · 2 fatal · Limited investigation · Final report · Jan 24, 1990 · N4802B · Destroyed
  > Undetermined.
- [NTSB MIA85LA249](https://openairdocs.org/ntsb/MIA85LA249.md): Piper PA-28-160 · Key West, FL · Accident · 2 fatal · Limited investigation · Final report · Sep 9, 1985 · N5488W · Destroyed
  > The acft failed to arrive at its intended destination on a flt plan from ft. lauderdale FL. To Key West FL. Navy Key West apch was providing VFR flt following, radar & radiocontact was lost with the acft 20 NE of Key West. The whereabouts of the occupants are…
- [NTSB MIA85LAMS2](https://openairdocs.org/ntsb/MIA85LAMS2.md): Cessna 337 · Atlantic Ocean, FL · Accident · 4 fatal · Final report · Jan 14, 1985 · N505CX · Destroyed
  > The acft was reported missing and search & rescue control center initiated a search on 1-17-85. The search was suspendedon 1-24-85. The last reported position of the acft was 66 miles northeast of jacksonville, FL. The acft is still missing & the damage index…
- [NTSB MIA84LA114](https://openairdocs.org/ntsb/MIA84LA114.md): Piper PA-28-235 · Sanibel Island, FL · Accident · 4 fatal · Limited investigation · Final report · Mar 12, 1984 · N39677 · Destroyed
  > The acft failed to arrive at its destination. A satellite photo of the area showed wx & cloud cover between the departure & destination arpts. Radar data showed that an acft had left key west, FL, at about 1700, went northbound at 4500 until it encounter bad…
- [NTSB MIA84LA035](https://openairdocs.org/ntsb/MIA84LA035.md): Cessna 340A · Nr. Orangeville, FL · Accident · 1 fatal · Limited investigation · Final report · Nov 20, 1983 · N85JK · Destroyed
  > The acft disappeared fm radar coverage while in cruise flt at 10,000 feet MSL near Orangeville, FL. The ATC transcript revealed that the plt had been inquiring abt the weather ahead of him and was cleared to descend to 6000 in order to get below strong…
- [NTSB MIA84LA007](https://openairdocs.org/ntsb/MIA84LA007.md): Cessna T-210-J · FL · Accident · 3 fatal · Limited investigation · Final report · Oct 4, 1983 · N2284R · Destroyed
  > This acft is missing on a flt from andros town, Bahamas to ft. pierce, FL. After departure the acft contacted nassau to file a VFR clearance and called miami fss to report 60 DME east of ft. lauderdale in heavy rain. The plt requested information on how to…
- [NTSB MIA82DA157](https://openairdocs.org/ntsb/MIA82DA157.md): Piper PA-28R-201T · West Of Cross C, FL · Accident · 4 fatal · Final report · Jul 5, 1982 · N505HP
  > At about 1605 CDT, the pilot activated his VFR flight plan from nashville, TN to venice, FL. At 1813, the pilot contacted tallahasee fss and was briefed on the weather conditions to sarasota, FL. This was the last known radio communication with the aircraft.…

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

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