NTSB investigations: Lycoming AEIO-360 series, 2003
9 cases on aircraft whose registry engine model is Lycoming AEIO-360 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
| 1965 | 1 |
|---|---|
| 1967 | 1 |
| 1974 | 1 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 13 |
| 1979 | 8 |
| 1980 | 3 |
| 1981 | 5 |
| 1982 | 6 |
| 1983 | 8 |
| 1984 | 2 |
| 1985 | 5 |
| 1986 | 6 |
| 1987 | 4 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 4 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 6 |
| 1996 | 5 |
| 1997 | 5 |
| 1998 | 5 |
| 1999 | 1 |
| 2000 | 4 |
| 2001 | 8 |
| 2002 | 3 |
| 2003 | 9 |
| 2004 | 3 |
| 2005 | 7 |
| 2006 | 3 |
| 2007 | 3 |
| 2008 | 1 |
| 2009 | 4 |
| 2010 | 4 |
| 2011 | 7 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 3 |
| 2015 | 1 |
| 2016 | 7 |
| 2017 | 4 |
| 2018 | 2 |
| 2019 | 4 |
| 2020 | 5 |
| 2021 | 4 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 6 |
| 2026 | 1 |
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\") = 2003
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41522', '41601'))
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") = 2003
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41522', '41601'))
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 SEA04CA037Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Bend, ORDirectional control not maintained during landing. Factors include an icy runway and a snow bank.NTSB MIA04LA015Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Ocala, FLThe failure of the dual student to maintain airspeed (VS) and the CFI's improper supervision while turning to reverse direction resulting in an inadvertent stall/spin and collision with trees and the ground during the resultant uncontrolled descent.NTSB SEA03LA182Accident · Minor injuriesLimited investigationFinal reportPitts S-2A · Hillsboro, ORThe pilot's failure to maintain the proper distance and altitude while on final approach which led to touching down short of the runway. The pilot's restricted visual lookout was a factor.NTSB CHI03LA327Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA200 · Sugar Grove, ILA loss of engine power due to the pilot's inadvertent deactivation of the magnetos, and the pilot's selection of the wrong runway for the forced landing. Factors were the low altitude and the unsuitable terrain encountered during the forced landing.NTSB CHI03LA232Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Stephen, MNThe pilot's failure to maintain clearance from the transmission line and the pilot's continued operation with known deficiencies in equipment. Factors to the accident were the power lines and the low altitude the pilot was flying at.NTSB SEA03LA141Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Newman Lake, WAThe pilot's failure to maintain clearance from an object while on final approach for landing. Trees and inadequate visual lookout were factors.NTSB SEA03LA145Accident · No injuriesLimited investigationFinal reportAndelin S1E · Troutdale, ORThe pilot's inability to maintain directional control due to an obstruction of the left brake line by foreign material resulting in asymmetrical braking.NTSB LAX03CA246Accident · No injuriesData collectionFinal reportMaysmike Pitts S1S · Livermore, CAThe pilot's inadequate compensation for crosswind conditions, which resulted in a loss of directional control and a ground loop.NTSB FTW03LA171Accident · Minor injuriesLimited investigationFinal reportBoyle Black Eagle BE360 · Celina, TXThe loss of propeller pitch effectiveness for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.