NTSB investigations: Lycoming 0-320 series, 2013, AZ
5 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 | 7 |
|---|---|
| 1965 | 6 |
| 1966 | 6 |
| 1967 | 5 |
| 1968 | 7 |
| 1969 | 3 |
| 1970 | 7 |
| 1971 | 11 |
| 1972 | 3 |
| 1973 | 6 |
| 1974 | 4 |
| 1975 | 7 |
| 1976 | 9 |
| 1977 | 5 |
| 1978 | 14 |
| 1979 | 9 |
| 1980 | 9 |
| 1981 | 10 |
| 1982 | 14 |
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 7 |
| 1986 | 7 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 9 |
| 1990 | 6 |
| 1991 | 8 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 6 |
| 1995 | 5 |
| 1996 | 4 |
| 1997 | 10 |
| 1998 | 8 |
| 1999 | 5 |
| 2000 | 6 |
| 2001 | 7 |
| 2002 | 13 |
| 2003 | 6 |
| 2004 | 6 |
| 2005 | 9 |
| 2006 | 11 |
| 2007 | 10 |
| 2008 | 7 |
| 2009 | 6 |
| 2010 | 4 |
| 2011 | 3 |
| 2012 | 10 |
| 2013 | 5 |
| 2014 | 7 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 4 |
| 2019 | 4 |
| 2020 | 4 |
| 2021 | 6 |
| 2022 | 5 |
| 2023 | 4 |
| 2024 | 4 |
| 2025 | 1 |
| 2026 | 4 |
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\") = 2013
AND c.\"eventStateOrRegion\" = 'AZ' 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") = 2013
AND c."eventStateOrRegion" = 'AZ' 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 WPR14LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-150 · Tucson, AZThe pilot’s failure to maintain airplane control during takeoff following the loss of left engine power due to the failure of the left engine-driven fuel pump’s diaphragm. Contributing to the accident was the pilot’s failure to use the electric fuel boost…NTSB WPR14CA021Accident · No injuriesData collectionFinal reportPiper PA28 - 160 · Tucson, AZThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion and collison with a runway sign.NTSB WPR13CA219Accident · Serious injuriesData collectionFinal reportPiper PA-28 · Cottonwood, AZThe student pilot's decision to attempt a night landing on an unlit runway, which resulted in a misaligned approach and subsequent collision with a fence. Contributing to the accident was the student pilot's improper set-up of the airplane radios, which…NTSB WPR13CA152Accident · Minor injuriesData collectionFinal reportCessna 172N · Gila Bend, AZThe student pilot's failure to maintain airplane control during an attempted go-around.NTSB WPR13LA113Accident · No injuriesLimited investigationFinal reportCessna 172 · Wilcox, AZThe loss of engine power for reasons that could not be determined because postaccident examination did not reveal any abnormalities that would have precluded normal operation.