NTSB investigations: Lycoming 0-235 series, 2017
33 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\") = 2017
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") = 2017
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 GAA18CA090Accident · No injuriesData collectionFinal reportPiper PA22 · Yentna, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a loss of directional control and subsequent nose-over.NTSB ERA18LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Everglades City, FLThe loose nut connecting the mixture control cable to the mixture control arm, which resulted in the pilot’s inability to control the mixture and the subsequent total loss of engine power.NTSB WPR18LA042Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · Everett, WAThe flight instructor’s inadequate preflight inspection, during which he failed to ensure that water was sufficiently drained from the fuel system, which resulted in total loss of engine power and a subsequent forced landing and impact with objects.NTSB GAA18CA076Accident · No injuriesData collectionFinal reportCessna 152 · Fullerton, CAThe student pilot’s failure to maintain directional control during takeoff.NTSB CEN18LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA 12 · Dickinson, NDThe pilot’s failure to attain adequate airspeed during the short field takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB WPR18FA035Accident · 1 fatalField investigationFinal reportCessna 152 · Tehachapi, CAThe pilot's loss of situational awareness shortly after takeoff over a sparsely lit area in dark night conditions, which resulted in a rapid descent to ground impact.NTSB WPR18LA014Accident · Serious injuriesClass 3 · LimitedFinal reportAmerican AA 1A · Maricopa, AZThe pilot’s failure to see and avoid unmarked power lines during the approach to land.NTSB GAA17CA563Accident · No injuriesData collectionFinal reportPiper PA 22 · Orangeburg, SCA failed main landing gear tire for reasons that could not be determined due to postcrash fire damage.NTSB ERA17LA336Accident · No injuriesLimited investigationFinal reportCessna 152 · Winder, GAThe pilot's inadequate preflight inspection, which resulted in undetected water in the fuel system and a total loss of engine power during the initial climb.NTSB ERA17LA333Accident · Serious injuriesLimited investigationFinal reportBuschmann/Vanzee Vari EZ · Ambler, PAWater contamination of the fuel that was not detected during a preflight inspection, which resulted in a total loss of engine power.NTSB GAA17CA528Accident · No injuriesData collectionFinal reportCessna 152 · Broomfield, COThe student pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB ERA17FA299Accident · 2 fatalField investigationFinal reportGrumman AA1 · Portland, TNThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA17LA281Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Green Creek, NJThe pilot's exhaustion of the fuel supply in the selected tank.NTSB ERA17LA268Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Mount Sterling, KYA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR17LA175Accident · Serious injuriesLimited investigationFinal reportGrumman AA1 · Phoenix, AZThe partial loss of engine power during initial climb due to the No. 3 cylinder exhaust valve becoming stuck open due to deposit buildup in the exhaust valve stem and guide and the pilot’s exceedance of the airplane’s critical angle of attack while attempting…NTSB GAA17CA462Accident · No injuriesData collectionFinal reportChampion 7ECA · Butler, PAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB ERA17LA258Accident · No injuriesLimited investigationFinal reportKubassek David Zenith 601 · Aiken, SCThe failure of the nose landing gear’s (NLG) lower bearing, which resulted in the pilot’s inability to maintain directional control during landing, a runway excursion, and the NLG collapsing.NTSB ERA17LA254Accident · No injuriesLimited investigationFinal reportCessna 152 · Tamarac, FLThe flight instructor's failure to ensure that the airplane's fuel system was free of water contamination before departing, which resulted in a total loss of engine power and subsequent forced landing.NTSB ERA17FA231Accident · 1 fatalField investigationFinal reportCessna 152 · Homestead, FLThe pilot's loss of control due to spatial disorientation while maneuvering in night conditions over an area devoid of ground reference lights.NTSB ERA17CA221Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe student pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA17CA387Accident · No injuriesData collectionFinal reportPiper PA 12 · Chickaloon, AKThe pilot’s improper landing flare on a turf runway, which necessitated a go-around during which he failed to establish a climb.NTSB ANC17LA033Accident · No injuriesClass 2 · LimitedFinal reportPiper PA 12 · Skwentna, AKThe pilot's failure to properly secure the external load, which resulted in the load shifting during flight, interference with the water rudder cable, and a subsequent loss of controlNTSB GAA17CA335Accident · No injuriesData collectionFinal reportCessna 152 · Stow, OHThe student pilot’s rudder overcorrection during the landing roll, which resulted in a loss of directional control.NTSB CEN17LA153Accident · No injuriesLimited investigationFinal reportCessna 152 · La Porte, TXA total loss of engine power due to fuel contamination, which resulted from the pilot’s inadequate preflight inspection that did not detect water contamination.NTSB GAA17CA241Accident · Minor injuriesData collectionFinal reportAmerican AA 1 · New Market, VAThe pilot’s failure to maintain a proper approach path, which resulted in an impact with trees.NTSB ERA17FA148Accident · 1 fatalField investigationFinal reportPiper PA 12 · Sanford, FLThe incorrect rigging of the elevator control cables, which resulted in a reversal of elevator control inputs applied by the pilot during the takeoff, an excessive nose-high pitch, and subsequent aerodynamic stall after takeoff. Also causal was the inadequate…NTSB GAA17CA247Accident · No injuriesData collectionFinal reportGrumman American Avn. AA · Flushing, MIThe pilot’s unstabilized approach and subsequent failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB GAA17CA188Accident · No injuriesData collectionFinal reportPiper PA 12 · Anchorage, AKThe pilot’s failure to maintain directional control during the taxi on skis on hard-packed snow in gusting wind conditions.NTSB GAA17CA173Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe student pilot’s loss of directional control.NTSB ERA17FA112Accident · 1 fatalField investigationFinal reportPiper PA38 · East Haven, CTThe failure of the fuel selector valve in a position that restricted fuel flow to the engine, resulting in a total loss of engine power during initial climb due to fuel starvation. Also causal was the operator's failure to effectively detect and resolve the…NTSB CEN17LA105Accident · Serious injuriesLimited investigationFinal reportAmerican AA 1A · Gainesville, TXThe pilot’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and subsequent forced landing in a field. Contributing to the accident was the pilot’s delayed action in taking control of the…NTSB GAA17CA169Accident · No injuriesData collectionFinal reportCessna 152 · Bonifay, FLThe student pilot's failure to maintain directional control during landing in crosswind conditions.NTSB ERA17LA078Accident · Serious injuriesLimited investigationFinal reportAircraft Mfg & Development CH 2000 · Atlanta, GAThe pilot's exceedance of the airplane's critical angle of attack while attempting a short-field takeoff, which resulted in an aerodynamic stall.