NTSB investigations, 2018, 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\") = 2018
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") = 2018 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 CEN19WA080Accident · No injuriesForeign investigationCirrus SR22 · Toussus-Le-Noble, FranceThe government of France has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on December 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…NTSB ENG19WA005Incident · No injuriesForeign investigationBoeing 767 · Addis Ababa, EthiopiaOn November 26, 2018, a Boeing 767-300 airplane, operated by Ethiopian Airlines, experienced a right engine (No. 2) fan blade failure during takeoff from the Addis Ababa Bole International Airport (ADD), Ethiopia. The airplane returned to ADD where an…NTSB ERA19WA046Accident · Serious injuriesForeign investigationGarlick UH1D · Valparaiso, ChileThe government of Chile has notified the NTSB of an accident involving a GARLICK UH1D helicopter that occurred on October 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions…NTSB CEN19WA012Accident · 2 fatalForeign investigationCessna 150M · La Paz, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 150M airplane that occurred on October 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB ERA18WA248Accident · No injuriesForeign investigationBell 206 · Bartica, GuyanaThe government of Guyana has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on September 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guyana's investigation under the provisions…NTSB CEN18WA327Accident · No injuriesForeign investigationColumbia LC41-550FG · Vallecillos, MexicoOn July 4, 2018, about 1910 UTC, a Mexican registered Columbia LC41-550FG airplane, XB-OHG, sustained substantial damage during a forced landing due to a loss of engine power near Vallecillos, Nuevo Leon, Mexico. The pilot was not injured. The flight…NTSB DCA18WA174Incident · No injuriesForeign investigationBoeing 737 · Arequipa, PeruThe government of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on May 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of ICAO…NTSB ENG18WA011Incident · No injuriesForeign investigationAirbus A330 · Alice Springs, AustraliaOn January 18, 2018, about 14:25 Western Australian standard time, a Malaysian-registered Airbus A330-323 airplane had the No. 1 engine, a Pratt & Whitney PW4168A engine shutdown by the flight crew after it had compressor stalls. The airplane, which was…NTSB WPR18WA159Accident · Serious injuriesForeign investigationRobinson R44 · Ayers Rock, AustraliaOn January 17, 2018, at 1800 local time, a Robinson R44 helicopter, VH-HGX, experienced a partial loss of engine power shortly after takeoff. The pilot subsequently initiated an autorotation, landed hard and rolled over near Ayres Rock, Australia. The pilot…