NTSB investigations, 2014, Outside the U.S.
8 cases where the sequence of events included Loss of engine power (partial).
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 1 |
| 2010 | 4 |
| 2011 | 2 |
| 2012 | 6 |
| 2013 | 4 |
| 2014 | 8 |
| 2015 | 7 |
| 2016 | 6 |
| 2017 | 9 |
| 2018 | 9 |
| 2019 | 20 |
| 2020 | 4 |
| 2021 | 28 |
| 2022 | 17 |
| 2023 | 27 |
| 2024 | 31 |
| 2025 | 33 |
| 2026 | 8 |
Latest 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\") = 2014
AND c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '342' 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") = 2014 AND c."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '342' 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 ENG15WA008Incident · No injuriesForeign investigationAirbus A319 - 132 · Zurich, SwitzerlandOn October 17, 2014, an Air Serbia Airbus 319-132, registration umber YU-APA, powered by two IAE V2524-A5 turbofan engines experienced a right engine oil leak shortly after departure. The flight crew performed an inflight shutdown of the engine and an air…NTSB ENG14IA029Incident · No injuriesIncident investigationFinal reportBombardier CRJ700 · Hodeida, YemenThe probable cause of the undercowl engine fire was the burn-through of the combustion chamber inner liner from the accumulation of dust that became molten during operating and infiltrated the combustion chamber thermal barrier coating causing it to spall off…NTSB CEN14WA491Accident · 2 fatalForeign investigationRobinson Helicopter R44 · Roeselare, BelgiumNTSB ENG14WA030Incident · No injuriesForeign investigationBoeing 737 - 6H3 · Budapest, HungaryOn June 10, 2014, about 1830 local (1630 UTC), a TunisAir Boeing 737-6H3, TS-IOK, operating as flight TU-4671, experienced a malfunction of the No. 1 (left) engine during the takeoff roll at Budapest, Hungary. The pilots rejected the takeoff. A borescope…NTSB ANC14RA051Accident · Minor injuriesForeign investigationExtra 300 - L · Fukushima City, JapanOn May 12, 2014, at 0115 coordinated universal time, a Japanese registered Extra 300L airplane, JA111L, operated by a private individual, experienced a loss of engine power followed by a forced landing near Fukushima City, Japan. The pilot and one passenger…NTSB ENG14WA012Incident · No injuriesForeign investigationAirbus A330 - 223 · Melbourne, Australia, AustraliaOn May 6, 2014, at 10:52 am local time, an Airbus A330-223 performed a rejected takeoff at the Melbourne Aerodrome, Melbourne, Victoria Australia, due to the failure of the No. 2 engine (right), a Pratt & Whitney PW4168 turbofan. No injuries were reported.…NTSB ENG14RA014Incident · No injuriesForeign investigationBAE AVRO146RJ - 100 · Perth, Australia, AustraliaOn April 29, 2014, a British Aerospace BAE AVRO 146-RJ100, registration VH-NJI, experienced a No. 2 engine (left inboard) fire from the Honeywell LF507-1F turbofan engine during climb from Perth, Australia. The airplane was returned to Perth where an…NTSB ERA14WA116Accident · Serious injuriesForeign investigationHelio HT-295 · Macas, EcuadorOn January 15, 2014, about 2030 coordinated universal time (1530 local time), a Helio Courier HT-295, Ecuadorian registration HC-BTC, was substantially damaged during a forced landing after takeoff from Edmundo Carvajal Airport (SEMC), Macas, Ecuador. The…