NTSB investigations: Lycoming 0-235 series, TX
36 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Loss of control - on ground/water”. 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 per year
| 1982 | 6 |
|---|---|
| 1983 | 3 |
| 1984 | 4 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 3 |
| 1991 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 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 DFW06CA202Accident · No injuriesData collectionFinal reportCessna 152 · Gainesville, TXThe pilot's improper recovery from a bounced landing resulting in a porpoise.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 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 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 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 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 FTW99LA195Accident · No injuriesLimited investigationFinal reportCessna 152 · Frisco, TXThe pilot's failure to maintain directional control of the airplane during the simulated soft field takeoff.NTSB FTW99LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe student pilot's loss of directional control due to improper use of the rudder. A factor was the hilly terrain beyond the departure end of the runway.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 FTW97LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe pilot's loss of control due to delayed landing flare. A factor was the porpoise encountered during landing.NTSB FTW96LA364Accident · No injuriesLimited investigationFinal reportCessna 152 · Spring, TXfailure of the pilot to maintain directional control of the airplane during a touch-and-go, which resulted in an inadvertent ground swerve, an encounter with soft terrain, and a nose over of the airplane.NTSB FTW95LA215Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Corpus Christi, TXThe pilot's inadequate compensation for crosswind conditions.NTSB FTW94LA085Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Eagle Lake, TXThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB FTW91LA044Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Friendswood, TXThe duel student's failure to maintain directional control during the landing and his inadvertent activation of the brakes. A factor was the ditch.NTSB FTW88LA144Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Kingsland, TXThe tail-dragger touched down on the left gear, then the right gear. The pilot applied power for a go-around but he said he then cut it off because he was going to be going so close to the hangar. The airplane went off the left side of the runway and…NTSB FTW88LA086Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Grand Prairie, TXThe student pilot lost directional control on the takeoff ground run and the aircraft was damaged after it ran off the runway. The reported weather showed a 90 degree left crosswind at 12 knots velocity with gusts to 20 knots. The plt did not file an acc…NTSB FTW88LA071Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Benito, TXThe student plt was making a touch and go on his second solo flt. After the flaps were retracted and the power was increased, the acft veered to the right and hit a runway light. The acft then continued into the dirt beside the runway where the nose gear…NTSB FTW87LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Arlington, TXThe dual student pilot, while on his second flight, suddenly applied full right rudder during flare/touchdown and froze on the controls while in this position. The aircraft veered off the right side of the runway into deep and soft mud before the CFI could…NTSB FTW87LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXA student pilot on a solo flight in the local area, lost control of the aircraft while practicing touch and go landings. Substantial damage occurred when the aircraft slid off the rt side of the rwy into a ditch, causing the aircraft to nose over inverted.NTSB FTW87LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · Plano, TXAccording to the pilot, the aircraft was substantially damaged when he lost control of the aircraft on touch down.NTSB FTW86LA110Accident · No injuriesLimited investigationFinal reportCessna 152 · Mineola, TXThe student pilot was practicing touch and go landings when he lost control of the acft on landing. He stated he lost directional control due to windy conditions. However, winds in the area were reported to be calm. The aircraft veered off the runway damaging…NTSB FTW86LQA01Accident · Minor injuriesFinal reportCessna 152 · El Paso, TXThe acft went off the rwy and nosed over in the rough sand. The plt said that she looked into the cockpit to locate the flap switch to raise the flaps for a running takeoff. Power had already been added and the acft started to the left by the time the plt…NTSB FTW85LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXShortly after touchdown on a full stop landing directional control was lost and the acft went off the left side of the 5,000 x 100 ft rwy. The aircraft collided with and came to rest in a ditch on the north side of the runway. Winds were northeasterly at 10…NTSB FTW85LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · Denver City, TXPlt cited gust on landing caused acft to drift to right, plt visual acuteness reduced by landing into setting sun. Corrective control input of left aileron was excessive, causing left wing to drop to ground contact. Acft pivoted about left wing tip and came…NTSB FTW84LA396Accident · No injuriesLimited investigationFinal reportCessna 152 · Laporte, TXDuring the ldg flare the acft drifted left and touched down near the edge of the rwy. The plt did not correct the drift and the acft drifted off the left side of the rwy. After colliding with a ditch the acft nosed over coming to rest inverted.NTSB FTW84LA276Accident · No injuriesLimited investigationFinal reportCessna 152 · Houston, TXShortly after touchdown during a touch and go landing directional control was lost. Acft veered off left side of rwy and came to rest in a waterway used by seaplanes that is adjacent and parallel to rwy 17L.NTSB FTW84LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Weslaco, TXThe student was practicing touch & go landings on a solo flt. On his 1st apch, the acft touched down on the left side of the rwy. The student reported that when he added power to go around, the acft veered to the left. He reported that he applied excessive…NTSB FTW84LA010Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 Special · Wichita Falls, TXThe plt reported that during a landing with a quartering left head wind, the right brake did not hold & the acft veered to the left. He added power in an attempt to avoid a ground loop; however, the acft went in a wet, plowed field & nosed over. Reportedly,…NTSB FTW83LA306Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · El Paso, TXThe plt was practicing touch-&-go landings & stated that he had been flying with the mixture leaned. After a landing, he applied full throttle, but the eng coughed & sputtered. He then advance the mixture to rich to correct the situation. At about the same…NTSB FTW83LA012Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXWhile practicing touch & go landings the student plt lost directional control, ran off the side of the rwy into a ditch collapsing the nose gear & turning over.NTSB FTW82DA288Accident · No injuriesFinal reportCessna 152 · Huntsville, TXThe student stated that on her fourth landing of the day, she felt she was too FAR down the runway and to high to make a good landing, so she "put in flaps and power and was going to make a go-around." Reportedly, the aircraft landed, she lost directional…NTSB FTW82DPA13Accident · No injuriesFinal reportCessna 152 · Mckinney, TXThe student pilot practicing touch and go landings lost control of the aircraft and swerved off the runway. The aircraft then contacted a fence and nosed over.NTSB FTW82DA058Accident · No injuriesFinal reportCessna 152 · Cleveland, TXOn the second landing of a supervised solo flight, the aircraft veered and the student pilot lost control. The aircraft collided with the wind sock pole and was substantially damaged.NTSB FTW82DA051Accident · No injuriesFinal reportCessna 152 · Mckinney, TXDuring local solo flight the aircraft veered off the left side of the runway resulting in substantial damage to the Cessna. The winds were gusting from 8 to 13 knots 35 degrees to the left of the runway heading.NTSB FTW82DA044Accident · No injuriesFinal reportCessna 152 · Midland, TXDuring the student's first supervised solo flight he landed normally but lost control prior to adding power for a touch and go landing. The aircraft ran off the runway and collided with a pile of gravel coming to rest inverted.