Skip to content

NTSB investigations, 2003, 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, 2003, 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") = 2003 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\") = 2003
    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") = 2003
  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 MIA04WA046Accident · No injuriesForeign investigationCessna 172 · Lamentin, MartiniqueDec 30, 2003 · N8547X · Substantial damage NTSB LAX04WA080Accident · 1 fatalForeign investigationPacific Aerospace 750XL · Pacific Ocean, New ZealandDec 26, 2003 · ZKUAC · Destroyed NTSB WAS04RA010Accident · 141 fatalForeign investigationBoeing 727-223 · Cotonou, BeninDec 25, 2003 · 3X-GDO NTSB FTW04WA050Accident · 1 fatalForeign investigationCessna 172 · Shiona, EcuadorDec 23, 2003 · HC-BAS · Destroyed NTSB DCA04WA014Accident · No injuriesForeign investigationBoeing 737-300 · Libreville, GabonDec 19, 2003 · TR-LFZ · Substantial damage NTSB FTW04WA048Accident · 2 fatalForeign investigationPiper PA-46 · Guaymas, MexicoDec 13, 2003 · N9223X · Destroyed NTSB DCA04WA010Accident · No injuriesForeign investigationBoeing 737-200 · Lima, PeruDec 13, 2003 · OB-1544 · Substantial damage NTSB MIA04WA033Accident · 2 fatalForeign investigationEurocopter France AS 350 B3 · Guayaramerim, BrazilDec 9, 2003 · N32TJ · Destroyed NTSB DCA04WA013Incident · No injuriesForeign investigationBoeing 737-800 · Goteberg, SwedenDec 7, 2003 · LN-RPL · No damage NTSB DCA04WA009Accident · 3 fatalForeign investigationSocata TBM-700 · Oxford, United KingdomDec 6, 2003 · N30LT · Destroyed NTSB FTW04WA034Accident · 2 fatalForeign investigationCessna R172E · Macas, EcuadorDec 1, 2003 · HC-BRE · Destroyed NTSB WAS04WA006Accident · No injuriesForeign investigationBoeing 747-200 · Lagos, NigeriaNov 29, 2003 · ZS-OOS · Substantial damage NTSB ENG04RA005Incident · No injuriesForeign investigationAirbus Industrie A320-322 · Birmingham, United KingdomNov 29, 2003 · G-EUUI NTSB MIA04WA032Accident · Minor injuriesForeign investigationCessna 206 · Alto Orinoco, VenezuelaNov 28, 2003 · YV-874C · Substantial damage NTSB MIA04WA031Accident · Minor injuriesForeign investigationCessna 210 · Santiago, ChileNov 28, 2003 · CC-PIK · Substantial damage NTSB MIA04WA030Accident · 4 fatalForeign investigationPiper PA-28R-201T · Caracas, VenezuelaNov 23, 2003 · YV-1528P · Destroyed NTSB FTW04WA033Accident · 2 fatalForeign investigationBeech BE-36 · Santa Cruz, BoliviaNov 22, 2003 · CP-2376 · Destroyed NTSB FTW04WA032Accident · 2 fatalForeign investigationCessna P337 · Versalles, BoliviaNov 21, 2003 · CP-1958 · Destroyed NTSB MIA04FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-32-300 · Missing, BahamasUndetermined.Nov 13, 2003 · N8224C · Destroyed NTSB LAX04WA148Accident · 2 fatalForeign investigationPiper PA-34-200 · New South Wales, AustraliaNov 13, 2003 · VH-CTT · Destroyed NTSB FTW04WA035Accident · 2 fatalForeign investigationBell 206L4 · Urucu, BrazilNov 13, 2003 · PT-YEE · Destroyed NTSB WAS04WA003Accident · No injuriesForeign investigationCessna 172N · Mannheim, GermanyNov 10, 2003 · N6473D · Substantial damage NTSB MIA04WA026Incident · No injuriesForeign investigationPiper PA-46-350P · Walkers Cay, BahamasNov 8, 2003 · N7KH · Minor damage NTSB MIA04WA021Accident · 1 fatalForeign investigationRobinson R-44 Raven II · Darien, PanamaNov 8, 2003 · HP-1481 · Destroyed NTSB MIA04WA020Accident · 2 fatalForeign investigationShort Brothers Skyvan SC7 · Georgetown, GuyanaNov 8, 2003 · 8R-GMC · Substantial damage NTSB LAX04WA040Accident · 4 fatalForeign investigationRobinson R44 · Derby, AustraliaNov 8, 2003 · VHYKL · Destroyed NTSB MIA04WA027Accident · Serious injuriesForeign investigationMitsubishi MU-2B-35 · Bonaire, NTNov 3, 2003 · N630HA · Substantial damage NTSB MIA04WA019Accident · Serious injuriesForeign investigationCessna 206C · Golfito, Costa RicaNov 3, 2003 · TI-AVH · Substantial damage NTSB MIA04WA017Accident · 2 fatalForeign investigationCessna 182P · Santa Elena, VenezuelaNov 2, 2003 · YV-933P · Destroyed NTSB MIA04WA018Accident · Serious injuriesForeign investigationAyres S2R-T34/510 · Sarapiqui, Costa RicaNov 1, 2003 · TI-AYE · Substantial damage NTSB FTW04WA017Accident · Serious injuriesForeign investigationBell 206B · Mexico City, MexicoOct 29, 2003 · XA-AFX · Substantial damage NTSB FTW04WA016Accident · 3 fatalForeign investigationRaytheon Corporate Jets Hawker 125 · Tampico, MexicoOct 27, 2003 · XA-ISH · Destroyed NTSB MIA04WA014Accident · 5 fatalForeign investigationFairchild FH227B · Buenos Aires, ArgentinaOct 26, 2003 · LV-MGV · Destroyed NTSB ATL04WA042Accident · 4 fatalForeign investigationCirrus Design SR-22 · Pamplona, SpainOct 12, 2003 · N100BR · Substantial damage NTSB DCA04WA003Incident · No injuriesForeign investigationBoeing 737-400 · Changi Airport, SingaporeOct 6, 2003 · 9M-MOK · Minor damage NTSB FTW04WA005Accident · 4 fatalForeign investigationCessna U-206G · El Peru, BoliviaOct 3, 2003 · CP-2169 · Destroyed NTSB DCA04WA007Accident · 2 fatalForeign investigationConvair Div. of Gen. Dynamics CV340/580 · Kapiti Coast, New ZealandOct 3, 2003 · ZK-KFU · Destroyed NTSB SEA04IA010Incident · No injuriesIncident investigationFinal reportBoeing 747-100 · Lyon, FranceAn undetermined malfunction in an aircraft system while in cruise flight leading to a fire in the engine number four B Loop portion (Card A16) of the fire detection controls cardfile.Oct 2, 2003 · N479EV · Minor damage NTSB LAX04WA006Accident · 5 fatalForeign investigationPiper PA-23-250 · Queensland, AustraliaOct 1, 2003 · VH-WAC · Destroyed NTSB LAX03WA303Accident · 2 fatalForeign investigationRobinson R22 · Derby, AustraliaSep 28, 2003 · VH-UXF · Destroyed NTSB DCA04WA025Incident · No injuriesForeign investigationBoeing 777-300 · Chennai, IndiaSep 28, 2003 · EK404 · No damage NTSB MIA03WA188Accident · No injuriesForeign investigationMaule MX-7-160 · Eleuthera, BahamasSep 21, 2003 · N141DF · Substantial damage NTSB FTW03WA234Accident · No injuriesForeign investigationPiper PA-60 · Pavas, Costa RicaSep 21, 2003 · N713HM · Substantial damage NTSB FTW03WA227Accident · 1 fatalForeign investigationAero Commander 690 · Soto La Marina, MexicoSep 16, 2003 · N302WB · Destroyed NTSB FTW03WA228Accident · 2 fatalForeign investigationPiper PA-31 · Uraba, ColombiaSep 13, 2003 · XB-BAQ · Destroyed NTSB FTW03WA226Accident · 8 fatalForeign investigationCessna 402B · Tecalitran, MexicoSep 13, 2003 · XB-FTA · Destroyed NTSB DCA03WA056Accident · 9 fatalForeign investigationBeech King Air B200 · Madeira Islands, PortugalSep 12, 2003 · N600BV · Destroyed NTSB FTW03WA214Accident · Serious injuriesForeign investigationCessna 152 · Tocumen, PanamaSep 4, 2003 · HP1426AS · Substantial damage NTSB FTW03WA215Accident · 4 fatalForeign investigationBell 206L-3 · Solola, GuatemalaSep 1, 2003 · TG-HDG · Destroyed NTSB NYC03WA191Accident · 4 fatalForeign investigationCessna 172N · Malaga, SpainAug 29, 2003 · EC-EUK · Destroyed