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

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

Cases per year

19622026
Fatal NTSB investigations, 1996, Outside the U.S. per year, 1962–2026: 3,271 cases
19621
196420
196518
196615
196716
196816
196914
197014
197111
197217
197316
197411
197511
19761
19776
197811
19792
19811
19821
19831
19843
19853
19862
19879
198811
19898
19908
19919
199211
199311
199410
199524
199637
199737
199843
199953
200077
200166
200259
200371
200475
200597
200689
200787
200890
200990
201098
2011120
2012119
2013124
2014107
2015130
2016131
2017133
2018137
2019140
202091
2021107
2022125
202398
2024110
2025109
2026109

Latest cases

Query with SQL
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\") = 1996
    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.

NTSB DCA97WA014Accident · 3 fatalForeign investigationBell 206B · Madrid, SpainDec 16, 1996 · ECEXC · DestroyedNTSB DCA97WA068Accident · 1 fatalForeign investigationSikorsky S-76B · Omeath Ireland, IrelandDec 12, 1996 · GHAUG · DestroyedNTSB CHI97WA039Accident · 2 fatalForeign investigationLearjet 36 · Stephenville, IrelandDec 6, 1996 · N14TX · DestroyedNTSB DCA97WA011Accident · 125 fatalForeign investigationBoeing 767 · Comorso Islands, EthiopiaNov 23, 1996 · ETAIZ · DestroyedNTSB NYC97WA017Accident · 8 fatalForeign investigationPiper PA-31-310 · Nairobi, KenyaNov 13, 1996 · 5YALA · DestroyedNTSB DCA97WA007Accident · 349 fatalForeign investigationBoeing 747-168 · New Delhi, IndiaNov 12, 1996 · HZ-AIH · 2 aircraftNTSB NYC97WA016Accident · 2 fatalForeign investigationBell 206B3 · Dear, South AfricaNov 7, 1996 · ZSHKB · DestroyedNTSB NYC97WA015Accident · 8 fatalForeign investigationCessna 421 · Donzeil, FranceNov 7, 1996 · HBLRX · DestroyedNTSB MIA97WA018Accident · 14 fatalForeign investigationEmbraer EMB-110 · Flores, GuatemalaNov 1, 1996 · TGTPA · DestroyedNTSB MIA97WA017Accident · 2 fatalForeign investigationPiper PA-32-300 · St. Vincent, WNOct 31, 1996 · N970CA · DestroyedNTSB DCA97WA004Accident · 97 fatalForeign investigationFokker 100 · Sao Paulo, BrazilOct 31, 1996 · PTMRK · DestroyedNTSB MIA97RA011Accident · 34 fatalForeign investigationBoeing 707-323 · Manta, EcuadorOct 23, 1996 · N751MANTSB NYC97RA006Accident · 8 fatalForeign investigationPiper PA-31-350 · Eel River Cross, CanadaOct 20, 1996 · N744WNTSB MIA97WA015Accident · 3 fatalForeign investigationCessna 404 · Bolognesi, PeruOct 18, 1996 · CFYUQ · DestroyedNTSB MIA97WA009Accident · 3 fatalForeign investigationBeech 65-A90 · Itaguazurenda, BoliviaOct 11, 1996 · N3333D · Substantial damageNTSB DCA97RA001Accident · 70 fatalForeign investigationBoeing B-757-23A · Lima, PeruOct 2, 1996 · N52AWNTSB NYC96WA191Accident · 1 fatalForeign investigationLake LA-4 · Azores, PortugalSep 16, 1996 · N2664P · DestroyedNTSB MIA96WA230Accident · 8 fatalForeign investigationBell UH-1B · Concepcion, ArgentinaAug 15, 1996 · LVWAV · DestroyedNTSB NYC96WA175Accident · 2 fatalForeign investigationPiper PA-30 · North Italy, ItalyJul 13, 1996 · N8484Y · DestroyedNTSB FTW96WA310Accident · 2 fatalForeign investigationAerospatiale SA315B · La Peruanita, PeruJun 30, 1996 · N32074 · DestroyedNTSB MIA96WA169Accident · 2 fatalForeign investigationPiper PA-18-C23 · Iztapa, GuatemalaJun 23, 1996 · TGCUB · Substantial damageNTSB CHI96WA204Accident · 1 fatalForeign investigationPiper PA-24-250 · Pelican Narrows, CanadaJun 15, 1996 · N6541P · DestroyedNTSB MIA96WA140Accident · 2 fatalForeign investigationBeech 200 · Treasure Cay, BahamasMay 15, 1996 · N1865D · DestroyedNTSB DCA96RA046Accident · 33 fatalForeign investigationBoeing CT-42A · Dubrovnik, CroatiaApr 3, 1996 · N1149NTSB MIA96WA098Accident · 8 fatalForeign investigationCessna 402B · Punto Fijo, VenezuelaMar 13, 1996 · P4AVB · DestroyedNTSB MIA96WA150Accident · 3 fatalForeign investigationde Havilland DHC-6-200 · Bagua, PeruMar 9, 1996 · N245GW · DestroyedNTSB LAX96WA132Accident · 1 fatalForeign investigationCessna 421B · Vigan, PhilippinesMar 3, 1996 · N69905 · DestroyedNTSB DCA96RA034Accident · 123 fatalForeign investigationBoeing -737-222 · Arequipa, PeruMar 1, 1996 · OB145NTSB DCA96RA042Accident · 4 fatalForeign investigationCessna 337 · Havana, CubaFeb 24, 1996 · N2456S · 2 aircraftNTSB MIA96WA083Accident · 1 fatalForeign investigationCessna 207 · San Jose, Costa RicaFeb 20, 1996 · TIAGP · DestroyedNTSB NYC96WA070Accident · 5 fatalForeign investigationPiper PA-46 · ZambiaFeb 15, 1996 · N2514Q · DestroyedNTSB MIA96WA079Accident · 11 fatalForeign investigationAerospace Tech. of Australia N24A · Port-Au-Prince, HaitiFeb 12, 1996 · N224E · DestroyedNTSB DCA96RA030Accident · 189 fatalForeign investigationBoeing 757-200 · Puerto Plata, Dominican RepublicFeb 7, 1996 · TCGENNTSB LAX96RA116Accident · 8 fatalForeign investigationCessna 550 · Ensenada, MexicoFeb 6, 1996 · XASLQNTSB LAX96LA111Accident · 1 fatalLimited investigationFinal reportBell 47G-2A1 · Honiara, Solomon Islandsthe pilot and the ship crew's failure to assure the tie down strap was removed prior to liftoff.Jan 29, 1996 · N6569H · DestroyedNTSB MIA96WA058Accident · 5 fatalForeign investigationCessna 172 · Nassau, BahamasJan 7, 1996 · N55475 · Substantial damageNTSB MIA96WA056Accident · 3 fatalForeign investigationCessna 182M · Trujillo, HondurasJan 3, 1996 · N91682 · Substantial damage