NTSB investigations, 2012, Outside the U.S.
6 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\") = 2012
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") = 2012 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 ERA13WA108Incident · No injuriesForeign investigationSikorsky S61 · Carauari, BrazilOn October 10, 2012, at 1630 Coordinated Universal Time (UTC), a Sikorsky S-61, Brazilian registration PR-HRU, experienced a loss of power in the number one engine and performed a single-engine landing to Carauari Airport, Carauari Municipality, Brazil. The…NTSB DCA13WA174Incident · No injuriesForeign investigationCessna 210 - N · Outjo, NamibiaOn October 6, 2012 about 1400 UTC, V5-YUL, Cessna 210N, had a partial loss of engine power followed by a precautionary landing near Outjo, Namibia. Visual meteorological conditions existed at the time. None of the 4 occupans were injured. The airplane was not…NTSB DCA12WA160Incident · No injuriesForeign investigationBAE BAE146 - 199 · Gaborone, BotswanaOn August 11, 2012 about 1136 UTC, A2-ABF, British Aerospace BAe 146-199, a scheduled commerical flight, operated by Air Botswana, after a loss of power in the no. 2 engine, aborted takeoff at Sir Seretse Khama International Airport, Gaborone, Botswana. There…NTSB CEN12WA681Accident · No injuriesForeign investigationMcdonnell Douglas 500 · Kastire, LatviaOn July 12, 2012, about 0945 local time, a McDonnell Douglas MD-500 helicopter, registration OH-HJR, sustained substantial damage when it impacted terrain near Kastire, Latvia. The pilot was not injured. This investigation is under the jurisdiction of the…NTSB DCA12WA063Incident · No injuriesForeign investigationMcdonnell Douglas MD80 - 80 · Copenhagen, DenmarkThe Danish Accident Investigation Board (AIB) has notified the NTSB of an incident involving a McDonnell Douglas MD-82 that occurred on February 5, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AIB investigation under the…NTSB CEN13WA102Incident · No injuriesForeign investigationRobinson Helicopter R44 · Oosterschelde, NetherlandsOn January 21, 2012, at 1430 universal coordinated time, a Robinson Helicopter Company model R44, Dutch registration PH-WMW, made an uneventful forced landing after experiencing a partial loss of engine power near Oosterschelde, The Netherlands. The pilot and…