NTSB investigations, OH
51 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 1 |
| 1994 | 5 |
| 1995 | 5 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 3 |
| 2002 | 1 |
| 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\" = 'OH' 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\" = 230)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230) 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 CHI08FA045Accident · 2 fatalField investigationFinal reportCessna 208B · Columbus, OHThe pilot's failure to maintain aircraft control and collision avoidance with terrain due to spatial disorientation. Contributing to the accident were the low cloud ceiling and night conditions.NTSB CHI08CA001Accident · No injuriesData collectionFinal reportDusenberry 1905 Wright Flyer · Dayton, OHThe altitude not maintained by the pilot for a turning maneuver.NTSB CHI08CA013Accident · No injuriesData collectionFinal reportCessna 182 · Middlefield, OHThe proper touchdown point not obtained by the pilot and the inadequate supervision by the certified flight instructor during landing. A contributing factor was the rough terrain encountered during landing.NTSB CHI07LA237Accident · 1 fatalLimited investigationFinal reportOpus Motorsports BD02 · Dayton, OHThe pilot not maintaining clearance from terrain during the aerobatic maneuver. Factors contributing to the accident were the pilot's restricted ability to see the terrain and the oil smoke present in the air show performer's box.NTSB CHI07LA086Accident · 1 fatalLimited investigationFinal reportCamair 480 · East Liberty, OHThe uncontrolled descent for undetermined reasons.NTSB CHI06CA266Accident · No injuriesData collectionFinal reportMD Helicopters 369FF · Port Clinton, OHThe pilot not maintaining clearance from the water during the survey flight. A factor was the low altitude the survey flight was flown at.NTSB NYC02LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Kelleys Island, OHThe pilot-in-command's failure to obtain a proper touchdown point. A factor was the downdraft.NTSB IAD00FA082Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Carrollton, OHPilot's improper decision to delay the aborted landing, which resulted in an insufficient airspeed during climb and subsequent collision with terrain. A factor was the wet runway and tailwind.NTSB NYC00LA232Accident · Serious injuriesLimited investigationFinal reportTriple S Aero Lancair IVP · Moraine, OHThe pilot's failure to maintain a proper glide path to the runway which resulted in the airplane contacting a 15-foot levee just short of the runway.NTSB IAD00LA050Accident · Serious injuriesLimited investigationFinal reportBakeng Double Deuce · West Alexandria, OHthe pilot's failure to maintain control of the airplane. A factor in the accident was the pilot's failure to properly brief/communicate transfer of the flight controls to the pilot-rated passenger.NTSB NYC99LA242Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Brookfield, OHThe pilot's failure to maintain aircraft control, resulting in an inadvertent stall.NTSB NYC99LA124Accident · 2 fatalLimited investigationFinal reportToman Great Lakes 2T-1AJ · Painesville, OHThe pilot's improper decision to conduct low-level aerobatic flight, and his lack of adequate altitude for the maneuver attempted.NTSB NYC98FA166Accident · 2 fatalField investigationFinal reportChampion 7FC · Alliance, OHThe pilot's failure to maintain altitude/clearance during the approach which resulted in an in-flight collision with trees. A factor in the accident was the pilot's lack of recent experience and lack of experience in the make and model of the accident…NTSB NYC98FA017Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA-200 · Radnor, OHThe failure of the pilot to obtain the proper altitude/clearance above the terrain, to perform an aerobatic maneuver. A factor was the pilot's lack of total experience in make and model.NTSB NYC96FA178Accident · 1 fatalField investigationFinal reportCessna 177 · Youngstown, OHthe pilot's delay in aborting the landing, and his failure to attain adequate airspeed to fly out of ground effect, which resulted in a stall/mush and collision with the ground. Factors relating to the accident were: the pilot's improper recovery from a…NTSB IAD96LA113Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75N1 · Goshen, OHthe pilot's failure to maintain adequate clearance from terrain during short final approach/landing flare. The hot temperature was a related factor.NTSB BFO96LA029Accident · 1 fatalLimited investigationFinal reportCessna 150K · Seville, OHpilot suicide (intentional in-flight collision with terrain).NTSB BFO96FA027Accident · 2 fatalField investigationFinal reportGraichen Christen Eagle II · Malinta, OHfailure of the pilot to maintain proper altitude, while performing aerobatic maneuvers.NTSB BFO96FA022Accident · 3 fatalField investigationFinal reportBeech 58 · Cleveland, OHthe pilot's improper IFR procedure, by failing to maintain a positive rate of climb (and terrain clearance) after takeoff. Factors relating to the accident were: darkness, and the lack of visual references over water and under overcast cloud conditions.NTSB BFO96LA018Accident · No injuriesLimited investigationFinal reportBeech 35 · Phillipsburg, OHThe flight instructor's (CFI's) inadequate supervision of the flying pilot, and the flying pilot's abrupt handling of the airplane during an attempted go-around. Factors relating to the accident were: the flying pilot's lack of familiarity with light piston…NTSB NYC95LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Wilmington, OHThe pilot's failure to maintain adequate terrain clearance during a go around, which resulted in an inflight collision with a snowbank. A factor is the pilot's delay in initiating a go around.NTSB BFO95LA008Accident · Serious injuriesLimited investigationFinal reportAmerican General AA1 · Beach City, OHthe pilot-in-command's failure to maintain adequate control of the aircraft during the takeoff. The pilot's inadequate compensation for unfavorable wind conditions is a related factor in this accident.NTSB BFO94LA161Accident · 2 fatalLimited investigationFinal reportHenderson Christen Eagle II · Painesville, OHThe pilot's failure to maintain aircraft control while conducting aerobatic maneuvers. The pilot's overconfidence in his ability was a factor.NTSB NYC94FA134Accident · 5 fatalField investigationFinal reportPiper PA-32-260 · Minford, OHThe pilot's failure to follow the published instrument departure procedure. A factor in the accident were the weather conditions.NTSB BFO94LA097Accident · 1 fatalLimited investigationFinal reportFalen Commander 503 · Georgetown, OHThe gyroplane's uncontrolled descent into terrain due to undetermined reasons.NTSB BFO94LA050Accident · No injuriesLimited investigationFinal reportBeech 400 · Cleveland, OHThe pilots failure to use the proper radio frequency to activate the airport runway lights, and the pilot's improper decision to continue his approach and land without the runway lights being on.NTSB NYC92LA165Accident · No injuriesLimited investigationFinal reportSchweizer 269C · London, OHThe failure of the pilot to properly judge his altitude during a practice autorotation, which resulted in a tail rotor ground strike and roll over upon touchdown.NTSB NYC92LA040Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Piqua, OHThe pilot allowed the airplane to get too low on short final and struck the terrain short of the runway. Factors in the accident were the proper glide path was not maintained, resulting in the intended touchdown point not being attained.NTSB NYC92LA031Accident · 2 fatalLimited investigationFinal reportMooney M20C · Painesville, OHThe pilot's failure to see and avoid the powerline tower structure while executing a visual approach to the airport. Factors related to the accident were the lack of proper radio equipment necessary to execute the instrument approach, restricted visibility…NTSB NYC91LA227Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Galloway, OHImproper supervision by the flight instructor which resulted in an inadvertent ground contact and a dynamic rollover. A factor related to the accident was improper use of the flight controls by the non-rated student pilot.NTSB CHI90LA158Accident · No injuriesLimited investigationFinal reportCessna 310 · Moraine, OHThe pilot-in-command's failure to maintain adequate ground clearance during his approach to landing. Contributing factors were reduced visibility in fog and rain.NTSB CHI90LA153Accident · No injuriesLimited investigationFinal reportCessna 172 · Millersburg, OHFailure of the pilot to maintain directional control during a go-around attempt. The pilots lack of total aviation experience and his motion sickness are factors associated with the accident.NTSB ATL89FAMS3Accident · 1 fatalMissing aircraftFinal reportCessna 310Q · Cleveland, OHAn uncontrolled descent into the water for undetermined reasons.NTSB ATL89MA072Accident · 2 fatalMajor investigationFinal reportHawker Siddeley HS.748 Series 2A · Tipp City, OHImproper IFR procedure by the first officer (copilot) during takeoff, his lack of instrument scan (improper use of flight/navigation instruments), his failure to maintain a positive rate of climb or to identify the resultant descent, and the captain's…NTSB CHI88DEI01Accident · No injuriesFinal reportVan Wormer Emeraude SSE-328R · Elyria, OHAccording to the plt, the eng seemed to lose power as the acft was climbing thru about 50 ft AGL after takeoff. Subsequently, the acft settled to the ground, crossed a road & collided with a chain link fence. It came to rest about 150 ft from where it 1st…NTSB ATL88LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · Center Village, OHThe CFI attempted to demonstrate a short-field takeoff to his student, with a tailwind. He reported believing at the time that a light cross-wind/quartering tailwind was blowing. He elected to depart from rwy 27, because rwy 09 had utility wires at the…NTSB ATL88IA096Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Elyria, OHNTSB ATL87FA248Accident · 1 fatalField investigationFinal reportCessna 182 · Lima, OHDuring a night flt from toledo to cincinnati, OH, the acft crashed along the route at Lima, OH, after svrl local residents heard an acft circling. Initial impact was with the top of a dike after the acft crossed over a reservoir. Wreckage was scattered over a…NTSB ATL86LA200Accident · Serious injuriesLimited investigationFinal reportBalloon Works FF-7 · Pandora, OHFollowing a early morning Balloon flight, the pilot attempted a landing in a cleared area with winds at about 14 knots. The pilot realized that the first attempt he would encounter powerlines and trees. The pilot climbed out and attempted another approach to…NTSB ATL86LA110Accident · Serious injuriesLimited investigationFinal reportAeronca L-3B · Harrison, OHDuring a demonstration flight to a resident who lived near the airport, the acft crashed in a plowed field in a departure stall. The flight was intended to demonstrate the safe maneuverability of the acft and deception of altitude clearances from the…NTSB ATL86FA077Accident · 1 fatalField investigationFinal reportCessna 182P · Elyria, OHThe plt was cleared for and executed a rwy 17 ILS apch at night. Prior to beginning the apch he was informed that vis was 1/8 mile. Minimum for the apch was 1/2 mile. At the middle marker the plt rated pax in the right seat told the PIC that the rwy was not…NTSB CHI85LA244Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Mcconnelsville, OHThe student plt had taken the acft without authority of the owner & reportedly was using it to elude police. While flying at low alt, he attempted to pass under wires along a state hiway. However, the acft impacted an embankment in a nose low, wings level…NTSB CHI85LA134Accident · No injuriesLimited investigationFinal reportHughes 269C · Center Village, OHWhile the student plt practiced hovering 8 to 12 inches AGL the heel of the right skid contacted the ground. The CFI stated he did not notice the helicopter drifting or descending but when the ground contact was felt he took over the controls. Up collective…NTSB CHI85LA119Accident · No injuriesLimited investigationFinal reportBeech N35 · Athens, OHFollowing one hour of airwork the instructor and student returned to the airport for a short field landing. The instructor stated that the student lowered the gear on downwind. He stated further that they both checked the gear position indicator on base leg…NTSB CHI84FEI01Accident · 1 fatalFinal reportBell-Olympic Helicopters 47G2 · Toledo, OHThe helicopter was being used to photograph an office building. The photographer stated that after each flt of about 10 min, the plt flew the helicopter to the left & center of the landing pad, a few feet above the ground, then moved the acft sideways to the…NTSB CHI84FA239Accident · 2 fatalField investigationFinal reportMooney M20C · Middlefield, OHThe acft props touched the rwy during a wheels-up approach and the plt initiated a go-around with bent props. The acft climbed to about 100 ft AGL with less than full power. The wings began to rock,the left wing dropped and the acft fell straight down to the…NTSB CHI83LA274Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wadsworth, OHThe CFI said the student pilot tried to correct for a gust of wind. After the acft turned 30 0R 40 degrees the CFI took control. During the go-around the right wing contacted the ground and the acft cartwheeled.NTSB CHI83LA260Accident · No injuriesLimited investigationFinal reportCessna 210 · Bryan, OHThe acft main landing gear collapsed during landing. The nose gear never came down. The pilot stated the approach was long and flat. The 'stall warning beeped a couple times. On flare horn came on.' The landing gear was tested for extension/retraction with no…NTSB CHI83LA211Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · East Liverpool, OHDuring the approach, the plt neglected to extend the gear, aand subsequently, made a wheels up landing.NTSB CHI83FA059Accident · 2 fatalField investigationFinal reportCessna T210 · Defiance, OHAircraft crashed during non-precision approach in weather that was below minimums for that type of approach.