NTSB investigations: Lycoming 0-360-A1D, 2003
14 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
Latest 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 ('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") = 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 ('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 IAD04LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-44 · Prospect, PAThe flight instructor's improper in-flight decision, which included an inappropriate altitude selection for intentional single engine operation. Factors were the inability of the flight instructor to restart the right engine for undetermined reasons, and the…NTSB LAX04LA049Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Phoenix, AZthe flight instructor's inadequate supervision of the flight and delayed remedial action, which resulted in a loss of directional control. The reason for the partial power loss in the left engine was not determined.NTSB LAX04LA041Accident · 2 fatalLimited investigationFinal reportDaughters T18C · Needles, CAthe pilot's continuation of a visual flight rules (VFR) flight into an area of adverse weather, which resulted in an encounter with moderate to severe turbulence and in-flight breakup of the airplane.NTSB LAX04FA037Accident · 2 fatalField investigationFinal reportRobinson R22 Beta II · Torrance, CAthe failure of the pilot of the R22 to comply with an ATC clearance.NTSB SEA03LA199Accident · Serious injuriesLimited investigationFinal reportWood Avid Magnum · Kooskia, IDThe pilot's improper recovery from a bounced landing which led to a loss of control.NTSB CHI03LA302Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Sikeston, MOThe pilot's inadvertent activation of the brake system during touchdown and his inadequate remedial action, which resulted in the airplane nosing over.NTSB ANC03LA104Accident · No injuriesLimited investigationFinal reportAviat A-1A · Sitka, AKThe pilot's delay in aborting the takeoff, which resulted in a collision with the shoreline during an aborted takeoff.NTSB NYC03LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Sandusky, OHThe pilot's failure to maintain the engine mixture control during the go-around, which resulted in a loss of power, and in-flight collision with trees.NTSB DEN03FA111Accident · 1 fatalField investigationFinal reportHammond Vans RV-6A · La Junta, COthe pilot's failure to maintain airspeed resulting in a stall during the turn from base leg to final approach.NTSB SEA03FA100Accident · 2 fatalField investigationFinal reportAviat A-1 · Atlanta, IDClearance from trees was not maintained during the initial climb. A proper touchdown point was not attained, the pilot's lack of familiarity with the geographic area and trees were factors.NTSB FTW03LA172Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Houston, TXThe pilot's failure to maintain rotor RPM and the improper landing flare resulting in a hard landing. A contributing factor was the prevailing high winds.NTSB SEA03FA096Accident · 1 fatalField investigationFinal reportAviat A-1A · Sandpoint, IDThe pilot's failure to maintain adequate airspeed during a low pass maneuver which resulted in a stall. A related factor was the trees.NTSB ATL03FA104Accident · 3 fatalField investigationFinal reportPiper PA-44-180 · Battleboro, NCThe certified flight instructor's (CFI) failure to maintain flying speed that resulted in a stall/spin and the uncontrolled collision with the ground.NTSB CHI03LA133Accident · 1 fatalLimited investigationFinal reportAir & Space 18A · South Shore, SDThe pilot's failure to maintain clearance from the terrain. The pilot's lack of experience, the rain, the dark night, the low ceiling, and the rising terrain were contributing factors to the accident.