NTSB investigations: Lycoming 0-235 series, TX
22 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 2 |
| 1992 | 1 |
| 1993 | 2 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 3 |
| 1999 | 1 |
| 2005 | 3 |
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\" = 353))
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" = 353))
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 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 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 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 FTW99LA273Accident · No injuriesLimited investigationFinal reportCessna 152 · Slaton, TXThe pilot's failure to refuel the airplane resulting in fuel exhaustion. Factors were the pilot's inadequate preflight planning and the lack of suitable terrain for the forced landing.NTSB FTW97LA244Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXfuel exhaustion, due to the pilot's failure to refuel before taking off on the remainder of the flight after making a precautionary landing. Factors related to the accident were: the pilot becoming lost and disoriented, and the lack of suitable terrain for a…NTSB FTW97LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97FA173Accident · Minor injuriesField investigationFinal reportGowan LONG-EZ · Roanoke, TXThe pilot's failure to maintain the proper descent rate. A factor was the gascolator's filter screen becoming contaminated with fiber glass residue due to the pilot/mechanic's inadequate maintenance.NTSB FTW97LA013Accident · No injuriesLimited investigationFinal reportDickson RV-3A · Rosharon, TXThe pilot's failure to follow procedures and directives in that he did not use carburetor heat and he did not periodically clear the engine during an extended glide. Factors were the carburetor icing weather conditions and the transmission wire.NTSB FTW96LA105Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Falfurrias, TXfuel starvation due to the pilot's improper positioning of the fuel selector. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA262Accident · No injuriesLimited investigationFinal reportBeech 77 · Mcallen, TXThe dual student's failure to properly operate the throttle and the inadequate supervision by the flight instructor. A factor was the lack of suitable terrain for the forced landing.NTSB DEN93LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Timpson, TXThe pilot in command's failure to refuel resulting in fuel exhustion. Factors were: the lack of suitable terrain for the forced landing, and dark night light conditions.NTSB FTW93FA158Accident · Serious injuriesField investigationFinal reportPiper PA-22-108 · Weatherford, TXTotal loss of engine power with cause undetermined. A factor was the lack of suitable terrain.NTSB FTW92FA107Accident · Minor injuriesField investigationFinal reportCessna 150 II · Fort Worth, TXA fuel exhaustion induced engine power loss due to the pilot's failure to refuel. A factor was the pilot's inadvertent disorientation.NTSB FTW89DRG10Accident · 1 fatalFinal reportZenair CH-200 · Kerrville, TXImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB FTW89LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Kaufman, TXStudent pilot inadvertently becoming lost/disoriented and exhausting the fuel in the fuel system.NTSB FTW88LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · San Antonio, TXThe pilot experienced a complete loss of engine power while on the final approach. The damage to the aircraft occurred when he had to land on unsuitable terrain during the forced landing. Examination of the aircraft fuel system showed that a fuel line to the…NTSB FTW87LA212Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Roby, TXAfter aprx 3.3 hrs of flt, the eng lost power from fuel exhaustion. The plt rprtd that when he made a forced landing in a field, the nose tire dug in the ground & the acft nosed over. Also, he stated that he did not top off the fuel tanks before departing on…NTSB FTW87LA171Accident · No injuriesLimited investigationFinal reportCessna 152 · Graham, TXThe approximate half tanks of fuel which the student pilot reportedly observed on board during his preflight inspection (and which should have been on board at that time) apparently leaked out through the broken fuel line fitting at the carburetor while the…NTSB FTW86LPA08Accident · No injuriesFinal reportCessna 152II · Frisco, TXThe student plt stated that he departed mckinney municipal arpt at aprx 1030 LCL en route to wichita falls, TX. He said he became disoriented while en route, but landed at wichita falls at aprx 1220 LCL. The plt did not refuel the acft. He then departed…NTSB FTW83LA138Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Shiro, TXWhile on a solo cross-country, the student plt became disoriented on the 3rd leg of the flt. He reoriented himself, but the eng lost power before he reached his intended destination. During an emergency landing, the acft encountered soft terrain & was damaged…NTSB FTW82DA170Accident · No injuriesFinal reportCessna 152 · Coahama, TXThe pilot was on a cross country flight for his commercial pilot's license. He became lost, landed in a plowed open field and the aircraft nosed over. There was no evidence of propeller rotation or fuel at the scene of the accident.NTSB FTW82DA060Accident · No injuriesFinal reportBellanca 7ECA · Henderson, TXAfter reducing power to idle, gliding for some distance, and then applying carburetor heat he realized that additional power would be needed to reach the runway. Power was added with no results and the aircraft was set down in a rough field approximately 1/4…