NTSB investigations: Lycoming TI0-540 series, 2006
6 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 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 5 |
| 1988 | 3 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 2 |
| 1994 | 3 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 5 |
| 2000 | 4 |
| 2001 | 7 |
| 2002 | 6 |
| 2003 | 3 |
| 2004 | 1 |
| 2005 | 6 |
| 2006 | 6 |
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 year(c.\"eventDate\") = 2006
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 year(c."eventDate") = 2006
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 NYC07FA043Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Charlottesville, VAA loss of engine power for undetermined reasons.NTSB DEN06CA105Accident · No injuriesData collectionFinal reportSchweizer G-164B · Joes, COA loss of engine power due to the failure of the supercharger. Contributing to the accident was a lack of suitable terrain for a forced landing.NTSB SEA06FA139Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Easton, WAThe loss of power in both engines for undetermined reasons while in cruise flight, leading to an attempted forced landing. Factors include unfavorable winds at the site of the forced landing, and trees off the approach end of the grass runway the pilot was…NTSB ANC06LA078Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Borinquen, PRFuel starvation/exhaustion for an undetermined reason during cruise flight, which resulted in a complete loss of engine power to both engines and a ditching in the ocean.NTSB MIA06TA093Accident · Minor injuriesFinal reportPiper PA-31-310 · St. ThomasThe loss of engine power in both engines for an unknown reason.NTSB DEN06LA045Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Manhattan, KSA loss of engine power due to the intermittent grounding of the left magneto "P" lead, causing the fuel controller to search and the engine to surge then lose power, and the pilot's failure to attain proper runway alignment. Contributing factors were the…