Final NTSB investigations: Continental TSIO-520 series, 1976

22 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, 1976 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\") = 1976
    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 CHI77FEE07Accident · Minor injuriesClosedCessna 320 · Wheeling, ILDec 7, 1976 · N234M · Substantial damageNTSB LAX77FUQ11Accident · No injuriesClosedCessna 340 · Santa Ynez, CADec 4, 1976 · N69476 · Substantial damageNTSB OAK77FVD06Accident · No injuriesClosedCessna T210 · Eureka, CANov 26, 1976 · N1650X · Substantial damageNTSB CHI77FEK07Accident · No injuriesClosedCessna 421B · Findlay, OHNov 17, 1976 · N14DB · Substantial damageNTSB DEN77FQA04Accident · Minor injuriesClosedCessna TU206F · Albuquerque, NMNov 11, 1976 · N9678G · Substantial damageNTSB NYC77DFJ04Accident · No injuriesClosedCessna T210L · Hornell, NYNov 2, 1976 · N30266 · Substantial damageNTSB OAK76DVH17Accident · No injuriesClosedCessna 210 · St.Helena, CASep 22, 1976 · N1782X · Substantial damageNTSB MIA76AM108Accident · 5 fatalClosedCessna 414 · Brighton, FLSep 13, 1976 · N8PR · 2 aircraft · DestroyedNTSB OAK76DVD50Accident · No injuriesClosedCessna T210 · Novato, CAAug 8, 1976 · N81PC · Substantial damageNTSB MKC76AK071Accident · No injuriesClosedCessna 401 · Farmington, MOJul 28, 1976 · N4010Q · Substantial damageNTSB MKC76FCD50Accident · No injuriesClosedCessna T210 · Iowa Falls, IAJun 27, 1976 · N1675X · 2 aircraft · Substantial damageNTSB IAD76FLJ25Accident · No injuriesClosedCessna 402B · Wilmington, NCJun 27, 1976 · N4088L · Substantial damageNTSB SEA76DYC55Accident · No injuriesClosedCessna T210L · Mcminnville, ORJun 12, 1976 · N29176 · Substantial damageNTSB OAK76FVM35Accident · No injuriesClosedCessna T310Q · San Francisco, CAMay 8, 1976 · N310DH · Substantial damageNTSB FTW76AF077Accident · 2 fatalClosedCessna 402B · Giddings, TXMar 23, 1976 · N69314 · DestroyedNTSB FTW76DQG58Accident · No injuriesClosedCessna 210 · Sonora, TXMar 22, 1976 · N29169 · Substantial damageNTSB NYC76FGT19Accident · No injuriesClosedCessna T210L · Gaines, PAMar 21, 1976 · N60636 · Substantial damageNTSB DEN76FQA37Accident · Serious injuriesClosedCessna T207 · Gallup, NMMar 10, 1976 · N14450 · Substantial damageNTSB DEN76DTC26Accident · Minor injuriesClosedCessna T210L · Afton, WYFeb 29, 1976 · N4660Q · Substantial damageNTSB OAK76FJA13Accident · Serious injuriesClosedCessna 402A · Honolulu, HIFeb 27, 1976 · N7816Q · 2 aircraft · Substantial damageNTSB OAK76AP044Accident · No injuriesClosedCessna T210L · Oakland, CAFeb 18, 1976 · N2230S · Substantial damageNTSB LAX76AL050Accident · No injuriesClosedCessna T210L · Banning, CAJan 24, 1976 · N6677R · Substantial damage