NTSB investigations, 2019, 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\") = 2019
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") = 2019 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 WPR20WA021Accident · 1 fatalForeign investigationRobinson R44 · Tunis, TunisiaThe government of Tunisia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on November 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Tunisia's investigation under the…NTSB WPR20WA137Accident · No injuriesForeign investigationRobinson R44 · Pretoria, South AfricaThe government of South African Civil Aviation Authority has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on October 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South…NTSB WPR19WA210Accident · 1 fatalForeign investigationLiberty Aerospace XL-2 · Braidwood, AustraliaOn August 6, 2019, at 0138 coordinated universal time, a Liberty Aerospace XL-2, registration VH-XLK, collided with terrain during a landing attempt near Braidwood, New South Wales, Australia. The pilot and sole occupant was fatally injured, and the airplane…NTSB WPR19WA206Accident · 1 fatalForeign investigationBell 47G · Limpopo Province, South AfricaOn July 30, 2019, about 0900 coordinated universal time, a Bell 47G-3B-1 helicopter, ZS-HGY, impacted terrain following a total loss of engine power near Alldays, Limpopo Province, South Africa. The pilot was fatally injured, and the passenger was seriously…NTSB CEN19WA291Accident · No injuriesForeign investigationSikorsky S76 · Vigo, SpainOn July 26, 2019, about 2130 coordinated universal time, a Sikorsky S76 C+, EC-JES, impacted terrain at the Vigo Airport (LEVX), Vigo, Spain. The accident investigation is under the jurisdiction and control of the government of Spain. This report is for…NTSB ERA19FA210Accident · 7 fatalClass 2 · FieldFinal reportAgusta AW139 · Big Grand Cay, BahamasThe pilots’ decision to takeoff over water in dark night conditions with no external visual reference, which resulted in spatial disorientation and subsequent collision with the water. Also causal was the pilots’ failure to adequately monitor their…NTSB CEN19WA288Accident · 2 fatalForeign investigationZenair CH601 · Pont-A-Celles, BelgiumThe government of Belgium has notified the National Transportation Safety Board (NTSB) of an accident involving a Zenair CH 601XL airplane that occurred on June 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB WPR19WA151Accident · 1 fatalClass 5 · ForeignRobinson R44 II · Tai Po, ChinaNTSB ENG19WA023Incident · No injuriesForeign investigationBoeing 767 · Johannesburg, South AfricaThe Government of South Africa has notified the NTSB of an incident involving an Air Zimbabwe Boeing 767-2NOER with Pratt & Whitney PW4056 engines on April 28, 2019. The NTSB has appointed an Accredited Representative in accordance with the provisions of ICAO…NTSB CEN19WA096Accident · 2 fatalForeign investigationNorth American T28 · Escuintla, Guatemala