Fatal NTSB investigations, FL

4 cases where the first occurrence was “On ground/water collision with object”.

Cases per year

19832026
Fatal NTSB investigations, FL per year, 1983–2026: 4 cases
19831
19851
19861
19921

Latest cases

Query with SQL
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.\"highestInjuryLevel\" = 'Fatal'
    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\" = 310)
  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.

NTSB MIA92LA145Accident · 1 fatalLimited investigationFinal reportRaven S-60A · Dover, FLThe pilot in commands choice of landing area near electrical lines and his failure to exit the balloon and seek safety when it was determined the deflating bag was going to make contact with power lines resulting in his receiving electrocution injuries.Jul 4, 1992 · N4037Q · Minor damageNTSB DCA87MA010Accident · 1 fatalClass 1 · MajorFinal reportPiper PA-23-150 · Tampa, FLAt aprx 0612 EST, an eastern airline capt (owner of Piper PA-23, N2185P) departed a rwy near his home in VFR conds to commute to work at Tampa, FL. Shortly after takeoff, he contacted a fss & updated the wx info he had obtained on the previous evening. At…Nov 6, 1986 · N2185P · 2 aircraft · DestroyedNTSB MIA85FA122Accident · 1 fatalField investigationFinal reportPiper J3C-85 · Winter Haven, FLWhile taxiing back to the seaplane ramp after landing the acft struck a small fishing boat causing fatal injuries to the boats sole occupant. The acft was being taxied at high speed on the step and s turns where being made to clear the area due to the plt not…Mar 16, 1985 · N6716H · Minor damageNTSB MIA83LA084Accident · 1 fatalLimited investigationFinal reportPiper PA-32R · Cross City, FLThe acft collided with trees during a night landing on a lonely stretch of country road. The landing was an attempt to unload 662 pounds of marijuana in an illegal drug operation.a passenger was fatally injured and the injured pilot was found later in the…Mar 1, 1983 · N3898F · Destroyed