# NTSB investigations, 2004: 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 DEN05IA025](https://openairdocs.org/ntsb/DEN05IA025.md): Blair-American USA · Fort Collins, CO · Incident · No injuries · Incident investigation · Final report · Nov 12, 2004 · N1518 · 2 aircraft · No damage
  > the Blair-American and the Cessna pilot's inadequate visual lookout, and student pilot's failure to give right-of-way to a landing aircraft, which resulted in a runway incursion and subsequent collision. Contributing factors include the student instructor's…
- [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 LAX04FA304](https://openairdocs.org/ntsb/LAX04FA304.md): American Champion 8KCAB · Prescott, AZ · Accident · 2 fatal · Field investigation · Final report · Aug 28, 2004 · N561ER · 2 aircraft · Destroyed
  > The failure of both pilots to maintain adequate clearance from each other while performing formation aerobatic maneuvers.
- [NTSB LAX04FA301](https://openairdocs.org/ntsb/LAX04FA301.md): Bellanca 7ECA · Malibu, CA · Accident · 3 fatal · Field investigation · Final report · Aug 23, 2004 · N53879 · 2 aircraft · Destroyed
  > The failure of both pilots to maintain an adequate visual lookout and their failure to see and avoid the other aircraft.
- [NTSB NYC04FA185](https://openairdocs.org/ntsb/NYC04FA185.md): Cessna A150L · Kinnelon, NJ · Accident · 2 fatal · Field investigation · Final report · Aug 7, 2004 · N6186F · 2 aircraft · Substantial damage
  > Both pilots inadequate visual lookout, which resulted in a midair collision.
- [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 SEA04FA083](https://openairdocs.org/ntsb/SEA04FA083.md): Cessna 170B · Tenino, WA · Accident · 1 fatal · Field investigation · Final report · May 17, 2004 · N3510D · 2 aircraft · Destroyed
  > The pilot's failure to maintain an adequate visual lookout during cruise flight, which resulted in a midair collision between the two airplanes.
- [NTSB FTW04LA123](https://openairdocs.org/ntsb/FTW04LA123.md): Diamond Aircraft Industries DA-40 · Georgetown, TX · Accident · Serious injuries · Limited investigation · Final report · May 9, 2004 · N89SE · 2 aircraft · Substantial damage
  > The failure of both pilot's to maintain an adequate visual lookout, which resulted in a midair collision between the two airplanes.
- [NTSB CHI04LA104](https://openairdocs.org/ntsb/CHI04LA104.md): Cessna 172M · New Munster, WI · Accident · No injuries · Limited investigation · Final report · Apr 10, 2004 · N73213 · 2 aircraft · Substantial damage
  > Visual lookout not maintained by the pilots of both airplanes.
- [NTSB SEA04LA063](https://openairdocs.org/ntsb/SEA04LA063.md): Glasflugel STD Libelle 201B · Oso, WA · Accident · 1 fatal · Limited investigation · Final report · Apr 2, 2004 · N161D · 2 aircraft · Substantial damage
  > The pilot of the Glaser-Dirks (lead glider) failure to maintain clearance from the Glasflugel (trailing glider) resulting in a mid-air collision while maneuvering.
- [NTSB MIA04FA043](https://openairdocs.org/ntsb/MIA04FA043.md): Piper PA-30 · Clearwater, FL · Accident · 1 fatal · Field investigation · Final report · Jan 17, 2004 · N8735Y · 2 aircraft · Substantial damage
  > The failure of both pilots to maintain adequate visual lookout while entering the traffic pattern (downwind leg) at an uncontrolled airport resulting in a midair collision. inadvertent stall, and in-flight collision with terrain.
- [NTSB LAX04FA095](https://openairdocs.org/ntsb/LAX04FA095.md): Cessna 180K · Tehachapi, CA · Accident · 1 fatal · Field investigation · Final report · Jan 16, 2004 · N61691 · 2 aircraft · Destroyed
  > The pilot's inadequate visual lookout during climb, and the pilot of the other airplane's inadequate visual lookout during cruise.

## 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 year(c."eventDate") = 2004
  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&year=2004

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