Skip to content

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

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

Fatal NTSB investigations, 2002, Outside the U.S. per year, 1962–2026: 3,269 cases
1962	1
1964	20
1965	18
1966	15
1967	16
1968	16
1969	14
1970	14
1971	11
1972	17
1973	16
1974	11
1975	11
1976	1
1977	6
1978	11
1979	2
1981	1
1982	1
1983	1
1984	3
1985	3
1986	2
1987	9
1988	11
1989	8
1990	8
1991	9
1992	11
1993	11
1994	10
1995	24
1996	37
1997	37
1998	43
1999	53
2000	77
2001	66
2002	59
2003	71
2004	75
2005	97
2006	89
2007	87
2008	90
2009	90
2010	98
2011	120
2012	119
2013	124
2014	107
2015	130
2016	131
2017	133
2018	137
2019	140
2020	91
2021	107
2022	125
2023	98
2024	110
2025	109
2026	107

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

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") = 2002
  AND c."eventCountry" <> 'USA'
  AND c."highestInjuryLevel" = 'Fatal'
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 SEA03WA030Accident · 2 fatalForeign investigationLancair IV · Geelong, AustraliaDec 20, 2002 · VH-CIV · Destroyed NTSB MIA03WA032Accident · 3 fatalForeign investigationPiper PA-46-500TP · Badearic Island, SpainDec 19, 2002 · N53328 · Destroyed NTSB LAX03WA221Accident · 3 fatalForeign investigationPiper PA-31-325 · Fielding, New ZealandDec 17, 2002 · ZKTZC · Destroyed NTSB MIA03WA042Accident · 2 fatalForeign investigationCessna 206 · El Carmen, ColombiaDec 15, 2002 · YV1032CP · Substantial damage NTSB MIA03WA031Accident · 2 fatalForeign investigationPiper PA-23-250 · Freeport, BahamasDec 13, 2002 · N6568Y · Destroyed NTSB MIA03WA027Accident · 4 fatalForeign investigationCessna U206G · Pucallpa, PeruDec 7, 2002 · OB1180 · Destroyed NTSB MIA03WA017Accident · 7 fatalForeign investigationPiper PA-23-250 · San Carlos, ArgentinaNov 17, 2002 · LV-HJE · Destroyed NTSB FTW03WA043Accident · 2 fatalForeign investigationCessna 182M · Gonzaga, MexicoNov 15, 2002 · N70685 · Destroyed NTSB FTW03WA042Accident · 2 fatalForeign investigationPiper PA-28-236 · Polvaredas, ArgentinaNov 11, 2002 · CC-PMG · Destroyed NTSB FTW03WA032Accident · 1 fatalForeign investigationPiper PA-31-350 · Cambita, Dominican RepublicNov 4, 2002 · N74946 · Destroyed NTSB FTW03WA031Accident · 1 fatalForeign investigationCanadair F-86 · San Isidro, Dominican RepublicNov 4, 2002 · N30CJ · Destroyed NTSB FTW03WA021Accident · 4 fatalForeign investigationPiper PA-34-200T · Caraballeda, VenezuelaOct 28, 2002 · YV2459P · Destroyed NTSB FTW03WA020Accident · 2 fatalForeign investigationBell 430 · Jalapa, MexicoOct 19, 2002 · XC-DPC · Destroyed NTSB FTW03WA014Accident · 2 fatalForeign investigationCessna 182F · Tarapoto, PeruOct 15, 2002 · OB-669 · Destroyed NTSB WAS03WA001Accident · 1 fatalForeign investigationAgusta 119A · Godensee, AustriaOct 14, 2002 · OE-XSB · No damage NTSB NYC03WA036Accident · 1 fatalForeign investigationCessna 172M · Belwaarde, SurinameOct 10, 2002 · PZ-NAI · Substantial damage NTSB FTW03WA012Accident · 2 fatalForeign investigationBellanca 17-30 · Bogota, ColombiaOct 9, 2002 · HK-4234P · Destroyed NTSB FTW02RA259Accident · 6 fatalForeign investigationCessna U206G · Atalaya, PeruSep 12, 2002 · OB-1226 NTSB FTW02WA260Accident · 5 fatalForeign investigationCessna 310R · San Salvador, El SalvadorSep 9, 2002 · TG-WOT · Destroyed NTSB WAS02WA051Accident · 1 fatalForeign investigationHughes 269C · Dannevirke, New ZealandAug 16, 2002 · ZK-HFW · Destroyed NTSB NYC02WA164Accident · 3 fatalForeign investigationPiper PA-44-180 · Lake Vossemeer, NetherlandsAug 14, 2002 · PH-MLH · Destroyed NTSB MIA02WA142Accident · 4 fatalForeign investigationCessna F172N · Nykoebing Mors, DenmarkJul 30, 2002 · OY-BNE · Destroyed NTSB FTW02WA215Accident · 3 fatalForeign investigationCessna T210M · Urrao, ColombiaJul 24, 2002 · HK-3824P · Destroyed NTSB FTW02WA213Accident · 6 fatalForeign investigationCessna 206 · Guachochi, MexicoJul 21, 2002 · XA-LIV · Destroyed NTSB ATL02LA144Accident · 5 fatalLimited investigationFinal reportPiper PA-32RT-300 · Atlantic Ocean, BahamasThe pilot continued VFR flight into IMC and thunderstorm conditions which resulted in spatial disorientation and subsequent loss of control of the airplane.Jul 20, 2002 · N9738C · Destroyed NTSB DCA02WA048Accident · 23 fatalForeign investigationBoeing 707 · Bangui, Central African RepublicJul 4, 2002 · 9XR-IS · Destroyed NTSB DCA02RA047Accident · 71 fatalForeign investigationBoeing 757-23F · Uberlingen, GermanyJul 1, 2002 · A9C-DHL · 2 aircraft NTSB WAS02WA045Accident · 2 fatalForeign investigationSchweizer 269C · Paderborn-Lipsd, GermanyJun 6, 2002 · D-HMIN · Destroyed NTSB WAS02WA046Accident · 4 fatalForeign investigationBell 206B (II) · Dhoyntji, AustraliaJun 5, 2002 · VH-PHQ · Destroyed NTSB WAS02WA054Accident · 3 fatalForeign investigationHawker Siddeley 748 · George, South AfricaJun 1, 2002 · ZS-OJY · Destroyed NTSB ATL02WA116Accident · 2 fatalForeign investigationAero Commander 500-B · Roseau, DominicaMay 31, 2002 · N78336 · Destroyed NTSB DCA02RA038Accident · 206 fatalForeign investigationBoeing 747-200 · Makung Island, TaiwanMay 25, 2002 NTSB ATL02WA109Accident · 1 fatalForeign investigationCessna 210F · Grand Cayman, Cayman IslandsMay 23, 2002 · N5816F · Substantial damage NTSB WAS02WA043Accident · 1 fatalForeign investigationMcDonnell Douglas 369HS · PremierGameFarm, South AfricaMay 21, 2002 · ZS-HNE · Substantial damage NTSB FTW02WA144Accident · 4 fatalForeign investigationCessna 172 · Mamayac, EcuadorMay 7, 2002 · HC-CBV · Destroyed NTSB DCA02RA034Accident · 14 fatalForeign investigationBoeing 737-500 · Tunis, TunisiaMay 7, 2002 · SU-GBI NTSB WAS02WA040Accident · 3 fatalForeign investigationPiper PA-28 · Edenkoben, GermanyMay 3, 2002 · PH-ASL · Destroyed NTSB WAS02RA036Accident · 6 fatalForeign investigationCessna TU206G · Catacamas, HondurasApr 24, 2002 · N7344N · Destroyed NTSB DCA02WA033Accident · 3 fatalForeign investigationCommander 112TC · Milan, ItalyApr 18, 2002 · HB-NCX · Destroyed NTSB WAS02WA035Accident · 4 fatalForeign investigationCessna 172 · Pico, Duarte, Dominican RepublicApr 17, 2002 · HI-375 · Destroyed NTSB DCA02RA032Accident · 138 fatalForeign investigationBoeing 767-200ER · Pusan, South KoreaApr 15, 2002 · B-2552 NTSB DCA02WA031Accident · 2 fatalForeign investigationSwearingen Metro SW3 · PalmaDeMallorca, SpainApr 12, 2002 · EC-GKR · Destroyed NTSB FTW02WA145Accident · 4 fatalForeign investigationCessna U206G · Santa Ana, BoliviaApr 5, 2002 · CP-1776 · Destroyed NTSB WAS02WA031Accident · 2 fatalForeign investigationPiper PA-38-112 · Newport, United KingdomApr 1, 2002 · G-CWFC · Destroyed NTSB WAS02WA030Accident · 1 fatalForeign investigationPiper PA-32R-301T · Ramstein, GermanyMar 28, 2002 · D-ENEC · Destroyed NTSB FTW02WA140Accident · 2 fatalForeign investigationCessna 152 · Tegucigalpa, HondurasMar 22, 2002 · HR-AHU · Destroyed NTSB WAS02WA028Accident · 1 fatalForeign investigationBell 206 B III · Anaco, VenezuelaMar 20, 2002 · YV-324C · Substantial damage NTSB WAS02WA026Accident · 2 fatalForeign investigationCessna U206G · San Antonio, PeruFeb 23, 2002 · OB-1230 · Destroyed NTSB NYC02WA063Accident · 1 fatalForeign investigationRobinson R-44 · Verona, ItalyFeb 21, 2002 · N110DD · Destroyed NTSB CHI02WA080Accident · 3 fatalForeign investigationCessna 421B · Libourne, FranceFeb 18, 2002 · F-GHUY · Substantial damage