NTSB investigations: Lycoming 0-235 series, TX
26 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Loss of engine power”. 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 | 2 |
|---|---|
| 1984 | 2 |
| 1985 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1996 | 1 |
| 1998 | 5 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 1 |
Where
Latest 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\" = 350))
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" = 350))
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 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 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 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 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 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 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 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 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 FTW99LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Bowie, TXThe hard landing due to the flight instructor's delayed remedial action to take control of the airplane when the engine lost power. Factors were the loss of engine power for an undetermined reason, and the rough and uneven terrain.NTSB FTW99LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Peaster, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA008Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Boyd, TXThe loss of engine power due to the total loss of engine oil for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.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 FTW96LA109Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Grand Prairie, TXa loss of power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW92LA188Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Carrollton, TXThe pilot's selection of unsuitable terrain. Factors were the failed carburetor de-ice system valve resulting in an inoperative carburetor and the inadequate annual inspection by company maintenance personnel.NTSB FTW92LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Henrietta, TXLoss of engine power from fuel exhaustion and the pilot's failure to refuel the airplane.NTSB FTW92LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Lubbock, TXFuel exhaustion as a result of the pilot's failure to refuel the airplane prior to the flight. A factor was the fbo's failure to properly maintain the fuel quantity gauges.NTSB FTW90LA108Accident · No injuriesLimited investigationFinal reportCessna 152 II · Katy, TXThe cfi's inadequate supervision of the student and the airplane.NTSB FTW85LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Katy, TXThe plt stated he had his destination arpt in sight and then lost sight of it. While attempting to locate the arpt the eng lost pwr. He attempted a emergency landing on an interstate hwy 10 west of houston, TX. After touchdown and during rollout the right…NTSB FTW85LA139Accident · No injuriesLimited investigationFinal reportCessna 152 · Kosse, TXDuring a return flt from mckinney to college station, TX, the eng lost power & the plt made a forced landing on a road near Kosse, TX. On the landing roll, the eng began running again. After stopping, the plt elected to 'check it out.' He estimated 5 gals of…NTSB FTW84LA303Accident · Minor injuriesLimited investigationFinal reportSmith Miniplane DSA-1 · Brookshire, TXThe acft collided with an unmarked wire after the engine quit on final apch. After the collision the plt was able to level the acft and crash landed about 250 ft short of the rwy. The impact snapped off one gear and folded the other. Theacft skidded to a stop…NTSB FTW84LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Acuff, TXThe CFI simulated an engine failure during flt at about 1000 ft AGL. When throttle was advanced the engine did not respond. The CFI made a forced landing in a plowed field and the acft nosed over in the soft furrowed dirt. An exam revealed no eng problems,…NTSB FTW82DA357Accident · No injuriesFinal reportCessna 152 · College Station, TXAfter the CFI cut power for a simulated forced landing, the student set up an approach to a road. When power was added at the bottom of the approach the engine accelerated to about 75% power & then decelerated back to idle. On touchdown on the road the left…NTSB FTW82DA159Accident · Minor injuriesFinal reportPiper PA-18 · Victoria, TXThe pilot tookoff at about 1535 to fly in the local area and then to proceed to his home at edna, TX. He flew to a ball field to observe some friends playing ball. After circling the field 3 times, he applied power and began a climb. He stated that about 30…