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 ERA09CA504Accident · No injuriesData collectionFinal reportCessna 152 · Harrisburg, PAThe student pilot’s delayed decision to abort the takeoff, resulting in an overrun.NTSB CEN09CA560Accident · No injuriesData collectionFinal reportPiper PA-12 · Gonvick, MNA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.NTSB ANC09CA087Accident · No injuriesData collectionFinal reportPiper PA-12 · Dillingham, AKThe pilot's decision to land on unsuitable soft, wet terrain, which resulted in a nose-over on landing.NTSB ERA09LA468Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Mount Holly, NJA loss of directional control during landing for undetermined reasons.NTSB WPR09FA398Accident · 2 fatalField investigationFinal reportCessna 152 · Hesperia, CAThe pilot's failure to maintain adequate airspeed while maneuvering in the traffic pattern, which resulted in an aerodynamic stall/spin. Also causal was the failure of the left magneto due to improper assembly of the drive gear during installation on the…NTSB WPR09CA392Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · Kamiah, IDThe failure of the student pilot to maintain directional control during landing.NTSB WPR09CA394Accident · Minor injuriesData collectionFinal reportPiper PA-12 · Sisters, ORThe pilot's failure to maintain directional control during the landing roll.NTSB CEN09LA490Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Whitney, TXA partial loss of engine power for undetermined reasons.NTSB WPR09LA380Accident · Serious injuriesLimited investigationFinal reportDavenport DAVE-EZ · Santa Monica, CAThe loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control during the forced landing.NTSB ERA09LA413Accident · 1 fatalLimited investigationFinal reportCessna 152 · Ponce, PRThe airplane’s impact with water for undetermined reasons.NTSB ERA09CA373Accident · No injuriesData collectionFinal reportCessna 152 · Mt. Pleasant, SCThe pilot's improper recovery from a bounced landing.NTSB CEN09CA387Accident · No injuriesData collectionFinal reportCessna 152 · Oklahoma City, OKThe pilot's failure to maintain control of the airplane during landing.NTSB CEN09CA367Accident · No injuriesData collectionFinal reportCessna 152 · Fort Collins, COThe pilot's failure to control the airplane after engine startup, resulting in a ground collision with a nearby airplane.NTSB WPR09LA293Accident · 2 fatalLimited investigationFinal reportChampion 7ECA · Lake Elsinore, CAA loss of airplane control for undetermined reasons.NTSB WPR09CA274Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Grangeville, IDThe pilot's failure to maintain clearance from an obstacle during taxi.NTSB ERA09CA306Accident · Minor injuriesData collectionFinal reportCessna 152 · Lumberton, NJThe pilot's failure to maintain aircraft control during initial climb, which resulted in a loss of adequate airspeed and a subsequent aerodynamic stall.NTSB ERA09CA292Accident · No injuriesData collectionFinal reportCessna 152 · Memphis, TNThe pilots' decision to fly at a low altitude and their inadequate visual lookout while maneuvering.NTSB CEN09LA277Accident · 2 fatalLimited investigationFinal reportChampion 7GCBC · Surrey, NDThe pilot’s failure to maintain control of the airplane during an abrupt pull-up maneuver, which resulted in an aerodynammic stall at low altitude.NTSB CEN09CA279Accident · Minor injuriesData collectionFinal reportAmerican AA-1 · Cumberland, WIThe pilot's failure to maintain control of the aircraft during takeoff in crosswind conditions.NTSB ERA09CA275Accident · No injuriesData collectionFinal reportPiper PA-12 · Georgetown, SCThe pilot's failure to maintain directional control during landing roll. Contributing to the accident was the pilot’s lack of experience in the make and model airplane.NTSB WPR09LA205Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlsbad, CAA partial loss of engine power during takeoff due to carbon fouling of a spark plug.NTSB WPR09FA200Accident · 2 fatalField investigationFinal reportChampion 7ECA · San Jose, CAThe pilot's failure to maintain airspeed while maneuvering within a canyon in mountainous terrain, which resulted in an inadvertent stall/spin.NTSB ANC09LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Talkeetna, AKThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall while maneuvering at a high density altitude.NTSB WPR09LA196Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Glendale, AZA loss of engine power due to the failure of both magnetos resulting from an improper maintenance repair by maintenance personnel.NTSB ERA09FA235Accident · 1 fatalField investigationFinal reportGrumman AA-1B · Chesnee, SCA loss of engine power in flight due to fuel starvation as a result of the pilot's inadequate inflight fuel planning and the pilot's failure to maintain airspeed while descending for a forced landing.NTSB WPR09CA172Accident · No injuriesData collectionFinal reportCessna 152 · Ellensburg, WAThe student pilot's improper flare and improper recovery from a bounced landing.NTSB CEN09CA215Accident · Minor injuriesData collectionFinal reportMcCurdy Pro Star PT-2 · Springfield, ILThe pilot's failure to maintain directional control during the landing roll.NTSB ERA09LA199Accident · No injuriesLimited investigationFinal reportShniderman Ervin Stanley LONG-EZ · Manassas, VAA fire of undetermined origin in the engine compartment.NTSB CEN09FA195Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA-1B · Golden, NMThe pilot's continued visual flight into instrument meteorological conditions. Contributing to the accident were the pilot's recent usage of alcohol and his subsequent impairment.NTSB ERA09CA181Accident · No injuriesData collectionFinal reportCessna 152 · Crystal River, FLThe student pilot's improper recovery from a bounced landing.NTSB CEN09CA200Accident · No injuriesData collectionFinal reportCessna 152 · Fort Wayne, INThe student pilot's improper flare and recovery from a bounced landing.NTSB WPR09LA124Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Salinas, CAThe pilot's failure to maintain clearance from a wire while intentionally maneuvering at a low altitude.NTSB WPR09LA117Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Turlock, CAThe loss of engine power due to carburetor icing resulting from the pilot's failure to apply carburetor heat. Contributing to the accident was the instructor's inadequate supervision of the flight.NTSB CEN09LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe pilot's improper flare and recovery from a bounced landing.NTSB WPR09CA107Accident · No injuriesData collectionFinal reportCessna 152 · Ellensburg, WAThe student pilot's failure to maintain directional control during the takeoff roll.Contributing to the accident was the student pilot's decision to initiate the takeoff with the airplane positioned near the left edge of the runway.NTSB ERA09CA142Accident · No injuriesData collectionFinal reportCessna 152 · Titusville, FLA loss of engine power during approach due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB ERA09LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Wauchula, FLA loss of engine power due to failure of the Number 3 connecting rod due to oil contamination. Contributing to the accident was the insufficient oil change time intervals performed by company personnel.NTSB WPR09CA073Accident · No injuriesData collectionFinal reportCessna 152 · Long Beach, CAThe student pilot's failuire to maintain directional control during takeoff.NTSB ERA09FA060Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Smithfield, RIThe pilot's improper descent below the published minimum descent altitude during the approach, which resulted in controlled flight into terrain.NTSB WPR09LA040Accident · 1 fatalLimited investigationFinal reportCessna 152 · Atwater, CAThe second pilot's failure to see and avoid the rotating propeller after exiting the airplane.NTSB CEN09CA066Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Bowling Green, MOFailure of the pilot to maintain aircraft control during the landing sequence. A contributing factor was the sudden gusty crosswind.NTSB ANC09LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Fairbanks, AKThe failure of the instructor pilot in the other airplane to maintain separation from the Cessna 182R, and his failure to follow the tower controller’s instructions.NTSB CEN09CA048Accident · No injuriesData collectionFinal reportCessna 152 · Spring, TXFailure of the student pilot to apply appropriate actions following a bounced landing.NTSB WPR09CA030Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Friant, CAThe student pilot's failure to execute a go-around in timely manner, which resulted in a collision with terrain. Also causal was the instructor's inadequate supervision of the flight and delayed remedial actions.NTSB WPR09CA002Accident · No injuriesData collectionFinal reportPiper J3C-65 · Lynden, WAThe separation of the tailwheel spring retaining clip for unknown reasons, which resulted in the loss of directional control during the landing roll.NTSB NYC08CA328Accident · No injuriesData collectionFinal reportHood Junior Ace · Ashville, ALThe pilot's improper flare while landing. Contributing to the accident was the airplane's lack of yaw control as reported by the pilot.NTSB LAX08LA299Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Carlsbad, CAThe loss of engine power during takeoff for undetermined reasons.NTSB ANC08CA124Accident · No injuriesData collectionFinal reportPiper PA-12 · Slana, AKThe pilot's excessive application of the brakes during the landing roll, resulting in a nose over and substantial damage.NTSB SEA08CA198Accident · No injuriesData collectionFinal reportCessna 152 · Columbia, CAThe student pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the student pilot's improper use of the throttle control.NTSB MIA08CA171Accident · Minor injuriesData collectionFinal reportCessna 152 · Ormond Beach, FLBoth pilots' inadequate preflight inspection of the fuel.