NTSB investigations: Continental C90 series, CA

113 cases on aircraft whose registry engine model is Continental C90 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 ('17009'))
  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 LAX75DUM26Accident · No injuriesClosedPiper PA-18 · Imperial, CAMay 17, 1975 · N4711A · Substantial damageNTSB LAX75DUM11Accident · Minor injuriesClosedPiper PA-18 · Imperial, CANov 25, 1974 · N4711A · Substantial damageNTSB LAX75AL024Accident · No injuriesClosedBell 47G-5 · Riverside, CANov 4, 1974 · N7081J · 2 aircraft · Substantial damageNTSB OAK75AP007Accident · 2 fatalClosedChampion 7FC · Newman, CAAug 17, 1974 · N7584E · DestroyedNTSB OAK75DVD38Accident · No injuriesClosedCessna 140 · Hayward, CAJun 23, 1974 · N76138 · Substantial damageNTSB OAK74DVA72Accident · No injuriesClosedAlon A-2 · Fresno, CAJun 8, 1974 · N6366V · Substantial damageNTSB LAX74DUM34Accident · No injuriesClosedCessna 140 · Borrego Spg, CAMay 30, 1974 · N2286V · Substantial damageNTSB OAK74FVW16Accident · Minor injuriesClosedChampion 7EC · Lone Pine, CAApr 6, 1974 · N4341C · Substantial damageNTSB LAX74FUM10Accident · No injuriesClosedPiper PA-18 · Santee, CAOct 19, 1973 · N7248K · Substantial damageNTSB OAK74FVG01Accident · Serious injuriesClosedCessna 140 · Grass Vally, CAJul 1, 1973 · N2392V · Substantial damageNTSB LAX73DUQ40Accident · No injuriesClosedChampion 7FC · Mojave, CAJun 16, 1973 · N9883Y · Substantial damageNTSB LAX73DUG59Accident · No injuriesClosedChampion 7CCM · Riverside, CAMay 27, 1973 · N1052E · Substantial damageNTSB OAK73FVD17Accident · No injuriesClosedChampion 7EC · Fremont, CASep 10, 1972 · N4330C · Substantial damageNTSB OAK73DVA16Accident · Minor injuriesClosedChampion 7FC · Hanford, CASep 1, 1972 · N7540B · Substantial damageNTSB OAK72DVG68Accident · No injuriesClosedCessna 140A · Hayfork, CAJun 4, 1972 · N9655A · Substantial damageNTSB OAK72FVD24Accident · No injuriesClosedAeronca 7EC · Sonoma, CAOct 8, 1971 · N7410B · Substantial damageNTSB OAK72DVD07Accident · No injuriesClosedLuscombe 8F · Concord, CAAug 19, 1971 · N1373B · Substantial damageNTSB LAX72FUQ09Accident · Serious injuriesClosedErco 415-D · Van Nuys, CAJul 24, 1971 · N3618H · Minor damageNTSB LAX72DUQ03Accident · No injuriesClosedPiper PA-18 · Rosamond, CAJul 5, 1971 · N8079D · Substantial damageNTSB OAK71DVA85Accident · No injuriesClosedCessna 140 · Columbia, CAJun 15, 1971 · N3738V · Substantial damageNTSB LAX71DVW26Accident · No injuriesClosedChampion 7FC · Tecopa, CAFeb 20, 1971 · N9038B · Substantial damageNTSB LAX71FUA28Accident · No injuriesClosedCessna 140 · Santa Ana, CANov 28, 1970 · N1148D · Substantial damageNTSB OAK71DVM29Accident · Minor injuriesClosedLuscombe 8F · San Carlos, CANov 21, 1970 · N9920C · Substantial damageNTSB OAK71DXQ19Accident · No injuriesClosedLuscombe 8F · Fort Bidwel, CASep 26, 1970 · N9909C · Substantial damageNTSB LAX70FUQ24Accident · No injuriesClosedCessna 140 · S Fernando, CAApr 7, 1970 · N2331V · Substantial damageNTSB OAK70D0120Accident · No injuriesClosedErco 415G · Lone Pine, CASep 19, 1969 · N94408 · Substantial damageNTSB LAX70D0066Accident · No injuriesClosedLuscombe 8F · San Frnando, CAAug 10, 1969 · N1372B · Substantial damageNTSB OAK69D0259Accident · No injuriesClosedCessna 140A · Exeter, CAMar 24, 1969 · N1136D · Substantial damageNTSB OAK69A0059Accident · 1 fatalClosedLuscombe 8F · Novato, CAMar 15, 1969 · N2086B · DestroyedNTSB LAX69D0228Accident · No injuriesClosedAlon A-2 · Riverside, CAJan 3, 1969 · N5698F · Substantial damageNTSB LAX69A0029Accident · 1 fatalClosedAlon A-2 · Lockwood, CANov 27, 1968 · N5469E · Substantial damageNTSB OAK69D0051Accident · No injuriesClosedAeronca 7EC · Fremont, CAJul 4, 1968 · N4337C · Substantial damageNTSB OAK68D0353Accident · No injuriesClosedAeronca 7EC · Eureka, CAApr 27, 1968 · N7567E · DestroyedNTSB OAK68D0317Accident · No injuriesClosedCessna 140 · Oceano, CAFeb 24, 1968 · N76139 · Substantial damageNTSB LAX68F0212Accident · No injuriesClosedLuscombe 8F · Santa Monic, CANov 30, 1967 · N1867B · Substantial damageNTSB LAX68F0165Accident · Minor injuriesClosedAlon A-2 · El Monte, CAOct 6, 1967 · N6585Q · Substantial damageNTSB LAX68F0160Accident · No injuriesClosedChampion 7FC · Lancaster, CAOct 5, 1967 · N7545B · Substantial damageNTSB LAX68F0003Accident · Minor injuriesClosedLuscombe 8F · Chino, CAJun 5, 1967 · N2137B · DestroyedNTSB OAK67D0335Accident · No injuriesClosedChampion 7FC · San Carlos, CAMay 30, 1967 · N9021B · Substantial damageNTSB LAX67F0408Accident · No injuriesClosedCessna 140A · Santa Ana, CAApr 14, 1967 · N1148D · Substantial damageNTSB LAX67D0141Accident · No injuriesClosedCessna 140 · San Diego, CASep 12, 1966 · N2351V · Substantial damageNTSB LAX67D0076Accident · No injuriesClosedCessna 140A · Daggett, CAAug 13, 1966 · N2497V · Substantial damageNTSB OAK67D0030Accident · No injuriesClosedAeronca 7EC · San Francisco, CAJul 14, 1966 · N9098B · Substantial damageNTSB OAK67F0021Accident · No injuriesClosedChampion 7FC · Concord, CAJun 7, 1966 · N7584E · Substantial damageNTSB OAK67D0009Accident · No injuriesClosedErcoupe 415-C · S.Luis Obispo, CAMay 29, 1966 · N3618H · Substantial damageNTSB OAK66D0214Accident · No injuriesClosedChampion 7EC · Oakland, CAMar 9, 1966 · N9986Y · Substantial damageNTSB LAX66F0256Accident · No injuriesClosedChampion 7FC · Santa Monica, CAMar 2, 1966 · N9839Y · Substantial damageNTSB LAX66D0209Accident · Minor injuriesClosedChampion 7FC · San Diego, CADec 23, 1965 · N9896B · Substantial damageNTSB LAX66D0199Accident · No injuriesClosedCessna 140 · San Diego, CADec 19, 1965 · N76403 · Substantial damageNTSB LAX66D0101Accident · No injuriesClosedLuscombe 8F · Torrance, CAAug 10, 1965 · N1453B · Substantial damage