Skip to content

NTSB investigations, 2001, Outside the U.S.

180,598 investigations by the National Transportation Safety Board since 1962: 174,578 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

NTSB investigations, 2001, Outside the U.S. per year, 1962–2026: 9,095 cases
1962	9
1963	3
1964	108
1965	99
1966	106
1967	101
1968	64
1969	63
1970	70
1971	56
1972	79
1973	66
1974	65
1975	58
1976	16
1977	24
1978	36
1979	14
1980	5
1981	2
1982	5
1983	3
1984	7
1985	6
1986	8
1987	22
1988	41
1989	25
1990	30
1991	29
1992	36
1993	41
1994	42
1995	66
1996	61
1997	93
1998	134
1999	110
2000	159
2001	152
2002	134
2003	136
2004	154
2005	174
2006	181
2007	174
2008	174
2009	181
2010	227
2011	238
2012	259
2013	248
2014	219
2015	268
2016	319
2017	304
2018	337
2019	323
2020	257
2021	428
2022	429
2023	460
2024	492
2025	475
2026	390

Latest cases

Query with SQL

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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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'
  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") = 2001
  AND c."eventCountry" <> 'USA'
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 WAS02WA014Accident · 3 fatalForeign investigationCessna 337D · Piura, PeruDec 23, 2001 · N24EG · Destroyed NTSB ATL02WA022Accident · No injuriesForeign investigationCessna C205 · Bimini, BahamasDec 22, 2001 · N55VX · Substantial damage NTSB ATL02WA020Accident · 2 fatalForeign investigationCessna CE-560 · Zurich, SwitzerlandDec 20, 2001 · HB-VLV · Destroyed NTSB WAS02WA012Accident · Serious injuriesForeign investigationBell 412EP · Rio Frio, MexicoDec 18, 2001 · XC-PUE · Substantial damage NTSB WAS02WA011Accident · 1 fatalForeign investigationRobinson R22 · Phitippeburg, GermanyDec 11, 2001 · D-HLHL · Destroyed NTSB NYC02WA037Accident · Minor injuriesForeign investigationSchweizer 300C · Stockerau, AustriaDec 11, 2001 · OE-XAK · Substantial damage NTSB LAX02RA045Accident · 1 fatalForeign investigationBeech 200C · Mount Gambier, AustraliaDec 10, 2001 · VH-FMN NTSB WAS02WA010Accident · Minor injuriesForeign investigationBoeing Helicopters Div. 369E · Eberebruum, GermanyDec 8, 2001 · D-HFLY · Destroyed NTSB DCA02WA012Incident · No injuriesForeign investigationBoeing 767-323 · London, United KingdomDec 4, 2001 · N7375A · Minor damage NTSB MIA02WA043Accident · No injuriesForeign investigationPiper PA-32R-300 · Rum Cay, BahamasNov 30, 2001 · N6119J · Substantial damage NTSB WAS02RA006Accident · 3 fatalForeign investigationCessna 208 · Quepos, Costa RicaNov 28, 2001 · HP-1405 NTSB DCA02WA011Incident · No injuriesForeign investigationAirbus Industrie A300-600 · Lima, PeruNov 28, 2001 · N7055A · No damage NTSB WAS02WA008Accident · No injuriesForeign investigationLet 410 UVP-E · Playa De Carmen, MexicoNov 27, 2001 · XA-SJY · Destroyed NTSB WAS02WA007Accident · 9 fatalForeign investigationBell UH-1H · El Limon, El SalvadorNov 27, 2001 · 66-16590 · Destroyed NTSB ENG02RA004Incident · No injuriesForeign investigationBoeing 767-238 · Melbourne, AustraliaNov 27, 2001 · VH-EAQ NTSB DCA02WA010Accident · No injuriesForeign investigationBoeing 747-200F · Port Harcourt, NigeriaNov 27, 2001 · 9G-MKI · Destroyed NTSB WAS02WA009Accident · No injuriesForeign investigationCessna 550 · Mexico City, MexicoNov 26, 2001 · XC-PGP · Substantial damage NTSB DCA02WA009Accident · 4 fatalForeign investigationBeech BE-200 · Moulins, FranceNov 24, 2001 · F-GDLE · Destroyed NTSB DCA02WA008Accident · 24 fatalForeign investigationBritish Aerospace Avro RJ100 · Zurich, SwitzerlandNov 24, 2001 · Destroyed NTSB ENG02RA003Incident · No injuriesForeign investigationBoeing 747-200 · Jakarta, IndonesiaNov 23, 2001 NTSB DCA02WA007Accident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Taipei, TaiwanNov 20, 2001 · B-16101 · Substantial damage NTSB WAS02RA016Accident · Serious injuriesForeign investigationBell 206B · Maracaibo, VenezuelaNov 4, 2001 · YV-OGEZ NTSB DCA02WA006Accident · Serious injuriesForeign investigationBoeing 737-300 · Nairobi, KenyaNov 1, 2001 · 5Y-KQD · Substantial damage NTSB WAS02WA004Accident · No injuriesForeign investigationLearjet 25B · Ciudad Victoria, MexicoOct 27, 2001 · N715MH · Substantial damage NTSB IAD02WA008Accident · 1 fatalForeign investigationBell Bell 47-G2 · Fabregues, FranceOct 27, 2001 · F-BXXZ NTSB WAS02WA003Accident · 2 fatalForeign investigationRobinson R-22 · San Salvador, El SalvadorOct 26, 2001 · YS-1020P · Destroyed NTSB DCA02WA005Accident · 2 fatalForeign investigationFairchild Swearingen SA-226-TC · Shamattawa, Man, CanadaOct 12, 2001 · C-GYPA · Destroyed NTSB WAS02WA005Accident · No injuriesForeign investigationBell 407 · Copiapo, ChileOct 11, 2001 · CC-PBZ · Substantial damage NTSB MIA02WA068Accident · Serious injuriesForeign investigationPiper PA-25-150 · Marcos Juarez, ArgentinaOct 11, 2001 · LV-HJF · Substantial damage NTSB DCA02WA004Accident · 10 fatalForeign investigationSwearingen Metroliner · Mediterranean, SpainOct 10, 2001 · Destroyed NTSB DCA02RA002Accident · 118 fatalForeign investigationCessna CitationJet 2 · Milan, ItalyOct 8, 2001 · D-IEVX · 2 aircraft NTSB WAS02WA001Accident · 3 fatalForeign investigationBell 412HP · Los Cabos, MexicoOct 7, 2001 · XA-SPZ · Destroyed NTSB MIA01WA232Accident · No injuriesForeign investigationFairchild SA 227-TT Merlin · SanJose Guaribe, VenezuelaSep 29, 2001 · YV652CP · Substantial damage NTSB DCA01WA061Incident · No injuriesForeign investigationDouglas DC-8 · Mexico City, MexicoSep 24, 2001 · N806DH · No damage NTSB WAS01RA026Accident · 8 fatalForeign investigationLet 410 UVP-E · Guatemala City, GuatemalaSep 18, 2001 · TG-CFE NTSB ENG01RA010Incident · 1 fatalForeign investigationFokker F28 Mk 100 · Belo Horizonte, BrazilSep 15, 2001 · PT-MRN NTSB WAS01RA025Accident · 19 fatalForeign investigationLet 410 UVP-E · Chichen Itza, MexicoSep 12, 2001 · XA-ACM NTSB WAS01WA028Accident · 8 fatalForeign investigationCessna TU206G · Baborigame, MexicoSep 8, 2001 · XA-PID · Destroyed NTSB ATL01WA106Accident · Serious injuriesForeign investigationBoeing B767-332 · Buenos Aires, ArgentinaSep 7, 2001 · N194DN · No damage NTSB WAS01RA024Accident · Minor injuriesForeign investigationSaab-Scania 340B · Tijuana, MexicoSep 6, 2001 · XA-ACK NTSB ATL01WA107Accident · No injuriesForeign investigationBell TH-1F · Puerto Plata, Dominican RepublicSep 5, 2001 · N8123H · Substantial damage NTSB ENG01WA009Incident · No injuriesForeign investigationExtra Flugzeugbau 400 · Rorvik, NorwaySep 2, 2001 · D-ETAW · Substantial damage NTSB MIA01WA235Accident · Serious injuriesForeign investigationCessna 421 · Carcassome, FranceAug 30, 2001 · F-GAPR · Destroyed NTSB DCA01WA059Accident · 4 fatalForeign investigationCASA 235 · Malaga, SpainAug 29, 2001 · Destroyed NTSB MIA01WA221Accident · No injuriesForeign investigationCessna U206G · Valencia, VenezuelaAug 25, 2001 · YV856P · Substantial damage NTSB MIA01RA225Accident · 9 fatalForeign investigationCessna 402B · Marsh Harbour, BahamasAug 25, 2001 · N8097W NTSB DCA01WA062Incident · Minor injuriesForeign investigationAirbus Industrie A330-200 · Terceira-Azores, PortugalAug 24, 2001 · C-GITS · Minor damage NTSB IAD01WA081Accident · 2 fatalForeign investigationCessna T210M · Innsbruck, AustriaAug 12, 2001 · N645LS · Destroyed NTSB NYC01WA207Accident · 2 fatalForeign investigationHughes 369D · Baffin Island, CanadaAug 9, 2001 · C-GYTY · Destroyed NTSB MIA01WA214Accident · 5 fatalForeign investigationCessna 210 · Barcelonette, FranceAug 8, 2001 · OO-SGI · Destroyed