# NTSB investigations: Cessna 182P, WY

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 DEN88LA179](https://openairdocs.org/ntsb/DEN88LA179.md): Cessna 182P · Casper, WY · Accident · No injuries · Limited investigation · Final report · Aug 8, 1988 · N182AD · Substantial damage
  > Drg flt after an annual inspn, the eng lost power as the acft was climbing to cruise. Attempts to restart the eng were unsuccessful. Subsequently, the acft was landed on rough/rocky terrain where it nosed over. When the eng was being checked after the acdnt,…
- [NTSB DEN86LA177](https://openairdocs.org/ntsb/DEN86LA177.md): Cessna 182P · Sheridan, WY · Accident · No injuries · Limited investigation · Final report · Jun 28, 1986 · N9099M · Substantial damage
  > A loss of directional control occurred during landing roll and the acft departed the left side of the grass/dirt landing strip. The acft then traveled down a slight embankment and collided with a wire fence and fence posts.
- [NTSB DEN78FA006](https://openairdocs.org/ntsb/DEN78FA006.md): Cessna 182P · Kemmerer, WY · Accident · 2 fatal · Closed · Nov 7, 1977 · N7368S · Destroyed
- [NTSB DEN76DTC46](https://openairdocs.org/ntsb/DEN76DTC46.md): Cessna 182 · Big Piney, WY · Accident · No injuries · Closed · Sep 24, 1976 · N5789J · Substantial damage
- [NTSB DEN76DTC40](https://openairdocs.org/ntsb/DEN76DTC40.md): Cessna 182 · Cheyenne, WY · Accident · No injuries · Closed · Jun 27, 1976 · N9445M · Substantial damage
- [NTSB DEN74AD028](https://openairdocs.org/ntsb/DEN74AD028.md): Cessna 182 · Cokeville, WY · Accident · 3 fatal · Closed · Nov 29, 1973 · N9338G · Destroyed

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

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

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