NTSB investigations: Continental C145 series, CA

118 cases on aircraft whose registry engine model is Continental C145 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\" = 'CA' 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 ('17012'))
  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 OAK78DVD11Accident · No injuriesClosedCessna 170B · Willits, CANov 23, 1977 · N1805C · Substantial damageNTSB OAK77DVD23Accident · No injuriesClosedCessna 170A · Oakland, CAMar 19, 1977 · N4041V · Substantial damageNTSB LAX77FUD02Accident · No injuriesClosedCessna 170B · Compton, CAJan 16, 1977 · N2717C · Substantial damageNTSB LAX77FQU10Accident · No injuriesClosedGlobe GC-1B · Pearblossom, CANov 21, 1976 · N3785K · Substantial damageNTSB LAX76FUG65Accident · No injuriesClosedCessna 170B · Upland, CAJun 27, 1976 · N2323D · Substantial damageNTSB OAK76FVG45Accident · No injuriesClosedCessna 170 · Cordelia, CAFeb 2, 1976 · N4245V · Substantial damageNTSB OAK76DVD16Accident · Minor injuriesClosedCessna 170 · Tamales, CANov 28, 1975 · N3159A · DestroyedNTSB OAK76DVG29Accident · No injuriesClosedCessna 170 · San Andreas, CAOct 9, 1975 · N3832V · Substantial damageNTSB OAK75DVM33Accident · No injuriesClosedCessna 170 · San Jose, CAJun 14, 1975 · N2524V · Substantial damageNTSB OAK75DVD23Accident · No injuriesClosedCessna 170 · Garberville, CANov 5, 1974 · N3942V · Substantial damageNTSB OAK74DVG69Accident · No injuriesClosedCessna 170A · Redding, CAJul 13, 1974 · N1700D · DestroyedNTSB OAK74DVA79Accident · No injuriesClosedCessna 170B · Auberry, CAJun 25, 1974 · N2329D · Substantial damageNTSB LAX74DVA40Accident · No injuriesClosedCessna 170A · Kennedy Mds, CAJan 12, 1974 · N9781A · Substantial damageNTSB OAK74DVM17Accident · No injuriesClosedCessna 170B · Paso Robles, CAJan 1, 1974 · N2326D · Substantial damageNTSB OAK74DVD11Accident · No injuriesClosedCessna 170A · Ukiah, CASep 2, 1973 · N1490D · Substantial damageNTSB OAK74AP008Accident · 2 fatalClosedCessna 170B · Mammoth Lks, CAAug 26, 1973 · N8015A · DestroyedNTSB LAX73DUG46Accident · Serious injuriesClosedCessna 170A · Apple Vally, CAApr 7, 1973 · N9297A · Substantial damageNTSB LAX73FUQ26Accident · No injuriesClosedCessna 170B · Santa Paula, CAApr 5, 1973 · N2710D · Substantial damageNTSB OAK73DVD20Accident · No injuriesClosedCessna 170B · Hayward, CAOct 28, 1972 · N3068A · Substantial damageNTSB LAX73DUM04Accident · No injuriesClosedCessna 170A · Calexico, CASep 4, 1972 · N9521A · Substantial damageNTSB OAK73FVG12Accident · No injuriesClosedCessna 170B · Sacramento, CAAug 23, 1972 · N2268D · Substantial damageNTSB OAK73DVD12Accident · Minor injuriesClosedCessna 170B · Livermore, CAJul 13, 1972 · N4680C · Substantial damageNTSB LAX72FUA34Accident · Minor injuriesClosedCessna 170B · Torrance, CAFeb 11, 1972 · N2336D · Substantial damageNTSB LAX72FUG52Accident · Minor injuriesClosedCessna 170 · Chino, CAJan 30, 1972 · N4025V · Substantial damageNTSB LAX72FUA33Accident · No injuriesClosedGlobe GC-1B · S.J.Cpstrno, CAJan 30, 1972 · N3269K · Substantial damageNTSB LAX72FUQ37Accident · No injuriesClosedCessna 170B · Quartz Hill, CAOct 23, 1971 · N2807C · Substantial damageNTSB OAK72DVD14Accident · No injuriesClosedCessna 170 · Santa Rosa, CASep 19, 1971 · N2491D · Substantial damageNTSB OAK72DVG23Accident · No injuriesClosedCessna 170B · Grass Vally, CASep 4, 1971 · N8022A · Substantial damageNTSB LAX71FUA57Accident · No injuriesClosedCessna 170A · Long Beach, CAApr 26, 1971 · N1748D · Substantial damageNTSB LAX71DUA09Accident · No injuriesClosedCessna 170B · Fullerton, CAJul 12, 1970 · N3022A · Substantial damageNTSB LAX70DUA18Accident · No injuriesClosedCessna 170B · Sj Capstrno, CAApr 3, 1970 · N2565C · Substantial damageNTSB LAX70DUM04Accident · No injuriesClosedCessna 170A · Calexico, CAJan 31, 1970 · N9781A · Substantial damageNTSB OAK70D0189Accident · No injuriesClosedCessna 170 · Concord, CADec 6, 1969 · N2670V · Substantial damageNTSB LAX69D0358Accident · No injuriesClosedCessna 170A · Oxnard, CAMay 18, 1969 · N1744D · Substantial damageNTSB OAK69D0137Accident · Minor injuriesClosedCessna 170B · Tahoe Valley, CASep 22, 1968 · N2502C · Substantial damageNTSB OAK69D0093Accident · No injuriesClosedCessna 170 · Vacaville, CAAug 18, 1968 · N3944V · Substantial damageNTSB OAK69D0068Accident · No injuriesClosedCessna 170 · Chico, CAJun 19, 1968 · N2713D · Substantial damageNTSB OAK69D0012Accident · No injuriesClosedCessna 170 · Morgan Hill, CAMay 26, 1968 · N9240A · Substantial damageNTSB OAK68D0343Accident · No injuriesClosedCessna 170B · Stratford, CAMar 28, 1968 · N170X · Substantial damageNTSB LAX68D0345Accident · No injuriesClosedCessna 170 · Lakeside, CAFeb 25, 1968 · N9268A · Substantial damageNTSB OAK68F0288Accident · Minor injuriesClosedCessna 170 · Lodi, CADec 30, 1967 · N4422V · Substantial damageNTSB OAK68D0262Accident · No injuriesClosedCessna 170A · Morgan Hill, CADec 30, 1967 · N9240A · Substantial damageNTSB LAX68D0158Accident · No injuriesClosedCessna 170B · Saugus, CAOct 21, 1967 · N2590D · Substantial damageNTSB OAK68D0047Accident · Minor injuriesClosedAeronca 15AC · Oakdale, CAJul 16, 1967 · N1197H · DestroyedNTSB OAK68F0028Accident · No injuriesClosedAeronca 15AC · Fairfield, CAJun 25, 1967 · N1139H · Substantial damageNTSB OAK68D0055Accident · No injuriesClosedCessna 170 · Concord, CAJun 18, 1967 · N1240D · Substantial damageNTSB OAK67D0270Accident · No injuriesClosedCessna 170B · Lake Tahoe, CAApr 9, 1967 · N2795D · Substantial damageNTSB OAK67D0090Accident · No injuriesClosedCessna 170B · Elk Grove, CAOct 5, 1966 · N8000A · Substantial damageNTSB LAX67A0008Accident · 1 fatalClosedCessna 170A · Santa Maria, CAJul 19, 1966 · N1488D · DestroyedNTSB OAK67D0028Accident · No injuriesClosedCessna 170B · Stockton, CAJul 12, 1966 · N1805C · Substantial damage