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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA09WA223Accident · 1 fatalForeign investigationBeech A36 · Querencia, BrazilNoneNTSB ERA09WA183Accident · No injuriesForeign investigationBell 206B · St. Maarten, NTNone.NTSB 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…NTSB ERA09WA180Accident · 6 fatalForeign investigationBeech BE-100 · San Miguel, VenezuelaNone.NTSB 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…NTSB ERA09WA178Accident · 1 fatalForeign investigationCessna 172 · Liquino, EcuadorNone.NTSB CEN09WA188Accident · Minor injuriesForeign investigationBell 212 · Aguascalientes, MexicoNot Required. Investigation is being conducted by the DGAC, Mexico.NTSB DCA09WA036Incident · No injuriesClass 5 · ForeignBoeing 737 · South Jakarta, IndonesiaNTSB 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…NTSB 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…NTSB 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…NTSB DCA09WA035Accident · No injuriesForeign investigationMcdonnell Douglas MD90 · Batam, Indonesia.NTSB DCA09WA029Accident · Serious injuriesForeign investigationBoeing 747 · Tokyo, JapanNTSB 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…NTSB WPR09WA138Accident · No injuriesForeign investigationEurocopter EC225 · North Sea, United Kingdom.NTSB CEN09WA176Accident · 1 fatalForeign investigationCessna 206 · Island of Cebaco, PanamaNot Required. Investigation is being conducted by AAC, Panama.NTSB ERA09WA167Accident · 13 fatalForeign investigationBell UH-1H · Chanco, ChileNone.NTSB ERA09WA174Accident · Minor injuriesForeign investigationCessna 172 · Ica, PeruNone.NTSB CEN09WA177Accident · 2 fatalForeign investigationDassault Falcon · Samedan, SwitzerlandThis is under the jurisdiction and control of the Swiss government.NTSB CEN09WA163Accident · 3 fatalForeign investigationRobinson R44 · Budaors, HungaryN/aNTSB 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,…NTSB ERA09RA161Accident · 2 fatalForeign investigationCessna 650 · Rome, ItalyNone.NTSB 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…NTSB 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…NTSB ERA09WA211Accident · 3 fatalForeign investigationPiper PA-28R · Santo Antonio do Leverger, BrazilNone.NTSB 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),…NTSB CEN09WA138Accident · 1 fatalForeign investigationPiper PA-42-720 · Konigstein, GermanyThis is under the jurisdiction and control of the German Government.NTSB 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…NTSB ERA09WA212Incident · No injuriesForeign investigationPiper PA28R · Rio Verde, BrazilNone.NTSB 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…NTSB CEN09WA129Accident · 1 fatalForeign investigationEurocopter Deutsch EC 135 T2 · Molesmes, FranceUnder the jurisdiction and control of the French government.