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.

NTSB FTW68F0616Accident · No injuriesClosedBoeing A75N1 · Beaumont, TXJun 1, 1968 · N60885 · 2 aircraft · Substantial damageNTSB FTW67D0610Accident · No injuriesClosedSnow S2A · Garwood, TXMay 5, 1967 · N9443R · Substantial damageNTSB FTW67F0567Accident · No injuriesClosedBoeing E75 · Nome, TXApr 24, 1967 · N1682M · 2 aircraft · Substantial damageNTSB FTW67F0147Accident · No injuriesClosedBoeing A75 · Navasota, TXAug 8, 1966 · N46592 · Substantial damageNTSB FTW67A0022Accident · 1 fatalClosedBoeing A75 · Texas City, TXAug 4, 1966 · N59335 · Substantial damageNTSB FTW67D0106Accident · No injuriesClosedGrumman G-164 · Port Lavaca, TXJul 22, 1966 · N485Y · Substantial damageNTSB FTW66D0680Accident · No injuriesClosedBoeing A75 · Nome, TXMay 24, 1966 · N59767 · Substantial damageNTSB FTW66F0665Accident · Minor injuriesClosedBoeing A75N1 · Nederland, TXMay 9, 1966 · N60885 · Substantial damageNTSB FTW66F0282Accident · No injuriesClosedCessna 190 · Hillsboro, TXSep 13, 1965 · N1044D · Substantial damageNTSB FTW66F0242Accident · Minor injuriesClosedBoeing A75 · Bryan, TXAug 6, 1965 · N48569 · 2 aircraft · Substantial damageNTSB FTW66D0147Accident · No injuriesClosedSnow S2A · Stratford, TXJul 6, 1965 · N3696F · Substantial damageNTSB FTW66D0144Accident · No injuriesClosedGrumman G-164 · Santa Maria, TXJun 29, 1965 · N143W · Substantial damageNTSB FTW66F0060Accident · No injuriesClosedBoeing D75N1 · Progresso, TXMay 21, 1965 · N61W · Substantial damageNTSB FTW66F0057Accident · No injuriesClosedFunk F-23 · Garwood, TXMay 4, 1965 · N1127Z · 2 aircraft · Minor damageNTSB FTW66F0151Accident · No injuriesClosedBoeing E-75 · El Campo, TXApr 26, 1965 · N3997B · Substantial damageNTSB UNK64X3756Accident · No injuriesClosedSnow S2A · Roaring Sprgs, TXSep 3, 1964 · N4973C · Substantial damageNTSB UNK64X3159Accident · 1 fatalClosedBoeing A75N1 · San Antonio, TXAug 1, 1964 · N62552 · DestroyedNTSB UNK64X2966Accident · No injuriesClosedBoeing A75 · El Campo, TXJul 21, 1964 · N63916 · Substantial damageNTSB UNK64X2713Accident · No injuriesClosedGrumman G164 · Port Lavaca, TXJul 8, 1964 · N472Y · Substantial damageNTSB UNK64X2330Accident · No injuriesClosedBoeing A75N1 · Bryan, TXJun 17, 1964 · N55361 · Substantial damageNTSB UNK64X1832Accident · No injuriesClosedBoeing A75N1 · Eagle Lake, TXMay 18, 1964 · N52652 · Substantial damage