# NTSB investigations, LA: 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 DFW07LA022](https://openairdocs.org/ntsb/DFW07LA022.md): Cessna 152 · Monroe, LA · Accident · No injuries · Limited investigation · Final report · Nov 7, 2006 · N94684 · 2 aircraft · Substantial damage
  > The failure of the second pilot to maintain separation from the preceding traffic established on final approach. A contributing factor was the failure by ATC personnel to visually identify and separate airplanes in the traffic pattern.
- [NTSB DFW05LA182](https://openairdocs.org/ntsb/DFW05LA182.md): Ayres S2R-T34 · Bonita, LA · Accident · No injuries · Limited investigation · Final report · Jul 14, 2005 · N61220 · 2 aircraft · Substantial damage
  > The failure of the pilot to maintain adequate visual lookout, which resulted in a midair collision.
- [NTSB DFW05LA134](https://openairdocs.org/ntsb/DFW05LA134.md): Gulfstream-Schweizer G-164D · Jennings, LA · Accident · No injuries · Limited investigation · Final report · May 24, 2005 · N8120K · 2 aircraft · Substantial damage
  > The failure of both pilots to maintain adequate visual lookout, which resulted in a midair collision while on final approach.
- [NTSB FTW00LA233](https://openairdocs.org/ntsb/FTW00LA233.md): Air Tractor AT-502 · Deerpark, LA · Accident · Minor injuries · Limited investigation · Final report · Aug 15, 2000 · N9136U · 2 aircraft · Destroyed
  > the failure of both pilots to maintain a visual outlook during landing approach. A contributing factor was both pilot's failure to follow recommended traffic patterns.
- [NTSB FTW97FA208](https://openairdocs.org/ntsb/FTW97FA208.md): Bell 206B · Intracoastl Cty, LA · Accident · 1 fatal · Field investigation · Final report · Jun 1, 1997 · N115AL · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid each other's aircraft. Factors were the failure of the pilot of N2773A to use the available traffic advisory service and the failure of the operator of N2773A to make the use of traffic advisory services a company…
- [NTSB FTW97LA018](https://openairdocs.org/ntsb/FTW97LA018.md): Aeronca 11BC · Oil City, LA · Accident · No injuries · Limited investigation · Final report · Oct 13, 1996 · N3818E · 2 aircraft · Substantial damage
  > the failure of the pilots of both aircraft to maintain an adequate visual lookout. Factors were: different traffic pattern altitudes flown by the two pilots, and the sunglare encountered by the pilot of the ultralight.
- [NTSB FTW89FA159](https://openairdocs.org/ntsb/FTW89FA159.md): Cessna 152 · Houma, LA · Accident · 3 fatal · Field investigation · Final report · Sep 3, 1989 · N24516 · 2 aircraft · Destroyed
  > The failure of both pilots to see-and-avoid each other's aircraft (inadequate visual lookout). A probable factor was: failure of either pilot to issue a traffic advisory.
- [NTSB FTW82FRJ16](https://openairdocs.org/ntsb/FTW82FRJ16.md): Rockwell S-2R · Jones, LA · Accident · 2 fatal · Final report · Aug 23, 1982 · N8474V · 2 aircraft · Destroyed
  > Air tractor AT-400, N2342Z, and another aircraft, a Rockwell international S-2R, N8474V, collided while both aircraft were involved in spraying operatons. The AT-400 pilot was spraying a field that was surrounded by trees. He had just completed a swath run to…

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

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