NTSB investigations: Lycoming TI0-540 series, TX
10 cases on aircraft whose registry engine model is Lycoming TI0-540 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 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2002 | 1 |
| 2005 | 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 ('41533')
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 ('41533')
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 DFW05CA201Accident · Minor injuriesData collectionFinal reportSmith Aerostar 601P · Sinton, TXThe pilot's failure to abort the takeoff and the subsequent loss of engine power for undetermined reasons. Contributing factors were the attempted operation of the airplane with known deficiencies in the equipment and the lack of suitable terrain for the…NTSB FTW03LA046Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Kerrville, TXThe propeller shaft seal leak resulting in an in-flight fire.NTSB FTW00LA176Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Del Rio, TXThe separation of the #3 connecting rod, piston, and cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW00LA059Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Sweeney, TXThe pilot's excessive flare resulting in a hard landing. Factors were the loss of engine power for undetermined reasons, the power lines on final approach and the dark night conditions.NTSB FTW99LA178Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Houston, TXThe pilot's failure to maintain the proper descent rate during a forced landing, which resulted in a runway undershoot. Factors were the total loss of engine power for an undetermined reason and the dusk light conditions.NTSB FTW96LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Sulphur Springs, TXthe pilot's failure to maintain terrain clearance. A factor was his diverted attention to the performance of the manual gear extension procedure.NTSB FTW95FA069Accident · 1 fatalField investigationFinal reportPiper PA-32RT · San Antonio, TXThe loss of engine power for undetermined reasons. A factor related to the accident was: the lack of a suitable area for the forced landing.NTSB FTW87LA075Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · George West, TXAircraft collided with power lines during forced landing due to fuel exhaustion. Owner has not responded to letters. Warrant was issued for arrest of person thought to be pilot. Aircraft had traces of marijuana on board.NTSB FTW86LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Rio Hondo, TXThe right eng failed during cruise flt and the plt was unsuccessful in his attempt to restart the eng. The acft was unable to maintain alt and impacted the ground resulting in substantial damage to the acft. Although there was no evidence of any…NTSB FTW83LA034Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · El Paso, TXWhile on a business cross country flight the fuel pressure began dropping with a subsequent drop in power. The pilot attempted to reduce manifold pressure to keep the engine running. Approximately 3-5 miles from El Paso airport the pilot landed on the desert.…