NTSB investigations, 2012, Outside the U.S.
16 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 | 49 |
| 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\") = 2012
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") = 2012 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 ERA13WA080Accident · 1 fatalForeign investigationPiper PA-25-260 · El Viento, ColombiaOn November 22, 2012, at 1705 Universal Coordinated Time (UTC), a Piper PA-25-260, Colombian registration HK588,operated by Fuminorte Ltda. Fumigaciones Aereas Norte, was substantially damaged when it collided with terrain during an agriculture spraying…NTSB ERA12WA577Accident · 1 fatalForeign investigationCessna 172R · Macapá, BrazilOn September 12, 2012, about 2112 universal coordinated time, a Cessna 172R, Brazilian registration PT-WYK, was destroyed when it collided with terrain under unknown circumstances near Macapa ´, Brazil. The non-certificated pilot was fatally injured. The…NTSB CEN12WA562Accident · 2 fatalForeign investigationPiper PA-38-112 · Bruera, Cheshire, United KingdomOn August 16, 2012, about 1940 universal coordinated time, a Piper PA-38-112 airplane, United Kingdom registration G-BODP, impacted terrain during an instructional flight near Bruera, Cheshire, United Kingdom. The flight instructor and student pilot were…NTSB CEN12WA528Accident · Serious injuriesForeign investigationCessna 180G · Kenora, CanadaNTSB DCA12WA135Accident · 3 fatalForeign investigationAgusta A109 · Jiquipilco, MexicoThe Mexican Dirección General de Aeronáutica Civil (DGAC) has notified the NTSB of an accident involving a AgustaWestland 109SP helicopter that occurred on July 28, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC investigation…NTSB ERA12WA383Accident · 1 fatalForeign investigationPiper PA-28R-200 · São Paulo, BrazilNTSB WPR12WA446Accident · 1 fatalForeign investigationHughes 369D · Lake Sumner, New Zealand, New ZealandOn May 21, 2012, at 0200 universal coordinated time, a Hughes 369D, ZK-HXZ, registered to and operated by Way to Go Heliservices, crashed into Lake Sumner, New Zealand, under unknown circumstances. The helicopter sank in 125 meters of water and was not…NTSB ERA12WA372Accident · 1 fatalForeign investigationCessna 182 · Veronica, ArgentinaOn May 19, 2012, about 2140 universal coordinated time, a Cessna 182C, Argentina registration LV-GTF, was substantially damaged when it impacted terrain during a missed approach at Veronica Airfield, Veronica, Buenos Aires, Argentina. The foreign certificated…NTSB DCA12WA085Incident · No injuriesForeign investigationBoeing 737 · Riga, LatviaOn May 19, 2012, at approximately 0819 locat time, a Boeing 737-500 operated by AirBaltic was climbing after departure from Riga International Airport, and was cleared by ATC to climb to FL230. At the same time, an Airbus 320, operated by Aeroflot perfromed a…NTSB DCA12WA074Accident · No injuriesForeign investigationDornier 228 · Jomson, NepalThe Nepal Civil Aviation Authority (NCAA) has notified the NTSB of an accident involving a DO-228 that occurred on May 14, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the NCAA investigation under the provisions of ICAO Annex 13 as…NTSB ERA12WA353Accident · 2 fatalForeign investigationEmbraer EMB712 · Morro do Manduba Guaruja, BrazilOn April 26, 2012, about 1845 Universal Coordinated Time (UTC), an Embraer 712, Brazilian registration PT-NUH, operated by the Aeroclube de Itanhaem, crashed under unknown circumstances in a dense forest area in Morro do Manduba Guaruja Municipality, Sao…NTSB ERA12WA298Accident · 4 fatalForeign investigationAgusta A119 · Leningradsky, RussiaOn April 6, 2012, about 1240 Universal Coordinated Time (UTC), an AgustaWestland S.p.A., A119 helicopter, Russian registration RA-01980, crashed onto a frozen lake (Yanisyarvi), Sortavalsk district, Leningradsky region, about 5 KM from camp Chernye Kamni,…NTSB DCA12WA055Accident · No injuriesForeign investigationATR ATR72 · Roshchino, RussiaThe Russian Interstate Aviation Committee (MAK) has notified the NTSB of an accident involving an ATR-72 that occurred on April 2, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the MAK investigation under the provisions of ICAO Annex…NTSB ERA12WA249Accident · 8 fatalForeign investigationBeech 300 · Puerto Aguiree, ChileOn March 22, 2012, at 0358 UTC, a Beech BE 300, Chilean registration CC-AEB registered to Banco Popular Espanol, S.A. and operated by Inaer Helicopter Chile SA as an air ambulance flight, departed controlled flight at Flight level 280 while in radio contact…NTSB ERA12WA221Accident · 3 fatalForeign investigationPiper PA-34 · Belém, BrazilOn February 25, 2012, about 1150 coordinated universal time, a Piper PA-34-220T, Brazilian registration PR-LAB, was substantially damaged when it impacted terrain shortly after departure from Belém-Brigadeiro Protásio de Oliveira Airport (SBJC), Belém,…NTSB CEN12WA138Accident · No injuriesForeign investigationPiper PA-31-235 · Powys, Wales, United Kingdom, United KingdomOn January 18, 2012, about 1145 universal time (UTC), a United Kingdom registered Piper PA-31-235, G-BWHF, sustained substantial damage when it impacted terrain near Leighton Welshpool, Powys, Wales, United Kingdom. The pilot and the passenger were fatally…