NTSB investigations: Continental E185 series, 1968, CA

14 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 per year

19642026
NTSB investigations: Continental E185 series, 1968, CA per year, 1964–2026: 126 cases
19645
19658
196611
196710
196814
19696
19705
19717
19726
19734
19742
19751
19762
19772
19783
19802
19812
19823
19832
19852
19864
19873
19883
19894
19902
19961
19982
20021
20053
20061
20071
20111
20141
20171
20201

Latest cases

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\") = 1968
    AND c.\"eventStateOrRegion\" = 'CA' 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 ('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 OAK69D0246Accident · No injuriesClosedNavion A · Davis, CADec 1, 1968 · N4273K · Substantial damageNTSB LAX69D0212Accident · No injuriesClosedBeech A35 · Santa Ana, CANov 29, 1968 · N734B · Substantial damageNTSB LAX69D0197Accident · No injuriesClosedBeech 35 · Palm Springs, CANov 16, 1968 · N446B · Substantial damageNTSB OAK69D0163Accident · No injuriesClosedBeech 35 · San Jose, CAOct 20, 1968 · N2786V · Substantial damageNTSB OAK69D0108Accident · No injuriesClosedBeech 35 · Redding, CAAug 24, 1968 · N3064V · Substantial damageNTSB OAK69A0011Accident · 2 fatalClosedBeech N35 · Truckee, CAAug 16, 1968 · N1235Z · DestroyedNTSB OAK69F0105Accident · No injuriesClosedBeech A35 · Tah0e Valley, CAJul 20, 1968 · N536B · Substantial damageNTSB OAK69D0019Accident · No injuriesClosedBeech 35 · S.Luis Obispo, CAMay 29, 1968 · N543PJ · Substantial damageNTSB LAX68F0430Accident · No injuriesClosedBeech A35 · S.J.Capistrno, CAMay 22, 1968 · N898S · Substantial damageNTSB LAX68D0391Accident · No injuriesClosedBeech C35 · Oxnard, CAApr 26, 1968 · N8950A · Substantial damageNTSB LAX68F0387Accident · No injuriesClosedBeech C35 · Santa Ana, CAApr 11, 1968 · N8973A · Substantial damageNTSB OAK68D0346Accident · No injuriesClosedBeech B35 · Stockton, CAApr 6, 1968 · N5084C · Substantial damageNTSB LAX68D0344Accident · No injuriesClosedNavion G · Baker, CAFeb 11, 1968 · N4823K · Substantial damageNTSB LAX68D0299Accident · No injuriesClosedBeech C35 · Santa Ana, CAJan 28, 1968 · N8945A · Substantial damage