Final NTSB investigations, OH
219 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 21 |
|---|---|
| 2009 | 19 |
| 2010 | 15 |
| 2011 | 28 |
| 2012 | 8 |
| 2013 | 6 |
| 2014 | 12 |
| 2015 | 9 |
| 2016 | 15 |
| 2017 | 19 |
| 2018 | 18 |
| 2019 | 17 |
| 2020 | 5 |
| 2021 | 6 |
| 2022 | 6 |
| 2023 | 4 |
| 2024 | 3 |
| 2025 | 5 |
| 2026 | 3 |
Where
Latest 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' 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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' 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 ERA26LA311Accident · No injuriesClass 4 · LimitedFinal reportHPH Glasflugel 304CZ · Xenia, OHThe glider’s encounter with atmospheric conditions where lift was not sufficient to maintain flight.NTSB ERA26LA237Accident · No injuriesClass 4 · LimitedFinal reportSinclair Pete Lancair ES · Youngstown, OHThe pilot’s failure to maintain directional control during takeoff roll, which resulted in a runway excursion and collision with an approach lighting system.NTSB ERA26LA105Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C · Brimfield, OHThe pilot’s failure to use carburetor heat during descent in cold temperatures, which resulted in a total loss of engine power at an altitude too low for recovery.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 ERA25LA245Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177 · Kelleys Island, OHThe pilot’s failure to maintain control of the airplane while taking off in gusting crosswind conditions.NTSB ERA25LA243Accident · No injuriesClass 4 · LimitedFinal reportCessna T188C · Mount Gilead, OHThe pilot’s failure to maintain adequate airspeed while in a turn during initial climb and the exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at a low altitude.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 ERA25LA176Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Kingston, OHThe pilot’s exceedance of the airplanes’ critical angle of attack resulting in a stall at an altitude too low to recover.NTSB ERA24FA362Accident · 1 fatalClass 3 · FieldFinal reportSchleicher Alexander ASH 26 E · Waynesville, OHA loss of control on takeoff for undetermined reasons.NTSB ERA24FA308Accident · 3 fatalClass 3 · FieldFinal reportBeech B-60 · Vienna Center, OHThe pilot’s loss of airplane control during a single-engine go-around. Also contributing to the accident was fuel system contamination, which resulted in detonation and a total loss of left engine power.NTSB ERA24LA285Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210L · Albany, OHThe pilot's loss failure to maintain directional control of the airplane during a crosswind landing. Contributing was an unanticipated wind gust.NTSB ERA24FA026Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Marion, OHA descent and impact with terrain for undetermined reasons.NTSB ERA23LA385Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T206 · Port Clinton, OHThe pilot’s failure to detect and avoid unmarked powerline(s) while attempting to take off from a river.NTSB ERA23LA208Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV6 · Eaton, OHThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA23FA200Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · London, OHThe flight instructor’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB ERA23FA024Accident · 2 fatalClass 3 · FieldFinal reportBeech E-90 · Marietta, OHStructural icing on the tailplane that resulted in a tailplane stall and subsequent loss of control.NTSB ERA23LA026Accident · Serious injuriesClass 4 · LimitedFinal reportKolb Firestar II · West Alexandria, OHThe pilot’s failure to maintain airplane control after takeoff, resulting in an aerodynamic stall and collision with terrain.NTSB ERA22LA412Accident · No injuriesClass 3 · LimitedFinal reportEngineering & Research 415-C · Galion, OHA partial loss of engine power due to an exhaust valve that was stuck in the open position.NTSB ERA22LA401Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Wadsworth, OHA total loss of engine power for reasons that could not be determined.NTSB ERA22LA330Accident · No injuriesClass 3 · LimitedFinal reportBell 206B · Kenton, OHThe pilot’s inadequate fuel management, which resulted in fuel exhaustion and a loss of engine power.NTSB ERA22FA262Accident · 2 fatalClass 3 · FieldFinal reportEnstrom F28 · Greenville, OHAn impact with terrain for undetermined reasons.NTSB CEN21FA376Accident · 1 fatalClass 3 · FieldFinal reportSocata TBM 700 · Urbana, OHThe pilot’s failure to arrest the airplane’s left roll and rapid descent for reasons that could not be determined based on the available evidence.NTSB CEN21LA379Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Industries DA-42 · Bellefontaine, OHThe improper position of the right engine’s fuel feed pump bolt, which led to a total loss of power on the right engine, and the left engine's partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN21LA381Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Wadsworth, OHA partial loss of engine power due to carburetor icing and the pilot’s failure to apply carburetor heat when the power loss occurred.NTSB CEN21LA301Accident · No injuriesClass 4 · LimitedFinal reportChristen Industries A-1 · Wilmington, OHThe pilot’s failure to maintain directional control during takeoff with gusting winds, which resulted in an inflight collision with a fence.NTSB CEN21LA265Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 180K · Columbus, OHThe loss of engine power due to fuel starvation resulting from sealant contamination in the wing.NTSB CEN21LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Urbana, OHThe student pilot’s loss of directional control during landing which resulted in an impact with a snowbank. The slippery runway condition contributed to the accident.NTSB CEN20CA312Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT 602 · Tiro, OHThe pilot's failure to maintain clearance while attempting to fly under power lines during an aerial application pass.NTSB CEN20LA239Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150 · Millersport, OHThe loss of engine power for reasons that could not be determined based on the available information.NTSB CEN20CA231Accident · Serious injuriesClass 4 · Data collectionFinal reportDestiny XLT · Frankfort, OHThe pilot's inadequate preflight inspection of the powered parachute, which resulted in his takeoff with twisted riser lines and impaired aircraft control.NTSB CEN20LA197Accident · 1 fatalClass 3 · LimitedFinal reportBeech 35-A33 · Cambridge, OHA fuel injection system leak at or near the No. 3 cylinder that resulted in a partial loss of engine power during cruise flight.NTSB CEN20CA114Accident · No injuriesData collectionFinal reportVans RV8 · Harrison, OHThe malfunction of the steerable tailwheel, which resulted in a loss of directional control during the landing roll and subsequent impact with the precision approach path indicator lights system.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 CEN20LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Harrison, OHA total loss of engine power during approach to land due to carburetor icing during a simulated engine failure, which resulted in impact with trees.NTSB GAA20CA073Accident · Minor injuriesData collectionFinal reportSchleicher ASW15 · Waynesville, OHThe glider pilot's improper approach during landing, which resulted in collision with trees.NTSB GAA20CA017Accident · No injuriesData collectionFinal reportPiper PA28 · Dayton, OHThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and an off-airport landing, during which the airplane struck a vehicle.NTSB CEN19FA323Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · London, OHThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering toward the final leg of the traffic pattern and facing the rising sun, which resulted in a subsequent aerodynamic stall at too low an altitude to recover.NTSB CEN19MA312Accident · 2 fatalClass 3 · MajorFinal reportConvair 440 · Monclova, OHThe flight crew’s failure to maintain the proper airspeed on final approach, which resulted in an inadvertent aerodynamic stall and impact with trees, and terrain. Contributing to the accident was the flight crew’s fatigue due to the overnight flight schedule.NTSB CEN19LA263Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · New Carlisle, OHThe pilot’s excessive use of pitch control during rotation, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall shortly after liftoff.NTSB CEN19LA262Accident · Minor injuriesClass 3 · LimitedFinal reportPietenpol Aircamper · Newark, OHThe engine’s failure to produce full power for reasons that could not be determined.NTSB CEN19LA181Accident · Serious injuriesClass 3 · LimitedFinal reportQuicksilver Sport · Barnesville, OHThe pilot's loss of control for undetermined reasons.NTSB CEN19FA177Accident · 2 fatalField investigationFinal reportBeech A36 · Elida, OHThe noninstrument-rated pilot's decision to continue visual flight rules flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing was the pilot not obtaining a weather…NTSB GAA19CA340Accident · Minor injuriesData collectionFinal reportPiper PA24 · Cambridge, OHThe pilot's improper landing flare, which resulted in a hard landing, and his subsequent loss of directional control, which resulted in impact with a creek.NTSB GAA19CA303Accident · Minor injuriesData collectionFinal reportAir Tractor AT502 · Rockford, OHThe pilot's failure to maintain clearance from power lines during an agricultural application flight.NTSB ERA19FA181Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28R · Auburn Township, OHThe pilot's loss of control due to spatial disorientation in dark night conditions. Contributing to the accident was his inadequate weather planning, lack of experience flying at night and the deteriorating weather conditions.NTSB CEN19FA144Accident · 1 fatalClass 2 · FieldFinal reportVans RV6 · Chillicothe, OHThe pilot's failure to maintain control of the airplane following an intermittent loss of engine power during cruise flight that resulted in him impacting trees. The reason for the loss of engine power could not be determined based on the available…NTSB ERA19FA124Accident · 1 fatalField investigationFinal reportPiper PA31 · Madeira, OHFuel starvation to the left engine and the resulting loss of engine power to that engine, and a loss of airplane control due to the pilot's failure to maintain the minimum controllable airspeed.NTSB CEN19LA056Accident · 2 fatalLimited investigationFinal reportDouglas DC3C · Kidron, OHThe loss of airplane control after an engine flameout and auto-feather system interruption during the takeoff climb, which resulted in an impact with terrain.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 CEN19LA047Accident · No injuriesLimited investigationFinal reportRans S12 · McClure, OHThe cold seizure of the cylinder/piston due to the pilot’s failure to adequately warm the engine before takeoff, which resulted in a loss of engine power during a departure climb.