NTSB investigations, 2012, Outside the U.S.
18 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 13 |
| 2010 | 12 |
| 2011 | 11 |
| 2012 | 18 |
| 2013 | 26 |
| 2014 | 25 |
| 2015 | 36 |
| 2016 | 38 |
| 2017 | 31 |
| 2018 | 35 |
| 2019 | 64 |
| 2020 | 38 |
| 2021 | 35 |
| 2022 | 44 |
| 2023 | 35 |
| 2024 | 23 |
| 2025 | 30 |
| 2026 | 5 |
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\" = '240' 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" = '240' 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 ERA13WA103Accident · 2 fatalForeign investigationPiper PA28 · Minas City, BrazilOn December 26, 2012, at 2050 universal coordinated time, a Piper PA-28-181, Brazilian registration PR-NAX, was destroyed when it impacted the ground after the crew lost control during a go around. The instructor pilot and student were fatally injured. The…NTSB DCA13RA025Accident · 7 fatalForeign investigationLearjet 25 · Monterrey, MexicoNTSB ERA13WA066Accident · 1 fatalForeign investigationAerospatiale AS-355F1 · Great Guana Cay, BahamasOn November 22, 2012, about 1310 eastern standard time, an Aerospatiale AS 355F1, Bahamian registration C6-APV, registered to Pioneer Caribbean Logistics Ltd., impacted terrain while attempting to land at Baker's Bay Resort, Great Guana Cay, Bahamas. The…NTSB ERA13WA431Accident · 3 fatalForeign investigationBeech 95B55 - B · Concepcion, ParaguayOn November 16, 2012, about 0813 local time (1113 coordinated universal time), a Beech BE-55, Paraguayan registration ZP-BLV, was destroyed when it impacted terrain about 500 meters short of the runway at a ranch in Departamento Presidente Hayes, about 50…NTSB CEN13WA061Accident · 2 fatalForeign investigationReims-Cessna F150 · Birr, Ireland, IrelandOn November 11, 2012, about 1655 Western European time, a Reims-Cessna, model F150H, single engine airplane, EI-AST, was destroyed when it impacted terrain near Birr Airfield (EIBR), Birr, Ireland. The two pilots were fatally injured. The airplane was…NTSB CEN13WA020Accident · 2 fatalForeign investigationMooney M20E · Speichersdorf, GermanyOn October 21, 2012, about 1520 coordinated universal time, a Mooney M20E, D-EMHE was destroyed following a loss of control during initial climb from Rosenthal Field Ploessen Airport (EDQP), near Speichersdorf, Germany. The pilot and passenger were fatally…NTSB ERA12WA590Accident · 1 fatalForeign investigationPiper PA34 · Ilheus, BrazilOn September 25, 2012, about 0155 universal coordinated time, a Piper PA-34-200T, Brazilian registration PT-RDG, was substantially damaged when it impacted the Atlantic Ocean, shortly after takeoff from the Ilheus Jorge Amado Airport (SBIL), Ilheus, Bahia,…NTSB ERA12WA591Accident · 1 fatalForeign investigationCessna 210 · Roraima, BrazilOn September 24, 2012, about 0400 hours local, or 0800 UTC, a Cessna 210L, Brazilian registration PT-KSB, departed controlled flight and crashed shortly after takeoff from Pouso Da Aguilia Airport (SWPD), Roraima, Brazil. Visual meteorological conditions…NTSB ERA13WA205Accident · 4 fatalForeign investigationCessna 172N · Acreúna Municipality, BrazilNTSB ERA12WA554Accident · Serious injuriesForeign investigationBell 212 · Malvinas, PeruOn August 23, 2012, about 2020 universal coordinated time (1520 local time), a Bell 212, Peruvian registration OB-1912-P, operated by Los Andes S.A.C., was substantially damaged when it impacted terrain while approaching a jungle landing site about 19…NTSB CEN12WA560Accident · 2 fatalForeign investigationPaulistinha 56-C1 56-C1 · Braga, PortugalThis report is under the jurisdiction and control of the Portuguese Government.NTSB ERA12WA446Accident · 2 fatalForeign investigationRobinson R22 · Sao Paulo, BrazilOn July 11, 2012, at 1300 Universal Coordinated Time (UTC), a Robinson R22 Beta, Brazilian registration PT-HOL, operated by Master Escola Aviacao Civil Ltda, was destroyed following a loss of in-flight control and collision with a building near Sao Paulo,…NTSB WPR12WA197Accident · 1 fatalForeign investigationCessna 150 · Bourke , Australia, AustraliaOn April 29, 2012, at 0800 universal coordinated time, a Cessna 150M, VH-UWR, collided with the terrain during a mustering operation near Bourke, Australia. The airplane was operated by a private individual under the pertinent civil regulations of Australia.…NTSB ERA12WA300Accident · 1 fatalForeign investigationBeech C90 · Jundiai, BrazilOn April 20, 2012, at 1735 UTC, a Beech C90A, Brazilian registration PP-WCA, was destroyed when it impacted the ground shortly after takeoff from Comandante Rolim Adolfo Amaro State Airport (SBJD), Jundiaí, Brazil. The pilot was fatally injured. Visual…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 ERA12WA239Accident · 3 fatalForeign investigationPiper PA28R · Eliseu Martins, BrazilOn March 6, 2012, about 1400 universal coordinated time, a Piper PA-28R-200, Brazilian registration PT-NKS, was destroyed when it impacted terrain, following a loss of control during cruise flight near Eliseu Martins, Brazil. The foreign certificated pilot…NTSB DCA12FA024Accident · 3 fatalField investigationFinal reportBell 214 · Camp Bastion, Afghanistanthe overtravel of the collective sleeve, which led to a severe and sudden reduction in main rotor blade collective pitch, resulting in a loss of control of the helicopter. The reason for the collective sleeve overtravel could not be determined since much of…NTSB ERA12WA159Accident · 3 fatalForeign investigationBeech A36 · Mato Grosso, BrazilOn January 14, 2012, about 1000 universal coordinated time, a Beech A36, Brazilian registration PR-RGF, was destroyed when it impacted terrain, following a loss of control during cruise flight into deteriorating weather near Mato Grosso, Brazil. The…