Skip to content

NTSB investigations, 2004, 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, 2004, 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") = 2004 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\") = 2004
    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") = 2004
  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 WAS05WA005Accident · Minor injuriesForeign investigationRobinson Helicopters R44 · Vlakfontein Far, South AfricaDec 31, 2004 · ZS-RPZ · Substantial damage NTSB SEA05WA031Accident · 1 fatalForeign investigationRobinson R-44 II · Fairmont Hot Sp, CanadaDec 28, 2004 · N313AL · Destroyed NTSB NYC05WA032Accident · 3 fatalForeign investigationBeech 65-90 · Montpellier, FranceDec 24, 2004 · F-GVRM · Destroyed NTSB LAX05WA072Accident · 3 fatalForeign investigationRobinson R44 · Saga, JapanDec 24, 2004 · JA44RH · Substantial damage NTSB DCA05WA019Accident · Serious injuriesForeign investigationShort Brothers SD3-60 · Ontario, CanadaDec 17, 2004 · N748CC · Destroyed NTSB DFW05WA039Accident · 5 fatalForeign investigationAero Commander AC-685 · Apodaca, MexicoDec 14, 2004 · XB-GSG · Destroyed NTSB DCA05WA022Incident · No injuriesForeign investigationBoeing 747-200 · Incheon, South KoreaDec 14, 2004 · TF-ARH · Minor damage NTSB DCA05WA020Incident · No injuriesForeign investigationBoeing 747 · London, United KingdomDec 12, 2004 · N523MC · No damage NTSB DFW05WA035Accident · 2 fatalForeign investigationBeech BE-36-TC · Pereira, ColombiaDec 10, 2004 · hk4349P · Destroyed NTSB DFW05WA036Accident · 6 fatalForeign investigationCessna TU206G · La Macarena, ColombiaDec 7, 2004 · HK2882 · Destroyed NTSB DCA05WA023Accident · No injuriesForeign investigationGulfstream Aerospace G-IV · Bucharest, RomaniaDec 6, 2004 · N478GS · Substantial damage NTSB CHI05WA046Accident · No injuriesForeign investigationCessna 560XL · Stockholm, SwedenDec 1, 2004 · SE-DYX · Substantial damage NTSB SEA05WA020Accident · 2 fatalForeign investigationPiper PA-34-200T · Mt. Taranaki, New ZealandNov 30, 2004 · ZK-JAN · Destroyed NTSB IAD05RA020Accident · 25 fatalForeign investigationMcDonnell Douglas MD-82 · Solo City, IndonesiaNov 30, 2004 · PK-LMN NTSB SEA05WA021Accident · Serious injuriesForeign investigationBeech E33 · Yao Airport, JapanNov 27, 2004 · JA3435 · Destroyed NTSB LAX05WA048Accident · Serious injuriesForeign investigationRobinson R22B · Taumaranui, New ZealandNov 27, 2004 · ZK-HWP · Destroyed NTSB IAD05FA023Accident · 6 fatalClass 1 · FieldFinal reportCASA 212-200-CC · Bamiyan, Afghanistanthe captain's inappropriate decision to fly a nonstandard route and his failure to maintain adequate terrain clearance, which resulted in the inflight collision with mountainous terrain. Factors were the operator's failure to require its flight crews to file…Nov 27, 2004 · N960BW · Destroyed NTSB DCA05RA010Accident · 55 fatalForeign investigationBombardier CRJ-200 · Baotou, ChinaNov 21, 2004 · B3072 NTSB MIA05WA031Accident · 4 fatalForeign investigationBritish Aerospace 3101 · Caracas, VenezuelaNov 18, 2004 · YV-1083C · Destroyed NTSB IAD05WA016Accident · No injuriesForeign investigationRobinson R-22B · Biggin Hill, United KingdomNov 15, 2004 · GDERB · Substantial damage NTSB NYC05WA015Accident · 1 fatalForeign investigationRobinson R-22B · Bishopton, United KingdomNov 11, 2004 · G-TGRR · Destroyed NTSB MIA05WA023Accident · 5 fatalForeign investigationCessna 310 · San Salvador, El SalvadorNov 11, 2004 · TG-WOT · Destroyed NTSB ATL05WA029Accident · No injuriesForeign investigationRobinson R22 · Madrid, SpainNov 10, 2004 · EC-GAU · Substantial damage NTSB DCA05WA008Incident · No injuriesForeign investigationBoeing B767-200 · Manchester, United KingdomNov 7, 2004 · GSATR · 2 aircraft · Minor damage NTSB DCA05WA005Accident · No injuriesForeign investigationBoeing B747-230C · Sharjah, United Arab EmiratesNov 7, 2004 · TFARR · Substantial damage NTSB DCA05WA007Incident · No injuriesForeign investigationBoeing B747-300 · Paris, FranceNov 4, 2004 · D2-TEB · Minor damage NTSB DCA05WA006Accident · Minor injuriesForeign investigationBoeing B737-300 · Kota Kinabalu, MalaysiaNov 4, 2004 · 9M-AAP · Minor damage NTSB MIA05WA025Accident · Minor injuriesForeign investigationPiper PA-23-250 · Nassau, BahamasNov 3, 2004 · N5474Y · Substantial damage NTSB DFW05WA013Accident · Serious injuriesForeign investigationBölkow BO-105-LS · Puerto Plata, Dominican RepublicOct 31, 2004 · HI-6875P · Substantial damage NTSB MIA05WA026Accident · Minor injuriesForeign investigationCessna 337G · San Fernando, ArgentinaOct 29, 2004 · LV-WHH · Substantial damage NTSB SEA05WA018Accident · No injuriesForeign investigationBeech C23 · Nagasaki, JapanOct 24, 2004 · JA3683 · Substantial damage NTSB SEA05WA012Accident · 1 fatalForeign investigationCessna F-406 · Inverness, United KingdomOct 22, 2004 · G-TWIG · Substantial damage NTSB MIA05WA010Accident · No injuriesForeign investigationBeech 1900C · Nassau, BahamasOct 22, 2004 · N79YV · Substantial damage NTSB WAS05WA001Accident · No injuriesForeign investigationCessna 208B · Loiborsoit, TanzaniaOct 19, 2004 · 5H-AXL · Substantial damage NTSB DCA05WA001Incident · No injuriesForeign investigationBoeing 757 · ArgentinaOct 19, 2004 · T-01 · No damage NTSB ENG05RA001Incident · No injuriesForeign investigationBoeing 777 · Saint-Denis, RéunionimportOct 18, 2004 · F-OPAR · Minor damage NTSB MIA05WA007Accident · 3 fatalForeign investigationDouglas DC-3C · Medellin, ColombiaOct 15, 2004 · HK-1503 · Destroyed NTSB DCA05RA002Accident · 7 fatalForeign investigationBoeing 747-244BC · Halifax, CanadaOct 14, 2004 · 9G-MKJ NTSB MIA05WA004Accident · No injuriesForeign investigationCessna 210 · Freeport, BahamasOct 13, 2004 · N357RB · Destroyed NTSB DCA05WA014Incident · No injuriesForeign investigationBoeing 737-800 · Perth, AustraliaOct 11, 2004 · VH-VOF · Minor damage NTSB CHI05WA008Accident · 4 fatalForeign investigationPiper PA-46-310P · Dijon Longvic, FranceOct 9, 2004 · N20VP · Substantial damage NTSB MIA05WA005Accident · 1 fatalForeign investigationPiper PA-38-112 · Rio Negro, ArgentinaOct 3, 2004 · LV-OFE · Destroyed NTSB DFW05WA014Accident · 2 fatalForeign investigationGarlick UH-1H · San Felipe, ChileSep 25, 2004 · CC-CNJ · Substantial damage NTSB ATL04WA194Accident · 3 fatalForeign investigationPiper PA-28-181 · Nordhorn-Lingen, GermanySep 24, 2004 · PH-TWG · Destroyed NTSB CHI04WA277Accident · 1 fatalForeign investigationPiper PA-28-181 · Wilhelmshausen, GermanySep 23, 2004 · D-ECBG · Destroyed NTSB NYC04WA215Accident · 1 fatalForeign investigationRobinson R-44 · Kentallen, Scot, United KingdomSep 19, 2004 · G-SPAL · Destroyed NTSB IAD04WA049Accident · 4 fatalForeign investigationCessna 182R · Montreux, SwitzerlandSep 19, 2004 · HB-CJB · Destroyed NTSB CHI04WA294Accident · No injuriesForeign investigationLake LA-4-200 · Kolari, FinlandSep 19, 2004 · OH-AKF · Destroyed NTSB IAD04WA047Accident · 3 fatalForeign investigationRobinson R44 · Vattlefjall, SwedenSep 11, 2004 · SE-JHJ · Substantial damage NTSB WAS04WA015Accident · 6 fatalForeign investigationCessna 210 · Livingstone, ZambiaSep 9, 2004 · ZS-KOX · Destroyed