# NTSB investigations, NM: 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 DEN07IA021](https://openairdocs.org/ntsb/DEN07IA021.md): Beech P35 · Los Alamos, NM · Incident · No injuries · Incident investigation · Final report · Nov 6, 2006 · N102H · 2 aircraft · Minor damage
  > the failure of both pilots to maintain adequate visual lookout during the visual approach. A contributing factor was the failure of N5368E's pilot to communicate his intentions on the Common Traffic Advisory Frequency.
- [NTSB DEN00LA148](https://openairdocs.org/ntsb/DEN00LA148.md): Cessna 150H · Albuquerque, NM · Accident · Minor injuries · Limited investigation · Final report · Aug 11, 2000 · N6999S · 2 aircraft · Substantial damage
  > the failure of both pilots to maintain visual lookout. A contributing factor was the pilot not following recommended traffic pattern procedures.
- [NTSB DEN99LA067](https://openairdocs.org/ntsb/DEN99LA067.md): Cessna 172I · Las Cruces, NM · Accident · No injuries · Limited investigation · Final report · Apr 28, 1999 · N46204 · 2 aircraft · Substantial damage
  > The pilot of N46204's failure to maintain visual lookout and to identify the other aircraft visually during landing.
- [NTSB FTW98LA009](https://openairdocs.org/ntsb/FTW98LA009.md): Cameron N-90 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Oct 10, 1997 · N1602R · 2 aircraft · Substantial damage
  > The failure of the pilot of the Aerostar RX 8, N71415, to follow procedures/directives.
- [NTSB FTW93LA010](https://openairdocs.org/ntsb/FTW93LA010.md): Raven S-60A · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Oct 8, 1992 · N8EN · 2 aircraft · Substantial damage
  > The pilot's failure to maintain visual lookout.
- [NTSB DEN91LA062](https://openairdocs.org/ntsb/DEN91LA062.md): Ercoupe 415-C · Santa Rosa, NM · Accident · Minor injuries · Limited investigation · Final report · Apr 19, 1991 · N87259 · 2 aircraft · Substantial damage
  > The pilot of the other aircraft failed to maintain clearance between the aircraft.
- [NTSB DEN88LA010](https://openairdocs.org/ntsb/DEN88LA010.md): Balloon Works Firefly 7 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Oct 5, 1987 · N36988 · 2 aircraft · Substantial damage
  > Two balloons, a rally and a firefly, collided in flight during the Albuquerque international Balloon fiesta. The pilot of the firely was climbing at approximately 300 feet per minute when his envelope contacted the basket of the rally. The pilot of the rally…

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

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