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 LAX00LA270Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Luis Obispo, CAThe pilot's inadequate visual lookout while taxiing to the runway, which resulted in his failure to see and avoid the fuel truck.NTSB LAX00LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · San Jose, CAThe pilot's in-flight decision to continue the takeoff and his subsequent delayed decision to abort the takeoff after he noted that the airplane was unable to climb out of ground effect.NTSB CHI00LA202Accident · No injuriesLimited investigationFinal reportCessna 152 · Park River, NDdirectional control not being maintained by the pilot during landing.NTSB LAX00LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Selma, CAA cracked plastic fuel selector handle that precluded proper engagement of the internal mechanism to fully select a port, and left it in an intermediate position, restricting the fuel supply to the engine, which subsequently lead to a loss of engine power.NTSB LAX00LA252Accident · No injuriesLimited investigationFinal reportCessna 152 · Oakland, CAfailure of the instructor to adequately supervise the student, resulting in a loss of directional control.NTSB MIA00FA201Accident · 1 fatalField investigationFinal reportCessna 152 · Murfreesboro, TNthe flight instructor's failure to maintain an airspeed above the aircraft's stall speed, which resulted in a stall/mush, and an inflight loss of control while maneuvering to return to a landing area during an emergency, resulting in an uncontrolled descent…NTSB NYC00LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Beverly, MAThe pilot's improper flare, which resulted in a loss of control.NTSB CHI00LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, NEthe misjudged flare and the inadequate recovery from the bounced landing performed by the student pilot.NTSB NYC00LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · West Point, VAThe student pilot's failure to maintain directional control during the landing roll.NTSB NYC00LA170Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · Nashua, NHThe flight instructor's delayed corrective action.NTSB FTW00LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcallen, TXLoss of engine power for reasons undetermined. A factor was the lack of suitable terrain for the forced landing.NTSB CHI00FA165Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Westfield, INThe pilot's improper in-flight decison to maneuver back to the departure airport following the loss of engine power on initial climb, the pilot's loss of aircraft control and the pilot's inadequate preflight inspection of the airplane. Contributing factors to…NTSB LAX00LA225Accident · No injuriesLimited investigationFinal reportCessna 152 · Lodi, CAThe pilot's inaccurate fuel consumption calculations, his misjudged in-flight planning, and his failure to flare during the landing attempt. A factor was the pilot's improper preflight inspection when he refueled the airplane.NTSB IAD00LA048Accident · No injuriesLimited investigationFinal reportGrumman American AA-1A · Northampton, MAThe student pilot's failure to maintain directional control during takeoff.NTSB MIA00LA182Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Steens, MSthe flight instructor failed to maintain control of the airplane after landing, which resulted in an on ground collision with a tree. Factors in this accident were the flight instructor allowed the student to get too fast and high on the approach.NTSB MIA00LA183Accident · No injuriesLimited investigationFinal reportHayes LONG-EZ · Collegedale, TNThe pilot's failure to maintain the proper glide path on final approach to insure arrival at the proper runway touchdown point. A factor in the accident is the pilot's unfamiliarity with the cockpit spoiler control's location and operation.NTSB CHI00LA142Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Sandstone, MNthe pilot not attaining an airspeed necessary for the go-around and not maintaining clearance from terrain. Factors were the crosswind, gust, and the collapsed nose gear.NTSB CHI00LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · Goshen, INthe failure of the student pilot to maintain directional control on the takeoff roll. Factors to the accident were the lack of experience of the student pilot and the improper use of the throttle.NTSB NYC00LA137Accident · No injuriesLimited investigationFinal reportAnderson MA-18 · Pittsburgh, PAThe pilot's improper fuel management which resulted in the loss of power, and his improper flare during the forced landing, which resulted in a hard landing. Factors included a restricted fuel supply due to a design flaw in the header tank/fuel valve/supply…NTSB LAX00LA194Accident · No injuriesLimited investigationFinal reportCessna 152 · Borrego Springs, CAThe pilot's inadequate compensation for a crosswind condition during initial takeoff climb, which resulted a failure to maintain alignment and the airplane drifting into a nearby tree.NTSB MIA00LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLthe dual student's improper visual lookout and the flight instructor's inadequate supervision that resulted in the airplane colliding with a fence post.NTSB SEA00LA079Accident · No injuriesLimited investigationFinal reportMorton Christavia Mark I · Salem, ORThe pilot/builder's failure to correct the center of gravity computations after a weight increase. A contributing factor was the pilot/builder's exceeding the forward CG limit in fuel weight, of which both conditions resulted in a degradation of aircraft…NTSB LAX00LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Fresno, CAFuel exhaustion during cruise flight due to the student pilot becoming disoriented and lost.NTSB LAX00LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Eureka, CAThe pilot's failure to compensate for a crosswind and to maintain directional control during landing.NTSB ANC00LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Delta Junction, AKThe pilot's failure to maintain altitude/clearance. Factors associated with the accident were flat light conditions, and snow-covered terrain.NTSB FTW00LA125Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Arlington, TXThe failure of the pilot to maintain directional control during the landing roll. A factor was the pilot's total lack of experience in tailwheel airplanes.NTSB MIA00LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, TNA loss of engine power during takeoff climb for undetermined reasons resulting in an attempted emergency landing to unsuitable terrain and collision with a tree and transmission wires.NTSB FTW00LA109Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Decatur, TXThe instructor pilot's failure to maintain the minimum controllable airspeed during a simulated emergency approach, which resulted in a stall.NTSB MIA00LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe partial loss of engine power due to undetermined reasons.NTSB CHI00LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Butler, MOthe certified flight instructor's improper use of the mixture control while demonstrating a simulated loss of engine power which resulted in fuel starvation. A factor associated with the accident was the rough terrain on which the forced landing was made.NTSB ANC00LA036Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Anchorage, AKThe pilot's inadvertent stall during an attempted go-around. A factor associated with the accident was the pilot's failure to maintain proper runway alignment.NTSB MIA00LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLthe flight instructor's inadequate supervision of the student pilot by allowing the student to fly in gusty wind conditions with excessive crosswinds that resulting in the student pilot not maintaining control and nosing the aircraft over.NTSB FTW00LA094Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Charles, LAThe failure of the pilot to refuel the airplane which resulted in fuel exhaustion. Factors were the pilot's poor preflight planning, failure to lean the mixture in accordance with the POH, and lack of suitable terrain for the forced landing.NTSB NYC00LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Hazelton, PAThe pilot's failure to maintain directional control while landing with a crosswind.NTSB FTW00LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's failure to maintain aircraft control during landing. A factor was the crosswind condition.NTSB SEA00LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Billings, MTDirectional control was not maintained. Inadequate remedial action was a factor.NTSB ATL00LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe pilot's failure to maintain visual lookout during flight operations under Visual Flight Rules. A factor is that the pilot was not on the airport radio frequency.NTSB NYC00LA074Accident · No injuriesLimited investigationFinal reportGrumman American AA1 · Wildwood, NJThe student pilot's failure to maintain directional control. A factor in this accident was the crosswind condition.NTSB MIA00LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Louisburg, NCThe improper recovery from the bounced landing by the pilot-in-command for his failure to apply power and inadvertent stall by the pilot-in-command resulting in a hard landing. A contributing factor was the total lack of experience of the pilot-in-command.NTSB LAX00LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Taft, CAThe pilot's misinterpretation of his VOR navigation indicator, which subsequently led to his becoming lost and disoriented while navigating to an alternate airport and resulted in fuel exhaustion. The pilot's failure to obtain either a preflight weather…NTSB MIA00LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Kissimmee, FLThe failure of the pilot to obtain winds aloft for the planned cross country flight with a preflight weather briefing and inadequate fuel consumption calculations performed by the pilot resulting in the total loss of engine power due to fuel exhaustion.NTSB IAD00LA016Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Waynesburg, PAthe pilot's failure to maintain aircraft control during the landing roll-out.NTSB LAX00LA056Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Oxnard, CAThe pilot's inadequate compensation for the variable crosswind condition and subsequent failure to maintain directional control of the airplane.NTSB MIA00LA051Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Woodville, FLThe pilot's improper preflight planning resulting in loss of engine power due to fuel exhaustion and the collision with trees during a forced landing.NTSB MIA00LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Venice, FLThe pilot's improper flare resulting in a hard landing and a collapsed nose landing gear.NTSB MIA00LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLThe inadequate supervision of the student pilot by the pilot-in-command (CFI) for his failure to take the controls from the student and initiate a go-around earlier following the airplane drifting off the runway centerline.NTSB CHI00LA034Accident · No injuriesLimited investigationFinal reportTaylorcraft F-21 · Houlton, WIthe mechanic failed to torque the rod cap bolt during the major engine overhaul. Factors relating to the accident included the rough field and the collapsed landing gear.NTSB LAX00LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Surprise, AZThe pilot's failure to attain and maintain an adequate airspeed during takeoff from a short and unimproved dirt road, which resulted in an inadvertent stall/mush condition and impact with the ground.NTSB FTW00LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlisle, ARThe loss of engine power as a result of excessively fouled spark plugs. A factor was the soft terrain during the forced landing.NTSB CHI00LA024Accident · No injuriesLimited investigationFinal reportAmerican AA-1B · Gallatin, MOOn-ground collision with an animal during landing roll. The night conditions were a contributing factor.