NTSB investigations, Outside the U.S.
7 cases where the sequence of events included Loss of tail rotor effectiveness.
Cases per year
| 2011 | 2 |
|---|---|
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2021 | 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\" = '242' 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" = '242' 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 GAA21WA247Accident · No injuriesClass 4 · ForeignEnstrom 280FX · Llanfachreth, United KingdomNTSB WPR20WA081Accident · Minor injuriesForeign investigationOas UH-1H · Williamtown Aerodrome, AustraliaThe government of Australia has notified the NTSB of an accident involving a OAS UH-1H helicopter that occurred on December 07, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB CEN17WA069Incident · No injuriesForeign investigationSikorsky S92 · North Sea, UK, United KingdomOn December 28, 2016, G-WNSR, a Sikorsky S-92A helicopter had a heavy landing on the deck of an offshore platform in the North Sea. The 11 persons on-board were not injured. This accident/incident investigation is under the jurisdiction and control of the…NTSB CEN15WA435Accident · No injuriesForeign investigationBell 206B · Sept-Iles, CanadaOn September 2, 2015, about 1345 Universal Coordinated Time (UTC), a Bell 206B, Canada Registry C-GYBK, impacted terrain about 19 miles north of Sept-iles, Quebec. Of the five occupants that were on board, the pilot sustained minor injuries, two passengers…NTSB ERA14WA047Accident · 1 fatalForeign investigationRobinson R66 · Rio de Janeiro, BrazilNTSB CEN11WA412Accident · Serious injuriesForeign investigationMcDonnell Douglas Helicopter 369E · Glastonbury, United KingdomOn June 19, 2011, at 1420 universal coordinated time (UTC), a McDonnell Douglas Helicopter Company model 369E, United Kingdom registration G-KSWI, s/n 0204E, was substantially damaged during an emergency landing after experiencing a mechanical failure of the…NTSB ERA11WA215Accident · 1 fatalForeign investigationBell 205 · San Clemente, Chile