Skip to content

NTSB investigations: Continental C145 series, WY

13 cases on aircraft whose registry engine model is Continental C145 series. 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.engine_model_code IN ('17012')) 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.engine_model_code IN ('17012'))
  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.engine_model_code IN ('17012'))
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 WPR22LA200Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170 · Wheatland, WYThe pilot’s improper landing flare which, resulted in a bounced landing and subsequent nose over.Jun 6, 2022 · N4067V · Substantial damage NTSB GAA17CA141Accident · No injuriesData collectionFinal reportCessna 170 · Wheatland, WYThe flight instructor’s incorrect compensation for the gusting crosswind during the landing roll, which resulted in a loss of directional control and runway excursion.Feb 13, 2017 · N1421D · Substantial damage 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 DEN02FA043Accident · 1 fatalField investigationFinal reportCessna 170A · Casper, WYthe pilot's inadvertent flight into adverse weather conditions and his subsequent failure to maintain aircraft control. A factor contributing to this accident was the fog.May 17, 2002 · N1211D · Destroyed 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 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 DEN70DXA12Accident · No injuriesClosedCessna 170 · Rawlins, WYMay 24, 1970 · N8074A · Substantial damage NTSB DEN65F0070Accident · No injuriesClosedSwift GC-1B · Rawlins, WYMay 16, 1965 · N80883 · Substantial damage