NTSB investigations: Lycoming TI0-540 series, FL
9 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
| 1986 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 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\" = 'FL' 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" = 'FL' 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 DEN06GA128Accident · 2 fatalFinal reportPiper PA-23-250 · Fort Meade, FLA loss of power in the right engine while manuevering for reasons undetermined, and failure to maintain aircraft control which resulted in an inadvertent stall. Contributing factors were the airspeed below Vmc, and an altitude too low to afford a safe…NTSB MIA05LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Pompano Beach, FLThe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and the loss of engine power in one engine. Contributing factors were the pilot's inadequate handling of the aircraft following failure of the right engine for his failure…NTSB MIA03LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-310 · Jupiter, FLThe pilot's failure to adequately plan for the flight which resulted in fuel exhaustion, a forced landing, and damage to the airplane during the landing.NTSB MIA02FA048Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Hollywood, FLThe pilot's inadequate planning for a Title 14 CFR Part 135 on-demand air taxi flight, and his failure to refuel the airplane, which resulted in fuel exhaustion while en route over the Atlantic Ocean, a power off glide, and ditching in the ocean.NTSB MIA96LA187Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · St Petersburg, FLa loss of engine power due to fuel contamination, which resulted in a forced landing (ditching) in water. Factors relating to the accident were: an inadquate annual inspection by maintenance personnel, and an inadequate preflight inspection by the pilot.NTSB MIA94LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301 · Live Oak, FLThe improper use of the fuel selector by the pilot-in-command by switching to an empty fuel tank. Contributing to the accident was the pilot's failure to switch back to a tank with fuel.NTSB MIA88LA266Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Punta Gorda, FLThe plt was returning from VFR xc flt during which many climbs, descents & detours were made to avoid adverse wx & maintain VFR. He stated the strong headwinds considerably reduced his grndspeed. At his 1st intended ldg arpt, strong gusty x-winds made the…NTSB MIA88LA069Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marathon, FLU.S. Coast guard personnel stated that the pilot reported that they were out of fuel and were ditching approximately 110 miles southeast of Marathon FL. The pilots were picked up by the coast guard and were transported back to miami.NTSB MIA86LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Ft. Pierce, FLThe plt stated that while switching tanks, his fuel selector froze up & both eng's failed. Upon landing, the acft struck a tree severing a wing. The NTSB form 6120.1 that was sent to the plt was returned, it stated that the addressee moved & left no address.…