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 NYC04CA121Accident · No injuriesData collectionFinal reportCessna 152 · Pottstown, PAThe student pilot's failure to maintain directional control during landing, and the flight instructor's delayed remedial action.NTSB CHI04LA112Accident · 1 fatalLimited investigationFinal reportGrumman American AA-1B · Dodge Center, MNThe pilot's failure maintain climb and his failure to maintain clearance from the terrain during initial climb out after takeoff. The aircraft's low altitude, high gusty winds and low level turbulence were contributing factors.NTSB ATL04CA102Accident · No injuriesData collectionFinal reportPiper PA-18 · Cedartown, GAThe pilot's improper use of brakes during landing roll which resulted in the airplane nosing over.NTSB FTW04LA114Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Seminole, OKThe pilot's inadequate pre-flight planning. A contributing factor was the pilot's use of unsuitable terrain for takeoff.NTSB SEA04LA067Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Hardin, MTThe pilot's failure to perform a go-around. Contributing factors were the pilot's misjudgment of speed and distance and the tree.NTSB LAX04LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Martin, CAthe loss of engine power for undetermined reasons.NTSB LAX04CA181Accident · No injuriesData collectionFinal reportPiper PA-38-112 · McKinleyville, CAa loss of engine power due fuel exhaustion, which was caused by the pilot's inadequate in-flight planning/decision, inadequate in-flight fuel consumption calculations, and failure to divert to an alternate airport before the fuel situation became critical.…NTSB IAD04CA014Accident · Minor injuriesData collectionFinal reportCessna 152 · Hamilton, OHThe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and the loss of engine power. The student pilot becoming lost/disoriented is a contributing factor.NTSB ATL04LA087Accident · Serious injuriesLimited investigationFinal reportAircraft Mfg & Development Alarus CH2T · Bay Minette, ALThe pilot's inadequate inflight decision which resulted in continued VFR flight into IMC conditions, and his failure to maintain clearance which resulted in a collision with trees. A factor was the fog.NTSB NYC04LA090Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, KYThe total loss of engine power due to a total loss of engine oil for undetermined reasons, which resulted in a forced landing and subsequent collision with trees.NTSB LAX04FA167Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Jean, NVThe student pilot's failure to regain control of the aircraft following an upset due to the disconnected primary right aileron control cable. The failure of the company maintenance personnel to detect and correct the improperly secured turnbuckle fitting at…NTSB LAX04LA156Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Selma, CAThe pilot's inadequate preflight planning, which failed to assure adequate takeoff performance, and his failure to abort the takeoff. The aircraft inadequate weight and balance was a contributing factor.NTSB FTW04LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Sugar Land, TXThe pilot's improper weather evaluation, and his encounter with adverse weather conditions. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB NYC04CA080Accident · No injuriesData collectionFinal reportBellanca 7ECA · Hornell, NYAn inadvertent encounter with soft snow during takeoff.NTSB SEA04LA044Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Laurel, MTThe student pilot's failure to maintain aircraft control during the landing roll. Inadequate remedial action was a factor.NTSB NYC04LA075Accident · No injuriesLimited investigationFinal reportCessna 152 · Spencer, MAA loss of engine power for undetermined reasons.NTSB DEN04LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · West Jordan, UTthe failure of the exhaust valve for the engine's number one cylinder, resulting in the exhaust valve/piston contact and the subsequent total loss of engine power. Contributing factors include the lack of suitable terrain for a forced landing and the snow…NTSB LAX04CA134Accident · No injuriesData collectionFinal reportBellanca 7ECA · Groveland, CAthe pilot's failure to maintain a proper glide path and misjudged landing flare, which resulted in a hard landing. Also causal was the pilot's inadequate recovery from a bounced landing, resulting in a loss of directional control and collision with terrainNTSB LAX04CA099Accident · No injuriesData collectionFinal reportCessna 152 · San Diego, CAthe pilot's misjudgment of clearance from the vehicle while taxiing. A factor in the accident was the pilot's diverted attention.NTSB ANC04LA017Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Togiak, AKA loss of engine power due to an undetermined reason that resulted in a forced landing, a collapse of the main landing gear, and a collision with trees. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB LAX04LA079Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Oxnard, CAthe failure of the pin that secured the right rudder pedal to the brake cylinder arm due to improper installation of the pin. Also causal was the manufacturer's confusing maintenance instructions regarding the installation of the right rudder pedal pin and…NTSB DEN04LA032Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Edgewood, NMthe pilot's inadequate in-flight planning and decision making. Factors contributing to the accident include the resulting fuel exhaustion, the snow covered field and the fence.NTSB ATL04LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Louisburg, NCOther maintenance personnel's inadequate engine overhaul that resulted in engine case fretting and engine oil starvation.NTSB NYC04LA045Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Butler, PAThe student pilot's improper use of carburetor heat, which resulted in a total loss of engine power during cruise flight. A factor was carburetor icing conditions.NTSB CHI04LA039Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIThe loss of engine power for undetermined reasons. A factor to the accident was the tree line and the unsuitable terrain.NTSB FTW04LA020Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Mineral Wells, TXthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB MIA04CA010Accident · Minor injuriesData collectionFinal reportCessna 152 · Pierson, FLIn flight collision with a bird, resulting in airplane not being able to maintain altitude and nosing over during a forced landing on unsuitable terrain.NTSB LAX04LA022Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · San Martin, CAThe absence of compression in two of the airplane's four cylinders, and the pilot/mechanic's failure to maintain the engine in an airworthy condition, which resulted in a loss of engine power during takeoff-initial climb, and subsequent forced landing.NTSB MIA04CA001Accident · Minor injuriesData collectionFinal reportAmerican General AA-1 · Bartow, FLA loss of engine power due to oil starvation. Also causal was the pilot's improper maintenance.NTSB CHI03FA320Accident · 1 fatalField investigationFinal reportCessna 152 · Three Oaks, MIThe pilot not maintaining adequate airspeed resulting in a stall during takeoff. Contributing factors were the buzzing flight and trees.NTSB DEN03LA154Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Byers, COThe pilot not maintaining adequate clearance from the ground and his improper in-flight planning/decision. Factors contributing to the accident were the tailwind, the low altitude, the tree, the people, the embankment, and the ravine.NTSB MIA03LA179Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kissimmee, FLA loss of engine power due to inadequate maintenance.NTSB NYC03CA192Accident · No injuriesData collectionFinal reportCessna 152 · Franklin, VAThe student pilot's improper flare, which resulted in a hard landing.NTSB CHI03LA294Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIThe student pilot's inadequate recovery from the bounced landing. Factors contributing to the accident were the variable crosswind, the misjudged flare that resulted in the bounced landing and the subsequent collapse of the nose landing gear.NTSB MIA03CA174Accident · No injuriesData collectionFinal reportCessna 152 · Ocala, FLthe student pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway, and impacting with a ditch.NTSB LAX03CA269Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · Joshua Tree, CAthe student pilot failed to maintain directional control of the airplane during the takeoff roll.NTSB NYC03LA184Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Pawtucket, RIA loss of engine power for undetermined reasons.NTSB MIA03LA170Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Panama City, FLThe pilot's failure to follow the airplane manufacturer's recommendation to not use automobile fuel in the airplane resulting in deterioration of the fuel tank sealant, fuel starvation of the engine from fuel system contamination, and subsequent collision…NTSB FTW03LA192Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Granbury, TXThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB LAX03LA251Accident · Serious injuriesLimited investigationFinal reportBeech 77 · French Valley, CAThe pilot's attempted low altitude flight maneuver during a go-around, which resulted in his loss of control of the airplane and subsequent in-flight collision with terrain.NTSB ATL03LA121Accident · Minor injuriesLimited investigationFinal reportLancair 235 · Fort Payne, ALThe pilot's failure to properly reconnect the mixture control cable resulting in a total loss of engine power, and subsequent in-flight collision with the trees.NTSB CHI03LA233Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Brooklyn, MIThe pilot's failure to attain the proper touchdown point, and his failure to maintain control of the airplane.NTSB LAX03LA242Accident · Minor injuriesLimited investigationFinal reportSmith Miniplane · Winnemucca, NVThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power during cruise flight, and subsequent in-flight collision with terrain. A factor associated with the accident is the night light conditions.NTSB NYC03LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Gaithersburg, MDThe student pilot's failure to maintain directional control during an aborted landing.NTSB LAX03LA214Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mt. Charleston, NVthe pilot's inadequate in-flight planning and selection of the wrong route of flight, which led the airplane toward rising terrain in excess of the performance capability of the airplane. Also causal was the pilot's delayed decision to divert her route of…NTSB ANC03LA056Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Teller, AKThe pilot's inadequate compensation for a crosswind and his failure to maintain directional control during the landing roll, resulting in a loss of control and nose down of the airplane. A factor in the accident was a crosswind.NTSB CHI03LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Owensville, MOThe pilots delayed attempt to perform an aborted takeoff and subsequent overrun. Contributing factors to the accident were the fence and the ditch.NTSB LAX03LA148Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pala, CAthe dual student's delay in executing the proper recovery procedures and improper retraction of the flaps, the CFI's inadequate supervision during the recovery to normal flight, the CFI's delayed remedial action, and the failure of both pilots to maintain an…NTSB NYC03WA100Accident · No injuriesForeign investigationPiper PA-16 · Saint Girons, FranceNTSB CHI03LA109Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Red Owl, SDThe pilot not maintaining aircraft control during initial climb-out, resulting in the encountered stall.