NTSB investigations, 2018, Outside the U.S.
35 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 | 45 |
| 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\") = 2018
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") = 2018 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 ERA19RA077Accident · 5 fatalForeign investigationAgusta A109 · Santa Maria Coronango, State of Puebla, MexicoThe government of Mexico has notified the NTSB of an accident involving a AGUSTA A109S helicopter that occurred on December 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…NTSB CEN19WA102Accident · 3 fatalForeign investigationCirrus SR22 · Beauberry, FranceThe government of France has notified the NTSB of an accident involving a Cirrus SR22 airplane that occurred on December 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…NTSB CEN19WA040Accident · 4 fatalForeign investigationCessna U206 · Culiacan, Sinaloa, MexicoNTSB GAA19WA419Accident · 2 fatalForeign investigationSocata TB20 · Dinard Pleurtuit, FranceThe government of France has notified the NTSB of an accident involving a SOCATA TB20 airplane that occurred on November 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…NTSB ERA19WA040Accident · 1 fatalForeign investigationPiper PA23 · Nassau, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Piper PA23 airplane that occurred on November 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…NTSB CEN19WA037Accident · 1 fatalForeign investigationRotorway Exec · Saint Pierre, St. Pierre & MiquelonNTSB ENG19WA004Accident · 5 fatalForeign investigationAgusta Agusta AW169 · Leicester, United KingdomThe United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an accident involving an Agusta AW169, which occurred on October 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB WPR19WA015Accident · 1 fatalForeign investigationBell UH -1H · Vermaaklikheid, South AfricaOn October 23, 2018, about 0745 Coordinated Universal time, a Bell UH-1H helicopter, ZS-HLP, impacted terrain during a firefighting mission near Vermaaklikheid, South Africa. The pilot sustained fatal injuries and the helicopter was substantially damaged in…NTSB DCA19WA015Incident · No injuriesForeign investigationBoeing 787 · Hong Kong, ChinaThe government of China has notified the NTSB of an accident involving a BOEING 787 airplane that occurred on October 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of China's investigation under the provisions of…NTSB CEN19WA001Accident · 3 fatalForeign investigationCessna 210 5 · Yécora, MexicoOn October 1, 2018, about 2110 universal coordinated time (UTC), a Cessna 210, US registration N8388Z, impacted terrain under unknown circumstances near Sonora, Mexico. Under the provisions of ICAO Annex 13, the NTSB has assigned an accredited representative…NTSB ANC19WA001Accident · 2 fatalForeign investigationRobinson R44 · Bodaybo, RussiaOn October 1, 2018, at an undetermined time, a Robinson R-44-II helicopter, RA-05758, impacted water and sank prior to colliding with a power transmission line near Bodaybo, Russia. The pilot and passenger sustained fatal injuries. The Interstate Aviation…NTSB CEN18WA376Accident · 4 fatalForeign investigationRobinson R44 · Domažlická 1059, Plzen - Skvrnany, CzechiaOn September 5, 2018, at 1533 Coordinated Universal Time, a Robinson R44, I-CCNI, impacted terrain while maneuvering at low altitude, Plzen-Skvmany, Czech Republic. The pilot and three passengers sustained fatal injuries.The investigation is under the…NTSB ANC18WA077Accident · 3 fatalForeign investigationCessna U206 · Fort Simpson, CanadaOn August 17, 2018, about 0035 Coordinated Universal Time, an amphibious float-equipped Cessna U206G airplane, C-FNEQ, nosed over while landing at Little Doctor Lake near Fort Simpson, Northwest Territories, Canada. Of the five souls onboard, the pilot and…NTSB ERA18WA209Accident · 1 fatalForeign investigationBeech 90 · Sao Paulo, BrazilThe government of Brazil has notified the NTSB of an accident involving a Beech C90 that occurred on July 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO Annex…NTSB ERA18WA198Accident · 4 fatalForeign investigationBeech 58 · Ayolas, ParaguayThe government of Paraguay has notified the NTSB of an accident involving a BEECH 58 airplane that occurred on July 25, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Paraguay's investigation under the provisions of…NTSB CEN18WA308Accident · 1 fatalForeign investigationAir Tractor AT301 · Ascension, Chihuahua, MexicoOn July 25, 2018, about 1600 coordinated universal time, a Mexican registered Air Tractor AT 301 airplane, XB-OVB, impacted terrain near Ascension, Chihuahua, Mexico. The pilot was fatally injured and the airplane sustained substantial damage. The local…NTSB CEN18WA393Accident · Minor injuriesForeign investigationAerospatiale AS350 · Wolfsberg, AustriaNTSB ERA18WA207Accident · 1 fatalForeign investigationAero Eli Servizi Yo-Yo 222 · Musile del Piave, ItalyThe government of Italy has notified the NTSB of an accident involving a Aero Eli Servizi Yo-Yo 222 helicopter that occurred on July 13, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the…NTSB GAA18WA586Accident · Serious injuriesForeign investigationBeagle B121 · Bembridge, Isle of Wight, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a BEAGLE B121 airplane that occurred on July 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB CEN18WA264Accident · 1 fatalForeign investigationCessna 152 · Ponte de Sor, PortugalThe government of Portugal has notified the NTSB of an accident involving a Cessna 152 airplane that occurred on July 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Portugal's investigation under the provisions…NTSB CEN18WA256Accident · 2 fatalForeign investigationCessna 172 · Bad Voslau, AustriaOn June 4, 2018, about 0815 coordinated universal time, a Cessna 172S airplane, F-HFPL, impacted terrain at Bad Voslau Airport, Bad Voslau, Austria. The pilot in command and passenger were fatally injured, and the airplane was destroyed. The flight was…NTSB ERA18WA237Accident · 2 fatalForeign investigationAgusta A109 · Espírito Santo, BrazilThe government of Brazil has notified the NTSB of an accident involving a Agusta A109 helicopter that occurred on June 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB ERA18WA159Accident · 3 fatalForeign investigationCessna 421B · Rock Sound, BahamasNTSB CEN18WA196Accident · 1 fatalForeign investigationAvid Avid Flyer · Granada, SpainOn May 26, 2018, at 1030 UTC, an Avid Flyer Stol, EC-YFP, encountered a loss of climb during initial climb out and subsequent impact with terrain near Loja Aerodrome, Granada, Spain. The experimental airplane was destroyed; the pilot suffered serious injuries…NTSB ERA18WA151Accident · 2 fatalForeign investigationCessna 210 · Itacoatiara, BrazilThe government of Brazil has notified the NTSB of an accident involving a CESSNA 210 airplane that occurred on May 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB CEN18WA169Accident · 2 fatalForeign investigationCessna 208B · Clonbullogue, IrelandNTSB ERA18WA153Accident · 1 fatalClass 5 · ForeignBell Helicopter 206 · Barra da Tijuca, BrazilNTSB ERA18WA133Accident · 1 fatalForeign investigationBell 206L-4 · Vereda Plateado, ColombiaThe government of Colombia has notified the NTSB of an accident involving a BELL 206L-4 helicopter that occurred on April 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB CEN18WA130Accident · 2 fatalForeign investigationMaule M 7-235 · Arosa, SwitzerlandNTSB ERA18WA100Accident · 1 fatalForeign investigationBeech V35B · Brasilandia, Mato Grosso do Sul, BrazilThe government of Brazil has notified the NTSB of an accident involving a Beech V35B airplane that occurred on February 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ERA18WA090Accident · 4 fatalForeign investigationNeiva EMB-720D · Manaus City, BrazilThe government of Brazil has notified the NTSB of an accident involving a NEIVA EMB-720D airplane that occurred on February 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB CEN18WA096Accident · 2 fatalForeign investigationPiper PA-28-161 · Helle, NorwayOn February 11, 2018, about 2000 UTC, a Piper Aircraft, Inc. PA-28-161 airplane, Norwegian registration LN-TOS, impacted the waters near the Svolvaer Airport (ENSH), Helle, Norway. The pilot and passenger on board were fatally injured and the airplane was…NTSB ERA18WA081Accident · 2 fatalForeign investigationReims F150L · Abrizzano di Negrar, ItalyThe government of Italy has notified the NTSB of an accident involving a Reims Aviation F150L airplane that occurred on January 31, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the…NTSB CEN18WA091Accident · 1 fatalForeign investigationPiper PA25 · Mocorito, MexicoOn January 26, 2018, at 1930 UTC, a Piper PA25-150, XB-FBN, impacted terrain under unknown circumstances in the Community el Recoveco in Mocorito, Mexico. The aircraft was destroyed, and the pilot was fatally injured. The flight had departed airdrome "El…NTSB ERA18WA063Accident · 6 fatalForeign investigationPiper PA-23-250 · Nicholls Town, BahamasThe government of Bahamas has notified the NTSB of an accident involving a PIPER PA 23-250 airplane that occurred on January 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the…