NTSB investigations: Continental W670 series, CA

89 cases on aircraft whose registry engine model is Continental W670 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 ('17018'))
  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 LAX76FUG50Accident · Serious injuriesClosedNieuport 28 · Colton, CAMay 1, 1976 · N100JP · Substantial damageNTSB OAK76DVG47Accident · No injuriesClosedGrumman G-164A · Marysville, CAFeb 28, 1976 · N7807 · Substantial damageNTSB OAK76DVA13Accident · No injuriesClosedBoeing A75 · Los Banos, CASep 27, 1975 · N54671 · 2 aircraft · Substantial damageNTSB OAK75DVG60Accident · No injuriesClosedGrumman G-164A · Davis, CAMay 8, 1975 · N8376 · Substantial damageNTSB OAK75DVD33Accident · No injuriesClosedBoeing A75N1 · Santa Rosa, CAJan 14, 1975 · N62945 · Substantial damageNTSB OAK75FVG18Accident · No injuriesClosedGrumman G-164A · Davis, CAAug 21, 1974 · N8376 · Substantial damageNTSB LAX74FUQ26Accident · Minor injuriesClosedNieuport LF-1 · Piru, CAJan 15, 1974 · N12237 · Substantial damageNTSB LAX73FUA40Accident · No injuriesClosedWaco UPF-7 · Santa Ana, CAApr 29, 1973 · N30141 · 2 aircraft · Substantial damageNTSB OAK72FVM01Accident · No injuriesClosedStinson L-5 · San Jose, CAJun 17, 1972 · N3767G · Substantial damageNTSB OAK72DVM33Accident · No injuriesClosedWaco UPF-7 · Watsonville, CAMay 21, 1972 · N32137 · Substantial damageNTSB OAK72FVM21Accident · 1 fatalClosedStearman E75 · Castroville, CAJan 18, 1972 · N68983 · DestroyedNTSB LAX72DUG23Accident · No injuriesClosedStinson L-5E · Elsinore, CAOct 9, 1971 · N68781 · Substantial damageNTSB LAX72DVA11Accident · Minor injuriesClosedBoeing B75N1 · Wheeler Rdg, CAAug 12, 1971 · N68994 · Substantial damageNTSB OAK72FVG03Accident · No injuriesClosedBoeing A75N1 · Sacramento, CAJul 9, 1971 · N62794 · DestroyedNTSB LAX71FUM31Accident · Serious injuriesClosedFairchild M-62C · Chula Vista, CAMar 9, 1971 · N57064 · Substantial damageNTSB OAK71DVM32Accident · No injuriesClosedCessna 190 · San Jose, CADec 13, 1970 · N9851A · Substantial damageNTSB OAK71AP018Accident · 2 fatalClosedBoeing A75N1 · Castro Valley, CASep 26, 1970 · N49793 · DestroyedNTSB OAK71DVM16Accident · No injuriesClosedBoeing B75 · Soledad, CASep 18, 1970 · N68984 · Substantial damageNTSB OAK71DVM13Accident · No injuriesClosedStearman B75 · Gonzales, CAAug 31, 1970 · N68984 · Substantial damageNTSB LAX70DUG15Accident · No injuriesClosedStinson L-5 · Elsinore, CAJan 31, 1970 · N68781 · Substantial damageNTSB OAK70D0128Accident · No injuriesClosedBoeing A75 · Castroville, CAAug 30, 1969 · N4767V · Substantial damageNTSB OAK69F0210Accident · Minor injuriesClosedStearman B75N1 · Castroville, CAJan 4, 1969 · N1226V · DestroyedNTSB OAK69D0147Accident · No injuriesClosedStinson L-5 · Santa Clara, CAAug 31, 1968 · N3768G · Substantial damageNTSB OAK69F0004Accident · 1 fatalClosedBoeing A75 · Meridian, CAMay 28, 1968 · N68135 · DestroyedNTSB LAX68D0078Accident · No injuriesClosedBoeing E75 · Lamont, CAJul 22, 1967 · N269N · Substantial damageNTSB OAK68D0165Accident · No injuriesClosedBoeing A75N1 · Dos Palos, CAJul 20, 1967 · N54671 · DestroyedNTSB LAX68D0077Accident · No injuriesClosedBoeing A75N1 · Buttonwillow, CAJul 1, 1967 · N56439 · DestroyedNTSB OAK67D0324Accident · No injuriesClosedStinson L-5 · Dos Palos, CAMay 8, 1967 · N63108 · Substantial damageNTSB OAK68F0050Accident · Minor injuriesClosedCessna 190 · San Jose, CAMar 18, 1967 · N1114M · Substantial damageNTSB OAK67D0078Accident · No injuriesClosedBoeing A75 · Dos Palos, CAAug 22, 1966 · N56749 · Minor damageNTSB OAK67F0045Accident · No injuriesClosedStinson L5 MOD · Brentwood, CAJul 3, 1966 · N54029 · Substantial damageNTSB OAK66F0258Accident · No injuriesClosedBoeing A75 · Maxwell, CAApr 8, 1966 · N62917 · Substantial damageNTSB OAK66F0148Accident · Minor injuriesClosedStinson L-5 · Byron, CASep 26, 1965 · N54029 · Substantial damageNTSB LAX66F0125Accident · No injuriesClosedBoeing D-75N1 · Holtville, CASep 22, 1965 · N48780 · Substantial damageNTSB OAK66F0094Accident · Minor injuriesClosedBoeing B-75N1 · Watsonville, CAJun 22, 1965 · N68942 · Substantial damageNTSB UNK65X0783Accident · No injuriesClosedWaco UKC-S · La Verne, CANov 22, 1964 · N14606 · Substantial damageNTSB UNK65X0543Accident · No injuriesClosedStinson L5 · Castroville, CANov 3, 1964 · N66881 · Substantial damageNTSB UNK64X2193Accident · Serious injuriesClosedBoeing 75 · 50nm E Fresno, CAJun 8, 1964 · N79466 · DestroyedNTSB UNK64X1366Accident · 2 fatalClosedFairchild 24W41 · San Jose, CAApr 18, 1964 · N29012 · Destroyed