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 CHI92LA131Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Branson, MOInadequate inflight planning/decision by the pilot in command in failing to maintain distance separation from the other aircraft.NTSB CHI92LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · Hanover, INInadequate remedial action by the pilot in command when the engine lost partial power during cruise flight. Factors in the accident were the presence of carburetor icing conditions, and soft terrain in the area selected for a forced landing.NTSB MIA92FA110Accident · 1 fatalField investigationFinal reportCessna 152 · Bushnell, FLThe pilot-in-command's failure to maintain airspeed (vso) while maneuvering during a forced landing. This resulted in an inadvertent stall, in flight loss of control, and collision with terrain. Contributing to the accident was the pilot-in-command's failure…NTSB FTW92FA107Accident · Minor injuriesField investigationFinal reportCessna 150 II · Fort Worth, TXA fuel exhaustion induced engine power loss due to the pilot's failure to refuel. A factor was the pilot's inadvertent disorientation.NTSB NYC92LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Moneta, VAThe student pilot's failure to properly compensate for the crosswind condition and to maintain directional control of the airplane after landing. Contributing to the accident was the crosswind.NTSB NYC92LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Coatsville, PAThe failure of the student pilot to compensate for adverse winds during landing, which resulted in a loss of airspeed and subsequent stall and loss of control. A factor related to the accident was the student pilot's lack of total flight experience.NTSB SEA92LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Friday Harbor, WAThe pilot's improper recovery from a bounced landing. A factor was the poorly planned approach.NTSB ATL92LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Knightdale, NCThe student pilot's failure to maintain directional control of the airplane during the landing roll. Factor(s) in this accident were: the crosswind conditions prevailing at the airport, and the soft, muddy terrain conditions adjacent to the runway.NTSB ATL92LA044Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe improper in-flight decision by the instructor pilot to attempt a precautionary off airport landing when no emergency existed. Factors related to the accident were the fog and low ceilings in the area at the time.NTSB MIA92LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Perry, FLFailure of the pilot to maintain clearance while taxiing.NTSB CHI92LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Howell, MIThe pilot's improper use of carburetor heat. An associated factor is weather conducive to carburetor icing.NTSB ATL92LA043Accident · No injuriesLimited investigationFinal reportCessna 152 · Shelbyville, TNThe improper level off by the student pilot because of misjudging the airplane's altitude above the runway. A factor was her diverted attention by an aircraft behind her in the traffic pattern.NTSB CHI92LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockford, ILThe pilot's delayed application of carburetor heat.NTSB BFO92LA018Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Richmond, RIThe pilots failure to maintain directional control during rollout.NTSB ANC92LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Anchorage, AKThe failure of the pilot to maintain directional control of the airplane during the aborted takeoff. Contributing to the accident were the partial loss of engine power for undetermined reasons, the icy runway condition, and the pilot's lack of total…NTSB DEN92LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Falcon, COEngine failure over unsuitable terrain due to fuel exhaustion. Factors were: pilot inexperience and becoming lost and disoriented.NTSB BFO92LA015Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wadsworth, OHFailure of the pilot to attain an adequate airspeed during an attempted go around, which resulted in a stall. His premature raising of the flaps and lack of experience in the make and model of aircraft were related factors.NTSB CHI92LA063Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Alpha, ILInadequate preflight planning and refueling not performed by the pilot.NTSB CHI92LA042Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fargo, NDThe pilot's improper interpretation of instructions issued by air traffic control specialist, and the pilot's poor inflight planning and decision(s). Factors associated with the accident are the confusing communications by the air traffic control specialist,…NTSB NYC92LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Orford, NHThe student pilot became lost and disoriented.NTSB FTW92LA039Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Las Cruces, NMThe pilot's misjudgment of the airplane's performance which led to a situation where it could not climb above the rising terrain. A factor was the high density altitude which existed in the mountains at the time of the accident.NTSB ANC92LA026Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Talkeetna, AKThe pilot's improper flare following an aborted takeoff, which resulted in a hard landing and the subsequent loss of control of the airplane. Contributing to the accident was the pilot's lack of total experience in the type of operation.NTSB NYC92LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student pilot's improper preflight and planning which resulted in fuel system exhaustion and a forced landing on unsuitable terrain. A factor related to the accident was the pilot's lack of total experience.NTSB DEN92LA010Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Watkins, COFailure to maintain directional control of the airplane during landing flare. A factor was the crosswind condition that existed at the time of the accident.NTSB MIA92LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe pilot-in-command's improper use of the rudder controls and brakes. A contributing factor was his lack of total experience.NTSB MIA92LA033Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1C · Lantana, FLThe improper maintenance assembly and inspection of the throttle linkage which resulted in the throttle linkage becoming disconnected in flight and subsequent loss of engine power.NTSB LAX92LA046Accident · 2 fatalLimited investigationFinal reportBellanca 7ECA · Fremont, CAThe pilot-in-command's failure to maintain an airspeed above the stall speed. His over confidence in his personal ability, lack of familiarity with the aircraft, and his inadequate training in acrobatic flight were factors in the accident.NTSB LAX92LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Maricopa, AZThe cfi's inadequate supervision and his delayed remedial action. A factor was carburetor icing conditions.NTSB CHI92LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Faribault, MNThe pilot's improper starting procedures and the passenger's inattentiveness. A related factor is the pilot's lack of supervision.NTSB LAX92LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Reedley, CAThe student pilot's improper use of the flight controls and his failure to maintain directional control of the aircraft. A contributing factor in the accident was the students lack of total experience.NTSB MIA92FA012Accident · 1 fatalField investigationFinal reportCessna 177 · Green Cove Spgs, FLThe pilot in command's failure to maintain a visual lookout.NTSB FTW92LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Lubbock, TXFuel exhaustion as a result of the pilot's failure to refuel the airplane prior to the flight. A factor was the fbo's failure to properly maintain the fuel quantity gauges.NTSB LAX92LA007Accident · No injuriesLimited investigationFinal reportCessna 421C · Santa Monica, CAThe failure of the pilot of the other aircraft to maintain an adequate visual lookout while taxiing his aircraft.NTSB SEA91LA259Accident · No injuriesLimited investigationFinal reportGrumman AA-1 · Granite Falls, WAThe pilot's decision to not perform a go-around and a misjudged distance.NTSB ATL91LA181Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lagrange, GAThe J-5 pilot's failure to maintain adequate visual lookout.NTSB CHI91LA303Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Newark, ILA sheared oleo piston retaining pin which allowed the wheel to fall out.NTSB NYC91FA235Accident · 1 fatalField investigationFinal reportPiper PA38-112 · Akron, OHThe pilot lost control of the airplane and inadvertently stalled and spun the airplane at too low an altitude to allow recovery. Factors related to the accident were; the pilot's improper preflight and planning, which resulted in fuel exhaustion, a loss of…NTSB FTW91DRD08Accident · No injuriesFinal reportCessna 152 · Ruston, LAThe cfi's exceeding the airplane's takeoff performance capability.NTSB BFO91LA080Accident · No injuriesLimited investigationFinal reportCessna 152 · Croom, MDThe pilot's failure to assure an adequate fuel supply was on board to complete the flight which resulted in fuel exhaustion.NTSB CHI91LA290Accident · No injuriesLimited investigationFinal reportCessna 152 · Minneapolis, KSThe pilot's failure to assure an adequate fuel supply was on board the airplane which resulted in fuel exhaustion. A factor related to the accident was inaccurate preflight planning.NTSB CHI91LA289Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kansas City, MOThe pilot's misjudgement of the landing flare and not maintaining directional control during a landing touchdown and roll. A factor was the pilot's lack of total expereince.NTSB CHI91LA280Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Algonquin, ILIncapacitation of the pilot due to a heart attack.NTSB LAX91LA379Accident · No injuriesLimited investigationFinal reportCessna C-152 · Palo Alto, CAImproper recovery from a bounced landing by the student pilot and the delayed remedial action of the instructor pilot. Contributing to this accident was the student pilot's failure to maintain the proper descent rate which resulted in a bounced landing and…NTSB MIA91LA204Accident · Serious injuriesLimited investigationFinal reportBellanca 7EA · Venice, FLThe pilot's loss of control of the airplane on takeoff ground roll due to his lack of experience and flight time in this type of airplane. A contributing factor is an on-ground encounter with a crosswind.NTSB MIA91LA200Accident · No injuriesLimited investigationFinal reportCessna 152 · Marianna, FLThe student pilot's failure to maintain proper airspeed during landing and failure to execute a go-around in a timely manner.NTSB DEN91LA115Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Parker, COPhysical impairment of the pilot in command for unknown reasons.NTSB NYC91LA208Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Butler, PAThe pilot failed to maintain control of the airplane, resulting in the airplane departing the runway and impacted with the terrain.NTSB NYC91LA207Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bear Mountain, NYThe pilot's improper preflight and planning, which resulted in fuel exhaustion and a forced landing in water.NTSB CHI91LA247Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrensburg, MODirectional control was not maintained by the pilot. A factor related to the accident was lack of total experience in type of operation by the pilot.NTSB NYC91LA202Accident · No injuriesLimited investigationFinal reportCessna 152 · Brookville, OHThe pilot's improper use of the flight controls resulting in loss of directional control and an inadvertent stall.