Fatal NTSB investigations: Lycoming 0-320 series, 1972
10 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 | 11 |
|---|---|
| 1965 | 5 |
| 1966 | 17 |
| 1967 | 14 |
| 1968 | 16 |
| 1969 | 17 |
| 1970 | 16 |
| 1971 | 13 |
| 1972 | 10 |
| 1973 | 15 |
| 1974 | 21 |
| 1975 | 17 |
| 1976 | 17 |
| 1977 | 25 |
| 1978 | 43 |
| 1979 | 42 |
| 1980 | 36 |
| 1981 | 39 |
| 1982 | 50 |
| 1983 | 29 |
| 1984 | 26 |
| 1985 | 24 |
| 1986 | 35 |
| 1987 | 22 |
| 1988 | 38 |
| 1989 | 21 |
| 1990 | 18 |
| 1991 | 22 |
| 1992 | 21 |
| 1993 | 28 |
| 1994 | 18 |
| 1995 | 27 |
| 1996 | 17 |
| 1997 | 17 |
| 1998 | 17 |
| 1999 | 20 |
| 2000 | 15 |
| 2001 | 26 |
| 2002 | 45 |
| 2003 | 26 |
| 2004 | 32 |
| 2005 | 33 |
| 2006 | 24 |
| 2007 | 28 |
| 2008 | 27 |
| 2009 | 24 |
| 2010 | 23 |
| 2011 | 14 |
| 2012 | 23 |
| 2013 | 18 |
| 2014 | 17 |
| 2015 | 23 |
| 2016 | 19 |
| 2017 | 18 |
| 2018 | 13 |
| 2019 | 17 |
| 2020 | 12 |
| 2021 | 11 |
| 2022 | 12 |
| 2023 | 22 |
| 2024 | 12 |
| 2025 | 8 |
| 2026 | 16 |
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\") = 1972
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 1972
AND c."highestInjuryLevel" = 'Fatal'
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 NYC73FLJ14Accident · 1 fatalClosedPiper PA-22 · Whitakers, NCNTSB SEA73AS015Accident · 3 fatalClosedPiper PA-28 · Bend, ORNTSB LAX73AL019Accident · 1 fatalClosedCessna 172K · Missing AircraftNTSB CHI73AC032Accident · 2 fatalClosedBeech 23 · Kenosha, WINTSB LAX73AL007Accident · 3 fatalClosedPiper PA-28 · Ontario, CANTSB LAX73AL004Accident · 3 fatalClosedCessna 172 · La Jolla, CANTSB NYC72AN151Accident · 1 fatalClosedPiper PA-22 · Winchester, VANTSB FTW72AF078Accident · 1 fatalClosedCessna 177 · Many, LANTSB ANC72AA037Accident · 1 fatalClosedInterstate S-1B1 · Skwentna, AKNTSB FTW72FRA38Accident · 1 fatalClosedCessna 172K · Sugar Land, TX