Skip to content

NTSB investigations, OH

22 cases where the first occurrence was “Miscellaneous/other”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19842026

Where

Latest cases

Query with SQL

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" = 430) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 430)
  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" = 430)
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 CHI07CA313Accident · No injuriesData collectionFinal reportHasch Vans RV6 · Salem, OHThe loss of engine power due to the blocked cooling and induction systems because of the pilot in command's failure to remove the cowling covers before the flight. Factors were the pilot's misjudged landing glidepath, the pilot rated passenger's inability to…Sep 13, 2007 · N423SH · Substantial damage NTSB NYC05CA035Accident · Minor injuriesData collectionFinal reportRaytheon Corporate Jets 400A · Cleveland, OHThe loss of directional control by the operator of a ground service vehicle.Dec 18, 2004 · N417CW · Substantial damage NTSB NYC04CA177Accident · Serious injuriesData collectionFinal reportAvian Falcon II · Middletown, OHThe passenger's inadvertent fall from the basket, during landing. A factor in this accident was the windy conditions.Jul 24, 2004 · N15053 · Minor damage NTSB NYC03LA143Accident · Serious injuriesLimited investigationFinal reportAerostar International RX 8 · Grove City, OHThe passengers failure to maintain her balance inside the balloon basket.Jun 21, 2003 · N71696 · No damage NTSB NYC03LA046Accident · 1 fatalLimited investigationFinal reportMitsubishi MU-2B-60 · Cleveland, OHthe bank couriers inadequate visual lookout, as he approached an airplane with operating engines. A factor was the lack of guidance and training from the bank, for working around airplanes with operating engines.Jan 28, 2003 · N941MA · Minor damage NTSB NYC01LA125Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135LR · Cleveland, OHAn overload force being exerted on the nosewheel gear assembly for undetermined reason.Apr 13, 2001 · N735TS · Substantial damage NTSB NYC01FA007Accident · 1 fatalField investigationFinal reportBeech E18S · Wash. Ct. House, OHAn undetermined event, which resulted in an off airport landing. A factor in this accident was the night light condition.Oct 10, 2000 · N2067C · Destroyed NTSB NYC00LA135Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Wellington, OHThe pilot's failure to maintain aircraft control. A factor was the pilot's improper in-flight decision to abort the initial climb due to an open canopy.May 13, 2000 · N3872G · Substantial damage NTSB NYC00LA120Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lancaster, OHThe pilot's improper recovery from a bounced landing. A factor in the accident was the pilot's decision to operate the airplane over the maximum gross weight and his improper landing flare.Apr 23, 2000 · N66430 · Substantial damage NTSB IAD99LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · Medina, OHWas the pilot's failure to remove snow from the horizontal stabilator prior to take-off and his improper decision to depart downwind. Factors in the accident were the heavy snow squall and tailwind.Feb 7, 1999 · N31975 · Destroyed NTSB IAD97LA104Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Mt. Vernon, OHThe pilot's failure to maintain rotor RPM.Jul 26, 1997 · N35134 · Substantial damage NTSB NYC97LA084Accident · No injuriesLimited investigationFinal reportSchempp-Hirth CIRRUS-S · Wadsworth, OHThe pilot's inadvertent activation of the speed brakes while being towed for takeoff. Subsequently, the glider pilot lost sight of the tow airplane due to excessive altitude, released the tow rope, and performed an off airport landing during which the glider…Sep 25, 1996 · N9775 · Substantial damage NTSB BFO96LA031Accident · Minor injuriesLimited investigationFinal reportBellanca BL14-19-3 · Toledo, OHan improper splice of the magneto 'P' lead wires, and the pilot's improper positioning of the throttle and mixture controls while he rotated the propeller by hand.Dec 20, 1995 · N7624E · Destroyed NTSB BFO96LA024Accident · No injuriesLimited investigationFinal reportCessna 210J · Bellefontaine, OHThe pilot unknownly left the ignition switch in right magneto-only position, while moving the propeller by hand, which allowed an inadvertent start of the engine. The weak battery was a related factor.Nov 19, 1995 · N3328S · Substantial damage NTSB NYC91LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Celina, OHThe pilot-in-command's improper use of the powerplant controls, magnetos and brakes.Jan 24, 1991 · N8385S · Substantial damage NTSB CHI90LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Millbury, OHFailure of the pilot to properly secure the aircraft and/or adequately brief the passenger (student pilot), and inadvertent bumping of the throttle by the passenger.Dec 1, 1989 · N43416 · Substantial damage NTSB CHI88FA249Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Columbus, OHAerodynamically stalled lifting surface causing an uncommanded pitch over at an altitude too low to affect a recovery.Oct 1, 1988 · N14HR · Destroyed NTSB ATL86LA236Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Coshocton, OHThe plt initiated a maximum power takeoff from a confined parking lot with 2 passengers on board. The area was boardered by obstructions & people. The plt rprtd that during lift-off, she increased power to 2900 RPM, lifted off to a 4' hover with 33' of…Sep 1, 1986 · N549H · Substantial damage NTSB CHI85LA350Accident · No injuriesLimited investigationFinal reportCessna C-172P · Zanesville, OHPlt aborted takeoff from taxiway when he realized that he as not on rwy. Plt stated he was confused by taxiway marking & he believes taxiway arrows are misleading.Aug 16, 1985 · N5279K · Substantial damage NTSB CHI85LA231Accident · Serious injuriesLimited investigationFinal reportJenkins HP-18 · Wellington, OHFollowing an aprx one-half hour flt, witnesses stated that the glider did not appear to flare for landing, but instead, impacted the ground without arresting the rate of descent. The plt eported he had very poor ventilation in the cockpit and feels that he…Jun 8, 1985 · N8036X · Substantial damage NTSB DCA84IA001Incident · No injuriesIncident investigationFinal reportBoeing VC-137B-BN · Akron, OHA Boeing VC-137B-BN, USAF #58-6971, operating as air force 2 (AF-2), departed cleveland, OH, at about 1745 EDT on an IFR clearance. After departing cleveland, AF-2 was assigned an alt of 8000 ft MSL by cleveland departure control & was transfered to cleveland…Sep 30, 1984 · USAF · 2 aircraft · No damage NTSB CHI84LA388Accident · No injuriesLimited investigationFinal reportAvian Balloon AX8 · Canton, OHPlt and passenger (student balloon pilot) elected a precautionary landing in an open field rather than overfly densely populated area and power lines, on touchdown, wind lifted balloon slightly and caused drift. As student plt was operating envelope vent, she…Sep 29, 1984 · N7003Q · Substantial damage