NTSB investigations: Lycoming O&VO-360 series, 2002, UT
6 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
| 1966 | 1 |
|---|---|
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 2 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1978 | 4 |
| 1979 | 5 |
| 1980 | 1 |
| 1981 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 2 |
| 2001 | 1 |
| 2002 | 6 |
| 2003 | 5 |
| 2004 | 2 |
| 2005 | 2 |
| 2007 | 3 |
| 2008 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2023 | 4 |
| 2024 | 1 |
| 2025 | 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 year(c.\"eventDate\") = 2002
AND c.\"eventStateOrRegion\" = 'UT' 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 year(c."eventDate") = 2002
AND c."eventStateOrRegion" = 'UT' 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 DEN03LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Vernal, UTthe pilot's improper in-flight planning/decision. Factors contributing to the accident were fuel exhaustion and the fog.NTSB DEN03LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Salt Lake City, UTfuel exhaustion as a result of the pilot's inadequate preflight planning. A contributing factor was the pilot's decision to continue the flight without stopping for fuel.NTSB DEN03LA006Accident · No injuriesLimited investigationFinal reportMooney M20B · Loa, UTthe pilot's inadvertent placement of the fuel selector position in the off position. A contributing factor was the pilot's lack of familiarity with the aircraft.NTSB DEN02FA089Accident · 4 fatalField investigationFinal reportMooney M20A · Marysvale, UTthe pilot's poor in-flight decision to fly so close to the ridge (looking for animals). Contributing factors were the mountainous terrain condition, the downdraft weather conditions in high mountains, and the high density altitude weather condition.NTSB DEN02LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172Q · Fruitland, UTthe pilot's failure to apply carburetor heat. Contributing factors included carburetor icing conditions, the unavailability of suitable terrain on which to make a forced landing, and night conditions.NTSB DEN02LA022Accident · No injuriesLimited investigationFinal reportCessna 175 · St. George, UTThe student pilot's failure to maintain aircraft directional control during take off roll.