NTSB investigations: Lycoming 0-320 series, 1985, ID
6 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 | 5 |
|---|---|
| 1965 | 3 |
| 1966 | 5 |
| 1967 | 3 |
| 1968 | 6 |
| 1969 | 6 |
| 1970 | 3 |
| 1971 | 7 |
| 1972 | 2 |
| 1973 | 5 |
| 1974 | 5 |
| 1975 | 4 |
| 1976 | 2 |
| 1977 | 5 |
| 1978 | 4 |
| 1979 | 1 |
| 1980 | 2 |
| 1981 | 5 |
| 1982 | 2 |
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 6 |
| 1986 | 6 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 5 |
| 1993 | 1 |
| 1994 | 4 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 4 |
| 1998 | 4 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 7 |
| 2006 | 4 |
| 2007 | 1 |
| 2008 | 4 |
| 2009 | 6 |
| 2010 | 2 |
| 2011 | 4 |
| 2012 | 3 |
| 2013 | 4 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 4 |
| 2020 | 2 |
| 2021 | 4 |
| 2022 | 2 |
| 2023 | 5 |
| 2024 | 4 |
| 2025 | 1 |
| 2026 | 2 |
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\") = 1985
AND c.\"eventStateOrRegion\" = 'ID' 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" = 'ID' 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 SEA86FA004Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Oakley, IDLow time private pilot had borrowed aircraft for personal trip to nearby airport. On arrival, pilot made fly by of friend's ranch to signal for pick up at airport. Friend got into auto and headed for airport,stated he was driving 60 mph and saw aircraft in…NTSB SEA86LA006Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Emmett, IDWhile landing in calm wind conditions on a 2400 ft rwy, the left brake failed & the acft contd off the departure end, then hit a fence. An exam revealed the left brake pads were worn & the left actuator cylinder was losing fluid. The brake backing plate & the…NTSB SEA85LA199Accident · No injuriesLimited investigationFinal reportCessna 172P · Preston, IDThe acft landed at Preston, ID, for fuel in a x-wind of 15-20 KTS, gusting to 30 KTS. A gust at touchdown veered the acft to the rt. The plt attempted a go-around with full flaps. Flaps were reduced as a stall occurred. The acft hit the ground and bounced…NTSB SEA85FA181Accident · 2 fatalField investigationFinal reportPiper PA-22 · Ketchum, IDStudent pilot on cross country flt, route thru mountain pass and mountains. Attempted emergency landing on highway. During approach and while turning toward selected landing site, plt inadvertantly set full nose down trim with half flaps. As acft completed…NTSB SEA85LA165Accident · No injuriesLimited investigationFinal reportCessna 172 · Pacatello, IDAfter landing the plt was instructed by the tower to expedite off the rwy and taxiway due to a jet following close behind. During taxi from the taxiway to the ramp, the plt was paying particular attention to his right wing tip to avoid parked acft. The acft…NTSB SEA85FA100Accident · 1 fatalField investigationFinal reportPiper PA-14 · Bliss, IDThe acft was observed by witnesses to climb out at a steep angle & slow airspeed after the 3rd touch & go before performing a wingover like maneuver & crashing in the x-wind turn. The pax reported the plt executing a steep left turn before the acft began a…