Fatal NTSB investigations, 2020, Outside the U.S.

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19622026
Fatal NTSB investigations, 2020, Outside the U.S. per year, 1962–2026: 3,271 cases
19621
196420
196518
196615
196716
196816
196914
197014
197111
197217
197316
197411
197511
19761
19776
197811
19792
19811
19821
19831
19843
19853
19862
19879
198811
19898
19908
19919
199211
199311
199410
199524
199637
199737
199843
199953
200077
200166
200259
200371
200475
200597
200689
200787
200890
200990
201098
2011120
2012119
2013124
2014107
2015130
2016131
2017133
2018137
2019140
202091
2021107
2022125
202398
2024110
2025109
2026109

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\") = 2020
    AND c.\"eventCountry\" <> 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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.

NTSB ANC21WA009Accident · 1 fatalClass 5 · ForeignRobinson R66 · Ojiro in Shimada-City, Shizuoka, JapanDec 30, 2020 · JA77ARNTSB GAA21WA006Accident · 4 fatalClass 4 · ForeignCessna 177 · Rancador, PR, BrazilDec 29, 2020 · PT-KCK · DestroyedNTSB ERA21WA086Accident · 1 fatalClass 5 · ForeignBell 206 · Mambucaba, BrazilDec 11, 2020 · PP-MSA · Substantial damageNTSB WPR21WA065Accident · 2 fatalClass 5 · ForeignRobinson R44 · Tallong, AustraliaDec 2, 2020 · VH-HGU · DestroyedNTSB WPR21WA063Accident · 2 fatalClass 5 · ForeignGrob 120A-1 · Beer-Sheba, IsraelNov 24, 2020 · 4X-DGA · DestroyedNTSB WPR21WA062Accident · 1 fatalClass 5 · ForeignCessna 172 · Katale, UgandaNov 18, 2020 · N7834M · DestroyedNTSB GAA21WA173Accident · 2 fatalClass 5 · ForeignPiper PA11 · Open Door, ArgentinaNov 17, 2020 · LV-YNN · Substantial damageNTSB GAA21WA005Accident · 1 fatalClass 5 · ForeignBeech 95B55 · Sao Pedro, SP, BrazilNov 14, 2020 · PT-OOQ · Substantial damageNTSB CEN21WA063Accident · 1 fatalClass 5 · ForeignRotorsport UK Cavalon · Avoch, United KingdomNov 12, 2020 · G-CKYT · DestroyedNTSB CEN21WA056Accident · 2 fatalClass 5 · ForeignQuest Kodiak 100 · Guatemala City, GuatemalaNov 8, 2020 · TG-SMT · DestroyedNTSB CEN21WA061Accident · 3 fatalClass 5 · ForeignCessna 182 · Durango, MexicoNov 7, 2020 · XB-QOX · Substantial damageNTSB WPR21WA050Accident · 1 fatalClass 5 · ForeignCirrus SR22 · Nelspruit, South AfricaNov 6, 2020 · ZS-CNM · Substantial damageNTSB CEN21WA042Accident · 2 fatalClass 5 · ForeignPiper PA34 · Reus, SpainNov 3, 2020 · EC-HCA · Substantial damageNTSB WPR21WA036Accident · 1 fatalClass 5 · ForeignPiper PA-25-235 · Kirkwood, South AfricaOct 31, 2020 · ZS-MAD · DestroyedNTSB WPR21WA089Accident · 1 fatalClass 5 · ForeignCessna 182 · Cheworez, ZimbabweOct 23, 2020 · Z-YXY · Substantial damageNTSB GAA21WA002Accident · 2 fatalClass 5 · ForeignRobinson R44 · Passa Tres, Rio Claro, BrazilOct 15, 2020 · PR-ESK · Substantial damageNTSB GAA21WA001Accident · 3 fatalClass 3 · ForeignPiper PA28RT · Ubate-Cundinamarca, ColombiaOct 13, 2020 · HK2335G · Substantial damageNTSB CEN21WA013Accident · 1 fatalClass 5 · ForeignCessna FRA150 · Troutbeck, United KingdomOct 11, 2020 · G-CIIRNTSB GAA21WA175Accident · 5 fatalClass 5 · ForeignPioneer 300 · Loches, FranceOct 10, 2020 · 37AHH · 2 aircraftNTSB GAA21WA003Accident · 1 fatalClass 5 · ForeignPiper PA25 · Juan Jose Rios, MexicoOct 9, 2020 · XB-OKQ · Substantial damageNTSB ERA21WA033Accident · 2 fatalClass 3 · ForeignANG 01 · Peremoha, UkraineOct 5, 2020 · UR-PNGD · DestroyedNTSB CEN20WA426Accident · 3 fatalClass 5 · ForeignCirrus SR22 · Le Chevillotte, FranceSep 28, 2020 · N918SE · DestroyedNTSB GAA20WA139Accident · 1 fatalClass 5 · ForeignCessna 172 · Riyadh, Saudi ArabiaSep 22, 2020 · N9056K · DestroyedNTSB CEN20WA409Accident · 1 fatalClass 5 · ForeignPitts S1 · Kulmbach, GermanySep 20, 2020 · N25LM · DestroyedNTSB CEN20WA408Accident · 2 fatalForeign investigationRaven Aircraft Corppration Raven · Moosburg an der Isar, GermanySep 19, 2020 · N651RA · DestroyedNTSB CEN21WA036Accident · 2 fatalClass 5 · ForeignCessna TU206G · Los Laureles, MexicoSep 16, 2020 · XB-LVT · DestroyedNTSB GAA20WA137Accident · 2 fatalForeign investigationRans S6 · Lasne, BelgiumThe government of Belgium has notified the NTSB of an accident involving a RANS S6 airplane that occurred on September 13, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the provisions…Sep 13, 2020 · 62-ALK · DestroyedNTSB GAA20WA133Accident · 4 fatalForeign investigationCommander 114 · Fur airport, DenmarkThe government of Denmark has notified the NTSB of an accident involving a COMMANDER 114 airplane that occurred on August 30, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the…Aug 30, 2020 · D-EQCA · DestroyedNTSB GAA20WA134Accident · 1 fatalForeign investigationBeech 35 · Teresina, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH 35 airplane that occurred on August 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…Aug 28, 2020 · PT-AFN · DestroyedNTSB WPR20WA292Accident · 1 fatalForeign investigationCessna 172 · Springs, South AfricaThe government of South Africa has notified the National Transportation Safety Board (NTSB) of an accident involving a Cessna 172 airplane that occurred on August 26, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of…Aug 26, 2020 · ZE-OET · Substantial damageNTSB GAA20WA132Accident · 2 fatalClass 5 · ForeignAviamilano Falco F8L · Sibari, ItalyAug 26, 2020 · I-CAVL · DestroyedNTSB CEN20WA435Accident · 2 fatalClass 4 · ForeignSchleicher ASH25 · Gloucestershire, United KingdomAug 26, 2020 · G-CFST · Substantial damageNTSB CEN20WA376Accident · 1 fatalForeign investigationCanadair CL215 1A10 · Lobios (Ourense), PortugalThe Comision de Investigacion de Accidentes y Incidentes de Aviacion Civil (CIAIAC) of Spain has notified the NTSB of an incident involving a Canadair CL-215-1A10 airplane, which occurred on August 8, 2020. The NTSB has appointed a U.S Accredited…Aug 8, 2020 · EC-HET · Substantial damageNTSB GAA20WA128Accident · 1 fatalForeign investigationRans S6 · Heathfield East Sussex, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a RANS S6 airplane that occurred on August 04, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…Aug 4, 2020 · G-BUWK · DestroyedNTSB GAA20WA125Accident · 1 fatalForeign investigationCessna R172 · Tarapaca-Amazonas, ColombiaJul 30, 2020 · HK2129 · DestroyedNTSB ANC20WA073Accident · 1 fatalForeign investigationCessna 140 · Abbotsford, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 140 airplane that occurred on July 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…Jul 28, 2020 · C-GOFKNTSB GAA20WA126Accident · 4 fatalForeign investigationCessna 172 · Blatten - VS, SwitzerlandThe government of Switzerland has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on July 25, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…Jul 25, 2020 · HB-TLF · DestroyedNTSB GAA20WA118Accident · 1 fatalForeign investigationRobinson R44 · Thorburn Lake, CanadaThe government of Canada has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on July 20, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…Jul 20, 2020 · C-FPBL · Substantial damageNTSB GAA20WA148Accident · 1 fatalClass 4 · ForeignParachute Icarus Crossfire 2 · Juta, HungaryJul 19, 2020 · UNREG · Substantial damageNTSB GAA20WA121Accident · 1 fatalForeign investigationBeech 58 · Sao Paulo, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH 58 airplane that occurred on July 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO…Jul 8, 2020 · PR-OFI · Substantial damageNTSB WPR20WA210Accident · 2 fatalForeign investigationRobinson R44 · Broome Aerodrome, AustraliaThe government of Australia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on July 04, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…Jul 4, 2020 · VH-NBY · Substantial damageNTSB GAA20WA113Accident · 2 fatalForeign investigationRobinson R22 · Strzegom city, PolandThe government of Poland has notified the NTSB of an accident involving a ROBINSON R22 helicopter that occurred on June 30, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Poland's investigation under the provisions…Jun 30, 2020 · SP-HBOG · DestroyedNTSB GAA20WA114Accident · 5 fatalForeign investigationCessna TU206 · Balleza, Chihuahua, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA TU206 airplane that occurred on June 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…Jun 23, 2020 · XB-PWE · DestroyedNTSB GAA20WA112Accident · 1 fatalForeign investigationPiper PA25 · Vereda Brisas de Guaiquitia, ColombiaJun 22, 2020 · HK-1042 · DestroyedNTSB WPR20WA186Accident · 2 fatalForeign investigationBell 206 · Gauteng, South AfricaJun 17, 2020 · ZT-RHC · DestroyedNTSB CEN20WA237Accident · 1 fatalForeign investigationPiper PA34 · Reinsfeld, GermanyThe government of Germany has notified the NTSB of an accident involving a Piper PA-34 220T airplane, German registration D-GEMZ, that occurred on June 17, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's…Jun 17, 2020 · D-GEMZ · DestroyedNTSB WPR20WA182Accident · 2 fatalForeign investigationCessna 152 · Bhubaneswar, IndiaThe government of India has notified the NTSB of an accident involving a CESSNA 152 airplane that occurred on June 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's investigation under the provisions of ICAO…Jun 8, 2020 · VT-ENF · Substantial damageNTSB CEN20WA438Accident · 1 fatalClass 5 · ForeignPitts S2 · Carcassonne, FranceMay 30, 2020 · F-GIZZ · DestroyedNTSB CEN20WA198Accident · 1 fatalForeign investigationCessna 150 · Blomberg, GermanyThe government of Germany has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on May 27, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…May 27, 2020 · D-ECVT · DestroyedNTSB ERA20WA196Accident · 1 fatalForeign investigationDiamond DA20 · Rome, ItalyThe government of Italy has notified the NTSB of an accident involving a DIAMOND DA20 airplane that occurred on May 25, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…May 25, 2020 · I-DADL · Substantial damage