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 NYC91LA200Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Alton, NHThe pilot's improper use of carburetor heat, which resulted in a loss of engine power.NTSB ANC91LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Palmer, AKThe pilot's failure to maintain airspeed and inadvertent stall during low level maneuvering flight. Contributing to the accident was the high terrain.NTSB DEN91LA104Accident · No injuriesLimited investigationFinal reportCessna 152 · Fountain, COThe pilot's selection of unsuitable terrain on which to make a landing. Factors were: the pilot's inadequate preflight planning, and weather conditions that included low ceiling, obscuration, fog, and drizzle.NTSB MIA91LA189Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hilliard, FLLoss of engine power due to undetermined reasons, failure of the pilot to maintain vso, and inadvertent stall mush. Contributing to the accident was lack of total experience in the type of operation.NTSB ATL91LA131Accident · No injuriesLimited investigationFinal reportCessna 152 · Benton, TNA loss of engine power for undetermined reasons.NTSB LAX91LA298Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Indian Springs, NVFuel exhaustion due to improper preflight planning, and failure to refuel the aircraft. Factors in the accident were: 1) the pilot becoming lost/disoriented ; 2) the dark night conditions; 3) the failure of the pilot to seek help in a timely fashion; and 4)…NTSB ANC91LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Woodchopper Crk, AKEngine failure due to fuel exhaustion, the pilot's inadequate preflight planning and the unsuitable terrain. Contributing to the accident was the pilot's lack of total experience.NTSB ANC91LA091Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Merrill Pass, AKThat the pilot failed to maintain an airspeed above stall speed. Contributing to the accident was the turbulence.NTSB MIA91FA171Accident · 2 fatalField investigationFinal reportBeech 77 · Magnolia, MSThe instructor pilot's (cfi's) improper supervision of flight and a failure to maintain sufficient altitude above the trees.NTSB LAX91LA275Accident · No injuriesLimited investigationFinal reportCessna C-152 · Las Vegas, NVFuel exhaustion due to the failure of the pilot to ensure that an adequate fuel supply was on board the aircraft prior to departure.NTSB MIA91LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Brooksville, FLFailure of the student pilot to maintain directional control of the airplane during the landing roll. Contributing to the accident was his lack of total experience.NTSB ATL91LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNStudent pilot's failure to maintain directional control during the landing roll.NTSB LAX91LA262Accident · No injuriesLimited investigationFinal reportCessna 152 · Oceanside, CAFuel exhaustion due to the pilot's improper preflight planning.NTSB LAX91LA263Accident · No injuriesLimited investigationFinal reportCessna 152 · Fountain Hills, AZThe failure of the student pilot and instructor pilot to correctly configure the aircraft for the attempted go around. Contributing to the accident was the improper supervision of the flight by the flight instructor.NTSB ANC91LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot-in-command's improper preflight and the contaminated fuel system. A factor was the rough, uneven terrain.NTSB MIA91LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Pensacola, FLThe pilot-in-command's improper flare and recovery from a bounced landing resulting in a hard landing and collapse of the nose landing gear.NTSB LAX91LA240Accident · No injuriesLimited investigationFinal reportPiper PA38-112 · Stockton, CAThat the pilot-in-command used poor preflight planning, inflight decision, and fuel consumption calculations. Contributing to this accident was fuel exhaustion.NTSB MIA91LA156Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Quincy, FLThe pilot's inadequate preflight inspection and the blocked vent line.NTSB ATL91LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Knightdale, NCThe student pilot's delay in aborting the takeoff. The pilot's continued operation of the airplane with a known discrepancy and the operator's previous improper maintenance/inspection of the pitot/static system were factors related to the accident.NTSB CHI91LA172Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, ILThe pilot in command's misjudgment of the proper touchdown point. An associated factor is the pilot-in-command not performing remedial action.NTSB NYC91LA135Accident · No injuriesLimited investigationFinal reportCessna 152 II · Newtonville, NJPilot factor in that the student pilot delayed asking for assistance, after becoming lost until insufficient fuel was available to make an airport. This resulted in engine failure to fuel exhaustion and a subsequent emergency landing in rough terrain.NTSB MIA91LA143Accident · No injuriesLimited investigationFinal reportCessna 152 · Yazoo City, MSPoor planning decision by the student pilot, improper fuel calculations, resulting in fuel exhaustion due to an inadequate fuel supply. Contributing to the accident was overconfidence in his own personal ability by the student pilot.NTSB CHI91LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIRecovery from a bounced landing was improper by the pilot. Factors related to the accident were lack of recent experience by the pilot.NTSB CHI91LA276Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Monticello, MNThe pilot in command's (CFI) delayed remedial action. Related factors are the gusty crosswind, the student pilot's lack of total experience, inadequate compensation for crosswind conditions, and the cfi's failure to maintain directional control.NTSB LAX91LA202Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Ojai, CAThe pilot's inadequate compensation for the wind condition. A factor related to the accident was the downdraft weather condition.NTSB SEA91LA097Accident · 1 fatalLimited investigationFinal reportGrumman AA-1B · Douglas, WYAn inadvertent stall with inadequate terrain clearance. Factors include flight in mountainous terrain at an altitude where remedial action was not possible.NTSB LAX91LA189Accident · No injuriesLimited investigationFinal reportPiper PA 38-112 · Fresno, CAThe pilot-in-command's failure to maintain directional control and inadequate compensation for wind conditions during the landing touchdown. Contributing to the accident was the pilot-in-command's overconfidence in his ability while analyzing the forecast…NTSB ATL91LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Hampton, GAThe pilot's improper flare and his failure to execute an abort in a timely manner when a safe landing was not possible. Factors in the accident were the wet grass conditions at the airstrip, and the pilot's lack of recent total flying experience.NTSB CHI91LA138Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Millard, NEImproper use of APU by unknown personnel which resulted in the airplane's electrical wiring melting and subsequent short.NTSB CHI91DCJ02Accident · No injuriesFinal reportFagerberg Longeze · Wahoo, NEThe improper installation/maintenance of the carburetor heat control. A factor was the pilot's restricted visual outlook.NTSB FTW91LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Durant, OKThe pilot's failure to maintain proper alignment during the flare.NTSB CHI91LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Oskosh, WIRefueling not performed resulting in loss of engine power due to fuel exhaustion. Factors related to the accident were misjudged fuel consumption calculations and non suitable terrain.NTSB BFO91LA037Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Clinton, MDThe lost of engine power for undetermined reasons.NTSB SEA91LA070Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Everett, WAThe pilot did not maintain control of the airplane during the landing roll. Factors tot he accient were the pilot inadequately planned the approach, and uncontrolled ground-loop, and the pilot's lack of total experience in this type of aircraft.NTSB BFO91LA038Accident · Minor injuriesLimited investigationFinal reportCessna 152 · California, MDThe loss of engine power for undetermined reasons resulting in a forced landing and on ground collision with terrain.NTSB MIA91LA104Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · La Belle, FLFailure of the student pilot to maintain directional control during the landing roll. Contributing to the accident was the fact that the pilot diverted his attention when he pulled the parking brake handle to apply the brakes.NTSB NYC91LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Caldwell, NJImproper flare by the pilot. Darkness was a related factor.NTSB SEA91LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Gig Harbor, WAThe pilot's failure to maintain directional control on the ground. Factors include wind gusts.NTSB LAX91LA126Accident · No injuriesLimited investigationFinal reportCessna 152 · Tucson, AZEngine failure due to oil starvation caused by a rotation of the main bearing. A factor in the accident was the failure of the operator maintenance personnel to accomplish an engine overhaul within the interval specified by the manufacturer.NTSB MIA91LA090Accident · No injuriesLimited investigationFinal reportCessna 152 · Jensen Beach, FLImproper in-flight planning decision by the pilot resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident were the unreliable fuel quantity indicators.NTSB FTW91LA044Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Friendswood, TXThe duel student's failure to maintain directional control during the landing and his inadvertent activation of the brakes. A factor was the ditch.NTSB SEA91LA056Accident · No injuriesLimited investigationFinal reportCessna 152 · Port Townsend, WAThe pilot's failure to maintain aircraft directional control during landing roll. Factors relating to the accident were the crosswind weather conditions and the soft terrain beside the runway.NTSB CHI91LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Wonder Lake, ILFailure of the student pilot to maintain directional control during takeoff. Her lack of flying expereince was a related factor.NTSB MIA91LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Cloud, FLFailure of the pilot to plan the flight and failure to obtain proper assistance from ATC after becoming lost, which resulted in total loss of engine power due to fuel exhaustion.NTSB DEN91LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Timberon, NMThe pilot's inadequate preflight planning and selection of the wrong runway. Related factors were: the rising terrain, trees, and the pilot's lack of experience.NTSB CHI91LA096Accident · No injuriesLimited investigationFinal reportCessna 152 · Osseo, WIFuel exhaustion which occurred when the pilot became lost/disoriented. Factors related to the accident were: the pilot's lack of total experience, the terrain condition, and a fence.NTSB MIA91WA074Accident · Minor injuriesForeign investigationCessna 152 · Mores Island, BahamasNTSB FTW91LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's failure to maintain directional control during landing. Contributing to the accident was the crosswind condition that existed at the time of the accident.NTSB LAX91LA080Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZThe student pilot's improper bounced landing recovery technique. A factor in the accident was the pilot's limited flight experience.NTSB MIA91LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLInadequate maintenance record keeping by the operation, and failure of the CFI to follow procedures and directives.