NTSB investigations, 2011, Outside the U.S.
19 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 9 |
| 2010 | 20 |
| 2011 | 19 |
| 2012 | 16 |
| 2013 | 26 |
| 2014 | 40 |
| 2015 | 60 |
| 2016 | 78 |
| 2017 | 69 |
| 2018 | 79 |
| 2019 | 46 |
| 2020 | 50 |
| 2021 | 49 |
| 2022 | 50 |
| 2023 | 55 |
| 2024 | 59 |
| 2025 | 70 |
| 2026 | 203 |
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\" = '000' 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" = '000' 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 DCA11WA108Accident · 18 fatalForeign investigationAviocar CASA C212 · Aceh, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an accident involving a Aviocar CASA C212 that occurred on September 29, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation…NTSB WPR11WA476Accident · 2 fatalForeign investigationBell 412SP · Mataram, West Nusa, IndonesiaOn September 25, 2011, at 1341 local time (0541 UTC) a Bell Helicopter 412SP, Indonesia registry PK-OVC, crashed in a jungle under unknown circumstances 150 kilometers east of Selaparang Airport, Mataram, West Nusa Tenggara, Indonesia. The Helicopter was…NTSB DCA11WA099Incident · No injuriesForeign investigationAirbus A320 · Cusco, PeruOn September 19, 2011, at 1620 UTC, an Airbus A320-233, N493TA, experienced smoke in the cockpit. The airplane landed uneventfully at Alejandro Velasco Astete International Airport (SPZO), Peru, its original destination. None of the passengers or crewmembers…NTSB CEN11WA639Accident · 2 fatalForeign investigationPiper PA-31P · Ciudad Apodaca, MexicoNTSB ERA11WA509Accident · 2 fatalForeign investigationRobinson R44 · Rio de Janeriro, BrazilOn September 10, 2011, about 2330 universal coordinated time, a Robinson R44 II, Brazilian registration PR-CEC, was substantially damaged when it impacted wooded terrain during an aerial photography flight, near Rio de Janeiro, Brazil. The foreign…NTSB CEN11WA603Accident · 1 fatalForeign investigationCessna TU206G · Sioux Lookout, CanadaNTSB WPR11WA351Accident · 1 fatalForeign investigationRobinson R22 · Fitzroy Crossing, Australia, AustraliaOn July 27, 2011, at 0930 universal coordinated time, a Robinson R-22 Beta, VH-YOL, registered to and operated by a private owner, collided with terrain near Fitzoy Crossing, Australia. The helicopter was substantially damaged and the pilot, the sole…NTSB CEN11WA382Accident · 1 fatalForeign investigationAir Tractor AT-502B · La Fora, Tiquisate, GuatemalaNTSB ERA11WA310Accident · 4 fatalForeign investigationPiper PA-34-200 · Sao Pedro, BrazilOn May 16, 2011, about 0130 universal coordinated time, a Piper PA-34-200, Brazilian registration PT-IFS, was destroyed when it impacted hilly terrain under unknown circumstances near Sao Pedro, Sao Paulo, Brazil. The Brazilian certificated pilot and three…NTSB ERA11WA305Accident · 3 fatalForeign investigationCessna 210M · Breu Branco, BrazilOn May 14, 2011, about 1430 universal coordinated time, a Cessna 210M, Brazilian registration PR-HSM, was substantially damaged when it impacted wooded terrain under unknown circumstances, in a remote, dense forest near Breu Branco, Brazil. The foreign…NTSB ANC11WA028Accident · 1 fatalForeign investigationCessna 195A · Campbell River, CanadaNTSB ERA11WA245Accident · 2 fatalForeign investigationBell 206B · Santo Andre City, BrazilOn April 8, 2011, at 2030 coordinated universal time (1730 local time), a Bell 206B, Brazilian registration PT-YMJ, was destroyed when it impacted terrain at the 5,000-foot level of the Serra do Mar mountain range in Santo André, São Paulo, Brazil. The pilot…NTSB ERA11WA251Accident · 3 fatalForeign investigationEurocopter AS-355-F2 · Alto Alegre, BrazilOn April 6, 2011, about 2225 coordinated universal time, a Eurocopter AS-355-F2, Brazilian registration PT-HNA, was destroyed when it impacted terrain near Alto Alegre, Brazil. The pilot and one passenger incurred minor injuries, and three passengers were…NTSB WPR11WA176Accident · 4 fatalForeign investigationPiper PA-32R · Moree, AustraliaThe accident is under the jurisdiction of and is being investigated by the Australian Transport Safety Bureau.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 DCA11WA024Accident · 7 fatalForeign investigationRaytheon Hawker · Sulaimanyia, IraqOn February 4, 2011 about 1449 UTC, OD-SKY, a Hawker Beechcraft HS-850XP, registered to Club Aviation S.A.L and operated by Sky Lounge services S.A.L., crashed during the initial takeoff climb at Suliamaniyah International Airport, Iraq. The 3 crew members…NTSB ERA11WA143Accident · 3 fatalForeign investigationBeech 58 · Patrimonio Regina City, BrazilOn January 28, 2011, at 2047 coordinated universal time (1847 local time), a Beech 58, Brazilian registration PT-BOR, was substantially damaged when it impacted terrain near Patrimônio Regina City, Paraná, Brazil. The two pilots and the passenger were fatally…NTSB CEN11WA151Accident · 1 fatalForeign investigationCirrus Design SR20 · Santiago Atitlán, GuatemalaNTSB DCA11WA069Accident · No injuriesForeign investigationBoeing 727 · Urmia, IranOn January 9, 2011, an Iran Air Boeing B727-200, registration EP-IRP, crashed during missed approach to Orumiyeh Airport (OITR), Urmia, Iran. Of the 105 passengers and crew onboard, 78 were fataly injured and 27 received serious injuries. The airplane was…