Skip to content

Fatal NTSB investigations: Lycoming TI0-540 series, Outside the U.S.

27 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

19722026

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."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.\"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."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 GAA26WA072Accident · 6 fatalClass 3 · ForeignPiper PA-31-325 · Paipa, ColombiaJan 10, 2026 · N325FA · Destroyed NTSB GAA23WA042Accident · 1 fatalClass 5 · ForeignPiper PA 46-350P · Happy Valley-Goose Bay, CanadaDec 14, 2022 · N5EQ · Destroyed NTSB GAA22WA227Accident · 2 fatalClass 5 · ForeignPiper PA-31-325 · Queretaro, MexicoJul 12, 2022 · N28DF · Substantial damage NTSB GAA22WA187Accident · 2 fatalClass 5 · ForeignSmith Aerostar 601P · Ceballos, MexicoMay 23, 2022 · N66CG · Destroyed NTSB ERA19WA040Accident · 1 fatalForeign investigationPiper PA23 · Nassau, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Piper PA23 airplane that occurred on November 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…Nov 8, 2018 · N8383C · Substantial damage NTSB ERA18WA063Accident · 6 fatalForeign investigationPiper PA-23-250 · Nicholls Town, BahamasThe government of Bahamas has notified the NTSB of an accident involving a PIPER PA 23-250 airplane that occurred on January 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the…Jan 17, 2018 · N62769 · Destroyed NTSB CEN15WA254Accident · 2 fatalForeign investigationCessna T182 - T · Carlow, IrelandMay 24, 2015 · N247P · Destroyed NTSB CEN15WA133Accident · 1 fatalForeign investigationPiper PA 46 350P · Meyrin, SwitzerlandJan 30, 2015 · N246PR · Destroyed NTSB CEN13WA405Accident · 1 fatalForeign investigationPiper PA-32R-301T · Lagunillas, MexicoMay 30, 2013 · N371HP · Substantial damage NTSB ERA12WA255Accident · 4 fatalForeign investigationPiper PA-32R-300 · Treasure Cay, BahamasOn March 25, 2012, at 1830 UTC, a Piper PA-32R-300, N8415C, was substantially damaged when it crashed shortly after takeoff from Treasure Cay International Airport (MYAT), Abaco, Bahamas. The two certificated private pilots and two passengers were fatally…Mar 25, 2012 · N8415C · Substantial damage NTSB ERA11WA088Accident · 1 fatalForeign investigationPiper PA-32R-301T · Roma, ItalyOn December 8, 2010, at 1443 UTC, a Piper PA-32R-301T, N58SE, registered to Aircraft Guaranty Title Corporation Trustee,collided with a bus depot after departing runway 34 from Roma Urbe Airport (LIRU), Roma, Italy. The airplane had been recently purchased by…Dec 8, 2010 · N58SE · Destroyed NTSB ERA10WA281Accident · 2 fatalForeign investigationPiper PA23 · North Bimini, BahamasOn May 25, 2010, at approximately 1830 eastern daylight time, a twin engine, Piper PA-23-250 airplane, N1526T, collided with power lines and crashed into the sea while flying at a low altitude shortly after takeoff from South Bimini Airport, South Bimini,…May 25, 2010 · N1526T · Substantial damage NTSB ERA10WA116Accident · 3 fatalForeign investigationPiper PA-32-300 · Bimini, Bahamas, BahamasOn January 17, 2010, at approximately 1545 eastern standard time, a Piper PA-32-300, N4219R, crashed approximately 500 yards northwest of the Bimini Bay Resort, North Bimini, Bahamas. The flight departed Lynden Pindling International Airport, Nassau, Bahamas…Jan 17, 2010 · N4219R · Destroyed NTSB CEN09WA091Accident · 2 fatalClass 5 · ForeignPiper PA46 · Baden, AustriaDec 14, 2008 · N403HP · Destroyed NTSB DEN08WA094Accident · 2 fatalForeign investigationPiper PA-46-350P · Léguillac-de-l'Auche, FranceMay 25, 2008 · N9245D · Destroyed NTSB NYC08WA173Accident · 8 fatalClass 5 · ForeignPiper PA-31-310 · Maiquetia, VenezuelaOn April 28, 2008, about 1425 coordinated universal time (UTC), a Piper PA-31-310, N6463L, was destroyed during impact with residences, shortly after takeoff from Aeropuerto Internacional Del Centro Simon Bolivar (SVMI), Maiquetia, Venezuela. The certificated…Apr 28, 2008 · N6463L · Destroyed NTSB DFW05RA063Accident · 2 fatalForeign investigationPiper PA-32RT-300 · Guerrero, MexicoJan 20, 2005 · N2144C · Substantial damage NTSB WAS05WA004Accident · 5 fatalForeign investigationAerostar 600 · Cornelia, South AfricaJan 18, 2005 · N7478S · Destroyed NTSB MIA04FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-32-300 · Missing, BahamasUndetermined.Nov 13, 2003 · N8224C · Destroyed NTSB ATL02WA116Accident · 2 fatalForeign investigationAero Commander 500-B · Roseau, DominicaMay 31, 2002 · N78336 · Destroyed NTSB NYC01WA082Accident · 2 fatalForeign investigationAero Commander 500S · Kross, IcelandMar 6, 2001 · N272BB · Destroyed NTSB MIA98WA156Accident · 1 fatalForeign investigationPiper PA-23-250 · Walker'S Cay, BahamasMay 8, 1998 · N5813Y · Substantial damage NTSB MIA97WA017Accident · 2 fatalForeign investigationPiper PA-32-300 · St. Vincent, WNOct 31, 1996 · N970CA · Destroyed NTSB DCA94WA077Accident · 2 fatalForeign investigationAero Commander 500S · Westman Isles, IcelandSep 23, 1994 · N9082N · Destroyed NTSB MIA92WA119Accident · 1 fatalForeign investigationPiper PA-32-300 · San Michele, HaitiApr 29, 1992 · N4026W · Destroyed NTSB MIA88WA252Accident · 2 fatalForeign investigationPiper PA-23-250 · Gr. Harbor Cay, BahamasAug 9, 1988 · N6737Y · Destroyed NTSB MIA73RM030Accident · 5 fatalClosedPiper PA-23 · Georgetown, Burkina FasoSep 11, 1972 · N14265 · Destroyed