Fatal NTSB investigations: Lycoming O&VO-360 series, NM
12 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 per year
| 1977 | 1 |
|---|---|
| 1978 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1994 | 1 |
| 2008 | 1 |
| 2014 | 1 |
| 2018 | 1 |
| 2019 | 1 |
Where
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 c.\"eventStateOrRegion\" = 'NM' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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."highestInjuryLevel" = 'Fatal'
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 WPR20FA008Accident · 2 fatalClass 3 · FieldFinal reportPiper PA 24 · Angel Fire, NMThe airplane’s degraded performance due to high-density altitude and gusting wind conditions, which resulted in its inability to maintain altitude during the initial takeoff climb. Contributing to the accident was the pilot’s lack of experience with high…NTSB CEN19FA032Accident · 1 fatalField investigationFinal reportMooney M20C · Santa Fe, NMCollision with terrain for reasons that could not be determined based on the available information. Contributing to the accident was the pilot's poor preflight planning and poor decision to depart on the accident flight.NTSB CEN15FA092Accident · 2 fatalField investigationFinal reportPiper PA 28-181 · Vaughn, NMThe noninstrument-rated pilot’s continued flight into night instrument meteorological conditions, which resulted in his failure to maintain clearance from terrain.NTSB CEN09FA010Accident · 2 fatalField investigationFinal reportMaule MXT-7-180A · Santa Teresa, NMThe pilot's decision to takeoff and fly into a thunderstorm.NTSB FTW94FA101Accident · 4 fatalField investigationFinal reportCessna 172RG · Dulce, NMFailure by the pilot in command to properly plan the flight and calculate performance data.NTSB DEN88FA170Accident · 1 fatalField investigationFinal reportBeech B23 · Cimarron, NMThe pilot to properly preflight his aircraft in accordance with the procedures provided in the operators handbook thus causing the engine to lose power following takeoff due to fuel contamination caused by water.NTSB DEN87FA159Accident · 1 fatalField investigationFinal reportMooney M20A · Reserve, NMThe plt was ferrying his acft from Reserve airport, NM, to jewitt mesa airport, apache creek, NM. There was a mature thunderstorm over the northern mountain ridge producing what one witness described as winds 'really blowing hard.' She said she saw the acft…NTSB DEN84FA144Accident · 1 fatalField investigationFinal reportBeech B23 · Ruidoso, NMThe pilot stated that upon landing a gust of wind blew the aircraft off the runway center and he initiated a go-around. Witnesses stated the aircraft climbed to approximately 200 to 300 ft and started a left turn. Engine power appeared to be minimal. As the…NTSB FTW82FQA27Accident · 2 fatalFinal reportCessna 177B · Guadalupita, NMPilot on cross-country impacted the side of a 11,055 foot mountain at the 10,800 foot level. The mountains were obscured at the time.NTSB FTW80DA125Accident · 1 fatalClosedPiper PA-28 · El Rito, NMNTSB DEN78FA023Accident · 1 fatalClosedPiper PA-24 · Pojoaque, NMNTSB DEN78FA008Accident · 1 fatalClosedPiper PA-28 · Carlsbad, NM