# NTSB investigations, OH: Midair collision

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB CHI07FA140](https://openairdocs.org/ntsb/CHI07FA140.md): Cessna 172N · Sharonville, OH · Accident · 3 fatal · Field investigation · Final report · May 11, 2007 · N6614D · 2 aircraft · Destroyed
  > The inadequate visual lookout of the pilots in both airplanes and their not maintaining clearance from each others airplane during climb.
- [NTSB CHI06FA010](https://openairdocs.org/ntsb/CHI06FA010.md): Plavcan Lancair 235 · Rootstown, OH · Accident · 4 fatal · Field investigation · Final report · Oct 14, 2005 · N235U · 2 aircraft · Destroyed
  > The 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.
- [NTSB NYC05LA002](https://openairdocs.org/ntsb/NYC05LA002.md): Cessna 152 · Harrison, OH · Accident · Serious injuries · Limited investigation · Final report · Oct 10, 2004 · N68298 · 2 aircraft · Substantial damage
  > The 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.
- [NTSB NYC00LA081](https://openairdocs.org/ntsb/NYC00LA081.md): Piper PA-28-236 · Parkertown, OH · Accident · No injuries · Limited investigation · Final report · Feb 15, 2000 · N8264G · 2 aircraft · Substantial damage
  > The inadequate visual lookout by the pilots of both airplanes.
- [NTSB NYC94LA130](https://openairdocs.org/ntsb/NYC94LA130.md): Edward A. Alderfer EAA-3 · Middletown, OH · Accident · 1 fatal · Limited investigation · Final report · Jul 19, 1994 · N63EA · 2 aircraft · Substantial damage
  > Inadequate 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.
- [NTSB NYC91LA015](https://openairdocs.org/ntsb/NYC91LA015.md): Cessna 152 · Kent, OH · Accident · No injuries · Limited investigation · Final report · Oct 20, 1990 · N5331P · 2 aircraft · Substantial damage
  > Failure 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.
- [NTSB CHI88LA156](https://openairdocs.org/ntsb/CHI88LA156.md): Piper PA-28-180 · Moraine, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 7, 1988 · N7222W · 2 aircraft · Substantial damage
  > While 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…
- [NTSB ATL87FA006](https://openairdocs.org/ntsb/ATL87FA006.md): Cessna 140A · Hamilton, OH · Accident · No injuries · Field investigation · Final report · Oct 19, 1986 · N9612A · 2 aircraft · Substantial damage
  > The 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…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

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

This list as a web page: https://openairdocs.org/ntsb?occurrence=270&state=OH

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.