Skip to content

NTSB investigations: Cessna 170B, WY

20 cases on aircraft the registry lists as Cessna 170B. 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

19642026

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 ('2072306', '2072307')) 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 ('2072306', '2072307'))
  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 ('2072306', '2072307'))
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 WPR13CA282Accident · No injuriesData collectionFinal reportCessna 170B · Rawlins, WYThe pilot’s delayed decision to abort the takeoff. Contributing to the accident was the pilot's inadequate preflight planning and a high density altitude, which resulted in a runway excursion and collision with terrain.Jun 23, 2013 · N170CW · Substantial damage NTSB DEN02LA047Accident · No injuriesLimited investigationFinal reportCessna 170B · Rock Springs, WYthe pilot's failure to maintain aircraft control during initial takeoff climb. A contributing factor was the gusty crosswind.May 30, 2002 · N4559C · Substantial damage NTSB DEN00LA087Accident · No injuriesLimited investigationFinal reportCessna 170B · Bedford, WYThe pilot's inadvertent ground loop. A factor was the soft grass airstrip.May 13, 2000 · N8319A · Substantial damage NTSB DEN99LA134Accident · No injuriesLimited investigationFinal reportCessna 170B · Casper, WYThe pilot's selection of a wrong runway for landing and his failure to maintain directional control.Aug 4, 1999 · N4448B · Substantial damage NTSB SEA97LA160Accident · No injuriesLimited investigationFinal reportCessna 170B · Jackson, WYThe pilot's inadequate compensation for wind conditions. Gusting wind conditions was a factor.Jul 6, 1997 · N211R · Substantial damage NTSB SEA95LA150Accident · No injuriesLimited investigationFinal reportCessna 170B · Afton, WYDirectional control was not maintained. Factors to the accident were: inadequate remedial action and a stall not identified.Jul 17, 1995 · N3165B · Substantial damage NTSB DEN83LA075Accident · No injuriesLimited investigationFinal reportCessna 170B · Douglas, WYThe plt had recently purchased the plane & had only 6 hrs of flt time in tailwheel equipped acft. He reported that during a landing, the acft bounced once, then touched down just left of the center of the rwy. He stated that the acft veered left, then he…Mar 10, 1983 · N2280D · Substantial damage NTSB DEN83LA068Accident · No injuriesLimited investigationFinal reportCessna 170B · Buffalo, WYThe acfts main left gear collapsed during a groundloop on landing. The pilot stated that his approach to landing was normal but after touchdown the acft veered to the right. He said the wind was not a factor. The pilot gave a federal inspector the impression…Feb 26, 1983 · N1896C · Substantial damage NTSB DEN81DTC10Accident · No injuriesClosedCessna 170B · Buffalo, WYFeb 14, 1981 · N1896C · Substantial damage NTSB DEN78DTC28Accident · No injuriesClosedCessna 170B · Rock Springs, WYJun 28, 1978 · N2619D · Substantial damage NTSB DEN75DTC06Accident · No injuriesClosedCessna 170 · Gillette, WYAug 14, 1974 · N2618D · Substantial damage NTSB DEN73DTC12Accident · No injuriesClosedCessna 170B · Hanna, WYNov 1, 1972 · N7681 · Substantial damage NTSB DEN73AD013Accident · 1 fatalClosedCessna 170A · Midwest, WYSep 25, 1972 · N1253D · Destroyed NTSB DEN72FTC12Accident · Serious injuriesClosedCessna 170B · Sheridan, WYOct 14, 1971 · N4569C · Destroyed NTSB DEN70DXA12Accident · No injuriesClosedCessna 170 · Rawlins, WYMay 24, 1970 · N8074A · Substantial damage NTSB DEN68F0269Accident · Serious injuriesClosedCessna 170B · Cheyenne, WYApr 28, 1968 · N4660C · Substantial damage NTSB DEN68D0205Accident · No injuriesClosedCessna 170 · Medicine Bow, WYJan 27, 1968 · N2742D · Substantial damage NTSB DEN67D0236Accident · No injuriesClosedCessna 172B · Powell, WYMar 26, 1967 · N8222A · Substantial damage NTSB DEN65D0089Accident · No injuriesClosedCessna 170 · Douglas, WYMay 9, 1965 · N3475D · Substantial damage NTSB UNK64X2726Accident · No injuriesClosedCessna 170B · Wheatland, WYJul 9, 1964 · N3524C · Substantial damage