NTSB investigations: Continental IO-520 series, NM

84 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\" = 'NM' 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 DEN77DQG07Accident · Minor injuriesClosedCessna 188 · Clovis, NMJul 29, 1977 · N4947Q · Substantial damageNTSB DEN77DQA43Accident · No injuriesClosedCessna 188 · Grady, NMJul 11, 1977 · N8010G · Substantial damageNTSB DEN77FQA21Accident · Minor injuriesClosedCessna TU206F · Albuquerque, NMFeb 14, 1977 · N94NM · Substantial damageNTSB DEN77DQD07Accident · No injuriesClosedCessna 411 · Artesia, NMJan 21, 1977 · N411HG · Substantial damageNTSB DEN77DQG01Accident · No injuriesClosedCessna 185E · Clovis, NMJan 4, 1977 · N1204F · Substantial damageNTSB DEN77FQA07Accident · No injuriesClosedBellanca 17-30A · Albuquerque, NMDec 18, 1976 · N8797V · Substantial damageNTSB DEN76FQA46Accident · No injuriesClosedCessna T210 · Los Alamos, NMMay 26, 1976 · N6851R · Substantial damageNTSB DEN76FQA24Accident · No injuriesClosedCessna 206 · Abiquiu, NMNov 10, 1975 · N12007 · Substantial damageNTSB DEN76FQA19Accident · Minor injuriesClosedCessna 206 · Des Moines, NMOct 7, 1975 · N2629X · Substantial damageNTSB DEN76DQA14Accident · No injuriesClosedBeech 58 · Ruidoso, NMAug 31, 1975 · N9027Q · Substantial damageNTSB DEN75FQA50Accident · No injuriesClosedBeech V35B · Albuquerque, NMJun 13, 1975 · N1102W · Substantial damageNTSB DEN75AD057Accident · No injuriesClosedCessna U206E · Farmington, NMMay 21, 1975 · N1459M · Substantial damageNTSB DEN75FQA39Accident · No injuriesClosedCessna 206 · Albuquerque, NMMay 10, 1975 · N5149U · Substantial damageNTSB DEN75FQD15Accident · Minor injuriesClosedCessna A185E · Las Cruces, NMJan 13, 1975 · N5818J · Substantial damageNTSB DEN75DQA10Accident · Minor injuriesClosedCessna 206 · La Vida Msn, NMJul 31, 1974 · N4862F · Substantial damageNTSB DEN75FQA04Accident · No injuriesClosedBeech D55 · Bernalillo, NMJul 12, 1974 · N73681 · Substantial damageNTSB DEN74FQA02Accident · No injuriesClosedCessna 210E · Albuquerque, NMJun 29, 1973 · N4957U · Substantial damageNTSB DEN73AD044Accident · Serious injuriesClosedCessna U206 · Las Cruces, NMMar 28, 1973 · N29053 · No damageNTSB DEN73DQD11Accident · No injuriesClosedBeech A36 · Pinon, NMNov 26, 1972 · N4467A · Substantial damageNTSB DEN73FQD10Accident · No injuriesClosedCessna 210D · Sunland, NMNov 4, 1972 · N3901Y · Substantial damageNTSB DEN73FQA16Accident · Minor injuriesClosedBeech S35 · Albuquerque, NMAug 31, 1972 · N4321S · Substantial damageNTSB DEN72FQA15Accident · No injuriesClosedCessna 411 · Albuquerque, NMAug 30, 1971 · N3236R · Substantial damageNTSB DEN71DQA45Accident · No injuriesClosedCessna 210 · Los Alamos, NMJan 25, 1971 · N6107R · Substantial damageNTSB DEN70F0117Accident · No injuriesClosedBellanca 17-30 · Grants, NMOct 30, 1969 · N4799V · Substantial damageNTSB DEN70F0103Accident · No injuriesClosedCessna A188 · Roswell, NMOct 10, 1969 · N8167V · Substantial damageNTSB DEN69D0138Accident · No injuriesClosedBeech 35C33A · Albuquerque, NMNov 13, 1968 · N8310N · Substantial damageNTSB DEN69D0137Accident · No injuriesClosedCessna 210 · Hobbs, NMNov 9, 1968 · N3772Y · Substantial damageNTSB DEN69A0020Accident · 2 fatalClosedBeech S35 · Las Cruces, NMOct 16, 1968 · N5785K · DestroyedNTSB DEN69F0048Accident · No injuriesClosedCessna 188 · Tucumcari, NMJul 12, 1968 · N8167V · Substantial damageNTSB DEN69F0038Accident · No injuriesClosedBeech 36 · Socorro, NMJul 11, 1968 · N7452N · Substantial damageNTSB DEN69F0013Accident · Minor injuriesClosedCessna TU206 · Santa Fe, NMJun 13, 1968 · N4931F · Substantial damageNTSB DEN68D0263Accident · Minor injuriesClosedCessna 210 · Farmington, NMMar 8, 1968 · N2399F · Substantial damageNTSB DEN68D0088Accident · No injuriesClosedCessna 210 · Cimarron, NMAug 25, 1967 · N2375F · Substantial damageNTSB DEN67D0204Accident · No injuriesClosedCessna 210 · Corona, NMFeb 1, 1967 · N3772Y · Substantial damage