NTSB investigations: Lycoming 0-235 series, 2010
30 cases on aircraft whose registry engine model is Lycoming 0-235 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 | 137 |
|---|---|
| 1965 | 122 |
| 1966 | 98 |
| 1967 | 92 |
| 1968 | 78 |
| 1969 | 54 |
| 1970 | 74 |
| 1971 | 82 |
| 1972 | 73 |
| 1973 | 68 |
| 1974 | 68 |
| 1975 | 69 |
| 1976 | 64 |
| 1977 | 86 |
| 1978 | 152 |
| 1979 | 167 |
| 1980 | 153 |
| 1981 | 147 |
| 1982 | 148 |
| 1983 | 149 |
| 1984 | 148 |
| 1985 | 101 |
| 1986 | 99 |
| 1987 | 120 |
| 1988 | 111 |
| 1989 | 100 |
| 1990 | 86 |
| 1991 | 85 |
| 1992 | 68 |
| 1993 | 73 |
| 1994 | 72 |
| 1995 | 84 |
| 1996 | 74 |
| 1997 | 77 |
| 1998 | 69 |
| 1999 | 58 |
| 2000 | 76 |
| 2001 | 76 |
| 2002 | 67 |
| 2003 | 53 |
| 2004 | 61 |
| 2005 | 72 |
| 2006 | 47 |
| 2007 | 55 |
| 2008 | 46 |
| 2009 | 50 |
| 2010 | 30 |
| 2011 | 36 |
| 2012 | 39 |
| 2013 | 35 |
| 2014 | 19 |
| 2015 | 23 |
| 2016 | 42 |
| 2017 | 33 |
| 2018 | 40 |
| 2019 | 33 |
| 2020 | 30 |
| 2021 | 23 |
| 2022 | 32 |
| 2023 | 25 |
| 2024 | 10 |
| 2025 | 23 |
| 2026 | 15 |
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\") = 2010
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505'))
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") = 2010
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505'))
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 ERA11LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Wimauma, FLThe mechanic/pilot's failure to detect a visible exhaust gas leak and cracked cylinder head immediately prior to the accident flight, which resulted in a partial loss of engine power during initial climb. Contributing to the accident was an inadequate…NTSB CEN11CA131Accident · No injuriesData collectionFinal reportCessna 152 · Bolingbrook, ILThe student pilot's failure to maintain directional control during landing.NTSB CEN10LA573Accident · No injuriesLimited investigationFinal reportCessna 152 · Tea, SDThe loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.NTSB ANC10CA102Accident · No injuriesData collectionFinal reportPiper PA-12 · Windy Forks Strip, AKThe pilot's failure to maintain directional control while taxiing on a rough/uneven airstrip.NTSB WPR10CA437Accident · No injuriesData collectionFinal reportHolt Herbert L Long EZ · Afton, WYThe pilot's failure to securely lock the canopy prior to takeoff, which allowed the contents of the cabin to exit the airplane and damage the propeller. Contributing to the severity of the damage was the subsequent fire that ensued.NTSB ERA10LA434Accident · No injuriesLimited investigationFinal reportCessna 152 · Hollywood, FLA loss of engine power for undetermined reasons.NTSB ERA10CA433Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe pilots' inadequate fuel planning, resulting in the loss of engine power due to fuel exhaustion.NTSB ANC10CA072Accident · No injuriesData collectionFinal reportPiper J5C · Skwentna, AKThe pilot's failure to maintain directional control during landing, and his selection of unsuitable terrain for landing.NTSB WPR10CA390Accident · No injuriesData collectionFinal reportCessna 152 · Livermore, CAThe pilot’s failure to maintain aircraft control during final approach, resulting in a hard landing.NTSB CEN10CA468Accident · No injuriesData collectionFinal reportPiper J3C-85 · Auburn, INThe pilot of the other airplane failing to monitor the position this airplane.NTSB WPR10CA380Accident · No injuriesData collectionFinal reportPiper PA-12 · White Sulphur Springs, MTThe pilot’s loss of directional control while attempting to avoid a herd of antelope crossing the runway during the landing rollout.NTSB CEN10CA451Accident · No injuriesData collectionFinal reportPiper PA-12 · Wild Rose, WIThe pilot's loss of directional control during the takeoff roll.NTSB CEN10CA467Accident · No injuriesData collectionFinal reportCessna 152 · Breckenridge, MIThe pilot's failure to mantain directional control during the aborted landing.NTSB ERA10CA380Accident · No injuriesData collectionFinal reportCessna 152 · Shirley, NYThe student pilot’s improper recovery from a bounced landing.NTSB ERA10LA374Accident · Serious injuriesLimited investigationFinal reportMulloy Charles Zodiac 601XL · Enochville, NCLoss of engine power due to fuel contamination, and the pilot’s inadequate preflight of the fuel system.NTSB WPR10CA367Accident · No injuriesData collectionFinal reportCessna 152 · Ephrata, WAThe pilot's failure to maintain clearance from a fire hydrant while taxiing to the runway.NTSB ERA10CA369Accident · No injuriesData collectionFinal reportCessna 152 · Indian Head, MDThe pilot's loss of control while landing in gusting crosswind conditions.NTSB CEN10CA384Accident · Serious injuriesData collectionFinal reportAmerican AA-1 · Gallup, NMThe pilot's inadequate in-flight planning and failure to attain an adequate airspeed that led to a stall/mush. Contributing to the accident was the lack of suitable terrain for an off-airport landing and the high density altitude.NTSB ERA10CA366Accident · No injuriesData collectionFinal reportPiper J-3C · Buckhead, GAAn in-flight encounter with a downdraft during a go-around, resulting in a collision with trees and the ground.NTSB WPR10FA325Accident · 1 fatalField investigationFinal reportCessna 152 · Venice, CAThe pilot's failure to maintain adequate airspeed and airplane control during initial climb, which resulted in an aerodynamic stall/spin and subsequent impact with the ground.NTSB CEN10CA346Accident · No injuriesData collectionFinal reportCessna 152 · St. Charles, MOThe pilot's improper takeoff procedure that led to a decreased climb rate and subsequent off-airport landing.NTSB WPR10CA263Accident · No injuriesData collectionFinal reportCessna 152 · Merced, CAThe pilot's improper recovery from a bounced landing.NTSB ANC10CA043Accident · No injuriesData collectionFinal reportPiper PA-12 · Tanana, AKThe pilot's excessive application of the brakes during the landing roll resulting in a nose over.NTSB ERA10LA277Accident · 1 fatalLimited investigationFinal reportRutter Herbert G Long EZ · Wakefield, VAThe pilot’s failure to properly align the airplane with the final approach path to the runway and his subsequent loss of control during his attempts to correct the flight path. Contributing to the accident was the pilot’s progressive cognitive decline due to…NTSB ERA10CA249Accident · No injuriesData collectionFinal reportCessna 152 · Cross City, FLThe pilot's inadequate compensation for the crosswind condition resulting in the loss of directional control while landing.NTSB ERA10LA235Accident · No injuriesLimited investigationFinal reportCessna 152 · Avon Park, FLThe operator's failure to correct known deficiencies with the carburetor, which resulted in a complete loss of engine power and subsequent forced landing by the pilot. Also causal was the operator's decision to rent the airplane in an unairworthy condition.NTSB ERA10CA198Accident · No injuriesData collectionFinal reportCessna 152 · Venice, FLThe student pilot's improper flare and recovery from a bounced landing.NTSB ERA10LA187Accident · No injuriesLimited investigationFinal reportCessna 152 · Moore, SCThe certificated mechanic's improper installation of a helicoil, which resulted in the separation of a sparkplug and the helicoil and led to a partial loss of engine power.NTSB CEN10CA137Accident · No injuriesData collectionFinal reportCessna 152 · Hearne, TXThe student pilot's decision to land with a quartering tailwind and his improper flare and recovery from a bounced landing.NTSB ERA10LA139Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Canon, GAThe Luscombe pilot's improper engine starting procedures.