NTSB investigations, OH
40 cases where the sequence of events included Abnormal runway contact.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 3 |
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 5 |
| 2017 | 5 |
| 2018 | 5 |
| 2019 | 3 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 1 |
| 2024 | 1 |
| 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\" = 'OH' 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\" = '090' 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" = 'OH' 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" = '090' 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 ERA25LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna P210 · Akron, OHThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the fight instructor’s inadequate supervision of the pilot.NTSB ERA24LA288Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Medina, OHThe pilot’s failure to extend the landing gear and the flight instructor’s lack of remedial action, which resulted in a landing with the landing gear not correctly configured.NTSB ERA22LA428Accident · No injuriesClass 3 · LimitedFinal reportZenith CH 750 · Cincinnati, OHThe airplane builder’s installation of incorrect hardware in the control yoke assembly, which resulted in a loss of control during takeoff.NTSB CEN22LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Wadsworth, OHThe student pilot’s failure to maintain aircraft control during the final approach resulting in a bounced landing.NTSB CEN21LA205Accident · No injuriesClass 4 · LimitedFinal reportCessna 310N · Carrollton, OHThe pilot’s failure to confirm the landing gear was down before landing due to distraction during the Before Landing checks, which resulted in a gear-up landing.NTSB CEN20CA280Accident · No injuriesClass 4 · Data collectionFinal reportWaco YKC · New Carlisle, OHThe pilot's failure to maintain proper approach speed and descent path to the runway, which resulted in excessive speed at touchdown and insufficient runway remaining to safely bring the airplane to a stop before the end of the runway. Contributing to the…NTSB CEN20CA059Accident · No injuriesData collectionFinal reportZenith CH 750 · Xenia, OHThe pilot’s failure to maintain airplane control during landing, which resulted in the right tire contacting the runway first followed by the left wing.NTSB CEN20CA039Accident · Minor injuriesData collectionFinal reportFlight Design Ctsw · Delaware, OHThe student pilot’s failure to maintain yaw control during takeoff, which resulted in an aborted takeoff and subsequent landing on grassy terrain, during which the airplane bounced and then nosed over.NTSB GAA19CA104Accident · No injuriesData collectionFinal reportPiper PA28 · Bowling Green, OHThe student pilot's failure to maintain directional control upon touchdown, which resulted in a runway excursion and impact with a ditch.NTSB GAA19CA069Accident · No injuriesData collectionFinal reportPiper PA32R · Versailles, OHThe pilot's improper landing flare, which resulted in landing on the landing gear first and a subsequent loss of directional control, a runway excursion, and impact with a tree and a fence during an attempted go-around.NTSB GAA18CA539Accident · No injuriesData collectionFinal reportSchweizer 269C · Delaware, OHThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA470Accident · Minor injuriesData collectionFinal reportWalter C Smythe Tango XR · Mansfield, OHThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall.NTSB GAA18CA425Accident · No injuriesData collectionFinal reportCessna 172 · Batavia, OHThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA144Accident · No injuriesData collectionFinal reportPiper PA 22 · Ashland, OHThe pilot’s failure to maintain directional control during the landing roll resulting in a ground loop.NTSB GAA18CA046Accident · No injuriesData collectionFinal reportTextron 172 · Columbus, OHThe student pilot’s improper landing flare, which resulted in a porpoise.NTSB GAA18CA008Accident · No injuriesData collectionFinal reportCessna 150 · Medina, OHThe student pilot’s improper landing flare, which resulted in a hard landing and porpoise.NTSB CEN17LA323Accident · Serious injuriesLimited investigationFinal reportNorth American SNJ-4 · Ashland, OHThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control.NTSB GAA17CA334Accident · Minor injuriesData collectionFinal reportPiper PA28R · Geneva, OHThe pilot’s failure to maintain a proper landing flare in variable wind conditions, which resulted in the airplane landing on the left edge of the runway and impacting trees.NTSB GAA17CA133Accident · No injuriesData collectionFinal reportCessna 182 · Sebring, OHThe pilot’s failure to maintain the proper glidepath during landing, which resulted in the airplane landing short of the runway, the nose landing gear separating, and the airplane nosing over during a second landing.NTSB GAA16CA361Accident · No injuriesData collectionFinal reportCessna 172 · Lancaster, OHThe pilot's improper landing flare in gusting wind conditions, which resulted in a hard landing.NTSB GAA16CA301Accident · No injuriesData collectionFinal reportCessna 172 · Urbana, OHThe pilot's abnormal runway contact during the landing flare, which resulted in a porpoise, hard landing, and runway excursion.NTSB GAA16CA278Accident · No injuriesData collectionFinal reportPiper PA24 · Wadsworth, OHThe pilot's inadvertent power reduction during landing, which resulted in a runway undershoot, collision with the runway threshold, nose and right main landing gear collapse, and runway excursion.NTSB GAA16CA238Accident · No injuriesData collectionFinal reportWaco YKS 7 · Millersburg, OHThe pilot's loss of directional control during landing in gusting wind conditions resulting in excessive brake application, and airplane nose over.NTSB GAA16CA148Accident · No injuriesData collectionFinal reportRemos G 3/600 · Chesapeake, OHThe pilot's unstable approach, which resulted in excessive airspeed during the touchdown, subsequent bounced landing, collapsed nose landing gear, and a runway excursion.NTSB GAA15CA299Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Wellington, OHThe pilot's failure to level the wings during the landing flare, which resulted in the left wing striking the runway.NTSB CEN14CA355Accident · No injuriesData collectionFinal reportCessna 182S · Put in Bay, OHThe pilot's improper flare, which resulted in a hard landing.NTSB CEN14CA153Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Cleveland, OHThe pilot's improper flare and recovery from a bounced landing, which resulted in a loss of control and impact with terrain.NTSB CEN13LA366Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1124 · Cincinnati, OHLoss of control due to insufficient airspeed on takeoff and premature landing gear retraction, which resulted in the collapse of the left landing gear as the airplane impacted the runway.NTSB CEN13CA125Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Middle Bass Island, OHThe pilot did not attain the proper touchdown point during landing, which resulted in impact with the edge of the runway surface.NTSB CEN12LA676Accident · No injuriesLimited investigationFinal reportFlight Design Ctls · Elyria, OHThe pilot’s misjudged landing flare, which resulted in a hard landing.NTSB CEN12LA337Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Put-in-Bay, OHThe pilot's failure to attain a proper touchdown point at the proper speed, his failure to initiate a go-around, and the airplane’s inadequate climb gradient after the aborted landing, which resulted in impact with the trees.NTSB CEN11LA591Accident · Minor injuriesLimited investigationFinal reportAmerican Autogyro Sparrowhawk · Delaware, OHThe noncertificated pilot did not maintain adequate airspeed and aircraft control during initial climb.NTSB CEN11LA464Accident · Serious injuriesLimited investigationFinal reportBurtner Charles W Derjager D IX · East Liverpool, OHThe pilot's improper landing flare, which resulted in a porpoised landing and propeller contact with the runway, which caused an in-flight disintegration of the propeller during the go-around, and subsequent collision with trees.NTSB CEN11CA278Accident · No injuriesData collectionFinal reportCessna 152 · Stow, OHThe student pilot's improper recovery from a bounced landing.NTSB CEN11CA052Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Stockport, OHThe pilot's inadvertent movement of the throttle control during landing, which resulted in an increase in power and excursion from the runway.NTSB CEN10CA238Accident · No injuriesData collectionFinal reportAnkerstar Bradley D RAND-ROBINSON KR2 · Hamilton, OHThe pilot's improper flare resulting in a hard landing and collapsed landing gear.NTSB CEN09CA556Accident · No injuriesData collectionFinal reportAlon A2 · Richmond Hts., OHThe pilot's failure to maintain control of the airplane during the landing flare.NTSB CEN09CA381Accident · Minor injuriesData collectionFinal reportCessna 177B · Elyria, OHThe student pilot's failure to maintain aircraft control and adequate airspeed during the aborted landing, which resulted in an aerodynamic stall at a low altitude.NTSB CEN09LA183Accident · No injuriesLimited investigationFinal reportCessna 182 · Kelleys Island, OHThe pilot's failure to maintain aircraft control while landing in gusty winds due to inadequate aileron cable tension.NTSB CHI08CA091Accident · No injuriesData collectionFinal reportCessna 172R · Batavia, OHThe pilot's misjudgment of the landing flare and her inadequate recovery from the bounced landing.