NTSB investigations: Lycoming 0-360-A1D, 1999
8 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\") = 1999
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") = 1999
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 NYC00LA061Accident · Minor injuriesLimited investigationFinal reportZielke RV-4 · Florence, NJFailure of one of the propeller blades. A factor was the necessity land across, rather than in alignment with, the furrowed terrain due to the nature of the emergency.NTSB LAX00LA039Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Hilo, HIAn oil starvation induced failure and seizure of the engine. The reasons for the oil starvation event are undetermined.NTSB SEA99FA113Accident · 1 fatalField investigationFinal reportAlexander VAN'S RV-8 · Lafayette, ORFatigue of the number two connecting rod end resulting in a fracture at the rod end and release from the crankshaft, an ensuing in-flight fuel fed fire, followed by the pilot's abandoning the aircraft in flight. A contributing factor was pressure on the pilot…NTSB SEA99LA047Accident · Serious injuriesLimited investigationFinal reportAviat A-1 · Emmett, IDThe pilot's failure to maintain aircraft control during a low-altitude maneuver to view a coyote on the ground. A related factor was the pilot's low altitude.NTSB DEN99LA058Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Englewood, COThe flight instructor allowed the rotor rpm to decay during an autorotation which resulted in a hard landing.NTSB LAX99LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Scottsdale, AZThe failure of the local and ground controller to coordinate the clearances of both aircraft and to maintain separation of the traffic in the taxiway movement area.NTSB CHI99LA113Accident · No injuriesLimited investigationFinal reportDelong Glastar GS-1 · Lapeer, MIThe failure of the pilot to maintain compensation for wind conditions. Factors to the accident were the crosswind condition and the presence of trees along the runway.NTSB FTW99LA083Accident · No injuriesLimited investigationFinal reportRobinson R22-B2 · Freer, TXThe passenger's inadvertent interference with the cyclic control which consequently restricted the control's movement.