# NTSB investigations: Cessna 152, 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 SEA95LA133](https://openairdocs.org/ntsb/SEA95LA133.md): Cessna 152 · Saratoga, WY · Accident · No injuries · Limited investigation · Final report · Jun 26, 1995 · N5460B · Substantial damage
  > The pilot's improper handling of the airplane during landing.
- [NTSB SEA93LA123](https://openairdocs.org/ntsb/SEA93LA123.md): Cessna 152 · Cheyenne, WY · Accident · No injuries · Limited investigation · Final report · May 27, 1993 · N43LL · Substantial damage
  > The pilot's improper flare and improper recovery from a bounced landing. Factors include strong crosswinds, downdrafts, and an excessive descent rate.
- [NTSB DEN85LA213](https://openairdocs.org/ntsb/DEN85LA213.md): Cessna 152 · Riverton, WY · Accident · No injuries · Limited investigation · Final report · Aug 9, 1985 · N4941P · Substantial damage
  > The student plt attempted to land on rwy 17. The wind was reported to be from 010 degs at 13 KTS. The acft touched down halfway down the rwy. The plt attempted to go around but aborted because of the tailwind. The acft ran off the end of the rwy and collided…
- [NTSB DEN83LA025](https://openairdocs.org/ntsb/DEN83LA025.md): Cessna 152 · Afton, WY · Accident · No injuries · Limited investigation · Final report · Nov 26, 1982 · N24378 · Substantial damage
  > The pilot stated that he touched down on the snow covered runway and the brakes were frozen. The aircraft hit bare pavement and veered to the left. Wheel dropped off edge of runway into a snow bank. The aircraft nosed over. An interview with the pilot…
- [NTSB DEN81FTC27](https://openairdocs.org/ntsb/DEN81FTC27.md): Cessna 152 · Casper, WY · Accident · No injuries · Closed · Sep 19, 1981 · N4941P · Substantial damage
- [NTSB DEN81FTC15](https://openairdocs.org/ntsb/DEN81FTC15.md): Cessna 152 · Gillette, WY · Accident · No injuries · Closed · May 8, 1981 · N6560H · Substantial damage
- [NTSB DEN81FA031](https://openairdocs.org/ntsb/DEN81FA031.md): Cessna 152 · Cowley, WY · Accident · 1 fatal · Closed · May 4, 1981 · N757YH · Destroyed
- [NTSB DEN80FTC19](https://openairdocs.org/ntsb/DEN80FTC19.md): Cessna 152 · Sheridan, WY · Accident · Minor injuries · Closed · Jun 22, 1980 · N67417 · Substantial damage
- [NTSB DEN80FTC07](https://openairdocs.org/ntsb/DEN80FTC07.md): Cessna 152 · Lander, WY · Accident · No injuries · Closed · Feb 16, 1980 · N24272 · Substantial damage
- [NTSB DEN78FTC33](https://openairdocs.org/ntsb/DEN78FTC33.md): Cessna 152 · Gillette, WY · Accident · No injuries · Closed · Jul 23, 1978 · N67417 · Substantial damage
- [NTSB DEN78FTC17](https://openairdocs.org/ntsb/DEN78FTC17.md): Cessna 172 · Alta, WY · Accident · 1 fatal · Closed · Mar 18, 1978 · N25435 · Destroyed
- [NTSB DEN78DTC12](https://openairdocs.org/ntsb/DEN78DTC12.md): Cessna 152 · Cheyenne, WY · Accident · No injuries · Closed · Feb 13, 1978 · N25444 · 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 ('2071835'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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