NTSB investigations, 2017, Outside the U.S.
9 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\") = 2017
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") = 2017 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 ERA18WA061Accident · 1 fatalForeign investigationCessna A188 · Dom Pedrito, BrazilThe government of Brazil has notified the NTSB of an accident involving a CESSNA A188 airplane that occurred on December 30, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB WPR18WA061Accident · Minor injuriesForeign investigationEnstrom 480 · Bacoor, PhilippinesOn December 2, 2017, at 0900 universal time coordinated, a Enstrom Helicopter Corporation 480B, RP-C8955, was substantially damaged during a precautionary landing near Bacoor, Cavite, Philippines. The pilot was not injured, and the passenger sustained minor…NTSB CEN17WA343Accident · 2 fatalForeign investigationPiper Piper PA-28RT-201 · Wolferton, United KingdomOn September 11, 2017, at 0956 universal coordinated time (UTC), a Piper PA-28RT-201 single-engine airplane, United Kingdom registration G-BHAY, serial number 28R-7918213, was substantially damaged during a forced landing following a loss of engine power and…NTSB CEN17WA221Accident · Serious injuriesForeign investigationSilence Twister · Abingdon, United KingdomOn May 14, 2017, at 1330 universal coordinated time (UTC), a Silence model Twister single-engine airplane, United Kingdom registration G-JINX, serial number LAA 329-15102, was substantially damaged during a forced landing following a loss of engine power…NTSB CEN17WA256Accident · No injuriesForeign investigationLancair IV · Grenaa, DenmarkOn May 12, 2017, about 0635 coordinated universal time, a Lancair IV P airplane, Swiss registration SE-XRU, was substantially damaged when it impacted terrain near Grenaa, Denmark. The airplane was registered to and operated by a private individual as a…NTSB ENG17WA020Incident · No injuriesForeign investigationBAE JETSTREAM3100 · Monteria, ColombiaOn April 15, 2017, a Colombian-registered BAE Jetstream J32, HK4820, operated by Aerolinea de Antioquia ADA experienced a loss of power from the No. 2 engine, a Honeywell TPE331 turbopropeller. The engine was shutdown in flight and the airplane diverted to…NTSB ERA17WA132Accident · Serious injuriesForeign investigationBell 206 · Araucária Municipality, BrazilThe government of Brazil has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on March 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB ENG17WA015Incident · No injuriesForeign investigationAirbus A320 · Sao Paulo, BrazilOn February 23, 2017, during takeoff from São Paulo airport, the right hand engine of a Brazilian registered Airbus 320, registration number PT–MZY, lost power, causing a rejected takeoff and a temporary excursion from the runway. The Brazilian Centro de…NTSB CEN17WA380Incident · No injuriesForeign investigationSchweizer 269C · Locarno, SwitzerlandOn February 7, 2017, about 1016 universal coordinated time (UTC), a Schweizer 269C helicopter, Swiss registration HB-XFQ, conducted a precautionary landing near Locarno (LSZL), Switzerland, after the engine oil pressure was at minimum pressure and the oil…