NTSB investigations: Continental IO-520 series, 1978, CA

16 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

19652026
NTSB investigations: Continental IO-520 series, 1978, CA per year, 1965–2026: 405 cases
196510
19668
196717
19687
19698
19709
19716
19729
197313
19747
197511
19768
197717
197816
197923
198010
19817
198210
19839
198412
19854
19863
19872
19884
19893
19908
19914
19928
19933
19942
19959
19967
19977
19984
19994
20002
20013
20026
20033
20047
200510
20068
20076
20087
20097
20103
20114
20125
20134
20142
20152
20161
20178
20183
20195
20204
20212
20221
20233
20243
20252
20265

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\") = 1978
    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 ('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 OAK79DVG04Accident · No injuriesClosedCessna T210 · Oroville, CAOct 25, 1978 · N6794R · Substantial damageNTSB OAK78DVA56Accident · No injuriesClosedCessna 188 · Turlock, CAJul 16, 1978 · N731LV · Substantial damageNTSB OAK78DXQ35Accident · Minor injuriesClosedBeech A36 · Chester, CAJul 12, 1978 · N17748 · Substantial damageNTSB OAK78DVA52Accident · No injuriesClosedCessna 188B · Modesto, CAJun 30, 1978 · N70063 · Substantial damageNTSB OAK78FVD39Accident · No injuriesClosedCessna T210 · Santa Rosa, CAJun 16, 1978 · N8256M · Substantial damageNTSB OAK78FVA46Accident · No injuriesClosedBeech V35 · Fresno, CAJun 2, 1978 · N3707Q · Substantial damageNTSB OAK78DVA45Accident · No injuriesClosedCessna 188B · Dos Palos, CAMay 22, 1978 · N4747R · Substantial damageNTSB OAK78FA030Accident · Serious injuriesClosedCessna 411 · Fresno, CAApr 28, 1978 · N3236R · DestroyedNTSB LAX78FUM21Accident · No injuriesClosedCessna A185F · Ramona, CAApr 25, 1978 · N1084F · Substantial damageNTSB OAK78DVD28Accident · No injuriesClosedCessna 185 · Tracy, CAApr 17, 1978 · N7558H · Substantial damageNTSB LAX78DUM20Accident · No injuriesClosedCessna 206 · Imperial, CAApr 7, 1978 · N8619Z · Substantial damageNTSB OAK78DVG24Accident · No injuriesClosedCessna 188 · Locke, CAMar 29, 1978 · N4722Q · Substantial damageNTSB OAK78FVD21Accident · No injuriesClosedCessna 310R · Oakland, CAMar 6, 1978 · N87316 · Substantial damageNTSB OAK78DVA24Accident · No injuriesClosedCessna A188B · Merced, CAFeb 11, 1978 · N9030G · Substantial damageNTSB LAX78FUQ12Accident · No injuriesClosedDowner 17-30 · Lancaster, CAJan 22, 1978 · N4847V · Minor damageNTSB LAX78FUG11Accident · Minor injuriesClosedCessna 210A · La Verne, CAJan 8, 1978 · N6636X · Substantial damage