NTSB investigations: Lycoming O&VO-360 series, 2003, CA
13 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 | 21 |
|---|---|
| 1965 | 21 |
| 1966 | 28 |
| 1967 | 26 |
| 1968 | 13 |
| 1969 | 12 |
| 1970 | 11 |
| 1971 | 18 |
| 1972 | 10 |
| 1973 | 7 |
| 1974 | 12 |
| 1975 | 9 |
| 1976 | 9 |
| 1977 | 10 |
| 1978 | 17 |
| 1979 | 11 |
| 1980 | 12 |
| 1981 | 11 |
| 1982 | 10 |
| 1983 | 10 |
| 1984 | 10 |
| 1985 | 13 |
| 1986 | 13 |
| 1987 | 10 |
| 1988 | 5 |
| 1989 | 7 |
| 1990 | 5 |
| 1991 | 5 |
| 1992 | 2 |
| 1993 | 7 |
| 1994 | 4 |
| 1995 | 7 |
| 1996 | 6 |
| 1997 | 4 |
| 1998 | 8 |
| 1999 | 6 |
| 2000 | 10 |
| 2001 | 7 |
| 2002 | 10 |
| 2003 | 13 |
| 2004 | 10 |
| 2005 | 15 |
| 2006 | 15 |
| 2007 | 5 |
| 2008 | 9 |
| 2009 | 2 |
| 2010 | 6 |
| 2011 | 3 |
| 2012 | 4 |
| 2013 | 7 |
| 2014 | 2 |
| 2015 | 5 |
| 2016 | 6 |
| 2017 | 2 |
| 2018 | 8 |
| 2019 | 2 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 4 |
| 2024 | 1 |
| 2025 | 4 |
| 2026 | 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\") = 2003
AND c.\"eventStateOrRegion\" = 'CA' 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") = 2003
AND c."eventStateOrRegion" = 'CA' 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 LAX04LA073Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Temecula, CAa loss of engine power for undetermined reasons.NTSB LAX04GA051Accident · 2 fatalFinal reportPiper PA-28-180 · Big Bear City, CAThe pilots inadequate preflight planning and intentional flight into known adverse weather conditions. Contributing to this accident was the fact that it was a dark night with no moon illumination.NTSB LAX04LA038Accident · 1 fatalLimited investigationFinal reportCathaway RV-6A · Saticoy, CAA loss of engine power due to fuel exhaustion as a result of a loose B-nut fitting for the carburetor fuel inlet line, which allowed fuel to leak out.NTSB LAX04LA011Accident · No injuriesLimited investigationFinal reportCessna 172RG · Camarillo, CAThe fracture and failure of the left landing gear actuator. Contributing to the accident was the operator's failure to comply with the manufacturer's service bulletin.NTSB LAX04LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · San Rafael, CAa loss of engine power due to fuel exhaustion.NTSB LAX03LA290Accident · No injuriesLimited investigationFinal reportCessna 172RG · Santa Ana, CAthe failure of the right main landing gear pivot assembly.NTSB LAX03LA271Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Watsonville, CAthe non-instrument rated pilot's intentional continuance of VFR flight into instrument meteorological conditions and failure to maintain clearance with terrain.NTSB LAX03CA263Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Pauma Valley, CAthe pilot's failure to maintain an adequate airspeed, which resulted in a stall. The rising terrain was a factor.NTSB LAX03LA172Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Livermore, CAthe pilots acceptance of a clearance meant for another aircraft. Contributing to the accident was the failure of departure controller to detect the pilot's incorrect read back and the controllers improper radio technique, which increased the chances of call…NTSB LAX03LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Santa Maria, CAThe pilot's inadequate in-flight planning/decision resulting in fuel exhaustion which resulted in a total loss of engine power during cruise flight, and a subsequent on-ground collision with a pole and a fence during the ensuing emergency landing.NTSB LAX03LA120Accident · No injuriesLimited investigationFinal reportBeech 19A · Coalinga, CAThe pilot's failure to obtain/maintain an adequate airspeed, which resulted in a stall/mush.NTSB LAX03FA074Accident · 1 fatalField investigationFinal reportBeech 95 · Rancho Cucamong, CAThe fracture and separation of a propeller blade during cruise flight due to fatigue and corrosion pits in the blade pilot bore, and an improper overhaul of the separated propeller by repair station personnel. Factors contributing to the accident were the…NTSB LAX03FA061Accident · 1 fatalField investigationFinal reportMooney M20C · Warner Springs, CAthe pilot's loss of control during flight as a result of incapacitation due to atherosclerotic cardiovascular disease.