NTSB investigations: Lycoming 0-235 series, TX
344 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND 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 CEN13LA209Accident · No injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe failure of the nose landing gear fork during landing due to fatigue.NTSB CEN13LA149Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · College Station, TXThe flight instructor’s and commercial pilot’s failure to see and avoid the other airplane, which resulted in a collision during cruise flight. Contributing to the accident was the failure of the flight instructor to activate the transponder before departure,…NTSB CEN12FA570Accident · 2 fatalField investigationFinal reportAmerican AA-1 · Llano, TXThe flight instructor’s delayed remedial action and inadequate supervision during practice traffic pattern work. Contributing to the accident was the flight instructor’s use of sedating medication on the day of the accident and airplane’s high angle of attack…NTSB CEN12FA520Accident · No injuriesField investigationFinal reportPiper PA-38-112 · Fate, TXA total loss of engine power for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA257Accident · No injuriesLimited investigationFinal reportClifton Breezy · Laneville, TXA loss of engine power due to carburetor ice.NTSB CEN11CA217Accident · Minor injuriesData collectionFinal reportPiper PA-22-108 · Lockhart, TXThe pilot's failure to maintain clearance from trees.NTSB CEN10CA137Accident · No injuriesData collectionFinal reportCessna 152 · Hearne, TXThe student pilot's decision to land with a quartering tailwind and his improper flare and recovery from a bounced landing.NTSB CEN09LA490Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Whitney, TXA partial loss of engine power for undetermined reasons.NTSB CEN09CA048Accident · No injuriesData collectionFinal reportCessna 152 · Spring, TXFailure of the student pilot to apply appropriate actions following a bounced landing.NTSB DFW08CA165Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Taylor, TXThe student pilot's improper flare during landing. Contributing to the accident was the gusty winds.NTSB DFW08CA162Accident · No injuriesData collectionFinal reportCessna CE-152 · Castroville, TXAn improper flare during landing. Contributing to the accident was a porpoise induced oscillation.NTSB DFW08CA093Accident · No injuriesData collectionFinal reportCessna 152 · Arlington, TXThe student pilot's improper landing flare resulting in a hard landing. Contributing to the accident were the gusty surface winds and the student pilot's inadequate preflight planning.NTSB DFW08LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe loss of engine power during cruise flight due to the pilot's failure to refuel the airplane prior to fuel exhaustion.NTSB DFW07CA106Accident · Minor injuriesData collectionFinal reportCessna 152 · Houston, TXThe student pilot's failure to maintain directional control during landing. A contributing factor was the prevailing crosswind.NTSB DFW07CA099Accident · No injuriesData collectionFinal reportCessna 152 · San Antonio, TXThe single-engine pilot's failure to avoid the jet blast while taxiing and the ground controller's inattentiveness to the situation, which resulted in the airplane's being blown over.NTSB DFW07CA063Accident · No injuriesData collectionFinal reportCessna 152 · Houston, TXThe pilot's encounter with porpoise following a hard landing and the improper recovery from a bounced landing.NTSB DFW07CA030Accident · No injuriesData collectionFinal reportCessna 152 · Houston, TXThe pilot's improper flare, which resulted in a hard landing. A factor was the misjudged touchdown point.NTSB DFW07LA009Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wimberley, TXthe pilot's inadequate pre-flight planning which resulted in fuel starvation and the subsequent the loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW06CA202Accident · No injuriesData collectionFinal reportCessna 152 · Gainesville, TXThe pilot's improper recovery from a bounced landing resulting in a porpoise.NTSB DFW06CA133Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · La Porte, TXThe student pilot's inadequate weather evaluation and his failure to maintain airspeed which resulted in a stall. A contributing factor was the prevailing tailwind.NTSB DFW06CA044Accident · No injuriesData collectionFinal reportChampion 7ECA · Fredericksburg, TXThe pilot's failure to maintain directional control on the landing roll-out. A factor was the crosswind.NTSB DFW06CA022Accident · No injuriesData collectionFinal reportPiper PA38 · Decatur, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA234Accident · No injuriesData collectionFinal reportCessna 152 · Galveston, TXThe pilot's improper in-flight planning and decisions, which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA218Accident · No injuriesData collectionFinal reportCessna 152 · Bridgeport, TXThe pilot's inadequate compensation for wind conditions, and the flight instructor's delayed remedial action during a crosswind landing resulting in a loss of directional control.NTSB DFW05CA157Accident · Serious injuriesData collectionFinal reportGrumman AA1B · Llano, TXThe partial loss of engine power for undetermined reasons during takeoff resulting in an overrun. A factor was the high density altitude.NTSB DFW05CA136Accident · No injuriesData collectionFinal reportCessna 152 · Conroe, TXThe pilot's improper in-flight planning resulting in a total loss of engine power due to fuel exhaustion.NTSB DFW05CA108Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH-2000 · Panhandle, TXThe student pilot's improper compensation for existing wind conditions. Contributing factors were the crosswind and inadequate supervision by the flight instructor.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 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 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 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 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 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 FTW04LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Sugar Land, TXThe pilot's improper weather evaluation, and his encounter with adverse weather conditions. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB FTW04LA020Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Mineral Wells, TXthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB FTW03LA192Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Granbury, TXThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB FTW03LA095Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lockhart, TXThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the prevailing crosswind.NTSB FTW03FA037Accident · 1 fatalField investigationFinal reportCessna 152 · Justin, TXThe pilot's failure to maintain airspeed which resulted in a stall.NTSB FTW02LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXthe student pilot's improper recovery from a bounced landing, which resulted in a nose over.NTSB FTW02LA093Accident · No injuriesLimited investigationFinal reportTillman Long EZ · Lockhart, TXthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Perry, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB FTW02LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · New Braunfels, TXthe loss of engine power due to carburetor icing conditions while in cruise flight. A contributing factor was the lack of suitable terrain for the ensuing forced landing.NTSB FTW01FA188Accident · 1 fatalField investigationFinal reportCessna 152 · Weatherford, TXThe student pilot's improper decision making in that he landed with a tailwind and failed to execute a go-around, which resulted in a runway overrun. Contributing factors were the inaccurate reading of the left fuel gage as a result of improper maintenance by…NTSB FTW01LA174Accident · No injuriesLimited investigationFinal reportCessna 152 · Denison, TXthe pilot's delay in aborting the takeoff, which resulted in a runway overrun.NTSB FTW01LA135Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Amarillo, TXthe pilot's inadequate compensation for the crosswind, which resulted in a hard landing. A contributing factor was the crosswind.NTSB FTW00LA256Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Saspamco, TXthe failure of the #3 and #4 connecting rods. A contributing factor was the lack of suitable terrain condition for the forced landing.NTSB FTW00LA238Accident · No injuriesLimited investigationFinal reportCessna 152 · Wichita Falls, TXThe student pilot's delayed landing flare and failure to recover from the ensuing bounced landing.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 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 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.