NTSB investigations, OH
15 cases where the defining event was Runway excursion.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2018 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2025 | 2 |
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '300')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '300') 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 ERA25LA325Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Lebanon, OHThe pilot’s failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and collision with a sign.NTSB ERA25LA212Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Fremont, OHThe pilot’s inadequate takeoff performance planning, which resulted in a runway overrun and collision with terrain.NTSB ERA23LA112Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-31-350 · Middlefield, OHA runway overrun during a precautionary landing following a total loss of right engine power due to detonation and subsequent oil starvation. Contributing was the pilot’s failure to lower the flaps and the excessive airspeed at touchdown.NTSB DCA23LA005Incident · No injuriesClass 3 · LimitedFinal reportBombardier CL-600-2B19 · Dayton, OHThe airplane’s right turn, which developed during the landing rollout and persisted until the airplane came to rest, for reasons that could not be determined based on the available evidence. Contributing to the incident was the pilot’s reliance primarily on…NTSB GAA18CA487Accident · No injuriesData collectionFinal reportCessna U206 · Waynesville, OHThe pilot's inability to stop the airplane on the wet runway after an aborted go-around, which resulted in a runway overrun and impact with terrain.NTSB CEN18LA094Accident · No injuriesLimited investigationFinal reportRaytheon 400A · Cleveland, OHThe airplane's reduced braking performance due to an ice-covered runway, which resulted in a runway excursion. Contributing to the accident was the crew's selection of a runway with a tailwind.NTSB GAA15CA093Accident · No injuriesData collectionFinal reportRogers Homer/Rogers Sheila RV 6A · Lorain/Elyria, OHThe pilot's failure to maintain airplane attitude control during the landing flare, which resulted in an aerodynamic stall, hard landing, and runway excursion.NTSB CEN14CA260Accident · No injuriesData collectionFinal reportCessna 120 · Wadsworth, OHThe pilot's failure to maintain directional control of the airplane during landing which resulted in a runway excursion.NTSB CEN14LA006Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Xenia, OHThe nose landing gear failure as a result of a fatigue fracture of the engine mount nose gear actuator feet in an area detailed in a service bulletin. Contributing to the accident was maintenance personnel’s inadequate completion of the inspection specified…NTSB CEN13CA385Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Waynesville, OHThe pilot did not attain a proper touchdown point during the landing. Contributing to the accident was the simulated altimeter and spoiler failure and the flight instructor's lack of remedial action.NTSB CEN12LA445Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro SportCruiser · Waynesville, OHThe airplane's collision with fence posts during an aborted takeoff due to a sudden change in wind direction.NTSB CEN11CA674Accident · No injuriesData collectionFinal reportCessna 172N · Wadsworth, OHThe pilot's misjudgment of his speed and distance, which resulted in an overrun.NTSB OPS11IA271Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Dayton, OHThe pilots' lack of consideration for developing and known weather conditions en route to and at the destination airport, resulting in a runway excursion and subsequent incursion.NTSB CEN10CA144Accident · Minor injuriesData collectionFinal reportCessna 172R · Newark, OHThe pilot's failure to maintain directional control during takeoff.NTSB CHI08CA291Accident · No injuriesData collectionFinal reportCessna 172 · Wadsworth, OHThe pilot's excessive airspeed during the approach and landing and failure to perform a go-around. Contributing to the accident were the barricade and the down-sloping terrain at the end of the runway.