NTSB investigations: Lycoming 0-320 series, 1983, OK
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 | 2 |
|---|---|
| 1965 | 9 |
| 1966 | 6 |
| 1967 | 5 |
| 1968 | 9 |
| 1969 | 11 |
| 1970 | 3 |
| 1971 | 7 |
| 1972 | 5 |
| 1973 | 8 |
| 1974 | 2 |
| 1975 | 7 |
| 1976 | 4 |
| 1977 | 5 |
| 1978 | 7 |
| 1979 | 5 |
| 1980 | 5 |
| 1981 | 4 |
| 1982 | 6 |
| 1983 | 5 |
| 1984 | 5 |
| 1985 | 3 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 5 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 4 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 6 |
| 2002 | 4 |
| 2003 | 6 |
| 2006 | 2 |
| 2007 | 2 |
| 2008 | 1 |
| 2009 | 2 |
| 2010 | 5 |
| 2011 | 4 |
| 2012 | 2 |
| 2013 | 2 |
| 2017 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2022 | 2 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 3 |
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\") = 1983
AND c.\"eventStateOrRegion\" = 'OK' 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") = 1983
AND c."eventStateOrRegion" = 'OK' 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 FTW83LA390Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Buffalo, OKThe acft hit the ground while trying to stay VFR under low ceilings at night. The student plt was returning from a x-country, for which he had no briefing on the weather, when the weather became worse. The student plt circumnavigated some of the thunderstorms…NTSB FTW83LA355Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Cashion, OKThe plt was told that the sod strip was 1800 ft long. His calculated takeoff distance to clear a 50 ft obstacle was 1720 ft. however, the actual length of the sod strip ws 1300 ft. during the takeoff roll, the plt realized he would not be able to clear the 30…NTSB FTW83LA265Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tulsa, OKThe acft veered off the rwy & nosed over. The plt stated he had purchased the acft to start taking plt lessons to securehis license which had been revoked 10/3/79.NTSB FTW83LA168Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Mountain Park, OKThe pilot stated that he was taking off to the north on a highway for a crop spraying operation. The aircraft was loaded with 720 pounds of chemical and 36 gal of fuel. He perceived a breeze from the south but took off north because of a hill to the south.…NTSB FTW83LA082Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Mangum, OKThe pilot stated that shortly after takeoff the left engine surged twice and quit. He elected to make a precautionary landing in an open field which was soft from melting snow. During roll out the nose wheel dug in and the drag link broke which collapsed the…