Final NTSB investigations: Continental TSIO-520 series, 1977

21 cases on aircraft whose registry engine model is Continental TSIO-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

19662026
Final NTSB investigations: Continental TSIO-520 series, 1977 per year, 1966–2026: 1,647 cases
19663
19681
19692
19701
19712
19723
19734
197412
19758
197622
197721
197837
197954
198044
198154
198260
198340
198444
198547
198653
198736
198828
198923
199025
199130
199223
199324
199432
199525
199633
199729
199823
199926
200031
200142
200236
200354
200438
200535
200655
200741
200836
200928
201047
201124
201225
201329
201420
201521
201619
201732
201829
201921
202025
202124
202219
202323
202413
20256
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\") = 1977
    AND c.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17040'))
  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 MKC78DER19Accident · No injuriesClosedCessna 310Q · Rochester, MNDec 29, 1977 · N310JP · Substantial damageNTSB DEN78DTC08Accident · No injuriesClosedCessna T210L · Thayne, WYDec 6, 1977 · N4660Q · Substantial damageNTSB SEA78DYK02Accident · No injuriesClosedCessna T210 · Redmond, ORNov 23, 1977 · N94001 · Substantial damageNTSB FTW78DRD08Accident · No injuriesClosedCessna 210 · New Orleans, LANov 13, 1977 · N732CS · Substantial damageNTSB LAX78DUJ10Accident · Minor injuriesClosedCessna 210K · Benson, AZNov 12, 1977 · N9484M · Substantial damageNTSB IAD78DKW02Accident · No injuriesClosedCessna 414 · Oneida, TNOct 28, 1977 · N1603T · Substantial damageNTSB OAK78DVA01Accident · No injuriesClosedCessna 210L · Fresno, CAOct 4, 1977 · N1675X · Substantial damageNTSB SEA77FA056Accident · 1 fatalClosedCessna 206 · Cove, ORSep 28, 1977 · N35904 · DestroyedNTSB LAX77DUG54Accident · No injuriesClosedCessna 340 · Riverside, CAJul 6, 1977 · N1701G · Substantial damageNTSB LAX77FA052Accident · 1 fatalClosedCessna 340A · Corona, CAJun 20, 1977 · N98621 · DestroyedNTSB LAX77DUJ57Accident · Minor injuriesClosedCessna 210 · Estrella, AZJun 7, 1977 · N732EC · Substantial damageNTSB FTW770A003Accident · No injuriesClosedCessna 207 · Matamoros, MexicoJun 6, 1977 · N1520U · Substantial damageNTSB DEN77FTE53Accident · No injuriesClosedCessna 206 · Glenwood Spgs, COJun 2, 1977 · N71516 · Substantial damageNTSB LAX77FUJ45Accident · No injuriesClosedCessna T310Q · Santa Rosa, AZApr 27, 1977 · N310TT · Substantial damageNTSB FTW77FQD15Accident · No injuriesClosedCessna T310Q · El Paso, TXApr 10, 1977 · N650PC · Substantial damageNTSB LAX77OA005Accident · No injuriesClosedCessna 210 · Santa Inez, MexicoFeb 15, 1977 · N999PC · Minor damageNTSB NYC77DNC21Accident · No injuriesClosedCessna 414 · Carabasset, MEFeb 14, 1977 · N5264J · Substantial damageNTSB CHI77FA027Accident · No injuriesClosedCessna 402A · Peoria, ILFeb 7, 1977 · N87275 · Substantial damageNTSB LAX77DUQ15Accident · No injuriesClosedCessna T210M · Camarillo, CAFeb 6, 1977 · N13DJ · Substantial damageNTSB NYC77DNC20Accident · No injuriesClosedCessna 402 · Bennington, VTFeb 3, 1977 · N4090L · Substantial damageNTSB LAX77OA004Accident · Serious injuriesClosedCessna 210L · Puerta Vlarta, MexicoJan 27, 1977 · N5121V · Destroyed