Skip to content

NTSB investigations, 2002, 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, 2002, 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") = 2002 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\") = 2002
    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") = 2002
  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 MIA03WA052Accident · No injuriesForeign investigationCessna 208B · San Pedro, BelizeDec 27, 2002 · V3-HGH · Substantial damage NTSB WAS03WA005Accident · No injuriesForeign investigationCessna 404 · Windhoek, NamibiaDec 26, 2002 · V5-WAA · Substantial damage 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 IAD03WA023Accident · Minor injuriesForeign investigationCessna 206H · Lawa Antino, SurinameDec 12, 2002 · N5072T · Substantial damage NTSB ENG03WA004Incident · No injuriesForeign investigationBoeing 767-219ER · Brisbane, AustraliaDec 8, 2002 · ZK-NBC · Minor damage NTSB MIA03WA027Accident · 4 fatalForeign investigationCessna U206G · Pucallpa, PeruDec 7, 2002 · OB1180 · Destroyed NTSB ENG03RA003Incident · No injuriesForeign investigationBoeing 717 · Hobart,Tasmania, AustraliaNov 24, 2002 · VH-VQC NTSB WAS03WA002Accident · Minor injuriesForeign investigationBell 214B1 · Hanla Mountain, South KoreaNov 21, 2002 · HL-9132 · Substantial damage 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 MIA03WA013Accident · No injuriesForeign investigationCessna 310N · Stella Maris, BahamasNov 7, 2002 · N5059Q · Substantial damage 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 FTW03RA033Accident · Minor injuriesForeign investigationMcDonnell Douglas DC 9-32 · Monterrey, MexicoNov 1, 2002 · XA-AMF NTSB FTW03WA021Accident · 4 fatalForeign investigationPiper PA-34-200T · Caraballeda, VenezuelaOct 28, 2002 · YV2459P · Destroyed NTSB MIA03WA011Incident · No injuriesForeign investigationBoeing 767-300 · Buenos Aires, ArgentinaOct 21, 2002 · TFARA · Minor damage 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 ENG02WA014Incident · No injuriesClass 5 · ForeignSaab-Scania 227-AC · AustraliaThe Australian Transportation Safety Board (ATSB) requested assistance in obtaining information from Honeywell regarding the history of TPE331-11U 1st stage turbine blade failures and preventative maintenance action in connection with this failure. The ATSB…Oct 11, 2002 · 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 ENG03RA001Incident · No injuriesForeign investigationBoeing 717-200 · Launceton, AustraliaOct 4, 2002 · VH-VQC NTSB FTW02RA259Accident · 6 fatalForeign investigationCessna U206G · Atalaya, PeruSep 12, 2002 · OB-1226 NTSB DCA02WA057Incident · No injuriesForeign investigationDouglas DC-8-63 · Gander, Newfndl, CanadaSep 10, 2002 · N441J · Minor damage NTSB FTW02WA260Accident · 5 fatalForeign investigationCessna 310R · San Salvador, El SalvadorSep 9, 2002 · TG-WOT · Destroyed NTSB LAX02WA272Incident · No injuriesForeign investigationBoeing 747-419 · Auckland, New ZealandAug 30, 2002 · ZK-NBS NTSB SEA02WA173Accident · No injuriesForeign investigationCessna 180K · Pitt Meadows, CanadaAug 29, 2002 · N2658K · Substantial damage NTSB WAS02WA050Accident · No injuriesForeign investigationSchweizer -269C · Augsburg Bayern, GermanyAug 26, 2002 · D-HRIT · Substantial damage NTSB MIA02WA176Incident · No injuriesForeign investigationBoeing 767-332ER · Buenos Aires, ArgentinaAug 25, 2002 · N178DN · No damage NTSB NYC02WA175Accident · Serious injuriesForeign investigationCessna 310R · Saint Tropez, FranceAug 23, 2002 · N920RP · Substantial damage 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 FTW02WA241Accident · Serious injuriesForeign investigationCessna 172N · Tinaquillo, VenezuelaAug 12, 2002 · YV1856P · Substantial damage NTSB MIA02WA151Accident · No injuriesForeign investigationPiper PA-23-250B · Virgin Gorda, British Virgin IslandsAug 10, 2002 · N65CT · Substantial damage NTSB WAS02WA049Accident · Serious injuriesForeign investigationSikorsky S-61L · Prince George, CanadaAug 8, 2002 · N346AA · Substantial damage NTSB NYC02WA162Accident · Serious injuriesForeign investigationGulfstream Aerospace G-IV · Jinzhou, ChinaAug 5, 2002 · N12U · No damage NTSB MIA02WA142Accident · 4 fatalForeign investigationCessna F172N · Nykoebing Mors, DenmarkJul 30, 2002 · OY-BNE · Destroyed NTSB FTW02WA229Accident · Minor injuriesForeign investigationCessna T210N · Puerto Portillo, PeruJul 28, 2002 · OB-1261 · Substantial damage NTSB SEA02WA157Accident · No injuriesForeign investigationBell 206B · Prince George, CanadaJul 25, 2002 · N59584 · Substantial damage 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 FTW02RA232Accident · Minor injuriesForeign investigationGavilan 358 · Villavicencio, ColombiaJul 16, 2002 · HK4217X NTSB FTW02WA210Accident · Minor injuriesForeign investigationRobinson R44 · Bavaro, Dominican RepublicJul 13, 2002 · HI-757CA · Substantial damage