Fatal NTSB investigations, 2006, 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, 2006, 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\") = 2006
    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 DFW07WA054Accident · 2 fatalForeign investigationSabreliner NA-265T39 · Culiacan, MexicoDec 30, 2006 · XA-TNP · DestroyedNTSB DEN07WA041Accident · 1 fatalForeign investigationPiper PA-28-161 · Cantal Region, FranceDec 29, 2006 · F-GHKB · DestroyedNTSB WAS07WA005Accident · 2 fatalForeign investigationCessna 310Q · Mbeya, TanzaniaDec 16, 2006 · 5H-TZA · DestroyedNTSB DFW07WA040Accident · 3 fatalForeign investigationPiper PA-34-220T · Cadiz, SpainDec 15, 2006 · EC-HOL · DestroyedNTSB DEN07WA031Accident · 1 fatalForeign investigation107.5 Flying One Design DR 107 · Langenthal, SwitzerlandDec 3, 2006 · N107FP · DestroyedNTSB LAX07WA057Accident · 1 fatalForeign investigationRobinson R44 · Nadi, FijiDec 1, 2006 · DQ-IHE · DestroyedNTSB DEN07WA034Accident · 1 fatalForeign investigationGrob G 180 · Mindelheim, GermanyNov 29, 2006 · D-CGSP · DestroyedNTSB NYC07WA044Accident · 2 fatalForeign investigationBell 412 · Cafasse, Torino, ItalyNov 27, 2006 · I-AIVO · DestroyedNTSB NYC07WA039Accident · 1 fatalForeign investigationRobinson R-44 · Venice, ItalyNov 26, 2006 · I-EVER · DestroyedNTSB DEN07WA028Accident · 1 fatalForeign investigationYoakley Glasair · Rieden, GermanyNov 26, 2006 · N79KD · DestroyedNTSB MIA07WA022Accident · 6 fatalForeign investigationBeech B55 · Coyhaique, ChileNov 23, 2006 · CC-CAC · DestroyedNTSB DEN07WA025Accident · 1 fatalForeign investigationBurton Christen Eagle II · Pfronten, GermanyNov 16, 2006 · N60BS · DestroyedNTSB MIA07WA023Accident · 1 fatalForeign investigationBell 206L · Antioquia, ColombiaNov 3, 2006 · HK3727 · DestroyedNTSB DEN07WA018Accident · 1 fatalForeign investigationRobinson R-44 · Katrineholm, SwedenOct 30, 2006 · SE-JGX · DestroyedNTSB WAS07RA004Accident · 96 fatalForeign investigationBoeing 737-200 · Abuja, NigeriaOct 29, 2006 · 5N-BFKNTSB DEN07WA016Accident · 5 fatalForeign investigationCASA C-212-CE · Skanoer, SwedenOct 26, 2006 · SE-IVF · DestroyedNTSB WAS07WA003Accident · 6 fatalForeign investigationCessna 425 · Tulear, MadagascarOct 25, 2006 · 5R-MGV · DestroyedNTSB WAS07WA001Accident · 2 fatalForeign investigationPiper PA-28-140 · Petrusburg, South AfricaOct 19, 2006 · ZS-EXM · DestroyedNTSB DEN07WA012Accident · 4 fatalForeign investigationBeech 90 · Besancon, FranceOct 18, 2006 · F-GVPD · DestroyedNTSB DFW07WA005Accident · 3 fatalForeign investigationPiper PA-32 · Alava, SpainOct 17, 2006 · D-EJTF · DestroyedNTSB MIA07WA006Accident · 6 fatalForeign investigationPiper PA-34-200 · Victoria, BrazilOct 13, 2006 · PT-ISF · DestroyedNTSB DFW07WA002Accident · 4 fatalForeign investigationRobinson R44 · Sosua, Dominican RepublicOct 11, 2006 · HI-803CT · DestroyedNTSB WAS07WA002Accident · 3 fatalForeign investigationBeech V35 · Himeville, South AfricaOct 10, 2006 · ZS-JYB · DestroyedNTSB DCA07WA002Accident · 4 fatalForeign investigationBritish Aerospace BAe-146-200A · Stord-Sorstokke, NorwayOct 10, 2006 · OY-CRG · DestroyedNTSB DCA06RA076Accident · 154 fatalForeign investigationBoeing 737-800 · Azevedo, BrazilSep 29, 2006 · PR-GTD · 2 aircraft · DestroyedNTSB ANC06WA139Accident · 1 fatalForeign investigationBell 204B · Stony Rapids, CanadaSep 24, 2006 · C-GSHK · DestroyedNTSB MIA06WA138Accident · 1 fatalForeign investigationBell 212 · San Vicente, ColombiaSep 22, 2006 · HK-3341 · DestroyedNTSB DEN06WA133Accident · 1 fatalForeign investigationPiper PA-28-181 · Bad Schwartau, GermanySep 22, 2006 · D-EGPD · 2 aircraft · Substantial damageNTSB CHI06WA280Accident · 1 fatalForeign investigationGuscott VariViggen · Plaster Rock, CanadaSep 17, 2006 · N106VV · DestroyedNTSB DFW06WA211Accident · 1 fatalForeign investigationPiper PA-46-310P · Toluca, MexicoSep 15, 2006 · XB-JVH · DestroyedNTSB NYC07WA089Accident · 3 fatalForeign investigationMD Helicopters MD-600N · Novokuznetsk, RussiaSep 13, 2006 · UNREG · DestroyedNTSB DEN06WA130Accident · 2 fatalForeign investigationRobinson R-22 Beta · St. Florian, AustriaSep 10, 2006 · OE-XPJ · DestroyedNTSB DFW06WA210Accident · 3 fatalForeign investigationBeech 35 · Ensenada, MexicoSep 8, 2006 · N5146C · DestroyedNTSB DEN06WA120Accident · 1 fatalForeign investigationBellanca 17-31 ATC · Neuwerk Island, GermanySep 1, 2006 · D-ELAI · Substantial damageNTSB ANC06WA120Accident · 6 fatalForeign investigationCessna 337 · Ft. Good Hope, CanadaAug 16, 2006 · C-FWHP · DestroyedNTSB NYC06WA202Accident · 3 fatalForeign investigationLockheed L-100-30 · Piacenza, ItalyAug 13, 2006 · 7T-VHG · DestroyedNTSB MIA06WA128Accident · 2 fatalForeign investigationCessna 207A · Puerto Ayacucho, VenezuelaAug 11, 2006 · YV492C · DestroyedNTSB CHI06WA248Accident · 1 fatalForeign investigationBussey Express FT · Regina, SK, CanadaAug 4, 2006 · N554SB · DestroyedNTSB NYC06WA186Accident · 1 fatalForeign investigationPiper PA-28RT-201T · Guipuzcoa, SpainJul 27, 2006 · EC-ENR · Substantial damageNTSB CHI06WA192Accident · 4 fatalForeign investigationPiper PA-46-310P · Marina di Campo, ItalyJul 16, 2006 · D-EJMV · DestroyedNTSB DEN06WA102Accident · 1 fatalForeign investigationCessna T310R · Saint Tropez, FranceJul 15, 2006 · N234SA · DestroyedNTSB DEN06WA098Accident · 3 fatalForeign investigationCessna 172N · El Rosario, SpainJul 14, 2006 · EC-HQR · DestroyedNTSB WAS06WA012Accident · 5 fatalForeign investigationLockheed 382 C130 · Kigoma, TanzaniaJul 12, 2006 · S9-BOF · DestroyedNTSB DFW06WA177Accident · 5 fatalForeign investigationCessna 182C · Tepic, MexicoJul 9, 2006 · XB-PER · DestroyedNTSB DCA06RA055Accident · 124 fatalForeign investigationAirbus Industrie A310-300 · Irkutsk, RussiaJul 8, 2006 · F-OGYPNTSB DCA06RA053Accident · 6 fatalForeign investigationSikorsky S61N · Tenerife, SpainJul 8, 2006 · EC-FJJNTSB DFW08WA205Accident · 5 fatalForeign investigationCessna T210N · Poptun, GuatemalaJul 1, 2006 · TG-LUK · DestroyedNTSB WAS06WA011Accident · 3 fatalForeign investigationCessna 208B · Vilanculos, MozambiqueJun 30, 2006 · ZS-POG · Substantial damageNTSB NYC06WA166Accident · 1 fatalForeign investigationPiper PA-23-250 · Thirkleby, United KingdomJun 29, 2006 · G-BBEY · DestroyedNTSB DFW06WA170Accident · 1 fatalForeign investigationCessna U206 · Chiguao, VenezuelaJun 26, 2006 · YV-229C · Destroyed