NTSB investigations: Lycoming 0-290 series, 2005
19 cases on aircraft whose registry engine model is Lycoming 0-290 series. 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 | 92 |
|---|---|
| 1965 | 75 |
| 1966 | 71 |
| 1967 | 70 |
| 1968 | 47 |
| 1969 | 49 |
| 1970 | 51 |
| 1971 | 45 |
| 1972 | 49 |
| 1973 | 35 |
| 1974 | 43 |
| 1975 | 28 |
| 1976 | 38 |
| 1977 | 39 |
| 1978 | 45 |
| 1979 | 30 |
| 1980 | 19 |
| 1981 | 22 |
| 1982 | 29 |
| 1983 | 29 |
| 1984 | 24 |
| 1985 | 27 |
| 1986 | 15 |
| 1987 | 21 |
| 1988 | 19 |
| 1989 | 15 |
| 1990 | 15 |
| 1991 | 22 |
| 1992 | 17 |
| 1993 | 15 |
| 1994 | 12 |
| 1995 | 15 |
| 1996 | 31 |
| 1997 | 6 |
| 1998 | 21 |
| 1999 | 18 |
| 2000 | 14 |
| 2001 | 19 |
| 2002 | 24 |
| 2003 | 18 |
| 2004 | 12 |
| 2005 | 19 |
| 2006 | 11 |
| 2007 | 14 |
| 2008 | 18 |
| 2009 | 17 |
| 2010 | 11 |
| 2011 | 14 |
| 2012 | 17 |
| 2013 | 10 |
| 2014 | 11 |
| 2015 | 13 |
| 2016 | 6 |
| 2017 | 12 |
| 2018 | 10 |
| 2019 | 10 |
| 2020 | 14 |
| 2021 | 14 |
| 2022 | 8 |
| 2023 | 14 |
| 2024 | 6 |
| 2025 | 9 |
| 2026 | 9 |
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\") = 2005
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41506'))
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") = 2005
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41506'))
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 ANC06CA013Accident · No injuriesData collectionFinal reportPiper PA-18 · Skwentna, AKThe pilot's selection of an unsuitable landing area, which resulted in an on ground collision with trees during the landing roll. Factors associated with the accident were the icy and snow-covered terrain.NTSB CHI06CA044Accident · No injuriesData collectionFinal reportMendenhall Lancair 235 · Medina, OHThe pilot's failure to maintain directional control during landing due to an icy runway. Factors to the accident were the ice/snow contaminated runway surface, snow bank, and the pilot's lack of familiarity with the accident airplane.NTSB CHI05LA276Accident · 1 fatalLimited investigationFinal reportStits Playboy SA3B Lightning · Kimball, NEThe inadvertent stall and low airspeed by the pilot following takeoff. Contributing factors were the low altitude at the time of occurrence, the high density altitude, and the propeller.NTSB ANC05CA139Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot's failure to maintain adequate airspeed during takeoff initial climb, which resulted in an inadvertent stall/mush, and subsequent in-flight collision with trees. A factor contributing to the accident was a tailwind.NTSB SEA05CA186Accident · No injuriesData collectionFinal reportPiper PA-22 (20) · McCall, IDThe pilot's failure to maintain airspeed during takeoff. A wire fence was a factor in the accident.NTSB ATL05CA151Accident · Minor injuriesData collectionFinal reportPiper PA-18-105 · N. Myrtle Beach, SCThe loss of engine power due to the pilot's failure to use carburetor heat, which resulted in the formation of carburetor ice.NTSB ATL05CA146Accident · No injuriesData collectionFinal reportPiper 22 · Archdale, NCThe pilot's failure to maintain directional control during landing roll, which resulted in a nose over.NTSB CHI05CA193Accident · Minor injuriesData collectionFinal reportPiper PA-22 · Plainwell, MIThe loss of engine power on downwind due to carburetor icing, and the unsuitable terrain the pilot encountered during the forced landing. A factor was the soft terrain.NTSB ANC05CA091Accident · No injuriesData collectionFinal reportPiper PA-20 · Nome, AKThe pilot's inadequate compensation for wind conditions during the landing roll, which resulted in the collapse of the main landing gear, and a nose over. A factor associated with the accident was a crosswind.NTSB CHI05CA169Accident · Minor injuriesData collectionFinal reportKelley Volmer Amphibian B · Nauvoo, ILThe pilot's failure to maintain appropriate airspeed during landing, which resulted in a stall/mush condition and hard landing.NTSB LAX05CA212Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Pine Valley, CAThe pilot's delay in aborting the takeoff and excessive brake application. A contributing factor was the downsloping terrain used for the landing and takeoff.NTSB ANC05CA080Accident · No injuriesData collectionFinal reportPiper PA-18 · Delta Junction, AKThe pilot's selection of unsuitable terrain for landing, which resulted in an overrun. A factor contributing to the accident was rough and uneven terrain.NTSB ANC05LA073Accident · No injuriesLimited investigationFinal reportInterstate S-1A · Palmer, AKThe pilot's misjudged distance and speed, which resulted in an overrun during the landing roll, and subsequent nose over. Factors contributing to the accident were a tailwind and a short landing area.NTSB ATL05LA076Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Thomaston, GAThe unapproved repair of the tailwheel rudder arm assembly, which resulted in an overload failure during touchdown and subsequent loss of control of the airplane and on-ground collision with an object.NTSB DEN05FA124Accident · 2 fatalField investigationFinal reportPiper PA-22-135 · Kremmling, COthe pilot's failure to maintain clearance from terrain.NTSB ATL05CA059Accident · No injuriesData collectionFinal reportEcker Starduster 1 · Millington, TNThe malfunction of the left main landing gear wheel brake during landing roll on a grassy area, resulting in a nose over.NTSB ANC05LA042Accident · No injuriesLimited investigationFinal reportPiper J-5A · Kenai, AKThe pilot's selection of unsuitable terrain for a precautionary landing, which resulted in a collision with a snow berm during the landing flare. Factors contributing to the accident were flat light conditions, the presence of a snow berm along the edge of a…NTSB ATL05CA054Accident · No injuriesData collectionFinal reportPiper PA-22 · Holly Ridge, NCThe CFI's improper use of the rudder control and normal braking during the landing roll that resulted in the collapse of the nose gear assembly.NTSB SEA05LA039Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Lewiston, IDThe pilot's failure to maintain directional control during the landing roll. Wind gusts and the pilot's inadequate compensation for wind conditions were factors.