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 MIA06WA137Incident · No injuriesForeign investigationCirrus Design SR22 · Bull Bay, JamaicaSep 22, 2006 · N181LM · Minor damageNTSB DEN06WA133Accident · 1 fatalForeign investigationPiper PA-28-181 · Bad Schwartau, GermanySep 22, 2006 · D-EGPD · 2 aircraft · Substantial damageNTSB DCA06WA075Incident · No injuriesForeign investigationBoeing 777-200 · Brindisi, ItalySep 22, 2006 · N861DA · Minor damageNTSB LAX06WA300Accident · Minor injuriesForeign investigationBoeing B75N1 · Canyonleigh,NSW, AustraliaSep 19, 2006 · N73410 · Substantial damageNTSB DCA06WA073Incident · No injuriesForeign investigationBoeing 777 · Brisbane, AustraliaSep 18, 2006 · 9M-MRM · No damageNTSB DCA06WA074Incident · No injuriesForeign investigationBoeing 767-300 · IcelandSep 17, 2006 · TF-LLA · Minor damageNTSB CHI06WA280Accident · 1 fatalForeign investigationGuscott VariViggen · Plaster Rock, CanadaSep 17, 2006 · N106VV · DestroyedNTSB DFW06WA211Accident · 1 fatalForeign investigationPiper PA-46-310P · Toluca, MexicoSep 15, 2006 · XB-JVH · DestroyedNTSB DCA06WA072Accident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Subic Bay, PhilippinesSep 14, 2006 · N623FE · Substantial damageNTSB NYC07WA089Accident · 3 fatalForeign investigationMD Helicopters MD-600N · Novokuznetsk, RussiaSep 13, 2006 · UNREG · DestroyedNTSB ENG06WA036Incident · No injuriesForeign investigationCessna 560 · Calgary, CanadaSep 13, 2006 · C-GTGO · Substantial damageNTSB CHI06WA271Accident · No injuriesForeign investigationPiper PA-46-350P · Suwalki, PolandSep 13, 2006 · N721BB · Substantial damageNTSB DCA06WA069Incident · No injuriesForeign investigationBoeing 737 · Auckland, New ZealandSep 12, 2006 · ZK-NGJNTSB DEN06WA130Accident · 2 fatalForeign investigationRobinson R-22 Beta · St. Florian, AustriaSep 10, 2006 · OE-XPJ · DestroyedNTSB DFW06WA210Accident · 3 fatalForeign investigationBeech 35 · Ensenada, MexicoSep 8, 2006 · N5146C · DestroyedNTSB WAS06WA014Incident · No injuriesForeign investigationBoeing 727-277 · Lagos, NigeriaSep 7, 2006 · ZS-DPF · Minor damageNTSB DEN06WA122Accident · No injuriesForeign investigationCessna C210P · Hoexter, GermanySep 3, 2006 · N666JG · Substantial damageNTSB DCA06WA070Incident · No injuriesForeign investigationBoeing B737-300 · Doha, QatarSep 3, 2006 · AP-BCC · Minor damageNTSB DEN06WA120Accident · 1 fatalForeign investigationBellanca 17-31 ATC · Neuwerk Island, GermanySep 1, 2006 · D-ELAI · Substantial damageNTSB DEN06WA121Accident · No injuriesForeign investigationPiper PA-23-160 · Neresheim, GermanyAug 23, 2006 · N4067P · Substantial damageNTSB DEN07WA029Accident · No injuriesForeign investigationPiper PA-24-220T · Zee Am See, AustriaAug 22, 2006 · D-GREA · Substantial damageNTSB DEN06WA129Accident · No injuriesForeign investigationPiper PA-32R · Varberg, SwedenAug 16, 2006 · SE-KVE · Substantial damageNTSB ANC06WA120Accident · 6 fatalForeign investigationCessna 337 · Ft. Good Hope, CanadaAug 16, 2006 · C-FWHP · DestroyedNTSB ANC06WA116Accident · No injuriesForeign investigationMooney M20E · Victoria, CanadaAug 14, 2006 · N1234N · Substantial damageNTSB NYC06WA202Accident · 3 fatalForeign investigationLockheed L-100-30 · Piacenza, ItalyAug 13, 2006 · 7T-VHG · DestroyedNTSB NYC06WA203Accident · No injuriesForeign investigationCirrus SR-22 · Ligure Sea, ItalyAug 12, 2006 · N357MV · Substantial damageNTSB MIA06WA128Accident · 2 fatalForeign investigationCessna 207A · Puerto Ayacucho, VenezuelaAug 11, 2006 · YV492C · DestroyedNTSB LAX06FA258Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Saipan, SarkA loss of engine power during the initial climb due to fuel starvation resulting from the pilot's improper fuel selector valve position selection and his failure to select a tank containing an adequate fuel supply. Contributing to the accident was the high…Aug 11, 2006 · N4509T · DestroyedNTSB CHI06WA248Accident · 1 fatalForeign investigationBussey Express FT · Regina, SK, CanadaAug 4, 2006 · N554SB · DestroyedNTSB ENG06WA030Incident · No injuriesForeign investigationAirbus A320 · Shenzhen, China, ChinaAug 2, 2006 · B-2369 · No damageNTSB NYC06WA186Accident · 1 fatalForeign investigationPiper PA-28RT-201T · Guipuzcoa, SpainJul 27, 2006 · EC-ENR · Substantial damageNTSB ENG06RA025Incident · No injuriesForeign investigationCanadair CL600-2B19-200 · Barcelona, Spain, SpainJul 27, 2006 · EC-IJF · Minor damageNTSB ENG06WA033Incident · No injuriesForeign investigationAirbus Industrie A320 · Islamabad, PakistanJul 24, 2006 · AP-BGV · No damageNTSB DCA06WA056Incident · Minor injuriesForeign investigationBoeing B767-200 · Cancun, MexicoJul 24, 2006 · N67157 · No damageNTSB CHI06WA231Accident · No injuriesForeign investigationCirrus Design SR-22 · Mantena, BrazilJul 24, 2006 · PR-ESA · Substantial damageNTSB NYC06WA182Accident · No injuriesForeign investigationPiper PA-46T · Debrecen, HungaryJul 21, 2006 · N122WD · Substantial damageNTSB ENG06WA022Incident · No injuriesClass 5 · ForeignBoeing 747-200F · Amsterdam, NetherlandsOn July 16, 2006, at 1424 coordinated universal time, a Boeing 747-200F, N516MC, operated by Atlas Air, sufferend minor damage when the left main body gear tires burst during takeoff from runway 36L at Amsterdam/Schiphol Airport (EHAM). The airplane returned…Jul 17, 2006 · N516MC · Minor damageNTSB CHI06WA192Accident · 4 fatalForeign investigationPiper PA-46-310P · Marina di Campo, ItalyJul 16, 2006 · D-EJMV · DestroyedNTSB ENG06WA027Accident · No injuriesForeign investigationBell 206L · Maria Lankowitz, Austria, AustriaJul 15, 2006 · OE-KXE · Substantial damageNTSB DEN06WA102Accident · 1 fatalForeign investigationCessna T310R · Saint Tropez, FranceJul 15, 2006 · N234SA · DestroyedNTSB ENG07WA032Accident · Serious injuriesForeign investigationGrumman AA-5B · Skane County, SwedenJul 14, 2006 · OY-CFL · Substantial damageNTSB DEN06WA098Accident · 3 fatalForeign investigationCessna 172N · El Rosario, SpainJul 14, 2006 · EC-HQR · DestroyedNTSB WAS06WA012Accident · 5 fatalForeign investigationLockheed 382 C130 · Kigoma, TanzaniaJul 12, 2006 · S9-BOF · DestroyedNTSB DFW06WA177Accident · 5 fatalForeign investigationCessna 182C · Tepic, MexicoJul 9, 2006 · XB-PER · DestroyedNTSB DCA06RA055Accident · 124 fatalForeign investigationAirbus Industrie A310-300 · Irkutsk, RussiaJul 8, 2006 · F-OGYPNTSB DCA06RA053Accident · 6 fatalForeign investigationSikorsky S61N · Tenerife, SpainJul 8, 2006 · EC-FJJNTSB DCA06WA054Incident · No injuriesForeign investigationBoeing 737-300 · Stansted, United KingdomJul 7, 2006 · G-CELA · No damageNTSB DCA06WA057Incident · Serious injuriesForeign investigationBoeing MD-81 · Toyota, JapanJul 4, 2006 · JA8499 · No damageNTSB DFW08WA205Accident · 5 fatalForeign investigationCessna T210N · Poptun, GuatemalaJul 1, 2006 · TG-LUK · DestroyedNTSB WAS06WA011Accident · 3 fatalForeign investigationCessna 208B · Vilanculos, MozambiqueJun 30, 2006 · ZS-POG · Substantial damage