NTSB investigations, 2008, 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\") = 2008
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") = 2008 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 LAX08WA303Incident · No injuriesForeign investigationBoeing 757 · Cork, IrelandNTSB DFW08RA232Accident · 4 fatalClass 5 · ForeignCessna 421B · Ojinaga, MexicoOn September 15, 2008, approximately 1318 central daylight time, a United States registered Cessna 421B, N7560Q, was substantially damaged after it collided with mountainous terrain approximately 28 miles northwest of Ojinaga, Mexico, near the border town of…NTSB DCA08RA097Accident · 88 fatalClass 5 · ForeignBoeing 737-500 · Perm, RussiaOn September 14, 2008, at 0510 local time, Aeroflot-Nord flight 821, a Boeing 737-500, Bermuda registered (VP-BKO) and Russian operated, equipped with CFM56 engines, crashed on approach to Perm airport in Perm, Russia. All on board, including 6 crew and 82…NTSB NYC08WA326AccidentForeign investigationCessna 172 · El Trebolar, ChileNone.NTSB NYC08WA308Accident · 2 fatalForeign investigationRobinson R-44 · Muzino Village, RussiaNTSB MIA08WA181Accident · 7 fatalClass 5 · ForeignBell 212 · Persian Gulf, United Arab EmiratesOn September 3, 2008, at 0023 universal time, a Bell 212, A6-AVL registered to and operated by Aerogulf Services Company LLC, collided with a crane during takeoff from an oil rig in the Persian Gulf. Visual meteorological conditions prevailed and a visual…NTSB DCA08RA095Accident · 17 fatalForeign investigationBeech 1900 · Bukavu, Congo - KinshasaOn September 1, 2008 about 1510 UTC, ZS-OLD, Beech 1900C, operated by Air Serv International, collided with high terrain during approach to Bukavu, Democratic Republic of Congo (DRC). The pilot, copilot, and 15 passengers were fatally injured. The airplane…NTSB DCA08WA096Accident · 3 fatalForeign investigationBoeing B737-200 · Latacunga, Ecuador.NTSB NYC08IA290Incident · No injuriesIncident investigationFinal reportBoeing 747-209B · Bogota, ColombiaThe combination of fan blade edge contour, variable blade trim, and the high altitude, which resulted in an engine surge.NTSB MIA08WA175Accident · Serious injuriesForeign investigationCessna 172 · Pastaza, EcuadorOn August 26, 2008, about 1100 local time, a Cessna 172, Ecuadorian registration HC-BKY, registered to an operated by Wings of Hope Incorporated, as a medical transport flight, crashed following a loss of engine power, while in cruise flight to Rio Amazonas…NTSB DCA08WA094Incident · No injuriesForeign investigationBoeing B747-436 · Montreal, Canada.NTSB MIA08WA173Accident · 3 fatalClass 5 · ForeignBeech BE-55 · Curico, ChileOn August 25, 2008, about 1410 eastern daylight time, a Beech BE-55, CC-PBY, registered to and operated by Inversiones Aeronauticas Y Servicios Aereos Limitada, as a personal flight, collided with a private residence while maneuvering in the vicinity of…NTSB NYC08RA286Accident · 11 fatalClass 5 · ForeignCessna 208 · Zacapa, GuatemalaOn August 24, 2008, about 1545 universal coordinated time, a Cessna 208, Guatemalan registry TG-JCS, was destroyed during a forced landing, following a loss of engine power while in cruise flight near Zacapa, Guatemala. The two Guatemalan certificated flight…NTSB DCA08WA092Accident · 65 fatalForeign investigationBoeing 737 · Bishkek, Kyrgyzstan;khNTSB NYC08WA320AccidentForeign investigationGarlick UH-1D · Copiapo, ChileNone.NTSB DCA08RA090Accident · 154 fatalForeign investigationBoeing MD-82 · Madrid, SpainimportNTSB DFW08WA240Accident · 1 fatalForeign investigationCessna 501 · Las Americas, Dominican RepublicNTSB CHI08WA258Accident · 5 fatalClass 5 · ForeignCessna 402C · Covington, United KingdomOn August 17, 2008, at 1038 universal coordinated time, a Cessna 402C, registrations G-EYES, and a Rand KR-2, registration G-BOLZ, collided mid-air while on approach to land at the Coventry Airport (EGBE), Coventry, England. All four persons onboard the…NTSB DCA08WA100Incident · No injuriesForeign investigationBoeing B737-800 · Paris, France.NTSB DEN08WA149Accident · 3 fatalClass 5 · ForeignPiper PA-28R-200 · Taipalsaari, FinlandOn August 15, 2008 at 1014 UTC, a Piper PA-28R-200, Finland registration OH-PDY, broke up in flight while maneuvering in clouds and subsequently crashed into Lake Saimaa in Taipalsaari, Finland. The airplane was destroyed and the three persons on board, a…NTSB ANC08WA100Accident · 3 fatalClass 5 · ForeignHughes 369D · Alice Arm, CanadaOn August 6, 2007, about 0700 pacific daylight time, a Hughes 369D helicopter, Canadian registration C-GZIO, crashed while maneuvering in the vicinity of Alice Arm, British Columbia, Canada. The flight was operated by Prism Helicopters Inc., Pitt Meadows,…NTSB ANC08WA098Accident · Serious injuriesForeign investigationBeech 65-A90 · Pitt Meadows, CanadaNTSB ANC08WA096AccidentForeign investigationGrumman G-21A · Port Hardy, Canada.NTSB DEN08RA132Accident · No injuriesClass 5 · ForeignMcDonnell Douglas MD-902 · Fretin, FranceOn August 2, 2008, at 0835 coordinated universal time (1035 central European Summer Time), a McDonnell Douglas MD-902, Belgium registered OO-NHL, operated by Noordzee Helikopters Vlaanderen, experienced a separation of the right hand sliding door while in…NTSB CHI08WA244Accident · 2 fatalClass 5 · ForeignPiper PA-44-180 · Adriatic Sea, CroatiaOn August 1, 2008, at 1333 universal coordinated time, a Piper PA-44-180 Seminole airplane, registration D-GZXB, serial no. 4496165, crashed into the Adriatic Sea off the coast of Zadar, Croatia. The two pilots on-board were fatally injured. The instructional…NTSB ENG08WA034AccidentForeign investigationEurocopter EC135 · Kiskunlachaza, HungaryOn July 31, 2008, at approximately 1343 local time, an OMSZ Legimento Kht Eurocopter, EC-135 T2, having registration HA-ECE crashed as it was attempting an emergency landing about 2.2 kilometers directly south of Budapest, near Kiskunlachaza Hungary. The…NTSB ENG08RA033IncidentForeign investigationBoeing 777 · Tokyo, JapanOn July 30, 2008, a Vietnam Airline B777-200, Registration VNA146, experienced an undercowl engine fire shortly after landing at Narita International Airport, Tokyo, Japan. The airport fire team responded to a report of smoke from the No. 2 engine during…NTSB DCA08WA086AccidentForeign investigationBoeing 767 - 200 · Budapest, HungaryOn July 29, 2008, at 1607 local Budapest time, a Krasnojarsky Airlines Boeing 767-200, EI-GBA, experienced an inadvertent deployment of an emergency escape slide after takeoff from Budapest, Hungary. The flight continued to its destination of Domodedovo…NTSB DCA08RA084Accident · No injuriesClass 5 · ForeignBoeing 747-400 · Manila, PhilippinesAt approximately 11:15 AM local time, Manila, Philippines, the crew of Qantas flt 30, a Boeing 747-400, VH-OJK, executed an emergency landing after a section of the fuselage separated at an altitude of approximately 29,000 feet and resulted in a rapid…NTSB ENG08WA044IncidentForeign investigationBoeing 737 · Banjarmasin, South Kalimantan, IndonesiaOn July 23 2008, Garuda Indonesia Airlines Boeing 737, registeration PK-GZN, Serial number 29209, suffered a MLG failure at Syamsudin Noor Airport, South Kalimantan, Indonesia. Investigation found a crack in one of the brake mounting holes propogating…NTSB NYC08WA256Accident · No injuriesForeign investigationSikorsky S-61N · Cusco, PeruNTSB DCA08RA079Accident · Serious injuriesClass 5 · ForeignSikorsky S92A · Gapyeong, South KoreaAt approximately 5:00 PM local time, Gapyeong, Republic of Korea, a Korean registered Sikorsky S-92A helicopter, Korean registration HL9292, S/N 920020, operated by Times Aerospace, collided with trees and other ground obstacles while attempting a landing on…NTSB DCA08WA080Incident · Minor injuriesClass 5 · ForeignBoeing 737-282 · Port Harcourt, NigeriaOn July 14, 2008 about 1744 UTC, Chanchangi Airlines flight 138, a Boeing 737-282, 5N-BIG, crashed during landing at Port Harcourt International Airport, Nigieria. The airplane overran runway 21 following an instrument approach. Instrument meteorolgical…NTSB MIA08WA139Accident · 9 fatalClass 5 · ForeignRaytheon 99A · Puerto Montt, ChileOn July 10, 2008, about 1028 atlantic standard time, a Raytheon Aircraft Company 99A, Chilean registration CC-CFM, experienced an in-flight loss of control and crashed in an area of rising terrain approximately 1 mile north of La Paloma Airport (SCPF), Puerto…NTSB NYC08WA243Accident · 1 fatalClass 5 · ForeignPiper PA-28-235 · Parnu, EstoniaOn July 9, 2008, at 1219 universal time coordinated, a Piper PA-28-235, Swedish registration SE-KUY, was substantially damaged when it impacted terrain during approach to Parnu Airport (EEPU), Parnu, Estonia. Visual meteorological conditions prevailed at the…NTSB DCA08RA078Accident · 2 fatalForeign investigationBoeing 747-200FM · Madrid, ColombiaOn July 7, 2008, at 0357 local time, a Boeing 747-200FM, N714CK, operated by Kalitta Air as Centurion Airlines flight 164, was destroyed during a forced landing in Madrid, Cundinamarca, Colombia, shortly after taking off from El Dorado International Airport…NTSB DCA08RA077Accident · 1 fatalForeign investigationMcdonnell Douglas DC-9-15 · Saltillo, MexicoimportNTSB ENG08IA030IncidentIncident investigationFinal reportBoeing B747 · Jeddah, Saudi ArabiaFailure of the low pressure turbine stage 3 disk due to a design that is vulnerable to high pressure turbine unbalance-induced synchronous vibration that cannot be detected in flight, and the subsequent uncontained engine failure.NTSB DCA08WA082Accident · No injuriesClass 5 · ForeignBoeing B777 · Milan, ItalyOn July 2, 2008, a Pakistan International Airlines B777, registration AP-BHX, encountered a hail storm during descent to Malpensa Airport (MXP), Milan, Italy. The aircraft was substantially damaged. There were no injuries to the passengers and crew onboard.…NTSB DCA08WA074AccidentForeign investigationFairchild SA226 · Bergen, NorwayOn June 20, 2008, at 1032 local Norwegian time, a Helitrans AS Fairchild Aircraft Corporation SA226-T(B), registration LN-SFT, crashing into the North Sea approximately 15 NM West of Bergen Airport (ENBR), Bergen, Norway. The aircraft was on a training flight…NTSB DCA08WA073Accident · 4 fatalForeign investigationCessna 210 · Nairegi Enkera, KenyaOn June 10, 2008, about 1200 UTC, a Cessna 210, registration 5Y-BE, a chartered flight, was en route when it collided with high terrain near Nairegi Enkera, Kenya. The airplane was on a visual flight; instrument meteorological conditions prevailed due to low…NTSB DCA08WA072Accident · 30 fatalForeign investigationAirbus Industrie A310-324 · Khartoum, SudanOn June 10, 2008, about 1126 UTC, Sudan Airways Flight 109, an Airbus A310-324, registration ST-ATN, crashed during landing on runway 26 at Khartoum International Airport, Khartoum, Sudan. Thunderstorms were reported in the area. Of the 12 crew and 202…NTSB MIA08WA116Accident · No injuriesForeign investigationAero Commander 500S · North Bimini, BahamasNTSB NYC08WA209Accident · 1 fatalClass 5 · ForeignCessna 208B · La Junta, ChileOn June 7, 2008, about 1350 Chilean local time, a Cessna 208B, Chilean registry CC-CTR, operated by Patagonia Airlines, was substantially damaged when it impacted mountainous terrain about 18 kilometers west of La Junta, Aysen Region, Chile. The Chilean…NTSB ENG08WA029IncidentForeign investigationBoeing 737-2A5 · Pucallpa, PeruOn June 6, 2008, at approximately 1810 local time, OB-1799-P, a Boeing 737-2A5, operated by Aero Condor S.A.C., returned to the FAP Captain David Abenzur Rengifo International Airport, (SPCL), Pucallpa Peru, after experiencing a very strong vibration after…NTSB NYC08WA212Accident · No injuriesForeign investigationPiper PA-46-310P · Milano Linate, ItalyNTSB MIA08WA110Accident · Minor injuriesForeign investigationSikorsky S-64F · Torino, ItalyNTSB DEN08WA097Accident · 1 fatalClass 5 · ForeignBeech A 36 · Westerland/Sylt, GermanyOn May 30, 2008, at 1655 coordinated universal time (1855 central European Summer Time), a Beech Aircraft Corporation A 36, German registered D-EMIB, owned and piloted by the accident pilot, was destroyed when it impacted terrain under unknown circumstances…NTSB DCA08RA068Accident · 5 fatalClass 5 · ForeignAirbus Industrie A320-233 · Tegucgalpa, HondurasOn May 30, 2008 at 1545Z, an Airbus A320-233, Irish registration EI-TAF, operated by Taca Airlines as flight No. 390, overran the end of runway 02, at the Toncontin International Airport (TGU), in Tegucigalpa, Honduras, during landing. The airplane was on a…NTSB NYC08RA197Accident · 11 fatalClass 5 · ForeignBell UH-1N · Panama City, PanamaOn May 29, 2008, at 1410 central daylight time, a Bell UH-1H, operated by the Panamanian Servicio Aereo Nacional (SAN) as SAN-100, was destroyed when it impacted buildings in Panama City, Panama. The Panamanian pilot in command, the Panamanian flight…