NTSB investigations: Lycoming 0-320 series, 1985, AZ
7 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 | 7 |
|---|---|
| 1965 | 6 |
| 1966 | 6 |
| 1967 | 5 |
| 1968 | 7 |
| 1969 | 3 |
| 1970 | 7 |
| 1971 | 11 |
| 1972 | 3 |
| 1973 | 6 |
| 1974 | 4 |
| 1975 | 7 |
| 1976 | 9 |
| 1977 | 5 |
| 1978 | 14 |
| 1979 | 9 |
| 1980 | 9 |
| 1981 | 10 |
| 1982 | 14 |
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 7 |
| 1986 | 7 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 9 |
| 1990 | 6 |
| 1991 | 8 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 6 |
| 1995 | 5 |
| 1996 | 4 |
| 1997 | 10 |
| 1998 | 8 |
| 1999 | 5 |
| 2000 | 6 |
| 2001 | 7 |
| 2002 | 13 |
| 2003 | 6 |
| 2004 | 6 |
| 2005 | 9 |
| 2006 | 11 |
| 2007 | 10 |
| 2008 | 7 |
| 2009 | 6 |
| 2010 | 4 |
| 2011 | 3 |
| 2012 | 10 |
| 2013 | 5 |
| 2014 | 7 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 4 |
| 2019 | 4 |
| 2020 | 4 |
| 2021 | 6 |
| 2022 | 5 |
| 2023 | 4 |
| 2024 | 4 |
| 2025 | 1 |
| 2026 | 4 |
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\") = 1985
AND c.\"eventStateOrRegion\" = 'AZ' 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") = 1985
AND c."eventStateOrRegion" = 'AZ' 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 LAX86LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chino Valley, AZWhen the flt departed prescott for the local flt, the plt said the rwys switched several times between 11 & 03 due to the winds. The official prescott surfact observation reported the winds from 110 degrees at 8 KTS with gusts to 17 KTS. After departing…NTSB LAX86FA007Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Payson, AZThe passenger had a 10:00 medical appointment at the destination arot on the day of the accident. The non-instrument rated, recently certificated pvt plt, requested and received a weather briefing for a proposed VFR flt at 7500 ft MSL from mesa to holbrook,…NTSB LAX85LA292Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Glendale, AZWhen the plt realized he was low during final apch to a landing, he erroneously decided not to use full flaps instead of adding power, vref was high and the landing was 3/4 of the way down the 2400 ft rwy. Believing he had sufficient room to takeoff again,…NTSB LAX85FA202Accident · 2 fatalField investigationFinal reportCessna 172M · Camp Verde, AZBoth acft involved in the collision were part of a 4-plane formation flt en route to a group fly-in. N6439R was seen to change positions several times during the flt while the other acft remained stable. Reports from witnesses say that N6439R made 'close…NTSB LAX85LA166Accident · No injuriesLimited investigationFinal reportCessna 172 · Tucson, AZThe plt was commencing his 1st solo x-country flt. At lift-off, the acft entered a left bank of about 45 degs. The student plt reduced power & the acft touched down hard on the dirt beside the rwy & was damaged. The plt believed that he may have encountered…NTSB DEN85FA088Accident · 2 fatalField investigationFinal reportBellanca 7GCAA · Cornville, AZThe acft was on a local flt with the owner/private plt & a student plt on board. While in aerobatic flt over a narrow canyon/gully area, the acft collided with & severed 3 power lines & a static line, located aprx 100 ft above the ground. The acft then…NTSB LAX85LA124Accident · No injuriesLimited investigationFinal reportCessna 172N · Grand Canyon, AZThe 50 year old private pilot, with a total of 158 flight hours, said the landing was made on the right half of the 150 ft wide rwy. As he attempted to steer to the middle of the rwy the acft skidded off the left side of the rwy and contacted a snow bank aprx…