NTSB investigations: Continental O-470 series, WY

92 cases on aircraft whose registry engine model is Continental O-470 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.

Cases, newest first

Query with SQL
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 ('17026'))
  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.

NTSB DEN76DTC40Accident · No injuriesClosedCessna 182 · Cheyenne, WYJun 27, 1976 · N9445M · Substantial damageNTSB DEN76DTC10Accident · No injuriesClosedCessna 180 · Wheatland, WYAug 6, 1975 · N3657C · Substantial damageNTSB DEN75FTC25Accident · No injuriesClosedCessna 182K · Casper, WYMay 24, 1975 · N3100R · Substantial damageNTSB DEN75FTC16Accident · No injuriesClosedCessna 180H · Gillette, WYMar 15, 1975 · N9068M · Substantial damageNTSB DEN75FTC12Accident · Minor injuriesClosedCessna 182 · Gillette, WYDec 16, 1974 · N3087Q · Substantial damageNTSB DEN74DTC34Accident · No injuriesClosedCessna 182J · Wheatland, WYMay 18, 1974 · N3155F · Substantial damageNTSB DEN74DTC28Accident · No injuriesClosedCessna 182L · Cheyenne, WYMar 2, 1974 · N3439R · Substantial damageNTSB DEN74FTC11Accident · Minor injuriesClosedCessna 411 · Farson, WYAug 26, 1973 · N100MM · Substantial damageNTSB DEN73FTC27Accident · No injuriesClosedCessna 180 · Kemmerer, WYJun 12, 1973 · N3657C · Substantial damageNTSB DEN73DTC22Accident · No injuriesClosedCessna 180A · Glendo, WYMar 18, 1973 · N5220D · Substantial damageNTSB DEN73DTC17Accident · No injuriesClosedCessna 180 · Gillette, WYJan 21, 1973 · N3178D · Substantial damageNTSB DEN73DTC10Accident · No injuriesClosedCessna 180B · Glendo, WYOct 11, 1972 · N9122T · Substantial damageNTSB DEN73AD007Accident · 3 fatalClosedCessna 180 · Casper, WYAug 18, 1972 · N3354D · DestroyedNTSB DEN72DTC06Accident · No injuriesClosedCessna 182C · Lusk, WYSep 9, 1971 · N8672T · Substantial damageNTSB DEN72DTC01Accident · No injuriesClosedCessna 182E · Gillette, WYJul 1, 1971 · N9364X · Substantial damageNTSB DEN71DXA07Accident · No injuriesClosedCessna 180 · Cody, WYAug 24, 1970 · N4773B · Substantial damageNTSB DEN70DXA09Accident · No injuriesClosedCessna 182 · Laramie, WYApr 15, 1970 · N2076X · Substantial damageNTSB DEN70D0047Accident · No injuriesClosedCessna 182 · Cody, WYAug 6, 1969 · N3483R · Substantial damageNTSB DEN70F0077Accident · No injuriesClosedCessna 180 · Casper, WYJul 24, 1969 · N134H · Substantial damageNTSB DEN70D0028Accident · No injuriesClosedCessna 182 · Lusk, WYJun 25, 1969 · N8672T · Substantial damageNTSB DEN69D0239Accident · No injuriesClosedCessna 180H · Riverton, WYApr 24, 1969 · N91299 · Substantial damageNTSB DEN69D0201Accident · No injuriesClosedCessna 182C · Casper, WYMar 26, 1969 · N8561T · Substantial damageNTSB DEN69D0120Accident · No injuriesClosedCessna 182 · Casper, WYAug 15, 1968 · N9993T · Substantial damageNTSB DEN68D0164Accident · No injuriesClosedCessna 180 · Casper, WYDec 9, 1967 · N3178D · Substantial damageNTSB DEN68D0064Accident · No injuriesClosedCessna 182 · Riverton, WYAug 18, 1967 · N8619T · Substantial damageNTSB DEN68F0080Accident · No injuriesClosedCessna 180 · Lander, WYAug 13, 1967 · N9122T · Substantial damageNTSB DEN68D0031Accident · No injuriesClosedCessna 180 · Moorcroft, WYJul 10, 1967 · N3335D · Substantial damageNTSB DEN67D0248Accident · No injuriesClosedCessna 182C · Lander, WYApr 5, 1967 · N8941T · Substantial damageNTSB DEN67D0154Accident · No injuriesClosedCessna 182 · Rock River, WYOct 11, 1966 · N3579F · Substantial damageNTSB DEN67D0096Accident · No injuriesClosedCessna 180 · Kemmerer, WYAug 28, 1966 · N3642C · Substantial damageNTSB DEN66D0307Accident · No injuriesClosedCessna 182 · Big Piney, WYApr 30, 1966 · N5047D · Substantial damageNTSB DEN66F0213Accident · No injuriesClosedCessna 180 · Rock Springs, WYJan 25, 1966 · N6570A · Substantial damageNTSB DEN66D0191Accident · No injuriesClosedCessna 182 · Frannie, WYNov 12, 1965 · N3494S · Substantial damageNTSB DEN66F0125Accident · Minor injuriesClosedCessna 182C · Laramie, WYOct 15, 1965 · N8554T · Substantial damageNTSB DEN66D0126Accident · Minor injuriesClosedBellanca 14-19 · Douglas, WYOct 10, 1965 · N7688B · Substantial damageNTSB DEN66D0124Accident · No injuriesClosedCessna 180 · Medicine Bow, WYSep 18, 1965 · N3178D · Substantial damageNTSB DEN65D0087Accident · No injuriesClosedCessna 182 · Pine Bluffs, WYApr 11, 1965 · N3187Y · Substantial damageNTSB DEN65F0019Accident · No injuriesClosedCessna 180 · Lander, WYFeb 28, 1965 · N1725C · Substantial damageNTSB UNK64X3225Accident · No injuriesClosedCessna 182A · Rock Springs, WYAug 5, 1964 · N6154B · Substantial damageNTSB UNK64X0903Accident · No injuriesClosedCessna 180 · Cheyenne, WYMar 13, 1964 · N2134Z · Substantial damageNTSB UNK64X0451Accident · No injuriesClosedCessna 310B · Casper, WYFeb 3, 1964 · N364CA · Substantial damageNTSB UNK64X0213Accident · 1 fatalClosedCessna 182F · Thernopolis, WYJan 11, 1964 · N3343U · Destroyed