NTSB investigations: Lycoming 0-320 series, 2003, MI
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 | 8 |
|---|---|
| 1965 | 11 |
| 1966 | 11 |
| 1967 | 15 |
| 1968 | 15 |
| 1969 | 14 |
| 1970 | 10 |
| 1971 | 9 |
| 1972 | 13 |
| 1973 | 8 |
| 1974 | 12 |
| 1975 | 7 |
| 1976 | 15 |
| 1977 | 10 |
| 1978 | 8 |
| 1979 | 9 |
| 1980 | 8 |
| 1981 | 8 |
| 1982 | 10 |
| 1983 | 16 |
| 1984 | 6 |
| 1985 | 5 |
| 1986 | 8 |
| 1987 | 5 |
| 1988 | 7 |
| 1989 | 2 |
| 1990 | 4 |
| 1991 | 9 |
| 1992 | 7 |
| 1993 | 7 |
| 1994 | 6 |
| 1995 | 7 |
| 1996 | 3 |
| 1997 | 5 |
| 1998 | 3 |
| 1999 | 5 |
| 2000 | 5 |
| 2001 | 8 |
| 2002 | 2 |
| 2003 | 5 |
| 2004 | 5 |
| 2005 | 3 |
| 2006 | 6 |
| 2007 | 6 |
| 2008 | 1 |
| 2010 | 5 |
| 2011 | 1 |
| 2012 | 4 |
| 2013 | 4 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 2 |
| 2017 | 3 |
| 2018 | 5 |
| 2019 | 2 |
| 2020 | 4 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 3 |
| 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\" = 'MI' 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") = 2003
AND c."eventStateOrRegion" = 'MI' 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 CHI03LA298Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Harrisville, MIThe loss of engine power for undetermined reasons and the unsuitable terrain encountered during the forced landing. A factor to the accident was the trees.NTSB CHI03LA194Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Roscommon, MIThe pilot's failure to maintain aircraft control during a water landing. A factor contributing to the accident was the rough water.NTSB CHI03LA290Accident · No injuriesLimited investigationFinal reportCessna 172N · Romeo, MIThe pilot not maintaining directional control during landing. A factor to the accident was the parked airplane.NTSB CHI03LA140Accident · No injuriesLimited investigationFinal reportCessna 172M · Midland, MIThe pilot misjugded the flare and his improper recovery from a bounced landing.NTSB CHI03LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · South Haven, MIThe inadequate fuel consumption calculations by the pilot and the fuel exhaustion. The inadequate traffic pattern distance from the runway, which precluded his reaching the runway.