# NTSB investigations: Cessna 172M: 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 WPR23LA041](https://openairdocs.org/ntsb/WPR23LA041.md): Cessna 172M · Las Vegas, NV · Accident · No injuries · Class 3 · Limited · Final report · Nov 18, 2022 · N88E · 2 aircraft · Substantial damage
  > The student helicopter pilot’s failure to follow the tower controller’s landing instructions, which resulted in a midair collision.
- [NTSB WPR15MA243](https://openairdocs.org/ntsb/WPR15MA243.md): Cessna 172M · San Diego, CA · Accident · 5 fatal · Major investigation · Final report · Aug 16, 2015 · N1285U · 2 aircraft · Destroyed
  > The local controller's (LC) failure to properly identify the aircraft in the pattern and to ensure control instructions provided to the intended Cessna on downwind were being performed before turning Eagle1 into its path for landing. Contributing to the LC's…
- [NTSB ERA14FA459](https://openairdocs.org/ntsb/ERA14FA459.md): Cessna 172M · Lancaster, NY · Accident · 2 fatal · Field investigation · Final report · Sep 27, 2014 · N9679H · 2 aircraft · Destroyed
  > The other airplane pilot’s failure to maintain an adequate visual lookout for known traffic in the fly-in event traffic pattern, which resulted in a midair collision.
- [NTSB WPR13FA211](https://openairdocs.org/ntsb/WPR13FA211.md): Cessna 172RG · Calabasas, CA · Accident · 2 fatal · Class 3 · Field · Final report · Apr 29, 2013 · N4677V · 2 aircraft · Substantial damage
  > The failure of the pilots in both aircraft to maintain an adequate visual lookout, which resulted in a midair collision.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072418')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND 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?model=2072418

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