NTSB investigations: Continental E225 series, CA

101 cases on aircraft whose registry engine model is Continental E225 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 ('17015'))
  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 OAK70D0021Accident · No injuriesClosedBeech 35 · Lee Vining, CAJun 16, 1969 · N3731N · Substantial damageNTSB OAK69D0320Accident · No injuriesClosedNavion B · Bishop, CAMay 23, 1969 · N5140 · Substantial damageNTSB OAK69D0290Accident · No injuriesClosedBeech C35 · Chico, CAMay 4, 1969 · N793D · Substantial damageNTSB LAX69F0310Accident · No injuriesClosedBeech F35 · Burbank, CAApr 8, 1969 · N3219C · Substantial damageNTSB LAX69A0036Accident · 2 fatalClosedNavion A · Tecate, CADec 21, 1968 · N4941K · DestroyedNTSB LAX69D0248Accident · Serious injuriesClosedBeech 35G · Van Nuys, CAOct 23, 1968 · N4546D · No damageNTSB LAX69F0174Accident · Minor injuriesClosedBeech F35 · Calexico, CAOct 20, 1968 · N4275B · DestroyedNTSB OAK69D0119Accident · No injuriesClosedBeech C35 · Salinas, CAAug 17, 1968 · N5827C · Substantial damageNTSB OAK69D0053Accident · No injuriesClosedBeech F35 · Vacaville, CAJul 1, 1968 · N5073B · Substantial damageNTSB LAX68D0402Accident · No injuriesClosedNavion A · Palm Sprngs, CAMay 4, 1968 · N8929H · Substantial damageNTSB LAX68F0264Accident · No injuriesClosedBeech E35 · Calipatria, CADec 23, 1967 · N7390B · Substantial damageNTSB OAK68D0124Accident · No injuriesClosedBeech F35 · Carmel Vall, CAAug 26, 1967 · N5043B · Substantial damageNTSB OAK68D0016Accident · No injuriesClosedBeech E35 · Oakland, CAMay 11, 1967 · N3201C · Substantial damageNTSB LAX67D0420Accident · No injuriesClosedNavion A · Burbank, CAMay 6, 1967 · N8929H · Substantial damageNTSB LAX67D0366Accident · No injuriesClosedBeech G35 · Bakersfield, CAApr 1, 1967 · N311B · Substantial damageNTSB OAK67D0231Accident · No injuriesClosedBeech F35 · Stockton, CAFeb 17, 1967 · N5008B · Substantial damageNTSB LAX67F0228Accident · No injuriesClosedBeech A35 · San Diego, CADec 10, 1966 · N482B · Substantial damageNTSB OAK67D0175Accident · No injuriesClosedBeech C35 · Livermore, CANov 6, 1966 · N793D · Substantial damageNTSB OAK67D0119Accident · No injuriesClosedBeech F35 · Salinas, CAOct 20, 1966 · N3286C · Substantial damageNTSB OAK67D0112Accident · No injuriesClosedBeech G35 · Columbia, CASep 27, 1966 · N5095B · Substantial damageNTSB OAK67F0142Accident · Minor injuriesClosedNavion A · Morgan Hill, CASep 24, 1966 · N91537 · Substantial damageNTSB LAX67F0106Accident · No injuriesClosedBeech E35 · Torrance, CAAug 13, 1966 · N84BH · Substantial damageNTSB OAK67D0140Accident · No injuriesClosedBeech G35 · Willits, CAJul 4, 1966 · N4597D · Substantial damageNTSB LAX66D0381Accident · No injuriesClosedNavion A · Imperial, CAJun 5, 1966 · N91440 · Substantial damageNTSB LAX66D0366Accident · No injuriesClosedBeech G35 · Santee, CAMay 30, 1966 · N4490D · Substantial damageNTSB OAK66D0288Accident · No injuriesClosedBeech 35 · Oceano, CAMay 10, 1966 · N3267V · Substantial damageNTSB LAX66F0333Accident · No injuriesClosedBeech D35 · Ontario, CAMay 8, 1966 · N898Q · Substantial damageNTSB OAK66D0217Accident · No injuriesClosedBeechcraft F35 · Monterey, CAMar 19, 1966 · N4920B · Substantial damageNTSB OAK66D0193Accident · No injuriesClosedBeechcraft G35 · Merced, CAJan 30, 1966 · N5095B · Substantial damageNTSB OAK66F0170Accident · No injuriesClosedBeechcraft 35 · San Carlos, CAJan 2, 1966 · N7607B · Substantial damageNTSB LAX66F0207Accident · No injuriesClosedBeechcraft 35 · Oxnard, CADec 15, 1965 · N306B · Substantial damageNTSB LAX66F0193Accident · No injuriesClosedNavion A · El Monte, CANov 7, 1965 · N8724H · Substantial damageNTSB OAK66D0144Accident · No injuriesClosedBeech G35 · Santa Rosa, CAOct 15, 1965 · N4628D · Substantial damageNTSB LAX66F0091Accident · No injuriesClosedBeechcraft G-35 · National City, CAAug 31, 1965 · N335B · Substantial damageNTSB OAK65F0027Accident · No injuriesClosedBeechcraft G-35 · Snelling, CAApr 13, 1965 · N4259D · Substantial damageNTSB LAX65F0041Accident · No injuriesClosedBeechcraft F-35 · Hawthorne, CAApr 13, 1965 · N3396C · Substantial damageNTSB LAX65D0071Accident · No injuriesClosedBeechcraft C-35 · Fullerton, CAMar 16, 1965 · N1821D · Substantial damageNTSB LAX65F0034Accident · No injuriesClosedBeechcraft B-35 · Bishop, CAFeb 21, 1965 · N5007C · Substantial damageNTSB OAK66F0017Accident · No injuriesClosedBeechcraft D-35 · Hayward, CAFeb 13, 1965 · N3465B · Substantial damageNTSB LAX65F0002Accident · No injuriesClosedNavion A · Thousand Oaks, CAJan 11, 1965 · N91163 · Substantial damageNTSB UNK65X0712Accident · No injuriesClosedBeechraft A-35 · San Diego, CANov 15, 1964 · N747B · Substantial damageNTSB UNK65X0697Accident · Minor injuriesClosedBeechcraft B35 · Long Beach, CANov 14, 1964 · N8725A · DestroyedNTSB UNK65X0565Accident · No injuriesClosedBeechcraft 35 · Concord, CANov 5, 1964 · N4256D · Substantial damageNTSB UNK64X3287Accident · No injuriesClosedBeechcraft A35 · Torance, CAAug 9, 1964 · N4458V · Substantial damageNTSB UNK64X3257Accident · No injuriesClosedBeechcraft E35 · Pauma Valley, CAAug 7, 1964 · N3218C · Substantial damageNTSB UNK64X2714Accident · No injuriesClosedBeechcraft G35 · Sacramento, CAJul 8, 1964 · N5096B · Substantial damageNTSB UNK64X2416Accident · No injuriesClosedBeechcraft D35 · Calexico, CAJun 21, 1964 · N2063D · Substantial damageNTSB UNK64X2033Accident · No injuriesClosedNavion NAV4 · Placentia, CAMay 30, 1964 · N4582K · Substantial damageNTSB UNK64X1467Accident · No injuriesClosedBeechcraft G35 · Thousand Oaks, CAApr 26, 1964 · N4433D · Substantial damageNTSB UNK64X0836Accident · No injuriesClosedNavion NAV4 · Concord, CAMar 7, 1964 · N4305K · Substantial damage