NTSB investigations, 2010, FL
18 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\") = 2010
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") = 2010 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 ERA10TA481Accident · No injuriesFinal reportPiper PA-34-200T · Inverness, FLThe pilot's improper flare which resulted in a hard landing and subsequent collapse of the nose landing gear.NTSB ERA10CA432Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe instructor's delayed remedial action, which resulted in a loss of rotor rpm and a hard landing.NTSB ERA10LA361Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · West Melbourne, FLSeparation of the main rotor drive belts due to maintenance personnel’s failure to adequately inspect the upper drive sheave prior to installing the belts.NTSB ERA10CA336Accident · No injuriesData collectionFinal reportSchooley Sonex · Punta Gorda, FLThe pilot's improper flare, resulting in a hard landing.NTSB ERA10LA328Accident · No injuriesLimited investigationFinal reportParks J L/Dreffin D Seawind 3000 · Sanibel Island, FLAn overstress failure of the elevator. Contributing to the accident was the owner/builder's modification of the experimental airplane beyond the recommendations of the kit manufacturer.NTSB ERA10CA326Accident · No injuriesData collectionFinal reportCessna 172 · New Smyrna Beach, FLThe student pilot’s improper landing flare, and the flight instructor's delayed remedial action.NTSB ERA10CA264Accident · No injuriesData collectionFinal reportSchweizer 269C · Ormond Beach, FLThe student pilot’s improper use of collective and throttle during the landing flare.NTSB ERA10CA262Accident · Minor injuriesData collectionFinal reportHiller UH12 · Sarasota, FLThe pilot's delayed remedial action to maintain main rotor rpm, which resulted in a loss of lift and hard landing.NTSB ERA10CA255Accident · No injuriesData collectionFinal reportHughes 500 · West Palm Beach, FLThe commercial pilot's improper flare during a simulated autorotation, which resulted in a hard landing.NTSB ERA10LA235Accident · No injuriesLimited investigationFinal reportCessna 152 · Avon Park, FLThe operator's failure to correct known deficiencies with the carburetor, which resulted in a complete loss of engine power and subsequent forced landing by the pilot. Also causal was the operator's decision to rent the airplane in an unairworthy condition.NTSB ERA10CA218Accident · No injuriesData collectionFinal reportCessna 150G · Winter Haven, FLThe student pilot's inadequate recovery from a bounced landing in gusting winds.NTSB ERA10CA200Accident · No injuriesData collectionFinal reportCessna 172 · Sarasota, FLThe student pilot's inadequate recovery from a bounced landing.NTSB ERA10CA191Accident · No injuriesData collectionFinal reportBeech 58 · Naples, FLThe pilot's improper flare while landing, resulting in a bounced landing.NTSB ERA10CA198Accident · No injuriesData collectionFinal reportCessna 152 · Venice, FLThe student pilot's improper flare and recovery from a bounced landing.NTSB ERA10CA208Accident · No injuriesData collectionFinal reportCessna 172P · Ft. Pierce, FLThe student pilot's improper flare and the flight instructor's delayed remedial action, resulting in a hard landing.NTSB ERA10CA213Accident · No injuriesData collectionFinal reportCessna 172P · Fort Pierce, FLThe student pilot’s improper flare and recovery from a bounced landing.NTSB ERA10CA143Accident · No injuriesData collectionFinal reportCessna 172P · Fort Pierce, FLThe student pilot's improper flare during landing.NTSB ERA10CA145Accident · No injuriesData collectionFinal reportClopton Aero Aerocomp Compair 7SL · Merritt Island, FLThe pilot’s failure to maintain control of the airplane during landing.