NTSB investigations, 2017
6 cases where the sequence of events included Uncontained engine failure.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 4 |
| 2012 | 4 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 5 |
| 2016 | 4 |
| 2017 | 6 |
| 2018 | 5 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 4 |
| 2026 | 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 year(c.\"eventDate\") = 2017
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '343' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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") = 2017 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '343' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 WPR18LA051Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA 32-300 · Hinesville, GAA total loss of engine power due to the failure of a connecting rod.NTSB DCA18WA023Incident · No injuriesForeign investigationBoeing 737 · Guayaquil, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions…NTSB ENG18RA004Incident · No injuriesForeign investigationBritish Aerospace Avro 146 · Johannesburg, South AfricaOn November 8, 2017, at about 1750 UTC, South African Airlink flight 8103, a British Aerospace BAE-146 RJ85A, registered in South Africa as ZS-ASW, experienced an uncontained release of turbine material from the No. 2 engine, a Honeywell LF507-1F turbofan,…NTSB ENG17RA039Accident · No injuriesForeign investigationAirbus A380 · Goose Bay, CanadaOn September 30, 2017, an Air France A380 operating as flight AF 66 from Paris, France to Los Angeles, California had the No. 4 engine's inlet and fan rotor separate from the remainder of the engine. The airplane diverted to Goose Bay, Canada for landing. The…NTSB ENG17WA034Accident · No injuriesForeign investigationBoeing 747 · Delhi, IndiaThe India Aircraft Accident Investigation Bureau (AAIB) has notified the NTSB of an incident involving a Boeing 747-200 which occurred on August 26, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the…NTSB ENG17IA027Incident · No injuriesIncident investigationFinal reportBoeing 737 7H4 · Washington, DCThe failure the control alternator gearshaft, which disconnected the accessory gearbox from the rest of the engine and resulted in an uncommanded in-flight shutdown of the left engine and subsequent flight diversion. The control alternator gearshaft failed…