# NTSB investigations: Cessna 182R, 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 CHI05TA251](https://openairdocs.org/ntsb/CHI05TA251.md): Cessna 182R · New Ulm, MN · Accident · No injuries · Final report · Aug 31, 2005 · N505NR · Substantial damage
  > The loss of engine power for undetermined reasons resulting in a forced landing. A contributing factor was the soft terrain condition.
- [NTSB CHI92LA069](https://openairdocs.org/ntsb/CHI92LA069.md): Cessna 182 · Lake Elmo, MN · Accident · No injuries · Limited investigation · Final report · Jan 11, 1992 · N9845H · Substantial damage
  > The proper touchdown point was not attained and an aborted landing was delayed by the pilot. A factor related to the accident was the icy runway conditions.
- [NTSB CHI82DA193](https://openairdocs.org/ntsb/CHI82DA193.md): Cessna 182 · Tracy, MN · Accident · No injuries · Final report · May 30, 1982 · N9767H · Substantial damage
  > The pilot reported that during a normal landing, the left main gear axle failed and he was unable to control the aircraft. The aircraft went off the runway and the nose gear collapsed when it encountered soft mud.

## 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 ('2072731'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072731&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.