NTSB investigations, 2019, FL
17 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\") = 2019
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") = 2019 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 ERA20CA078Accident · No injuriesData collectionFinal reportCessna 172 · Ormond Beach, FLThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA20CA138Accident · Serious injuriesData collectionFinal reportLindstrand 180A · Davenport, FLThe pilot’s failure to maintain the proper descent rate during the approach to landing, which resulted in a hard landing and serious injury to a passenger.NTSB GAA20CA067Accident · No injuriesData collectionFinal reportCessna 172 · Pembroke Pines, FLThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with a taxiway sign.NTSB GAA20CA062Accident · No injuriesData collectionFinal reportBell 47G · Groveland, FLThe student pilot's improper cyclic input after a reported hydraulic failure, the reason for which could not be determined, and his failure to follow the emergency procedures, which resulted in a hard landing.NTSB ERA20LA037Accident · Serious injuriesClass 3 · LimitedFinal reportMosquito XE · Seffner, FLThe pilot's failure to maintain control of the helicopter while landing, which resulted in a hard landing and dynamic rollover. Contributing to the accident was the pilot's lack of helicopter experience.NTSB GAA20CA088Accident · Serious injuriesData collectionFinal reportHiggins John H/Williams John D Questair Venture · Daytona Beach, FLThe pilot's unstabilized approach, which resulted in a hard, bounced landing, loss of directional control, and impact with a tree and then terrain.NTSB GAA20CA091Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 · Apopka, FLThe student pilot's improper landing flare, which resulted in a hard, bounced landing and subsequent nose-over.NTSB GAA19CA590Accident · No injuriesData collectionFinal reportCessna 172 · St. Augustine, FLThe student pilot's improper landing flare, which resulted in a bounced, hard landing.NTSB ERA19LA282Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 337 · St. Augustine, FLThe failure of the pilot and examiner to recognize that the rear engine was not developing power, which resulted in an attempted partial-power takeoff and the airplane’s subsequent descent and impact with terrain.NTSB GAA19CA581Accident · No injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot's improper landing flare, which resulted in a hard landing and a collapsed nose landing gear.NTSB ERA19TA276Accident · No injuriesClass 3Final reportBeech 23 · Panama City, FLA total loss of engine power due to an obstructed fuel vent, and the flight instructor's failure to ensure that the student did an adequate preflight inspection, which resulted in a forced landing.NTSB ERA19TA211Accident · No injuriesClass 3Final reportCessna 208 · Plant City, FLThe pilot's improper landing flare due to reduced visibility from a foggy windshield and his failure to use the airplane’s windshield defrost system, which resulted in a hard landing and subsequent nose landing gear collapse.NTSB GAA19CA337Accident · No injuriesData collectionFinal reportVans RV10 · Fort Drum, FLThe pilot's failure to maintain the proper airspeed during approach, which resulted in an aerodynamic stall.NTSB ERA19FA142Accident · 1 fatalField investigationFinal reportRobinson R44 II · Tampa, FLContamination of and an inadequate bond between the two layers of fabric comprising the helicopter engine's air induction inlet duct, which resulted a partial collapse of the duct, obstruction of the airflow into the engine, and a total loss of engine power.NTSB ERA19LA126Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58A · Ponte Vedra Beach, FLA total loss of engine power due to the introduction of air into fuel lines and an interruption of fuel flow to the engine.NTSB ERA19TA114Accident · Serious injuriesFinal reportRempe Kitfox · Merritt Island, FLThe pilot's failure to maintain airplane control during an attempted go-around.NTSB GAA19CA121Accident · No injuriesData collectionFinal reportEurocopter AS 350 · Tampa, FLThe pilot's improper landing flare while practicing autorotations, which resulted in a hard, bounced landing.