# NTSB investigations, FL: Undetermined

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 MIA95LA166](https://openairdocs.org/ntsb/MIA95LA166.md): Piper PA-23-250 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Jun 28, 1995 · N25AT · Substantial damage
  > Unknown.
- [NTSB MIA92LA151](https://openairdocs.org/ntsb/MIA92LA151.md): Consolidated Aeronautics LA-4-200 · FL · Accident · No injuries · Limited investigation · Final report · Jul 9, 1992 · N2969P · Substantial damage
  > Substantial damage to the airplane during Unknown phase of flight for undetermined reasons.
- [NTSB MIA87LA161](https://openairdocs.org/ntsb/MIA87LA161.md): Piper PA-23-250 · Missing, FL · Accident · 2 fatal · Limited investigation · Final report · May 14, 1987 · N640CC · Destroyed
  > The acft failed to arrive at its destination on a flight from miami, FL to aruba, netherland antilles via andros is, great inagua & port au prince. According to a flt plan filed by the plt the acft carried enough fuel for 8 hours & 30 minutes of flt, along…
- [NTSB MIA87LA034](https://openairdocs.org/ntsb/MIA87LA034.md): Cessna 152 · Lantana, FL · Accident · No injuries · Limited investigation · Final report · Nov 22, 1986 · N24298 · Substantial damage
  > The pilot stated the aircraft performed sluggishly during takeoff and would not climb to clear trees at the departure end of the runway. The takeoff was aborted and the aircraft overran the runway encountering sand and nosing over. The pilot stated that…
- [NTSB MIA84LA128](https://openairdocs.org/ntsb/MIA84LA128.md): Cessna 172 · Marathon, FL · Accident · 4 fatal · Limited investigation · Final report · Apr 2, 1984 · N64110 · Destroyed
  > The acft was missing after departing on a flt from maraton, FL to everglades city, FL. Sar personnel found the bodies of the plt & 3 pax, but the acft was not found. It was presumed to have been destroyed during a crash in the gulf of Mexico.
- [NTSB MIA84LA089](https://openairdocs.org/ntsb/MIA84LA089.md): Cessna P-210N · Key West, FL · Accident · 2 fatal · Limited investigation · Final report · Feb 21, 1984 · N731NJ · Destroyed
  > During his wx briefing the plt was given the flight precautions & enroute forecast along his proposed route of flt. Enroute at 14,000 ft the plt advised ARTCC that the flt had encountered rime ice. The controller cleared the flt to descend to 12,000 ft & the…

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

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