NTSB investigations: Lycoming 0-360-A1D, 1994
4 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\") = 1994
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") = 1994
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 ANC94LA125Accident · No injuriesLimited investigationFinal reportCessna 170B · Fort Yukon, AKThe fatigue failure of the right main landing gear spring.NTSB FTW94LA201Accident · Minor injuriesLimited investigationFinal reportGamble BD-4 · Leadville, COThe pilot's failure to maintain directional control. Factors were an unreliable airspeed indicator and excessive landing approach airspeed.NTSB MIA94LA106Accident · No injuriesLimited investigationFinal reportCessna 172RG · Parkland, FLImproper planning/decision by the director of operations, and failure of the instructor pilot to take adequate remedial action. A factor related to the accident was: the soft/wet runway condition.NTSB LAX94LA092Accident · Minor injuriesLimited investigationFinal reportBeech 76 · Avalon, CAThe pilot's failure to see and avoid the powerlines. A related factor was the pilot's poor judgment in flying at low altitude.