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 DFW05LA083Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Austin, TXThe loss of engine power due to the failure of the number three connecting rod. Contributing factors were the foreign object located within the engine lubrication system, inadequate inspection of the engine by other maintenance personal, and the lack of…NTSB DEN05LA060Accident · 2 fatalLimited investigationFinal reportPiel Emeraude CP-305 · Del Norte, COThe pilot's failure to maintain clearance with the terrain for undetermined reasons.NTSB DFW05CA068Accident · No injuriesData collectionFinal reportBeech BE77 · Angleton, TXThe loss of engine power as result of fuel exhaustion due to the pilot's improper in-flight planning. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX05LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Hana, HIForeign object damage inside an engine cylinder, which resulted in a loss of engine power during climb to cruise, and an off-airport forced landing.NTSB NYC05CA050Accident · No injuriesData collectionFinal reportCessna 152 · Kelleys Island, OHThe pilot's failure to maintain obstacle clearance during landing.NTSB CHI05LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · Sturtevant, WIThe pilot's failure to identify the electrical system failure and to maintain adequate airspeed during the landing approach. Factors associated with the accident were the electrical system failure, the snow covered terrain, and the pilot's lack of experience.NTSB ATL05CA045Accident · Minor injuriesData collectionFinal reportCessna 152 · Nashville, TNA loss of engine power due to fuel starvation as a result of fuel system blockage.NTSB CHI05CA054Accident · No injuriesData collectionFinal reportCessna 152 · Stockton, MOthe pilot's failure to attain the proper touchdown point, which resulted in an overrun. Contributing factors were the tailwind and dusk light conditions.NTSB LAX05LA057Accident · No injuriesLimited investigationFinal reportOrr Long-Ez · Yucca Valley, CAa loss of engine power due to ignition system failure due to rain water grounding/shorting of the magneto switches.NTSB LAX05LA083Accident · Serious injuriesLimited investigationFinal reportAircraft Mfg & Dev. CH-2000 · Jean, NVan in-flight separation of the left cockpit door due to the failure of the hinges from repeated exposure to wind or propeller slip stream forces while in the open position. The hinge failures were the ultimate result of the failure of persons unknown to…NTSB DFW05LA025Accident · Minor injuriesLimited investigationFinal reportWingo Long-Ez · Huntsville, TXLoss of engine power for undetermined reasons. A contributing factor was the unsuitable terrain for landing.NTSB DEN05LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Lyons, COthe pilot's inadequate in-flight planning/decision by his intentional VFR flight into IMC, and his failure to maintain obstacle clearance.NTSB ATL05CA021Accident · No injuriesData collectionFinal reportCessna 152 · Rocky Mount, NCThe pilot's improper landing flare, and improper recovery from a bounced landing.NTSB DEN05CA018Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH 2000 · Salt Lake City, UTthe dual student's high flare resulting in an inadvertent stall/mush and a hard landing. A factor contributing to the accident was the flight instructor's inadequate supervision.NTSB ATL05LA018Accident · 2 fatalLimited investigationFinal reportBellanca Citabria 7ECA · Summerville, SCThe loss of engine power due to undetermined reasons.NTSB DEN05CA016Accident · No injuriesData collectionFinal reportCessna 152 · Santa Teresa, NMthe student pilot' failure to maintain directional control during the takeoff roll. Contributing to the accident was the student pilot's failure to abort the takeoff.NTSB LAX05CA017Accident · No injuriesData collectionFinal reportCessna 152 · Imperial, CAthe student pilot's failure to maintain directional control during the landing rollout, which resulted in the airplane veering off of the runway surface and nosing over.NTSB LAX05LA013Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mesa, AZthe student pilot's failure to maintain directional control of the airplane during a touch-and-go takeoff.NTSB LAX05LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAthe pilot's misjudged distance/altitude and inadequate flare that resulted in a hard landing, and a porpoise down the runway. Also causal was the student pilot's improper bounced landing recovery technique.NTSB NYC05LA002Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Harrison, OHThe Cessna 152 pilot's improper traffic pattern procedure and improper radio communication, which resulted in a mid-air collision with a Cessna 172. A factor in the accident was both pilots' failure to maintain an adequate visual lookout.NTSB DFW05CA001Accident · Minor injuriesData collectionFinal reportBellanca 7ECA · Hearne, TXThe excessive taxi speed by the pilot in command resulting in the pilot's loss of control. A contributing factor was the quartering tailwind.NTSB LAX05CA003Accident · No injuriesData collectionFinal reportCessna 152 · San Jose, CAan in-flight collision with a bird.NTSB CHI04LA285Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Perham, MNThe dual student's improper compensation for the crosswind condition and his subsequent failure to maintain control of the airplane. An additional cause was the flight instructor's inadequate remedial action. A contributing factor was the crosswind condition.NTSB SEA04CA194Accident · No injuriesData collectionFinal reportCessna 152 · Friday Harbor, WAThe pilot's delay in executing an aborted landing and his failure to obtain altitude/clearance from trees during the aborted landing. A factor was the pilot's failure to obtain the proper touchdown point as a result of his high airspeed on approach.NTSB NYC04LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Dayton, OHThe student pilot's inadequate preflight and in-flight planning, which resulted in a total loss of engine power during cruise flight, due to fuel exhaustion.NTSB CHI04CA296Accident · No injuriesData collectionFinal reportPiper PA-16 · Port Huron, MIThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in the overload failure of the right main landing gear.NTSB CHI04CA266Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Hurdland, MOThe pilot's failure to maintain proper airspeed and directional control during the takeoff and his failure to properly abort the takeoff after the encountered tailstrike. A factor to the accident was the stall/mush encountered during the attempted takeoff and…NTSB ATL04LA187Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Inverness, FLThe improper installation of the carburetor which resulted in a loss of engine power and subsequent collision with trees during an emergency landing.NTSB ATL04CA179Accident · Minor injuriesData collectionFinal reportCessna 152 · Inverness, FLThe pilot's inadequate preflight inspection, and his failure to detect the presence of water in the fuel system, which resulted in a loss of engine power and subsequent collision with trees and terrain.NTSB ATL04CA174Accident · No injuriesData collectionFinal reportGrumman American AA1C · Boone, NCThe pilot's selection of the wrong runway, and his misjudgment of the distance and speed during the approach to land, which resulted in the overrun of the runway surface and subsequent collision with trees. A factor was tailwind.NTSB ANC04FA102Accident · 2 fatalField investigationFinal reportPiper PA-12 · Koliganek, AKThe pilot's failure to maintain adequate airspeed while on approach to land, which resulted in an inadvertent stall and an uncontrolled descent.NTSB ATL04CA172Accident · No injuriesData collectionFinal reportCessna 152 · Waycross, GAThe pilot misjudged the approach speed to touchdown, and the hydroplaning of the airplane during the landing roll resulted in the overrun of the runway surface and the subsequent collision with a fence. .NTSB LAX04FA301Accident · 3 fatalField investigationFinal reportBellanca 7ECA · Malibu, CAThe failure of both pilots to maintain an adequate visual lookout and their failure to see and avoid the other aircraft.NTSB CHI04LA238Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1A · Eudora, KSA loss of engine power due to fuel starvation resulting from the pilot's selection of a fuel tank with an insufficient quantity remaining.NTSB MIA04CA116Accident · No injuriesData collectionFinal reportCessna 152 · Sarasota, FLThe student pilot's incorrect recovery following a bounced landing resulting in a hard landing and collapse of the nose landing gear.NTSB DEN04LA110Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Guernsey, WYthe pilot's inadequate use of carburetor heat which resulted in the formation of carburetor ice and loss of engine power. Factors contributing to the accident were weather conditions conducive for carburetor icing, and a lack of suitable terrain for a forced…NTSB ANC04CA083Accident · No injuriesData collectionFinal reportPiper J5A · Kotzebue, AKThe pilot's inadvertent use of the airplane's brakes during the takeoff roll, which resulted in the airplane nosing over. A factor contributing to the accident was the pilot's failure to maintain directional control.NTSB NYC04LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Jaffrey, NHThe loss of engine power for undetermined reasons.NTSB NYC04LA158Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · Batavia, OHThe pilot's inadequate preflight preparation which failed to assure the takeoff performance needed to out climb obstacles. Factors in this accident were the up sloping runway, the high density altitude, and airplane being loaded above it's maximum gross…NTSB FTW04LA174Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1 · Gordonville, TXThe pilot's premature lift-off and his failure to abort the takeoff. Contributing factors were the soft and muddy runway conditions and the unfavorable winds.NTSB NYC04CA155Accident · No injuriesData collectionFinal reportBellanca 7ECA · North Creek, NYThe pilot's failure to maintain directional control during the landing roll. A factor in this accident was the pilot's lack of experience in tail-wheeled airplanes.NTSB NYC04LA154Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Lawrenceburg, KYThe pilot's decision to perform a negative g maneuver, which resulted in a loss of engine power due to fuel starvation.NTSB DEN04LA090Accident · No injuriesLimited investigationFinal reportAircraft Mfg & Dev. Aleros CH 2000 · West Jordan, UTthe pilot's improper flare which resulted in a hard landing. Contributing factors were the low altitude and high airspeed, resulting in an unstabilized approach.NTSB CHI04CA156Accident · No injuriesData collectionFinal reportYoukey Lancair 235 · Hays, KSThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the gusty crosswind, the runway marker sign, and the taxiway lights…NTSB SEA04LA104Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Jerome, IDThe pilot's failure to refuel the airplane resulting in fuel exhaustion and the loss of power during descent for landing. Factors contributing to the accident were the soft terrain and the forced landing site.NTSB NYC04CA138Accident · No injuriesData collectionFinal reportCessna 152 · Elyria, OHThe student pilot's inadequate recovery from a bounced landing.NTSB MIA04CA091Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Carthage, MSThe failure of the student pilot to maintain control of the airplane resulting in the airplane departing the runway and impacting with terrain. A factor related to this accident was the student pilot's lack of total flight experience.NTSB FTW04LA138Accident · No injuriesLimited investigationFinal reportCessna 172 · Decatur, TXThe student pilot's failure to follow the flight instructor's instructions and relinquish the controls, and the flight instructor's delay in initiating a go-around.NTSB FTW04LA125Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Oil City, LAA loss of engine power for undetermined reasons, and the student pilot's failure to maintain airspeed resulting in a stall..NTSB CHI04CA118Accident · No injuriesData collectionFinal reportPiper PA-12 · Hartford, WIThe loss of engine power for undetermined reasons. A factor to the accident was the soft terrain encountered during the forced landing.