NTSB investigations, 2019, Outside the U.S.
64 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\") = 2019
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") = 2019 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 GAA20WA103Accident · 1 fatalForeign investigationCessna 150 · Region del Bio Bio, ChileThe government of Chile has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on December 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of…NTSB GAA20WA102Accident · 1 fatalForeign investigationBeech C90 · Caieiras, SP, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH C90 airplane that occurred on December 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB CEN20WA024Accident · 7 fatalForeign investigationPiper PA32 · Kingston, CanadaNTSB GAA20WA097Accident · 1 fatalForeign investigationCessna 172 · Near Puffin Island, Anglesey, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on November 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…NTSB ERA20WA032Accident · 2 fatalForeign investigationICP Ventura · Gecitkale, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a ICP Ventura ultralight that occurred on October 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions…NTSB GAA20WA078Accident · 6 fatalForeign investigationCessna 401 · Madero, Mexico, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 401 airplane that occurred on October 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB GAA20WA065Accident · 2 fatalForeign investigationCirrus SR20 · Belo Horizonte, BrazilThe government of Brazil has notified the NTSB of an accident involving a CIRRUS SR20 airplane that occurred on October 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB GAA20WA077Accident · 2 fatalForeign investigationCessna 310 · La Piedad, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 310 airplane that occurred on October 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB WPR20WA010Accident · No injuriesForeign investigationBell 412 · Port Said City, EgyptOn October 11, 2019, about 1147 coordinated universal time, a Bell Helicopter 412EP, SU-CBX, impacted the sea about 65 miles north of Port Said City, Egypt after losing control in flight. There were no injuries to the two pilots and three passengers, and the…NTSB WPR20WA002Accident · 1 fatalForeign investigationCessna 172 · Maharashtra, IndiaOn October 5, 2019, at 0628 coordinated universal time, a Cessna 172R airplane, VT-HRP, collided with a fence during approach at the Shirpur Airport, Maharashtra, India. The student pilot was fatally injured and the airplane was substantially damaged. The…NTSB GAA19WA588Accident · 2 fatalForeign investigationPiper PA22 · Petrovice, CzechiaThe government of Czech Republic has notified the NTSB of an accident involving a PIPER PA22 airplane that occurred on September 26, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Czech Republic's investigation under…NTSB GAA19WA595Accident · 2 fatalForeign investigationCozy Mark IV · Rio Verda, GO, BrazilThe government of Brazil has notified the NTSB of an accident involving a COZY Mark IV airplane that occurred on September 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB GAA19WA553Accident · 1 fatalForeign investigationCessna 208 · Gransee, GermanyThe government of Germany has notified the NTSB of an accident involving a CESSNA 208 airplane that occurred on September 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the…NTSB GAA19WA593Accident · No injuriesForeign investigationPiper PA25 · Mazatan, Chiapas, MexicoThe government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on September 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB GAA19WA565Accident · 1 fatalForeign investigationCessna 172 · Racine, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 172 that occurred on September 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of ICAO…NTSB GAA19WA594Accident · 1 fatalForeign investigationAirbus A350 · Alta city, NorwayThe government of Norway has notified the NTSB of an accident involving a AIRBUS A350 helicopter that occurred on August 31, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the provisions…NTSB GAA19WA540Accident · 3 fatalForeign investigationRobinson R44 · Buriti Alegre, BrazilThe government of Brazil has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on August 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB CEN19WA287Accident · 3 fatalForeign investigationPiper PA28RT · Simplon Pass, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a Piper PA28RT airplane that occurred on August 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…NTSB CEN19WA285Accident · 1 fatalForeign investigationRotorway Exec 162F · Herisau, SwitzerlandOn August 24, 2019, about 1400 universal coordinated time, a Rotorway Exec 162F helicopter, Swiss registration HB-YKJ, was destroyed when it crashed in a meadow during an autorotation and caught fire, about 3 miles south of Herisau, Switzerland. The pilot was…NTSB GAA19WA532Accident · 4 fatalForeign investigationCessna 182 · Warintza, Morona Santiago, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a CESSNA 182 airplane that occurred on August 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions…NTSB ERA19WA261Accident · 3 fatalForeign investigationAgusta A109 · Poros, GreeceThe government of the Hellenic Republic, Greece, has notified the NTSB of an accident involving an Agusta A-109C helicopter that occurred on August 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Greece's…NTSB ERA19WA270Accident · 3 fatalClass 5 · ForeignEmbraer EMB710 · Itaituba, BrazilNTSB GAA19WA579Accident · No injuriesForeign investigationHughes 369 · Follebu, NorwayThe government of Norway has notified the NTSB of an accident involving a HUGHES 369 helicopter that occurred on August 01, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the provisions…NTSB CEN19WA268Accident · 1 fatalForeign investigationBeech V35 · Senneterre, Quebec, CanadaNTSB GAA19WA460Accident · 1 fatalForeign investigationDe Havilland DH82 · Hythe, United KingdomNTSB GAA19WA444Accident · 1 fatalForeign investigationCirrus SR22 · Leutasch, Austria, AustriaThe government of Austria has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on July 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Austria's investigation under the provisions of…NTSB GAA19WA441Accident · 7 fatalForeign investigationDe Havilland DHC2 · Mistastin Lake, NL, CanadaThe government of Canada has notified the NTSB of an accident involving a DE HAVILLAND DHC2 airplane that occurred on July 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…NTSB GAA19WA420Accident · 9 fatalForeign investigationAIRvan GA8 · Umea, SwedenThe government of Sweden has notified the NTSB of an accident involving a AIRvan GA8 airplane that occurred on July 14, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Sweden's investigation under the provisions of…NTSB GAA19WA442Accident · 2 fatalForeign investigationSteen Skybolt · Enconada, BoliviaThe government of Bolivia has notified the NTSB of an accident involving an amateur-built STEEN Skybolt airplane that occurred on July 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under…NTSB ERA19WA237Accident · 2 fatalForeign investigationPiper PA28 · Atibaia, BrazilThe government of Brazil has notified the NTSB of an accident involving a Piper PA-28-140 airplane that occurred on July 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB GAA19WA459Accident · 2 fatalForeign investigationDe Havilland DHC2 · Hawk Junction ON-Canada, CanadaThe government of Canada has notified the NTSB of an accident involving a DE HAVILLAND DHC2 airplane that occurred on July 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…NTSB ERA19FA210Accident · 7 fatalClass 2 · FieldFinal reportAgusta AW139 · Big Grand Cay, BahamasThe pilots’ decision to takeoff over water in dark night conditions with no external visual reference, which resulted in spatial disorientation and subsequent collision with the water. Also causal was the pilots’ failure to adequately monitor their…NTSB GAA19WA386Accident · 2 fatalForeign investigationCessna 182 · Chimaltenango, GuatemalaNTSB WPR19WA277Accident · No injuriesForeign investigationRobinson R22 · Kutchera Station, AustraliaOn June 22, 2019, at 0900 local time, a Robinson R22 helicopter, VH-HHQ, collided with terrain near Kutchera Station, Australia. The pilot was fatally injured and the helicopter was substantially damaged. The flight was conducted under the pertinent civil…NTSB GAA19WA356Accident · 1 fatalForeign investigationPitts S2 · Saint-Jean-Port-Joli, CanadaNTSB GAA19WA341Accident · 2 fatalForeign investigationCessna 172 · Sailagouse, France, FranceThe government of France has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on June 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB CEN19WA342Accident · 2 fatalForeign investigationBRM Aero Bristell NG5 · Belan, IrelandThe government of Ireland has notified the NTSB of an accident involving an amateur-built BRM Aero Bristell NG5 airplane that occurred on June 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's…NTSB GAA19WA391Accident · 3 fatalForeign investigationPiper PA23 · Mulakot, IcelandNTSB GAA19WA357Accident · 1 fatalForeign investigationS.A.N. Jodel D-11 · La Cote, Switzerland, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a S.A.N. Jodel D-11 airplane that occurred on May 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…NTSB ANC19WA020Accident · 2 fatalForeign investigationCessna 170 · Whitehorse, CanadaNTSB GAA19WA308Accident · 3 fatalForeign investigationPiper PA28 · Estancia County, BrazilNTSB GAA19WA290Accident · 1 fatalForeign investigationCessna T210 · Belem County, State of Para, BrazilNTSB GAA19WA275Accident · 2 fatalForeign investigationBeech F33 · Campo Grande County, BrazilNTSB GAA19WA291Accident · 2 fatalForeign investigationCessna T210 · Mahahual, Mexico, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA T210 airplane that occurred on May 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB CEN19WA137Accident · 14 fatalForeign investigationCanadair CL 600 2B16 · Coahuila, MexicoOn May 5, 2019, a Challenger Ltd CL-600-2B16 airplane, N601VH, impacted terrain near Coahuila, Mexico. The two pilots and fourteen passengers were fatally injured, and the airplane was substantially damaged. This investigation is under the jurisdiction and…NTSB GAA19WA254Accident · No injuriesForeign investigationRobinson R44 · Guatape-Antioquia, ColombiaNTSB ERA19WA168Accident · Serious injuriesForeign investigationAyres S2R · Isla Bejucal, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a AYRES S2R airplane that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions of…NTSB ERA19WA165Accident · 1 fatalForeign investigationRobinson R22 · Pegognaga, ItalyThe government of Italy has notified the NTSB of an accident involving a Robinson R22 Beta helicopter that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions…NTSB GAA19WA210Accident · 6 fatalForeign investigationBritten Norman BN2A · Marcel Marchant (SCPF), ChileThe government of Chile has notified the NTSB of an accident involving a BRITTEN NORMAN BN2A airplane that occurred on April 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the…NTSB WPR19WA225Incident · No injuriesForeign investigationPilatus PC12 · Merredin, AustraliaOn April 14, 2019, at 0020 local time, a Pilauts PC-12 airplane, VH-OWJ, experienced an uncontrolled pitch down while climbing through 2,600 ft mean sea level near Merredin, Western Australia. The pilot and three passengers were not injured. The airplane was…