NTSB investigations: Lycoming O&VO-360 series, WY
4 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “In flight encounter with weather”. 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
| 1983 | 1 |
|---|---|
| 1986 | 1 |
| 2002 | 1 |
| 2007 | 1 |
Where
Open the mapLatest 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\" = 'WY' 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240))
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" = 'WY' 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
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 DEN07FA054Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Centennial, WYthe pilot's inadvertent flight into adverse weather conditions resulting in a loss of aircraft control. Contributing factors include the pilot's improper preflight planning and decision making, the pilot's spatial disorientation, the pilot's lack of night…NTSB DEN02LA075Accident · Serious injuriesLimited investigationFinal reportAmerican General AA5B · Worland, WYthe pilot's selection of an inadequate altitude for crossing mountainous terrain, resulting in a collision with trees. A contributing factor was the downdraft.NTSB DEN87FA008Accident · 1 fatalField investigationFinal reportMooney M20B · Buffalo, WYAt aprx 1720 MDT, tower psnl at the dep arpt received a phone call from the plt. He said he wished to depart with an inop 2-WAY radio. He was advised that IMC prevailed & that a radio would be required to depart with an IFR or special VFR clnc. At 1907 (after…NTSB DEN83FA108Accident · 1 fatalField investigationFinal reportPiper 28-180 · Alpine, WYThe acft collided with mountainous terrain in IMC weather. The pilot had been briefed on the weather. Part of the observation called for mountain obscuration by clouds or precipitation. A person who resides in Alpine, WY said the mountain tops were obscured…