Skip to content

NTSB investigations: Cessna 180, WY

25 cases on aircraft the registry lists as Cessna 180. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Where

Latest cases

Query with 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 ('2072602')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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 ('2072602'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB WPR26LA253Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Marbleton, WYThe pilot's failure to maintain directional control during the landing roll.Jul 9, 2026 · N3339D · Substantial damage NTSB WPR14CA247Accident · No injuriesData collectionFinal reportCessna 180 · Casper, WYThe pilot's inadequate flare and loss of directional control during landing.Jun 16, 2014 · N9012C · Substantial damage NTSB DEN06LA094Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Sheridan, WYthe partial loss of engine power for undetermined reasons. Contributing factors were the dirt embankment and fence.Jun 30, 2006 · N153M · Substantial damage NTSB SEA95LA027Accident · No injuriesLimited investigationFinal reportCessna 180 · Lonetree, WYThe restricted movement of the carburebor float.Dec 8, 1994 · N1594C · Substantial damage NTSB SEA93FA187Accident · 3 fatalField investigationFinal reportCessna 180 · Cheyenne, WYImproper in-flight planning/decison by the pilot, which resulted in exceeding the design stress limits of the aircraft after encountering adverse weather. The weather conditions were related factors.Sep 2, 1993 · N3120C · Destroyed NTSB SEA91LA185Accident · No injuriesLimited investigationFinal reportCessna 180 · Cody, WYPilot's failure to maintain proper runway alignment. Factors were diverted attention, and gusty crosswinds.Jul 20, 1991 · N3343D · Substantial damage NTSB DEN87LA136Accident · No injuriesLimited investigationFinal reportCessna 180 · Upton, WYThe plt reported completing a cross wind landing with strong gusts. While taxiing from landing, the wind lifted the acft from the right and it nosed over. The rwy used was 13, and the FBO reported winds as 210 degrees at 20 knots, gusting to 40 knots.May 27, 1987 · N2933C · Substantial damage NTSB DEN86LA156Accident · No injuriesLimited investigationFinal reportCessna 180 · Cheyenne, WYThe student plt flew from alliance to Cheyenne on his solo x-country and flew locally at Cheyenne to make 3 landings at a twr controlled arpt. While he was in the pattern a cumulonimbus cloud moved into the vicinity of the arpt and the winds became gusty.…Jun 6, 1986 · N3253D · Substantial damage NTSB DEN81FTC19Accident · No injuriesClosedCessna 180 · Thayne, WYJun 26, 1981 · N966K · Substantial damage NTSB DEN77DTC01Accident · No injuriesClosedRobertson 180 · Edgerton, WYNov 8, 1976 · N134H · Substantial damage NTSB DEN76DTC10Accident · No injuriesClosedCessna 180 · Wheatland, WYAug 6, 1975 · N3657C · Substantial damage NTSB DEN75FTC19Accident · No injuriesClosedCessna 180 · Jackson, WYApr 25, 1975 · N8817 · Substantial damage NTSB DEN73FTC27Accident · No injuriesClosedCessna 180 · Kemmerer, WYJun 12, 1973 · N3657C · Substantial damage NTSB DEN73DTC17Accident · No injuriesClosedCessna 180 · Gillette, WYJan 21, 1973 · N3178D · Substantial damage NTSB DEN73AD007Accident · 3 fatalClosedCessna 180 · Casper, WYAug 18, 1972 · N3354D · Destroyed NTSB DEN72ADO43Accident · 1 fatalClosedCessna 180H · Medicine Bow, WYMar 20, 1972 · N9050M · Destroyed NTSB DEN71DXA07Accident · No injuriesClosedCessna 180 · Cody, WYAug 24, 1970 · N4773B · Substantial damage NTSB DEN70F0077Accident · No injuriesClosedCessna 180 · Casper, WYJul 24, 1969 · N134H · Substantial damage NTSB DEN69A0007Accident · 2 fatalClosedCessna 180 · Casper, WYAug 9, 1968 · N4794B · Destroyed NTSB DEN68D0164Accident · No injuriesClosedCessna 180 · Casper, WYDec 9, 1967 · N3178D · Substantial damage NTSB DEN68D0031Accident · No injuriesClosedCessna 180 · Moorcroft, WYJul 10, 1967 · N3335D · Substantial damage NTSB DEN67D0096Accident · No injuriesClosedCessna 180 · Kemmerer, WYAug 28, 1966 · N3642C · Substantial damage NTSB DEN66F0213Accident · No injuriesClosedCessna 180 · Rock Springs, WYJan 25, 1966 · N6570A · Substantial damage NTSB DEN66D0124Accident · No injuriesClosedCessna 180 · Medicine Bow, WYSep 18, 1965 · N3178D · Substantial damage NTSB DEN65F0019Accident · No injuriesClosedCessna 180 · Lander, WYFeb 28, 1965 · N1725C · Substantial damage