# NTSB investigations, 2001: 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 ATL02LA012](https://openairdocs.org/ntsb/ATL02LA012.md): Extra Flugzeugbau EA300/L · St. Augustine, FL · Accident · No injuries · Limited investigation · Final report · Nov 10, 2001 · N2XA · 2 aircraft · Minor damage
  > The pilot of the other airplanes failure to maintain a visual lookout and yield the right-of-way to a lower airplane while landing. This resulted in an inadvertent midair collision. Contributing to the accident was reported excessive radio communication on…
- [NTSB LAX01GA291](https://openairdocs.org/ntsb/LAX01GA291.md): Grumman TS-2A · Hopland, CA · Accident · 2 fatal · Final report · Aug 28, 2001 · N442DF · 2 aircraft · Destroyed
  > the failure of both pilots to maintain an adequate visual lookout. The failure of the pilot in Tanker 87 to comply with suggested procedures regarding positive radio contact and orbit entry was a factor.
- [NTSB DEN01TA134](https://openairdocs.org/ntsb/DEN01TA134.md): Bell 205A-1 · Jackson, WY · Accident · No injuries · Final report · Jul 31, 2001 · N205BR · 2 aircraft · Substantial damage
  > the Bell 212 helicopter pilot's inadequate visual lookout which resulted in a midair collision.
- [NTSB SEA01LA122](https://openairdocs.org/ntsb/SEA01LA122.md): Piper PA-38-112 · Bozeman, MT · Accident · No injuries · Limited investigation · Final report · Jun 27, 2001 · N9341T · 2 aircraft · Substantial damage
  > The pilot of another aircraft failed to maintain clearance while maneuvering for a formation flight. An updraft was a factor.
- [NTSB ATL01LA063](https://openairdocs.org/ntsb/ATL01LA063.md): Air Tractor 502B · Anguilla, MS · Accident · 2 fatal · Limited investigation · Final report · Jun 2, 2001 · N257LA · 2 aircraft · Destroyed
  > Failure of both pilots to maintain visual lookout, resulting in an in-flight collision. A factor was sun glare.
- [NTSB LAX01FA101](https://openairdocs.org/ntsb/LAX01FA101.md): Cessna 152 · Long Beach, CA · Accident · 4 fatal · Field investigation · Final report · Feb 15, 2001 · N68763 · 2 aircraft · Destroyed
  > The failure of the flight crews of both airplanes to maintain adequate visual lookout for traffic.
- [NTSB FTW01FA058](https://openairdocs.org/ntsb/FTW01FA058.md): Cessna 152 · Platter, OK · Accident · 2 fatal · Field investigation · Final report · Feb 6, 2001 · N114SS · 2 aircraft · Destroyed
  > the failure of both pilots to maintain a visual lookout, which resulted in a mid-air collision over a lake. A contributing factor to the accident was the sun glare from the setting sun.

## 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") = 2001
  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=2001

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