NTSB investigations, 2017, FL
14 cases where the sequence of events included Runway excursion.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 14 |
| 2010 | 14 |
| 2011 | 18 |
| 2012 | 15 |
| 2013 | 9 |
| 2014 | 17 |
| 2015 | 15 |
| 2016 | 17 |
| 2017 | 14 |
| 2018 | 17 |
| 2019 | 11 |
| 2020 | 18 |
| 2021 | 16 |
| 2022 | 9 |
| 2023 | 12 |
| 2024 | 17 |
| 2025 | 8 |
| 2026 | 8 |
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 year(c.\"eventDate\") = 2017
AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '300' 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 year(c."eventDate") = 2017 AND c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '300' 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 GAA18CA053Accident · No injuriesData collectionFinal reportPiper PA 28R · Melborne, FLThe pilot’s loss of directional control during the landing roll on the wet runway.NTSB ANC18LA009Accident · No injuriesLimited investigationFinal reportCessna 172RG · Opa Locka, FLA failure of the airplane 's electrical system, which led to the failure of the landing gear system, for reasons that could not be determined because postaccident examination and testing revealed no mechanical anomalies that would have precluded normal…NTSB GAA18CA035Accident · No injuriesData collectionFinal reportSmith Aerostar 600A · Tallahassee, FLThe pilot's incorrect pitch control and premature landing gear retraction during the initial climb.NTSB ERA17LA306Accident · No injuriesLimited investigationFinal reportKerr Gerald Velocity SUV · St. Petersburg, FLThe pilot's misjudgment of the airplane’s speed and the distance remaining during landing and his improper decision to not abort the landing.NTSB GAA17CA391Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Ferguson, FLThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB GAA17CA350Accident · No injuriesData collectionFinal reportWard Christopher Barry RAI 6 · Williston, FLThe pilot’s failure to maintain the airplane’s pitch control during rotation and his subsequent loss of directional control.NTSB GAA17CA348Accident · No injuriesData collectionFinal reportPiper PA 16 · Palatka, FLThe pilot’s failure to maintain directional control during the landing.NTSB GAA17CA277Accident · No injuriesData collectionFinal reportCessna 172 · Boca Raton, FLThe student pilot’s failure to maintain directional control of the airplane while landing with a tailwind.NTSB GAA17CA209Accident · No injuriesData collectionFinal reportCessna 140 · St. Petersburg, FLThe pilot receiving instruction’s overcorrection with rudder during the landing roll, which resulted in a ground loop and runway excursion. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB GAA17CA181Accident · No injuriesData collectionFinal reportAerotek Pitts S-2A · West Palm Beach, FLThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB ERA17LA121Accident · No injuriesLimited investigationFinal reportCessna 340 · Ft Lauderdale, FLFailure of the left main landing gear downlock link, which resulted in a landing gear collapse during the landing roll.NTSB GAA17CA163Accident · No injuriesData collectionFinal reportCessna 172S · St Petersburg, FLThe student pilot’s overcompensation of right rudder pedal application during the landing roll, which resulted in a loss of directional control and impact with runway signage and a fence.NTSB GAA17CA169Accident · No injuriesData collectionFinal reportCessna 152 · Bonifay, FLThe student pilot's failure to maintain directional control during landing in crosswind conditions.NTSB GAA17CA111Accident · No injuriesData collectionFinal reportCessna 172 · Hollywood, FLThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a hard landing.