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, newest first

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'
  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 DCA07WA064Accident · 2 fatalForeign investigationReims F406 · Entebbe, UgandaSep 26, 2007 · ZS-SSD · DestroyedNTSB MIA07WA156Accident · No injuriesForeign investigationPiper PA-46-350 · Bergamo, ItalySep 23, 2007 · I-BSAB · Substantial damageNTSB DCA08WA004Incident · No injuriesForeign investigationBoeing 737 · Bournemouth, United KingdomSep 23, 2007 · G-THOF · No damageNTSB DCA08WA001Accident · No injuriesForeign investigationBoeing 737-800 · Saga, JapanSep 20, 2007 · B-16805 · Substantial damageNTSB 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 CHI07WA301Accident · No injuriesForeign investigationPiper PA-32-301 · Banbury, United KingdomSep 16, 2007 · G-BMDC · Substantial damageNTSB DFW07WA205Accident · No injuriesForeign investigationBoeing 737-200 · Guadalajara, MexicoSep 15, 2007 · XA-MAC · Substantial damageNTSB MIA07WA150Accident · Serious injuriesForeign investigationCessna 208B · Port-au-Prince, HaitiSep 11, 2007 · HH-CAW · Substantial damageNTSB 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 SEA07WA275Accident · Minor injuriesForeign investigationBell 206B · Prajuabkhirikha, ThailandSep 7, 2007 · N1612 · DestroyedNTSB MIA07WA149Accident · Minor injuriesForeign investigationCessna 208B · Port-au-Prince, HaitiAug 31, 2007 · HH-CAR · 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 DEN07WA143Incident · No injuriesForeign investigationBoeing 767-323 · Frankfurt, GermanyAug 20, 2007 · N369AA · Minor damageNTSB DCA07RA061Accident · No injuriesForeign investigationBoeing 737-800 · Naha, Okinawa, JapanAug 20, 2007 · B18616NTSB DFW07WA188Accident · 1 fatalForeign investigationPiper PA-25-235 · Tamoyo, Dominican RepublicAug 15, 2007 · HI-736TA · DestroyedNTSB DEN07WA146Accident · No injuriesForeign investigationRobinson R-22 Beta II · Wiener Neustadt, AustriaAug 15, 2007 · OE-XSM · Substantial damageNTSB 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 ATL07WA113Accident · No injuriesForeign investigationGates Learjet 35A · Melville Hall, DominicaAug 11, 2007 · N500ND · Substantial damageNTSB 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 DFW07WA178Accident · Serious injuriesForeign investigationBoeing 737-724 · Panama City, PanamaAug 2, 2007 · N13716 · No damageNTSB 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 MIA07WA146Accident · No injuriesForeign investigationDouglas DC-3 · Puerto Concord, ColombiaJul 31, 2007 · HK1149 · Substantial damageNTSB ANC07WA078Accident · No injuriesForeign investigationde Havilland DHC-2 · Victoria, CanadaJul 31, 2007 · N340KA · Substantial damageNTSB DEN07WA129Accident · 1 fatalForeign investigationStein Skybolt · Ardfert, IrelandJul 29, 2007 · EI-CIZ · DestroyedNTSB NYC07WA180Accident · 5 fatalForeign investigationRobinson R44 · Izhevsk, RussiaJul 28, 2007 · RA-04203 · DestroyedNTSB DFW08WA101Accident · No injuriesForeign investigationSocata TB-10 · Lillo, SpainJul 25, 2007 · EC-FTJ · No damageNTSB ENG07WA040Incident · No injuriesForeign investigationAirbus A330 · Indian Ocean, A1Jul 23, 2007 · VH-EBE · No damageNTSB 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 MIA07WA127Accident · Minor injuriesForeign investigationCessna 208B · Bolivar, VenezuelaJul 21, 2007 · YV-1182 · Substantial damageNTSB 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 · DestroyedNTSB DEN07WA113Accident · 2 fatalForeign investigationCessna 208B · Inverin, IrelandJul 5, 2007 · N208EC · DestroyedNTSB MIA07WA114Accident · Serious injuriesForeign investigationCessna T210H · McLean's Town, BahamasJul 3, 2007 · N2219R · DestroyedNTSB ANC07WA065Accident · 2 fatalForeign investigationEurocopter AS 350-B2 · Bernick Lake, CanadaJul 2, 2007 · C-FLUK · Substantial damageNTSB NYC07WA153Accident · 2 fatalForeign investigationHughes MD369 · Ayapel, ColombiaJun 29, 2007 · HK-2195 · DestroyedNTSB DCA07WA054Accident · 6 fatalForeign investigationBoeing 737-200 · M'banza Congo, AngolaJun 28, 2007 · D2-TBP · DestroyedNTSB DCA07WA053Accident · No injuriesForeign investigationBoeing B737-800 · Treviso, ItalyJun 25, 2007 · EI-CSN · Minor damageNTSB DFW07WA180Incident · No injuriesForeign investigationBoeing 757 · Quito, EcuadorJun 24, 2007 · N17106 · No damageNTSB DFW07WA141Accident · 1 fatalForeign investigationCessna 337G · Moixent, SpainJun 19, 2007 · EC-HMC · Destroyed