Fatal NTSB investigations, 2007, 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, 2007, 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\") = 2007
    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 LAX08WA045Accident · 1 fatalForeign investigationRobinson R-44 · Westgate Bridge, AustraliaDec 29, 2007 · VH-MEB · Substantial damageNTSB DFW08WA050Accident · 3 fatalForeign investigationCessna 172 · Boquete, PanamaDec 23, 2007 · HP762 · DestroyedNTSB NYC08WA065Accident · 1 fatalForeign investigationCirrus SR22 · Gurupi, BrazilDec 19, 2007 · PR-OGM · Substantial damageNTSB DEN08WA042Accident · 1 fatalForeign investigationReims F172 M · Chevroux, FranceDec 17, 2007 · FBVIF · DestroyedNTSB NYC08WA057Accident · 5 fatalForeign investigationBeech C90B · Kyiv, UkraineDec 9, 2007 · D-IBDH · Substantial damageNTSB MIA08WA060Accident · 2 fatalForeign investigationCessna T210 · Guario, VenezuelaDec 9, 2007 · YV-1221 · DestroyedNTSB DFW08WA043Accident · 1 fatalForeign investigationCessna 210 · Arteaga, MexicoDec 6, 2007 · XB-GTS · DestroyedNTSB DCA08RA015Accident · 57 fatalForeign investigationMcDonnell Douglas MD-83 · Isparta, TürkiyeNov 30, 2007 · TC-AKMNTSB DEN08WA037Accident · 1 fatalForeign investigationCirrus Design SR-20 · Jagel, GermanyNov 28, 2007 · N141CD · Substantial damageNTSB LAX08WA131Accident · 4 fatalForeign investigationCessna 337G · Inverloch, AustraliaNov 17, 2007 · VH-CHU · DestroyedNTSB ANC08WA021Accident · 2 fatalForeign investigationCessna 404 · Nakatsugawa, JapanNov 15, 2007 · JA-5257 · DestroyedNTSB DEN08WA029Accident · 1 fatalForeign investigationPiper PA-32R · Merrenberg, FranceNov 7, 2007 · F-HCDV · DestroyedNTSB MIA08RA013Accident · 8 fatalForeign investigationLearjet 35A · Sao Paulo, BrazilNov 4, 2007 · PT-OVCNTSB MIA08WA020Accident · 3 fatalForeign investigationRobinson R-44 · San Paulo, BrazilNov 1, 2007 · PT-YMF · DestroyedNTSB DFW08WA034Accident · 2 fatalForeign investigationVans RV4 · Palencia, SpainOct 28, 2007 · EC-ZNT · DestroyedNTSB ANC08WA016Accident · 2 fatalForeign investigationCessna 172 · Golden, CanadaOct 28, 2007 · C-GQZX · Substantial damageNTSB ANC08WA013Accident · 2 fatalForeign investigationRobinson R-22B · Yao-City, JapanOct 27, 2007 · JA-102D · Substantial damageNTSB ANC08WA012Accident · 3 fatalForeign investigationPiper PA-46 · Fairmont, CanadaOct 27, 2007 · C-GTCS · Substantial damageNTSB MIA08WA059Accident · 2 fatalForeign investigationCessna 182 · Araya, VenezuelaOct 23, 2007 · YV-2405 · Substantial damageNTSB DCA08WA010Accident · 2 fatalForeign investigationBeech A36 · Windhoek, NamibiaOct 22, 2007 · V5-KLB · DestroyedNTSB ANC08WA014Accident · 1 fatalForeign investigationPiper PA-34 · Vancouver, CanadaOct 19, 2007 · C-GHFD · DestroyedNTSB DEN08WA018Accident · 2 fatalForeign investigationNorth American T-6G · Neuchatel, SwitzerlandOct 17, 2007 · HB-RDC · DestroyedNTSB NYC08WA014Accident · 1 fatalClass 5 · ForeignSullivan Lancair IV · Great Harbor, BahamasOn October 13, 2007, at 1036 eastern daylight time, an amateur-built Lancair IV, N95HS, was destroyed when it encountered turbulence over Bahamian waters near Great Harbor Cay, Berry Islands. The certificated commercial pilot was presumed to be fatally…Oct 13, 2007 · N95HS · DestroyedNTSB ANC08WA015Accident · 3 fatalForeign investigationCessna 172 · Bamfield, CanadaOct 13, 2007 · C-GGVK · Substantial damageNTSB NYC08WA013Accident · 7 fatalForeign investigationHawker-Beechcraft BE-200 · Bogota, ColombiaOct 12, 2007 · HK-4222 · Substantial damageNTSB DCA08WA002Accident · 2 fatalForeign investigationGulfstream Aerospace Giib · Santo Domingo, VenezuelaOct 8, 2007 · XB-KKU · DestroyedNTSB DCA07WA064Accident · 2 fatalForeign investigationReims F406 · Entebbe, UgandaSep 26, 2007 · ZS-SSD · DestroyedNTSB DEN07WA164Accident · 2 fatalForeign investigationPiper PA-28-181 · Airolo, SwitzerlandSep 16, 2007 · HB-PGC · DestroyedNTSB DCA07RA063Accident · 89 fatalForeign investigationBoeing MD-82 · Phuket, ThailandSep 16, 2007 · HS-OMGNTSB DCA08WA009Accident · 2 fatalForeign investigationRobinson R44 · Johannesburg, South AfricaSep 9, 2007 · ZS-RWW · DestroyedNTSB DEN07WA159Accident · 2 fatalForeign investigationRobinson R-22 Beta · Buhl, GermanySep 8, 2007 · D-HZAK · Substantial damageNTSB DEN07WA147Accident · 2 fatalForeign investigationPiper PA-39 · Vannes, FranceAug 25, 2007 · N13PF · DestroyedNTSB MIA07WA135Accident · 2 fatalForeign investigationCessna U206G · Anaco, VenezuelaAug 22, 2007 · YV-1562 · DestroyedNTSB DFW07WA188Accident · 1 fatalForeign investigationPiper PA-25-235 · Tamoyo, Dominican RepublicAug 15, 2007 · HI-736TA · DestroyedNTSB ANC07WA091Accident · 3 fatalForeign investigationCirrus SR-22 · Spirit River, CanadaAug 13, 2007 · C-GIOO · Substantial damageNTSB DFW08WA037Accident · 3 fatalForeign investigationCessna 206 · Zihuatanejo, MexicoAug 12, 2007 · XA-ASQ · DestroyedNTSB DEN08WA039Accident · 20 fatalForeign investigationde Havilland DHC6-33 · Moorea, French PolynesiaAug 9, 2007 · FOIQI · DestroyedNTSB CHI07WA257Accident · 4 fatalForeign investigationPiper PA-28-140 · Sandown, United KingdomAug 5, 2007 · G-AVRP · Substantial damageNTSB WAS07WA013Accident · 1 fatalForeign investigationBell 412 EP · Eket, NigeriaAug 3, 2007 · 5N-BIQ · DestroyedNTSB CHI07WA256Accident · 4 fatalForeign investigationRobinson R44 · Lancastershire, United KingdomAug 3, 2007 · GOSSI · DestroyedNTSB DFW07WA176Accident · 2 fatalForeign investigationPiper PA-38-112 · Madrid, SpainAug 2, 2007 · EC-DRL · DestroyedNTSB LAX07WA239Accident · 2 fatalForeign investigationRockwell 500S · Melbourne, VIC, AustraliaAug 1, 2007 · VH-YJB · DestroyedNTSB DEN07WA129Accident · 1 fatalForeign investigationStein Skybolt · Ardfert, IrelandJul 29, 2007 · EI-CIZ · DestroyedNTSB NYC07WA180Accident · 5 fatalForeign investigationRobinson R44 · Izhevsk, RussiaJul 28, 2007 · RA-04203 · DestroyedNTSB DEN07WA125Accident · 1 fatalForeign investigationExpress Express 2000 ER · Basel, SwitzerlandJul 23, 2007 · HB-YMN · DestroyedNTSB DFW07WA166Accident · 1 fatalForeign investigationRobinson R22 Beta II · San Salvador, El SalvadorJul 22, 2007 · HR-ASO · DestroyedNTSB DFW07WA168Accident · 1 fatalForeign investigationBeech BE-36TC · Tlajomulco, MexicoJul 21, 2007 · XB-JCJ · DestroyedNTSB DCA07RA059Accident · 199 fatalForeign investigationAirbus Industrie A320-233 · Sao Paulo, BrazilJul 17, 2007 · PR-MBKNTSB ENG07WA039Accident · 1 fatalForeign investigationAerospatiale 350B1 · Ballynacally, County Clare, Republic of Ireland, IrelandJul 12, 2007 · IE-IHL · DestroyedNTSB DFW07WA159Accident · 9 fatalForeign investigationNorth American T39A · Culiacan, MexicoJul 5, 2007 · XA-TFL · Destroyed