NTSB investigations: Lycoming 0-360-A1D, 2002
15 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\") = 2002
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") = 2002
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 MIA02CA177Accident · No injuriesData collectionFinal reportAviat A-1 · Cherry Point, NCthe pilot misjudged the landing flare, resulting in a hard landing, an inadvertent ground loop, and the subsequent impact with the runway.NTSB LAX02FA288Accident · 3 fatalField investigationFinal reportMooney M-20E · Carlsbad, CAfailure of the pilots of both airplanes to maintain an adequate visual lookout and to see and avoid each other. A contributing factor was the failure of the controller to detect and resolve the conflict between the airplanes.NTSB NYC02LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Manassas, VAThe pilot's inadequate pre-flight planning, and his inadequate visual lookout while taxing on an off airport road. A factor related to the accident was the dark night conditions.NTSB DEN02LA094Accident · No injuriesLimited investigationFinal reportCollette RV6 · Nephi, UTThe pilot's failure to maintain aircraft control during landing roll, resulting in his attempt to go-around and an inadvertent stall/mush. A contributing factor was the lack of suitable terrain for a forced landing.NTSB MIA02LA156Accident · No injuriesLimited investigationFinal reportAviat A1 · Merritt Island, FLThe pilot's failure to maintain directional control during the landing rollout while landing in a crosswind which resulted in the airplane inadvertently veering off the runway and incurring damage when the pilot forced it into a ground loop to avoid entry…NTSB LAX02LA220Accident · No injuriesLimited investigationFinal reportBushby Mustang M-11 · Pahrump, NVthe failure and separation of a propeller blade for undetermined reasons.NTSB SEA02LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Anacortes, WAThe pilot's improper decision to continue his flight after failing to take on fuel at a planned en route refueling stop, which lead to a loss of power from fuel exhaustion while on final approach to his round-robin final destination. Factors include…NTSB LAX02LA156Accident · No injuriesLimited investigationFinal reportHam Pitts S-1C · Borrego Springs, CAThe failure of the pilot to maintain control of the airplane during landing rollout resulting in a ground loop/swerve and a nose over. The soft terrain was a factor.NTSB NYC02FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Gardiner, NYThe pilot-in-command's failure to maintain sufficient altitude while maneuvering in a mountainous area, which resulted in a collision with terrain. Factors in the accident were, mountainous terrain, clouds, and the pilot's decision to continue the flight in…NTSB SEA02LA068Accident · No injuriesLimited investigationFinal reportSteele Steen Skybolt · Coeur d' Alene, IDThe pilot's failure to maintain directional control during the landing rollout.NTSB LAX02LA126Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Goodyear, AZThe student pilot's misjudgment of clearance and his failure to adhere to the flight school's policy/procedures for taxiing around obstructions.NTSB LAX02LA119Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe failure of the flight instructor to properly judge the landing flare and add adequate cyclic, resulting in a hard landing which collapsed the left skid. The wind gusts were a factor.NTSB ANC02LA017Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Fairbanks, AKThe pilot's failure to maintain clearance from objects while maneuvering. A factor associated with the accident is an undetermined object.NTSB DEN02LA024Accident · No injuriesLimited investigationFinal reportAviat A-1A · Afton, WYThe pilot's failure to maintain directional control, which resulted in a collision with a snow bank. Contributing factors were the icy runway and the snow bank.NTSB FTW02FA071Accident · 1 fatalField investigationFinal reportBeech C23 · Sinton, TXThe pilot's failure to maintain clearance with trees while executing a missed approach procedure. Contributing factors were the prevailing fog and the dark night conditions.