NTSB investigations: Lycoming TI0-540 series, WV

12 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

19662026

NTSB investigations: Lycoming TI0-540 series, WV per year, 1966–2026: 12 cases
1966	1
1975	1
1976	1
1977	1
1984	1
1989	1
1991	1
1995	1
1996	1
2004	2
2014	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" = 'WV' 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')) 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\" = 'WV' 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'))
  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" = 'WV' 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'))
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 ERA14FA192Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Hugheston, WVThe pilot's loss of airplane control while operating in instrument flight rules conditions.Apr 11, 2014 · N39965 · Destroyed NTSB IAD05CA025Accident · Minor injuriesData collectionFinal reportSmith, Ted Aerostar 601P · Wheeling, WVThe pilot misjudged his distance/speed, and his intentional landing on an unsuitable taxiway at night. A factor in the accident was the night light conditions.Dec 19, 2004 · N60CF · Substantial damage NTSB NYC04FA170Accident · 5 fatalField investigationFinal reportPiper PA-32R-301T · Wheeling, WVThe pilot's failure to maintain terrain clearance while executing an instrument approach. A factor was the night instrument meteorological conditions.Jul 19, 2004 · N7710M · Destroyed NTSB NYC96FA073Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Bridgeport, WVThe pilot's inablility to maintain aircraft control due to a full nose down trim condition, which resulted in a loss of control and collision with terrain.Mar 11, 1996 · N222WR · Destroyed NTSB BFO96IA012Incident · No injuriesIncident investigationFinal reportPiper PA-23 · Beckley, WVan in-flight fire (behind the right side of the instrument panel), which occurred for undetermined reason(s).Oct 14, 1995 · N65SC · Minor damage NTSB BFO91FA078Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Sod, WVThe improper level off which resulted in a hard landing. Contributing was fuel starvation resulting in partial loss of engine power.Aug 31, 1991 · N5435Y · Destroyed NTSB BFO90LA016Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Morgantown, WVThe pilot's excessive taxi speed. Ice on the ramp and the location of the fence were related factors.Dec 9, 1989 · N7485L · Substantial damage NTSB ATL84FA093Accident · 4 fatalField investigationFinal reportPiper PA-32RT-300T · Bluefield, WVThe non-instrument rated plt began his takeoff during the hours of darkness, but in VMC wx. He stated that during the takeoff roll at about 65 to 75 KTS just prior to rotation, the landing light extinguished. Plt stated that 2 to 3 seconds later, he rotated &…Feb 9, 1984 · N22457 · Destroyed NTSB IAD78FA021Accident · No injuriesClosedPiper PA-32R · Buckhannon, WVDec 11, 1977 · N200HM · Substantial damage NTSB IAD76AI077Accident · No injuriesClosedPiper PA-32R · Davis, WVJun 22, 1976 · N4505X · Substantial damage NTSB IAD76II032Incident · No injuriesClosedPiper PA-23 · Beckley, WVNov 12, 1975 · N100BA · Minor damage NTSB NYC67F0193Accident · No injuriesClosedAero Cmdr 500-B · Elkins, WVAug 16, 1966 · N2001 · Substantial damage