NTSB investigations, 2013, Outside the U.S.
12 cases where the sequence of events included Miscellaneous/other.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 6 |
| 2011 | 2 |
| 2012 | 11 |
| 2013 | 12 |
| 2014 | 5 |
| 2015 | 12 |
| 2016 | 10 |
| 2017 | 7 |
| 2018 | 11 |
| 2019 | 10 |
| 2020 | 6 |
| 2021 | 10 |
| 2022 | 18 |
| 2023 | 20 |
| 2024 | 19 |
| 2025 | 32 |
| 2026 | 4 |
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\" = '900' 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" = '900' 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 WPR14WA085Accident · 1 fatalForeign investigationBell 206 · Berastagi, IndonesiaOn December 30, 2013, at about 1030 local time, a Bell 206 helicopter, registration PK-DAL, crashed shortly after takeoff from a hospital near Berastagi, North Sumatera, Indonesia. Reports indicate that there was one fatality and two serious injuries…NTSB DCA14WA024Incident · No injuriesForeign investigationBoeing 767 · Arusha, TanzaniaNTSB DCA14WA019Accident · No injuriesForeign investigationBoeing 767 - 300ER · Madrid, SpainNTSB DCA14WA015Incident · No injuriesForeign investigationBoeing 737-400 · Zurich, SwitzerlandThe Swiss Accident Investigation Board (SAIB) has notified the NTSB of an incident involving a Boeing 737-400 that occurred on November 10, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the SAIB investigation under the provisions of…NTSB ENG13WA043Incident · No injuriesClass 5 · ForeignBoeing 737 - 53C · Cusco, PeruOn September 26, 2013, about 2042 EST, a BOEING 737 - 53C airplane, OB-2041-P, experienced an in-flight engine shutdown near Cusco, Peru. The pilot was not injured. The airplane was not damaged. The investigation is under the jurisdiction of the government of…NTSB DCA13WA159Incident · No injuriesForeign investigationBoeing 787 - 8QQ · Warsaw, PolandOn September 18, 2013, a LOT Polish Airlines, Boeing 787-8, registration number SP-LRB, powered by two Rolls-Royce Trent 100-67B turbofan engines experienced a maintenance status message “ENG FUEL FULTER R” during cruise from Beijing Capital International…NTSB DCA13WA144Incident · No injuriesForeign investigationAirbus Industrie A300B4-622R · Luton, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving an Airbus A300 operated by Federal Express Corp, which occurred on August 25, 2013. The NTSB has appointed a U.S. Accredited Representative to…NTSB CEN13WA492Accident · 1 fatalForeign investigationAerostar International S-55A · Mont-St-Grégoire, CanadaOn August 11, 2013, at 0730 eastern daylight time, an Aerostar International Inc. model S-55A, United States registration N25QL, serial number S55A1-1017, was not damaged when a member of the balloon ground-support team was fatally injured after falling to…NTSB ERA13WA306Accident · 1 fatalForeign investigationPiper PA34 · Envira, BrazilOn June 7, 2013, at 1400 coordinated universal time (UTC), a Piper PA-34-200T, Brazilian registration PT-MMX, was substantially damaged during a ditching into the Tarauacá River following an unspecified malfunction of the airplane’s right engine after…NTSB ERA13WA226Accident · 2 fatalForeign investigationCessna 210L · Belem, BrazilOn April 26, 2013, about 1215 universal coordinated time, a Cessna 210L, Brazilian registration PR-LJI, operated by Brabo Taxi Aereo Ltda., was substantially damaged during a forced landing while on approach to the Brigadeiro Protasio de Oliveira Airport…NTSB DCA13WA089Accident · 1 fatalForeign investigationBeech 1900 · Unkown, São Tomé & PríncipeThe Sao Tome and Principe Civil Aviation Authority (STPCAA) has notified the NTSB of an accident involving a Beech 1900 that occurred on April 07, 2013. The NTSB has appointed a U.S. Accredited Representative to assist STPCAA investigation under the…NTSB ERA13WA282Accident · 2 fatalForeign investigationRobinson R66 · Caraguatatuba, BrazilOn January 3, 2013, about 1600 coordinated universal time (UTC), a Robinson R-66 Helicopter, Brazilian registration PR-DUB, was destroyed when it impacted a dense forest and the side of a hill in the Caraguatatuba Municipality, in the State of São Paulo,…