NTSB investigations: Lycoming 0-290 series, 2006
11 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\") = 2006
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") = 2006
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 ANC07CA004Accident · No injuriesData collectionFinal reportPiper PA-20-135 · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and encounter with terrain. Factors associated with the accident were the ground loop and inadequate main wheel brakes.NTSB ANC06LA140Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe pilot's failure to refuel the airplane before departure, which resulted in fuel exhaustion, and a total loss of engine power during cruise flight. Factors contributing to the accident were an inaccurate fuel tank indication on one of the two fuel tanks,…NTSB ANC06CA128Accident · No injuriesData collectionFinal reportPiper PA-18 · Aniak, AKThe pilot's inadequate compensation for wind conditions during the takeoff initial climb, which resulted in a loss of control and in-flight collision with terrain. A factor contributing to the accident was a windshear.NTSB ANC06LA118Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Chugiak, AKThe pilot's failure to properly preflight the airplane and remove all water from the fuel system, which resulted in a loss of engine power during takeoff/initial climb, and subsequent loss of control. Factors associated with the accident are the pilot's…NTSB CHI06CA159Accident · Minor injuriesData collectionFinal reportPiper PA-22-135 · Nebraska City, NEThe pilot's failure to maintain directional control during the landing rollout and the resulting ground loop. A contributing factor was the excessive tail wheel steering (rudder) input by the pilot.NTSB ANC06LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing roll. A factor associated with the accident was the rocky terrain.NTSB SEA06CA113Accident · No injuriesData collectionFinal reportPiper PA-20 · Salt Lake City, UTAn improper flare and the pilot's failure to maintain directional control during the landing which resulted in the aircraft nosing over. Delayed remedial action was a factor.NTSB DFW06CA107Accident · No injuriesData collectionFinal reportPiper PA-22 · Tecumseh, OKThe pilot's failure to maintain clearance from the trees. Contributing factors were the pilot's inadequate preflight planning/preparation and the high-density altitude.NTSB CHI06LA100Accident · No injuriesLimited investigationFinal reportPiper PA-20 · South St. Paul, MNThe pilot's failure to maintain directional control during landing roll, which resulted in the collapse of the right main landing gear. A factor associated with the accident was a tailwind.NTSB SEA06CA061Accident · No injuriesData collectionFinal reportPiper PA-18 · Saint Paul, ORThe pilot's failure to maintain a proper glide path on final approach to landing resulting in a nose over. A factor was the loose gravel/sandy condition.NTSB SEA06CA062Accident · No injuriesData collectionFinal reportPiper PA-18A · Shady Cove, ORThe pilot's improper installation of the control stick during maintenance, which resulted in the control stick becoming disconnected during the initial takeoff climb, resulting in a loss of control and in-flight collision with the ground.