NTSB investigations: Continental IO-520 series, 1979

149 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\") = 1979
    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 DEN79FTE76Accident · No injuriesClosedBellanca 17-30 · Colorado Sprng, COAug 21, 1979 · N4853V · DestroyedNTSB ANC79DAH12Accident · No injuriesClosedCessna 185 · Sheldons Point, AKAug 16, 1979 · N70048 · Substantial damageNTSB MKC79DTK24Accident · No injuriesClosedCessna 188B · Ashton, SDAug 14, 1979 · N731CS · Substantial damageNTSB NYC79IA075Incident · No injuriesClosedLear Jet 35 · Newark, NJAug 13, 1979 · N35NB · Minor damageNTSB LAX79DUK11Accident · No injuriesClosedBeech E55 · Mesa, AZAug 12, 1979 · N4466W · Substantial damageNTSB NYC79FNC46Accident · Minor injuriesClosedBellanca 17-30 · Panton, VTAug 8, 1979 · N6570V · Substantial damageNTSB MIA79FKG61Accident · No injuriesClosedCessna 188T · Albany, GAAug 8, 1979 · N9822G · Substantial damageNTSB LAX79FVA55Accident · Serious injuriesClosedCessna 188 · Modesto, CAAug 7, 1979 · N70063 · DestroyedNTSB ANC79FA076Accident · 1 fatalClosedCessna 207A · Nikishki, AKAug 7, 1979 · N6469H · Substantial damageNTSB LAX79DXQ31Accident · Minor injuriesClosedCessna 206 · Fallon, NVAug 5, 1979 · N4736F · DestroyedNTSB DEN79FA053Accident · No injuriesClosedCessna TU206 · Ft Collins, COAug 4, 1979 · N4862F · Substantial damageNTSB MKC79FTG13Accident · No injuriesClosedBeech V35 · Bismarck, NDAug 3, 1979 · N911V · Substantial damageNTSB NYC79DFA28Accident · No injuriesClosedCessna 185 · Durham, NYJul 28, 1979 · N601 · Substantial damageNTSB CHI79FEI35Accident · No injuriesClosedBeech 95-C55 · Cleveland, OHJul 25, 1979 · N5740V · Substantial damageNTSB DCA79AA020Accident · 8 fatalClosedDehavilland DH-114 · St Croix, VIJul 24, 1979 · N575PR · DestroyedNTSB SEA79FYA20Accident · No injuriesClosedCessna 188 · Nyssa, ORJul 22, 1979 · N9499R · DestroyedNTSB FTW79FA097Accident · 1 fatalClosedCessna A185F · Lafayette, LAJul 20, 1979 · N4616E · DestroyedNTSB CHI79DEC38Accident · No injuriesClosedBeech D-55 · Troy, MIJul 18, 1979 · N6288V · Substantial damageNTSB CHI79FEK18Accident · Minor injuriesClosedCessna A188B · Alger, OHJul 17, 1979 · N4898Q · Substantial damageNTSB ANC79DAG62Accident · No injuriesClosedCessna 185F · Port Allsworth, AKJul 17, 1979 · N1770R · Substantial damageNTSB MKC79DCJ26Accident · No injuriesClosedCessna 188A · Bassett, NEJul 15, 1979 · N8131V · Substantial damageNTSB MKC79DCJ29Accident · No injuriesClosedCessna A188B · Hartington, NEJul 12, 1979 · N9275R · Substantial damageNTSB ANC79DAG59Accident · No injuriesClosedCessna U206 · Palmer, AKJul 12, 1979 · N9111M · Substantial damageNTSB ANC79DAG76Accident · No injuriesClosedCessna 185E · Soldotna, AKJul 7, 1979 · N2233T · Substantial damageNTSB MIA79FLD73Accident · No injuriesClosedBeech B-55 · Howey, FLJul 5, 1979 · N99RJ · Substantial damageNTSB IAD79DKW16Accident · No injuriesClosedCessna A185 · Elizabethton, TNJul 5, 1979 · N70083 · Substantial damageNTSB LAX79FUM18Accident · No injuriesClosedCessna 210J · Carlsbad, CAJul 1, 1979 · N3384S · Substantial damageNTSB ANC79FA064Accident · Minor injuriesClosedCessna U206F · Kotlik, AKJun 30, 1979 · N1991U · DestroyedNTSB ANC79DA062Accident · No injuriesClosedCessna U206 · Emmonak, AKJun 26, 1979 · N9129M · Substantial damageNTSB SEA79DYM44Accident · Minor injuriesClosedCessna 185 · Madras, ORJun 24, 1979 · N4710Q · Substantial damageNTSB OAK79DV960Accident · No injuriesClosedBellanca 17-30A · Fall River Mil, CAJun 24, 1979 · N4159B · Substantial damageNTSB FTW79FA089Accident · 2 fatalClosedBeech V35B · Pampa, TXJun 23, 1979 · N2028P · DestroyedNTSB IAD79FID20Accident · No injuriesClosedBeech 58 · Keysville, VAJun 15, 1979 · N2018T · Substantial damageNTSB ANC79FA060Accident · No injuriesClosedCessna 207 · Platinum, AKJun 11, 1979 · N6255H · Substantial damageNTSB MIA79FKQ12Accident · No injuriesClosedCessna 188 · Bentonia, MSJun 8, 1979 · N731VY · Substantial damageNTSB OAK79DVA45Accident · Minor injuriesClosedCessna 188B · Hanford, CAJun 6, 1979 · N9157G · DestroyedNTSB SEA79FYK16Accident · No injuriesClosedBeech A36 · Sunriver, ORJun 3, 1979 · N40JH · Substantial damageNTSB MKC79DER44Accident · No injuriesClosedCessna 188 · Gully, MNMay 31, 1979 · N9709G · Substantial damageNTSB OAK79DVG46Accident · No injuriesClosedBeech A-36 · Yuba, CAMay 30, 1979 · N17931 · Substantial damageNTSB OAK79FA032Accident · 3 fatalClosedBeech F33A · Orleans, CAMay 26, 1979 · N6083S · DestroyedNTSB FTW79DPJ21Accident · No injuriesClosedCessna A188B · Cushing, OKMay 26, 1979 · N8358G · Substantial damageNTSB MIA79DLD71Accident · No injuriesClosedCessna 188B · Bushnell, FLMay 25, 1979 · N6679G · Substantial damageNTSB FTW79FRG36Accident · 1 fatalClosedCessna A188B · Falfurrias, TXMay 24, 1979 · N53311 · DestroyedNTSB FTW79DA081Accident · Minor injuriesClosedCessna 185F · Morgan City, LAMay 24, 1979 · N4663E · DestroyedNTSB MIA79DKJ41Accident · No injuriesClosedBeech A36 · Harvest, ALMay 22, 1979 · N23621 · Substantial damageNTSB LAX79FUJ74Accident · No injuriesClosedCessna 207 · Show Low, AZMay 16, 1979 · N7340U · Substantial damageNTSB LAX79FA052Accident · 2 fatalClosedCessna 320E · Tucson, AZMay 8, 1979 · N3432Q · DestroyedNTSB MKC79FCQ21Accident · No injuriesClosedCessna A188B · Minneapolis, KSMay 7, 1979 · N21622 · Substantial damageNTSB MIA79DA105Accident · No injuriesClosedCessna 185 · Jamaica, WNMay 6, 1979 · N561MC · DestroyedNTSB CHI79DEE56Accident · No injuriesClosedCessna P206 · Park Forrest, ILMay 6, 1979 · N4746F · Substantial damage