NTSB investigations: Garrett TFE731 series
8 cases on aircraft whose registry engine model is Garrett TFE731 series, where the first occurrence was “Loss of control - in flight”. 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.
Cases per year
| 1999 | 1 |
|---|---|
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('29001')
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\" = 250))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('29001')
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" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 DEN08LA013Accident · No injuriesLimited investigationFinal reportLearjet 35A · Goodland, KSThe pilot's failure to maintain aircraft control during the landing.NTSB LAX07TA051Accident · No injuriesFinal reportLearjet 36 · San Diego, CAThe pilot's failure to maintain aircraft control while maneuvering, which resulted in exceeding the design stress limits of the aircraft. Contributing to the accident was the sunglare.NTSB LAX06FA071Accident · 2 fatalField investigationFinal reportLearjet 35A · Truckee, CAThe pilot's inadequate compensation for the gusty crosswind condition and failure to maintain an adequate airspeed while maneuvering in a steep turn close to the ground.NTSB NYC04LA088Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Utica, NYThe copilot's failure to maintain airspeed, and the captain's delayed remedial action, which resulted in an inadvertent stall and the subsequent hard landing.NTSB DEN03FA155Accident · 3 fatalField investigationFinal reportHawker Siddeley HS-125-700A · Beaumont, TXthe first pilot's failure to maintain aircraft control and adequate airspeed. Contributing factors included performing intentional stalls at too low an altitude to afford a safe recovery, the pilot's failure to add power in an attempt to recover, and the…NTSB NYC03FA173Accident · 2 fatalField investigationFinal reportLearjet 35A · Groton, CTThe first officer's inadvertent retraction of the flaps during the low altitude maneuvering, which resulted in the inadvertent stall and subsequent in-flight collision with a residential home. Factors in the accident were the captain's decision to perform a…NTSB FTW03FA036Accident · 2 fatalField investigationFinal reportIsrael Aircraft Industries 1124A · Taos, NMThe pilot's inadvertent flight into mountain wave weather conditions while IMC, resulting in a loss of aircraft control.NTSB CHI99LA078Accident · No injuriesLimited investigationFinal reportGates Learjet 35 · Chicago, ILthe second pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall mush.