NTSB investigations, 2014, FL
16 cases where the sequence of events included Hard landing.
Cases per year
| 2008 | 17 |
|---|---|
| 2009 | 7 |
| 2010 | 18 |
| 2011 | 16 |
| 2012 | 12 |
| 2013 | 11 |
| 2014 | 16 |
| 2015 | 8 |
| 2016 | 6 |
| 2017 | 13 |
| 2018 | 10 |
| 2019 | 17 |
| 2020 | 5 |
| 2021 | 10 |
| 2022 | 7 |
| 2023 | 7 |
| 2024 | 10 |
| 2025 | 7 |
| 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\") = 2014
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\" = '092' 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") = 2014 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" = '092' 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 ERA15FA085Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Lake Worth, FLA main rotor stall due to low rotor rpm, which resulted in an uncontrolled descent into terrain. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA15CA069Accident · No injuriesData collectionFinal reportPiper PA-46-310P · Wachula, FLThe pilot's improper recovery from a bounced landing during gusty crosswind conditions.NTSB ERA15CA038Accident · No injuriesData collectionFinal reportCessna 172P · Miami, FLThe failure of the student pilot to achieve a proper touchdown during a touch-and-go landing resulting in a hard landing and substantial damage.NTSB ERA15LA060Accident · No injuriesLimited investigationFinal reportBell 206B · West Palm Beach, FLA hard landing for reasons that could not be determined based on the available evidence.NTSB ERA14CA452Accident · No injuriesData collectionFinal reportCessna 172S · Naples, FLThe student pilot's improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot's self-induced pressure to land due to the deteriorating weather conditions.NTSB ERA14CA406Accident · No injuriesData collectionFinal reportPiper PA 34-200T · Gainesville, FLThe pilot's inadequate landing flare, which resulted in a bounced landing.NTSB ERA14CA348Accident · Minor injuriesData collectionFinal reportSchweizer 269C · Titusville, FLThe student pilot's failure to initiate the decelerative flare during autorotation and the CFI's delayed remedial action, which resulted in a hard landing.NTSB ERA14LA344Accident · No injuriesLimited investigationFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Melbourne, FLA total loss of engine power during cruise flight for reasons that could not be determined based on the available information.NTSB ERA14CA331Accident · No injuriesData collectionFinal reportCessna 172M · Miami, FLThe pilot's failure to ensure the security of the seat prior to flight, which resulted in a loss of control and subsequent hard landing.NTSB ERA14LA309Accident · Minor injuriesLimited investigationFinal reportSimmons William E Aventura 2 · Rockledge, FLThe pilot’s failure to maintain airspeed during a forced landing following a loss of engine power, which resulted in a hard landing. Contributing to the accident was the pilot’s inadequate inspection of the engine, which resulted in a loose ground wire lug on…NTSB ERA14LA279Accident · No injuriesLimited investigationFinal reportFrederick Hays-Roth Velocity Twin · Sebastian, FLThe pilot’s improper landing flare, which resulted in a bounced landing. Also causal to the accident were the pilot’s subsequent delayed decision to abort the landing and his improper execution of the aborted landing, which resulted in the airplane exceeding…NTSB ERA14CA197Accident · No injuriesData collectionFinal reportCessna 162 · Leesburg, FLThe student pilot's inadequate landing flare, which resulted in a hard landing.NTSB ERA14LA152Accident · Serious injuriesLimited investigationFinal reportKurtz Jay B RV-9A · Live Oak, FLThe pilot’s improper recovery from a bounced landing, which resulted in an aerodynamic stall, a subsequent nose-down landing, and excessive bending loads to the nose landing gear.NTSB ERA14CA121Accident · No injuriesData collectionFinal reportCessna 172R · Fort Pierce, FLThe student pilot's improper landing flare, which resulted in a hard landing.NTSB ERA14CA109Accident · No injuriesData collectionFinal reportCessna 172S · Immokalee, FLThe student pilot's improper landing flare, which resulted in a hard landing.NTSB ERA14LA103Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Zephyrhills, FLThe pilot’s inadequate compensation for gusting wind conditions, which resulted in a hard landing that produced forces beyond the structural capability of the airframe.