NTSB investigations, FL
14 cases where NTSB found Surface speed/braking.
Cases per year
| 2008 | 2 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 2 |
| 2019 | 1 |
| 2020 | 2 |
| 2022 | 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\", '01062045'))
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", '01062045')) 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 ERA22LA250Accident · No injuriesClass 4 · LimitedFinal reportCessna 340 · St. Petersburg-Clearwater, FLThe pilot’s inability to stop the airplane on the available runway, which resulted in a runway excursion and collision with an airport perimeter fence.NTSB ERA21LA036Accident · Minor injuriesClass 3 · LimitedFinal reportRaytheon 400A · Fernandina Beach, FLThe flight crew's improper decision to land with a tailwind on a wet runway, which resulted in a runway overrun. Contributing to the accident was the copilot’s early retraction of the speed brakes and the pilot’s decision to turn off the anti-skid system.NTSB ERA20CA276Accident · No injuriesClass 4 · Data collectionFinal reportCessna 177RG · Lakeland, FLThe pilot’s failure to maintain control of the airplane during the attempted engine start.NTSB GAA19CA488Accident · No injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot's improper decision to turn off the runway while the airplane was moving too fast after landing, which resulted in a runway excursion and impact with a taxiway sign.NTSB ERA17CA208Accident · No injuriesData collectionFinal reportPiper PA23 · Cedar Key, FLThe pilot's failure to stop the airplane within the available runway after conducting the approach and landing with a tailwind.NTSB ERA17LA091Accident · Serious injuriesLimited investigationFinal reportAmerican Legend AL3 · Pierson, FLThe pilot's improper braking during takeoff, which resulted in a nose-over.NTSB GAA17CA084Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Pensacola, FLThe student pilot’s incorrect brake application during the landing roll, which resulted in a loss of directional control.NTSB ERA15LA380Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Sarasota, FLThe pilot’s failure to attain the proper touchdown point and to adequately slow the airplane within the available runway, which resulted in a runway overrun.NTSB GAA15CA220Accident · No injuriesData collectionFinal reportCessna 150M · Apopka, FLFollowing a bird strike during takeoff, the pilot's decision to land without sufficient runway remaining to safely stop the airplane, which resulted in an over-run, collision with terrain, and nose over.NTSB ERA14LA159Accident · No injuriesLimited investigationFinal reportCessna 500 · Zephyrhills, FLThe pilots' inadequate in-flight planning and improper selection of runway 36 for landing, which resulted in a significant quartering tailwind during the landing, exceedance of the airplane's braking capability, and a subsequent runway overrun.NTSB ERA12CA173Accident · No injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Winter Haven, FLThe flight instructor’s delayed remedial action to prevent the airplane from hitting the hangar door. Contributing to the accident was the student pilot's misuse of the airplane's throttle, and his incorrect use of the wheel brakes.NTSB ERA11CA132Accident · No injuriesData collectionFinal reportCessna 172S · St. Petersburg, FLThe student pilot's failure to maintain directional control while attempting to turn the airplane onto a taxiway after landing.NTSB MIA08LA123Accident · No injuriesLimited investigationFinal reportCirrus Design SR-20 · Williston, FLThe student pilot’s failure to follow the manufacturer's recommended taxiing procedures.NTSB LAX08CA120Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Plant City, FLThe pilot's excessive taxi speed, which led to a loss of control.