NTSB investigations: Lycoming 0-360-A1D, 2010
6 cases on aircraft whose registry engine model is Lycoming 0-360-A1D. 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 | 1 |
|---|---|
| 1965 | 1 |
| 1966 | 4 |
| 1967 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 3 |
| 1973 | 2 |
| 1974 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 2 |
| 1979 | 1 |
| 1980 | 5 |
| 1981 | 2 |
| 1982 | 1 |
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 7 |
| 1986 | 1 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 6 |
| 1993 | 5 |
| 1994 | 4 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 8 |
| 1998 | 6 |
| 1999 | 8 |
| 2000 | 10 |
| 2001 | 14 |
| 2002 | 15 |
| 2003 | 14 |
| 2004 | 5 |
| 2005 | 6 |
| 2006 | 7 |
| 2007 | 10 |
| 2008 | 8 |
| 2009 | 7 |
| 2010 | 6 |
| 2011 | 8 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 5 |
| 2018 | 6 |
| 2019 | 2 |
| 2020 | 5 |
| 2021 | 7 |
| 2022 | 6 |
| 2023 | 4 |
| 2024 | 4 |
| 2025 | 4 |
| 2026 | 3 |
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\") = 2010
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41504'))
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") = 2010
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41504'))
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 WPR11CA084Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe student pilot's failure to maintain clearance from obstacles while taxiing.NTSB ANC10TA080Accident · No injuriesFinal reportAviat A-1B · Bettles Field, AKThe pilot's selection of an unsuitable off-airport landing site for a precautionary landing.NTSB ANC10CA066Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's failure to maintain directional control after encountering a crosswind during landing.NTSB WPR10LA370Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Walla Walla, WAThe pilot's partial incapacitation during cruise flight and his subsequent inadequate fuel management, which resulted in fuel starvation.NTSB CEN10CA350Accident · No injuriesData collectionFinal reportAviat A-1B · Idabell, OKThe pilot's failure to maintain directional control during a go-around.NTSB CEN10CA209Accident · No injuriesData collectionFinal reportTrue Flight Holdings AA-5B · Muskegon, MIThe inadvertent in-flight collision with a goose.