NTSB investigations: Lycoming O&VO-360 series, NM

95 cases on aircraft whose registry engine model is Lycoming O&VO-360 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 ('41514'))
  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 DEN78FA008Accident · 1 fatalClosedPiper PA-28 · Carlsbad, NMNov 25, 1977 · N2665T · Substantial damageNTSB DEN78DQD01Accident · No injuriesClosedPiper PA-24 · Las Cruces, NMOct 13, 1977 · N510GQ · Substantial damageNTSB DEN77FQA52Accident · Minor injuriesClosedPiper PA-28 · Aztec, NMSep 4, 1977 · N1344H · Substantial damageNTSB DEN77FQA27Accident · Minor injuriesClosedMooney M20C · Glenwood, NMApr 3, 1977 · N6735N · Substantial damageNTSB DEN77FQA26Accident · Serious injuriesClosedPiper PA-28 · Las Vegas, NMMar 8, 1977 · N5122G · DestroyedNTSB DEN77DQA11Accident · No injuriesClosedBellanca 8GCBC · Aztec, NMJan 5, 1977 · N8658V · Substantial damageNTSB DEN77FQA08Accident · Minor injuriesClosedPiper PA-28 · Albuquerque, NMDec 26, 1976 · N7585R · Substantial damageNTSB DEN76FQA61Accident · No injuriesClosedBeech 23 · Albuquerque, NMAug 16, 1976 · N9150S · Substantial damageNTSB DEN76FQA53Accident · No injuriesClosedMooney M20C · Albuquerque, NMJul 7, 1976 · N6466U · Substantial damageNTSB DEN76FQA52Accident · No injuriesClosedCessna 177 · Albuquerque, NMJul 2, 1976 · N3147T · Substantial damageNTSB DEN76DQA12Accident · No injuriesClosedBellanca 8GCBC · Farmington, NMAug 23, 1975 · N8658V · Substantial damageNTSB DEN75DQA32Accident · No injuriesClosedHughes 269A · Gallup, NMFeb 9, 1975 · N8810F · Substantial damageNTSB DEN75FQA17Accident · No injuriesClosedMooney M20C · Zuni, NMSep 2, 1974 · N6445U · Substantial damageNTSB DEN75FQA12Accident · No injuriesClosedCessna 170B · Albuquerque, NMAug 21, 1974 · N2546C · Substantial damageNTSB DEN74FQA07Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMJul 13, 1973 · N9602J · Substantial damageNTSB DEN73DQD14Accident · No injuriesClosedPiper PA-28 · Alamogordo, NMJan 21, 1973 · N6502J · Substantial damageNTSB DEN73FQA11Accident · No injuriesClosedPiper PA-24 · Reserve, NMAug 17, 1972 · N6755P · Substantial damageNTSB DEN73FQD01Accident · No injuriesClosedCessna 177B · Anapra, NMJul 2, 1972 · N34021 · Substantial damageNTSB DEN72FQA45Accident · No injuriesClosedPiper PA-28 · Gallup, NMJun 27, 1972 · N6362J · Substantial damageNTSB DEN72FQA39Accident · No injuriesClosedPiper PA-24 · Alameda, NMMay 4, 1972 · N6359P · Substantial damageNTSB DEN72FQA10Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMAug 9, 1971 · N5374L · Substantial damageNTSB DEN71DQD15Accident · No injuriesClosedPiper PA-28 · Columbus, NMFeb 26, 1971 · N7926N · Substantial damageNTSB DEN71FQA42Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMJan 17, 1971 · N7472W · Substantial damageNTSB DEN71DQA31Accident · No injuriesClosedPiper PA-28 · Taos, NMNov 28, 1970 · N9618J · Substantial damageNTSB DEN71FQA30Accident · Minor injuriesClosedPiper PA-28 · Albuquerque, NMNov 25, 1970 · N9101J · Substantial damageNTSB DEN71DQD01Accident · No injuriesClosedPiper PA-24 · Rodeo, NMJul 25, 1970 · N5134P · Substantial damageNTSB DEN70FQA01Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMJan 5, 1970 · N5666P · Substantial damageNTSB DEN70F0120Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMNov 8, 1969 · N5656P · Substantial damageNTSB DEN70F0123Accident · No injuriesClosedCessna 175 · Hobbs, NMNov 3, 1969 · N7664M · Substantial damageNTSB DEN70F0011Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMJun 19, 1969 · N6311P · Substantial damageNTSB DEN69D0219Accident · No injuriesClosedPiper PA-24 · Hobbs, NMApr 9, 1969 · N5407P · Substantial damageNTSB DEN69D0162Accident · No injuriesClosedMooney M20C · Roswell, NMJan 1, 1969 · N6894U · Substantial damageNTSB DEN69D0110Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMOct 13, 1968 · N8419W · Substantial damageNTSB DEN68D0188Accident · No injuriesClosedPiper PA-28 · Clines Cnrs, NMDec 18, 1967 · N9671J · Substantial damageNTSB DEN68D0115Accident · No injuriesClosedPiper PA-24 · Grady, NMSep 14, 1967 · N8029P · Substantial damageNTSB DEN68F0051Accident · Minor injuriesClosedMooney M20C · Ruidoso, NMAug 15, 1967 · N5981Q · Substantial damageNTSB DEN68F0048Accident · Minor injuriesClosedBeech 95 · Albuquerque, NMJun 17, 1967 · N2038C · Substantial damageNTSB DEN67D0289Accident · No injuriesClosedMooney M20C · Deming, NMMay 8, 1967 · N3482X · Substantial damageNTSB DEN67D0212Accident · No injuriesClosedPiper PA-28 · Roswell, NMFeb 4, 1967 · N7786W · Substantial damageNTSB DEN67D0090Accident · No injuriesClosedPiper PA-28 · Alamogordo, NMJul 4, 1966 · N7574W · Substantial damageNTSB DEN66F0299Accident · No injuriesClosedMooney 20B · Albuquerque, NMMay 10, 1966 · N74516 · Substantial damageNTSB DEN66F0123Accident · No injuriesClosedCessna 175 · Albuquerque, NMSep 30, 1965 · N7062M · Substantial damageNTSB UNK65X0263Accident · No injuriesClosedMooney M20D · Socorro, NMOct 13, 1964 · N6830U · Substantial damageNTSB UNK64X3340Accident · No injuriesClosedMooney MK20A · Santa Rosa, NMAug 12, 1964 · N1080C · Substantial damageNTSB UNK64X2658Accident · No injuriesClosedPiper PA28 · Rosweell, NMJul 5, 1964 · N7486W · Substantial damage