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 ENG06WA026Incident · No injuriesForeign investigationAirbus Industrie A320 · Dublin, IrelandMar 5, 2006 · EC-HUK · No damageNTSB DFW06WA082Accident · Serious injuriesForeign investigationCessna 208B · Arecuna, VenezuelaMar 5, 2006 · YV-1149C · Substantial damageNTSB DFW06WA079Accident · Minor injuriesForeign investigationAmerican Champion 8KCAB · Banjul, GambiaMar 4, 2006 · N5523K · DestroyedNTSB DCA06WA027Incident · No injuriesForeign investigationBoeing MD-82 · Surabaya, IndonesiaMar 4, 2006 · PKLMW · Substantial damageNTSB DCA06WA028Incident · No injuriesForeign investigationBoeing 717-200 · Paraburdoo, AustraliaFeb 28, 2006 · VH-NXH · No damageNTSB DFW06WA075Accident · 4 fatalForeign investigationBell 206B3 · Mutata, ColombiaFeb 24, 2006 · HK-2496 · DestroyedNTSB LAX06WA121Accident · 4 fatalForeign investigationRobinson R44 · Gunpowder, AustraliaFeb 21, 2006 · VH-HBS · DestroyedNTSB SEA06WA058Accident · 6 fatalForeign investigationCessna 501 · Sulaimaniya, IraqFeb 16, 2006 · D-IMRX · DestroyedNTSB ENG06WA010Incident · No injuriesForeign investigationBoeing 737 · Sao Paulo, BrazilFeb 13, 2006 · PP-VNY · No damageNTSB DFW06WA069Accident · 3 fatalForeign investigationCessna 172P · Samana, Dominican RepublicFeb 12, 2006 · HI-410CT · DestroyedNTSB ENG06RA013Accident · No injuriesForeign investigationCessna 208 Caravan · Strahan, Tasmania, AustraliaFeb 5, 2006 · VH-KLP · Substantial damageNTSB LAX06WA100Accident · 3 fatalForeign investigationBell 206B III · Parkes, AustraliaFeb 2, 2006 · VH-MFI · DestroyedNTSB ENG06WA009Incident · No injuriesForeign investigationBoeing 747 · Istanbul, TürkiyeFeb 1, 2006 · LX-GCV · Minor damageNTSB SEA06WA050Accident · No injuriesForeign investigationRockwell Commander 114TC · Oxford, United KingdomJan 31, 2006 · N115TB · Substantial damageNTSB LAX06WA095Accident · 3 fatalForeign investigationRobinson R-44 · Lorca, Murcia, SpainJan 27, 2006 · EC-JOG · DestroyedNTSB SEA06WA046Accident · 3 fatalForeign investigationCessna 208B · Port Alberni, CanadaJan 22, 2006 · C-GRXZ · Substantial damageNTSB DFW06WA086Accident · 1 fatalForeign investigationBrantly Helicopter B-2B · Googlong, NSW, AustraliaJan 22, 2006 · VH-FBE · DestroyedNTSB CHI06WA075Accident · No injuriesForeign investigationStarduster SA-100 · Old Hay, Kent, United KingdomJan 22, 2006 · N40D · Substantial damageNTSB ENG06WA012Incident · No injuriesForeign investigationSao Paulo, BrazilJan 20, 2006 · Minor damageNTSB NYC07WA012Incident · No injuriesForeign investigationCessna 208B · Floro, NorwayJan 19, 2006 · LN-PBF · No damageNTSB LAX06WA093Accident · 2 fatalForeign investigationBeech 58 · McArthur Rive M, AustraliaJan 19, 2006 · VH-MNI · DestroyedNTSB DCA08WA013Incident · No injuriesForeign investigationBoeing MD-82 · Makassar, IndonesiaJan 18, 2006 · PK-LMJ · Minor damageNTSB WAS06WA007Accident · 1 fatalForeign investigationRobinson R22 · Cape Point, South AfricaJan 17, 2006 · ZS-RXA · Substantial damageNTSB SEA06WA045Accident · 4 fatalForeign investigationEADS Socata TB-20 Trinidad · Bourdeau, FranceJan 16, 2006 · N250AG · DestroyedNTSB WAS06WA006Accident · 1 fatalForeign investigationRobinson R22 · Mariental, NamibiaJan 15, 2006 · V5-HSL · Substantial damageNTSB ATL06WA036Accident · 2 fatalForeign investigationBeech D35 · Tierra Blanca, Costa RicaJan 15, 2006 · N5985C · DestroyedNTSB DFW06WA053Accident · Minor injuriesForeign investigationde Havilland DHC-6 · Puerto Jimenez, Costa RicaJan 10, 2006 · TI-BAF · Substantial damageNTSB DFW06WA052Accident · 2 fatalForeign investigationBeech 95B55 · Piedras Negras, VenezuelaJan 5, 2006 · YV-1612P · DestroyedNTSB MIA06WA038Accident · 4 fatalForeign investigationCessna 172RG · Mendoza, ArgentinaJan 3, 2006 · PT-OJN · DestroyedNTSB NYC06WA052Accident · 3 fatalForeign investigationRaytheon HS-125-700 · Kharkiv, UkraineJan 2, 2006 · P4-AOD · DestroyedNTSB LAX06WA077Accident · 5 fatalForeign investigationCessna U206 · Brisbane, AustraliaJan 2, 2006 · VH-UYB · Destroyed