NTSB investigations, Outside the U.S.
525 cases where the sequence of events included Loss of control in flight.
Cases, newest first
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 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 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 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…NTSB GAA19WA230Incident · No injuriesForeign investigationCessna CJ1 · Bournemouth, Dorset, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a CESSNA CJ1 airplane that occurred on April 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB GAA19WA197Accident · 4 fatalForeign investigationCessna P210 · Solunska glava (LBSF), North MacedoniaThe government of Macedonia has notified the NTSB of an accident involving a CESSNA P210 airplane that occurred on April 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Macedonia's investigation under the…NTSB GAA19WA187Accident · 3 fatalForeign investigationEpig 1000LT · Egelsbach (Germany), GermanyThe government of Germany has notified the NTSB of an accident involving an amateur-built EPIG 1000LT airplane that occurred on March 31, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under…NTSB GAA19WA201Accident · 1 fatalForeign investigationMoravan Z-50LA · Castel Viscardo, ItalyThe government of Italy has notified the NTSB of an accident involving a MORAVAN Z-50LA airplane that occurred on March 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB GAA19WA188Accident · 1 fatalForeign investigationPiper J3C · Snowshoe Lake, Ontario, CanadaNTSB GAA19WA179Accident · 2 fatalForeign investigationEnstrom 480 · Blazkov village, Czech Republic., CzechiaThe government of Czech Republic has notified the NTSB of an accident involving a ENSTROM 480 helicopter that occurred on March 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Czech Republic's investigation under…NTSB GAA19WA222Accident · 2 fatalForeign investigationCessna U206 · Bolivar, VenezuelaThe government of Venezuela has notified the NTSB of an accident involving a CESSNA U206 airplane that occurred on March 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Venezuela's investigation under the…NTSB CEN19WA105Accident · No injuriesForeign investigationPiper PA34 · Lagunilla, Costa RicaNTSB CEN19WA103Accident · 2 fatalForeign investigationRobinson R66 · Timmins, CYTS, CanadaThe government of Canada has notified the NTSB of an accident involving a Robinson R66 helicopter that occurred on March 04, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…NTSB ERA19WA099Accident · 3 fatalForeign investigationBell 206 · Barueri County, BrazilThe government of Brazil has notified the NTSB of an accident involving a Bell 206 helicopter that occurred on February 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ERA19WA101Accident · 2 fatalForeign investigationGlobe GC1A · Dom Pedrito County, BrazilThe government of Brazil has notified the NTSB of an accident involving a GLOBE GC1A airplane that occurred on February 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB WPR19WA147Accident · Minor injuriesForeign investigationSikorsky S64 · Mount Eliza, AustraliaOn January 28, 2019, at 1956 local time, a Sikorsky S-64E, N173AC, sustained substantial damage after colliding into a pond near Mount Eliza, Australia. The pilot and two crewmembers were not injured. The investigation is under the jurisdiction of the…NTSB CEN19WA057Accident · 2 fatalForeign investigationPiper PA46 · St. Peter Port, United KingdomOn January 21, 2013, about 2012 UTC, a Piper PA-46-301P, N264DB, operated by a private individual, disappeared from radar 15 nm north of Guernsey, Channel Island, United Kingdom. The airplane is believed to have crashed in English Channel and is presumed…NTSB ERA19WA092Accident · 1 fatalForeign investigationPiper PA25 · Campinas do Sul County, BrazilThe government of Brazil has notified the NTSB of an accident involving a Piper PA25-235 airplane that occurred on January 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…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…