OpenAirDocs.org

NTSB investigations, OH

8 cases where the first occurrence was “Midair collision”.

Cases per year

19862026

Where

Open the map

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.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 270)
  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.

NTSB CHI07FA140Accident · 3 fatalField investigationFinal reportCessna 172N · Sharonville, OHThe inadequate visual lookout of the pilots in both airplanes and their not maintaining clearance from each others airplane during climb.May 11, 2007 · N6614D · 2 aircraft · DestroyedNTSB CHI06FA010Accident · 4 fatalField investigationFinal reportPlavcan Lancair 235 · Rootstown, OHThe failure of both pilots to maintain an adequate visual lookout during cruise flight, which resulted in their failure to see and avoid each other and a midair collision.Oct 14, 2005 · N235U · 2 aircraft · DestroyedNTSB NYC05LA002Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Harrison, OHThe Cessna 152 pilot's improper traffic pattern procedure and improper radio communication, which resulted in a mid-air collision with a Cessna 172. A factor in the accident was both pilots' failure to maintain an adequate visual lookout.Oct 10, 2004 · N68298 · 2 aircraft · Substantial damageNTSB NYC00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Parkertown, OHThe inadequate visual lookout by the pilots of both airplanes.Feb 15, 2000 · N8264G · 2 aircraft · Substantial damageNTSB NYC94LA130Accident · 1 fatalLimited investigationFinal reportEdward A. Alderfer EAA-3 · Middletown, OHInadequate visual lookout by both pilots which resulted in a mid-air collision. A factor was the failure of the pilot of the ultralight to stay north of runway 26.Jul 19, 1994 · N63EA · 2 aircraft · Substantial damageNTSB NYC91LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Kent, OHFailure of both pilots to maintain visual separation in the landing traffic pattern. Factors to this mid-air collision were the excessive number of airplanes in the airport traffic pattern and radio frequency congestion.Oct 20, 1990 · N5331P · 2 aircraft · Substantial damageNTSB CHI88LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Moraine, OHWhile on final approach N7222W experienced a midair collision with N8611U on a similar approach. N8611U was a high wing aircraft and was in front of and below N7222W which was a low wing aircraft. The pilot of N8611U stated that he had no knowledge of the…Jul 7, 1988 · N7222W · 2 aircraft · Substantial damageNTSB ATL87FA006Accident · No injuriesField investigationFinal reportCessna 140A · Hamilton, OHThe Cessna high wing was in the traffic pattern doing touch and go's and was on the third apch when the homebuilt biwing entered the traffic pattern. The homebuilt overtook the Cessna on short final. The collision occurred about 100-200 feet AGL. Both acft…Oct 19, 1986 · N9612A · 2 aircraft · Substantial damage