# NTSB investigations: Cessna R172E: In flight collision with object

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 DEN92LA053](https://openairdocs.org/ntsb/DEN92LA053.md): Cessna R172E · Colorado Spring, CO · Accident · No injuries · Limited investigation · Final report · May 18, 1992 · N146AC · Substantial damage
  > The pilot did not maintain clearance and the airplane collided with a fence post.
- [NTSB LAX89LA194](https://openairdocs.org/ntsb/LAX89LA194.md): Cessna R172E · Young, AZ · Accident · Minor injuries · Limited investigation · Final report · May 14, 1989 · N88778 · Substantial damage
  > The pilots decision to land at the restricted airport which had a tree located 20 feet from the centerline of the runway and his failure to maintain proper alignment with the centerline once he made the decision to land there.
- [NTSB DEN84FA251](https://openairdocs.org/ntsb/DEN84FA251.md): Cessna R172E · Farmington, NM · Accident · 2 fatal · Field investigation · Final report · Aug 6, 1984 · N601SP · Destroyed
  > After being airborne 1 hour and 10 minutes the traffic surviellance flt was cancelled. The plt transmitted to the policeunits on the ground that he would 'buzz' them as he left the area. During this pass the acft struck a high voltage transmission line 88.9…

## 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 ('2072413')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072413&occurrence=220

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