NTSB investigations: Continental O-470 series, VA

67 cases on aircraft whose registry engine model is Continental O-470 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\" = 'VA' 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 ('17026'))
  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 NYC72DID09Accident · No injuriesClosedCessna 182J · Ashland, VAAug 28, 1971 · N2723F · Substantial damageNTSB IAD71FID14Accident · 1 fatalClosedCessna 182 · Crewe, VANov 8, 1970 · N8503S · No damageNTSB IAD70AI044Accident · 1 fatalClosedCessna 182 · Dublin, VAFeb 9, 1970 · N127CS · DestroyedNTSB DIA69F0135Accident · No injuriesClosedCessna 182 · Petersburg, VAJan 13, 1969 · N2723F · Substantial damageNTSB DIA69D0065Accident · No injuriesClosedCessna 182 · Norfolk, VASep 2, 1968 · N4738D · Substantial damageNTSB DIA68F0005Accident · No injuriesClosedCessna 182 · Quinton, VAJun 3, 1967 · N6257A · Substantial damageNTSB NYC67D0470Accident · No injuriesClosedCessna 182A · Turbeville, VADec 20, 1966 · N5161D · Substantial damageNTSB NYC67D0412Accident · No injuriesClosedCessna 182J · Warrenton, VADec 2, 1966 · N3360F · DestroyedNTSB NYC67F0078Accident · Minor injuriesClosedCessna 182J · Roanoke, VAJul 8, 1966 · N2826F · Substantial damageNTSB NYC66F0387Accident · No injuriesClosedCessna 182 · Fork Union, VADec 7, 1965 · N3208U · Substantial damageNTSB NYC66F0043Accident · No injuriesClosedCessna 310B · Leesburg, VAJun 20, 1965 · N295C · Substantial damageNTSB NYC66F0079Accident · No injuriesClosedCessna 182 · Woodbridge, VAJun 18, 1965 · N3772D · Substantial damageNTSB NYC66D0248Accident · No injuriesClosedCessna 182E · Sandston, VAJun 13, 1965 · N3172Y · Substantial damageNTSB NYC65F0211Accident · No injuriesClosedCessna 182 · Dulles Arpt, VAMay 26, 1965 · N9911B · Substantial damageNTSB UNK65X1469Accident · Serious injuriesClosedCessna 182C · Rustburg, VAMar 7, 1965 · N8957T · DestroyedNTSB UNK64X2254Accident · 1 fatalClosedCessna 180 · Fancy Gap, VAJun 12, 1964 · N3149C · DestroyedNTSB UNK64X0583Accident · No injuriesClosedCessna 180 · Norfolk, VAFeb 16, 1964 · N3128C · Substantial damage