NTSB investigations, FL

11 cases where the first occurrence was “Missing aircraft”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations, FL per year, 1982–2026: 11 cases
1982	1
1983	2
1984	1
1985	2
1990	1
1991	1
1993	1
1994	1
2000	1

Where

Open the map

Latest cases

Query with 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

duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB MIA01FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 150 · Missing, FLundetermined.Oct 27, 2000 · N11214 · Destroyed NTSB MIA95FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-28-161 · Missing, FLUndetermined.Dec 25, 1994 · N5916V · Destroyed NTSB MIA93FAMS2Accident · 1 fatalMissing aircraftFinal reportCessna 152 · FLundetermined.Sep 30, 1993 · N93261 · Destroyed NTSB MIA91FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-24-260 · Missing, FLUndetermined.Apr 24, 1991 · N8938P · Destroyed NTSB MIA90LA061Accident · 2 fatalLimited investigationFinal reportCessna 152 · Missing, FLUndetermined.Jan 24, 1990 · N4802B · Destroyed NTSB MIA85LA249Accident · 2 fatalLimited investigationFinal reportPiper PA-28-160 · Key West, FLThe 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…Sep 9, 1985 · N5488W · Destroyed NTSB MIA85LAMS2Accident · 4 fatalFinal reportCessna 337 · Atlantic Ocean, FLThe 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…Jan 14, 1985 · N505CX · Destroyed NTSB MIA84LA114Accident · 4 fatalLimited investigationFinal reportPiper PA-28-235 · Sanibel Island, FLThe 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…Mar 12, 1984 · N39677 · Destroyed NTSB MIA84LA035Accident · 1 fatalLimited investigationFinal reportCessna 340A · Nr. Orangeville, FLThe 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…Nov 20, 1983 · N85JK · Destroyed NTSB MIA84LA007Accident · 3 fatalLimited investigationFinal reportCessna T-210-J · FLThis 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…Oct 4, 1983 · N2284R · Destroyed NTSB MIA82DA157Accident · 4 fatalFinal reportPiper PA-28R-201T · West Of Cross C, FLAt 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.…Jul 5, 1982 · N505HP