NTSB investigations: Lycoming O&VO-360 series, 2016, TX
7 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
| 1964 | 14 |
|---|---|
| 1965 | 14 |
| 1966 | 14 |
| 1967 | 18 |
| 1968 | 14 |
| 1969 | 7 |
| 1970 | 12 |
| 1971 | 8 |
| 1972 | 9 |
| 1973 | 5 |
| 1974 | 7 |
| 1975 | 7 |
| 1976 | 7 |
| 1977 | 10 |
| 1978 | 9 |
| 1979 | 3 |
| 1980 | 7 |
| 1981 | 3 |
| 1982 | 9 |
| 1983 | 9 |
| 1984 | 4 |
| 1985 | 7 |
| 1986 | 4 |
| 1987 | 5 |
| 1988 | 4 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 5 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 5 |
| 1995 | 5 |
| 1996 | 3 |
| 1997 | 4 |
| 1998 | 3 |
| 1999 | 3 |
| 2000 | 4 |
| 2001 | 4 |
| 2002 | 3 |
| 2003 | 5 |
| 2004 | 4 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 6 |
| 2008 | 5 |
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 4 |
| 2012 | 2 |
| 2014 | 3 |
| 2015 | 3 |
| 2016 | 7 |
| 2017 | 3 |
| 2018 | 6 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 7 |
| 2022 | 1 |
| 2023 | 8 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 5 |
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\") = 2016
AND c.\"eventStateOrRegion\" = 'TX' 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") = 2016
AND c."eventStateOrRegion" = 'TX' 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 CEN17LA010Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-180 · Clarendon, TXThe failure of a cylinder piston pin, which resulted in an obstructed oil inlet screen, reduced the amount of oil available to the engine, and led to the subsequent loss of engine power. Contributing to the accident was the failure of the nonmechanic, who had…NTSB GAA16CA365Accident · No injuriesData collectionFinal reportCessna 172RG · Stamford, TXThe pilot's failure to maintain clearance from a hangar during taxi for departure.NTSB CEN16LA225Accident · Serious injuriesLimited investigationFinal reportPiper PA 24 · Houston, TXThe total loss of engine power due to fuel exhaustion.NTSB CEN16LA249Accident · No injuriesLimited investigationFinal reportAero Commander 100 180 · Port Lavaca, TXLoss of engine power due to failure of a connecting rod.NTSB GAA16CA147Accident · No injuriesData collectionFinal reportPiper PA 28 · Pearland, TXThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and a collision with an airport sign.NTSB CEN16LA121Accident · Serious injuriesLimited investigationFinal reportAriosto James J Ariosto Mustang II · Normangee, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel selector positioning procedures during the flight.NTSB CEN16FA114Accident · 2 fatalField investigationFinal reportOhlgren RV 6A · Abilene, TXThe pilot's failure to maintain airplane control during takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's impairment due to his combined use of central…