NTSB investigations: Lycoming O&VO-360 series, 2016, NY
5 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 | 2 |
|---|---|
| 1965 | 11 |
| 1966 | 8 |
| 1967 | 3 |
| 1968 | 4 |
| 1969 | 7 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 4 |
| 1973 | 5 |
| 1974 | 5 |
| 1975 | 3 |
| 1976 | 7 |
| 1977 | 2 |
| 1978 | 9 |
| 1979 | 4 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 4 |
| 1983 | 1 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 4 |
| 1990 | 1 |
| 1991 | 2 |
| 1993 | 2 |
| 1994 | 4 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2003 | 7 |
| 2005 | 2 |
| 2007 | 2 |
| 2008 | 1 |
| 2010 | 3 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 5 |
| 2021 | 3 |
| 2024 | 3 |
Where
Latest 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\" = 'NY' 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" = 'NY' 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 GAA16CA427Accident · No injuriesData collectionFinal reportPiper PA28 · Hamburg, NYThe pilot's failure to perform a go-around, which resulted in a landing area overshoot, a runway overrun, a landing gear collapse, and a collision with a guard rail.NTSB ERA16LA286Accident · Minor injuriesLimited investigationFinal reportCessna 177 · McDonough, NYThe pilot’s improper recovery from a slow flight configuration at low altitude, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot’s decision to operate at low…NTSB ERA16LA234Accident · No injuriesLimited investigationFinal reportPiper PA28 · Poughkeepsie, NYAn overstress failure of the left main landing gear attachment bolts, which resulted in the left main landing gear collapse.NTSB ERA16LA192Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Batavia, NYThe student pilot's failure to maintain directional control during takeoff, which resulted in a collision with runway signs.NTSB ERA16LA109Accident · 1 fatalLimited investigationFinal reportPiper PA28 · Port Jefferson, NYThe flight instructor's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.