NTSB investigations: Lycoming O&VO-360 series, 2001, FL
11 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 | 4 |
|---|---|
| 1965 | 10 |
| 1966 | 12 |
| 1967 | 7 |
| 1968 | 8 |
| 1969 | 5 |
| 1970 | 5 |
| 1971 | 8 |
| 1972 | 5 |
| 1973 | 7 |
| 1974 | 9 |
| 1975 | 3 |
| 1976 | 3 |
| 1977 | 7 |
| 1978 | 7 |
| 1979 | 8 |
| 1980 | 6 |
| 1981 | 10 |
| 1982 | 3 |
| 1983 | 5 |
| 1984 | 3 |
| 1985 | 7 |
| 1986 | 7 |
| 1987 | 4 |
| 1988 | 8 |
| 1989 | 2 |
| 1990 | 6 |
| 1992 | 2 |
| 1993 | 8 |
| 1994 | 5 |
| 1995 | 4 |
| 1996 | 4 |
| 1997 | 4 |
| 1998 | 9 |
| 1999 | 6 |
| 2000 | 3 |
| 2001 | 11 |
| 2002 | 3 |
| 2003 | 6 |
| 2004 | 6 |
| 2005 | 6 |
| 2006 | 5 |
| 2007 | 6 |
| 2008 | 6 |
| 2009 | 5 |
| 2010 | 2 |
| 2011 | 4 |
| 2012 | 4 |
| 2014 | 6 |
| 2015 | 4 |
| 2016 | 4 |
| 2017 | 8 |
| 2018 | 3 |
| 2019 | 4 |
| 2020 | 3 |
| 2021 | 4 |
| 2022 | 3 |
| 2023 | 2 |
| 2024 | 3 |
| 2025 | 6 |
| 2026 | 3 |
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\") = 2001
AND c.\"eventStateOrRegion\" = 'FL' 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") = 2001
AND c."eventStateOrRegion" = 'FL' 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 MIA02LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Deland, FLThe loss of engine power during takeoff/initial climb due to undetermined reasons.NTSB MIA02LA020Accident · No injuriesLimited investigationFinal reportMooney M20C · High Springs, FLThe pilot's improper preflight planning/preparation and failure to ensure sufficient fuel was available to complete the flight, which resulted in fuel exhaustion, a forced landing, and damage to the aircraft when it collided with a fence during the landing…NTSB MIA01LA210Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Fort Lauderdale, FLThe failure of the mechanic who installed the carburetor after overhaul to safety the throttle linkage at the carburetor per an Airworthiness Directive resulting in separation of the throttle linkage and subsequent partial loss of engine power. Contributing…NTSB ATL01LA058Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Brooksville, FLThe fatigue failure of the left main landing gear strut that resulted in collapse of the landing gear.NTSB ATL01LA054Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Zephyrhills, FLThe pilots failure to adequately preflight plan fuel for the flight that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB MIA01LA122Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Dade City, FLthe pilot's inadequate recovery from a bounced landing, and loss of directional control which resulted in an in-flight collision with a fence during the go-around, resulting in a subsequent forced landing in a pasture.NTSB MIA01LA109Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Osteen, FLThe pilot in command, flight instructor's delayed feathering of the right propeller after engine failure resulting in the airplane being unable to maintain altitude with the remaining engine and damage to the airplane during a forced landing in a field.NTSB ATL01LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-24 · Cross City, FLThe fracture of the crankshaft assembly that resulted in a total loss of engine power.NTSB MIA01FA075Accident · 2 fatalField investigationFinal reportBrantly B-2B · Archer, FLThe flight crew's loss of control for undermined reasons.NTSB MIA01LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Milton, FLa loss of right engine power due to chaffed and frayed wiring on the right and left magnetos on the right engine resulting in a forced landing, an inadvertent stall, and subsequent impact with the ground.NTSB MIA01LA057Accident · No injuriesLimited investigationFinal reportMooney M-20C · Jacksonville, FLThe failure of maintenance personnel to properly reconnect the aircraft's elevator control system, resulting in an in-flight disconnection of the elevator control and jamming of the rudder control during climb, the subsequent in-flight loss of control, and…