NTSB investigations, OK
32 cases where the sequence of events included Hard landing.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 1 |
| 2012 | 3 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 4 |
| 2024 | 2 |
| 2025 | 1 |
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 c.\"eventStateOrRegion\" = 'OK' 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 c."eventStateOrRegion" = 'OK' 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 CEN25LA350Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Ardmore, OKThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB CEN24LA219Accident · Serious injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-23H-15 · Chouteau, OKThe student pilot’s failure to maintain control of the glider while landing. Contributing to the accident was the unclear communications between the student pilot and instructor.NTSB CEN24LA122Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Tulsa, OKThe pilot's inadvertent retraction of the flaps while landing which resulted in a hard landing and loss of directional control.NTSB CEN24LA070Accident · No injuriesClass 4 · LimitedFinal reportHelicopteres Guimbal Cabri G2 · Claremore, OKThe flight instructor’s failure to maintain sufficient rotor speed during a practice autorotation which resulted in a hard landing.NTSB CEN24LA004Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Hochatown, OKA total loss of engine power during a practice autorotation due to the improper engine idle setting and rigging of the carburetor heat control which resulted in a hard landing.NTSB CEN23LA152Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Goldsby, OKThe engine electronic ignition system became disconnected, which resulted in a partial loss of engine power.NTSB CEN23LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · Oklahoma City, OKThe pilot’s improper landing flare, which resulted in a hard, bounced landing, runway excursion, and subsequent collision with a runway sign. Contributing to the accident was the pilot’s lack of experience in the airplane, the unstabilized approach, and…NTSB CEN22LA443Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Owasso, OKThe student pilot’s failure to maintain a proper descent rate during the short field landing.NTSB CEN22LA294Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · Idabel, OKThe pilot’s failure to apply full power during the practice autorotation recovery, which resulted in a hard landing.NTSB CEN21LA153Accident · No injuriesClass 4 · LimitedFinal reportEurocopter EC130 · Tulsa, OKThe pilot’s improper decision to approach the airport and enter a low altitude hover with a gusting quartering tailwind, which resulted in a loss of tail rotor effectiveness during a turn at a low altitude.NTSB CEN20CA226Accident · No injuriesClass 4 · Data collectionFinal reportBellanca 17 30 · Talihina, OKThe pilot's failure to maintain control of the airplane during a crosswind landing, which resulted in a hard landing and runway excursion.NTSB CEN20CA152Accident · No injuriesData collectionFinal reportCessna 172 · Enid, OKThe flight instructor's delayed remedial action during a power-off approach and go-around in gusting wind conditions, which resulted in a hard landing, loss of directional control, and a runway excursion onto a field.NTSB CEN19TA327Accident · No injuriesClass 3Final reportPiper PA60 · Tulsa, OKThe pilot's improper landing flare, which resulted in an aerodynamic stall and hard landing.NTSB CEN19TA328Accident · Serious injuriesClass 3Final reportLindstrand 105A · Lawton, OKA hard landing, which resulted the basket tipping over and a passenger sustaining a serious injury.NTSB CEN19LA106Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Madill, OKThe failure of the V-belts due to improper maintenance, which resulted in the loss of power to the helicopter's rotor system and subsequent forced landing on rough terrain.NTSB CEN17LA357Accident · Minor injuriesLimited investigationFinal reportBeech A36 · McAlester, OKA total loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN16LA183Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US Z-150 · Edmond, OKThe pilot’s failure to control the balloon’s descent rate during the landing approach, which resulted in a hard landing.NTSB GAA16CA208Accident · No injuriesData collectionFinal reportCessna 172 · Durant, OKThe pilot candidate's incorrect action performance by pulling the throttle off early and the subsequent failure to maintain the descent rate, resulting in a hard landing.NTSB CEN15CA121Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe pilot's improper landing technique which resulted in a hard landing and subsequent nose landing gear collapse.NTSB CEN13FA121Accident · Serious injuriesField investigationFinal reportEurocopter EC130 B4 · Seminole, OKThe loss of engine power due to ice ingestion. Contributing to the accident was maintenance personnel’s delayed decision to install the helicopter's engine inlet cover until after the engine had been exposed to moisture and freezing temperatures and their…NTSB CEN13FA080Accident · Minor injuriesField investigationFinal reportCessna 208B · Bryans Corner, OKThe total loss of engine power as a result of a fractured compressor turbine blade due to fatigue cracking.NTSB CEN12CA671Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Goldsby, OKThe commercial pilot did not attain the proper touchdown point during the landing, which resulted in a premature touchdown and an impact with the edge of the runway surface.NTSB CEN12CA269Accident · No injuriesData collectionFinal reportEurocopter AS 350 B2 · Hugo, OKThe pilot’s inadequate collective control inputs while performing a hovering autorotation, which resulted in a hard landing. Contributing to the accident was the check airman's delayed remedial action.NTSB CEN12CA054Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8F · Woodward, OKThe student pilot’s hard landing and subsequent loss of directional control.NTSB CEN10CA517Accident · Minor injuriesData collectionFinal reportBeech D35 · Guymon, OKThe loss of engine power for undetermined reasons.NTSB CEN10LA303Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Kingfisher, OKThe pilot's inadequate airspeed while landing, which led to an aerodynamic stall and a hard landing.NTSB CEN10CA132Accident · No injuriesData collectionFinal reportCessna 172 · Davis, OKThe flight instructor’s improper recovery from a bounced landing.NTSB CEN09CA199Accident · No injuriesData collectionFinal reportRoach Neil Glasair SU · Tulsa, OKThe pilot's improper flare, and the flight instructor's delayed remedial action.NTSB CEN09LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe pilot's improper flare and recovery from a bounced landing.NTSB CEN09CA133Accident · Minor injuriesData collectionFinal reportBrantly B-2B · Cement, OKThe pilot's failure to maintain proper airspeed and descent rate during approach, which resulted in a hard landing. Contributing to the accident were the nearby power lines.NTSB DEN08LA111Accident · No injuriesLimited investigationFinal reportCessna 172R · Tishomingo, OKThe pilot's failure to maintain aircraft control, resulting in an inadvertent stall during the landing flare. Contributing factors in this accident was the terrain-induced turbulence, and the instructor's inadequate supervision of the pilot.NTSB DFW08CA083Accident · No injuriesData collectionFinal reportCessna 150 · Idabell, OKThe pilot's inadequate compensation for wind conditions. Factors contributing to the accident are high and gusting winds.