NTSB investigations: Garrett TFE731 series, FL
9 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
| 1994 | 1 |
|---|---|
| 2000 | 1 |
| 2006 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2019 | 2 |
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.\"eventStateOrRegion\" = 'FL' 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 ('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."eventStateOrRegion" = 'FL' 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 ('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 ERA20LA008Accident · No injuriesClass 3 · LimitedFinal reportRaytheon Hawker · Fort Myers, FLMaintenance personnel's improper installation of the nose landing gear assembly, which resulted in separation of the actuator arm and the failure of a nose landing gear to lock in place.NTSB ERA19TA133Accident · No injuriesClass 3Final reportCessna 650 · Sanford, FLThe pilot's failure to keep the airplane on the taxiway while taxiing at night. Contributing to the accident was a miscommunication between the flight crewmembers about the position of the airplane.NTSB ERA19LA073Accident · No injuriesClass 3 · LimitedFinal reportLearjet 35 · Key West, FLThe flight crew’s encounter with windshear during the landing flare, which resulted in a hard landing.NTSB ERA15IA198Incident · No injuriesClass 2 · IncidentFinal reportDassault-Breguet Mystere Falcon 900 · Orlando, FLUnknown maintenance personnel’s inadequate securing of a wiring bundle during a maintenance, repair, or modification event, which led to chafing of the wiring bundle, an electrical short and arcing, and a subsequent in-flight fire.NTSB ERA14LA111Accident · Serious injuriesLimited investigationFinal reportGates Learjet 35A · Ft. Lauderdale, FLThe pilot’s failure to ensure that the ground power unit was disconnected from the airplane via hand signals from the lineman providing ground services before taxiing, which resulted in an injury to the lineman.NTSB ERA12FA127Accident · No injuriesField investigationFinal reportCessna 650 · Ft. Lauderdale, FLThe crew's failure to use proper emergency procedures during an uncommanded right roll after takeoff, which led to a forced landing with a quartering tailwind. Contributing to the accident was a faulty right roll spoiler actuator, which allowed the right roll…NTSB MIA07FA005Accident · No injuriesField investigationFinal reportBritish Aerospace HS 125-700A · Fort Lauderdale, FLThe failure of the flight crew to extend the landing gear. Contributing to the accident was the inoperative audible landing gear warning system.NTSB MIA00FA129Accident · 3 fatalField investigationFinal reportLearjet 35A · Marianna, FLthe pilot's failure to maintain control of the airplane while on final approach resulting in the airplane striking trees. Factors in this accident were: improper planning of the approach, and not obtaining the proper alignment with the runway.NTSB MIA94IA059Incident · No injuriesIncident investigationFinal reportLearjet LR-35A · Key Largo, FLThe failure of the pilot-in-command to maintain the proper glidepath.