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.

NTSB CEN13LA209Accident · No injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe failure of the nose landing gear fork during landing due to fatigue.Mar 26, 2013 · N48693 · Substantial damageNTSB 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,…Feb 1, 2013 · N247RB · 2 aircraft · Substantial damageNTSB 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…Aug 25, 2012 · N5796L · Substantial damageNTSB 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.Aug 4, 2012 · N2552C · Substantial damageNTSB CEN12LA257Accident · No injuriesLimited investigationFinal reportClifton Breezy · Laneville, TXA loss of engine power due to carburetor ice.Apr 23, 2012 · N6155M · Substantial damageNTSB CEN11CA217Accident · Minor injuriesData collectionFinal reportPiper PA-22-108 · Lockhart, TXThe pilot's failure to maintain clearance from trees.Mar 7, 2011 · N4571Z · Substantial damageNTSB 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.Mar 4, 2010 · N6503M · Substantial damageNTSB CEN09LA490Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Whitney, TXA partial loss of engine power for undetermined reasons.Aug 3, 2009 · N1644R · Substantial damageNTSB CEN09CA048Accident · No injuriesData collectionFinal reportCessna 152 · Spring, TXFailure of the student pilot to apply appropriate actions following a bounced landing.Nov 3, 2008 · N47221 · Substantial damageNTSB 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.Jun 15, 2008 · N2345G · Substantial damageNTSB DFW08CA162Accident · No injuriesData collectionFinal reportCessna CE-152 · Castroville, TXAn improper flare during landing. Contributing to the accident was a porpoise induced oscillation.May 29, 2008 · N4789P · Substantial damageNTSB 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.Feb 8, 2008 · N24768 · Substantial damageNTSB 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.Dec 20, 2007 · N49962 · Substantial damageNTSB 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.May 9, 2007 · N25945 · Substantial damageNTSB 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.Apr 28, 2007 · N49108 · Substantial damageNTSB 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.Jan 26, 2007 · N83HT · Substantial damageNTSB 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.Nov 23, 2006 · N67503 · Substantial damageNTSB 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.Oct 21, 2006 · N2426N · Substantial damageNTSB DFW06CA202Accident · No injuriesData collectionFinal reportCessna 152 · Gainesville, TXThe pilot's improper recovery from a bounced landing resulting in a porpoise.Aug 25, 2006 · N6102Q · Substantial damageNTSB 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.May 19, 2006 · N2378K · Substantial damageNTSB 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.Dec 29, 2005 · N7569F · Substantial damageNTSB 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.Nov 6, 2005 · N2593P · Substantial damageNTSB 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.Sep 9, 2005 · N68440 · Substantial damageNTSB 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.Aug 20, 2005 · N6459M · Substantial damageNTSB 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.Jul 5, 2005 · N1466R · Substantial damageNTSB 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.May 24, 2005 · N67770 · Substantial damageNTSB 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.Apr 25, 2005 · N215LF · Substantial damageNTSB 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…Mar 8, 2005 · N3870W · Substantial damageNTSB 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.Feb 13, 2005 · N6717S · Substantial damageNTSB DFW05LA025Accident · Minor injuriesLimited investigationFinal reportWingo Long-Ez · Huntsville, TXLoss of engine power for undetermined reasons. A contributing factor was the unsuitable terrain for landing.Nov 25, 2004 · N234BW · Substantial damageNTSB 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.Oct 9, 2004 · N5529K · Substantial damageNTSB 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.Jul 4, 2004 · N6241L · Substantial damageNTSB 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.May 24, 2004 · N5302E · Substantial damageNTSB 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.Mar 2, 2004 · N2588A · Substantial damageNTSB FTW04LA020Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Mineral Wells, TXthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Nov 12, 2003 · N95604 · Substantial damageNTSB 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.Aug 8, 2003 · N9347T · DestroyedNTSB 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.Feb 9, 2003 · N25324 · Substantial damageNTSB FTW03FA037Accident · 1 fatalField investigationFinal reportCessna 152 · Justin, TXThe pilot's failure to maintain airspeed which resulted in a stall.Nov 8, 2002 · N4835B · Substantial damageNTSB FTW02LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXthe student pilot's improper recovery from a bounced landing, which resulted in a nose over.May 9, 2002 · N48819 · Substantial damageNTSB 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.Mar 13, 2002 · N126DT · Substantial damageNTSB 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.Nov 30, 2001 · N95565 · Substantial damageNTSB 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.Nov 22, 2001 · N48941 · Substantial damageNTSB 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…Aug 22, 2001 · N4755B · DestroyedNTSB FTW01LA174Accident · No injuriesLimited investigationFinal reportCessna 152 · Denison, TXthe pilot's delay in aborting the takeoff, which resulted in a runway overrun.Aug 5, 2001 · N5183P · Substantial damageNTSB 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.Jun 2, 2001 · N2495C · Substantial damageNTSB 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.Sep 12, 2000 · N64921 · Substantial damageNTSB FTW00LA238Accident · No injuriesLimited investigationFinal reportCessna 152 · Wichita Falls, TXThe student pilot's delayed landing flare and failure to recover from the ensuing bounced landing.Aug 21, 2000 · N4711L · Substantial damageNTSB 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.Jun 19, 2000 · N94290 · Substantial damageNTSB 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.Apr 15, 2000 · N2868Z · Substantial damageNTSB 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.Mar 28, 2000 · N94912 · Substantial damage