# NTSB investigations, CO: 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 WPR25FA268](https://openairdocs.org/ntsb/WPR25FA268.md): Cessna 172M · Fort Morgan, CO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 31, 2025 · N61657 · 2 aircraft · Destroyed
  > On August 31, 2025, about 1040 mountain daylight time, a Cessna 172M, N61657, and an Extra Flugzeugproduktions-UND EA 300/LC, N330AN, were both destroyed when they collided midair near Fort Morgan, Colorado. The pilot and safety pilot of the Cessna received…
- [NTSB CEN22FA424](https://openairdocs.org/ntsb/CEN22FA424.md): Cessna 172S · Longmont, CO · Accident · 3 fatal · Class 3 · Field · Final report · Sep 17, 2022 · N2117Y · 2 aircraft · Destroyed
  > The pilots’ inability to see and avoid each other, resulting in a midair collision.
- [NTSB CEN21FA215](https://openairdocs.org/ntsb/CEN21FA215.md): Swearingen SA226TC · Englewood, CO · Accident · No injuries · Class 3 · Field · Final report · May 12, 2021 · N280KL · 2 aircraft · Substantial damage
  > The Cirrus pilot’s failure to maintain the final approach course for the assigned runway, which resulted in a collision with the Swearingen which was on final approach to the parallel runway. Contributing to the accident was the failure of the controller to…
- [NTSB CEN18LA087](https://openairdocs.org/ntsb/CEN18LA087.md): Robinson Helicopter R44 II · Loveland, CO · Accident · Minor injuries · Limited investigation · Final report · Jan 26, 2018 · N878BC · 2 aircraft · Substantial damage
  > The airplane pilot’s failure to see and avoid the helicopter while in the traffic pattern, which resulted in a midair collision between the two aircraft. Contributing to the accident was the airplane pilot’s misunderstanding of the helicopter pilot’s…
- [NTSB CEN12FA199](https://openairdocs.org/ntsb/CEN12FA199.md): Cessna 172S · Longmont, CO · Accident · 2 fatal · Field investigation · Final report · Mar 23, 2012 · N10468 · 2 aircraft · Substantial damage
  > The inadequate visual lookout by the pilots of both airplanes, which resulted in a mid-air collision.
- [NTSB CEN10FA115](https://openairdocs.org/ntsb/CEN10FA115.md): Piper PA-25-235 · Boulder, CO · Accident · 3 fatal · Field investigation · Final report · Feb 6, 2010 · N8718L · 3 aircraft · Substantial damage
  > The failure of both pilots to see and avoid the other resulting in a midair collision. Contributing to the accident was the lack of perceived visual relative motion of the Piper and the Cirrus to the pilot of each airplane, the terrain background, and the…
- [NTSB CEN09LA031](https://openairdocs.org/ntsb/CEN09LA031.md): Cessna 180 · Whitewater, CO · Accident · No injuries · Limited investigation · Final report · Oct 22, 2008 · N3389D · 2 aircraft · Substantial damage
  > Both pilots' failure to see and avoid the other airplane. Contributing factors in this accident were the Cessna 180 pilot's attention being diverted and the Cessna 210 pilot's vision being affected by the sun glare.

## 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" = 'CO' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '250' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/250/sequence?state=CO

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