NTSB investigations: Continental IO-520 series, 1973

88 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\") = 1973
    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 LAX73FUJ84Accident · Serious injuriesClosedBeech G33 · Flagstaff, AZJun 13, 1973 · N1740W · Substantial damageNTSB MIA73FLG48Accident · No injuriesClosedCessna U206C · Little River, SCJun 1, 1973 · N29147 · Substantial damageNTSB FTW73FPG54Accident · No injuriesClosedCessna A188B · Tryonza, ARJun 1, 1973 · N5916G · Substantial damageNTSB FTW73FRG87Accident · No injuriesClosedCessna T210F · Corpus Chrsti, TXMay 28, 1973 · N6756R · Substantial damageNTSB LAX73FUG54Accident · Minor injuriesClosedCessna 185E · Big Bear Cy, CAMay 27, 1973 · N2262T · Substantial damageNTSB FTW73FPM11Accident · No injuriesClosedCessna A188 · Tulsa, OKMay 23, 1973 · N3525Q · Substantial damageNTSB CHI73FEE58Accident · No injuriesClosedCessna 421 · Crystal Lake, ILMay 21, 1973 · N354WP · Substantial damageNTSB IAD73FKW26Accident · No injuriesClosedCessna 210 · Athens, TNMay 20, 1973 · N1822F · Substantial damageNTSB NYC73DFJ24Accident · Minor injuriesClosedCessna A185E · Penn Yan, NYMay 11, 1973 · N4755Q · Substantial damageNTSB DEN73DTC25Accident · No injuriesClosedCessna T210J · Riverton, WYMay 9, 1973 · N2280R · Substantial damageNTSB MKC73DCQ28Accident · Minor injuriesClosedCessna 188 · Mccune, KSMay 2, 1973 · N1556M · DestroyedNTSB CHI73FEE54Accident · No injuriesClosedBellanca 17-30A · Polo, ILMay 1, 1973 · N39816 · Substantial damageNTSB NYC73FGM29Accident · No injuriesClosedBellanca 17-30A · Freidens, PAApr 24, 1973 · N39880 · Substantial damageNTSB DEN73FTE71Accident · No injuriesClosedBeech V35 · Walsenburg, COApr 22, 1973 · N109Q · Substantial damageNTSB DEN73FTE72Accident · No injuriesClosedBeech V35TC · Delta, COApr 19, 1973 · N3705Q · Substantial damageNTSB NYC73DHD35Accident · No injuriesClosedBellanca 14-19 · N.Philadelphia, PAApr 17, 1973 · N7308V · Substantial damageNTSB MIA73FLG42Accident · No injuriesClosedBeech 95-C55 · Orangeburg, SCApr 5, 1973 · N4112 · Substantial damageNTSB DEN73DTM25Accident · No injuriesClosedBeech V35-TC · Hanksville, UTApr 1, 1973 · N9478S · Substantial damageNTSB ANC73DAG81Accident · No injuriesClosedCessna 185E · Kenai, AKMar 30, 1973 · N70183 · Substantial damageNTSB DEN73AD044Accident · Serious injuriesClosedCessna U206 · Las Cruces, NMMar 28, 1973 · N29053 · No damageNTSB IAD73FLQ23Accident · No injuriesClosedCessna 210 · Henderson, KYMar 23, 1973 · N2216R · Substantial damageNTSB FTW73FPJ11Accident · No injuriesClosedBeech 95-C55 · Norman, OKMar 21, 1973 · N2087W · 2 aircraft · Substantial damageNTSB IAD73FLJ21Accident · No injuriesClosedCessna 401A · Morrisville, NCMar 20, 1973 · N501BJ · Substantial damageNTSB ANC73DAG77Accident · No injuriesClosedCessna 185E · Glennallen, AKMar 18, 1973 · N2233T · Substantial damageNTSB CHI73AEE46Accident · Minor injuriesClosedBeech V35 · Mount Morris, ILMar 8, 1973 · N2048W · Substantial damageNTSB MIA73FKQ24Accident · No injuriesClosedCessna A188 · Lexington, MSFeb 27, 1973 · N21886 · Substantial damageNTSB DEN73DTE60Accident · Minor injuriesClosedBeech A36 · Glenwood Spg, COFeb 24, 1973 · N9432Q · Substantial damageNTSB LAX73DUG39Accident · Minor injuriesClosedBellanca 17-30A · Mountn Pass, CAFeb 22, 1973 · N8778V · Substantial damageNTSB MIA73FLD55Accident · No injuriesClosedCessna 172E · Sebring, FLFeb 20, 1973 · N3774S · 2 aircraft · Substantial damageNTSB LAX73DUG36Accident · No injuriesClosedCessna 210D · Big Bear, CAFeb 17, 1973 · N3844Y · Substantial damageNTSB CHI73DEE44Accident · No injuriesClosedCessna P206 · Dixon, ILFeb 17, 1973 · N2543X · Substantial damageNTSB LAX73AL037Accident · Serious injuriesClosedCessna U206C · Kayenta, AZFeb 6, 1973 · N3999G · Substantial damageNTSB OAK73DXQ21Accident · No injuriesClosedCessna P206 · Susanville, CAJan 26, 1973 · N2692X · Substantial damageNTSB FTW73DQG28Accident · No injuriesClosedBellanca 17-30 · Matador, TXJan 26, 1973 · N6633V · Substantial damageNTSB NYC73DFJ18Accident · Serious injuriesClosedBellanca 17-30 · Dunkirk, NYJan 25, 1973 · N4935V · Substantial damageNTSB FTW73FPG36Accident · No injuriesClosedCessna U206B · Hermitage, ARJan 22, 1973 · N3805G · Substantial damageNTSB MKC73FER36Accident · Serious injuriesClosedCessna A185E · Warroad, MNJan 17, 1973 · N5841J · DestroyedNTSB FTW73DRG42Accident · No injuriesClosedCessna 210L · Muzquiz, MexicoJan 15, 1973 · N4616Q · Substantial damage