NTSB investigations: Lycoming 0-320 series, 1981, AK
29 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 | 14 |
|---|---|
| 1965 | 12 |
| 1966 | 12 |
| 1967 | 26 |
| 1968 | 23 |
| 1969 | 18 |
| 1970 | 24 |
| 1971 | 15 |
| 1972 | 22 |
| 1973 | 27 |
| 1974 | 27 |
| 1975 | 22 |
| 1976 | 50 |
| 1977 | 36 |
| 1978 | 33 |
| 1979 | 39 |
| 1980 | 39 |
| 1981 | 29 |
| 1982 | 23 |
| 1983 | 27 |
| 1984 | 29 |
| 1985 | 37 |
| 1986 | 41 |
| 1987 | 33 |
| 1988 | 30 |
| 1989 | 34 |
| 1990 | 32 |
| 1991 | 32 |
| 1992 | 32 |
| 1993 | 32 |
| 1994 | 21 |
| 1995 | 31 |
| 1996 | 29 |
| 1997 | 23 |
| 1998 | 29 |
| 1999 | 30 |
| 2000 | 29 |
| 2001 | 15 |
| 2002 | 22 |
| 2003 | 27 |
| 2004 | 24 |
| 2005 | 23 |
| 2006 | 21 |
| 2007 | 19 |
| 2008 | 22 |
| 2009 | 19 |
| 2010 | 25 |
| 2011 | 25 |
| 2012 | 26 |
| 2013 | 12 |
| 2014 | 12 |
| 2015 | 19 |
| 2016 | 17 |
| 2017 | 13 |
| 2018 | 21 |
| 2019 | 17 |
| 2020 | 18 |
| 2021 | 23 |
| 2022 | 19 |
| 2023 | 15 |
| 2024 | 19 |
| 2025 | 14 |
| 2026 | 13 |
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\") = 1981
AND c.\"eventStateOrRegion\" = 'AK' 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") = 1981
AND c."eventStateOrRegion" = 'AK' 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 ANC82DAG10Accident · No injuriesClosedBellanca 7GCBC · King Salmon, AKNTSB ANC82DAG02Accident · Minor injuriesClosedPiper PA-18 · Iliamna, AKNTSB ANC81DAG92Accident · Serious injuriesClosedPiper PA-18 · Anchorage, AKNTSB ANC81DAD08Accident · No injuriesClosedPiper PA-23 · Yakutat, AKNTSB ANC81DAG86Accident · No injuriesClosedPiper PA-18 · Valdez, AKNTSB ANC81DAA35Accident · No injuriesClosedPiper PA-18 · Hodzona River, AKNTSB ANC81DAG71Accident · No injuriesClosedPiper PA-28 · Seldovia, AKNTSB ANC81DA106Accident · No injuriesClosedCessna U206F · Cantwell, AKNTSB ANC81DAG89Accident · No injuriesClosedPiper PA-18 · Homer, AKNTSB ANC81DAA31Accident · No injuriesClosedPiper PA-18 · Tin City, AKNTSB ANC81DAG66Accident · Serious injuriesClosedBellanca 7GCAA · Sterling, AKNTSB ANC81DAA25Accident · No injuriesClosedPiper PA-18 · Fairbanks, AKNTSB ANC81DAA28Accident · No injuriesClosedPiper PA-18 · Fairbanks, AKNTSB ANC81FA094Accident · 1 fatalClosedPiper PA-18 · Port Moller, AKNTSB ANC81DAG65Accident · No injuriesClosedPiper PA-18A · Canyon Creek, AKNTSB ANC81FA092Accident · 1 fatalClosedPiper PA-18 · Kokiak, AKNTSB ANC81FA084Accident · 3 fatalClosedPiper PA-18 · Cordova, AKNTSB ANC81DAG61Accident · No injuriesClosedPiper PA-18 · Kenai, AKNTSB ANC81DAG49Accident · Minor injuriesClosedPiper PA-18 · Crooked Creek, AKNTSB ANC81DAG63Accident · No injuriesClosedPiper PA-18 · Copper Center, AKNTSB ANC81FAA14Accident · No injuriesClosedPiper PA-22 · Fairbanks, AKNTSB ANC81DA038Accident · No injuriesClosedPiper PA-28 · Minchumina, AKNTSB ANC81FA033Accident · 2 fatalClosedPiper PA-18A · Fairbanks, AKNTSB ANC81DA027Accident · No injuriesClosedCessna 172N · Red Devil, AKNTSB ANC81DAG25Accident · No injuriesClosedPiper PA-28 · Anchorage, AKNTSB ANC81DAG23Accident · No injuriesClosedPiper PA-18 · Wasilla, AKNTSB ANC81FAA08Accident · No injuriesClosedPiper PA-18 · Galena, AKNTSB ANC81DAG20Accident · No injuriesClosedPiper PA-18 · Copper Center, AKNTSB ANC81DAG18Accident · No injuriesClosedPiper PA-22 · Kenai, AK