NTSB investigations: Continental E185 series, 1966

76 cases on aircraft whose registry engine model is Continental E185 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\") = 1966
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17014'))
  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 LAX67D0024Accident · No injuriesClosedNavion B · Buckeye, AZMay 27, 1966 · N8569H · Substantial damageNTSB OAK66D0303Accident · No injuriesClosedBeech D35 · Mendota, CAMay 19, 1966 · N2936B · Substantial damageNTSB CHI66F0723Accident · Minor injuriesClosedBeech 35 · Cincinnati, OHMay 18, 1966 · N275H · Substantial damageNTSB SEA67F0033Accident · No injuriesClosedBeech C35 · Corvallis, ORMay 17, 1966 · N794D · Substantial damageNTSB FTW67F0227Accident · No injuriesClosedBeech 35 · Fort Worth, TXMay 13, 1966 · N3388V · Substantial damageNTSB LAX66A0086Accident · 1 fatalClosedBeech 35 · ZMay 8, 1966 · N3918N · DestroyedNTSB LAX66D0360Accident · No injuriesClosedBeech B35 · Colton, CAApr 30, 1966 · N8461A · Substantial damageNTSB MKC66D0529Accident · No injuriesClosedBeech D35 · Minneapolis, MNApr 24, 1966 · N2165D · Substantial damageNTSB FTW66D0633Accident · No injuriesClosedBeech C35 · Sparkman, ARApr 24, 1966 · N1813D · Substantial damageNTSB CHI66F0695Accident · No injuriesClosedBeech 35 · Eaton, MIApr 21, 1966 · N2820V · Substantial damageNTSB FTW66D0617Accident · No injuriesClosedMavion A · Jonesboro, ARApr 12, 1966 · N9126R · Substantial damageNTSB DEN66F0292Accident · No injuriesClosedBeech 35 · Texico, NMApr 10, 1966 · N440B · Substantial damageNTSB OAK66F0232Accident · No injuriesClosedBeech 35 · Coalinga, CAApr 2, 1966 · N4841V · Substantial damageNTSB ANC66D0101Accident · No injuriesClosedBeech C35 · Wasilla, AKMar 27, 1966 · N778D · Substantial damageNTSB CHI66D0676Accident · No injuriesClosedBeech A35 · Crystal Lake, ILMar 20, 1966 · N515B · Substantial damageNTSB LAX66D0332Accident · No injuriesClosedBeech 35 · Cantil, CAMar 19, 1966 · N80409 · Substantial damageNTSB MKC67D0078Accident · No injuriesClosedBeech 35 · Anthony, KSMar 16, 1966 · N3178V · Substantial damageNTSB NYC66D0540Accident · No injuriesClosedCessna 150 · Islip, NYMar 13, 1966 · N8120S · Substantial damageNTSB FTW66A0097Accident · 2 fatalClosedBeech C35 · Brownsville (Gulf of Mexico)Mar 9, 1966 · N783D · DestroyedNTSB LAX66D0289Accident · No injuriesClosedBeech 35 · El Monte, CAMar 2, 1966 · N2889V · Substantial damageNTSB FTW66F0502Accident · No injuriesClosedBeechcraft 35 · Grand Prairie, TXJan 25, 1966 · N2722V · Substantial damageNTSB SEA66F0208Accident · No injuriesClosedBeechcraft C35 · Newport, WAJan 24, 1966 · N5813C · Substantial damageNTSB CHI66F0544Accident · No injuriesClosedBeechcraft C35 · Kankakee, ILJan 23, 1966 · N8944A · Substantial damageNTSB MKC66F0395Accident · No injuriesClosedBeech 35 · Salinga, KSJan 14, 1966 · N5783N · Substantial damageNTSB MIA66F0397Accident · No injuriesClosedNavion A · Montgomery, ALJan 12, 1966 · N91616 · Substantial damageNTSB CHI66D0525Accident · No injuriesClosedBeechcraft A35 · Cynthiana, KYJan 11, 1966 · N275H · Substantial damage