Fatal NTSB investigations, FL

6 cases where the sequence of events included Midair collision.

Cases per year

20082026
Fatal NTSB investigations, FL per year, 2008–2026: 6 cases
20081
20101
20171
20181
20191
20231

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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '250' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 ERA23FA142Accident · 4 fatalClass 3 · FieldFinal reportPiper J3C · Winter Haven, FLThe failure of both flight crews to see and avoid each other while operating in the airport environment.Mar 7, 2023 · N10510 · 2 aircraft · Substantial damageNTSB ERA19FA183Accident · 1 fatalClass 3 · FieldFinal reportVans Vans RV 4 · Green Cove Springs, FLThe failure of each pilot to maintain separation from the other airplane during intentional maneuvers within close proximity of each other.May 29, 2019 · N319RL · 2 aircraft · DestroyedNTSB ERA18FA194Accident · 4 fatalField investigationFinal reportPiper PA34 · Miami, FLThe failure of both pilots in both airplanes to see and avoid the other airplane as they converged nearly head-on at the same altitude.Jul 17, 2018 · N16281 · 2 aircraft · DestroyedNTSB ERA17FA143Accident · 2 fatalField investigationFinal reportCessna 170B · Edgewater, FLThe Cessna pilot's failure to maintain clearance from the Grumman during the transition to a different formation. Contributing to the accident was the stepped down configuration of the formation flight which was composed of dissimilar aircraft.Apr 1, 2017 · N8082A · 2 aircraft · DestroyedNTSB ERA10FA180Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Williston, FLThe pilots of both airplanes did not maintain an adequate visual lookout to see and avoid each other.Mar 20, 2010 · N823AG · 2 aircraft · Substantial damageNTSB ERA09FA080Accident · 4 fatalField investigationFinal reportPiper PA-44-180 · Ft. Lauderdale, FLThe failure of both pilots to see and avoid the other aircraft.Dec 6, 2008 · N118TP · 2 aircraft · Substantial damage