NTSB investigations: Continental O-470 series, NM

126 cases on aircraft whose registry engine model is Continental O-470 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 ('17026'))
  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 FTW84LA080Accident · No injuriesLimited investigationFinal reportCessna 180A · Portales, NMThe plt had made a successful landing in an unimproved wheat field. The acft had stopped & as the plt was making a 180 deg turn back the wind caught a wing causing the acft to nose over onto its back. The plt stated that during the turn the right main gear…Nov 26, 1983 · N5212D · Substantial damageNTSB FTW84FA032Accident · 1 fatalField investigationFinal reportCessna 182Q · Columbus, NMThe non-instrument rated plt departed imperial, CA, at 2010 PDT, & shortly thereafter, was identified & followed by a U.S. Customs special mission acft. The acft was followed to demming, NM. During that portion of the flt, its altitude varied from about 500…Oct 27, 1983 · N735CP · DestroyedNTSB FTW84LA017Accident · No injuriesLimited investigationFinal reportCessna 310B · Santa Fe, NMWhile practicing landings, the left eng power was reduced to simulate an eng failure while the acft was on downwind. The student retracted the gear & continued the apch, but forgot to reextend the gear. The instructor also forgot & the acft was landed with…Oct 12, 1983 · N5560V · Substantial damageNTSB FTW82DA395Accident · Minor injuriesFinal reportCessna 182B · Albuquerque, NMThe pilot undershot the runway following an engine failure on final approach. The pilot had been flying 4.7 hours on a cross-country flight when engine quit. The aircraft was out of fuel. The optimum endurance is 4.6 hours. The pilot had figured on 7 gallon…Sep 25, 1982 · N2389G · Substantial damageNTSB FTW82DA298Accident · No injuriesFinal reportCessna 182E · Albuquerque, NMThe pilot stated that after a normal approach, the aircraft touched down at about 90 mph on the first 1/4 to 1/3 of the runway. He raised the flaps and applied brakes. He noticed that there was insufficient braking action to stop on the wet runway, but by the…Jul 28, 1982 · N3013Y · Substantial damageNTSB FTW80FQA30Accident · No injuriesClosedCessna 180K · Santa Fe, NMJul 6, 1980 · N2868K · Substantial damageNTSB DEN80FQA21Accident · No injuriesClosedCessna 182 · Taos, NMMar 9, 1980 · N8598T · Substantial damageNTSB DEN80FQA19Accident · Serious injuriesClosedBeech A-45 · Taos, NMFeb 25, 1980 · N421NM · Substantial damageNTSB DEN80DQD02Accident · Minor injuriesClosedCessna 182N · Hacienda Sr Ln, NMNov 9, 1979 · N9128G · Substantial damageNTSB DEN80FA007Accident · 1 fatalClosedCessna 182P · Farmington, NMOct 29, 1979 · N1987M · DestroyedNTSB DEN79DQA34Accident · No injuriesClosedCessna 182 · Roswell, NMJul 1, 1979 · N8304S · Substantial damageNTSB DEN79DQD11Accident · No injuriesClosedCessna 182Q · Timberon, NMJun 2, 1979 · N759UP · Substantial damageNTSB DEN79DQD10Accident · No injuriesClosedCessna 180 · Las Cruces, NMMay 26, 1979 · N9004C · Substantial damageNTSB DEN79FQD08Accident · Minor injuriesClosedCessna 182 · Deming, NMMay 13, 1979 · N8890T · Substantial damageNTSB DEN79FQA13Accident · No injuriesClosedCessna C-182P · Albuquerque, NMJan 8, 1979 · N1779M · Substantial damageNTSB DEN79FQA03Accident · No injuriesClosedCessna 182P · Grants, NMOct 24, 1978 · N7354Q · Substantial damageNTSB DEN78FQA58Accident · Minor injuriesClosedCessna 182 · L1ndrith, NMSep 16, 1978 · N3918D · Substantial damageNTSB DEN78FQA54Accident · No injuriesClosedCessna 182 · Farmington, NMSep 8, 1978 · N8812X · Substantial damageNTSB DEN78FA013Accident · 3 fatalClosedCessna 182 · Socorro, NMDec 8, 1977 · N6488A · DestroyedNTSB DEN77FQA45Accident · No injuriesClosedCessna T210 · Abiquiu, NMJul 15, 1977 · N59181 · Substantial damageNTSB DEN77DQG02Accident · No injuriesClosedCessna 180H · Jal, NMJan 12, 1977 · N91402 · Substantial damageNTSB DEN77DQA05Accident · No injuriesClosedCessna 182 · Farmington, NMNov 21, 1976 · N5581B · Substantial damageNTSB DEN76FQA48Accident · No injuriesClosedCessna 180 · Farmington, NMJun 5, 1976 · N3228D · Substantial damageNTSB DEN76FQA39Accident · No injuriesClosedCessna 182A · Espanola, NMMar 25, 1976 · N3995D · Substantial damageNTSB DEN76FQA23Accident · Serious injuriesClosedCessna 180 · Zuni, NMNov 7, 1975 · N2420C · DestroyedNTSB DEN75FQD23Accident · No injuriesClosedCessna 182 · Las Cruces, NMMay 24, 1975 · N58947 · Substantial damageNTSB DEN75DQA46Accident · No injuriesClosedCessna 182E · Roy, NMMay 21, 1975 · N9327X · Substantial damageNTSB DEN75DQA45Accident · No injuriesClosedCessna 180 · Cimarron, NMMay 21, 1975 · N5219D · Substantial damageNTSB DEN75DQG08Accident · No injuriesClosedCessna 182B · Clovis, NMApr 17, 1975 · N2584G · Substantial damageNTSB DEN75DQA36Accident · No injuriesClosedCessna 182 · Albuquerque, NMMar 14, 1975 · N8568S · Substantial damageNTSB DEN75DQA35Accident · No injuriesClosedCessna 182 · Gallup, NMFeb 22, 1975 · N7343N · Substantial damageNTSB DEN74FQA47Accident · No injuriesClosedCessna 182B · Farmington, NMMay 29, 1974 · N2308G · Substantial damageNTSB DEN74FQD21Accident · No injuriesClosedCessna 182K · Ruidoso, NMMay 4, 1974 · N2504R · Substantial damageNTSB DEN74FQA27Accident · No injuriesClosedCessna 182 · Albuquerque, NMDec 17, 1973 · N9363G · Substantial damageNTSB DEN74DQA22Accident · No injuriesClosedCessna 182G · Mid Valley, NMOct 31, 1973 · N2496R · Substantial damageNTSB DEN74DQA16Accident · No injuriesClosedCessna 182 · Gallop, NMSep 4, 1973 · N91288 · Substantial damageNTSB DEN72FQA36Accident · Minor injuriesClosedCessna 180 · Albuquerque, NMApr 8, 1972 · N3128D · Substantial damageNTSB DEN72FQA33Accident · No injuriesClosedCessna 182 · Ruidoso, NMFeb 19, 1972 · N8932G · Substantial damageNTSB DEN71DQA55Accident · No injuriesClosedCessna 182G · Albuquerque, NMMay 19, 1971 · N2351R · Substantial damageNTSB DEN70DQG06Accident · No injuriesClosedCessna 180A · Clovis, NMMar 9, 1970 · N9613B · Substantial damageNTSB DEN69D0253Accident · No injuriesClosedCessna 182E · Albuquerque, NMMay 31, 1969 · N3000Y · Substantial damageNTSB DEN69A0036Accident · 2 fatalClosedCessna 180 · Tucumcari, NMMar 7, 1969 · N3371D · DestroyedNTSB DEN69D0175Accident · No injuriesClosedCessna 182 · Reserve, NMJan 30, 1969 · N4749D · Substantial damageNTSB DEN69F0196Accident · No injuriesClosedCessna 310 · Albuquerque, NMJan 12, 1969 · N111R · Substantial damageNTSB DEN69D0082Accident · No injuriesClosedCessna 182K · Albuquerque, NMAug 30, 1968 · N2625Q · Substantial damageNTSB DEN69F0066Accident · Minor injuriesClosedCessna 182K · Mountainair, NMAug 12, 1968 · N2494Q · Substantial damageNTSB DEN69F0065Accident · No injuriesClosedCessna 180 · Las Cruces, NMJul 5, 1968 · N180Y · Substantial damageNTSB DEN68F0159Accident · No injuriesClosedCessna 182 · Albuquerque, NMDec 8, 1967 · N2030G · Substantial damageNTSB DEN68D0162Accident · No injuriesClosedCessna 182 · Hobbs, NMNov 30, 1967 · N5626B · Substantial damageNTSB DEN68D0161Accident · No injuriesClosedCessna 182 · Chama, NMNov 23, 1967 · N2263G · Substantial damage