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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB LAX76FUG50Accident · Serious injuriesClosedNieuport 28 · Colton, CANTSB OAK76DVG47Accident · No injuriesClosedGrumman G-164A · Marysville, CANTSB OAK76DVA13Accident · No injuriesClosedBoeing A75 · Los Banos, CANTSB OAK75DVG60Accident · No injuriesClosedGrumman G-164A · Davis, CANTSB OAK75DVD33Accident · No injuriesClosedBoeing A75N1 · Santa Rosa, CANTSB OAK75FVG18Accident · No injuriesClosedGrumman G-164A · Davis, CANTSB LAX74FUQ26Accident · Minor injuriesClosedNieuport LF-1 · Piru, CANTSB LAX73FUA40Accident · No injuriesClosedWaco UPF-7 · Santa Ana, CANTSB OAK72FVM01Accident · No injuriesClosedStinson L-5 · San Jose, CANTSB OAK72DVM33Accident · No injuriesClosedWaco UPF-7 · Watsonville, CANTSB OAK72FVM21Accident · 1 fatalClosedStearman E75 · Castroville, CANTSB LAX72DUG23Accident · No injuriesClosedStinson L-5E · Elsinore, CANTSB LAX72DVA11Accident · Minor injuriesClosedBoeing B75N1 · Wheeler Rdg, CANTSB OAK72FVG03Accident · No injuriesClosedBoeing A75N1 · Sacramento, CANTSB LAX71FUM31Accident · Serious injuriesClosedFairchild M-62C · Chula Vista, CANTSB OAK71DVM32Accident · No injuriesClosedCessna 190 · San Jose, CANTSB OAK71AP018Accident · 2 fatalClosedBoeing A75N1 · Castro Valley, CANTSB OAK71DVM16Accident · No injuriesClosedBoeing B75 · Soledad, CANTSB OAK71DVM13Accident · No injuriesClosedStearman B75 · Gonzales, CANTSB LAX70DUG15Accident · No injuriesClosedStinson L-5 · Elsinore, CANTSB OAK70D0128Accident · No injuriesClosedBoeing A75 · Castroville, CANTSB OAK69F0210Accident · Minor injuriesClosedStearman B75N1 · Castroville, CANTSB OAK69D0147Accident · No injuriesClosedStinson L-5 · Santa Clara, CANTSB OAK69F0004Accident · 1 fatalClosedBoeing A75 · Meridian, CANTSB LAX68D0078Accident · No injuriesClosedBoeing E75 · Lamont, CANTSB OAK68D0165Accident · No injuriesClosedBoeing A75N1 · Dos Palos, CANTSB LAX68D0077Accident · No injuriesClosedBoeing A75N1 · Buttonwillow, CANTSB OAK67D0324Accident · No injuriesClosedStinson L-5 · Dos Palos, CANTSB OAK68F0050Accident · Minor injuriesClosedCessna 190 · San Jose, CANTSB OAK67D0078Accident · No injuriesClosedBoeing A75 · Dos Palos, CANTSB OAK67F0045Accident · No injuriesClosedStinson L5 MOD · Brentwood, CANTSB OAK66F0258Accident · No injuriesClosedBoeing A75 · Maxwell, CANTSB OAK66F0148Accident · Minor injuriesClosedStinson L-5 · Byron, CANTSB LAX66F0125Accident · No injuriesClosedBoeing D-75N1 · Holtville, CANTSB OAK66F0094Accident · Minor injuriesClosedBoeing B-75N1 · Watsonville, CANTSB UNK65X0783Accident · No injuriesClosedWaco UKC-S · La Verne, CANTSB UNK65X0543Accident · No injuriesClosedStinson L5 · Castroville, CANTSB UNK64X2193Accident · Serious injuriesClosedBoeing 75 · 50nm E Fresno, CANTSB UNK64X1366Accident · 2 fatalClosedFairchild 24W41 · San Jose, CA