Skip to content

NTSB investigations: Garrett TFE731 series, Outside the U.S.

14 cases on aircraft whose registry engine model is Garrett TFE731 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

19952026

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('29001')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('29001'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('29001'))
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 ERA23LA081Accident · No injuriesClass 4 · LimitedFinal reportLearjet 35 · Guantanamo Bay, CubaThe flight crew’s continuation of an unstable approach which resulted in abnormal runway contact during the landing flare and touchdown.Dec 2, 2022 · N979RF · Substantial damage NTSB GAA21WA165Accident · 2 fatalClass 5 · ForeignIai 1124 · Treasure Cay, BahamasJul 5, 2021 · N790JR · Destroyed NTSB CEN18WA155Incident · No injuriesForeign investigationDassault-Breguet Falcon 900 · Bremgarten, GermanyOn April 28, 2018, 2015, about 1505 universal time (UTC), a United States registered Dassault-Breguet Falcon-900, N670JD, was involved in an incident in Bremgarten, Germany. The pilot, copilot, and 2 passengers were not injured. The investigation is under the…Apr 28, 2018 · N670JD · No damage NTSB ERA16WA310Accident · No injuriesForeign investigationLearjet 55 · Eleuthera, BahamasOn August 25, 2016, about 1903 universal coordinated time, a Learjet 55, N666TK, operated by RCR7 LLC, was substantially damaged during a runway excursion following an aborted takeoff at North Eleuthera Airport, Eleuthera, Bahamas. The two pilots and seven…Aug 25, 2016 · N666TK · Substantial damage NTSB ERA16WA039Incident · No injuriesForeign investigationCessna 650 · Corlu, TürkiyeOn August 1, 2015, at 2317 coordinated universal time, a Cessna 650; N691BE, incurred minor damage after the main landing gear tires deflated during takeoff roll and a fire ensued in the area of the main landing gear at Tekirdag Çorlu Airport (LTBU), Corlu,…Aug 1, 2015 · N692BE · Minor damage NTSB ERA15RA047Accident · 9 fatalForeign investigationGates Learjet 35A · Freeport, BahamasNov 9, 2014 · N17UF · Destroyed NTSB ERA11WA518Accident · No injuriesForeign investigationGates Lear Jet 35 · Valencia, Carabobo, VenezuelaOn September 17, 2011, about 2135 universal coordinated time, a Gates Lear Jet 35, N535LC, was substantially damaged while landing at the Arturo Michelena Airport (SVVA), Valencia, Carabobo, Venezuela. The two pilots and five passengers were not injured. The…Sep 17, 2011 · N535LC · Substantial damage NTSB NYC08WA104Accident · 3 fatalClass 5 · ForeignCessna 650 · Caico Seco, VenezuelaOn February 18, 2008, about 1815 Venezuelan local time, a Cessna 650, N385EM, was destroyed when it impacted the savanna near Caico Seco, Anzoategui, Venezuela. The two pilots and one passenger, all Venezuelan citizens, were fatally injured. Visual…Feb 18, 2008 · N385EM · Destroyed NTSB DFW06WA169Accident · No injuriesForeign investigationRaytheon Corporate Jets DH 125-3A · Barcelona, VenezuelaJun 26, 2006 · N125GK · Destroyed NTSB NYC05WA114Incident · No injuriesForeign investigationIsrael Aircraft Industries 1124A · Shannon, IrelandJun 8, 2005 · N639AT · Minor damage NTSB CHI05WA061Accident · Serious injuriesForeign investigationHawker Siddely HS 125 600B · Quebec, CanadaFeb 21, 2005 · N21SA · Substantial damage NTSB MIA04LA103Accident · No injuriesLimited investigationFinal reportLearjet 35A · Newcastle, St. Kitts & NevisThe pilot's encounter with a downdraft.Jul 13, 2004 · N829CA · Substantial damage NTSB NYC04RA153Accident · 7 fatalForeign investigationIsrael Aircraft Industries 1124 · Tocumen, PanamaJul 2, 2004 · N280AT · Destroyed NTSB MIA95WA103Accident · No injuriesForeign investigationHawker Siddeley HS125 · Santo Domingo, Dominican RepublicApr 7, 1995 · N41953 · Substantial damage