NTSB investigations, OH
103 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 5 |
|---|---|
| 1983 | 5 |
| 1984 | 7 |
| 1985 | 6 |
| 1986 | 7 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 7 |
| 1990 | 8 |
| 1991 | 2 |
| 1992 | 4 |
| 1993 | 2 |
| 1995 | 8 |
| 1996 | 4 |
| 1997 | 5 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 5 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 5 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 3 |
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\" = 220)
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" = 220) 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 CHI07CA291Accident · Minor injuriesData collectionFinal reportSchweizer SGS 2-33A · Alliance, OHThe pilot's inattentiveness during the aircraft preflight and his failure to maintain clearance above the trees.NTSB CHI07LA195Accident · 2 fatalLimited investigationFinal reportGrumman American AA-1C · Carrollton, OHThe pilot failed to maintain clearance from trees during cruise. Factors were the inadequate preflight planning, the thunderstorm in the area at the time of the accident, and the trees.NTSB CHI07LA150Accident · 2 fatalLimited investigationFinal reportWood Vans RV7A · Marysville, OHThe pilot's failure to maintain clearance from an object during a go-around and subsequent failure to maintain adequate airspeed. An airport sign and an inadvertent stall were factors.NTSB CHI06LA187Accident · 1 fatalLimited investigationFinal reportPiper PA-18-135 · Steubenville, OHThe pilot's failure to maintain clearance from the unmarked power line which resulted in the subsequent impact with the roadway. Factors were the unmarked power line, and the low altitude at which the flight was conducted.NTSB CHI06LA138Accident · 1 fatalLimited investigationFinal reportHughes 269A · Berlin Center, OHThe pilot flew at a low altitude and failed to maintain clearance from the wire. A factor was the wire.NTSB IAD05LA129Accident · Minor injuriesLimited investigationFinal reportDassault/Sud Falcon 20D · Lorain, OHThe ingestion of multiple birds in each engine at takeoff, which resulted in a complete loss of engine power.NTSB NYC05FA028Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Vandalia, OHThe pilot's failure to maintain adequate altitude\clearance while on approach, which resulted in an in-flight collision with trees. Factors in the accident were the fog and low ceiling conditions.NTSB NYC05LA027Accident · 2 fatalLimited investigationFinal reportClose Air Command · Wilmont, OHThe pilot's failure to maintain clearance from a wire while maneuvering to land in an open field.NTSB NYC05CA016Accident · Serious injuriesData collectionFinal reportSyreini Hipps J3 Kitten · Delaware, OHThe pilot's failure to maintain adequate altitude, which resulted in an in-flight collision with wires.NTSB IAD04FA017Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · North Lima, OHThe pilot's failure to maintain a safe altitude clearance from trees. Factors included the night lighting conditions and the pilot's diminished night vision capability.NTSB NYC04CA076Accident · No injuriesData collectionFinal reportCessna 172N · Youngstown, OHAn inadvertent collision with a deer while landing.NTSB NYC04LA008Accident · Minor injuriesLimited investigationFinal reportSibila VP 1 · Cincinnati, OHThe pilot's delayed decision to abort the takeoff, which resulted in a collision with trees.NTSB NYC03LA198Accident · Serious injuriesLimited investigationFinal reportMooney M20A · Rockford, OHThe pilot's failure to maintain the proper altitude/clearance, which resulted in an in-flight collision with a utility wire. The owner's improper decision to allow the airplane to be operated by an uncertificated pilot was also causal.NTSB NYC03LA144Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Newcomerstown, OHThe pilot's failure to obtain the proper touchdown point and delayed go-around. Factors in this accident were the up sloping runway.NTSB NYC02LA067Accident · Minor injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Grove City, OHThe pilot's inadequate compensation for wind conditions which resulted in an in-flight collision with trees. A factor related to the accident was the gusting wind conditions.NTSB IAD02FA026Accident · 2 fatalField investigationFinal reportMBB BK-117 A-3 · Cleveland, OHpilot's failure to maintain directional control of the helicopter while hovering, which resulted in its collision with a building. Factors were the confined area, tail wind, and wind gusts.NTSB NYC01FA215Accident · 1 fatalField investigationFinal reportBeech BE-200 · Piqua, OHThe pilot's improper decision to attempt a visual landing under instrument meteorological conditions and his failure to maintain adequate altitude/clearance, which resulted in an in-flight collision with trees. A factor in this accident was the ground fog.NTSB NYC00FA247Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Apple Creek, OHThe pilot's premature liftoff and failure to attain a proper climb rate. Factors related to the accident were the over-gross weight conditions, and the low cloud ceilings.NTSB IAD00LA073Accident · Serious injuriesLimited investigationFinal reportAviat A-1 · Kidron, OHthe pilot's failure to maintain a proper glide path and proper visual lookout that resulted in collision with wires.NTSB IAD00LA065Accident · Serious injuriesLimited investigationFinal reportRotorway Exec 90 · Circleville, OHPilot's improper decision to depart a confined area with two people onboard, which resulted in a loss of rotor RPM and collision with a utility pole and wires.NTSB NYC00LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Miamisburg, OHThe CFI's delayed remedial action.NTSB NYC00FA127Accident · Serious injuriesField investigationFinal reportEurocopter BK-117-A4 · Cincinnati, OHthe pilot's misjudgment of his closure rate, while turning to land on the rooftop helipad, which resulted in a collision with the building. Factors in the accident were the tailwind and the stuck windsock.NTSB NYC00FA020Accident · 2 fatalField investigationFinal reportCessna 210L · Medina, OHThe pilot's failure to maintain proper altitude during the final approach segment of the visual approach. A factor was the diminishing light conditions of a deepening dusk.NTSB NYC99LA171Accident · 1 fatalLimited investigationFinal reportGuy Pitts S-1S · Norwalk, OHThe pilot's improper decision to conduct a low level aerobatic maneuver, and his subsequent loss of awareness regarding the location of trees at that level.NTSB NYC99LA138Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28 · Cincinnati, OHThe pilot's inadequate evaluation of the weather conditions at the time of departure, which resulted in a downwind takeoff. A factor in the accident was the change in wind direction.NTSB IAD98LA087Accident · No injuriesLimited investigationFinal reportCessna 172N · Lebanon, OHThe pilot's delay in aborting the landing, which resulted in inadequate obstacle (car) clearance during initial takeoff climb. A contributing factor is the pilot's decision to perform a tailwind landing.NTSB NYC98LA104Accident · 2 fatalLimited investigationFinal reportHispano Aviacion HA200B Saeta · Xenia, OHThe pilot's failure to maintain altitude clearance with trees after an improper decision to perform low level aerobatics.NTSB NYC98LA051Accident · Minor injuriesLimited investigationFinal reportPiper J-3C-65 · Albany, OHthe pilot's improper in-flight planning/decision and failure to turn off the carburetor heat during the go-around. Related factors were: the pilot's lack of experience in make and model, and the proximity of trees.NTSB IAD98FA018Accident · 3 fatalField investigationFinal reportBeech A 36 · Findlay, OHThe pilot-in-command's failure to obtain/maintain clearance with objects during the initial climb. Contributing factors were trees, fog, and the flying pilot's failure to maintain runway heading during the initial climb.NTSB IAD98LA017Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Steubenville, OHCollision with deer on runway during initial takeoff and climb.NTSB IAD97LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Zanesville, OHThe pilot's failure to perform the published short/soft field takeoff procedures.NTSB IAD97LA046Accident · No injuriesLimited investigationFinal reportCessna 172P · Chesapeake, OHthe pilot's failure to maintain proper altitude during the approach at night. Related factors were: darkness, and the pilot's lack of night flying experience.NTSB IAD97LA040Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Colombia Staton, OHinadequate supervision by the flight instructor (CFI), and his failure to ensure that sufficient altitude and/or clearance was maintain from obstructions (trees) during the approach. Darkness was a related factor.NTSB IAD97FA025Accident · 1 fatalField investigationFinal reportAero Commander 681 · Mansfield, OHthe pilot's early descent below the minimum descent altitude (MDA), while preparing to land from an instrument approach, and his failure to maintain adequate altitude and clearance from obstruction(s).NTSB IAD97LA006Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Springfield, OHfailure of the pilot to maintain obstacle clearance, while maneuvering at low altitudes. A related factor was the quartering tail wind.NTSB BFO96FA039Accident · 2 fatalField investigationFinal reportCessna R172K · Highland Hills, OHthe pilot's continued VFR flight into instrument meteorological conditions at a low altitude with known obstacles in the area.NTSB BFO96LA003Accident · No injuriesLimited investigationFinal reportEnstrom F28-280C · Blue Ash, OHthe commercial pilot's failure to maintain clearance from obstacles during hover-taxi operations. Related factors the tailwind, the nearby obstacle, and the misjudged maneuver to avoid obstacles.NTSB BFO95LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Put-In-Bay, OHThe pilot's delay in aborting the landing after selecting the wrong runway. Factors relating to the accident were: garbled radio transmissions on the UNICOM frequency, and the resultant tailwind for landing.NTSB BFO95LA085Accident · Serious injuriesLimited investigationFinal reportBirdman Enterprises Chinook 2S · Hammondsville, OHthe pilot's failure to maintain adequate altitude/clearance from obstacles (power lines) in his flight path.NTSB BFO95LA077Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Paintersville, OHThe pilot's continued VFR flight into instrument meteorological conditions. Factors related to the accident were: the pilot's failure to obtain a weather briefing, and the weather conditions.NTSB NYC95LA166Accident · No injuriesLimited investigationFinal reportBeech V35B · Goshen, OHthe pilot's premature liftoff which resulted in an inadvertent stall and a subsequent collision with trees.NTSB BFO95LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Wauseon, OHThe pilot's failure to obtain/maintain adequate altitude/clearance from obstacles during an attempted go-round. Related factors are the pilot's failure to attain the planned approach and the improper go-around procedures.NTSB NYC95LA133Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Yellow Springs, OHinadequate visual lookout by the pilot which resulted in the airplane striking the tower.NTSB BFO95LA065Accident · No injuriesLimited investigationFinal reportAeronca 65-LB · Grand River, OHThe pilot selected unsuitable terrain for the takeoff.NTSB NYC93LA097Accident · 1 fatalLimited investigationFinal reportCessna A188B · Marengo, OHThe pilot's misjudged clearance from obstacles during aerial application, resulting in a collision with trees. A factor in this accident was the pilot's lack of total experience in aerial application flying.NTSB NYC93LA054Accident · No injuriesLimited investigationFinal reportBeech A36 · Willoughby, OHThe pilot's failure to maintain the proper glide path during an instrument approach, and his improper remedial action, resulting in a collision with trees.NTSB NYC93LA016Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Kitts Hill, OHA hard landing due to improper use of the collective, following a wire strike due to inadequate visual lookout.NTSB NYC93LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Marengo, OHThe pilot's inadequate visual lookout due to sunglare, which resulted in a tree strike on final approach.NTSB NYC92DEK01Accident · Minor injuriesFinal reportFlight Works Capella · Fredonia, OHAn in Flight collision with telephone wires while on approach for landing.NTSB NYC92FA073Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Paris, OHThe failure of the pilot to maintain directional control which resulted in the airplane flying over higher terrain with a climb rate that was insufficient to clear the obstacles. Factors related to the accident were the pilot's lack of total experience and…