NTSB investigations: Lycoming O&VO-360 series, TX
16 cases on aircraft whose registry engine model is Lycoming O&VO-360 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
| 1983 | 1 |
|---|---|
| 1985 | 2 |
| 1987 | 1 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2005 | 1 |
| 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 ('41514')
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 ('41514')
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 DFW07CA202Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Taylor, TXThe loss of engine power due to fuel exhaustion as result of the pilot's inadequate in-flight planning/decision. Contributing factors were the lack of suitable terrain for the forced landing and the dark night.NTSB DFW06CA181Accident · Minor injuriesData collectionFinal reportMooney M20C · Eldorado, TXThe pilot's failure to switch fuel tanks during cruise flight, which resulted in a loss of engine power due to fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05LA159Accident · 1 fatalLimited investigationFinal reportHughes 269A · Rusk, TXA loss of engine power for undermined reasons, and the subsequent collision with power lines and the ground. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA002Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Horizon City, TXThe fuel exhaustion due to the pilot's failure to refuel the airplane. Factors were the unfavorable wind condition and the lack of suitable terrain for the forced landing.NTSB FTW98LA042Accident · No injuriesLimited investigationFinal reportMooney M20C · Ozona, TXthe pilot's improper planning/decision, which led to fuel exhaustion, loss of engine power, and a forced landing. A related factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Worth, TXInadequate preflight by the pilot, and improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power during takeoff. Darkness was a related factor.NTSB FTW95LA058Accident · No injuriesLimited investigationFinal reportCessna 177 · Katy, TXFuel exhaustion due to the pilot's failure to refuel. A factor was the unsuitable terrain at the pilot's disposal for the forced landing.NTSB FTW93LA155Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Dougherty, TXFuel exhaustion power loss due to refueling not performed by the pilot. A factor was lack of suitable terrainNTSB FTW92LA204Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Nevada, TXThe PIL0T'S inadvertent stall of the airplane during the forced landing and his failure to refuel the airplane en route.NTSB FTW92LA178Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Port Isabel, TXThe loss of power to the right engine due to a fractured crankshaft while the left engine was secured. Factors were the dual students failure to use carburetor heat while performing maneuvers and the unsuitable terrain.NTSB FTW92LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Fort Worth, TXThe pilot's selection of unsuitable terrain. Factors were the fuel starvation and the tough terrain.NTSB FTW91LA071Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Longview, TXFuel exhaustion resulting in a complete power loss due to the pic/cfi's failure to refuel at intermediate destinations.NTSB FTW87LA202Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bridgeport, TXThe engine quit during cruise flight at 5500 feet MSL but restarted when the pilot switched fuel tanks. He then headed for the nearest airport which was at Bridgeport, TX. While on final approach for landing the engine stopped again and would not restart. A…NTSB FTW85LA325Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Llano, TXThe plt stated he entered the traffic pattern at 2000 ft for a left downwind to rwy 17. He then reduced pwr to 1700 RPM and placed the mixture control into the full rich position. He assured that carburetor heat was off and then started his descent. The eng…NTSB FTW85LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · League City, TXThe acft collided with a ditch about 75 yards short of rwy 13 during a practice night forced landing. The pvt plt, an employee of the FBO operator, had taken the acft without permission and had been flying for approx 1.7 hrs when the accident occurred. The 18…NTSB FTW83LA337Accident · No injuriesLimited investigationFinal reportBeech C23 · Longview, TXThe acft crashed during a forced landing after the engine quit on the downwwind leg of the traffic pattern. The flt had taken off shortly before with one tank almost full and one almost empty. The fuel selector valve was found in the 'off' position after the…