NTSB investigations, 2012, Outside the U.S.
8 cases where the sequence of events included Loss of engine power (total).
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 14 |
| 2010 | 8 |
| 2011 | 12 |
| 2012 | 8 |
| 2013 | 19 |
| 2014 | 16 |
| 2015 | 27 |
| 2016 | 31 |
| 2017 | 28 |
| 2018 | 26 |
| 2019 | 24 |
| 2020 | 20 |
| 2021 | 85 |
| 2022 | 49 |
| 2023 | 62 |
| 2024 | 59 |
| 2025 | 61 |
| 2026 | 24 |
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\" = '341' 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" = '341' 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 ERA13WA050Accident · Serious injuriesForeign investigationCessna 206 · Kiim, EcuadorOn October 31, 2012, about 1545 coordinated universal time (1045 local time), a Cessna 206, Ecuadorian registration HC-CBG, was substantially damaged during a forced landing in Kiim, Ecuador. The Ecuadorian commercial pilot was seriously injured. The airplane…NTSB ERA13WA085Accident · No injuriesForeign investigationThrush S2R-T34 · Naranjal, EcuadorOn October 2, 2012, a Thrush S2R-T34, Ecuadorian registration HC-CFU, operated by a private owner, was substantially damaged following an engine failure and collision with terrain near Naranjal Province, Guayas, Ecuador. The flight's last departure point and…NTSB CEN12WA640Accident · Serious injuriesForeign investigationPiaggio P149 · Hoogeveen, NetherlandsOn August 4, 2012, at 0945 coordinated universal time, a Piaggio P149D, Dutch registration D-EGIT, owned by a private individual and operated by the pilot, received substantial damage when it impacted terrain under unknown circumstances near Hoogeveen Airport…NTSB CEN12WA523Accident · No injuriesForeign investigationAir Tractor AT802 · San Rafael, SpainOn July 16, 2012, about 1430 coordinated universal time, a Spanish-registered Air Tractor AT-802 airplane, EC-HMD, performed a forced landing following a loss of engine power near San Rafael, Ibiza, Spain. The pilot, the sole occupant, was not injured. The…NTSB ERA12WA451Accident · 1 fatalForeign investigationEmbraer EMB820 · Espinosa Municipality, BrazilOn July 6, 2012, at 1340 Universal Coordinated Time (UTC), a Piper PA-31-350 (Embraer 820C), Brazilian registration PT-ENG, operated by Microsurvev Aerogeof. E Cons. Cient. Ltda, was destroyed during a forced landing following a loss of power to both engines.…NTSB ERA12WA504Accident · Minor injuriesForeign investigationPiper PA-28-235 · Tartu, EstoniaOn May 4, 2012, about 2055 universal coordinated time, a Piper PA-28-235, Latvian registration YL-MED, was substantially damaged when it impacted a ditch, during a forced landing at night after a loss of power near Tartu Ulenurme Airport (EETU), Tartu,…NTSB ERA12LA268Accident · No injuriesLimited investigationFinal reportHawker Beechcraft C90GTX · Caribbean Sea, A1A complete loss of engine power due to fuel exhaustion as a result of the pilot's failure to verify that sufficient fuel was onboard prior to flight. Contributing to the accident was the pilot's misreading of the fuel ticket and his improper operation of the…NTSB ERA12WA142Accident · No injuriesForeign investigationCirrus Design SR22 · Andros Island, BahamasOn January 7, 2012, about 1324 eastern standard time, a Cirrus Design Corp. SR22, N723EA, registered to and operated by M&W Aviation LLC, descended into water near Andros Island, Bahamas, following deployment of the Cirrus Airframe Parachute System (CAPS).…