NTSB investigations, Outside the U.S.
11 cases where the sequence of events included Roll over.
Cases per year
| 2011 | 1 |
|---|---|
| 2015 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2021 | 2 |
| 2024 | 1 |
| 2025 | 2 |
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\" = '097' 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" = '097' 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 GAA26WA016Accident · 1 fatalClass 5 · ForeignRobinson R44 · Bentley, United KingdomNTSB ENG25WA033Accident · Serious injuriesClass 5 · ForeignBell 505 · Petersgrat Mountain, SwitzerlandNTSB GAA25WA019Accident · No injuriesClass 5 · ForeignViking Air DHC-2 MK 1 · Whitehaven, AustraliaNTSB GAA21WA098Accident · No injuriesClass 5 · ForeignRobinson R44 · Región de Ñuble, ChileNTSB GAA21WA069Accident · No injuriesClass 5 · ForeignRotorway Exec · Ledbury, Herefordshire, United KingdomNTSB ANC20CA014Accident · No injuriesData collectionFinal reportCessna 172 · Tokyo, JapanThe airplane’s encounter with prop wash while taxiing behind a larger airplane that was conducting a high-power engine run on the same taxiway. Contributing to the accident was the air traffic controller’s failure to inform the smaller airplane’s pilot about…NTSB CEN18WA372Accident · No injuriesForeign investigationRobinson R22 · Naunton Beauchamp, Worcestershire, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a ROBINSON R22 helicopter that occurred on August 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation…NTSB WPR18CA100Accident · Minor injuriesData collectionFinal reportHughes 369D · Pacific Ocean, Marshall IslandsAn in-flight mechanical malfunction with the helicopter, which necessitated a ditching in the ocean. The reason for the malfunction could be determined because the helicopter sank and was not recovered.NTSB WPR18WA038Accident · No injuriesForeign investigationBell Helicopter 206B · Emerald Aerodrome, AustraliaOn November 18, 2017, about 1430 local time, a Bell 206B helicopter, registration VH-SDZ, rolled over following a precautionary landing near Emerald Aerodrome, Middlemount, Queensland, Australia. The helicopter, which was equipped with a Rolls-Royce 250…NTSB GAA16CA071Accident · No injuriesData collectionFinal reportBell 206 · Christmas Island, KiribatiThe pilot's inadequate preflight inspection and the maintenance crew's failure to remove the tie down.NTSB ERA11WA122Accident · No injuriesForeign investigationBell 212 · Cuzco, PeruOn January 17, 2011, at 1940 universal coordinated time, a Bell 212 helicopter, Peruvian registration OB-1767-P, registered to Helicopters Service, and operated by Heliamerica S.A.C., experienced an un-commanded roll over during takeoff from a remote helipad…