NTSB investigations, FL
8 cases where the defining event was Dynamic rollover.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 1 |
| 2012 | 1 |
| 2019 | 1 |
| 2022 | 1 |
| 2025 | 1 |
| 2026 | 2 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '231')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '231') 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 ERA26LA304Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Miramar, FLThe flight instructor’s failure to maintain control of the helicopter during a hover, which resulted in the left skid contacting ground and a subsequent dynamic rollover.NTSB ANC26LA051Accident · Minor injuriesClass 3 · LimitedPreliminary reportRobinson R44 · Pembroke Pines, FLOn June 13, 2026, about 1318 eastern daylight time, a Robinson R44 Raven I helicopter, N336SG, was substantially damaged when it was involved in an accident at the North Perry Airport (HWO), Hollywood, Florida. The pilot and three passengers sustained minor…NTSB ERA25LA160Accident · No injuriesClass 4 · LimitedFinal reportRotorway Exec · Chuluota, FLThe pilot’s failure to maintain lateral control of the helicopter during takeoff, which resulted in a dynamic rollover.NTSB ERA22LA328Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Orlando, FLThe flight instructor’s inadequate remedial actions following the student pilot’s improper control inputs, which resulted in dynamic rollover.NTSB ERA20LA004Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58A · Fort Meade, FLThe pilot's failure to maintain control of the helicopter, which resulted in a dynamic rollover and impact with terrain.NTSB ERA12LA210Accident · Minor injuriesLimited investigationFinal reportBell 206B · Titusville, FLThe flight instructor's attempted takeoff in gusting wind conditions while the student pilot was adjusting her anti-torque pedals, which resulted in a dynamic rollover event.NTSB ERA10CA319Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · West Palm Beach, FLThe CFI's failure to prevent ground contact during hover, which resulted in a dynamic rollover.NTSB ERA09CA249Accident · No injuriesData collectionFinal reportBell 206 · West Palm Beach, FLThe pilot’s failure to maintain aircraft control during taxi, which resulted in a dynamic rollover.