NTSB investigations: Lycoming IO-320 series, 2006
12 cases on aircraft whose registry engine model is Lycoming IO-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 | 17 |
|---|---|
| 1965 | 21 |
| 1966 | 34 |
| 1967 | 35 |
| 1968 | 25 |
| 1969 | 20 |
| 1970 | 33 |
| 1971 | 28 |
| 1972 | 34 |
| 1973 | 32 |
| 1974 | 27 |
| 1975 | 21 |
| 1976 | 20 |
| 1977 | 19 |
| 1978 | 36 |
| 1979 | 19 |
| 1980 | 22 |
| 1981 | 17 |
| 1982 | 17 |
| 1983 | 13 |
| 1984 | 18 |
| 1985 | 12 |
| 1986 | 15 |
| 1987 | 18 |
| 1988 | 10 |
| 1989 | 11 |
| 1990 | 9 |
| 1991 | 9 |
| 1992 | 5 |
| 1993 | 5 |
| 1994 | 3 |
| 1995 | 5 |
| 1996 | 10 |
| 1997 | 5 |
| 1998 | 6 |
| 1999 | 9 |
| 2000 | 11 |
| 2001 | 11 |
| 2002 | 13 |
| 2003 | 13 |
| 2004 | 10 |
| 2005 | 8 |
| 2006 | 12 |
| 2007 | 15 |
| 2008 | 10 |
| 2009 | 13 |
| 2010 | 10 |
| 2011 | 13 |
| 2012 | 7 |
| 2013 | 10 |
| 2014 | 10 |
| 2015 | 7 |
| 2016 | 4 |
| 2017 | 8 |
| 2018 | 6 |
| 2019 | 3 |
| 2020 | 10 |
| 2021 | 9 |
| 2022 | 10 |
| 2023 | 9 |
| 2024 | 5 |
| 2025 | 6 |
| 2026 | 6 |
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\") = 2006
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41509'))
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") = 2006
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41509'))
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 DEN07WA028Accident · 1 fatalForeign investigationYoakley Glasair · Rieden, GermanyNTSB CHI06CA270Accident · No injuriesData collectionFinal reportDevereux Mustang II · Auburn, INThe failure of the left main landing gear attachment weld which resulted in the pilot's inablility to maintain directional control of the airplane during the landing roll.NTSB NYC06CA221Accident · No injuriesData collectionFinal reportCessna 172P · Baltimore, MDThe pilot's improper flare, which resulted in a hard landing.NTSB NYC06CA195Accident · Minor injuriesData collectionFinal reportChampion 7KCAB · Hyannis, MAThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB CHI06CA237Accident · No injuriesData collectionFinal reportSpittler Rans S-16 · Plattsmouth, NEA loss of engine power due to fuel starvation which resulted from a binding within the fuel servo. A factor associated with the accident was the high vegetation that was encountered during the forced landing.NTSB DEN06FA107Accident · 2 fatalField investigationFinal reportAmerican Champion 7KCAB · Winter Park, COThe pilot's failure to maintain adequate airspeed to avoid a stall while maneuvering at a low altitude in mountainous terrain. Factors associated with the accident are the pilot's performance of a low altitude flight maneuver, an inadvertent stall/spin, and…NTSB NYC06CA164Accident · Serious injuriesData collectionFinal reportBaker, Timithy Falco F8L · Montgomery, NYThe pilot's inadequate pre-flight inspection, which resulted in a loss of engine power due to fuel contamination.NTSB ATL06LA079Accident · 1 fatalLimited investigationFinal reportTaylor Skybolt · Sharpsburg, GAThe pilot's loss of control while conducting aerobatic flight. Factors in the accident were the pilot's ostentatious display, and lack of recent and total experience in type of operation.NTSB NYC06LA090Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Norfolk, VAThe pilot's failure to maintain aircraft control during a single-engine go-around. A factor was the partial loss of engine power.NTSB DEN06LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Greeley, COthe pilot's flight into adverse weather conditions, the airframe ice, and the wheels up landing. Factors contributing to the accident were the icing conditions, the frozen landing gear, the frozen alternate gear extension system, and the runway sign.NTSB LAX06FA089Accident · 4 fatalField investigationFinal reportPiper PA-30 · Visalia, CAthe pilot's failure to maintain airspeed during the landing approach, which resulted in a stall and uncontrolled descent. Contributing factors to the accident were the pilot's impairment due to his prolonged use of a highly sedating over-the-counter sleep aid…NTSB LAX06CA086Accident · Minor injuriesData collectionFinal reportBellanca 7KCAB · Fallbrook, CAthe student pilot's inadequate compensation for a crosswind condition and his failure to maintain directional control.