NTSB investigations, Outside the U.S.
21 cases where the sequence of events included VFR encounter with IMC.
Cases per year
| 2010 | 1 |
|---|---|
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 3 |
| 2018 | 1 |
| 2019 | 2 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 3 |
| 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 c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '401' 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 c."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '401' 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 GAA25WA066Occurrence · No injuriesClass 5 · ForeignPiper 28 · Banktown, AustraliaNTSB GAA25WA036Accident · Serious injuriesClass 5 · ForeignCessna 340A · Magny-lès-Villers, FranceNTSB GAA25WA007Accident · 2 fatalClass 5 · ForeignCirrus Design SR22 · La Bretonnière la Claye, FranceNTSB GAA24WA321Accident · No injuriesClass 5 · ForeignCessna TR-182 · Trieben, AustriaNTSB GAA24WA043Accident · 4 fatalClass 5 · ForeignRockwell 112 · Kasberg, Grünau im Almtal, AustriaNTSB GAA23WA177Accident · 2 fatalClass 5 · ForeignSocata Rallye 180 · Arkösund, Norrköping, SwedenNTSB GAA22WA265Accident · 2 fatalClass 3 · ForeignRobinson R66 · Zapallar, ChileNTSB GAA22WA054Accident · 1 fatalClass 5 · ForeignCirrus Design SR22 · Auxerre, FranceNTSB GAA22WA082Accident · 1 fatalClass 5 · ForeignCubcrafters CC11-160 · Monterrey, MexicoNTSB CEN20WA011Accident · 2 fatalForeign investigationCessna 172 · San Salvador, El SalvadorNTSB WPR20WA003Accident · 2 fatalForeign investigationCessna 172 · Sultanpur, IndiaOn October 6, 2019, about 0750 coordinated universal time, a Cessna 172, VT-RGF, impacted terrain near Sultanpur, India after requesting to turn back due to bad weather. The student pilot and passenger were fatally injured, and the airplane was destroyed. The…NTSB CEN18WA390Accident · 1 fatalForeign investigationRobinson R44 · Buttonville, CanadaOn September 25, 2018, about 1800 hours universal coordinated time, a Robinson R44 II helicopter, Canadian registration C-GMCT, impacted terrain while diverting due to deteriorating weather conditions near the Toronto/Buttonville Municipal Airport (CYKZ),…NTSB ERA16WA163Accident · 3 fatalForeign investigationRobinson R66 · Bely Island, RussiaNTSB ERA16WA138Accident · 3 fatalForeign investigationBell 206B III · Angostura, ColombiaOn March 23, 2016, about 1211 universal coordinated time, a Bell 206B III, Colombian registration HK4764, was destroyed when it impacted mountainous terrain and was consumed by a postcrash fire. Three of the four occupants were fatally injured, and one…NTSB ERA16WA081Accident · Serious injuriesForeign investigationBell 429 · Rostov-na-Dony, RussiaSubject: ERA16WA081 Bell 429, RA-01617, Rostov-na-Dony, Russia On January 1, 2016, about 0621 universal coordinated time, a Bell 429, Russian registration RA-01617, was substantially damaged by collision with terrain during an uncontrolled descent following a…NTSB ERA16WA069Accident · 4 fatalForeign investigationHawker Beech A36TC · Suvorovskaya, RussiaOn December 13, 2015, about 0826 Universal Time Coordinated (UTC), a Beech A36TC, Russian registration RA-2587G, registered to and operated by a private individual, experienced an in-flight loss of control and collided with terrain near Suvorovskaya Village,…NTSB ERA14WA026Accident · 2 fatalForeign investigationLuscombe 8 - E · Buenos Aires, ArgentinaOn October 14, 2013, about 1134 coordinated universal time, a Luscombe 8E, Argentina registration LV-RTS, was substantially damaged, during descent in thick fog, when it impacted terrain in an industrial park. The flight had departed Zarate Airport (SATE),…NTSB ERA13WA089Accident · 4 fatalForeign investigationPiper PA34 · Zulia, ColombiaOn December 12, 2012, about 1530 universal coordinated time (1030 local time), a Piper PA-34-200T, Colombian registration HK4477G, was destroyed when it impacted rising mountainous terrain in the vicinity of La Cuchilla, near Zulia, Norte de Santander,…NTSB ERA11WA439Accident · 1 fatalForeign investigationRobinson R-44 · Istok, RussiaOn July 9, 2011, at 1900 universal coordinated time, a Robinson R-44, Russian registration RA-04304, registered to and operated by a private owner, collided with the Yenisei River, near Istok, Krasnoyarsk Region, Russia, during a repositioning flight at…NTSB ERA11WA159Accident · 1 fatalForeign investigationRobinson R44 · Canne della Battaglia, ItalyOn February 18, 2011, about 0706 universal coordinated time, a Robinson R44, French registration F-GUJB, crashed after an in-flight separation of the tail rotor from the fuselage. The pilot was killed. The flight departed Bari, Italy, for Foggia Airport…NTSB ERA10LA511Accident · 2 fatalLimited investigationFinal reportBallonbau Worner NL-1000/STU · Adriatic Sea, A1The crew's intentional flight into known adverse weather conditions, which resulted in destruction of the balloon envelope by lightning strike and the subsequent uncontrolled descent to the sea.