NTSB investigations: Lycoming 0-320 series, 2000, NY
6 cases on aircraft whose registry engine model is Lycoming 0-320 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 | 9 |
|---|---|
| 1965 | 14 |
| 1966 | 20 |
| 1967 | 16 |
| 1968 | 16 |
| 1969 | 12 |
| 1970 | 18 |
| 1971 | 21 |
| 1972 | 13 |
| 1973 | 15 |
| 1974 | 15 |
| 1975 | 12 |
| 1976 | 17 |
| 1977 | 16 |
| 1978 | 17 |
| 1979 | 10 |
| 1980 | 11 |
| 1981 | 9 |
| 1982 | 7 |
| 1983 | 8 |
| 1984 | 10 |
| 1985 | 9 |
| 1986 | 8 |
| 1987 | 7 |
| 1988 | 4 |
| 1989 | 7 |
| 1990 | 5 |
| 1991 | 5 |
| 1992 | 3 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 6 |
| 1996 | 4 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 7 |
| 2000 | 6 |
| 2001 | 4 |
| 2002 | 4 |
| 2003 | 1 |
| 2004 | 3 |
| 2005 | 5 |
| 2006 | 3 |
| 2007 | 3 |
| 2008 | 2 |
| 2009 | 1 |
| 2010 | 9 |
| 2011 | 4 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 3 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 6 |
| 2021 | 2 |
| 2022 | 3 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 1 |
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\") = 2000
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 ('41508'))
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") = 2000
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 ('41508'))
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 NYC01LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Poughkeepsie, NYThe student pilot's improper recovery from a bounced landing.NTSB NYC00LA220Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Westhampton, NYThe pilot's inadequate flare during the landing. Factors were the entanglement of the tow rope with the rudder horn, and restricted rudder movement.NTSB IAD00LA059Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Dansville, NYthe loss of engine power during take-off for undetermined reasons.NTSB IAD00LA054Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · East North Port, NYThe pilot's failure to maintain adequate rotor RPM and failure to follow published recovery procedures after the low rotor RPM warning horn and caution light activated.NTSB NYC00LA093Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Farmingdale, NYa power loss over unsuitable terrain, for undetermined reason(s).NTSB NYC00LA088Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Conesus, NYThe contamination of the aircraft's fuel. Contributing factors were the pilot's failure to maintain adequate altitude and his diversion of attention during the base turn, dark night conditions, and the tree.