NTSB investigations: Continental I0-470 series, 1978

64 cases on aircraft whose registry engine model is Continental I0-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 year(c.\"eventDate\") = 1978
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17027'))
  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 OAK78DXQ17Accident · No injuriesClosedCessna 205 · Mammoth Lakes, CAApr 8, 1978 · N8347Z · Substantial damageNTSB MIA78FLA25Accident · No injuriesClosedCessna 310N · Jacksonville, FLMar 30, 1978 · N4137Q · Substantial damageNTSB LAX78FA039Accident · 4 fatalClosedBeech 95-B55 · Bear Valy Sprg, CAMar 30, 1978 · N718X · DestroyedNTSB CHI78DET19Accident · No injuriesClosedCessna 310Q · Fort Wayne, INMar 14, 1978 · N69737 · Substantial damageNTSB MKC78FCG17Accident · No injuriesClosedCessna 210 · Rushville, MOMar 13, 1978 · N345Q · Substantial damageNTSB CHI78FEI16Accident · No injuriesClosedCessna 310D · Carrollton, OHMar 11, 1978 · N6864T · Substantial damageNTSB NYC78FNC17Accident · No injuriesClosedCessna 31OJ · Bangor, MEFeb 27, 1978 · N3107L · Substantial damageNTSB NYC78FGT05Accident · No injuriesClosedCessna 310J · Lititz, PAFeb 24, 1978 · N3092L · Substantial damageNTSB MKC78FCG16Accident · No injuriesClosedCessna 310 · Bonner Springs, KSFeb 23, 1978 · N6996T · Substantial damageNTSB FTW78FPG16Accident · Serious injuriesClosedCessna 310Q · Fort Smith, ARFeb 17, 1978 · N972AC · DestroyedNTSB MIA78FA039Accident · 1 fatalClosedCessna 310 · St Petersburg, FLFeb 9, 1978 · N1272 · DestroyedNTSB IAD78FA030Accident · 1 fatalClosedBeech 55 · Lexington, KYJan 6, 1978 · N25N · DestroyedNTSB MKC78FER22Accident · No injuriesClosedCessna 310C · Blaine, MNJan 4, 1978 · N1780H · Substantial damageNTSB MKC78FCA11Accident · Serious injuriesClosedBeech M35 · West Plains, MOJan 2, 1978 · N686V · Destroyed