NTSB investigations, 2009, 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\") = 2009
    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 ERA09WA223Accident · 1 fatalForeign investigationBeech A36 · Querencia, BrazilNoneMar 8, 2009 · PT-LKH · DestroyedNTSB ERA09WA183Accident · No injuriesForeign investigationBell 206B · St. Maarten, NTNone.Mar 4, 2009 · N83086 · Substantial damageNTSB DCA09WA034Accident · Serious injuriesForeign investigationBoeing 777 · Niigata, JapanOn March 5, 2009, at approximately 0820 Japan Standard Time, an Air France Boeing 777-200, registration F-GSPD, encountered turbulence near Niigata, Japan, at an altitude of about 25,000 feet. Two flight attendants received serious injuries. The passengers…Mar 4, 2009 · FGSPD · No damageNTSB ERA09WA180Accident · 6 fatalForeign investigationBeech BE-100 · San Miguel, VenezuelaNone.Mar 2, 2009 · YV-2129 · DestroyedNTSB DCA09WA039Incident · No injuriesForeign investigationGreeceOn March 2, a Jet2.com B-757, registration G-LSAA, operating from Manchester, England, to Taba, Egypt, experienced a decompression during cruise over Greece. No serious injuries were reported to the 192 passengers and crew onboard. The flight diverted to…Mar 2, 2009 · No damageNTSB ERA09WA178Accident · 1 fatalForeign investigationCessna 172 · Liquino, EcuadorNone.Feb 28, 2009 · HC-BFQ · Substantial damageNTSB CEN09WA188Accident · Minor injuriesForeign investigationBell 212 · Aguascalientes, MexicoNot Required. Investigation is being conducted by the DGAC, Mexico.Feb 28, 2009 · XC-DES · Substantial damageNTSB DCA09WA036Incident · No injuriesClass 5 · ForeignBoeing 737 · South Jakarta, IndonesiaFeb 27, 2009 · PK-YTX · No damageNTSB DCA09RA030Accident · 9 fatalForeign investigationBoeing B737-800 · Amsterdam, NetherlandsOn February 25, 2009 at approximately 10:40 am local time, a Turkish Airlines B737-800 (registration TC-JGE), equipped with CFM engines, flight TK 1951, crashed during approach to Schipol Amsterdam Airport in Amsterdam, The Netherlands. The flight originated…Feb 25, 2009 · TC-JGE · DestroyedNTSB DCA09WA031Incident · No injuriesForeign investigationBombardier CL-600 · Santander, SpainOn February 24, 2009, about 1750 coordinated universal time, an Air Nostrum CL-600-2B19, registration EC-IKZ, experienced a duel engine failure while on approach to Santander Airport (LEXJ), Santander, Spain. The flight crew were able to restart both engines…Feb 24, 2009 · EC-IKZ · No damageNTSB CEN09WA174Accident · 4 fatalClass 5 · ForeignCirrus Design SR 22 · Itzehoe, GermanyOn February 24, 2009, at 1600 coordinated universal time, a Cirrus Design Corporation SR22 , German registered D-EPDK, was destroyed when it impacted terrain under unknown circumstances near Itzehoe Germany. Visual meteorological conditions prevailed at the…Feb 24, 2009 · D-EPDK · DestroyedNTSB DCA09WA035Accident · No injuriesForeign investigationMcdonnell Douglas MD90 · Batam, Indonesia.Feb 23, 2009 · PK-LIO · Minor damageNTSB DCA09WA029Accident · Serious injuriesForeign investigationBoeing 747 · Tokyo, JapanFeb 20, 2009 · N676NW · No damageNTSB CEN09WA216Accident · 3 fatalForeign investigationRobinson R44 · Tocumen, PanamaThe investigation is under the jurisdiction of the government of Panama. Further information pertaining to this accident may be obtained from: Direccion de Aeronautica Civil Apartados 7501 y 7615 Panama 5 http://www.aeronautica.gob.pa This report is for…Feb 19, 2009 · HP-AM3 · DestroyedNTSB WPR09WA138Accident · No injuriesForeign investigationEurocopter EC225 · North Sea, United Kingdom.Feb 18, 2009 · G-REDU · Substantial damageNTSB CEN09WA176Accident · 1 fatalForeign investigationCessna 206 · Island of Cebaco, PanamaNot Required. Investigation is being conducted by AAC, Panama.Feb 16, 2009 · HP-1367 RS · Substantial damageNTSB ERA09WA167Accident · 13 fatalForeign investigationBell UH-1H · Chanco, ChileNone.Feb 15, 2009 · CC-CBW · DestroyedNTSB ERA09WA174Accident · Minor injuriesForeign investigationCessna 172 · Ica, PeruNone.Feb 14, 2009 · OB-1093 · Substantial damageNTSB CEN09WA177Accident · 2 fatalForeign investigationDassault Falcon · Samedan, SwitzerlandThis is under the jurisdiction and control of the Swiss government.Feb 12, 2009 · VP-BAF · DestroyedNTSB CEN09WA163Accident · 3 fatalForeign investigationRobinson R44 · Budaors, HungaryN/aFeb 10, 2009 · HA-MIX · Substantial damageNTSB ERA09WA166Accident · 24 fatalForeign investigationEmbraer EMB110 · Coari, BrazilOn February 7, 2009, at 1810 universal time coordinates, an Embraer EMB 110P1, Brazilian registry PT-SEA, operated by Manaus Aerotaxi as a commuter flight, experienced an unknown problem after take-off from the Coari, Amazonas Airport (SWKO) in Coari, Brazil,…Feb 7, 2009 · PR-SAE · DestroyedNTSB ERA09RA161Accident · 2 fatalForeign investigationCessna 650 · Rome, ItalyNone.Feb 7, 2009 · I-FEEV · DestroyedNTSB CEN09WA309Accident · No injuriesForeign investigationLearjet 35 · Ciudad Victoria, MexicoOn February 5, 2009 a Learjet 35 airplane lost control on landing at Ciudad Victoria Airport (MMCV), Ciudad Victoria, Tamaulipas, Mexico. The crew lost control after touchdown and slid off the runway into the grass and came to rest upright after a 180 degree…Feb 5, 2009 · XB-RYT · Substantial damageNTSB CEN09WA160Accident · No injuriesForeign investigationBell OH-58 · Dominican RepublicOn February 2, 2009, about 1745 Coordinated Universal Time (UTC), a single-engine Bell helicopter, registration HI-855, impacted terrain after a loss of engine power, while do agricultural application work in the southwest section of Dominican Republic. The…Feb 2, 2009 · HI-855 · Substantial damageNTSB ERA09WA211Accident · 3 fatalForeign investigationPiper PA-28R · Santo Antonio do Leverger, BrazilNone.Feb 1, 2009 · PT-DJA · DestroyedNTSB ERA09WA153Accident · Minor injuriesForeign investigationCessna 421B · Nassau, BahamasOn January 29, 2009, at 2130 eastern daylight time, a Cessna 421B, Bahamian registration C6-DXL, operated by a private individual as an air ambulance, experienced a loss of engine power while on approach to the Lynden Pindling International Airport (MYNN),…Jan 30, 2009 · C6-DXL · Substantial damageNTSB CEN09WA138Accident · 1 fatalForeign investigationPiper PA-42-720 · Konigstein, GermanyThis is under the jurisdiction and control of the German Government.Jan 19, 2009 · DIDIA · DestroyedNTSB DCA09WA023Incident · No injuriesForeign investigationBoeing 737 · East Anglia, United KingdomOn January 12, 2009, at 1545 Coordinated Universal Time, an easyJet Boeing 737-73V, registered in the United Kingdom as G-EZJK, experienced a violent pitch down during flight. Vmo was exceeded by 100 knots, and a 10,000 foot loss of altitude occurred. The…Jan 12, 2009 · G-EZJK · No damageNTSB ERA09WA212Incident · No injuriesForeign investigationPiper PA28R · Rio Verde, BrazilNone.Jan 10, 2009 · PT-NEE · Minor damageNTSB ENG09RA003Incident · No injuriesForeign investigationBoeing 777 · Ho Chi Minh City, VietnamOn January 1, 2009, a Vietnam Airlines Boeing 777-200, registration VN-A143, flight number VN224, departed the Tan Son Nhat Airport, SGN (Ho Chi Minh City) and while climbing through 8,000 feet, a loud metallic noise was heard followed by a L ENGINE FAIL…Jan 6, 2009 · VN-A143 · Minor damageNTSB CEN09WA129Accident · 1 fatalForeign investigationEurocopter Deutsch EC 135 T2 · Molesmes, FranceUnder the jurisdiction and control of the French government.Jan 2, 2009 · F-HBMA · Destroyed