NTSB investigations, 2016, Outside the U.S.
10 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\") = 2016
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") = 2016 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 ENG17WA025Incident · No injuriesForeign investigationBombardier BD700 1A11 · Hong Kong, Hong Kong SAR ChinaThe United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident involving a Bombardier Global Express BD700, which occurred on November 15, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB…NTSB WPR16WA192Accident · 3 fatalForeign investigationCessna 182 · Mpumalanga Province, South AfricaOn August 27, 2016, about 1025 coordinated universal time, a Cessna 182Q, South African registration ZS-PHB, was destroyed when it impacted terrain shortly after takeoff from Komati Gorge Lodge private airstrip, Mpumalanga Province, South Africa. The pilot…NTSB CEN16WA403Accident · No injuriesForeign investigationRobin DR400/180R · Schaffhausen, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a ROBIN DR400/180R airplane that occurred on August 26, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under…NTSB WPR16WA143Accident · 1 fatalForeign investigationCessna 150 · New Crown Station, AustraliaOn July 12, 2016 about 1130 local time, a Cessna 150G airplane, Australian registration VH-RXU, collided with terrain near New Crown Station, South Australia. The airplane sustained substantial damage and the pilot was fatally injured. The airplane was…NTSB ENG16WA035Incident · No injuriesForeign investigationBoeing 737 · Mexico City, MexicoThe DIRECCIÓN GENERAL DE AERONAUTICA CIVIL (DGCA) of Mexico has notified the NTSB of an incident involving a Magnicharter Boeing 737, which occurred on July 12, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the DGCA investigation…NTSB DCA16WA189Incident · No injuriesForeign investigationBoeing 737 · Launceston, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Boeing 737 that occurred on June 17, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the provisions of ICAO…NTSB CEN16WA140Accident · 2 fatalForeign investigationCessna Skyhawk II 172N · Vulcan de Fuego, Guatemala, GuatemalaOn March 27, 2016, about 2242 universal coordinated time (UTC), a Guatemalan-registered Cessna 172N, TG-KAM, impacted terrain near the Vulcan de Fuego while en route from Tiquisate, Escuintla, to the La Aurora International Airport (MGGT), Guatemala City,…NTSB DCA16WA110Incident · No injuriesForeign investigationEmbraer ERJ 190 100 IGW · Nassau, BahamasThe Bahamas Department of Civil Aviation's Air Accident Investigation & Prevention Unit (AAIPU) has notified the NTSB of an incident involving an Embraer EMB 190 that occurred on March 25, 2016. The NTSB has appointed a U.S. Accredited Representative to…NTSB CEN16WA124Incident · No injuriesForeign investigationCessna 525 · Lugano, SwitzerlandNTSB ERA16WA101Accident · Serious injuriesForeign investigationRobinson R66 · Aviatornyi, RussiaOn February 2, 2016, about 0730 Coordinated Universal Time (UTC), a Robinson R66, RA-06239, registered to Southeast Agricultural Group, LLC, collided with terrain near Aviatornyi Township, Kirsanov District, Tambov Region, Russia. Visual meteorological…