# NTSB investigations: Cessna 172S: 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 ERA26LA167](https://openairdocs.org/ntsb/ERA26LA167.md): Cessna 172S · Marathon, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 11, 2026 · N529ND · 2 aircraft · Substantial damage
  > On April 11, 2026, about 1330 eastern daylight time, a Cessna 172S airplane, N529ND sustained substantial damage and a Raytheon Aircraft Company B200 (King Air) airplane, N699BW sustained minor damage when they collided in flight near Marathon, Florida. The 2…
- [NTSB ERA25LA072](https://openairdocs.org/ntsb/ERA25LA072.md): Piper PA28 · Pahokee, FL · Accident · No injuries · Class 3 · Limited · Final report · Dec 9, 2024 · N90874 · 2 aircraft · Substantial damage
  > The pilots' failure to see and avoid the other airplane, which resulted in a midair collision during short final approach.
- [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 CEN20LA419](https://openairdocs.org/ntsb/CEN20LA419.md): Cessna 172S · San Marcos, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 25, 2020 · N108VK · 2 aircraft · Substantial damage
  > The F1 pilot’s failure to see and avoid the lower altitude Cessna while on final approach for landing. Contributing to the accident were the restrictions to pilot visibility inherent to low- and high-wing airplanes, and both pilots’ failure to recognize the…
- [NTSB CEN19LA074](https://openairdocs.org/ntsb/CEN19LA074.md): Cessna 172 · Grand Prairie, TX · Accident · No injuries · Limited investigation · Final report · Jan 29, 2019 · N565SP · 2 aircraft · Substantial damage
  > The failure of the pilots of both airplanes to see and avoid the other airplane while entering the airport traffic pattern in visual meteorological conditions. Contributing to the accident was the tower controller's failure to recognize the proximity of the…
- [NTSB WPR13FA254](https://openairdocs.org/ntsb/WPR13FA254.md): Piper PA-28-181 · Anthem, AZ · Accident · 4 fatal · Field investigation · Final report · May 31, 2013 · N327PA · 2 aircraft · Substantial damage
  > The failure of the pilots in both aircraft to maintain adequate visual lookout in a known training area where multiple aircraft frequently operated, which resulted in a midair collision.
- [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.

## 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 ('2072439', '2072442')
    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=2072439

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