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 ATL02LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Elberton, GAThe student pilot's in-flight decision to land in a field, which resulted in an on-ground collision with a berm. Factors were the student's inadequate training and inadequate supervision by the flight instructor on the ground.NTSB NYC02LA018Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Batavia, OHMalfunction of an exhaust valve. A factor was the pilot/owner's failure to comply with the engine manufacturer's service instructions.NTSB FTW02LA021Accident · No injuriesLimited investigationFinal reportCessna 152 · Bethany, OKthe mechanic's failure to properly lock the exhaust valve's clearance adjusting screw locknut, which resulted in a loose nut, disabling of the exhaust valve pushrod, and a partial loss of engine power while in cruise flight. A contributing factor was the…NTSB LAX02LA012Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Henderson, NVFuel exhaustion during cruise flight due to the pilot's improper in-flight decision. A contributing factor was his improper preflight planning.NTSB LAX02LA009Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Chandler, AZThe Bellanca pilot's failure to maintain directional control while taxiing due to his improper brake usage.NTSB SEA02FA005Accident · 2 fatalField investigationFinal reportPiper PA-18 · Sandy, ORThe pilot's failure to maintain clearance from the trees while attempting to land in a field after entering an area of instrument meteorological conditions. Factors include low ceilings, rain, fog, strong winds, mountainous/hilly terrain, the pilot's…NTSB SEA01LA176Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Estacada, ORThe pilot's failure to maintain directional control of the aircraft during the takeoff ground roll. A tailwind, fence and the pilot's lack of total experience in the type of aircraft were factors.NTSB ANC01LA135Accident · Serious injuriesLimited investigationFinal reportColburn Murphy Rebel · Kotzebue, AKThe pilot's inadequate compensation for wind conditions during takeoff. Factors associated with the accident were variable winds, and trees.NTSB ANC01LA130Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKA failure of the pilot to maintain directional control of the airplane during the takeoff run.NTSB FTW01FA188Accident · 1 fatalField investigationFinal reportCessna 152 · Weatherford, TXThe student pilot's improper decision making in that he landed with a tailwind and failed to execute a go-around, which resulted in a runway overrun. Contributing factors were the inaccurate reading of the left fuel gage as a result of improper maintenance by…NTSB ANC01LA115Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Palmer, AKThe pilot's selection of an unsuitable takeoff area. A factor associated with the accident was rough/uneven terrain.NTSB NYC01LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Newark, OHThe student pilot's failure to maintain aircraft control during an aborted landing. A factor in this accident was the crosswind conditions.NTSB CHI01LA272Accident · No injuriesLimited investigationFinal reportCessna 152 · Peru, ILThe pilot's inadequate recovery from a bounced landing. Factors associated with the accident were improper touchdown point, rough terrain, and the nose gear collapse.NTSB FTW01LA174Accident · No injuriesLimited investigationFinal reportCessna 152 · Denison, TXthe pilot's delay in aborting the takeoff, which resulted in a runway overrun.NTSB MIA01LA209Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Statesville, NCThe pilot's attempted takeoff with a tail wind and his failure to maintain directional control of the airplane during takeoff resulting in the airplane veering to the left and colliding with trees.NTSB ANC01LA097Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe loss of left brake pressure due to a missing hydraulic brake fitting.NTSB MIA01LA201Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, FLThe failure of the pilot of N89803 to insure his brakes were set and that the airplane was not rolling prior to diverting his attention to duties inside the cockpit, resulting in N89803 rolling forward and colliding with N8660Q which was parked in front of…NTSB MIA01LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe student pilot's improper recovery from a bounced landing resulting in a hard landing on the nose landing gear, collapse of the nose landing, the airplane sliding off the runway, and the airplane being destroyed by a postcrash fire.NTSB LAX01LA263Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAthe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion and loss of engine power while on approach for landing.NTSB IAD01LA084Accident · No injuriesLimited investigationFinal reportCessna 152 · Gallipolis, OHcollision with a deer during take-off roll.NTSB CHI01LA228Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tracy, MNThe inadvertent stall during the initial takeoff. Factors relating to the accident were the student pilot's premature lift-off of the airplane during the initial takeoff, the instructor pilot's inadequate supervision, and the fences.NTSB FTW01LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Springdale, ARthe instructor's failure to refuel the airplane, which resulted in fuel exhaustion.NTSB IAD01LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Millville, NJThe student pilot's failure to compensate for wind conditions and his failure to maintain directional control during landing. A factor was the crosswind.NTSB ANC01LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Haines, AKThe pilot's failure to maintain directional control during the takeoff roll. Factors associated with the accident are the pilot's selection of unsuitable terrain for takeoff, and a rough/uneven takeoff area.NTSB CHI01LA210Accident · No injuriesLimited investigationFinal reportCessna 140 · Spearfish, SDThe pilot failed to maintain directional control of the airplane during the landing. Factors associated with the accident were the pilot's inadequate recovery from a bounced landing and his lack of experience in the make and model of the accident airplane.NTSB NYC01FA169Accident · 2 fatalField investigationFinal reportGrumman American AA-1C · Medford, NJThe pilot's improper use of the flight controls while turning to base, which resulted in a stall/spin and subsequent impact with the ground.NTSB SEA01LA128Accident · No injuriesLimited investigationFinal reportTibert Baby Lakes · Stevensville, MTThe pilot's failure to maintain directional control of the tailwheel-equipped aircraft during the landing roll. Factors include the pilot's low total time in this make and model aircraft and his lack of recent experience in this make and model aircraft.NTSB CHI01LA198Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Stillwater, MNThe loss of engine power for undermined reasons and the unsuitable terrain encountered during the forced landing. Additional factors included the power line and the trees.NTSB NYC01LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Manassas, VAThe student pilot's loss of control of the airplane after bouncing the landing. A factor in the accident was her heightened anxiety over making her first solo landing.NTSB NYC01LA157Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrenton, VAThe airplane's encounter with a deer during a touch and go.NTSB SEA01LA122Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Bozeman, MTThe pilot of another aircraft failed to maintain clearance while maneuvering for a formation flight. An updraft was a factor.NTSB MIA01LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Tampa, FLThe pilot's failure to maintain a visual look out while taxing an airplane for parking resulting in an on ground collision with a fixed object (Hangar/Building.)NTSB MIA01LA173Accident · No injuriesLimited investigationFinal reportBeech 77 · Rock Hill, SCThe poor weather evaluation by the pilot for landing with a tailwind and failure of the pilot to perform a go-around after the first bounced landing.NTSB FTW01LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Lapace, LAthe student pilot flared the airplane high, which resulted in a hard landing.NTSB MIA01LA167Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Oak Hill, FLA partial loss of engine power while at a low altitude cruise due to fuel contamination, and the subsequent emergency descent and landing to a rural road resulting in collision with tree and mailbox post.NTSB IAD01LA062Accident · No injuriesLimited investigationFinal reportEaa Chapter 40 Cubby Sport Trainer · Elkton, MDThe Cubby pilot's inadequate visual lookout for the Bellanca on the runway, prior to landing.NTSB FTW01LA135Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Amarillo, TXthe pilot's inadequate compensation for the crosswind, which resulted in a hard landing. A contributing factor was the crosswind.NTSB MIA01LA149Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Greensboro, NCthe pilot's failure to maintain airspeed during takeoff/initial climb, which resulted in an inadvertent stall, an uncontrolled descent, and collision with trees.NTSB CHI01LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Patriot, INthe inadequate rotation speed and compensation for wind conditions by the pilot. Contributing factors were the crosswind and gust.NTSB SEA01LA102Accident · 1 fatalLimited investigationFinal reportPiper PA-18-105 Special · Wilbur, WAA collision with terrain for undetermined reasons.NTSB CHI01LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Roscommon, MIThe failure of the pilot to maintain clearance from the tree line. Factors to the accident were the tailwind, the aircraft being near gross weight, the high density altitude, the rough runway condition, and the tree line. An additional factor to the accident…NTSB IAD01LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Easton, MDThe pilot's improper landing flare. A factor was the crosswind.NTSB LAX01LA168Accident · Minor injuriesLimited investigationFinal reportBeech BE77 · Riverside, CAThe student pilot's failure to maintain appropriate airspeed and to configure the airplane for climb-out.NTSB LAX01LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Hayward, CAthe student pilot's misjudged landing flare and improper use of the elevator control.NTSB CHI01LA122Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Kimball, NEThe pilot not maintaining clearance from the terrain. A factor was that the pilot misjudged the low altitude flight maneuver.NTSB LAX01LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZThe pilot's premature flare, which resulted in an inadvertent stall and a bounced landing. A factor was the improper recovery from a bounced landing.NTSB MIA01LA113Accident · 1 fatalLimited investigationFinal reportLarry R. Kinsey Variez O-235 · Pinson, ALThe pilot's continued visual flight rules flight into instrument meteorological conditions resulting in the airplane colliding with mountainous terrain.NTSB ANC01LA045Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Palmer, AKThe pilot's selection of an unsuitable takeoff area. A factor associated with the accident was rough/uneven terrain.NTSB ANC01LA044Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Cooper Landing, AKThe pilot's continued VFR flight into instrument metrological conditions during cruise flight. Factors associated in the accident were low ceilings, whiteout conditions, and snow-covered terrain.NTSB FTW01LA078Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Oklahoma City, OKthe loss of engine power during the initial takeoff climb for an undetermined reason, which resulted in a forced landing. A contributory factor to the accident was the lack of suitable terrain for the forced landing.