Fatal NTSB investigations: Continental IO-520 series, 1979

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

19642026
Fatal NTSB investigations: Continental IO-520 series, 1979 per year, 1964–2026: 666 cases
19641
19663
19671
19684
19694
19702
19725
19731
19741
19753
19769
19776
197817
197930
198015
198115
198222
198321
198413
19857
198613
19875
198818
19899
19909
199111
19929
19939
19946
199512
199611
19979
199812
199913
20008
200119
200217
200320
200421
200526
200616
200718
200815
200910
201014
201122
20129
20136
201414
201511
20168
20176
201810
201916
202013
202110
20226
20234
20247
20256
20268

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\") = 1979
    AND c.\"highestInjuryLevel\" = 'Fatal'
    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 SEA80FA011Accident · 2 fatalClosedBeech V35A · Sublett, IDDec 7, 1979 · N7950R · DestroyedNTSB CHI80FA012Accident · 3 fatalClosedCessna 210L · Fort Wayne, INNov 25, 1979 · N2034S · DestroyedNTSB FTW80FA008Accident · 1 fatalClosedBeech C55 · Fordyce, AROct 25, 1979 · N9466S · DestroyedNTSB DEN81FA066Accident · 4 fatalClosedBeech C33 · Dubois, WYOct 22, 1979 · N60234 · DestroyedNTSB LAX80FA006Accident · 2 fatalClosedBeech V35B · Lucerne Valley, CAOct 20, 1979 · N6641S · DestroyedNTSB MIA80FA001Accident · 2 fatalClosedCessna 210 · Osteen, FLOct 7, 1979 · N1738X · DestroyedNTSB NYC79FA105Accident · 3 fatalClosedBeech 35C33A · Warren, VTSep 24, 1979 · N1984S · DestroyedNTSB LAX79IA082Incident · 1 fatalClosedCessna 210 · Tucson, AZSep 14, 1979 · N6125F · No damageNTSB DEN79FA061Accident · 2 fatalClosedBeech A-36 · Garfield, COSep 14, 1979 · N2847W · DestroyedNTSB NYC79FA092Accident · 1 fatalClosedBellanca 17-30A · Hanover, PASep 9, 1979 · N102CB · DestroyedNTSB ANC79FA076Accident · 1 fatalClosedCessna 207A · Nikishki, AKAug 7, 1979 · N6469H · Substantial damageNTSB DCA79AA020Accident · 8 fatalClosedDehavilland DH-114 · St Croix, VIJul 24, 1979 · N575PR · DestroyedNTSB FTW79FA097Accident · 1 fatalClosedCessna A185F · Lafayette, LAJul 20, 1979 · N4616E · DestroyedNTSB FTW79FA089Accident · 2 fatalClosedBeech V35B · Pampa, TXJun 23, 1979 · N2028P · DestroyedNTSB OAK79FA032Accident · 3 fatalClosedBeech F33A · Orleans, CAMay 26, 1979 · N6083S · DestroyedNTSB FTW79FRG36Accident · 1 fatalClosedCessna A188B · Falfurrias, TXMay 24, 1979 · N53311 · DestroyedNTSB LAX79FA052Accident · 2 fatalClosedCessna 320E · Tucson, AZMay 8, 1979 · N3432Q · DestroyedNTSB FTW79FA076Accident · 3 fatalClosedCessna 320E · Covington, LAApr 22, 1979 · N3482Q · DestroyedNTSB ANC797A014Accident · 2 fatalClosedCessna U206 · Nightmute, AKMar 22, 1979 · N733CT · Substantial damageNTSB LAX79FA046Accident · 2 fatalClosedCessna 310R · Heber, AZMar 17, 1979 · N3424G · DestroyedNTSB DEN79FA023Accident · 4 fatalClosedCessna 206 · Moose, WYFeb 24, 1979 · N114CK · DestroyedNTSB FTW79FA052Accident · 1 fatalClosedCessna 210G · Jennings, LAFeb 23, 1979 · N687ST · DestroyedNTSB OAK79FA016Accident · 2 fatalClosedBeech A36 · San Jose, CAFeb 20, 1979 · N8571R · DestroyedNTSB MIA80FA051Accident · 1 fatalClosedBeech S35 · Horseshoe Bch, FLFeb 15, 1979 · N238H · DestroyedNTSB FTW79FA046Accident · 1 fatalClosedBellanca 17-30A · Bryans Corner, OKFeb 11, 1979 · N28175 · 2 aircraft · DestroyedNTSB ANC79FA033Accident · 1 fatalClosedCessna U206 · Cape Romanzof, AKJan 19, 1979 · N4970C · DestroyedNTSB MKC79FA014Accident · 1 fatalClosedCessna 210L · Junction City, KSJan 12, 1979 · N4685Q · DestroyedNTSB OAK79FA014Accident · 3 fatalClosedCessna 182Q · Truckee, CAJan 9, 1979 · N759YF · DestroyedNTSB MIA79DA038Accident · 3 fatalClosedCessna 210G · Gt Inagua, Burkina FasoJan 6, 1979 · N5853F · DestroyedNTSB MIA79FA035Accident · 1 fatalClosedCessna 310R · Madison, MSJan 5, 1979 · N303LA · Destroyed