# NTSB investigations: Cessna 172, 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 GAA17CA437](https://openairdocs.org/ntsb/GAA17CA437.md): Cessna 172 · Powell, WY · Accident · No injuries · Data collection · Final report · Jul 24, 2017 · N6470E · Substantial damage
  > The student pilot’s improper landing flare and subsequent failure to relinquish the flight controls, which resulted in a hard landing.
- [NTSB DEN01FA028](https://openairdocs.org/ntsb/DEN01FA028.md): Cessna 172 · Lusk, WY · Accident · 2 fatal · Field investigation · Final report · Dec 16, 2000 · N4223F · Substantial damage
  > the pilot's VFR flight into instrument meteorological conditions, and his subsequent failure to maintain terrain clearance, which resulted in an in-flight collision with terrain. Contributing factors were the pilot's failure to obtain a weather briefing, low…
- [NTSB FTW98LA116](https://openairdocs.org/ntsb/FTW98LA116.md): Cessna 172 · Laramie, WY · Accident · No injuries · Limited investigation · Final report · Jan 30, 1998 · N6926A · Substantial damage
  > The pilot's improper flare and subsequent improper go-around in that he failed to use compensating elevator control, and his loss of directional control.
- [NTSB SEA92LA137](https://openairdocs.org/ntsb/SEA92LA137.md): Cessna 172 · Mckinnon, WY · Accident · Minor injuries · Limited investigation · Final report · Jun 26, 1992 · N6089A · Destroyed
  > Water in the aircraft fuel system which was not purged as a result of the pilot in command's inadequate preflight. Factors contributing to the accident were: trees, a fence and the uneven terrain condition during the landing and rollout.
- [NTSB DEN89LA030](https://openairdocs.org/ntsb/DEN89LA030.md): Cessna 172 · Riverton, WY · Accident · No injuries · Limited investigation · Final report · Nov 13, 1988 · N8045B · Substantial damage
  > The instructor reported closing the throttle to simulate an engine failure, during a training flight. The student added carburetor heat first, instead of establishing a proper glide. The instructor removed carburetor heat and advised the student of the…
- [NTSB DEN86FA223](https://openairdocs.org/ntsb/DEN86FA223.md): Cessna 172 · Ten Sleep, WY · Accident · 1 fatal · Field investigation · Final report · Aug 9, 1986 · N4016F · Destroyed
  > The plt became lost/disoriented and inadvertently entered the narrow canyon in a mountain pass. He attempted to land on a public highway at 7,500 feet MSL when it became apparent the acft would not climb fast enough to clear rapidly rising terrain and that it…
- [NTSB DEN79FTC05](https://openairdocs.org/ntsb/DEN79FTC05.md): Cessna 172 · Rawlings, WY · Accident · 1 fatal · Closed · Dec 17, 1978 · N7015A · Destroyed
- [NTSB DEN72DTC14](https://openairdocs.org/ntsb/DEN72DTC14.md): Cessna 172 · Evanston, WY · Accident · No injuries · Closed · Jan 9, 1972 · N3245G · Substantial damage
- [NTSB DEN70F0045](https://openairdocs.org/ntsb/DEN70F0045.md): Cessna 172 · Laramie, WY · Accident · Serious injuries · Closed · Jun 20, 1969 · N7132A · Destroyed
- [NTSB DEN69F0135](https://openairdocs.org/ntsb/DEN69F0135.md): Cessna 172 · Laramie, WY · Accident · No injuries · Closed · Oct 25, 1968 · N7909B · Substantial damage
- [NTSB DEN69D0159](https://openairdocs.org/ntsb/DEN69D0159.md): Cessna 172 · Hulett, WY · Accident · No injuries · Closed · Oct 11, 1968 · N8214B · Substantial damage
- [NTSB DEN66F0131](https://openairdocs.org/ntsb/DEN66F0131.md): Cessna 172 · Albin, WY · Accident · No injuries · Closed · Oct 7, 1965 · N8058B · Substantial damage
- [NTSB DEN65F0097](https://openairdocs.org/ntsb/DEN65F0097.md): Cessna 172 · Sundance, WY · Accident · Minor injuries · Closed · May 30, 1965 · N4077F · Substantial damage
- [NTSB UNK64X1396](https://openairdocs.org/ntsb/UNK64X1396.md): Cessna 172 · Dubois, WY · Accident · 1 fatal · Closed · Apr 20, 1964 · N5831A · Substantial damage
- [NTSB UNK64X0551](https://openairdocs.org/ntsb/UNK64X0551.md): Cessna 172A · Newcastle, WY · Accident · 1 fatal · Closed · Feb 13, 1964 · N6480E · Destroyed
- [NTSB UNK64X0111](https://openairdocs.org/ntsb/UNK64X0111.md): Cessna 172 · Rawlings, WY · Accident · No injuries · Closed · Jan 1, 1964 · N4182F · Substantial damage

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

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