Skip to content

Fatal NTSB investigations, 2003, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

Fatal NTSB investigations, 2003, Outside the U.S. per year, 1962–2026: 3,270 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	108

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' 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\") = 2003
    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") = 2003
  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 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 FTW04WA048Accident · 2 fatalForeign investigationPiper PA-46 · Guaymas, MexicoDec 13, 2003 · N9223X · Destroyed NTSB MIA04WA033Accident · 2 fatalForeign investigationEurocopter France AS 350 B3 · Guayaramerim, BrazilDec 9, 2003 · N32TJ · Destroyed 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 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 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 MIA04WA017Accident · 2 fatalForeign investigationCessna 182P · Santa Elena, VenezuelaNov 2, 2003 · YV-933P · Destroyed 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 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 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 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 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 NTSB FTW03WA210Accident · 3 fatalForeign investigationCessna R172K · Juan de Morros, VenezuelaAug 29, 2003 · YV-1739P · Destroyed NTSB MIA03WA172Accident · 1 fatalForeign investigationPiper PA-38-112 · Penalolen, ChileAug 27, 2003 · CC-CRY · Destroyed NTSB FTW03WA218Accident · 1 fatalForeign investigationPiper PA-28-140 · Chilpancingo, MexicoAug 16, 2003 · N1647J · Substantial damage NTSB LAX03WA281Accident · 1 fatalForeign investigationCessna 404 · Jandakot, AustraliaAug 11, 2003 · VH-ANV · Destroyed NTSB FTW03WA193Accident · 2 fatalForeign investigationCessna 185F · Prto. Echeverry, ColombiaAug 9, 2003 · HK-1661P · Destroyed NTSB MIA03WA156Accident · 1 fatalForeign investigationRobinson R-22 · Santo Domingo, Dominican RepublicAug 3, 2003 · HI-682SP · Destroyed NTSB NYC03WA174Accident · 1 fatalForeign investigationCessna 182T · Buckinghamshire, United KingdomAug 1, 2003 · N666JH · Substantial damage NTSB MIA03WA159Accident · 1 fatalForeign investigationCessna 551 · Sorocaba, BrazilJul 23, 2003 · PT-LME · Substantial damage NTSB WAS03WA017Accident · 3 fatalForeign investigationHughes 369HS · Sevenoaks, Kent, United KingdomJul 19, 2003 · G-CSPJ · Destroyed NTSB WAS03RA016Accident · 14 fatalForeign investigationSwearingen SA-226TC · Mount Kenya,, KenyaJul 19, 2003 · ZS-OYI NTSB MIA03WA147Accident · 1 fatalForeign investigationPiper PA-23-235 · Freeport, BahamasJul 18, 2003 · N4928P · Destroyed NTSB DCA03WA045Accident · 2 fatalForeign investigationLockheed L-188A · Cranbrook, CanadaJul 16, 2003 · C-GFQA · Destroyed NTSB WAS03WA014Accident · 4 fatalForeign investigationCessna 182 RG · Pianello/Carena, SwitzerlandJul 13, 2003 · N6412T · Destroyed NTSB MIA03FA141Accident · 2 fatalClass 1 · FieldFinal reportCessna 402C · Treasure Cay, Bahamasthe in-flight failure of the right engine and the pilot’s failure to adequately manage the airplane’s performance after the engine failed. The right engine failure resulted from inadequate maintenance that was performed by Air Sunshine’s maintenance personnel…Jul 13, 2003 · N314AB · Substantial damage NTSB ENG04WA019Accident · 3 fatalForeign investigationBeech A-36 · Miyazaki Airpor, JapanJul 11, 2003 · JA4166 · Destroyed NTSB MIA03WA142Accident · 3 fatalForeign investigationBeech S-35 · San Vito Java, Costa RicaJul 10, 2003 · N80695 · Destroyed NTSB WAS03RA019Accident · 115 fatalForeign investigationBoeing 737-200 · Port Sudan, SudanJul 8, 2003 · ST-AFK · Destroyed NTSB CHI03WA198Accident · 1 fatalForeign investigationBeech BE-58TC · Toronto, CanadaJul 7, 2003 · N6058T · Substantial damage NTSB MIA03WA137Accident · 2 fatalForeign investigationPiper PA-34-220T · Estancia, ParaguayJul 5, 2003 · PT-VOO · Destroyed NTSB MIA03WA136Accident · 1 fatalForeign investigationCessna 182 · Uriman, VenezuelaJul 5, 2003 · YV-1015P · Destroyed