NTSB investigations: Garrett TFE731 series, 2007
6 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.
Cases per year
| 1979 | 1 |
|---|---|
| 1980 | 1 |
| 1985 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 1999 | 5 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 3 |
| 2005 | 4 |
| 2006 | 3 |
| 2007 | 6 |
| 2008 | 4 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 3 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 2 |
| 2025 | 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 year(c.\"eventDate\") = 2007
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 year(c."eventDate") = 2007
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" 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 SEA08LA014Accident · No injuriesLimited investigationFinal reportRaytheon Corporate Jets Hawker 800XP · Santa Ana, CAThe failure of the pilot-in-command to follow procedures stipulated in the airplane flight manual regarding brake cooling time periods. Factors contributing to the accident were the intentional aborted takeoffs which resulted in the hot brakes, and the…NTSB NYC08FA022Accident · No injuriesField investigationFinal reportCessna 650 · Atlantic City, NJThe first officer's failure to maintain airspeed during approach, and the captain's inadequate remedial action. Contributing to the accident was the first officer's failure to comply with procedures, windshear, and the lack of windshear warning from air…NTSB DEN08LA013Accident · No injuriesLimited investigationFinal reportLearjet 35A · Goodland, KSThe pilot's failure to maintain aircraft control during the landing.NTSB OPS07IA010Incident · No injuriesIncident investigationFinal reportLearjet 35 · Washington, DCThe probable cause of this incident was the IAD tower local controller's failure to ensure that the runway was free of all known ground vehicles, equipment, and personnel before permitting a departing aircraft to start takeoff roll. Additionally, the…NTSB NYC07LA087Accident · No injuriesLimited investigationFinal reportGates Learjet 36A · Newport News, VAThe failure of the landing gear tires due to foreign object damage (FOD) on the runway. Contributing to the accident was the failure of the drag chute.NTSB CHI07CA058Accident · No injuriesData collectionFinal reportLearjet 35A · Columbus, OHThe pilot's failure to maintain aircraft control during an inflight maneuver which resulted in the design stress limits of the airplane being exceeded. A factor was the excessive airspeed encountered during recovery.