NTSB investigations: Continental O-470 series, KS

115 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\" = '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 ('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 MKC76FCG31Accident · Serious injuriesClosedCessna 180 · Edgerton, KSNov 2, 1975 · N41CH · Substantial damageNTSB MKC76FCG07Accident · Minor injuriesClosedBeech D45 · Olathe, KSJul 14, 1975 · N13616 · Substantial damageNTSB MKC75DCQ48Accident · No injuriesClosedCessna 188 · Selden, KSMay 13, 1975 · N5642J · Substantial damageNTSB MKC75DCQ42Accident · No injuriesClosedCessna 182 · Elkhart, KSApr 15, 1975 · N8653T · Substantial damageNTSB MKC75DC001Accident · No injuriesClosedCessna 180 · Wichita, KSJul 6, 1974 · N2204C · Substantial damageNTSB MKC73DCQ38Accident · No injuriesClosedCessna 188 · North Fowler, KSJun 27, 1973 · N9899V · Substantial damageNTSB MKC73DCQ32Accident · No injuriesClosedCessna 182A · Yates Center, KSMay 22, 1973 · N4817D · Substantial damageNTSB MKC73FCQ34Accident · No injuriesClosedCessna 182L · Scandia, KSMay 20, 1973 · N3182R · Substantial damageNTSB MKC73DCQ04Accident · No injuriesClosedCessna 180 · Newton, KSJul 9, 1972 · N2204C · Substantial damageNTSB MKC73FCO02Accident · No injuriesClosedBeech H35 · Newton, KSJul 7, 1972 · N5025B · Substantial damageNTSB MKC73DCQ01Accident · No injuriesClosedCessna 182M · Wichita, KSJul 6, 1972 · N91621 · Substantial damageNTSB MKC72DCQ63Accident · Minor injuriesClosedCessna 182 · Russell, KSJun 30, 1972 · N9364X · Substantial damageNTSB MKC72DCQ38Accident · No injuriesClosedCessna 182L · Wichita, KSFeb 5, 1972 · N3440R · Substantial damageNTSB MKC72FCQ34Accident · No injuriesClosedCessna 180 · Valley Cntr, KSNov 14, 1971 · N2204C · Substantial damageNTSB MKC72FCQ32Accident · No injuriesClosedCessna 182N · Wichita, KSNov 10, 1971 · N8964G · Substantial damageNTSB MKC72FCQ24Accident · No injuriesClosedCessna 182J · Arkansas Cty, KSSep 4, 1971 · N3596F · Substantial damageNTSB MKC71DCG52Accident · Minor injuriesClosedCessna 182 · Olathe, KSApr 2, 1971 · N2760F · Substantial damageNTSB MKC71FCQ31Accident · No injuriesClosedCessna 180 · Longton, KSFeb 14, 1971 · N9102C · Substantial damageNTSB MKC71DCQ24Accident · No injuriesClosedCessna 182M · Manhattan, KSDec 3, 1970 · N70697 · Substantial damageNTSB MKC71FCG34Accident · No injuriesClosedCessna 310 · Lawrence, KSNov 25, 1970 · N790S · Substantial damageNTSB MKC71DCQ21Accident · No injuriesClosedCessna 180 · Sharon Sprgs, KSOct 22, 1970 · N1596C · Substantial damageNTSB MKC71FCG04Accident · No injuriesClosedCessna 182 · Kansas City, KSJul 14, 1970 · N2007X · Substantial damageNTSB MKC70FCQ20Accident · No injuriesClosedCessna 180B · Syracuse, KSMay 3, 1970 · N5080E · Substantial damageNTSB MKC70DCQ17Accident · No injuriesClosedCessna 182M · Wichita, KSApr 9, 1970 · N70697 · Substantial damageNTSB MKC70DCG16Accident · No injuriesClosedCessna 182 · Topeka, KSMar 25, 1970 · N8468T · DestroyedNTSB MKC70D0268Accident · No injuriesClosedCessna 182 · Topeka, KSNov 12, 1969 · N42887 · Substantial damageNTSB MKC70D0115Accident · No injuriesClosedCessna 182 · Leawood, KSJul 9, 1969 · N42349 · Substantial damageNTSB MKC69D0449Accident · No injuriesClosedCessna 182K · Augusta, KSMay 12, 1969 · N3103F · Substantial damageNTSB MKC69D0411Accident · No injuriesClosedCessna 182M · Wichita, KSMay 2, 1969 · N70697 · Substantial damageNTSB MKC69F0356Accident · Minor injuriesClosedCessna 210 · Augusta, KSMar 21, 1969 · N9429T · Substantial damageNTSB MKC69D0430Accident · No injuriesClosedCessna 182B · Bonner Sprgs, KSMar 20, 1969 · N2517G · Substantial damageNTSB MKC69D0259Accident · No injuriesClosedCessna 182L · Garden City, KSNov 10, 1968 · N42105 · Substantial damageNTSB MKC69A0015Accident · 2 fatalClosedCessna 182B · Olathe, KSSep 24, 1968 · N2316G · DestroyedNTSB MKC69D0181Accident · No injuriesClosedCessna 182 · Pratt, KSSep 2, 1968 · N2811F · Substantial damageNTSB MKC69D0109Accident · No injuriesClosedCessna 188 · Ulysses, KSAug 2, 1968 · N8086V · Substantial damageNTSB MKC69D0055Accident · No injuriesClosedCessna 182 · Leawood, KSJun 15, 1968 · N2659G · Substantial damageNTSB MKC68D0502Accident · No injuriesClosedBellanca 14-192 · Moscow, KSMar 25, 1968 · N7601E · Substantial damageNTSB MKC68F0450Accident · No injuriesClosedCessna 182J · Kansas City, KSJan 24, 1968 · N2905F · Substantial damageNTSB MKC68F0324Accident · No injuriesClosedCessna 182K · Augusta, KSNov 18, 1967 · N3103F · Substantial damageNTSB MKC68D0381Accident · No injuriesClosedCessna 182 · Bonner Sprgs, KSOct 11, 1967 · N2613Q · Substantial damageNTSB MKC68A0017Accident · 2 fatalClosedCessna 182D · Grenola, KSSep 2, 1967 · N9096X · DestroyedNTSB MKC68D0198Accident · No injuriesClosedCessna 182H · Hammond, KSAug 19, 1967 · N2434X · Substantial damageNTSB MKC67A0089Accident · 1 fatalClosedCessna 188 · Sharon Sprgs, KSJun 27, 1967 · N5513S · DestroyedNTSB MKC67D0517Accident · No injuriesClosedBellanca 14-19 · Liberal, KSMar 10, 1967 · N7672B · Substantial damageNTSB MKC67D0495Accident · No injuriesClosedCessna 182A · Kinsley, KSMar 6, 1967 · N6127B · Substantial damageNTSB MKC67F0448Accident · No injuriesClosedCessna 182 · Norton, KSFeb 18, 1967 · N3352F · Substantial damageNTSB MKC67D0371Accident · No injuriesClosedCessna 310D · Olathe, KSDec 28, 1966 · N3699D · Substantial damageNTSB MKC67D0317Accident · No injuriesClosedCessna 180 · Basehor, KSNov 26, 1966 · N5274D · Substantial damageNTSB MKC67D0222Accident · No injuriesClosedCessna 182 · Leawood, KSJul 31, 1966 · N3187Y · Substantial damageNTSB MKC67D0089Accident · No injuriesClosedCessna 182 · Larned, KSJun 8, 1966 · N3779U · Substantial damage