NTSB investigations: Lycoming 0-235 series
4,598 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 LAX90LA018Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Sonoma, CAThe failure of the pilot to maintain directional control during the landing roll.NTSB LAX90LA015Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1A · Borrego Springs, CAThe failure of the engine exhaust valve.NTSB ATL90LA021Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Lafayette, GAThe pilot's failure to abort the takeoff, when the airplane began to veer left during the takeoff roll. Contributing to the accident was the pilot's failure to inspect the airplane wheel for damage after it dropped off the runway during taxi.NTSB FTW90LA017Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Thibodaux, LAStudent pilot's failure to obtain or maintain airspeed during an aborted landing, which resulted in an inadvertent stall/mush. His failure to maintain runway alignment and the ditch were related factors.NTSB MKC90LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · St Louis, MODirectional control not maintained by the pilot in command. A contributing factor was the gusty crosswind.NTSB CHI90LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHThe pilot's improper flare and recovery from a bounced landing.NTSB NYC90LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Sterling, MAInflight loss of control due to inadvertent retraction of the wing flaps during a go around.NTSB CHI90LA004Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbus, OHThe student pilot's improper flare and improper recovery from a bounced landing.NTSB NYC90LA004Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Beaver Falls, PAThe right fuel vent became clogged allowing the left fuel tank to become exhausted. In addition, the pilot failed to adequately monitor the fuel supply in each tank.NTSB SEA89LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Alderwood Manor, WAInadequate compensation for wind conditions by the student pilot, and inadequate supervision by the instructor pilot (CFI), which resulted in a failure to maintain proper altitude. Factors related to the accident were: unfavorable (variable) wind, downdraft,…NTSB ANC89LA175Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Cottonwood Crk, AKImproper inflight planning/decision by the pilot and his failure to maintain adequate airspeed. Factors related to the accident were: the pilot's low pass over rising terrain and the aircraft's subsequent impact with alder bushes (high vegetation).NTSB MIA89FA253Accident · 2 fatalField investigationFinal reportCessna 172N · Ochopee, FLThe failure of the pilots of both airplanes to see and avoid each other while maneuvering.NTSB CHI89LA193Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Medina, OHThe pilot's improper flare and recovery from a bounced landing and his improper planning/decision which resulted in a situation from which an overrun occurred. Contributing factors were: the weather conditions, failure of the pilot to obtain a weather…NTSB LAX89FA318Accident · No injuriesField investigationFinal reportCessna 152 · Chandler, AZThe failure of the pilot's of both aircraft to maintain adequate visual outlook for other aircraft.NTSB ANC89LA172Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-105 · Port Moller, AKImproper planning/decision by the pilot. Factors related to the accident were: the pilot's self induced pressure and the adverse weather conditions.NTSB MIA89LA251Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Yulee, FLImproper planning/decision by the student pilot. Factors related to the accident were: the adverse weather conditions and the tree and ditch in the emergency landing area.NTSB FTW89DRG10Accident · 1 fatalFinal reportZenair CH-200 · Kerrville, TXImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB MIA89LA250Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fernandina Bch, FLThe private pilot's failure to maintain airspeed on final approach, which resulted in a stall/mush. The turbulence was a related factor.NTSB FTW89IA168Incident · No injuriesIncident investigationFinal reportCessna 152 · Bethany, OKFailure of the Cessna 150 pilot to see-and-avoid the Cessna 152 (inadequate visual lookout), and failure of the tower controller to provide adequate service. Factors related to the accident were: high traffic density, which resulted in frequency congestion,…NTSB SEA89LA169Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellensburg, WAThe pilot's failure to obtain current in-flight wind information in order to calculate that his remaining fuel supply was adequate to reach his final destination. Contributing was his inadequate preflight planning.NTSB LAX89LA308Accident · No injuriesLimited investigationFinal reportCessna 152 · Torrance, CAThe pilot's failure to maintain directional control during landing roll-out, which resulted a ground swerve. The pilot's relatively low level of flying experience and the berm beside the runway were related factors.NTSB CHI89LA182Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Newark, ILInadequate supervision by the flight instructor (CFI) and his delay in aborting the takeoff. Factors related to the accident were: malfunction of the flap system, which resulted in an improper flap setting for takeoff, and the soft runway condition.NTSB LAX89DVG10Accident · No injuriesFinal reportMinicab Hawk · Montaque, CAThe failure of the pilot to maintain directional control after landing.NTSB LAX89LA301Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Torrance, CAThe student pilot's improper flare and improper recovery from a bounced landing, which resulted in an inadvertent porpoise. A factor related to the accident was: the lack of training in recovery from bounced landings from her instructor pilot (CFI).NTSB BFO89LA073Accident · No injuriesLimited investigationFinal reportCessna 152 · Selbyville, DEExcessive wear of the number four exhaust lobe on the camshaft and poor condition (wear) of the number four exhaust tappet. The soybean crop in the emergency landing area was considered to be a factor.NTSB ANC89LA148Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcgrath, AKPilot-in-command's improper fuel consumption calculations, improper inflight planning, and decisions.NTSB MIA89LA227Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pensacola, FLThe pilot's failure to follow the checklist and ensure that the elevator trim tab was adjusted properly for takeoff.NTSB CHI89LA156Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kankakee, ILFailure of the student pilot to use carburetor heat, which resulted in loss of engine power, due to carburetor ice. A factor related to the accident was: carburetor icing conditions.NTSB MKC89LA172Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft Smith, ARInadequate preflight by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. A contributing factor was the road sign.NTSB CHI89LA148Accident · No injuriesLimited investigationFinal reportGrumman AA-1C · Madison, INThe student's failure to maintain directional control of the aircraft and the cfi's delay in taking remedial action to regain control. Contributing to the accident was the students lack of total experience.NTSB DEN89FA177Accident · 1 fatalField investigationFinal reportCessna 152 · Logan, UTInadequate preflight and improper inflight planning/decision by the student, which resulted in fuel exhaustion from an inadequate supply of fuel, and the student's failure to maintain airspeed, while maneuvering, which resulted in an inadvertent stall/spin. A…NTSB ANC89LA126Accident · No injuriesLimited investigationFinal reportCessna 140 · Nyac Mine, AKFailure of the left rudder pedal bar assembly and failure of the pilot to maintain control of the aircraft. Improper maintenance and the pilot's lack of total experience were considered to be contributing factors.NTSB ATL89DMG04Accident · No injuriesFinal reportWittman, S.J. W-8 · Washington, NCPilot inadvertently stalled the airplane.NTSB CHI89LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Grosse Ile, MIThe student pilot's not correcting the porpoise on the first landing. A factor in the accident is the lack of experience of the student pilot.NTSB MIA89FA192Accident · No injuriesField investigationFinal reportCessna 152 · Miami Lakes, FLThe failure of the pilot to visually inspect the airplane fuel tanks during the preflight inspection to assure adequate fuel to conduct the flight was available.NTSB CHI89LA130Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Indianapolis, INImproper recovery from a bounced landing and failure to maintain directional control by the pilot. The student pilot's lack of flight experience contributed to the accident.NTSB DEN89FA155Accident · Serious injuriesField investigationFinal reportPiper PA-16 · Minot, NDFailure of the airframe tubing (longeron) at the lower forward door frame due to corrosion. A contributing factor was failure of maintenance personnel to comply with service bulletin #819.NTSB NYC89LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Plattsburgh, NYThe pilot's improper flare, improper recovery from a bounced landing, and failure to maintain directional control.NTSB FTW89FA127Accident · 2 fatalField investigationFinal reportPiper PA-12 · Sanger, TXFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall at low altitude.NTSB NYC89LA160Accident · No injuriesLimited investigationFinal reportCessna 152 · Oneida, NYLoss of directional control during landing due to wind change. The aircraft landed hard on the runway due to improper flare by the pilot and a delayed response to the ballooning of the acft.NTSB LAX89DVM04Accident · Serious injuriesFinal reportProgress Aero R&D Discovery · Chualar, CAThe experimental aircraft's inadvertent entry into a non-recoverable flat spin during a slow airspeed test; the aerodynamic characteristics that produced the spin were not determined.NTSB NYC89DHA01Accident · No injuriesFinal reportVehafric Jungster ONE · Reading, PAThe failure of the pilot to properly use carburetor heat.NTSB LAX89LA227Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Julian, CAThe failure of the pilot to select the proper runway for existing wind conditions and to execute a go-around when touchdown at the proper point was not accomplished.NTSB ANC89LA101Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Alder Creek, AKSelection of unsuitable terrain (unimproved strip) by the pilot. Soft/uneven terrain & low bushes on the strip, as well as alders beside the strip, were contributing factors.NTSB FTW89LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Kaufman, TXStudent pilot inadvertently becoming lost/disoriented and exhausting the fuel in the fuel system.NTSB NYC89LA147Accident · Minor injuriesLimited investigationFinal reportPiper J-3C-65 · Erma, NJFailure of the pilot to maintain airspeed during a banner pickup.NTSB CHI89LA106Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Elyria, OHFailure (shearing) of the right main gear attaching bolts. A contributing factor was: failure of the owner/operator to comply with service bulletin #673B.NTSB MIA89LA169Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lauderdale, FLThe pilot's late flare which resulted in a hard landing that exceeded the design stress limits of the airplane.NTSB BFO89LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Dover Afb, DEThe pilot's improper flare, improper recovery from a bounced landing, and his delay in initiating a go-around, which resulted in an uncontrolled porpoise, loss of directional control, and an uncontrolled ground swerve. His lack of experience, a crosswind, and…NTSB ANC89LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Anaktuvuk Pass, AKThe pilot failed to adequately compensate for downdrafts encountered after departing a gravel bar that was surrounded by mountainous terrain.