# NTSB investigations, AR: 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 DFW06LA130](https://openairdocs.org/ntsb/DFW06LA130.md): Grumman G-164A · DeWitt, AR · Accident · 1 fatal · Limited investigation · Final report · May 18, 2006 · N6629 · 2 aircraft · Substantial damage
  > The failure by both pilots to maintain adequate visual lookout and the Grumman G-164A pilot's impairment caused by the recent use of marijuana.
- [NTSB FTW04LA151](https://openairdocs.org/ntsb/FTW04LA151.md): Air Tractor AT-502B · Weldon, AR · Accident · No injuries · Limited investigation · Final report · Jun 3, 2004 · N5002D · 2 aircraft · Minor damage
  > The other pilot's failure to maintain an adequate visual lookout during approach to landing, which resulted in a midair collision between the two airplanes.
- [NTSB FTW96FA130](https://openairdocs.org/ntsb/FTW96FA130.md): Cessna 182R · Proctor, AR · Accident · 4 fatal · Field investigation · Final report · Feb 24, 1996 · N9303E · 2 aircraft · Destroyed
  > failure of the pilots in both airplanes to see-and-avoid conflicting traffic (inadequate visual lookout).
- [NTSB MKC88DPG02](https://openairdocs.org/ntsb/MKC88DPG02.md): Snow 600-S2C · Almyra, AR · Accident · 2 fatal · Final report · Jul 30, 1988 · N1671S · 2 aircraft · Destroyed
  > Two ag aircraft were spraying the same field. According to several witnesses, 1671S was heading south and 3660X was heading east. Both aircraft were actively engaged in the spraying operation but did not seem to the witnesses to be coordinating with each…
- [NTSB MKC86FA123](https://openairdocs.org/ntsb/MKC86FA123.md): Cessna 140 · Des Arc, AR · Accident · 3 fatal · Field investigation · Final report · Jun 1, 1986 · N89247 · 2 aircraft · Destroyed
  > Numerous witnesses on a sandbar in the white river observed this collision of two airplanes as they were flying close together, low, over the river. Of the nine witness statements received, five had the Piper PA-28-140 hitting the Cessna 140, three had the…
- [NTSB MKC84FA240](https://openairdocs.org/ntsb/MKC84FA240.md): Cessna A188B · Stonewall, AR · Accident · Minor injuries · Field investigation · Final report · Aug 5, 1984 · N8145G · 2 aircraft · Substantial damage
  > While engaged in aerial application, two acft working the same field collided in-flight. Pre-flight planning and briefing for the dual operation was not conducted. There were no inter-plane communications.
- [NTSB MKC84LA178](https://openairdocs.org/ntsb/MKC84LA178.md): Snow AT400 · Portland, AR · Accident · No injuries · Limited investigation · Final report · Jun 18, 1984 · N501PR · 2 aircraft · Substantial damage
  > Both acft were about to touch down. N501PR was above N501JS. The pilot of N501PR stated that just before touchdown the collision occurred and resulted in severing of the tail section of N501PR. The pilot of 501JS stated N501PR flared out to land directly in…

## 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" = 'AR' 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=AR

---
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.