NTSB investigations: Continental E185 series, CA

126 cases on aircraft whose registry engine model is Continental E185 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 ('17014'))
  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 LAX74DUG34Accident · No injuriesClosedBeech A35 · Boron, CADec 10, 1973 · N597B · Substantial damageNTSB OAK74DVM16Accident · No injuriesClosedBeech 35 · Moss Beach, CADec 8, 1973 · N11E · Substantial damageNTSB LAX74FUA13Accident · No injuriesClosedBeech B35 · Long Beach, CANov 22, 1973 · N3019V · Substantial damageNTSB OAK73DXQ33Accident · No injuriesClosedNavion A · Tahoe City, CAFeb 17, 1973 · N91792 · Substantial damageNTSB LAX73FUM13Accident · No injuriesClosedBeech A35 · El Cajon, CADec 31, 1972 · N506B · Substantial damageNTSB OAK73DVG29Accident · No injuriesClosedBeech 35 · San Andreas, CANov 8, 1972 · N3388V · Substantial damageNTSB OAK73DXQ18Accident · No injuriesClosedBeech D35 · Truckee, CASep 18, 1972 · N1895D · Substantial damageNTSB LAX73DUA02Accident · No injuriesClosedBeech 35 · Long Beach, CAJul 2, 1972 · N4533V · Substantial damageNTSB OAK72FVG46Accident · Serious injuriesClosedNavion A · Jackson, CAMar 26, 1972 · N4551K · Substantial damageNTSB OAK72AP031Accident · 1 fatalClosedBeech E35 · Dublin, CAMar 2, 1972 · N766B · DestroyedNTSB OAK72DVM17Accident · No injuriesClosedBeech 35 · San Jose, CADec 4, 1971 · N3009V · 2 aircraft · Substantial damageNTSB OAK72DVM14Accident · No injuriesClosedBeech C35 · Palo Alto, CANov 15, 1971 · N5836C · Substantial damageNTSB OAK72DXQ09Accident · No injuriesClosedBeech D35 · Susanville, CAAug 12, 1971 · N7777J · Substantial damageNTSB OAK72DVW03Accident · No injuriesClosedBeech B35 · Bishop, CAJul 15, 1971 · N4449V · Substantial damageNTSB LAX71FUA51Accident · No injuriesClosedBeech 35 · Huntingtn B., CAMar 7, 1971 · N406B · Substantial damageNTSB LAX71FUG49Accident · No injuriesClosedBeech 35 · Corona, CAFeb 24, 1971 · N2864V · Substantial damageNTSB LAX71DVA48Accident · Minor injuriesClosedBeech 35 · Bakersfield, CAJan 1, 1971 · N80411 · Substantial damageNTSB LAX71FUG17Accident · No injuriesClosedBeech D35 · Fontana, CASep 28, 1970 · N4484V · Substantial damageNTSB LAX70FUA28Accident · No injuriesClosedBeech 35 · Torrance, CAJun 4, 1970 · N3947N · Substantial damageNTSB OAK70FVG04Accident · Serious injuriesClosedBeech 35 · Shingle Sprgs, CAMar 18, 1970 · N2961V · Substantial damageNTSB OAK70FVA07Accident · No injuriesClosedBeech D35 · Fresno, CAFeb 23, 1970 · N2971B · Substantial damageNTSB LAX70AL043Accident · 1 fatalClosedBeech D35 · Newhall, CAJan 13, 1970 · N2124D · DestroyedNTSB LAX70F0115Accident · No injuriesClosedLuscombe 11A · Bakersfield, CASep 1, 1969 · N1629B · Substantial damageNTSB OAK70D0049Accident · No injuriesClosedBeech D35 · Sanger, CAJul 16, 1969 · N2971B · Substantial damageNTSB LAX70F0015Accident · No injuriesClosedMeyers MAC145 · Torrance, CAJun 9, 1969 · N343E · Substantial damageNTSB LAX70D0008Accident · No injuriesClosedBeech 35 · Chino, CAJun 8, 1969 · N159W · Substantial damageNTSB LAX69F0306Accident · No injuriesClosedBeech 35 · Long Beach, CAMar 23, 1969 · N4440V · Substantial damageNTSB LAX69F0234Accident · No injuriesClosedNavion A · Fullerton, CAJan 29, 1969 · N91137 · Substantial damageNTSB OAK69D0246Accident · No injuriesClosedNavion A · Davis, CADec 1, 1968 · N4273K · Substantial damageNTSB LAX69D0212Accident · No injuriesClosedBeech A35 · Santa Ana, CANov 29, 1968 · N734B · Substantial damageNTSB LAX69D0197Accident · No injuriesClosedBeech 35 · Palm Springs, CANov 16, 1968 · N446B · Substantial damageNTSB OAK69D0163Accident · No injuriesClosedBeech 35 · San Jose, CAOct 20, 1968 · N2786V · Substantial damageNTSB OAK69D0108Accident · No injuriesClosedBeech 35 · Redding, CAAug 24, 1968 · N3064V · Substantial damageNTSB OAK69A0011Accident · 2 fatalClosedBeech N35 · Truckee, CAAug 16, 1968 · N1235Z · DestroyedNTSB OAK69F0105Accident · No injuriesClosedBeech A35 · Tah0e Valley, CAJul 20, 1968 · N536B · Substantial damageNTSB OAK69D0019Accident · No injuriesClosedBeech 35 · S.Luis Obispo, CAMay 29, 1968 · N543PJ · Substantial damageNTSB LAX68F0430Accident · No injuriesClosedBeech A35 · S.J.Capistrno, CAMay 22, 1968 · N898S · Substantial damageNTSB LAX68D0391Accident · No injuriesClosedBeech C35 · Oxnard, CAApr 26, 1968 · N8950A · Substantial damageNTSB LAX68F0387Accident · No injuriesClosedBeech C35 · Santa Ana, CAApr 11, 1968 · N8973A · Substantial damageNTSB OAK68D0346Accident · No injuriesClosedBeech B35 · Stockton, CAApr 6, 1968 · N5084C · Substantial damageNTSB LAX68D0344Accident · No injuriesClosedNavion G · Baker, CAFeb 11, 1968 · N4823K · Substantial damageNTSB LAX68D0299Accident · No injuriesClosedBeech C35 · Santa Ana, CAJan 28, 1968 · N8945A · Substantial damageNTSB LAX68D0269Accident · No injuriesClosedBeech A35 · Oxnard, CADec 23, 1967 · N8595A · Substantial damageNTSB OAK68F0209Accident · No injuriesClosedBeech A35 · Visalia, CANov 19, 1967 · N560B · Substantial damageNTSB LAX68F0277Accident · No injuriesClosedBeech 35 · Fullerton, CANov 1, 1967 · N4484V · Substantial damageNTSB LAX68D0181Accident · No injuriesClosedBeech 35 · Palm Sprngs, CAOct 11, 1967 · N2879V · Substantial damageNTSB LAX68D0161Accident · No injuriesClosedBeech A35 · Santee, CAOct 10, 1967 · N8564A · Substantial damageNTSB LAX68D0146Accident · No injuriesClosedNavion A · Bakersfield, CASep 13, 1967 · N91668 · Substantial damageNTSB OAK68D0131Accident · No injuriesClosedBeech 35 · Santa Rosa, CASep 9, 1967 · N3333V · Substantial damageNTSB OAK68D0068Accident · No injuriesClosedBeech 35A · San Francisco, CAJul 10, 1967 · N2889V · Substantial damage