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 FTW98LA180Accident · No injuriesLimited investigationFinal reportCessna A152 · Brigham City, UTfailure of the pilot to maintain directional control of the airplane during a touch and go landing. Related factors were: the pilot allowed his attention to be diverted into the cockpit for an excessive amount of time, and the encounter with a ditch.NTSB IAD98LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Windsor Locks, CTThe student pilot's inattention during taxi, which resulted in the collision with a fuel truck.NTSB ANC98LA033Accident · No injuriesLimited investigationFinal reportPiper J5-C · Valdez, AKThe owner/pilot mechanic's improper overhaul of the engine, and lack of proper lubricating cylinder grease. A factor in the accident was the lack of a suitable area for a forced landing.NTSB MIA98LA107Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Dauphin Island, ALFailure of the pilot-in-command (CFI) to maintain directional control of the airplane following an intentional low altitude maneuver by the student. Also, altitude inadequate for recovery from the in-flight loss of control.NTSB LAX98FA118Accident · 3 fatalField investigationFinal reportCessna 310H · Corona, CAThe failure of both pilots to maintain an adequate visual lookout and to see and avoid the other airplane.NTSB IAD98LA038Accident · 1 fatalLimited investigationFinal reportChampion 7ECA · Castlewood, VAThe pilot's failure to achieve the proper touchdown point and the delayed execution of the go around. A contributing factor was the fence.NTSB ATL98LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · La Belle, FLthe student pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. The gusty crosswind condition was a related factor.NTSB SEA98LA043Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Dubois, IDThe student pilot's misjudgment of altitude/clearance and overloading of the nose gear. A contributing factor was the snow-covered turf runway.NTSB IAD98LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrenton, VAThe student pilot's improper flare which resulted in a hard landing.NTSB FTW98LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKFuel exhaustion due to the student pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB ATL98LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Americus, GAthe pilot's improper planning/decision, which led to fuel exhaustion, loss of engine power, and a forced landing on unprepared terrain.NTSB SEA98LA037Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Bridger, MTThe student pilot's failure to maintain airspeed during a bounced landing recovery.NTSB MIA98LA077Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Georgetown, SCthe pilot's decision to attempt a takeoff from an unsuitable area of roadway, following a forced landing after the engine had lost power, due to fuel exhaustion; and his failure to maintain clearance from obstructions, while attempting the takeoff. The…NTSB MIA98LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe CFI's improper planning and decision to taxi behind a multi-engine airplane conducting an engine run-up.NTSB FTW98LA125Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Sheridan, WYthe pilot's improper use of carburetor heat, which resulted in loss of engine power due to carburetor ice. Factors relating to the accident were: the carburetor icing (weather) condition, and the lack of a suitable area for an emergency landing.NTSB FTW98LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Frederick, OKThe loss of wheel brakes due to the failure of the brake actuating cable. A factor was the tailwind.NTSB FTW98LA091Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boyd, TXloss of engine power resulting from the pilot's delayed use of carburetor heat during serious carburetor icing conditions. Factors were: the lack of suitable terrain for the forced landing and an evasive maneuver which led to an inadvertent stall.NTSB FTW98FA086Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Tremonton, UTThe pilot's continued VFR flight into instrument meteorological conditions, becoming spatially disoriented and his subsequent loss of aircraft control. Factors were the dark night and weather conditions that included obscuration and snow.NTSB MIA98LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Everglades City, FLthe pilot's inadequate compensation for wind conditions and failure to properly flare the airplane, which resulted in a hard landing and overload failure of the nose gear. The unfavorable wind conditions were related factors.NTSB LAX98FA045Accident · 1 fatalField investigationFinal reportCessna 152 · El Cajon, CAThe solo student's failure to see and follow the other aircraft on the downwind as he had been instructed. Factors influencing this accident was the failure of the pilots in the other aircraft to see and avoid the aircraft encroaching on his flight path; the…NTSB CHI98LA056Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Nevada, MOa deer that ran onto the runway as the airplane was landing. The reduced light condition at dusk was a related factor.NTSB ATL98LA010Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Punta Gorda, FLThe flight instructor's improper short field takeoff procedure and his decision to abort the takeoff after rotation.NTSB MIA98LA034Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Palatka, FLthe student pilot's failure to properly secure the oilcap/dipstick within it's integral oil filler tube during his preflight inspection.NTSB CHI98IA035Incident · No injuriesIncident investigationFinal reportCessna 152 · Blaine, MNthe fracture of the flap cable as a result of fatigue cracking.NTSB CHI98LA030Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Madison, WIthe flight instructor's (CFI's) inadequate supervision of the flight, and his failure to ensure that control of the airplane was maintained. Factors associated with the accident were: the CFI's improper use of flaps, and subsequent contact with the runway…NTSB SEA98LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Eugene, ORthe pilot's failure to refuel which subsequently led to fuel exhaustion.NTSB CHI98LA027Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Augusta, KSfailure of the aircraft owner to reinstall the quick release hinge pins/safety pins, and failure of the pilot to notice the missing pins during the aircraft preflight, which resulted in separation of the main entry door during flight.NTSB LAX98LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Prescott, AZThe student's inadvertent application of left brake during touchdown, and the instructor's inadequate supervision of the flight.NTSB IAD98LA008Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln Park, NJthe pilot's improper flare during touchdown, which resulted in a hard landing and subsequent encounter with terrain.NTSB ANC98LA007Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's selection of an unsuitable landing area.NTSB FTW98LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKThe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise and subsequent collapse of the nose gear.NTSB NYC98LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Piqua, OHThe student pilot's inadequate compensation for the wind condition. A factor in this accident was the crosswind condition.NTSB LAX98FA009Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Tracy, CAThe pilot's low operating altitude and his failure to maintain appropriate clearance during low level maneuvering flight. Contributing factors were transmission wires and the physical impairment that resulted from the effects of the over-the-counter…NTSB LAX98FA006Accident · 1 fatalField investigationFinal reportCessna 152 · Julian, CAThe pilot's inadequate in-flight planning which resulted in VFR flight into instrument meteorological conditions and the loss of aircraft control. Contributing was the pilot's overconfidence in his ability, clouds, and rain.NTSB NYC98LA003Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAThe student pilot's failure to maintain directional control of the airplane.NTSB FTW98LA017Accident · No injuriesLimited investigationFinal reportCessna A152 · Rockwall, TXThe pilot's improper recovery from a bounced landing and her failure to maintain directional control during the aborted landing. Factors were the wind gust and the turbulence.NTSB ATL97LA141Accident · No injuriesLimited investigationFinal reportTomlinson Pober Super ACE · Lebanon, TNThe pilot's failure to follow normal checklist procedures that resulted in fuel starvation.NTSB ATL97LA138Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Fairview, NCfuel contamination, and the pilot's inadequate preflight of the airplane. A factor relating to the accident was: an inability to attain a proper touchdown point, which led to the runway overrun.NTSB ANC97LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Northway, AKThe pilot's failure to maintain directional control during the landing. A factor in the accident was the pilot's lack of familiarity with the airplane.NTSB ANC97LA137Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Healy, AKThe pilot's inadequate preflight which failed to detect water contamination in the fuel tanks. Factors were the worn gaskets on the fuel tank caps, and the pilot's decision to abort the partial power precautionary landing.NTSB FTW97LA333Accident · No injuriesLimited investigationFinal reportCessna 152 · Zavalla, TXthe pilot's improper planning/decision, becoming lost/disoriented during the flight, and selection of unsuitable terrain for an emergency/precautionary landing. Factors relating to the accident were: the hazy weather condition, and rough terrain in the…NTSB LAX97LA309Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Imperial, CAThe pilot's failure to maintain directional control during landing and to arrest porpoising after an improper recovery from a bounced landing. Factors in the accident were the misjudging of distance and speed during a downwind landing.NTSB ATL97LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · West Palm Beach, FLthe flight instructor's (CFI's) inaccurate assessment of fuel available for the flight, and his improper in-flight planning/decision by continuing the training flight with minimal fuel, which resulted in fuel exhaustion and loss of engine power.NTSB NYC97LA169Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Spencerport, NYfailure of the pilot to maintain directional control of the airplane, while landing. The crosswind was a related factor.NTSB MIA97LA235Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Villa Rica, GAInadequate runway maintenance by the pilot for allowing trees to be in close proximity of the runway and failure to maintain clearance from the trees.NTSB CHI97LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Glenwood, MNfailure of the student pilot to maintain the correct airspeed for a go-around maneuver, which resulted in a stall/mush and collision with terrain.NTSB ANC97LA123Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Kaktovik, AKThe pilot's selection of an unsuitable takeoff area. A factor related to the accident was the rocky terrain.NTSB ATL97LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Dunlap, TNa loss of engine power for undetermined reasons.NTSB NYC97LA157Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Easton, MDan inadequate weld repair, which resulted in insufficient structural strength of the left main gear.NTSB FTW97LA281Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXfailure of the pilot in the Cessna 172 to maintain clearance from the Cessna 152 aircraft.