NTSB investigations: Continental 0-200 series, OK

126 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.

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\" = 'OK' 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.

NTSB FTW82DA186Accident · No injuriesFinal reportCessna 150 · Knowles, OKDuring a cross country flight the student pilot elected to land in a pasture near his home. On takeoff the aircraft collided with a fence resulting in substantial damage to the aircraft. The pilot returned to the pasture and landed without further incident.…May 15, 1982 · N50994 · Substantial damageNTSB FTW82FPJ02Accident · Serious injuriesClosedCessna 150 · Asher, OKOct 26, 1981 · N2762S · DestroyedNTSB FTW81FPJ27Accident · Minor injuriesClosedCessna 150 · Guthrie, OKJun 10, 1981 · N8070S · DestroyedNTSB FTW81FPJ20Accident · Minor injuriesClosedCessna 150 · Dover, OKApr 19, 1981 · N23005 · Substantial damageNTSB FTW80FPJ32Accident · No injuriesClosedCessna 150G · Norman, OKAug 21, 1980 · N3661J · Substantial damageNTSB FTW79FPM10Accident · No injuriesClosedCessna 150 · Vinita, OKJun 10, 1979 · N50254 · Substantial damageNTSB FTW78DPJ38Accident · No injuriesClosedCessna 150 · Tuttle, OKSep 14, 1978 · N66482 · Substantial damageNTSB FTW78FPM18Accident · No injuriesClosedCessna 150 · Tulsa, OKJun 25, 1978 · N66707 · Substantial damageNTSB FTW78FPM12Accident · No injuriesClosedCessna 150 · Owasso, OKMay 28, 1978 · N7212S · Substantial damageNTSB FTW78DPM02Accident · No injuriesClosedCessna 150 · Claremore, OKDec 22, 1977 · N9141U · Substantial damageNTSB FTW77FPM21Accident · Minor injuriesClosedCessna 150 · Tulsa, OKSep 4, 1977 · N6686F · Substantial damageNTSB FTW77FPM17Accident · No injuriesClosedCessna 150 · Tulsa, OKAug 2, 1977 · N6341K · Substantial damageNTSB FTW77DPJ32Accident · No injuriesClosedCessna 150 · Olustee, OKJul 24, 1977 · N66636 · Substantial damageNTSB FTW77FPM09Accident · No injuriesClosedCessna 150M · Tulsa, OKMay 7, 1977 · N9103U · Substantial damageNTSB FTW77DPJ06Accident · No injuriesClosedCessna 150 · Medford, OKFeb 5, 1977 · N7303G · Substantial damageNTSB FTW76FPM31Accident · No injuriesClosedCessna 150 · Yanush, OKSep 24, 1976 · N6626T · Substantial damageNTSB FTW76DPM25Accident · Serious injuriesClosedCessna 150 · Chelsea, OKJun 3, 1976 · N3579L · No damageNTSB FTW76DPJ35Accident · No injuriesClosedCessna 150 · Clinton, OKMay 28, 1976 · N8054F · Substantial damageNTSB FTW76DPJ17Accident · No injuriesClosedTaylorcraft 19 · Oklahoma City, OKDec 14, 1975 · N3551T · Substantial damageNTSB FTW75FPM19Accident · No injuriesClosedCessna 150F · Kansas, OKJun 21, 1975 · N3028X · Substantial damageNTSB FTW75DPM11Accident · No injuriesClosedCessna 150 · Stilwell, OKDec 2, 1974 · N51408 · Substantial damageNTSB FTW75FPM02Accident · No injuriesClosedCessna 150L · Kiefer, OKAug 24, 1974 · N19030 · Substantial damageNTSB FTW74FPM16Accident · No injuriesClosedCessna 150K · Sand Springs, OKDec 26, 1973 · N6032G · No damageNTSB FTW74DPM13Accident · No injuriesClosedCessna 150 · Tulsa, OKDec 15, 1973 · N18124 · 2 aircraft · DestroyedNTSB FTW74DPM04Accident · No injuriesClosedCessna 150E · Warner, OKAug 4, 1973 · N6251T · Substantial damageNTSB FTW73FPJ21Accident · No injuriesClosedCessna 150L · Yukon, OKMay 29, 1973 · N19200 · Substantial damageNTSB FTW72FPM17Accident · Minor injuriesClosedCessna 150 · Kiefer, OKJan 26, 1972 · N5788G · Substantial damageNTSB FTW72FPJ25Accident · Serious injuriesClosedCessna 150 · Mangum, OKDec 11, 1971 · N7025F · DestroyedNTSB FTW72DPJ07Accident · Minor injuriesClosedCessna 150H · Okene, OKJul 31, 1971 · N6762S · Substantial damageNTSB FTW72DPJ01Accident · Minor injuriesClosedCessna 150L · Yukon, OKJul 3, 1971 · N6938G · Substantial damageNTSB FTW71FPJ34Accident · Minor injuriesClosedCessna 150K · Bethany, OKMar 25, 1971 · N6495G · Substantial damageNTSB FTW71FPJ29Accident · Minor injuriesClosedCessna 150K · Mustang, OKMar 5, 1971 · N5798G · Substantial damageNTSB FTW71DPJ28Incident · No injuriesClosedCessna 150 · Woodward, OKFeb 23, 1971 · N7126F · Minor damageNTSB FTW71DPJ26Accident · No injuriesClosedCessna 150 · East Jesse, OKJan 11, 1971 · N8284S · Substantial damageNTSB FTW71FPJ24Accident · No injuriesClosedCessna 150 · Wellston, OKDec 30, 1970 · N8449J · DestroyedNTSB FTW71DPJ16Accident · No injuriesClosedCessna 150 · Chattanooga, OKSep 15, 1970 · N50933 · Substantial damageNTSB FTW70DPM04Accident · No injuriesClosedCessna 150F · Dewey, OKApr 19, 1970 · N8645S · Substantial damageNTSB FTW70DPJ04Accident · No injuriesClosedCessna 150 · Lawton, OKFeb 5, 1970 · N8051S · Substantial damageNTSB FTW70AF049Accident · No injuriesClosedPiper PA-23 · Tulsa, OKJan 23, 1970 · N6847Y · 2 aircraft · Substantial damageNTSB FTW70F0286Accident · Serious injuriesClosedCessna 150 · Purcell, OKOct 31, 1969 · N22975 · DestroyedNTSB FTW70D0172Accident · No injuriesClosedCessna 150G · Jenks, OKAug 26, 1969 · N3183J · Substantial damageNTSB FTW70F0165Accident · No injuriesClosedCessna 150 · Norman, OKAug 20, 1969 · N51374 · Substantial damageNTSB FTW70D0007Accident · No injuriesClosedCessna 150 · Leon, OKMay 31, 1969 · N6184T · Substantial damageNTSB FTW69D0545Accident · No injuriesClosedCessna 150 · Ardmore, OKMay 30, 1969 · N6264S · Substantial damageNTSB FTW69D0214Accident · No injuriesClosedCessna 150F · Hobart, OKOct 6, 1968 · N7709F · Substantial damageNTSB FTW69D0218Accident · No injuriesClosedChampion 7EC · Enid, OKSep 29, 1968 · N11026 · Substantial damageNTSB FTW69D0212Accident · No injuriesClosedCessna 150 · Altus, OKSep 25, 1968 · N6566F · Substantial damageNTSB FTW69D0188Accident · No injuriesClosedCessna 150 · Norman, OKSep 25, 1968 · N23149 · Substantial damageNTSB FTW69D0168Accident · No injuriesClosedCessna 150 · Thomas, OKAug 26, 1968 · N7140F · Substantial damageNTSB FTW69F0124Accident · No injuriesClosedCessna 150 · Beaver, OKJul 19, 1968 · N3698J · Substantial damage