Fatal NTSB investigations, FL
15 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2019 | 1 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 3 |
Where
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\" = '000' 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.
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" = '000' 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
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 ERA27FA034Accident · 1 fatalClass 3 · FieldInvestigation openRobinson Helicopter R44 II · Coral Gables, FLNTSB ERA26FA177Accident · 1 fatalClass 3 · FieldPreliminary reportRajchl Vladimir Airplane Swing 06 · O'Brien, FLOn April 16, 2026, about 1030 eastern standard time, a Rajchl Vladimir Airplane Swing 06, N613SA, was substantially damaged when it was involved in an accident near O’Brien, Florida. The private pilot was fatally injured. The airplane was operated as a Title…NTSB ANC26FA021Accident · 2 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R44 · Boynton Beach, FLOn March 23, 2026, about 1221 eastern daylight time, a Robinson R44 Raven I helicopter, N478AT, was destroyed when it was involved in an accident near Boynton Beach, Florida. The flight instructor and the pilot receiving instruction were fatally injured. The…NTSB CEN26FA005Accident · 3 fatalClass 3 · FieldPreliminary reportBeech 58P · Williston, FLOn October 5, 2025, at 1610 eastern daylight time, a Beech 58P airplane, N121GJ, was destroyed when it was involved in an accident near Williston, Florida. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB ERA24FA300Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Palm Beach Gardens, FLA loss of engine power for reasons that could not be determined.NTSB ERA22LA162Accident · 1 fatalClass 3 · LimitedFinal reportCzech Sport Piper Sport · Homestead, FLThe airplane’s collision with water for underdetermined reasons.NTSB ERA20FA025Accident · 1 fatalClass 3 · FieldFinal reportVans RV 4 · Middleburg, FLImpact with power lines for reasons that could not be determined based on available evidence.NTSB ERA14FA464Accident · 1 fatalField investigationFinal reportFortuna Dave Sonex · Dunnellon, FLThe in-flight collision with a tree in a heavily wooded area during controlled flight while the pilot was attempting a forced landing for reasons that could not be determined based on the available evidence. Contributing to the delay in locating the wreckage…NTSB ERA13FA168Accident · 3 fatalField investigationFinal reportPiper PA-31T · Fort Lauderdale, FLThe pilot's failure to maintain airplane control following an emergency, the nature of which could not be determined because of crash and fire damage, which resulted in an aerodynamic stall.NTSB ERA13FA109Accident · 2 fatalField investigationFinal reportBenton Fred D Seawind 3000 · Sarasota, FLThe pilot's inability to establish a normal climb rate after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA13FA071Accident · 1 fatalField investigationFinal reportGreen Gary E Thorp T-18 · Pahokee, FLThe descent and overstress of the airplane during the descent, which resulted in the in-flight breakup of the airplane.NTSB ERA11FA214Accident · 1 fatalField investigationFinal reportAerostar S A YAK-52 · Palm Coast, FLThe pilot’s failure to recover from the nose-low descent during an aerobatic maneuver.NTSB ERA10FA464Accident · 2 fatalField investigationFinal reportCessna 150H · DeLand, FLThe pilot's failure to maintain adequate airspeed and airplane control during the initial climb, which resulted in an aerodynamic stall, wire strike, and subsequent impact with the ground.NTSB ERA10FA232Accident · 1 fatalField investigationFinal reportMaule M5-235C · Zellwood, FLThe pilot's failure to maintain airspeed while maneuvering after takeoff, which resulted in an aerodynamic stall, loss of aircraft control, and collision with trees.NTSB ERA10FA052Accident · 1 fatalField investigationFinal reportAero Commander 100 · Weston, FLThe flight's descent for undetermined reasons, resulting in the in-flight collision with terrain.