NTSB investigations, FL
9 cases where NTSB found Pole.
Cases per year
| 2009 | 1 |
|---|---|
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2025 | 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\", '03022010'))
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", '03022010')) 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 ERA26LA068Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Fort Pierce, FLThe pilot’s inadequate visual lookout while taxing, which resulted in the airplane striking a light pole.NTSB ERA19TA146Accident · No injuriesClass 3Final reportCessna 172 · Fort Myers, FLThe pilot's failure to remain clear of a light pole while taxiing.NTSB ERA19LA097Accident · No injuriesLimited investigationFinal reportPiper PA28 · Vero Beach, FLThe pilot's failure to use carburetor heat while operating the airplane in weather conditions and at engine power settings conducive to the formation of carburetor ice, which resulted in a loss of engine power due to carburetor icing and the subsequent forced…NTSB ERA18LA086Accident · Minor injuriesClass 3 · LimitedFinal reportStearman B75 · Zephryhills, FLThe pilot's inadequate preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power and impact with a pole during a forced landing.NTSB ERA17LA242Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Key Biscayne, FLThe nearly complete blockage of the right fuel tank strainer with organic material, which resulted in fuel starvation and the subsequent total loss of engine power. Contributing to the fuel starvation was the pilot receiving instruction’s and the flight…NTSB GAA16CA186Accident · No injuriesData collectionFinal reportCessna 172 · Punta Gorda, FLThe pilot's failure to avoid obstacles and maintain situational awareness while taxiing.NTSB ERA16LA111Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pembroke Pines, FLThe loss of engine power while on approach for reasons that could not be determined based on the available evidence.NTSB GAA16LA135Accident · No injuriesLimited investigationFinal reportPinkston Randy T RV-7 · Tavernier, FLThe pilot's misidentification of a parallel roadway for the runway and the airplane's subsequent collision with numerous objects during landing.NTSB ERA09CA361Accident · No injuriesData collectionFinal reportHummelbird Hummelbird · Sunrise, FLA partial loss of engine power during cruise flight for an undetermined reason.