NTSB investigations: Lycoming 0-320 series, 1986, 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\") = 1986
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") = 1986
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 SEA86LA230Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Priest River, IDThe pilot was attempting to land while a thunderstorm was within two miles of the airport. Strong turbulence was present during the approach but the pilot elected to continue the approach. A strong downdraft occurred when the aircraft was about 50 feet AGL.…NTSB SEA86LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Preston, IDThe jackson county sheriff reported that the pilot was attempting to take off from a farmer's field and failed to clear a dike. Subsequently, the acft cartwheeled into a county landfill and was damaged.NTSB SEA86LA140Accident · Minor injuriesLimited investigationFinal reportVarga 2050A · Bear Trap, IDDuring a simulated forced landing the instructor pilot allowed the student to enter into a stall while turning from base to final. Although the instructor attempted to correct the student's mistakes he allowed the student to go too FAR with the task before…NTSB SEA86LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Twin Falls, IDWhile landing for the fifth and final touch and go, the pilot touched down at about midfield, due to too high of an approach. Rather than go-around, the pilot selected heavy braking. The aircraft then veered to the right, struck a mound of dirt sheering off…NTSB SEA86LA094Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Aberdeen, IDThe student plt was attempting to land on rwy 25 with a light x-wind form 040 degs at 5 KTS. The plt allowed the acft to drift to the left of the narrow rwy. As full pwr was added in an attempt to go-around, the acft struck the ground, veered left through a…NTSB SEA86LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · American Falls, IDThe student pilot was attempting to make a touch and go, when the aircraft veered to the left of the runway and struck an embankment. The student failed to use enough right rudder to maintain directional control. The runway's width is 50 feet.