NTSB investigations: Lycoming 0-235 series
159 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Loss of engine power”. 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
| 1982 | 10 |
|---|---|
| 1983 | 8 |
| 1984 | 4 |
| 1985 | 3 |
| 1986 | 5 |
| 1987 | 4 |
| 1988 | 5 |
| 1989 | 1 |
| 1990 | 5 |
| 1991 | 8 |
| 1992 | 6 |
| 1993 | 3 |
| 1994 | 3 |
| 1995 | 3 |
| 1996 | 3 |
| 1997 | 7 |
| 1998 | 10 |
| 1999 | 5 |
| 2000 | 9 |
| 2001 | 7 |
| 2002 | 4 |
| 2003 | 9 |
| 2004 | 11 |
| 2005 | 10 |
| 2006 | 5 |
| 2007 | 11 |
Where
Latest 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
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 DFW08LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe loss of engine power during cruise flight due to the pilot's failure to refuel the airplane prior to fuel exhaustion.NTSB ANC08LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of engine power during takeoff initial climb for an undetermined reason.NTSB NYC08LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Miami, FLA total loss of engine power during initial climb for undetermined reasons.NTSB DEN08LA032Accident · Minor injuriesLimited investigationFinal reportGomory Long EZ · LeRoy, KSThe loss of engine power due to fuel starvation. Contributing factors were the pilot's improper fuel calculations and in-flight planning.NTSB DEN07CA141Accident · Minor injuriesData collectionFinal reportEaa Biplane P · Parker, COThe loss of engine power for undetermined reasons. A contributing factor was the pilot's intentional maneuver into a piece of machinery.NTSB CHI07LA170Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Lansing, ILThe loss of engine power during takeoff-initial climb due to a bent exhaust valve and fouled spark plugs.NTSB NYC07LA138Accident · No injuriesLimited investigationFinal reportPiper PA38 · Jacksonville, FLThe pilot's failure to perform adequate pre-flight fuel consumption calculations, which resulted in a loss of power due to fuel starvation.NTSB CHI07CA146Accident · No injuriesData collectionFinal reportEverett Zodiac 601XL · Lonoke, ARThe loss of engine power for undetermined reasons. An additional cause was the pilot's improper decision to enter the traffic pattern after intermittent losses of engine power, and his subsequent failure to remain within power off gliding distance of the…NTSB CHI07CA105Accident · No injuriesData collectionFinal reportPavliga Hatz CB-1 · Buffalo, MNThe loss of engine power due to the carburetor fuel flow valve becoming stuck in the closed position, which resulted in fuel starvation.NTSB MIA07LA072Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Lakeland, FLThe pilot's inadequate preflight. Contributing to the pilot's injuries was his failure to wear the installed shoulder harness.NTSB MIA07LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Canal Point, FLThe pilot-in-command's incorrect leaning of the fuel/air ratio resulting in the total loss of engine power during cruise flight.NTSB DFW07LA009Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wimberley, TXthe pilot's inadequate pre-flight planning which resulted in fuel starvation and the subsequent the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN06LA126Accident · Serious injuriesLimited investigationFinal reportBeech 77 · Live Oak, FLa loss of engine power for reasons undetermined, and an inadvertent stall while maneuvering.NTSB MIA06LA107Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe loss of engine power for undetermined reasons.NTSB MIA06LA064Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sanford, FLA loss of engine power during takeoff-initial climb due to contamination (debris) lodged in the carburetor jet, which resulted in a forced landing and collision with trees.NTSB SEA06LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Kelso, WAEncounter with carburetor icing conditions while maneuvering for the downwind which resulted in a loss of engine power due to carburetor ice. The aircraft nosing over during the landing roll in soft sand was a factor.NTSB MIA06LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · Key Largo, FLA loss of engine power for undetermined reasons that resulted in the airplane being ditched into the ocean. Contributing to the accident was the pilot's operation of an airplane with known deficiencies due to it having sat in flooded waters.NTSB DFW06CA022Accident · No injuriesData collectionFinal reportPiper PA38 · Decatur, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA06LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Newberg, ORThe flight instructor's failure to maintain airspeed while on approach for landing resulting in an inadvertent stall. Wind gusts, trees and an undetermined loss of engine power were factors.NTSB ATL05CA104Accident · No injuriesData collectionFinal reportCessna 152 · Naples, FLThe CFI's mismanagement of the fuel supply, which resulted in fuel exhaustion.NTSB SEA05LA099Accident · No injuriesLimited investigationFinal reportHorvath Pitts S-1C · Creswell, ORLoss of engine power as a result of a carburetor float drop restriction during cruise flight. Tall grass in the landing area was a factor in the accident.NTSB DFW05LA106Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Perry, OKA loss of engine power for undetermined reasons. A contributing factor was collision with a piece of farm equipment.NTSB ATL05LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, NCThe loss of engine power due to the failure of the carburetor mixture cable which resulted in fuel starvation.NTSB IAD05LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Port Royal, VAA loss of engine power due to the pilot's inadequate preflight planning which resulted in fuel exhaustion.NTSB DFW05LA083Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Austin, TXThe loss of engine power due to the failure of the number three connecting rod. Contributing factors were the foreign object located within the engine lubrication system, inadequate inspection of the engine by other maintenance personal, and the lack of…NTSB ATL05CA045Accident · Minor injuriesData collectionFinal reportCessna 152 · Nashville, TNA loss of engine power due to fuel starvation as a result of fuel system blockage.NTSB DFW05LA025Accident · Minor injuriesLimited investigationFinal reportWingo Long-Ez · Huntsville, TXLoss of engine power for undetermined reasons. A contributing factor was the unsuitable terrain for landing.NTSB ATL05LA018Accident · 2 fatalLimited investigationFinal reportBellanca Citabria 7ECA · Summerville, SCThe loss of engine power due to undetermined reasons.NTSB ATL04LA187Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Inverness, FLThe improper installation of the carburetor which resulted in a loss of engine power and subsequent collision with trees during an emergency landing.NTSB ATL04CA179Accident · Minor injuriesData collectionFinal reportCessna 152 · Inverness, FLThe pilot's inadequate preflight inspection, and his failure to detect the presence of water in the fuel system, which resulted in a loss of engine power and subsequent collision with trees and terrain.NTSB DEN04LA110Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Guernsey, WYthe pilot's inadequate use of carburetor heat which resulted in the formation of carburetor ice and loss of engine power. Factors contributing to the accident were weather conditions conducive for carburetor icing, and a lack of suitable terrain for a forced…NTSB NYC04LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Jaffrey, NHThe loss of engine power for undetermined reasons.NTSB FTW04LA125Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Oil City, LAA loss of engine power for undetermined reasons, and the student pilot's failure to maintain airspeed resulting in a stall..NTSB CHI04CA118Accident · No injuriesData collectionFinal reportPiper PA-12 · Hartford, WIThe loss of engine power for undetermined reasons. A factor to the accident was the soft terrain encountered during the forced landing.NTSB LAX04LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Martin, CAthe loss of engine power for undetermined reasons.NTSB NYC04LA090Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, KYThe total loss of engine power due to a total loss of engine oil for undetermined reasons, which resulted in a forced landing and subsequent collision with trees.NTSB NYC04LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Spencer, MAA loss of engine power for undetermined reasons.NTSB ANC04LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Togiak, AKA loss of engine power due to an undetermined reason that resulted in a forced landing, a collapse of the main landing gear, and a collision with trees. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB ATL04LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Louisburg, NCOther maintenance personnel's inadequate engine overhaul that resulted in engine case fretting and engine oil starvation.NTSB CHI04LA039Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIThe loss of engine power for undetermined reasons. A factor to the accident was the tree line and the unsuitable terrain.NTSB LAX04LA022Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · San Martin, CAThe absence of compression in two of the airplane's four cylinders, and the pilot/mechanic's failure to maintain the engine in an airworthy condition, which resulted in a loss of engine power during takeoff-initial climb, and subsequent forced landing.NTSB NYC03LA184Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Pawtucket, RIA loss of engine power for undetermined reasons.NTSB MIA03LA170Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Panama City, FLThe pilot's failure to follow the airplane manufacturer's recommendation to not use automobile fuel in the airplane resulting in deterioration of the fuel tank sealant, fuel starvation of the engine from fuel system contamination, and subsequent collision…NTSB FTW03LA192Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Granbury, TXThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB SEA03LA065Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Trident, MTFuel exhaustion while in cruise flight due to inadequate preflight planning / preparation. A fence was a factor.NTSB CHI03LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Rose Hill, KSThe loss of engine power due to the failure of the left magneto and the pilot's failure to identify the malfunctioning magneto. A factor to the accident was the soft terrain condition encountered during the forced landing.NTSB ATL02LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Spring City, TNThe flight instructor's failure to follow standard training procedures that resulted in the loss of engine power during a simulated loss of engine power.NTSB CHI02LA271Accident · No injuriesLimited investigationFinal reportCessna 152 · Brooklyn Park, MNThe pilot's inadequate preflight preparation/planning, which resulted in fuel exhaustion and the loss of engine power. A factor to the accident was the power transmission line and the trees.NTSB LAX02LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Boulder City, NVa loss of engine power due to an undetermined malfunction of the carburetor.NTSB FTW02LA093Accident · No injuriesLimited investigationFinal reportTillman Long EZ · Lockhart, TXthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.