NTSB investigations: Continental IO-520 series, 1968

81 cases on aircraft whose registry engine model is Continental IO-520 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\") = 1968
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17032'))
  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 NYC68D0493Accident · No injuriesClosedBeech S35 · Shippenville, PAMay 24, 1968 · N5760K · Substantial damageNTSB OAK69D0057Accident · Serious injuriesClosedCessna 210 · Alturas, CAMay 20, 1968 · N4962U · DestroyedNTSB LAX69F0004Accident · Minor injuriesClosedBeech S35 · Van Nuys, CAMay 8, 1968 · N9018S · Substantial damageNTSB FTW68D0569Accident · Minor injuriesClosedCessna 185 · Houma, LAMay 2, 1968 · N3357L · Substantial damageNTSB LAX68D0415Accident · No injuriesClosedCessna 206B · Winslow, AZApr 16, 1968 · N3406L · Substantial damageNTSB SEA68D0306Accident · No injuriesClosedCessna 206 · Livingston, MTApr 14, 1968 · N5210U · Substantial damageNTSB FTW68D0549Accident · No injuriesClosedBeech S35 · Odessa, TXApr 14, 1968 · N8827M · Substantial damageNTSB MKC68D0524Accident · No injuriesClosedCessna 206 · Shenandoah, IAApr 13, 1968 · N5244U · Substantial damageNTSB CHI68A0087Accident · 2 fatalClosedPiper PA-28 · Columbus, OHApr 10, 1968 · N4239J · 2 aircraft · DestroyedNTSB CHI68D0720Accident · No injuriesClosedBeech 35-C33 · Crystal Lake, ILMar 30, 1968 · N9493S · Substantial damageNTSB MIA68F0513Accident · Minor injuriesClosedCessna 206 · Spartanburg, SCMar 29, 1968 · N5017U · Substantial damageNTSB NYC68D0415Accident · No injuriesClosedCessna 206 · Flushing, NYMar 13, 1968 · N5208U · Substantial damageNTSB LAX68D0350Accident · No injuriesClosedBellanca 17-30 · El Cajon, CAMar 13, 1968 · N4716V · Substantial damageNTSB DEN68D0263Accident · Minor injuriesClosedCessna 210 · Farmington, NMMar 8, 1968 · N2399F · Substantial damageNTSB NYC68F0371Accident · No injuriesClosedBeech 35 · Old Town, MEFeb 25, 1968 · N3114V · Substantial damageNTSB DEN68F0219Accident · No injuriesClosedCessna 210 · Colo.Sprgs, COFeb 24, 1968 · N2387F · Substantial damageNTSB CHI68F0607Accident · No injuriesClosedCessna P206 · Wyoming, MIFeb 24, 1968 · N2620X · Substantial damageNTSB LAX68F0337Accident · No injuriesClosedCessna 402 · Ontario, CAFeb 23, 1968 · N3299Q · Substantial damageNTSB FTW68D0481Accident · No injuriesClosedBeech V-35 · Eufaula, OKFeb 18, 1968 · N7976M · Substantial damageNTSB DIA68F0166Accident · No injuriesClosedCessna 210D · Robbinsville, NCFeb 18, 1968 · N3949Y · Substantial damageNTSB MKC68A0052Accident · Serious injuriesClosedCessna P206A · Fort Madison, IAFeb 12, 1968 · N4653F · Substantial damageNTSB NYC68D0366Accident · No injuriesClosedCessna 210F · Slocum, RIFeb 11, 1968 · N5811F · Substantial damageNTSB FTW68D0460Accident · No injuriesClosedCessna U206 · Little Rock, ARFeb 9, 1968 · N3874G · Substantial damageNTSB MKC68D0438Accident · No injuriesClosedCessna 206 · E Prairie, MSFeb 8, 1968 · N5106U · DestroyedNTSB DEN68F0207Accident · No injuriesClosedBeech V35 · Denver, COJan 29, 1968 · N7096N · Substantial damageNTSB LAX68D0324Accident · No injuriesClosedCessna 210 · Bowie, AZJan 25, 1968 · N4964U · Substantial damageNTSB MKC68F0423Accident · No injuriesClosedBeech V-35 · Dell Rapids, SDJan 17, 1968 · N7895L · Substantial damageNTSB FTW68F0427Accident · No injuriesClosedBeech 95-C55 · Houston, TXJan 11, 1968 · N9490S · Substantial damageNTSB CHI68F0546Accident · Minor injuriesClosedCessna 411A · Elkhart, INJan 10, 1968 · N3254R · Substantial damageNTSB MIA68D0373Accident · No injuriesClosedBellanca 17-30 · Lake Wales, FLJan 5, 1968 · N4757V · Substantial damageNTSB CHI68F0526Accident · No injuriesClosedCessna 320E · Pontiac, MIJan 5, 1968 · N3482Q · Substantial damage