NTSB investigations: Lycoming TI0-540 series, TX
7 cases on aircraft whose registry engine model is Lycoming TI0-540 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 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2000 | 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\" = 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 ('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" = 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 FTW00LA170Accident · No injuriesLimited investigationFinal reportAero Commander 700 · Breckenridge, TXFuel exhaustion as a result of an inaccurate fuel quantity indicating system. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA232Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · El Indio, TXthe pilot's inadequate preflight, subsequent fuel starvation, and failure of the pilot to reposition the fuel selector to another tank (perform emergency procedure) after the loss of engine power, which resulted in a forced landing and subseqent nose-over.…NTSB FTW95LA085Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Brownsville, TXThe fuel starvation loss of engine power due to the pilot's improper use of the fuel tank selector. Factors were the pilot's qualification and the lack of suitable terrain for landing.NTSB FTW94LA136Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Laredo, TXThe fuel exhaustion induced power loss due to the pilot's inadequate preflight and his failure to refuel the airplane prior to departure. A factor was the lack of suitable terrain for the forced landing.NTSB FTW89FA007Accident · No injuriesField investigationFinal reportPiper PA-31-350 · Edinburg, TXAcft experienced a double eng failure. Plt stated that immediately after the left eng failed, in climb to cruise, the acft rolled left, the stall warning activated, and the acft entered a left spiral. The rt eng failed during the two-turn spiral. Plt's…NTSB FTW87FA149Accident · No injuriesField investigationFinal reportPiper PA-60-601 · Hillsboro, TXAprx 3 min after leveling at 6500', the acft began losing pwr despite attempts to remedy the problem by using boost pump & x-feed. Subsequently, both engs lost power & the acft was damaged drg a wheels-up lndg in a milo field. An exam revealed the upper &…NTSB FTW83LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Houston, TXThe aircraft struck a tree when the pilot was landing on a road. After tree impact, the aircraft spun around and crashed on the road sliding into a culvert and a telephone pole. The aircraft had been stolen and two occupants were observed to exit the aircraft…