Skip to content

NTSB investigations: Continental 0-200 series, WY

23 cases on aircraft whose registry engine model is Continental 0-200 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 ('17020')) 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 ('17020'))
  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 ('17020'))
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 CEN15FA307Accident · 4 fatalField investigationFinal reportCessna T310R · Cody, WYThe pilot's loss of airplane control following the loss of power in the left engine; the reason for the loss of power could not be determined during postaccident engine examination.Jul 18, 2015 · N72TP · Destroyed NTSB WPR11CA327Accident · Minor injuriesData collectionFinal reportCessna 150J · Wheatland, WYThe pilot's inadequate fuel consumption calculations, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's decision to continue flight with known equipment deficiencies.Jul 13, 2011 · N60060 · Substantial damage NTSB DEN03LA146Accident · No injuriesLimited investigationFinal reportCessna 150F · Laramie, WYA partial loss of engine power for undetermined reasons. Contributing factors were the high density altitude, trees, mountainous terrain, and unsuitable terrain on which to make a forced landing.Aug 21, 2003 · N8065F · Substantial damage NTSB SEA94LA233Accident · No injuriesLimited investigationFinal reportCessna 150 · Cheyenne, WYFuel deterioration and/or contamination, and the pilot's decision to operate the airplane with a known problem.Sep 6, 1994 · N1396Q · Substantial damage NTSB DEN89LA044Accident · No injuriesLimited investigationFinal reportCessna 150E · Basin, WYThe private plt attempted a takeoff from his short farm field strip. During the takeoff ground run, the plt realized the acft would not have flying speed and clear the fence at the end of the field. He elected to try to jump the acft over the fence and land…Dec 17, 1988 · N6122T · Substantial damage NTSB DEN84LA176Accident · No injuriesLimited investigationFinal reportCessna 150M · Afton, WYThe plt departed rwy 16 with the intention of repositioning the acft on the arpt after landing. He estimated the surfacewinds were from the southeast at 15 KTS. A witness stated that the winds had changed directions about eight times during the day. The plt…Jun 10, 1984 · N8564U · Substantial damage NTSB DEN84LA154Accident · No injuriesLimited investigationFinal reportCessna 150L · Evanston, WYPlt stated he couldn't make radio contact with the arpt and the wind sock indicated a x-wind so he elected to use rwy 34. The acft bounced during the landing. Plt stated, 'the wind shifted from a x-wind to 140 deg, causing a downwind which caused the plane to…May 23, 1984 · N6730G · Substantial damage NTSB DEN81FTC06Accident · No injuriesClosedCessna 150K · Wright, WYDec 22, 1980 · N6458G · Substantial damage NTSB DEN81FTC04Accident · Minor injuriesClosedCessna 150M · Casper, WYOct 25, 1980 · N345JF · Destroyed NTSB DEN79DTC10Accident · No injuriesClosedCessna 150 · Afton, WYMar 14, 1979 · N6411K · Substantial damage NTSB DEN78FTC09Accident · No injuriesClosedCessna 150K · Gillette, WYDec 14, 1977 · N5844G · Substantial damage NTSB DEN77FTC31Accident · No injuriesClosedCessna 150M · Cheyenne, WYSep 23, 1977 · N704CY · Substantial damage NTSB DEN77FTC30Accident · No injuriesClosedCessna 150 · Bill, WYSep 17, 1977 · N19258 · Substantial damage NTSB DEN76FTC38Accident · Minor injuriesClosedCessna 150L · Rock Springs, WYJul 3, 1976 · N6710G · Substantial damage NTSB DEN76DTC25Accident · No injuriesClosedCessna 150L · Jackson, WYFeb 24, 1976 · N11261 · Substantial damage NTSB DEN72DTC26Accident · Minor injuriesClosedCessna 150L · Hillsdale, WYMay 27, 1972 · N6726G · Substantial damage NTSB DEN71DTC01Accident · No injuriesClosedCessna 150B · Powell, WYMay 15, 1971 · N1134Y · Substantial damage NTSB DEN69D0108Accident · No injuriesClosedCessna 150 · Laramie, WYSep 30, 1968 · N2955J · Substantial damage NTSB DEN68F0233Accident · No injuriesClosedCessna 150 · Cheyenne, WYApr 13, 1968 · N23098 · Substantial damage NTSB DEN68D0163Accident · No injuriesClosedCessna 150 · Gillette, WYDec 5, 1967 · N8183F · Substantial damage NTSB DEN68D0124Accident · Minor injuriesClosedCessna 150 · Casper, WYOct 15, 1967 · N4574U · Substantial damage NTSB DEN66D0010Accident · No injuriesClosedCessna 182 · Mountain View, WYJun 12, 1965 · N8805S · Substantial damage NTSB DEN65D0078Accident · No injuriesClosedCessna 150B · Wheatland, WYMay 10, 1965 · N1134Y · Substantial damage