NTSB investigations, 2018
4 cases where the defining event was Uncontained engine failure.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 4 |
| 2012 | 4 |
| 2013 | 2 |
| 2015 | 5 |
| 2016 | 4 |
| 2017 | 6 |
| 2018 | 4 |
| 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\") = 2018
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '343')
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") = 2018 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '343') 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 ENG18IA036IncidentClass 3 · IncidentFinal reportBoeing 757 · Atlanta, GAA right engine turbine uncontainment resulting from failure of the high pressure turbine (HPT) lenticular seal due to a fatigue crack originating from an overheated region at a knife edge tip. Contributing to the failure was Pratt & Whitney’s decision to…NTSB ENG18WA039Incident · No injuriesForeign investigationMcdonnell Douglas MD80 · Songshan, Taipei, China, TaiwanOn July 2, 2018, Far Eastern Air Transport, flight FE8026, an MD82 aircraft, registration number B-28035, took off from Penghu Airport for Songsang Airport. The aircraft declared PAN PAN at 7 miles from the runway of Songshan Airport at an altitude of 2,800…NTSB CEN18LA127Accident · Minor injuriesLimited investigationFinal reportMX MXS · Fulton, TXA total loss of engine power due to the fatigue failure of the crankshaft, which resulted in the pilot’s forced landing to an abandoned airport and the airplane’s subsequent impact with debris on the runway.NTSB ENG18RA020Incident · No injuriesForeign investigationAvro RJ85 · Bishkek, KyrgyzstanOn March 1, 2018, a Tez Jet Airline Avro RJ85, powered by four Honeywell (formally Lycoming) LF507-1F turbofan engines experienced an uncontained No. 1 (left most) engine turbine failure during climb. The airplane returned to the Bishkek-Manas International…