NTSB investigations, 2006, 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\") = 2006
    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 ANC06WA142Accident · Minor injuriesForeign investigationBell 206B · Fontas, Alberta, CanadaJun 30, 2006 · C-FMGS · Substantial damageNTSB NYC06WA166Accident · 1 fatalForeign investigationPiper PA-23-250 · Thirkleby, United KingdomJun 29, 2006 · G-BBEY · DestroyedNTSB DFW06WA170Accident · 1 fatalForeign investigationCessna U206 · Chiguao, VenezuelaJun 26, 2006 · YV-229C · DestroyedNTSB DFW06WA169Accident · No injuriesForeign investigationRaytheon Corporate Jets DH 125-3A · Barcelona, VenezuelaJun 26, 2006 · N125GK · DestroyedNTSB DCA06WA052Accident · No injuriesForeign investigationBoeing B737-300 · East Midlands, United KingdomJun 15, 2006 · OO-TND · Substantial damageNTSB DCA06WA051Incident · No injuriesForeign investigationBoeing B737-400 · Catania, ItalyJun 15, 2006 · EI-COI · Minor damageNTSB WAS06WA013Incident · No injuriesForeign investigationBoeing 737-2m2 · Accra, GhanaJun 12, 2006 · D2-TBO · Minor damageNTSB DCA06WA065Incident · No injuriesForeign investigationBoeing B737-400 · Frankfurt, GermanyJun 8, 2006 · TC-TJC · No damageNTSB NYC06WA170Accident · No injuriesForeign investigationRobinson R-22 · Paris, FranceJun 7, 2006 · F-GUPC · Substantial damageNTSB DCA06WA049Accident · No injuriesForeign investigationBoeing 747-200 · Rio Negro, ColombiaJun 7, 2006 · N922FT · Substantial damageNTSB LAX06WA201Accident · No injuriesForeign investigationBell 407 · Bangalore, IndiaJun 5, 2006 · VT-DAC · Substantial damageNTSB DCA06RA042Accident · No injuriesForeign investigationMcDonnell Douglas DC10-10F · Managua, NicaraguaJun 4, 2006 · N68047 · Substantial damageNTSB LAX06WA188Accident · 1 fatalForeign investigationBeech A36 · Bathurst Island, AustraliaMay 31, 2006 · VH-JDJ · DestroyedNTSB DFW06WA148Accident · 1 fatalForeign investigationAir Tractor AT-802 · Molinicos, SpainMay 30, 2006 · EC-GOS · DestroyedNTSB DFW06WA147Accident · 3 fatalForeign investigationSchweizer 269D · Ciudad Juarez, MexicoMay 30, 2006 · XC-LJU · DestroyedNTSB ENG06WA041Incident · No injuriesForeign investigationAirbus A330 · Dubai, United Arab Emirates, United Arab EmiratesMay 28, 2006 · A6-EAB · Minor damageNTSB NYC06WA132Accident · 2 fatalForeign investigationCessna 150M · Raharney, IrelandMay 25, 2006 · EI-CHM · Substantial damageNTSB MIA06WA115Accident · Minor injuriesForeign investigationIsrael Aircraft Industries 1124 · Georgetown, BahamasMay 24, 2006 · N475AT · Substantial damageNTSB SEA06WA104Accident · No injuriesForeign investigationCessna 210G · Seoul, South KoreaMay 21, 2006 · HL1027 · Substantial damageNTSB DCA08WA014Accident · Minor injuriesForeign investigationBoeing B737-200 · Jakarta, IndonesiaMay 5, 2006 · PK-YTQ · Minor damageNTSB DCA06RA040Incident · No injuriesForeign investigationBoeing B727-200 · Banglore, IndiaMay 4, 2006 · 9M-TGANTSB ENG07WA003Accident · 113 fatalForeign investigationAirbus A320 · Sochi, RussiaMay 3, 2006 · EK-32009 · DestroyedNTSB DEN06WA072Accident · 2 fatalForeign investigationBeech C 24R · Albshausen, GermanyMay 3, 2006 · D-ELES · DestroyedNTSB DCA06WA037Incident · No injuriesForeign investigationBoeing B737-800 · Skelleftea, SwedenMay 3, 2006 · TCAAP · Minor damageNTSB DCA06WA036Incident · No injuriesForeign investigationAirbus A-300-B4 · Toronto, CanadaMay 2, 2006 · N372PC · Minor damageNTSB DFW06WA114Accident · No injuriesForeign investigationPiper PA-28-181 · Amman, JordanMay 1, 2006 · JY-RJB · DestroyedNTSB ATL06WA074Accident · 1 fatalForeign investigationPiper PA-34-220T · San Javier, SpainApr 29, 2006 · EC-IYY · Substantial damageNTSB WAS06WA009Accident · 3 fatalForeign investigationCessna 208B · Kasese, UgandaApr 28, 2006 · ZS-ADL · DestroyedNTSB ENG06RA037Accident · No injuriesForeign investigationBell 206B3 · San Paulo, BrazilApr 27, 2006 · PT-HoQNTSB SEA06WA085Accident · No injuriesForeign investigationGarlick UH-1H · Sarawak, MalaysiaApr 25, 2006 · N126AC · Substantial damageNTSB DCA06WA035Accident · Serious injuriesForeign investigationBoeing 777 · Shanghai, ChinaApr 19, 2006 · N216UA · No damageNTSB ATL06WA067Accident · 2 fatalForeign investigationCessna 172M · Toledo, SpainApr 18, 2006 · EC-HAS · 2 aircraft · Substantial damageNTSB SEA06WA079Accident · No injuriesForeign investigationLake LA-4-200 · Lady Smith, CanadaApr 16, 2006 · N2788P · Substantial damageNTSB MIA06WA094Incident · No injuriesForeign investigationCessna 208B · El Alto, BoliviaApr 14, 2006 · CP-2413 · Minor damageNTSB MIA06WA087Accident · 2 fatalForeign investigationPiper PA-34-200T · Antioquia, ColombiaApr 12, 2006 · HK-2387 · Substantial damageNTSB DFW06WA099Accident · Serious injuriesForeign investigationBell 407 · Morelia, MexicoApr 11, 2006 · XC-UPN · Substantial damageNTSB NYC06WA095Accident · Minor injuriesForeign investigationBell 206 · Propriano, FranceApr 9, 2006 · F-GIVH · Substantial damageNTSB DEN06WA057Accident · 1 fatalForeign investigationHerde Lancair 360 · Bankstown, AustraliaApr 5, 2006 · VH-ZNZ · DestroyedNTSB MIA06WA076Accident · 4 fatalForeign investigationCessna R172K · Cambita Garabit, Dominican RepublicMar 29, 2006 · N323EP · DestroyedNTSB DFW06WA091Accident · 6 fatalForeign investigationCessna 206 · Medellin, ColombiaMar 29, 2006 · HK-2969 · DestroyedNTSB LAX06WA132Accident · 1 fatalForeign investigationCessna A188B · Narrandera, AustraliaMar 27, 2006 · VH-ZIP · Substantial damageNTSB DFW06WA090Accident · 2 fatalForeign investigationCessna 150 · San Luis Potosi, MexicoMar 27, 2006 · XB-KAT · DestroyedNTSB MIA06RA070Accident · 5 fatalForeign investigationCessna 208B · Cuenca, EcuadorMar 24, 2006 · HC-BXD · DestroyedNTSB DEN06WA053Accident · 1 fatalForeign investigationMooney M-20K · San Bartelome, SpainMar 22, 2006 · EC-JCT · DestroyedNTSB ANC06WA042Accident · 1 fatalForeign investigationMD Helicopter MD 600 · Zama City, CanadaMar 21, 2006 · C-FTAZ · DestroyedNTSB DEN06WA052Accident · 1 fatalForeign investigationPiper PA-28-180 · Bonndorf, GermanyMar 19, 2006 · D-ELCI · DestroyedNTSB DFW06WA100Accident · No injuriesForeign investigationRockwell Sabreliner · Cochabamba, BoliviaMar 10, 2006 · CP-2317 · Minor damageNTSB SEA06WA063Accident · 1 fatalForeign investigationBeech C24R · Ribe, DenmarkMar 7, 2006 · D-ETRA · DestroyedNTSB DFW06WA080Accident · 2 fatalForeign investigationCessna 421C · Labiano, SpainMar 7, 2006 · EC-JAX · DestroyedNTSB CHI06WA097Accident · 1 fatalForeign investigationMooney M-20K · Sachsen, GermanyMar 6, 2006 · D-EIOI · Destroyed