NTSB investigations, 2013, Outside the U.S.
4 cases where the sequence of events included Engine shutdown.
Cases per year
| 2008 | 3 |
|---|---|
| 2012 | 2 |
| 2013 | 4 |
| 2014 | 4 |
| 2015 | 1 |
| 2019 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2025 | 1 |
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\") = 2013
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\" = '140' 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") = 2013 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" = '140' 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 ENG14RA004Incident · No injuriesForeign investigationSaab Saab 2000 · Lugano, SwitzerlandOn November 28, 2013, about 630 UTC, a SAAB 2000 airplane, HB-IZW, experienced an engine failure during climb out after takeoff in Switzerland. The location was not reported. The 2 pilots, 1 crew member and 25 passengers were not injured. Damage to the…NTSB ENG13WA039Incident · No injuriesForeign investigationBoeing 777 - 340ER · Moscow, RussiaThe Civil Aviation Authority Safety Investigation Board of Pakistan (CAAP) has notified the NTSB of an incident involving a Pakistan International Airlines Corporation (PIAC) Boeing 777-340ER, registration number AP-BHV, powered by General Electric CF90-115BL…NTSB ENG13IA033Incident · No injuriesIncident investigationFinal reportBoeing 777 · Ugolny Airport, RussiaThe failure of the transfer gearbox resulting from the fracture and separation of the radial gearshaft from fatigue cracking as a result of a combination of high residual tensile stresses produced by local decarburization during the manufacturing process…NTSB ENG13WA014Incident · No injuriesForeign investigationMcdonnell Douglas MD-82 · Copenhagen, Denmark, DenmarkOn January 30, 2013 an MD-82, registration number SE-DIK, sustained a serious engine failure during the takeoff roll. The engine has been removed from the airplane and will undergo a teardown examination. The Danish Accident Investigation Board is…