NTSB investigations: Lycoming 0-320 series, 1982, AR
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 | 4 |
|---|---|
| 1965 | 4 |
| 1966 | 3 |
| 1967 | 6 |
| 1968 | 3 |
| 1969 | 5 |
| 1970 | 3 |
| 1971 | 6 |
| 1972 | 2 |
| 1973 | 7 |
| 1974 | 4 |
| 1975 | 8 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 7 |
| 1979 | 5 |
| 1980 | 4 |
| 1981 | 1 |
| 1982 | 5 |
| 1983 | 5 |
| 1984 | 5 |
| 1985 | 1 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 4 |
| 1989 | 2 |
| 1990 | 4 |
| 1991 | 4 |
| 1992 | 7 |
| 1993 | 2 |
| 1994 | 4 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 5 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 1 |
| 2008 | 2 |
| 2009 | 5 |
| 2010 | 3 |
| 2012 | 1 |
| 2020 | 1 |
| 2022 | 2 |
| 2023 | 4 |
| 2025 | 1 |
| 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\") = 1982
AND c.\"eventStateOrRegion\" = 'AR' 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") = 1982
AND c."eventStateOrRegion" = 'AR' 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 FTW83LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Solgohachia, ARPilot overran runway and slid on grass into a tree. Pilot says he did not go-around because of rise in terrain.NTSB FTW82DA328Accident · No injuriesFinal reportPiper PA-18-150 · Devalls Bluff, ARThe pilot was flying over his farm and decided to land in a freshly plowed field. During the rollout, the main gear settled in the loose dirt and the plane nosed over.NTSB FTW82DA349Accident · No injuriesFinal reportCessna 172N · Antoine, ARThe pilot stated that during the takeoff run from a private airstrip he allowed the aircraft to veer to the left and struck a drainage ditch.NTSB FTW82DA315Accident · No injuriesFinal reportPiper PA-28-140 · Springdale, ARThe pilot stated taht the aircraft was at 4200 ft descending when the engine suddenly lost power. He was unable to glide to an airport so he landed on a road. During the landing, the right wing hit a road sign and was substantially damaged. After landing, the…NTSB FTW82FRJ08Accident · 2 fatalFinal reportBellanca 7GCBC · Near Texarkana, ARDuring flight, the aircraft struck a powerline about 70 ft above the red river. The aircraft crashed in the river and drifted about 2 miles before it was recovered. The passenger's body was recovered on 03/21/82 and the pilot's body was recovered on 05/15/83…