NTSB investigations, 2011, Outside the U.S.
18 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 14 |
| 2010 | 16 |
| 2011 | 18 |
| 2012 | 27 |
| 2013 | 17 |
| 2014 | 23 |
| 2015 | 6 |
| 2016 | 3 |
| 2017 | 2 |
| 2018 | 10 |
| 2019 | 11 |
| 2020 | 12 |
| 2021 | 39 |
| 2022 | 37 |
| 2023 | 28 |
| 2024 | 35 |
| 2025 | 20 |
| 2026 | 7 |
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\") = 2011
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\" = '470' 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") = 2011 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" = '470' 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 ERA12WA105Accident · 2 fatalForeign investigationCirrus SR20 · Minas Gerias, BrazilOn November 26, 2011, about 1300 universal coordinated time, a Cirrus SR20, Brazilian registration PR-LJL, operated by a private individual, was substantially damaged when it impacted terrain in Carmo do Cajuri Municipality, Minas Gerais, Brazil. The pilot…NTSB ERA12WA136Accident · No injuriesForeign investigationPiper PA36 · Machala, EcuadorOn November 23, 2011, about 2000 coordinated universal time, a Piper PA-36-300, Ecuadorian registration HC-BHJ, operated by Aerorient Fumigacion Aerea, was substantially damaged when the pilot made a forced landing following loss of engine power in a banana…NTSB ERA12WA099Accident · 4 fatalForeign investigationCessna 210 · Cuiaba, BrazilOn November 12, 2011, about 2000 universal coordinated time, a Cessna 210N, Brazilian registration PT-VMG, was substantially damaged when it impacted terrain shortly after takeoff in Cuiaba Municipality, State of Mato Grosso, Brazil. The Brazilian…NTSB ERA12WA092Accident · No injuriesForeign investigationPiper PA-25 · Meteropolitana, ChileOn November 11, 2011, at 1345 UTC, a Piper PA-25-260, Chilean registration CC-ABM, registered to and operated by Sociedad De Ttrabajos Aeros Aeropacifico LTDA as a personal flight experienced a partial loss of engine power on initial takeoff climb, in the…NTSB ERA12WA041Accident · Serious injuriesForeign investigationBell 412 · Santa Rosa, VenezuelaOn October 15, 2011, at 1933 UTC, a Bell 412SP, YV0126, registered to and operated by Electrificacion del Caroni (EDELCA), as a business flight, collided with trees while on approach to Macagua Airport, Santa Rosa, Venezuela. The Venezuelan Government…NTSB CEN12WA033Accident · 2 fatalForeign investigationDiamond DA20 · Amurrio, SpainOn October 14, 2011, at 1040 universal coordinated time, a Diamond DA20-C1 airplane, EC-KDS, sustained substantial damage when it impacted terrain near Amurrio, Spain. The two crewmembers sustained fatal injuries. The accident investigation is under the…NTSB CEN11WA639Accident · 2 fatalForeign investigationPiper PA-31P · Ciudad Apodaca, MexicoNTSB WPR11WA421Accident · 1 fatalForeign investigationHughes 369D · South Malekula, Vanuatu, VanuatuOn August 28, 2011, at 1500 universal coordinated time, a Hughes 369D, Vanuatu registration YJ-HEL, collided with the ground after the attached long-line became entangled in the rotor system near Malekula, Vanuatu. The helicopter was operated by Vanuatu…NTSB CEN11WA617Accident · 4 fatalForeign investigationRobinson R44 · St. Ferdinand, CanadaOn August 27, 2011, at 2115 eastern daylight time, a Robinson R44 helicopter, C-GEBY, sustained substantial damage when it impacted terrain shortly after takeoff near St. Ferdinand, Quebec, Canada. The pilot and three passengers sustained fatal injuries. The…NTSB ERA11WA470Accident · 2 fatalForeign investigationPiper PA30 · Region del Bio Bio, ChileOn August 20, 2011, at 1650 universal coordinated time, a Piper PA-30, Chilean registration CC-CTT, was substantially damaged when it impacted terrain, after its right wing separated in-flight while maneuvering, over Region del Bio Bio, Chile. The pilot and…NTSB ERA11WA472Accident · 4 fatalForeign investigationAgusta AW139 · BrazilOn August 19, 2011, at 1948 coordinated universal time (16:48 local time), an Agusta, AW139, helicopter, Brazilian registration PT-SEK, impacted into the Atlantic Ocean, near an oil rig, identifier P-65, the helicopter sank in waters with a recorded floor…NTSB ERA11WA268Accident · Minor injuriesForeign investigationGrumman G164 · Volgodonsk, RussiaOn April 20, 2011, about 1010 Universal Coordinated Time (UTC), a Grumman G-164A Agcat, Russian registration RA-1398G, operated by a private individual, was substantially damaged during a forced landing following a loss of engine power near Volgodonsk, Rostov…NTSB ERA11WA189Accident · 1 fatalForeign investigationCessna 182 · Calamar, ColombiaOn March 14, 2011, about 0815 universal coordinated time, a Cessna, 182N, Colombian registration, HK1084, operated by Transportes Aereos del Ariari, crashed while returning to Aerodromo Jorge E. Gonzalez- San Jose Guaviare (SKSJ), Calamar, Colombia, shortly…NTSB ERA11WA362Accident · Minor injuriesForeign investigationCessna 152 · Kingston, JamaicaOn March 4, 2011, about 1000 eastern standard time, a Cessna 152, Jamaican registration 6Y-JGA, was substantially damaged during a forced landing, following a total loss of engine power during initial climb from Norman Manley International Airport (MKJP),…NTSB WPR11WA129Accident · 1 fatalForeign investigationCessna 310R · Bathurst Island, Australia, AustraliaOn February 5, 2011, at 1255 universal coordinated time, a Cessna 310R, VH-XGX, operated by a private individual, collided with terrain near Bathurst Island, Australia. The airplane was substantially damaged and the pilot, the sole occupant, was killed. The…NTSB WPR11WA127Accident · 2 fatalForeign investigationRobinson R44 · Cessnock, Australia, AustraliaOn February 4, 2011, at 0047 universal coordinated time, a Robinson R-44, VH-HFH, operated by Aero Logistics Pty, collided with terrain during an instructional flight near Cessnock, Australia. The helicopter was substantially damaged and the pilot and a…NTSB ERA11WA119Accident · 1 fatalForeign investigationAvions Robin DR400 · Guidonia Montecelio, ItalyOn January 11, 2011, about 1430 universal coordinated time, an Avions Pierre Robin, DR400/180R, Italian registration I-ITAV, crashed during takeoff, while towing a glider, and was destroyed by fire. The airplane was departing Guidonia Airport (LIRG), Guidonia…NTSB ERA11WA126Accident · 1 fatalForeign investigationPiper · Corupa, BrazilOn January 03, 2011, at 1200 coordinated universal time (10:00 local time), a Piper PA-25-260, Brazilian registration PT-DJS, incurred substantial damage when it impacted terrain for unknown reasons near, Corupa, Santa Catarina, Brazil,. The pilot was fatally…