NTSB investigations: Lycoming 0-235 series
4,597 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, newest first
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'))
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'))
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 LAX08CA264Accident · Minor injuriesData collectionFinal reportCessna 152 · Oceanside, CAA loss of engine power due to fuel exhaustion that was caused by the pilot's inadequate fuel consumption calculations and failure to refuel the airplane en route.NTSB NYC08LA270Accident · 2 fatalLimited investigationFinal reportPiper PA-12 · Brownsboro, ALThe pilot’s failure to ensure the fuel valve was on prior taxi and takeoff. Contributing to the accident was the pilot’s failure to maintain airspeed following loss of engine power due to fuel starvation.NTSB LAX08CA252Accident · No injuriesData collectionFinal reportCessna 152 · Glendale, AZThe student pilot's misjudged altitude and distance, and failure to attain the proper touchdown point, that led to a landing overrun.NTSB CHI08CA226Accident · Minor injuriesData collectionFinal reportAmerican AA-1A · Grantsburg, WIA loss of engine power for an undetermined reason.NTSB DEN08CA126Accident · No injuriesData collectionFinal reportCessna 152 · Mc Alester, OKThe student pilot's improper flare and improper recovery from a bounced landing.NTSB NYC08FA238Accident · 1 fatalField investigationFinal reportCessna 152 · Rossville, TNUndetermined.NTSB LAX08LA211Accident · 1 fatalLimited investigationFinal reportCessna 152 · Piru, CAThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.NTSB MIA08LA125Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Leesburg, FLThe failure of the No. 3 connecting rod cap due to oil starvation. Contributing to the accident was the contamination of the engine oil.NTSB NYC08CA229Accident · No injuriesData collectionFinal reportPiper PA-18-105 · Fayetteville, NCThe pilot's failure to maintain directional control during the landing roll out.NTSB DFW08CA165Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Taylor, TXThe student pilot's improper flare during landing. Contributing to the accident was the gusty winds.NTSB DFW08CA163Accident · No injuriesData collectionFinal reportCessna CE-152 · Foss, OKA total loss of engine power for undetermined reasons.NTSB LAX08CA166Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Kykotsmovi, AZFuel exhaustion due to the pilot's inadequate preflight planning and failure to ensure that adequate fuel was onboard to complete the flight.NTSB MIA08CA113Accident · No injuriesData collectionFinal reportCessna 152 · Okeechobee, FLThe student pilot's improper recovery from a bounced landing.NTSB DFW08CA162Accident · No injuriesData collectionFinal reportCessna CE-152 · Castroville, TXAn improper flare during landing. Contributing to the accident was a porpoise induced oscillation.NTSB NYC08FA189Accident · 2 fatalField investigationFinal reportGrumman American AA-1C · Philadelphia, PAThe flight instructor's failure to maintain airspeed which resulted in an inadvertent stall.NTSB LAX08CA132Accident · No injuriesData collectionFinal reportCessna 152 · Glendale, AZThe pilot's misjudged landing flare and inadequate recovery from a bounced landing.NTSB SEA08CA125Accident · No injuriesData collectionFinal reportCessna 152 · Redding, CAThe pilot's misjudged landing flare, which resulted in a hard landing.NTSB ANC08LA061Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Soldotna, AKThe pilot's failure to remove the rudder gust lock prior to the flight.NTSB DFW08LA130Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Opelousas, LALoss of engine power due to starvation of the right fuel tank and the inability to select the left fuel tank. Contributing to airplane damage was the hidden obstruction in the field selected for the forced landing.NTSB NYC08CA161Accident · Minor injuriesData collectionFinal reportCessna 152K · Okeechobee, FLThe loss of engine power during cruise flight due to fuel contamination, and the pilot's inadequate preflight inspection.NTSB ANC08LA052Accident · Minor injuriesLimited investigationFinal reportPiper J5A · Big Lake, AKA loss of engine power during takeoff/initial climb for an undetermined reason.NTSB SEA08CA109Accident · No injuriesData collectionFinal reportPiper J3C-65 · Bisbee, AZThe pilot's failure to obtain/maintain sufficient airspeed after takeoff, which resulted in a stall/mush condition.NTSB SEA08CA107Accident · No injuriesData collectionFinal reportCessna 152 · Tucson, AZThe pilot's inadequate compensation for the gusty wind condition, which resulted in a loss of control and impact with terrain while landing. A contributing factor was the gusty wind condition.NTSB NYC08CA154Accident · Minor injuriesData collectionFinal reportAmerican AA-1A · Alabaster, ALThe pilot's failure to utilize carburetor heat during a power off approach.NTSB LAX08CA090Accident · No injuriesData collectionFinal reportCessna 152 · El Cajon, CAthe student pilot's inadequate compensation for gusty, crosswind conditions, and failure to maintain an adequate airspeed.NTSB ANC08LA047Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Ugashik, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over. A factor contributing to the accident was water on the surface of the ice-covered lake.NTSB MIA08CA071Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Norwood, MAThe failure of the flightcrew to maintain directional control of the airplane.NTSB DFW08CA093Accident · No injuriesData collectionFinal reportCessna 152 · Arlington, TXThe student pilot's improper landing flare resulting in a hard landing. Contributing to the accident were the gusty surface winds and the student pilot's inadequate preflight planning.NTSB CHI08CA076Accident · No injuriesData collectionFinal reportAmerican AA-1A · Grantsburg, WIThe seizure of the left brake due to a buildup of ice between the rotor and brake pad. Contributing to the accident was the snow and slush covered runway, and the snowbank.NTSB NYC08CA092Accident · Minor injuriesData collectionFinal reportKral Series 5 Kitfox · Fruitland Park, FLThe pilot's failure to maintain adequate clearance from obstructions during the landing approach. Contributing to the accident was the reduced visibility due to sunglare and haze.NTSB LAX08LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CALoss of engine power during the takeoff initial climb due to lack of compression to a cylinder.NTSB NYC08CA094Accident · Minor injuriesData collectionFinal reportPiper J3-C65 · Hollywood, FLThe pilot's failure to maintain directional control while landing. Contributing was the gusty crosswind condition.NTSB NYC08CA080Accident · No injuriesData collectionFinal reportCessna C-152 · Labelle, FLThe pilot's improper decision to takeoff from an inadequate field after a forced landing.NTSB DEN08CA047Accident · No injuriesData collectionFinal reportCessna 152 · Loveland, COthe student pilot's premature flare resulting in the loss of aircraft control.NTSB SEA08CA056Accident · No injuriesData collectionFinal reportPiper PA-12 · Santa Ana, CAThe failure of the student to maintain directional control during landing and the flight instructor's inadequate supervision of the flight.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 NYC08FA054Accident · 2 fatalField investigationFinal reportPiper PA-30 · Parkland, FLBoth pilots' failure to see and avoid the other airplane. Contributing to the accident were the erroneous readouts from the Cessna's altitude encoder.NTSB ANC08LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of engine power during takeoff initial climb for an undetermined reason.NTSB DFW08CA044Accident · No injuriesData collectionFinal reportCessna 152 · Madill, OKThe pilot failed to maintain directional control during landing roll. A contributing factor was the crosswind.NTSB NYC08LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Miami, FLA total loss of engine power during initial climb for undetermined reasons.NTSB NYC08CA047Accident · No injuriesData collectionFinal reportCessna 152 · Venice, FLThe student pilot's improper recovery from a bounced landing.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 DFW08CA028Accident · No injuriesData collectionFinal reportCessna 152 · Ardmore, OKThe pilot's improper landing flare which resulted in a hard landing.NTSB LAX08CA037Accident · No injuriesData collectionFinal reportCessna 152 · Turlock, CAThe pilot's delayed decision to abort the landing, which resulted in a runway overrun.NTSB MIA08LA005Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Farmingdale, NYThe failure of both pilots to see and avoid while maneuvering resulting in a midair collision. Contributing to the accident was the local controller's failure to properly identify conflicting traffic.NTSB NYC08LA001Accident · 1 fatalLimited investigationFinal reportLambert John G Varieze · Chesapeake, VAA loss of control in flight for undetermined reasons.NTSB CHI07CA306Accident · No injuriesData collectionFinal reportPiper PA-12 · Detroit Lakes, MNThe reduced airplane climb performance capability resulting in the pilot not obtaining a proper climb rate during takeoff and the inadequate flare by the pilot during the aborted takeoff. Additional causes were the inadequate preflight planning/preparation by…NTSB MIA07CA134Accident · Minor injuriesData collectionFinal reportCessna 152 · Labelle, FLThe student pilot's attempted precautionary landing on unsuitable terrain which resulted in damage to the airplane during the landing.NTSB ANC07LA092Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot's failure to maintain adequate altitude/clearance from a parked airplane during the landing flare.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.