Fatal NTSB investigations: Lycoming TI0-540 series, PA

11 cases on aircraft whose registry engine model is Lycoming TI0-540 series. 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

19782026

Fatal NTSB investigations: Lycoming TI0-540 series, PA per year, 1978–2026: 11 cases
1978	3
1980	1
1981	1
1983	1
1985	1
1998	1
2001	1
2002	1
2016	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" = 'PA' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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')) 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\" = 'PA' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    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'))
  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" = 'PA' AND c."eventCountry" = 'USA'
  AND c."highestInjuryLevel" = 'Fatal'
  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'))
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 ERA16FA215Accident · 2 fatalField investigationFinal reportPiper PA31 · State College, PAThe pilot's decision to continue an unstabilized instrument approach in instrument meteorological conditions, which resulted in controlled flight into terrain.Jun 16, 2016 · N3591P · Destroyed NTSB NYC02FA106Accident · 2 fatalField investigationFinal reportCessna A185F · Pleasant Mount, PAThe pilot's inadequate in-flight planning/decision resulting in flight into adverse weather, and his failure to maintain aircraft control, resulting in overstress of the aircraft. A factor was the thunderstorm activity.May 30, 2002 · N1577B · Destroyed NTSB NYC01FA223Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Bern Township, PAThe pilot's loss of control for undetermined reasons, which resulted in a high speed dive to the ground.Sep 5, 2001 · N8PK · Destroyed NTSB NYC98FA179Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar TS-600 · Marietta, PAThe failure of the pilot to maintain airspeed during a precautionary landing which resulted in a loss of control while operating with one engine shutdown. An additional cause was the improper maintenance procedures that resulted in the #5 cylinder not being…Sep 5, 1998 · N600JB · Destroyed NTSB NYC86FA027Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Landisburg, PAThe non-instrument rated pilot took off on a VFR crosscounty flight with no weather briefing. He flew into an area of adverse weather including low clouds, fog, drizzle & haze. The aircraft impacted near the top of a 2100 ft high hill in forested terrain.Oct 23, 1985 · N54264 · Destroyed NTSB NYC84FA033Accident · 6 fatalField investigationFinal reportAero Commander 500B · Franklin, PABefore departing youngstown, OH, the plt filed 2 IFR flt plans, 1 for a flt to plattsburgh, NY, the other for a return flt from plattsburgh back to youngstown. After a 2 hr & 10 min flt to plattsburgh, 70 gal of fuel was added, but the person who serviced the…Nov 20, 1983 · N6226X · Destroyed NTSB NYC82FA009Accident · 4 fatalClosedPiper PA-32 · Mount Pocono, PANov 15, 1981 · N178RB · Destroyed NTSB NYC80FA028Accident · 2 fatalClosedPiper PA-24 · East Freedom, PAMar 17, 1980 · N9226P · Destroyed NTSB NYC78FA090Accident · 2 fatalClosedPiper PA-32 · Honesdale, PASep 10, 1978 · N789CC · Destroyed NTSB NYC78FA058Accident · 1 fatalClosedPiper PA-31 · Fleetville, PAMay 23, 1978 · N9057Y · Destroyed NTSB NYC78FA032Accident · 1 fatalClosedPiper PA-23 · Connellsville, PAMar 12, 1978 · N40355 · Destroyed