NTSB investigations, OK
60 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 2 |
| 1984 | 5 |
| 1985 | 4 |
| 1986 | 1 |
| 1987 | 3 |
| 1988 | 1 |
| 1991 | 3 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 4 |
| 2003 | 2 |
| 2005 | 5 |
| 2006 | 1 |
| 2007 | 5 |
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200) 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 DFW08CA028Accident · No injuriesData collectionFinal reportCessna 152 · Ardmore, OKThe pilot's improper landing flare which resulted in a hard landing.NTSB DFW08CA021Accident · No injuriesData collectionFinal reportCessna 172 · Stillwater, OKThe student pilot's improper recovery from a bounced landing.NTSB DFW07CA196Accident · No injuriesData collectionFinal reportInterplane Skyboy · Atoka, OKThe pilot's improper landing flare, resulting in a hard landing.NTSB DFW07FA084Accident · 1 fatalField investigationFinal reportBeech 58P · Marietta, OKThe pilot's improper landing flare. A contributing factor was the premature touchdown in an area of rising terrain.NTSB DFW07CA083Accident · No injuriesData collectionFinal reportCessna 150 · Sand Springs, OKThe pilot's improper recovery from a bounced landing.NTSB DFW06LA060Accident · No injuriesLimited investigationFinal reportCessna 175 · Lindsay, OKThe hard landing was the result of the pilot's failure to maintain adequate airspeed while misjudging the altitude above the runway. Contributing factors were the inadequate quality of the manufacturer's engine-support bracket and the prevailing night…NTSB DFW05CA248Accident · No injuriesData collectionFinal reportPiper PA-46T · El Reno, OKThe improper flare which resulted in a hard landing. A related factor was the instructor's delayed remedial action.NTSB DFW05CA224Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe pilot's improper recovery from a bounced landing. A contributing factor was the dark night conditions.NTSB DFW05FA178Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Norman, OKThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A contributing factor was the pilot's attempted aborted landing following a hard landing and propeller strike.NTSB DFW05CA164Accident · No injuriesData collectionFinal reportCessna 152 · Burneyville, OKThe students pilot's improper flare and his failure to maintain directional control of the airplane. A contributing factor was the bounced landing.NTSB DFW05CA097Accident · No injuriesData collectionFinal reportCessna 152 · Shawnee, OKThe pilot's improper landing flare and his inadequate recovery from a bounced landing. A factor was the prevailing crosswind.NTSB FTW03LA177Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Bristow, OKThe pilot's premature retracting of the flaps, and his failure to maintain airspeed which resulted in an inadvertent stall.NTSB FTW03LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Durant, OKThe student pilot's improper landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.NTSB FTW03LA009Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe pilot's improper recovery from a bounced landing and his failure to maintain airspeed. A contributing factor was the pilot's failure to align with the runway.NTSB FTW03LA002Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Norman, OKThe pilot's failure to maintain directional control. A factor was the inadequate flare.NTSB FTW02LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKthe pilot's improper recovery from a bounced landing, which resulted in a hard landing.NTSB FTW02LA240Accident · Serious injuriesLimited investigationFinal reportBalloon Works FireFly 7B-15 · Oklahoma City, OKthe pilot's inadvertent flight into adverse weather conditions resulting in a hard landing. A contributing factor was the high wind.NTSB FTW02LA049Accident · No injuriesLimited investigationFinal reportBeech BE-50 · Altus, OKThe pilot's improper flare and his failure to maintain directional control. A contributing factor was the ditch.NTSB FTW00LA224Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8 · Tulsa, OKThe passenger's failure to comply with the briefing administered by the pilot. Factors were the passenger's physical impairment due to an injury sustained during the initial ground impact and the high wind condition.NTSB FTW00LA004Accident · Serious injuriesLimited investigationFinal reportLindstrand LBL-105G · Mcalester, OKThe pilot's continued flight into known adverse weather, which resulted in a hard landing. Factors were the thunderstorms, dark night light conditions, and the high winds.NTSB FTW99LA203Accident · No injuriesLimited investigationFinal reportBeech C23 · Tulsa, OKThe pilot's failure to maintain the proper descent rate, which resulted in a hard landing.NTSB FTW98LA403Accident · No injuriesLimited investigationFinal reportCessna 150M · Yukon, OKThe pilot's improper landing flare which resulted in a hard landing and her improper recovery procedures for a bounced landing.NTSB FTW98LA346Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKThe student pilot's delayed landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.NTSB FTW98LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKThe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise and subsequent collapse of the nose gear.NTSB FTW97LA164Accident · No injuriesLimited investigationFinal reportCessna 150F · Norman, OKImproper flare.NTSB FTW96LA283Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tulsa, OKThe student pilot's improper flare during the landing, which resulted in a collapsed nose gear, ground swerve, and collision with an object.NTSB FTW96LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Norman, OKthe student pilot's improper level-off during landing.NTSB FTW96LA029Accident · No injuriesLimited investigationFinal reportCessna 150L · Norman, OKThe student pilot's improper recovery from a bounced landing and the flight instructor's inadequate supervision of the flight. Factors were the gusty wind conditions and the student pilot's failure to obtain and maintain proper compensation for the wind…NTSB FTW95LA178Accident · No injuriesLimited investigationFinal reportCessna 182D · Overbrook, OKThe pilot's failure to maintain flying speed, resulting in an inadvertent stall. A factor was the crosswinds.NTSB FTW94LA193Accident · No injuriesLimited investigationFinal reportBell 47H-1 · Tulsa, OKThe pilot's failure to maintain rotor RPM, his delayed landing flare, and the improper touchdown.NTSB FTW93LA098Accident · No injuriesLimited investigationFinal reportCessna 177 · Overbrook, OKThe pilot's improper compensation for wind conditions and his failure to recover from a bounced landing. A factor was turbulenceNTSB FTW92LA171Accident · No injuriesLimited investigationFinal reportCessna R172K · Eufaula, OKThe pilot's inadequate compensation for the wind conditions. The turbulent winds near the end of the runway were a factor in the accident.NTSB FTW92GA160Accident · No injuriesFinal reportMcdonnell Douglas 369E · Yukon, OKThe dual student's failure to maintain adequate main rotor RPM and failure to level the helicopter at touchdown. Factors were the manufacturer's training pilot's inadequate supervision and the dual student performing the maneuver.NTSB FTW92LA135Accident · No injuriesLimited investigationFinal reportCessna 150M · Stilwell, OKThe pilot inadvertently pushed the nose down during the flare/landing. A factor was the pilot misjudged the flare/landing.NTSB FTW91LA148Accident · No injuriesLimited investigationFinal reportBeech B19 · Poteau, OKThe improper flare technique utilitzed by the pilot under instruction. A factor was the failure of the check pilot to intervene.NTSB FTW91LA041Accident · No injuriesLimited investigationFinal reportHughes 269C · Knowles, OKThe pilot's failure to maintain a proper descent rate during the maneuver and his delay in initiating the go-around.NTSB DEN91LA035Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe inadequate supervision of the student by the flight instructor. A factor was: the student's failure to flare the aircraft.NTSB FTW88FA060Accident · No injuriesField investigationFinal reportPiper PA-32RT-300T · Oklahoma City, OKThe airplane was equipped for IFR but not equipped to fly into icing cond. At 4000 feet MSL, the OAT was above freezing. At 3000 feet MSL the airplane was in clouds with OAT of 32 degrees f. the plt elected to attempt downwind ILS approach and landing. Plt…NTSB FTW88LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawton, OKThe student pilot stated that during flare/touchdown the aircraft bounced and came down hard on the nose gear collapsing it and damaging the prop and firewall. The majority of the student pilots flt time was obtained while in the military.NTSB FTW87LA189Accident · Minor injuriesLimited investigationFinal reportBeech V35B · El Reno, OKAcft bounced on touchdown and began porpoising down the runway. According to the plt, following the second bounce, the rt front seat passenger applied full throttle and the acft veered left into a fence. After striking the fence the nose gear collapsed when…NTSB FTW87LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Norman, OKWhile performing a touch and go landing, the aircraft landed hard causing a vibration in the engine area, and some loss of rudder control. The pilot flew by the tower and the tower indicated everything looked ok. On landing roll the nose gear failed causing…NTSB FTW86LA153Accident · No injuriesLimited investigationFinal reportCessna 206 · Ardmore, OKThe pre-solo student pilot had taken the aircraft without the owner's permission. He flew around the area for approximately 30 minutes before returning to the airport. After a hard landing, the nose wheel tire blew causing the nose wheel to collapse. The…NTSB FTW85LA334Accident · No injuriesLimited investigationFinal reportCessna 172B · Ada, OKThe student plt, who had been executing touch and go landings, stated that the acft bounced on touchdown and began porpoising. The student over-corrected and the acft subsequently impacted the runway in a nose low attitude damaging the prop, nose gear and the…NTSB FTW85LA328Accident · No injuriesLimited investigationFinal reportPiper J4A · Duncan, OKThe plt was practicing short fld landings when the accident occurred. He stated the acft ballooned and he advanced the throttle but the eng failed to respond immediately. The acft stalled at 2 ft above the ground according to the plt. Hardcontact with the…NTSB FTW85LA228Accident · No injuriesLimited investigationFinal reportCessna 182M · Chickasha, OKThe acft bounced during landing and the student plt allowed the acft to porpoise. The nose gear, engine firewall and propeller were damaged. This was the student's first solo flt. His last 2.7 hrs of dual flt instruction consisted of 18 practice touch and go…NTSB FTW85LA208Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe student plt was on a local instructional flt practicing solo landings. He stated he made a hard landing and the acft bounced with the nose gear ass'y separating allowing the acft to be substantially damaged. The left wing ass'y received substantial damage.NTSB FTW84LA386Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Altus, OKAccording to the plt, with full flaps extended the acft encountered a windshear during the flare causing an excessive rate of descent on touchdown. Rwy contact collapsed the left main landing gear allowing the left wing to scrape on the rwy. Shortly before…NTSB FTW84LA371Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKPlt lost control after a hard, right-wind-down landing. Acft porpoised, collapsing the nose gear and came to rest nose down.NTSB FTW84LA284Accident · No injuriesLimited investigationFinal reportGriffin Trane Starduster TOO · Oklahoma City, OKAcft touched down hard after 4 unsuccessful landing attempts at stroud, OK. Plt added full pwr and returned to Oklahoma City suspecting gear damage. Visual check by another acft revealed no apparent gear damage. Upon touchdown at expressway airpark, the main…NTSB FTW84LA283Accident · No injuriesLimited investigationFinal reportHughes 369HS · Oklahoma City, OKWhile performing a practice autorotation plt failed to bring in power in time to arrest the high rate of descent. The helicopter touched down hard and the main rotor blades flexed downward striking the tail boom and severing it. The plt stated his failure to…