NTSB investigations: Lycoming 0-290 series, 2011
14 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\") = 2011
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") = 2011
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 CEN11FA663Accident · 1 fatalField investigationFinal reportThorp T-18 · Plainwell, MIThe pilot did not maintain clearance from a semitrailer along the approach path.NTSB ERA11LA519Accident · No injuriesLimited investigationFinal reportHeinlein George GH125 · Okeechobee, FLThe non-certificated pilot's improper flare on an earlier flight, which resulted in a hard landing, fracture of the right main landing gear bolt, and subsequent collapse of the right main landing gear.NTSB CEN11CA611Accident · No injuriesData collectionFinal reportPiper L-21B · East Liverpool, OHThe pilot's failure to maintain directional control of the airplane during landing.NTSB CEN11FA597Accident · 1 fatalField investigationFinal reportNichols Lancair 235 · Heath, OHThe pilot's failure to obtain adequate familiarization with the accident airplane type before the accident flight, which resulted in his failure to maintain airplane control during takeoff.NTSB CEN11LA539Accident · Serious injuriesLimited investigationFinal reportHurley Richard A Cavalier SA102.5 · Salem, IAThe partial loss of engine power due to the formation of carburetor ice.NTSB WPR11FA319Accident · 2 fatalField investigationFinal reportPiper PA-22-135 · Verlot, WAThe non-instrument rated pilot’s decision to continue visual flight into clouds and his failure to maintain clearance from terrain while maneuvering in an area of reduced visibility, low clouds, and mountain obscuration.NTSB CEN11CA439Accident · No injuriesData collectionFinal reportBarker A E B-2 · Sisterdale, TXThe pilot's failure to maintain clearance from obstacles.NTSB ANC11CA049Accident · No injuriesData collectionFinal reportChampion 7HC · Kenai, AKThe pilot's selection of unsuitable terrain for landing, resulting in the collapse of the main landing gear, and a nose over.NTSB ANC11CA053Accident · No injuriesData collectionFinal reportPiper PA-18A · McCarthy, AKThe pilot's failure to maintain control of the airplane while taxiing in gusty wind conditions.NTSB ANC11CA029Accident · Serious injuriesData collectionFinal reportPiper PA-18-125 · Cordova, AKThe pilot's loss of aircraft control during final approach in gusty wind conditions, resulting in a hard landing.NTSB CEN11FA300Accident · 1 fatalField investigationFinal reportDahlman-Dower Tailwind W-8 · Elk City, OKThe pilot's decision to attempt flight into instrument meteorological conditions in an airplane that was equipped for flight in visual meteorological conditions only, which resulted in the pilot’s spatial disoriented and loss of control of the airplane.NTSB WPR11LA205Accident · Minor injuriesLimited investigationFinal reportBennett Midjet Mustang I · Ramona, CAThe pilot's inability to maintain directional control during the landing roll due to the overload separation of the left brake master cylinder from the left rudder pedal assembly.NTSB ERA11FA210Accident · 1 fatalField investigationFinal reportPiper PA-20 · Elgin, SCA total loss of engine power due to fuel exhaustion resulting from the pilot’s inadequate preflight planning. Contributing to the accident was that the pilot did not maintain an adequate airspeed, which resulted in an aerodynamic stall.NTSB ANC11CA016Accident · No injuriesData collectionFinal reportCessna 140 · Anchorage, AKThe pilot's failure to maintain directional control while landing, resulting in a ground loop.