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 CHI06FA010Accident · 4 fatalField investigationFinal reportPlavcan Lancair 235 · Rootstown, OHThe failure of both pilots to maintain an adequate visual lookout during cruise flight, which resulted in their failure to see and avoid each other and a midair collision.NTSB DFW06CA005Accident · No injuriesData collectionFinal reportCessna 152 · Tupelo, MSThe pilot's failure to maintain adequate visual lookout during taxi. Contributing factors were the dark night conditions, the unmarked light pole, and the lack of taxiway centerline markings at the parking area.NTSB SEA05LA196Accident · No injuriesLimited investigationFinal reportCessna 152 · Olympia, WAThe pilot's loss of aircraft control during landing roll, and airplane's subsequent inadvertent ground loop.NTSB ANC05CA148Accident · No injuriesData collectionFinal reportAeronca 7AC · Coldfoot, AKThe pilot's misjudgment of distance/altitude during the landing flare/touchdown, which resulted in an undershoot and subsequent nosing down of the airplane when the main landing gear tires contacted shallow water prior to the intended landing site.NTSB DEN05LA141Accident · 2 fatalLimited investigationFinal reportDenight 100D2 · Hudson, COthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.NTSB LAX05FA296Accident · 2 fatalField investigationFinal reportCessna 152 · Lakewood, CAthe certified flight instructor's failure to maintain an adequate airspeed resulting in a stall and loss of control. Also causal was the engine's loss of partial power due to inadequate maintenance, worn spark plugs, worn pistons, and broken piston rings.NTSB DFW05CA234Accident · No injuriesData collectionFinal reportCessna 152 · Galveston, TXThe pilot's improper in-flight planning and decisions, which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX05CA285Accident · No injuriesData collectionFinal reportBellanca 7ECA · Malibu, CAa partial loss of engine power for undetermined reasons.NTSB LAX05CA282Accident · No injuriesData collectionFinal reportBellanca 7ECA · San Jose, CAthe pilot's failure to maintain directional control of the airplane during the landing flare, which resulted in a collision with an runway sign.NTSB DFW05CA224Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe pilot's improper recovery from a bounced landing. A contributing factor was the dark night conditions.NTSB SEA05FA181Accident · 2 fatalField investigationFinal reportPiper PA-14 · Challis, IDThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin to the ground. A contributing factor was the pilot's diverted attention while spotting/locating Rocky Mountain Bighorn sheep.NTSB NYC05LA139Accident · No injuriesLimited investigationFinal reportTerrio Pober Jr Ace · Oxford, CTA fractured oil pressure line, which resulted in the fracture of the number 3 cylinder connecting rod bearing, and subsequent loss of engine power.NTSB MIA05FA152Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Freeport, FLThe failure of the pilot to maintain airspeed resulting in inadvertent stall, uncontrolled descent, and in-flight collision with terrain.NTSB DFW05CA218Accident · No injuriesData collectionFinal reportCessna 152 · Bridgeport, TXThe pilot's inadequate compensation for wind conditions, and the flight instructor's delayed remedial action during a crosswind landing resulting in a loss of directional control.NTSB CHI05CA240Accident · No injuriesData collectionFinal reportPiper PA-12 · Boscobel, WIThe separation of the right main landing gear attachment bracket bolt during the landing and the pilot's aircraft control not possible with the collapsed gear.NTSB DEN05CA129Accident · No injuriesData collectionFinal reportPiper PA-18A-135 · Cedaredge, COthe pilot's failure to maintain aircraft control, and the pilot's improper in-flight planning. Contributing to the accident was the wind shift, resultant tailwind, and the inadvertent stall.NTSB ANC05CA122Accident · No injuriesData collectionFinal reportPiper PA-12 · Arctic Village, AKThe pilot's inadequate evaluation of the weather conditions, which resulted in an overrun and subsequent nose over during the landing roll. A factor contributing to the accident was a tailwind.NTSB SEA05CA156Accident · No injuriesData collectionFinal reportPiper PA-20-115 · Weiser, IDThe pilot's failure to maintain directional control during the landing roll, and his application of excessive braking as the aircraft started to depart the side of the runway.NTSB SEA05CA154Accident · Minor injuriesData collectionFinal reportGrumman American AA1B · Camas, WAThe student pilot's failure to maintain aircraft control during landing roll. A contributing factor was the gusty cross-wind weather condition.NTSB SEA05CA150Accident · No injuriesData collectionFinal reportAmerican Champion 7ECA · Hailey, IDThe pilot's inadequate recovery from a bounced landing and his failure to maintain directional control during the landing roll. Factors include a crosswind, and soft terrain just off the side of the runway surface.NTSB SEA05CA148Accident · No injuriesData collectionFinal reportPiper PA-16 · Park City, MTThe failure of the pilot to maintain directional control of the airplane on the takeoff roll. Factors contributing to the accident included the loose gravel, ditch, and the fence.NTSB LAX05CA238Accident · No injuriesData collectionFinal reportCessna 152 · Rio Vista, CAthe student pilot's inadequate recovery from a bounced landing and his failure to maintain directional control of the airplane during landing rollout. A contributing factor was the student's failure to divert to an airport with less severe crosswind…NTSB ATL05CA134Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH2000 · Winston-Salem, NCThe student pilot's misjudged flare and his improper recovery from a bounced landing resulting in a stall and hard landing.NTSB DFW05CA157Accident · Serious injuriesData collectionFinal reportGrumman AA1B · Llano, TXThe partial loss of engine power for undetermined reasons during takeoff resulting in an overrun. A factor was the high density altitude.NTSB ATL05CA120Accident · No injuriesData collectionFinal reportGrumman American AA-1B · Durham, NCThe pilot's failure to maintain directional control. Factors were soft and wet terrain.NTSB MIA05CA128Accident · No injuriesData collectionFinal reportCessna 152 · St. Augustine, FLThe failure of the student pilot to maintain directional control during the landing roll resulting in the on-ground encounter with wet grass and subsequent nose over.NTSB MIA05CA125Accident · No injuriesData collectionFinal reportCessna 152 · Williston, FLThe inadequate weather evaluation by the pilot-in-command which resulted in the in-flight encounter with rain and thunder that resulted in a precautionary landing and subsequent on-ground collision with a ditch.NTSB SEA05LA134Accident · 1 fatalLimited investigationFinal reportJones Long EZ · Marsing, IDThe pilot's failure to maintain airspeed during landing, and his subsequent delay in attempting a recovery from a bounced landing. A contributing factor was the taxiway berm.NTSB DEN05LA099Accident · No injuriesLimited investigationFinal reportCampbell Long EZ · Santa Fe, NMthe inflight collision with a bird(s).NTSB NYC05CA112Accident · No injuriesData collectionFinal reportCessna 152 · Greenville, PAThe student pilot's improper flare, and inadequate recovery from a bounced landing, which resulted in a nose gear collapse while landing.NTSB ATL05CA104Accident · No injuriesData collectionFinal reportCessna 152 · Naples, FLThe CFI's mismanagement of the fuel supply, which resulted in fuel exhaustion.NTSB DFW05CA164Accident · No injuriesData collectionFinal reportCessna 152 · Burneyville, OKThe students pilot's improper flare and his failure to maintain directional control of the airplane. A contributing factor was the bounced landing.NTSB ATL05CA097Accident · No injuriesData collectionFinal reportCessna 152 · Fort Payne, ALThe intentional unauthorized use of a stolen aircraft by an unqualified person which resulted in a hard landing and substantial damage to the airplane.NTSB DFW05CA154Accident · No injuriesData collectionFinal reportCessna 152 · Marietta, OKThe pilot's failure to maintain directional control while executing a soft field take off. A factor was the prevailing dark night conditions.NTSB IAD05FA069Accident · 1 fatalField investigationFinal reportAmerican AA-1A · Levittown, PAThe pilot's improper in-flight planning which resulted in a total loss of engine power due to fuel exhaustion. A factor in the accident was the pilot's failure to maintain airspeed during the forced landing, resulting in an inadvertent stall and uncontrolled…NTSB DFW05CA136Accident · No injuriesData collectionFinal reportCessna 152 · Conroe, TXThe pilot's improper in-flight planning resulting in a total loss of engine power due to 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 SEA05CA096Accident · No injuriesData collectionFinal reportPiper PA-12 · Snohomish, WAThe pilot's failure to maintain aircraft control during the landing roll on a sandbar which resulted in the aircraft nosing over.NTSB LAX05LA158Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · San Luis Obispo, CAa loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat.NTSB IAD05CA059Accident · No injuriesData collectionFinal reportCessna 152 · Millville, NJThe pilot's misjudgment of the airplane's distance to the restaurant sundeck.NTSB CHI05CA107Accident · No injuriesData collectionFinal reportWhittman Tailwind · Lyndon, KSThe pilot improper recovery from a bounced landing, and his inadequate compensation for a tailwind, which resulted in a loss of control and subsequent collision with the ground. Contributing to the accident was the pilot's selection of a wrong runway, the…NTSB DFW05CA108Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH-2000 · Panhandle, TXThe student pilot's improper compensation for existing wind conditions. Contributing factors were the crosswind and inadequate supervision by the flight instructor.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 NYC05FA069Accident · 2 fatalField investigationFinal reportCessna 152 · Williamsburg, OHAn improperly installed rudder bumper, which resulted in a rudder jam during spin training and subsequent uncontrolled descent into terrain. A factor was the operator did not comply with the service bulletin.NTSB DFW05CA101Accident · No injuriesData collectionFinal reportCessna 152 · Stillwater, OKThe student pilot's failure to maintain directional control during landing.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 DFW05CA097Accident · No injuriesData collectionFinal reportCessna 152 · Shawnee, OKThe pilot's improper landing flare and his inadequate recovery from a bounced landing. A factor was the prevailing crosswind.NTSB ATL05CA070Accident · No injuriesData collectionFinal reportCessna 152 · Goose Creek, NCThe student pilot's failure to maintain direction control, which resulted in a loss of control and collision with a berm.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 SEA05LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Covington, WAThe failure of connecting rods during cruise flight resulting in a loss of engine power. Trees were a factor.