# NTSB investigations: Cessna 172RG, MN

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 CEN15LA309](https://openairdocs.org/ntsb/CEN15LA309.md): Cessna 172RG · Anoka, MN · Accident · No injuries · Limited investigation · Final report · Jul 17, 2015 · N6511V · Substantial damage
  > Failure of the left landing gear actuator for reasons that could not be determined because the actuator was not made available for examination.
- [NTSB CHI92FA035](https://openairdocs.org/ntsb/CHI92FA035.md): Cessna 172RG · Litchfield, MN · Accident · 4 fatal · Field investigation · Final report · Nov 27, 1991 · N9589B · Destroyed
  > Pilot factor in that he had spatial disorientation. Factors related to the accident are; VFR flight into IMC, disregarding hazardous weather advisories, performing flight into known adverse weather conditions, and overconfidence in personal ability by the…
- [NTSB CHI91LA196](https://openairdocs.org/ntsb/CHI91LA196.md): Cessna 172RG · Hawley, MN · Accident · No injuries · Limited investigation · Final report · Jun 19, 1991 · N9431D · Substantial damage
  > Inattentiveness of both the flight instructor and the student pilot, and failure to use carburetor heat. A factor related to the accident is the unsuitable terrain encountered during the forced landing.
- [NTSB CHI84FA169](https://openairdocs.org/ntsb/CHI84FA169.md): Cessna 172RG · Woodbury, MN · Accident · 4 fatal · Field investigation · Final report · Apr 29, 1984 · N6446V · Destroyed
  > The acft collided with a radio antenna support cable at aprx 171 ft AGL during low altitude maneuvering in snow showers. One witness stated that the heaviest snow showers were in the vicinity of the accident site. A policeman saw the acft over a field near…

## 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" = 'MN' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072438'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072438&state=MN

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