NTSB investigations, 2012, FL
12 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\") = 2012
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") = 2012 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 ERA13LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Boca Raton, FLThe pilot's improper landing flare after a loss of engine power shortly after takeoff, which resulted in a hard landing. The reason for the loss of engine power could not be determined based on the available information.NTSB ERA13CA044Accident · No injuriesData collectionFinal reportCessna 172R · Miami, FLThe flight instructor's improper power management during a steep, obstacle-clearance approach, which resulted in a hard landing.NTSB ERA13LA043Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 42 NG · Palm Coast, FLThe pilot’s failure to maintain adequate airspeed, which resulted in a hard landing.NTSB ERA12CA560Accident · No injuriesData collectionFinal reportCessna 172S · Sebring, FLThe student pilot's improper flare, which resulted in a hard landing.NTSB ERA12CA407Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Lake Wales, FLThe flight instructor’s inadequate supervision of the student pilot’s power management, which resulted in a hard landing. Contributing to the accident was the student pilot's premature power reduction during the landing flare.NTSB ERA12LA379Accident · Minor injuriesLimited investigationFinal reportBell 427 · Indiantown, FLThe inflight collision with birds, resulting in damage to the rotor head assembly and a subsequent forced landing and rollover.NTSB ERA12CA375Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe flight instructor’s inadequate supervision and delayed remedial action during a simulated engine-out procedure, which resulted in a hard landing.NTSB ERA12LA346Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Destin, FLThe partial loss of engine power due to a stuck (open) exhaust valve in the No. 5 cylinder. Contributing to the accident was the operator’s failure to follow the engine manufacturer’s directives concerning cooling of the engine after flight.NTSB ERA12LA259Accident · No injuriesLimited investigationFinal reportCessna 172P · Brooksville, FLThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA12TA251Accident · Minor injuriesFinal reportBell 407 · Delray Beach, FLThe pilot’s improper response to a simulated engine failure and the instructor’s delayed and improper remedial action.NTSB ERA12CA242Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · New Smyrna, FLThe pilot's improper flare, which resulted in a hard landing. Contributing to the accident was the flight instructor's inadequate remedial action.NTSB ERA12CA178Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe student pilot's improper flare and recovery from a bounced landing.