NTSB investigations, FL
8 cases where NTSB found Main rotor system.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2021 | 1 |
| 2023 | 1 |
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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010462'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010462')) 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 ERA23LA228Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Bradenton, FLThe pilot’s failure to maintain adequate rotor rpm during landing which resulted in a premature landing on uneven ground and a subsequent rollover.NTSB ERA21LA126Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Pahokee, FLA loss of main rotor rpm for reasons that could not be determined, which resulted in an autorotation and a subsequent hard landing and rollover.NTSB ERA15LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · West Palm Beach, FLThe failure of the airplane pilots to maintain an adequate visual lookout for known traffic in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the failure of the airplane pilots to announce their intentions before…NTSB ERA13FA186Accident · 2 fatalField investigationFinal reportRobinson R44 · Miami, FLThe mechanic's failure to properly secure the pitch link hardware of one main rotor blade to the rotating swash plate, which resulted in the pitch link separating in flight and the pilot's subsequent loss of control. Contributing to the accident was the…NTSB ERA12LA379Accident · Minor injuriesLimited investigationFinal reportBell 427 · Indiantown, FLThe inflight collision with birds, resulting in damage to the rotor head assembly and a subsequent forced landing and rollover.NTSB ERA10LA190Accident · No injuriesLimited investigationFinal reportRobinson R22 · Miami, FLA loss of main rotor rpm for undetermined reasons.NTSB ERA10LA172Accident · No injuriesLimited investigationFinal reportHughes 369 · Naples, FLThe pilot's excessive aft cyclic imput during the flare following an practice autorotation, which resulted in main rotor blade contact with the tail boom.NTSB NYC08TA183Accident · Minor injuriesFinal reportRobinson R44 II · Lake Wales, FLThe pilot's improper recovery from a practice autorotation.