NTSB investigations: Lycoming TI0-540 series, FL

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19832026

NTSB investigations: Lycoming TI0-540 series, FL per year, 1983–2026: 6 cases
1983	1
1986	1
1991	1
1994	1
1997	1
2005	1

Where

Open the map

Latest cases

Query with SQL

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" = 350)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 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" = '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" = 350))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 MIA05LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Fort Lauderdale, FLThe reported loss of engine power from the left engine, and the failure of the left propeller to feather for undetermined reasons, resulting in the inability to maintain altitude, and subsequent ditching.Aug 13, 2005 · N318JL · Substantial damage NTSB MIA98LA014Accident · No injuriesLimited investigationFinal reportAerofab Lake LA-250 · Miami, FLloss of engine power for an undetermined reason(s), which resulted in a forced landing and subsequent encounter with rough water.Oct 29, 1997 · N85HG · Substantial damage NTSB MIA94LA066Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Tamarac, FLThe loss of engine power for undetermined causes.Feb 3, 1994 · N15635 · Substantial damage NTSB MIA92LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Daytona Beach, FLTotal loss of engine power for undetermined reasons.Dec 8, 1991 · N22213 · Substantial damage NTSB MIA87FA002Accident · 1 fatalField investigationFinal reportPiper PA-60-600 · Tallahassee, FLWitnesses stated seeing the acft enter a left downwind apch to rwy 16, turn base to final normally then veer to the left of the runway in a nose high attitude & disappear behind a line of trees & crash aprx 500 feet east of rwy 16. Post crash examination of…Oct 2, 1986 · N217HM · Destroyed NTSB MIA83FA180Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Islamorada, FLThe acft was ditched in the Florida bay after the engine malfunctioned. According to the plt, the eng started to run rough and he ditched the acft at about 0600 EDT. However, the acft clock was stopped at 0345 and a commercial fisherman said he saw a low…Jul 11, 1983 · N6207J · Destroyed