NTSB investigations: Lycoming IO-320 series, 2008
10 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\") = 2008
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") = 2008
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 ERA09LA098Accident · Minor injuriesLimited investigationFinal reportHess John L Spezio II · Newville, PAA loss of engine power due to carburetor ice as a result of the pilot's delayed use of carburetor heat.NTSB WPR09CA045Accident · Minor injuriesData collectionFinal reportPiper PA-30 · Kona, HIThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during the landing roll. Contributing factors were the delayed remedial action by the check pilot, the crosswind condition, and the rough uneven…NTSB ERA09FA027Accident · 1 fatalField investigationFinal reportPiper PA-30 · Selmer, TNThe pilot's failure to avoid terrain during night instrument meteorological conditions.NTSB NYC08CA315Accident · No injuriesData collectionFinal reportPiper PA-30 · Jefferson, GAThe pilot's failure to follow the airplane manufacturer's landing gear failure and emergency extension procedures. Contributing to the accident was a malfunction of the landing gear system for undetermined reasons.NTSB NYC08LA207Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Pawtucket, RIBoth pilots' failure to see and avoid the other airplane. Contributing to the accident was the air traffic controllers failure to notify either pilot of the potential conflict.NTSB DFW08CA141Accident · No injuriesData collectionFinal reportPiper PA-30 · Houston, TXThe pilot's loss of directional control during the landing. A contributing factor was the flight instructor's delayed remedial action.NTSB MIA08CA095Accident · No injuriesData collectionFinal reportChampion 7KCAB · Alexander City, ALThe separation of the right tail wheel spring on landing roll out for undetermined reasons, resulting in a loss of directional control and collision with a ditch.NTSB LAX08LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Holbrook, AZA total loss of engine power due to fuel starvation as a result of the pilot's fuel system mismanagement and incorrect positioning of the fuel selector valves.NTSB NYC08CA105Accident · No injuriesData collectionFinal reportPiper PA-30 · Atlanta, GAThe pilot's failure to maintain directional control during the landing roll.NTSB DFW08CA069Accident · No injuriesData collectionFinal reportPiper J3C-65 · Shallowater, TXFailure of the pilot to maintain a safe clearance from the terrain while manuevering for the landing surface.