NTSB investigations: Continental IO-520 series, 1978

168 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\") = 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 ('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 MIA78FKJ78Accident · No injuriesClosedBellanca 300 · Pensacola, FLAug 19, 1978 · N39842 · Substantial damageNTSB MIA78DLA48Accident · No injuriesClosedCessna 188B · Colquitt, GAAug 18, 1978 · N9094R · Substantial damageNTSB MIA78FKG53Accident · No injuriesClosedCessna 188B · Cordele, GAAug 16, 1978 · N9449R · DestroyedNTSB IAD78FA095Accident · No injuriesClosedBeech D-55 · Hickory, NCAug 16, 1978 · N526Q · Substantial damageNTSB IAD78DKM20Accident · Minor injuriesClosedCessna 310F · Liberty, NCAug 16, 1978 · N372WP · Substantial damageNTSB FTW78DRJ28Accident · Minor injuriesClosedCessna 188 · Fondale, LAAug 13, 1978 · N70474 · Substantial damageNTSB MKC78DCD41Accident · No injuriesClosedCessna 188B · Yale, IAAug 9, 1978 · N9208R · Substantial damageNTSB FTW78DQG43Accident · No injuriesClosedCessna 188 · Muleshoe, TXAug 6, 1978 · N21860 · Substantial damageNTSB MKC78FA059Accident · Serious injuriesClosedCessna 402A · Manhattan, KSAug 3, 1978 · N4545Q · Substantial damageNTSB MKC78DCQ35Accident · No injuriesClosedCessna 188 · Sharon Spring, KSAug 3, 1978 · N9952G · Substantial damageNTSB NYC78FNC43Accident · Serious injuriesClosedBeech A-36 · Burlington, VTJul 31, 1978 · N25704 · Substantial damageNTSB MKC78FTK33Accident · No injuriesClosedCessna A188B · Doland, SDJul 28, 1978 · N731LH · Substantial damageNTSB SEA78DYE32Accident · No injuriesClosedCessna 185 · Oak Harbor, WAJul 23, 1978 · N94237 · Substantial damageNTSB NYC78DNC40Accident · No injuriesClosedCessna 185 · St Albans, VTJul 21, 1978 · N22901 · Substantial damageNTSB DEN78DTM29Accident · No injuriesClosedCessna 185 · Green River, UTJul 20, 1978 · N94201 · Substantial damageNTSB MKC78DCJ32Accident · No injuriesClosedCessna 188B · Milford, NEJul 19, 1978 · N4921R · Substantial damageNTSB MKC78DCJ31Accident · No injuriesClosedCessna 188B · Crete, NEJul 19, 1978 · N4818R · Substantial damageNTSB MIA78DKQ23Accident · Minor injuriesClosedCessna 188B · Doddsville, MSJul 19, 1978 · N4945Q · DestroyedNTSB ANC78DA056Accident · No injuriesClosedCessna 185 · Big Delta, AKJul 19, 1978 · N22131 · Substantial damageNTSB ANC78FAA28Accident · Minor injuriesClosedCessna 206 · Unalakleet, AKJul 18, 1978 · N625Q · Substantial damageNTSB OAK78DVA56Accident · No injuriesClosedCessna 188 · Turlock, CAJul 16, 1978 · N731LV · Substantial damageNTSB OAK78DXQ35Accident · Minor injuriesClosedBeech A36 · Chester, CAJul 12, 1978 · N17748 · Substantial damageNTSB CHI78FA049Accident · 1 fatalClosedBellanca 17-30A · Rhinelander, WIJul 12, 1978 · N93627 · DestroyedNTSB SEA78FA043Accident · Minor injuriesClosedCessna 207 · Olga, WAJul 11, 1978 · N91041 · DestroyedNTSB IAD78FLQ24Accident · No injuriesClosedCessna 210L · Leitchfield, KYJul 11, 1978 · N1778X · Substantial damageNTSB DEN78FQA39Accident · No injuriesClosedBeech 58 · Albuquerque, NMJul 11, 1978 · N9206Q · Substantial damageNTSB ANC78FA046Accident · No injuriesClosedCessna U206 · Anchorage, AKJul 10, 1978 · N756MD · Substantial damageNTSB MKC78FCG47Accident · No injuriesClosedCessna 210 · Oak Grove, MOJul 8, 1978 · N761AT · Substantial damageNTSB LAX78DUJ77Accident · No injuriesClosedBellanca 17-30 · Ft Huachuca, AZJul 7, 1978 · N6559V · Substantial damageNTSB FTW78DRD46Accident · Serious injuriesClosedCessna 185 · Venice, LAJul 7, 1978 · N103AM · Substantial damageNTSB ANC78FAA27Accident · No injuriesClosedCessna 185 · Unalakleet, AKJul 7, 1978 · N185SH · Substantial damageNTSB MIA78FKG57Accident · No injuriesClosedCessna 188B · Sylvester, GAJul 6, 1978 · N6298G · Substantial damageNTSB FTW78DPG56Accident · No injuriesClosedBeech A36 · Searcy, ARJul 2, 1978 · N710JT · Substantial damageNTSB OAK78DVA52Accident · No injuriesClosedCessna 188B · Modesto, CAJun 30, 1978 · N70063 · Substantial damageNTSB LAX78DUJ73Accident · No injuriesClosedCessna 185F · Scottsdale, AZJun 30, 1978 · N93183 · Substantial damageNTSB SEA78DYM37Accident · No injuriesClosedCessna 188A · Enterprise, ORJun 28, 1978 · N5633J · Substantial damageNTSB ANC78DAG99Accident · No injuriesClosedCessna 185 · Naknek, AKJun 26, 1978 · N70018 · Substantial damageNTSB MKC78FCG39Accident · Serious injuriesClosedBeech A36 · Olathe, KSJun 25, 1978 · N72MB · Substantial damageNTSB CHI78FEV40Accident · No injuriesClosedCessna A188B · Ramsey, ILJun 23, 1978 · N731CF · Substantial damageNTSB MIA78DLA40Accident · Serious injuriesClosedCessna A188B · Whigham, GAJun 22, 1978 · N9435R · DestroyedNTSB MKC78FCQ27Accident · 3 fatalClosedBeech V35 · Hillsboro, KSJun 20, 1978 · N9576Q · DestroyedNTSB MKC78FER59Accident · No injuriesClosedCessna 210 · St Paul, MNJun 18, 1978 · N711TM · Substantial damageNTSB OAK78FVD39Accident · No injuriesClosedCessna T210 · Santa Rosa, CAJun 16, 1978 · N8256M · Substantial damageNTSB CHI78FET23Accident · No injuriesClosedCessna 185 · Berrien Spgs, MIJun 14, 1978 · N1285F · Substantial damageNTSB FTW78FRG50Accident · No injuriesClosedCessna U206C · Austin, TXJun 11, 1978 · N29147 · Substantial damageNTSB DEN78FA044Accident · 1 fatalClosedCessna U206 · Erie, COJun 10, 1978 · N2189F · DestroyedNTSB CHI78FEM20Accident · No injuriesClosedBellanca 17-30 · Plainwell, MIJun 10, 1978 · N4850V · Substantial damageNTSB SEA78FA035Accident · No injuriesClosedCessna U206 · Billings, MTJun 9, 1978 · N2174F · Substantial damageNTSB CHI78DEV38Accident · No injuriesClosedCessna 188 · Ashmore, ILJun 9, 1978 · N4729R · Substantial damageNTSB MIA78FLD50Accident · Serious injuriesClosedBeech V35B · Lake Wales, FLJun 7, 1978 · N4277A · Substantial damage