NTSB investigations: Lycoming 0-320 series, 1982, MI
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 | 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\") = 1982
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") = 1982
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 CHI83LA057Accident · No injuriesLimited investigationFinal reportColonial C-1 · Kalamazoo, MIPilot lost oil pressure and elected to land in a plowed field. Nose gear collapsed during landing. Oil leak was the cause of the drop in quantity and pressure.NTSB CHI83LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · New Hudson, MIThe pilot was giving a plane ride to his brother, his brother's grandson and the child's mother. The child's grandmother wanted to take pictures and walked into the parking area next to the taxiway. While looking through the viewfinder, her depth perception…NTSB CHI83LA035Accident · No injuriesLimited investigationFinal reportCessna 172 · Port Hope, MIThe pilot estimated that the wind was from 210 to 220 deg at 15 KTS. He reported that the grass runway was soft and wet. For takeoff on runway 18, he used 10 deg of flaps and about 1/2 of the available aileron while using a soft field takeoff procedure. The…NTSB CHI82DA348Accident · No injuriesFinal reportCessna 172M · Cheboygan, MIThe flight was being conducted over the waters of lake huron when engine stoppage occurred. Unable to glide to the airport the pilot ditched the aircraft on the shoreline in the water. The post-accident investigation revealed that the foam rubber from the air…NTSB CHI82DA322Accident · No injuriesFinal reportGrumman AA-5A · Frankford, MIThe pilot landed hard and lost directional control of the aircraft. He executed the landing into a 19 kt head wind, in the rain, with a wet runway.NTSB DEN82FTA11Accident · 2 fatalFinal reportPiper PA-18 · Hardin, MIThe wreckage was found 3/4 mi west of the nw end of a farm rwy in the approximate position of where a right turn would occur from the downwind leg to the base leg of a right pattern to the se rwy. The wreckage showed evidence of a right rotational moment at…NTSB CHI82DA263Accident · No injuriesFinal reportBeech B19 · Berrien Springs, MIDuring landing, the aircraft bounced and the pilot lost directional control. Subsequently, the aircraft departed the left side of the runway, went into a muddy area, and was substantially damaged.NTSB CHI82DA167Accident · No injuriesFinal reportPiper PA-22-150 · Harrison, MIDuring takeoff the pilot failed to clear a chain link fence. The aircraft collided with a ditch and the left main landing gear collapsed.NTSB CHI82DA049Accident · No injuriesFinal reportCessna 172N · Lambertville, MIThe pilot and 3 passengers returned to the airport after a flight in the local area. A normal approach was made with 20 degrees of flaps for a crosswind landing. The pilot reported that his approach speed was a little fast. During landing, the aircraft…NTSB CHI82DA041Accident · No injuriesFinal reportCessna 172 · Benton Harbor, MIThe pilot received a weather briefing at 1030 EST for a cross-country flight. The cross-country originated at Benton Harbor at 1100 EST using runway 27. At that time, the runway was bare and dry. The flight proceeded to battle creek and kalamazoo, and then…