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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DEN78FA008Accident · 1 fatalClosedPiper PA-28 · Carlsbad, NMNTSB DEN78DQD01Accident · No injuriesClosedPiper PA-24 · Las Cruces, NMNTSB DEN77FQA52Accident · Minor injuriesClosedPiper PA-28 · Aztec, NMNTSB DEN77FQA27Accident · Minor injuriesClosedMooney M20C · Glenwood, NMNTSB DEN77FQA26Accident · Serious injuriesClosedPiper PA-28 · Las Vegas, NMNTSB DEN77DQA11Accident · No injuriesClosedBellanca 8GCBC · Aztec, NMNTSB DEN77FQA08Accident · Minor injuriesClosedPiper PA-28 · Albuquerque, NMNTSB DEN76FQA61Accident · No injuriesClosedBeech 23 · Albuquerque, NMNTSB DEN76FQA53Accident · No injuriesClosedMooney M20C · Albuquerque, NMNTSB DEN76FQA52Accident · No injuriesClosedCessna 177 · Albuquerque, NMNTSB DEN76DQA12Accident · No injuriesClosedBellanca 8GCBC · Farmington, NMNTSB DEN75DQA32Accident · No injuriesClosedHughes 269A · Gallup, NMNTSB DEN75FQA17Accident · No injuriesClosedMooney M20C · Zuni, NMNTSB DEN75FQA12Accident · No injuriesClosedCessna 170B · Albuquerque, NMNTSB DEN74FQA07Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMNTSB DEN73DQD14Accident · No injuriesClosedPiper PA-28 · Alamogordo, NMNTSB DEN73FQA11Accident · No injuriesClosedPiper PA-24 · Reserve, NMNTSB DEN73FQD01Accident · No injuriesClosedCessna 177B · Anapra, NMNTSB DEN72FQA45Accident · No injuriesClosedPiper PA-28 · Gallup, NMNTSB DEN72FQA39Accident · No injuriesClosedPiper PA-24 · Alameda, NMNTSB DEN72FQA10Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMNTSB DEN71DQD15Accident · No injuriesClosedPiper PA-28 · Columbus, NMNTSB DEN71FQA42Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMNTSB DEN71DQA31Accident · No injuriesClosedPiper PA-28 · Taos, NMNTSB DEN71FQA30Accident · Minor injuriesClosedPiper PA-28 · Albuquerque, NMNTSB DEN71DQD01Accident · No injuriesClosedPiper PA-24 · Rodeo, NMNTSB DEN70FQA01Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMNTSB DEN70F0120Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMNTSB DEN70F0123Accident · No injuriesClosedCessna 175 · Hobbs, NMNTSB DEN70F0011Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMNTSB DEN69D0219Accident · No injuriesClosedPiper PA-24 · Hobbs, NMNTSB DEN69D0162Accident · No injuriesClosedMooney M20C · Roswell, NMNTSB DEN69D0110Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMNTSB DEN68D0188Accident · No injuriesClosedPiper PA-28 · Clines Cnrs, NMNTSB DEN68D0115Accident · No injuriesClosedPiper PA-24 · Grady, NMNTSB DEN68F0051Accident · Minor injuriesClosedMooney M20C · Ruidoso, NMNTSB DEN68F0048Accident · Minor injuriesClosedBeech 95 · Albuquerque, NMNTSB DEN67D0289Accident · No injuriesClosedMooney M20C · Deming, NMNTSB DEN67D0212Accident · No injuriesClosedPiper PA-28 · Roswell, NMNTSB DEN67D0090Accident · No injuriesClosedPiper PA-28 · Alamogordo, NMNTSB DEN66F0299Accident · No injuriesClosedMooney 20B · Albuquerque, NMNTSB DEN66F0123Accident · No injuriesClosedCessna 175 · Albuquerque, NMNTSB UNK65X0263Accident · No injuriesClosedMooney M20D · Socorro, NMNTSB UNK64X3340Accident · No injuriesClosedMooney MK20A · Santa Rosa, NMNTSB UNK64X2658Accident · No injuriesClosedPiper PA28 · Rosweell, NM