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 NYC96LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Farmingdale, NYloss of engine power for undetermined reasons.NTSB ATL96LA070Accident · No injuriesLimited investigationFinal reportO'Connell Christen Eagle · New Smyrna Bch, FLthe failure of the pilots of the Cessna 152, N757NP, to see and avoid the Christen Eagle, N13LD.NTSB NYC96LA079Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Groton, NYthe pilot's inadequate fuel management, and his improper use of the fuel selector valve, which resulted in fuel starvation and the subsequent collision with bails of hay during the forced landing.NTSB SEA96LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Lynnwood, WAa loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB LAX96LA145Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlsbad, CAinadequate preflight by the pilot, and subsequent fuel exhaustion, due to an inadequate supply of fuel. Darkness and trees in the emergency landing area were related factors.NTSB FTW96LA154Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Slidell, LAthe pilot's failure to maintain aircraft control during the approach, and his failure to execute a go-around. A factor was the gusting wind.NTSB CHI96LA114Accident · No injuriesLimited investigationFinal reportCessna 152 · Lambertville, MIFailure of the student pilot to maintain directional control of the airplane during the takeoff roll. The snowbank was a related factor.NTSB ANC96LA036Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Chugiak, AKthe pilot's selection of an unsuitable area for landing.NTSB MIA96LA102Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lauderdale, FLthe pilot misjudged the clearance between the fuel trucks.NTSB ATL96LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Baxley, GAthe pilot's improper flare, which resulted in a hard landing, a collapsed nose gear, and a subsequent nose over.NTSB ATL96LA062Accident · No injuriesLimited investigationFinal reportCessna 152U · Rincon, GAInaccurate fuel consumption calculations by the pilot, and an inadequate supply of fuel, which resulted in fuel exhaustion and subsequent nose over of the airplane, during a forced landing on uneven terrain with high vegetation (small trees).NTSB LAX96LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Las Vegas, NVthe student pilot's improper flare and improper recover from a bounced landing, which resulted in a hard landing and collapse of the nose gear. A factor relating to the accident was: the flight instructor's inadequate instruction concerning recovery from…NTSB LAX96LA109Accident · No injuriesLimited investigationFinal reportCessna 152 · San Jose, CAthe student pilot's improper use of the rudder control and resultant failure to maintain directional control of the airplane during the landing rollout. Factors relating to the accident were: the student allowed the airspeed to be excessive during the…NTSB NYC96LA060Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mattituck, NYthe student pilot's inadequate inflight decision and inadequate evaluation of the weather which resulted in a downwind landing and runway overrun. The student pilot's failure to follow directives was a contributing factor.NTSB FTW96LA109Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Grand Prairie, TXa loss of power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB ATL96LA039Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenville, SCthe failure of the student pilot to maintain airspeed while raising the flaps during the go-around.NTSB FTW96LA105Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Falfurrias, TXfuel starvation due to the pilot's improper positioning of the fuel selector. A factor was the lack of suitable terrain for the forced landing.NTSB MIA96LA065Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe student pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, which resulted in a ground swerve and subsequent overload failure of the nose gear.NTSB ATL96LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Myers, FLthe student pilot's improper flare to touchdown.NTSB FTW96LA087Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Port Mansfield, TXDeer running onto the runway as the student pilot was landing. A factor relating to the accident was: the soft terrain that was encountered as the pilot was maneuvering to avoid a collision.NTSB LAX96FA082Accident · No injuriesField investigationFinal reportCessna 152 · Long Beach, CAa partial power loss due to carburetor icing resulting from existing environmental conditions and the pilot's failure to apply carburetor heat during descent.NTSB LAX96FA080Accident · Minor injuriesField investigationFinal reportCessna 152 · Compton, CAa push rod failed from fatigue as a result of longitudinal stress corrosion cracking.NTSB CHI96LA055Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Mason, MIthe improper application of the throttle by the pilot resulting in a delayed engine response, and the improper decision by the pilot to make a long fast touchdown requiring the need to take off under powerlines.NTSB MIA96LA040Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe pilot-in-command's failure to assure an adequate amount of fuel was available for the flight.NTSB SEA96LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Chimacum, WAthe pilot-in-command's delayed application of carburetor heat which resulted in a power loss due to carburetor ice. Carburetor icing conditions, a short takeoff area, and a ditch at the end of the airstrip were factors.NTSB BFO96LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Stanton, KYwas the student pilot's failure to maintain directional control of the aircraft. The student pilot's lack of experience was a related factor.NTSB LAX96LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Hayward, CAloss of engine power for an undetermined reason.NTSB SEA96FA022Accident · 1 fatalField investigationFinal reportCessna 152 · Provo, UTpilot suicide (intentional in-flight collision with rising terrain). A factor relating to the accident was: pilot anxiety/apprehension.NTSB FTW96LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Marietta, OKthe pilot's failure to maintain directional control. A factor was the wet grass runway.NTSB CHI96LA022Accident · Serious injuriesLimited investigationFinal reportPiper J-3C · Rochester, INfailure of the pilot to maintain adequate airspeed after takeoff, which resulted in a stall. A factor relating to the accident was: the gusty wind condition.NTSB LAX96LA017Accident · No injuriesLimited investigationFinal reportCessna 152 · Mobile, AZa loss of engine power for undetermined reasons.NTSB CHI96LA004Accident · No injuriesLimited investigationFinal reportCessna 152II · Troy, MIthe pilot's inadequate recovery from a bounced landing. A factor associated with the accident was the quartering tailwind condition and the pilot's selection of the wrong runway on which to land.NTSB SEA96LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot's failure to maintain directional control. A factor to the accident was inadequate remedial action.NTSB LAX95LA347Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Ana, CAthe second pilot's failure to maintain directional control and the first pilot's improper supervision of the flight.NTSB LAX95LA349Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Placerville, CAthe student pilot's failure to obtain a proper descent rate and improper remedial by failing to initiate a go-around. The inadvertent stall and the gusty wind conditions were factors in this accident.NTSB MIA95FA224Accident · 3 fatalField investigationFinal reportAerospatiale TB-9 · New Smyrna Bch, FLthe failure of the pilots of both aircraft to see and avoid each other.NTSB MIA95LA219Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Sarasota, FLThe pilot's failure to abort the takeoff resulting in a premature takeoff, and subsequent in-flight collision with terrain. The pilot's failure to perform the necessary performance data computations for the flight and his diverted attention due to…NTSB ANC95LA165Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's inadequate compensation for the wind conditions. A factor relating to the accident was: the gusty crosswind condition.NTSB CHI95LA315Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Milwaukee, WIthe pilot's premature liftoff which resulted in a stall.NTSB BFO95LA091Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Martinsburg, WVthe student pilot's failure to maintain control of the airplane during the landing/aborted landing sequence. A related factor is the student pilot's lack of total flight experience.NTSB ATL95LA163Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kissimmee, FLThe inadequate visual lookout by the driver of the vehicle. A factor in the accident was the inoperative anti-collision lights of the aircraft.NTSB NYC95LA204Accident · No injuriesLimited investigationFinal reportCessna 152 · Orson, PAThe pilot's improper planning/decision, and his delay in aborting the takeoff, which resulted in a collision with a pile of dirt and shrubs. The upsloping terrain (for takeoff) was a factor.NTSB CHI95LA294Accident · No injuriesLimited investigationFinal reportCessna 152 · Ypsilanti, MIthe pilot misjudged the flare. Lack of total experience was a factor.NTSB CHI95LA280Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Champaign, ILthe pilot's failure to maintain directional control of the airplane during takeoff.NTSB LAX95LA288Accident · No injuriesLimited investigationFinal reportCessna 152 · Camarillo, CAThe failure of the landing gear strut due to fatigue.NTSB CHI95LA256Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Naperville, ILThe pilot's failure to maintain directional control during the takeoff roll. Contributing factors were the pilot's lack or recent experience in tailwheel equipped aircraft and failure to abort the takeoff early enough to prevent the accident.NTSB ATL95LA146Accident · No injuriesLimited investigationFinal reportCessna 152A · Sanford, FLThe pilot's failure to maintain directional control during the takeoff portion of a touch and go landing.NTSB NYC95LA180Accident · No injuriesLimited investigationFinal reportWright JUNGSTER-I · Mansfield, MAthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall and subsequent uncontrolled descent and collision with the terrain.NTSB FTW95LA324Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Raton, NMThe pilot's inadvertent activation of the flaps. Factors in the accident were the weather conditions and the dark night.NTSB LAX95LA270Accident · No injuriesLimited investigationFinal reportBeech 77 · Madera, CAThe student pilot's improper compensation for the wind condition and improper use of the rudder. The whirlwind was a factor in this accident.