NTSB investigations: Continental 0-200 series, KS

143 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\" = 'KS' 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 MKC79DCQ17Accident · No injuriesClosedCessna 150 · Benton, KSMar 24, 1979 · N45284 · Substantial damageNTSB MKC79FCG31Accident · No injuriesClosedCessna 150 · Olathe, KSFeb 26, 1979 · N6063T · Substantial damageNTSB MKC79DCQ12Accident · No injuriesClosedCessna 150 · Kinsley, KSJan 21, 1979 · N7271S · Substantial damageNTSB MKC78FCQ36Accident · 1 fatalClosedVari-Eze · Liberal, KSAug 7, 1978 · N36EZ · DestroyedNTSB MKC78DCG20Accident · No injuriesClosedCessna 150M · Lawrence, KSMar 28, 1978 · N704RQ · Substantial damageNTSB MKC78DCQ05Accident · Minor injuriesClosedCessna 150 · Wellington, KSNov 27, 1977 · N704VU · Substantial damageNTSB MKC77DCQ51Accident · No injuriesClosedCessna 150 · Greensburg, KSAug 8, 1977 · N11619 · Substantial damageNTSB MKC77DCQ38Accident · Minor injuriesClosedCessna 150 · Maize, KSMay 29, 1977 · N11550 · Substantial damageNTSB MKC77FCG17Accident · No injuriesClosedCessna 150M · Olathe, KSMar 23, 1977 · N704FX · Substantial damageNTSB MKC77DCQ21Accident · No injuriesClosedCessna 150 · Manhattan, KSMar 7, 1977 · N16014 · Substantial damageNTSB MKC77DCG12Accident · No injuriesClosedCessna 150 · Lyndon, KSJan 30, 1977 · N51206 · Substantial damageNTSB MKC77DCQ11Accident · Minor injuriesClosedCessna 150 · Emporia, KSDec 25, 1976 · N6306K · Substantial damageNTSB MKC76DCH01Accident · No injuriesClosedCessna 150 · Kansas City, KSSep 29, 1976 · N8013S · Substantial damageNTSB MKC76DCQ72Accident · No injuriesClosedCessna 150 · Clyde, KSAug 7, 1976 · N19443 · Substantial damageNTSB MKC76DCQ74Accident · No injuriesClosedCessna 150 · Clay Center, KSAug 6, 1976 · N7053S · Substantial damageNTSB MKC76DCQ68Accident · No injuriesClosedCessna 150 · Flush, KSAug 1, 1976 · N19380 · Substantial damageNTSB MKC76DCQ64Accident · No injuriesClosedCessna 150G · Oxford, KSJul 5, 1976 · N3221J · Substantial damageNTSB MKC76DCQ60Accident · No injuriesClosedCessna 150 · Colby, KSJun 9, 1976 · N16025 · Substantial damageNTSB MKC76FCQ54Accident · No injuriesClosedCessna A150M · Wichita, KSMay 28, 1976 · N9842J · Substantial damageNTSB MKC76DCG68Accident · No injuriesClosedCessna 150 · Garnett, KSApr 3, 1976 · N3658J · Substantial damageNTSB MKC76DCG57Accident · No injuriesClosedCessna 150L · Lawrence, KSMar 16, 1976 · N6095J · Substantial damageNTSB MKC76DCQ15Accident · No injuriesClosedCessna 150 · Council Grove, KSSep 7, 1975 · N6095J · Substantial damageNTSB MKC76DCQ10Accident · No injuriesClosedBaby Ace Corbin · Tennis, KSAug 17, 1975 · N8RM · Substantial damageNTSB MKC75DCG45Accident · Minor injuriesClosedCessna 150 · Meriden, KSMay 18, 1975 · N6644S · Substantial damageNTSB MKC75FCQ38Accident · No injuriesClosedCessna 150 · Pratt, KSMar 20, 1975 · N11139 · Substantial damageNTSB MKC75DCG20Accident · No injuriesClosedCessna 150 · Olathe, KSNov 24, 1974 · N6420F · Substantial damageNTSB MKC74AK040Accident · 2 fatalClosedCessna 150J · Pittsburg, KSJan 25, 1974 · N60544 · DestroyedNTSB MKC74DCG19Accident · No injuriesClosedCessna 150 · Lawrence, KSJan 16, 1974 · N6095J · Substantial damageNTSB MKC74DCG16Accident · No injuriesClosedCessna 150L · Pleasanton, KSDec 18, 1973 · N18640 · Substantial damageNTSB MKC74DCQ02Accident · No injuriesClosedCessna 150 · Ashland, KSAug 1, 1973 · N60051 · Substantial damageNTSB MKC73DCQ21Accident · Minor injuriesClosedCessna 150J · Derby, KSOct 29, 1972 · N61140 · Substantial damageNTSB MKC73DCQ16Accident · No injuriesClosedCessna 150D · Great Bend, KSOct 3, 1972 · N4477U · Substantial damageNTSB MKC73FCQ05Accident · No injuriesClosedCessna A150K · Oakley, KSJul 16, 1972 · N5915J · Substantial damageNTSB MKC73FCQ10Accident · No injuriesClosedCessna 150 · Augusta, KSJun 24, 1972 · N6458G · Substantial damageNTSB MKC72DCQ60Accident · Serious injuriesClosedCessna 150 · Phillipsburg, KSJun 16, 1972 · N4673X · Minor damageNTSB MKC72FCQ52Accident · Minor injuriesClosedCessna 150L · Augusta, KSMay 13, 1972 · N1662Q · Substantial damageNTSB MKC72DCQ53Accident · Minor injuriesClosedCessna 150 · Mcpherson, KSMay 13, 1972 · N3954U · Substantial damageNTSB MKC72DCQ37Accident · No injuriesClosedCessna 150L · Clay Center, KSDec 16, 1971 · N1248Q · Substantial damageNTSB MKC72DCQ23Accident · No injuriesClosedCessna 150 · Med Lodge, KSAug 30, 1971 · N3915U · Substantial damageNTSB MKC72DC014Accident · No injuriesClosedCessna 150 · Stafford, KSJul 12, 1971 · N3915U · Substantial damageNTSB MKC71DCG65Accident · No injuriesClosedCessna 150H · Stillwell, KSMay 6, 1971 · N7132S · Substantial damageNTSB MKC71AK012Accident · 2 fatalClosedCessna 150G · Stanley, KSSep 6, 1970 · N3627J · DestroyedNTSB MKC71DCQ03Accident · No injuriesClosedCessna 150 · Dodge City, KSJul 14, 1970 · N60246 · Substantial damageNTSB MKC70DCG29Accident · No injuriesClosedCessna 150 · Eudora, KSMay 23, 1970 · N6484F · Substantial damageNTSB MKC70DCG23Accident · No injuriesClosedCessna 150 · Gardner, KSApr 23, 1970 · N22900 · Substantial damageNTSB MKC70DCQ18Accident · No injuriesClosedCessna 150H · Goodland, KSApr 16, 1970 · N23305 · 2 aircraft · Substantial damageNTSB MKC70DCG13Accident · No injuriesClosedCessna 150 · Atchison, KSMar 8, 1970 · N6012T · Substantial damageNTSB MKC70F0304Accident · Minor injuriesClosedCessna 150 · Leawood, KSOct 21, 1969 · N4070U · Substantial damageNTSB MKC70D0001Accident · Minor injuriesClosedCessna 150 · Ottawa, KSMay 25, 1969 · N3791J · Substantial damageNTSB MKC69D0367Accident · No injuriesClosedCessna 150J · Johnson, KSMar 31, 1969 · N51024 · Substantial damage