NTSB investigations: Continental IO-520 series, NC

76 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 c.\"eventStateOrRegion\" = 'NC' 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 ATL81DKM02Accident · No injuriesClosedCessna 210 · Marion, NCJan 3, 1981 · N6496C · Substantial damageNTSB ATL80DLJ18Accident · No injuriesClosedCessna 188B · Elizabeth City, NCAug 23, 1980 · N731CX · Substantial damageNTSB IAD80FA037Accident · 1 fatalClosedCessna 401 · Linville, NCApr 7, 1980 · N9912F · DestroyedNTSB IAD80DKM14Accident · No injuriesClosedBeech A36 · Albemarle, NCApr 6, 1980 · N5036M · Substantial damageNTSB IAD80FA023Accident · 2 fatalClosedBellanca 17-30A · Morrisville, NCFeb 12, 1980 · N28027 · DestroyedNTSB IAD79FLJ01Accident · Minor injuriesClosedCessna 210H · Rocky Mt, NCOct 15, 1978 · N5957F · 2 aircraft · Substantial damageNTSB IAD78FA095Accident · No injuriesClosedBeech D-55 · Hickory, NCAug 16, 1978 · N526Q · Substantial damageNTSB IAD78DKM20Accident · Minor injuriesClosedCessna 310F · Liberty, NCAug 16, 1978 · N372WP · Substantial damageNTSB IAD78DLJ13Accident · No injuriesClosedCessna 188T · Fairfield, NCMay 29, 1978 · N53299 · Substantial damageNTSB IAD78FLJ01Accident · No injuriesClosedCessna 188B · Roanoke Rapids, NCSep 30, 1977 · N4496Q · Substantial damageNTSB IAD77FLJ26Accident · No injuriesClosedCessna 188 · Columbia, NCJul 27, 1977 · N9095G · DestroyedNTSB IAD77DLJ31Accident · No injuriesClosedCessna A188B · Merritt, NCJun 24, 1977 · N4756R · Substantial damageNTSB IAD76FLJ28Accident · No injuriesClosedCessna A188B · Battleboro, NCSep 16, 1976 · N4845R · Substantial damageNTSB IAD76DKM38Accident · No injuriesClosedCessna 310 · Greensboro, NCJul 1, 1976 · N5133J · Substantial damageNTSB IAD76FKM19Accident · No injuriesClosedCessna 210 · Gastonia, NCNov 30, 1975 · N5863F · Substantial damageNTSB IAD76FLJ11Accident · No injuriesClosedCessna 188B · Laurinburg, NCSep 30, 1975 · N53162 · Substantial damageNTSB IAD75FLJ34Accident · No injuriesClosedCessna P206 · Washington, NCJun 24, 1975 · N2692X · Substantial damageNTSB IAD75DKM26Accident · Minor injuriesClosedBeech F33A · Beech Mountain, NCApr 18, 1975 · N1675W · Substantial damageNTSB IAD73FLJ21Accident · No injuriesClosedCessna 401A · Morrisville, NCMar 20, 1973 · N501BJ · Substantial damageNTSB NYC73AN044Accident · No injuriesClosedCessna 210L · Davis, NCSep 8, 1972 · N5145Q · Substantial damageNTSB NYC72FLJ24Accident · No injuriesClosedCessna 210G · Apex, NCFeb 4, 1972 · N5891F · Substantial damageNTSB IAD71DKM03Accident · No injuriesClosedBeech V35A · Statesville, NCJul 18, 1970 · N2810A · Substantial damageNTSB IAD70FLJ06Accident · No injuriesClosedBellanca 17-30 · Raleigh, NCMay 30, 1970 · N6622V · Substantial damageNTSB DIA69F0126Accident · No injuriesClosedCessna P206C · Morrisville, NCNov 16, 1968 · N8644Z · Substantial damageNTSB DIA68F0166Accident · No injuriesClosedCessna 210D · Robbinsville, NCFeb 18, 1968 · N3949Y · Substantial damageNTSB DIA68D0135Accident · No injuriesClosedBeech 95-C55 · Engelhard, NCDec 8, 1967 · N4868J · Substantial damage