NTSB investigations: Continental W670 series, TX
71 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\" = 'TX' 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" = 'TX' 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 FTW68F0616Accident · No injuriesClosedBoeing A75N1 · Beaumont, TXNTSB FTW67D0610Accident · No injuriesClosedSnow S2A · Garwood, TXNTSB FTW67F0567Accident · No injuriesClosedBoeing E75 · Nome, TXNTSB FTW67F0147Accident · No injuriesClosedBoeing A75 · Navasota, TXNTSB FTW67A0022Accident · 1 fatalClosedBoeing A75 · Texas City, TXNTSB FTW67D0106Accident · No injuriesClosedGrumman G-164 · Port Lavaca, TXNTSB FTW66D0680Accident · No injuriesClosedBoeing A75 · Nome, TXNTSB FTW66F0665Accident · Minor injuriesClosedBoeing A75N1 · Nederland, TXNTSB FTW66F0282Accident · No injuriesClosedCessna 190 · Hillsboro, TXNTSB FTW66F0242Accident · Minor injuriesClosedBoeing A75 · Bryan, TXNTSB FTW66D0147Accident · No injuriesClosedSnow S2A · Stratford, TXNTSB FTW66D0144Accident · No injuriesClosedGrumman G-164 · Santa Maria, TXNTSB FTW66F0060Accident · No injuriesClosedBoeing D75N1 · Progresso, TXNTSB FTW66F0057Accident · No injuriesClosedFunk F-23 · Garwood, TXNTSB FTW66F0151Accident · No injuriesClosedBoeing E-75 · El Campo, TXNTSB UNK64X3756Accident · No injuriesClosedSnow S2A · Roaring Sprgs, TXNTSB UNK64X3159Accident · 1 fatalClosedBoeing A75N1 · San Antonio, TXNTSB UNK64X2966Accident · No injuriesClosedBoeing A75 · El Campo, TXNTSB UNK64X2713Accident · No injuriesClosedGrumman G164 · Port Lavaca, TXNTSB UNK64X2330Accident · No injuriesClosedBoeing A75N1 · Bryan, TXNTSB UNK64X1832Accident · No injuriesClosedBoeing A75N1 · Eagle Lake, TX