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

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, 2001, Outside the U.S. per year, 1962–2026: 3,270 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
2026108

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\") = 2001
    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 WAS02WA014Accident · 3 fatalForeign investigationCessna 337D · Piura, PeruDec 23, 2001 · N24EG · DestroyedNTSB ATL02WA020Accident · 2 fatalForeign investigationCessna CE-560 · Zurich, SwitzerlandDec 20, 2001 · HB-VLV · DestroyedNTSB WAS02WA011Accident · 1 fatalForeign investigationRobinson R22 · Phitippeburg, GermanyDec 11, 2001 · D-HLHL · DestroyedNTSB LAX02RA045Accident · 1 fatalForeign investigationBeech 200C · Mount Gambier, AustraliaDec 10, 2001 · VH-FMNNTSB WAS02RA006Accident · 3 fatalForeign investigationCessna 208 · Quepos, Costa RicaNov 28, 2001 · HP-1405NTSB WAS02WA007Accident · 9 fatalForeign investigationBell UH-1H · El Limon, El SalvadorNov 27, 2001 · 66-16590 · DestroyedNTSB DCA02WA009Accident · 4 fatalForeign investigationBeech BE-200 · Moulins, FranceNov 24, 2001 · F-GDLE · DestroyedNTSB DCA02WA008Accident · 24 fatalForeign investigationBritish Aerospace Avro RJ100 · Zurich, SwitzerlandNov 24, 2001 · DestroyedNTSB IAD02WA008Accident · 1 fatalForeign investigationBell Bell 47-G2 · Fabregues, FranceOct 27, 2001 · F-BXXZNTSB WAS02WA003Accident · 2 fatalForeign investigationRobinson R-22 · San Salvador, El SalvadorOct 26, 2001 · YS-1020P · DestroyedNTSB DCA02WA005Accident · 2 fatalForeign investigationFairchild Swearingen SA-226-TC · Shamattawa, Man, CanadaOct 12, 2001 · C-GYPA · DestroyedNTSB DCA02WA004Accident · 10 fatalForeign investigationSwearingen Metroliner · Mediterranean, SpainOct 10, 2001 · DestroyedNTSB DCA02RA002Accident · 118 fatalForeign investigationCessna CitationJet 2 · Milan, ItalyOct 8, 2001 · D-IEVX · 2 aircraftNTSB WAS02WA001Accident · 3 fatalForeign investigationBell 412HP · Los Cabos, MexicoOct 7, 2001 · XA-SPZ · DestroyedNTSB WAS01RA026Accident · 8 fatalForeign investigationLet 410 UVP-E · Guatemala City, GuatemalaSep 18, 2001 · TG-CFENTSB ENG01RA010Incident · 1 fatalForeign investigationFokker F28 Mk 100 · Belo Horizonte, BrazilSep 15, 2001 · PT-MRNNTSB WAS01RA025Accident · 19 fatalForeign investigationLet 410 UVP-E · Chichen Itza, MexicoSep 12, 2001 · XA-ACMNTSB WAS01WA028Accident · 8 fatalForeign investigationCessna TU206G · Baborigame, MexicoSep 8, 2001 · XA-PID · DestroyedNTSB DCA01WA059Accident · 4 fatalForeign investigationCASA 235 · Malaga, SpainAug 29, 2001 · DestroyedNTSB MIA01RA225Accident · 9 fatalForeign investigationCessna 402B · Marsh Harbour, BahamasAug 25, 2001 · N8097WNTSB IAD01WA081Accident · 2 fatalForeign investigationCessna T210M · Innsbruck, AustriaAug 12, 2001 · N645LS · DestroyedNTSB NYC01WA207Accident · 2 fatalForeign investigationHughes 369D · Baffin Island, CanadaAug 9, 2001 · C-GYTY · DestroyedNTSB MIA01WA214Accident · 5 fatalForeign investigationCessna 210 · Barcelonette, FranceAug 8, 2001 · OO-SGI · DestroyedNTSB ENG01RA005Incident · 3 fatalForeign investigationDassault Falcon 20 · Narsarsuaq, GreenlandAug 5, 2001 · D-CDNANTSB MIA01WA188Accident · 1 fatalForeign investigation206 · Minas Parapapoy, VenezuelaJul 16, 2001 · YV-2619P · Substantial damageNTSB MIA01WA183Accident · 1 fatalForeign investigationMooney M20M · Manhay, BelgiumJul 10, 2001 · N44AJ · DestroyedNTSB WAS01RA011Accident · 2 fatalForeign investigationRobinson R-44 · La Fortuna, ParaguayJul 8, 2001 · ZP-PHRANTSB WAS01WA015Accident · 8 fatalForeign investigationSikorsky S-76B · P'ohang, South KoreaJul 5, 2001 · HL9240 · DestroyedNTSB WAS01RA013Accident · 2 fatalForeign investigationCessna U206G · San Ignacio, BoliviaJul 3, 2001 · CP-1644NTSB MIA01WA184Accident · 1 fatalForeign investigationCessna 172 · Sonnblick, AustriaJul 1, 2001 · D-EZMB · DestroyedNTSB MIA01WA177Accident · 6 fatalForeign investigationCessna 206 · Baborigame, MexicoJun 25, 2001 · XA-SFT · DestroyedNTSB NYC01WA162Accident · 4 fatalForeign investigationPiper PA-28-161 · Yverdon, SwitzerlandJun 22, 2001 · HB-PKL · 2 aircraft · Substantial damageNTSB NYC01WA159Accident · 1 fatalForeign investigationCessna 170B · Uxbridge, CanadaJun 20, 2001 · C-GKGG · 2 aircraft · Minor damageNTSB IAD01WA073Accident · 2 fatalForeign investigationCessna 210 · Petawa, Ontario, CanadaJun 18, 2001 · C-GPMC · Substantial damageNTSB IAD01WA064Accident · 3 fatalForeign investigationPiper 31-310 · Prince Edward, CanadaJun 5, 2001 · C-GMTT · Substantial damageNTSB WAS01WA010Accident · 3 fatalForeign investigationBell UH-IH · Taumarunui, New ZealandJun 4, 2001 · ZH-HJH · DestroyedNTSB IAD01WA065Accident · 1 fatalForeign investigationBell P-63A-7BE · Biggin Hill, United KingdomJun 3, 2001 · G-BTWR · DestroyedNTSB IAD01WA060Accident · 2 fatalForeign investigationBeech BE-36 · Berlin, GermanyMay 24, 2001 · D-EEJ6 · Substantial damageNTSB SEA01WA099Accident · 10 fatalForeign investigationCessna 172P · Kuwana Mie Pre., JapanMay 21, 2001 · 2 aircraft · DestroyedNTSB WAS01RA008Accident · 6 fatalForeign investigationBell 407 · Puerto Princesa, PhilippinesMay 18, 2001 · RP-C2345NTSB WAS01WA007Accident · 2 fatalForeign investigationCessna 182 · Zumatlan, MexicoMay 15, 2001 · XB-TAA · DestroyedNTSB MIA01WA141Accident · 2 fatalForeign investigationPiper PA-24-250 · Maldon Essex, United KingdomMay 12, 2001 · G-AIRE · Substantial damageNTSB IAD01WA057Accident · 2 fatalForeign investigationCessna 182S · Leicester, United KingdomMay 12, 2001 · G-BYEG · Substantial damageNTSB NYC01WA117Accident · 1 fatalForeign investigationPiper PA-42-1000 · Nurnberg, GermanyMay 5, 2001 · D-IMAY · DestroyedNTSB WAS01RA005Accident · 5 fatalForeign investigationCessna 182J · Coban, GuatemalaMay 4, 2001 · TG-CEG · DestroyedNTSB MIA01WA142Accident · 1 fatalForeign investigationCessna C-208 Caravan · Nagambie, AustraliaApr 29, 2001 · VH-MMV · DestroyedNTSB MIA01WA133Accident · 10 fatalForeign investigationCessna 208B · Roque Perez, ArgentinaApr 28, 2001 · LV-WSC · DestroyedNTSB NYC01WA104Accident · 3 fatalForeign investigationMooney M20E · Saint Mamet, FranceApr 22, 2001 · N200YS · DestroyedNTSB MIA01WA132Accident · 1 fatalForeign investigationBeech 55 · Carache, VenezuelaApr 18, 2001 · YV-2345P · DestroyedNTSB CHI01WA123Accident · 2 fatalForeign investigationCessna T310R · Madinah, Saudi ArabiaApr 18, 2001 · N700AS · Substantial damage