NTSB investigations, 2012, Outside the U.S.
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 2012
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") = 2012 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 ANC12WA087Accident · 1 fatalForeign investigationPiper PA-30 · Kelowna, CanadaOn August 13, 2012, about 1729 Pacific daylight time, a Piper PA-30 airplane, (Canadian Registration C-GLGJ) was on a VFR flight plan from Penticton to Boundary Bay, British Columbia. The Canadian Joint Rescue Coordination Centre received an ELT signal, and a…NTSB ENG12WA031Accident · No injuriesForeign investigationSikorsky S76 · Langara Lodge, BC, Canada, CanadaA Helijet Sikorsky S-76A helicopter was just about to land on a small floating heli-pad at the fishing lodge on Langara Island, when the pilot heard a loud bang and the #2 (right)engine (Rolls-Royce 250-C30) lost power. The pilot carried out an emergency…NTSB ERA12WA512Accident · 2 fatalClass 5 · ForeignCirrus SR22 · Marmara Sea, TürkiyeOn August 12, 2012, at 1115 Universal Coordinated Time (UTC), a Cirrus SR-22, Turkish Registration TC-SAS, was destroyed when it impacted the Marmara Sea during an instructional flight. The two pilots on board were fatally injured. The flight originated from…NTSB DCA12WA160Incident · No injuriesForeign investigationBAE BAE146 - 199 · Gaborone, BotswanaOn August 11, 2012 about 1136 UTC, A2-ABF, British Aerospace BAe 146-199, a scheduled commerical flight, operated by Air Botswana, after a loss of power in the no. 2 engine, aborted takeoff at Sir Seretse Khama International Airport, Gaborone, Botswana. There…NTSB DCA12WA125Incident · No injuriesForeign investigationBoeing 757-200 · Tenerife Sur, SpainThe Civil Aviation Accident and Incident Investigation Commission (CIAIAC) of Spain, has notified the NTSB of an accident involving a Boeing 757-200 that occurred on August 8, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CIAIAC…NTSB ENG12WA030Incident · No injuriesForeign investigationBoeing 757 · North Sea, United Kingdom, United KingdomA Boeing 757, registration number G-LSAN, during a post-maintenance test flight expereinced a No. 2 engine fuel leak and that engine was shut down. The airplane diverted and a succesful single engine landing was made. The Air Accident Investigation Branch…NTSB CEN12WA680Accident · No injuriesForeign investigationEmbraer · Liechtenstein, SwitzerlandOn August 6, 2012, at 1540 UTC, an Embraer 505 Phenom 300, Moroccan registration CN-MBR, owned and operated by Dalia Air, Morocco, was substantially damaged when it departed the runway and impacted a fence at the St. Gallen-Altenrhein Airport (LSZR),…NTSB CEN12WA640Accident · Serious injuriesForeign investigationPiaggio P149 · Hoogeveen, NetherlandsOn August 4, 2012, at 0945 coordinated universal time, a Piaggio P149D, Dutch registration D-EGIT, owned by a private individual and operated by the pilot, received substantial damage when it impacted terrain under unknown circumstances near Hoogeveen Airport…NTSB CEN12WA536Accident · Minor injuriesForeign investigationBell 407 · Tlaxco, MexicoOn August 4, 2012, at 1330 UTC, a Bell 407 helicopter, Mexico registration XC-SSP, owned and operated by Gobierno del Edo de Veracruz, sustained substantial damage when it lost engine power and impacted terrain near Tlaxco, Tlaxcala, Mexico. The pilot and 2…NTSB ENG12WA036Incident · No injuriesForeign investigationAirbus A319 · Rome, ItalyOn August 3, 2012, about 0900 local, an Airbus A319, registration EI-IMS, operated by Alitalia Airlines landed in Rome, Italy (LIRF) from Venezia, Italy (LIPZ). During a left turn for the stand at taxi in, the flight crew experienced abnormal skidding from…NTSB ERA12WA497Accident · 1 fatalForeign investigationCessna A188A · Casanare, ColombiaOn August 2, 2012, about 1830 universal coordinated time, a Cessna A188A, Columbian registration HK-1477, was substantially damaged when it impacted wires and terrain during an aerial application flight near Casanare, Columbia. The foreign certificated pilot…NTSB CEN12WA506Accident · 2 fatalForeign investigationCessna 500 · Santiago de Compostela, SpainOn August 2, 2012, at 0440 UTC, a Cessna 500 Citation, Spanish registration EC-IBA, owned and operated by AIRNOR, was destroyed when it impacted terrain 1.2 miles from the Santiago de Compostela Airport, Lavacolla, Galacia, Spain. The two pilots on board the…NTSB CEN12WA528Accident · Serious injuriesForeign investigationCessna 180G · Kenora, CanadaNTSB DCA12WA120Incident · No injuriesForeign investigationBoeing 737 · Johannesburg, South AfricaOn July 30, 2012, at approximately 0920 UTC, a Boeing 737-800, registration ZS-SJB, s/n 29249, operated by South African Airways, experienced a sudden decompression approximately one hour after takeoff. The cabin oxygen masks deployed from the overhead panels…NTSB ERA12WA488Accident · 8 fatalForeign investigationBeech 200 · Juiz de Fora, BrazilThis investigation is being conducted by the Brazilian Aeronautical Accident Prevention and Investigation Center This report is for information purposes only and contains only information released by the government Brazil. All inquiries should be directed to…NTSB DCA12WA135Accident · 3 fatalForeign investigationAgusta A109 · Jiquipilco, MexicoThe Mexican Dirección General de Aeronáutica Civil (DGAC) has notified the NTSB of an accident involving a AgustaWestland 109SP helicopter that occurred on July 28, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC investigation…NTSB DCA12WA117Incident · No injuriesForeign investigationBoeing 757 · Linz, AustriaThe Austrian Civil Aviation Safety Investigation Authority (CASIA) has notified the NTSB of an accident involving a BOEING 757 airplane that occurred on July 28, 2012. The CASIA delegated the investigation to the German Federal Bureau of Aircraft Accidents…NTSB CEN12WA505Accident · No injuriesForeign investigationBeech 200 · Cambridge, United KingdomOn July 28, 2012, about 1540 UTC, a Beech B200 Super King Air, Belgian registration OO-LET, was substantially damaged when its landing gear collapsed while landing at the Cambridge Airfield, Cambridge, England. The pilot and three passengers on board were not…NTSB CEN12WA535Accident · No injuriesForeign investigationCessna 210 · Antwerpen, BelgiumNTSB CEN12WA478Accident · 1 fatalForeign investigationCessna 172 · Portreath, United KingdomOn July 21, 2012, at 1421 UTC, a Cessna F172M, United Kingdom registration G-ROUP, was substantially damaged when it impacted a cliff near Portreath, Cornwall, England. A post impact fire ensued. The pilot, the sole person on board was fatally injured. Visual…NTSB WPR12WA327Accident · 3 fatalForeign investigationEurocopter EC120B · Triso, MalaysiaOn July 20,1012, at 1335 universal coordinated time, a Eurocopter EC120B, N8899, ditched into the Batang Lupar River, near Triso, Malaysia. The helicopter had a United States registration and was operated by the Sebiro Holding Company under the provisions of…NTSB DCA12WA121Accident · No injuriesForeign investigationBoeing 737 · La Serena, ChileOn July 18, 2012, a Sky Airline Boeing 737-200, registration CC-CRQ, struck its right wingtip during a visual approach to runway 30 at La Florida Airport, La Serena, Chile. There were no injuries to any of the 120 passengers and crew onboard but the airplane…NTSB ERA12WA457Accident · 2 fatalForeign investigationBeech B36TC · Nassau, BahamasNTSB CEN12WA523Accident · No injuriesForeign investigationAir Tractor AT802 · San Rafael, SpainOn July 16, 2012, about 1430 coordinated universal time, a Spanish-registered Air Tractor AT-802 airplane, EC-HMD, performed a forced landing following a loss of engine power near San Rafael, Ibiza, Spain. The pilot, the sole occupant, was not injured. The…NTSB DCA12RA110Accident · 3 fatalForeign investigationGulfstream GIV · Le Castellet, FranceNTSB CEN12WA681Accident · No injuriesForeign investigationMcdonnell Douglas 500 · Kastire, LatviaOn July 12, 2012, about 0945 local time, a McDonnell Douglas MD-500 helicopter, registration OH-HJR, sustained substantial damage when it impacted terrain near Kastire, Latvia. The pilot was not injured. This investigation is under the jurisdiction of the…NTSB WPR12WA334Accident · 1 fatalForeign investigationPiper PA34 · Broome, Australia, AustraliaOn July 11, 2012, at 2020 universal coordinated time, a Piper PA-34-200, VH-LCK, collided with terrain near Broome, Australia. The airplane was a charter flight operating under the pertinent civil regulations of Australia. The pilot was fatally injured and…NTSB ERA12WA446Accident · 2 fatalForeign investigationRobinson R22 · Sao Paulo, BrazilOn July 11, 2012, at 1300 Universal Coordinated Time (UTC), a Robinson R22 Beta, Brazilian registration PT-HOL, operated by Master Escola Aviacao Civil Ltda, was destroyed following a loss of in-flight control and collision with a building near Sao Paulo,…NTSB CEN12WA685Accident · 3 fatalForeign investigationPiper PA-30 · Soyapango, El SalvadorOn July 11, 2012, at 1212 coordinated universal time, a Piper PA-30, El Salvador-registered YS-125P, operated by Escuela De Pilotos Dargonza, was destroyed when it impacted terrain near Soyapango, El Salvador. Visual meteorological conditions prevailed at the…NTSB ERA12WA463Accident · 1 fatalClass 5 · ForeignPiper PA36 · San Alberto, ColombiaOn July 10, 2012, about 1230 universal coordinated time, a Piper PA-36-375, Colombian registration HK2210, operated by Aeropenort LTDA. Agropecuaria del Norte, was substantially damaged when it collided with trees, during an aerial application flight near San…NTSB CEN12WA683Accident · Serious injuriesForeign investigationNorth American Rockwell OV-10B · Kemble, United KingdomOn July 10, 2012, about 1450 coordinated univeral time, a North America Rockwell OV-10B airplane, G-BZGK, impacted terrain near Kemble, United Kingdom. The pilot was seriously injured and the airplane was destroyed. The accident investigation is under the…NTSB ERA12WA447Accident · 1 fatalClass 5 · ForeignCessna 208 · Sao Paulo, BrazilOn July 9, 2012, at 1700 UTC, a Cessna 208, Brazilian registration PT-OQR, was substantially damaged when it collided with a parachutist during a local skydiving flight from Boituva Airport (SDOI), Boituva Municipality, Sao Paulo, Brazil. The parachutist…NTSB ENG12WA027Incident · No injuriesForeign investigationBoeing 747 · London England, United KingdomOn July 9, 2012, at 22:08 UTC, an EL-AL Israel Airlines Boeing 747-400, registration number 4X-ELD, flight No. LY-318, powered by four Pratt & Whitney PW4056 tubofan engines, experienced a No. 4 (right outboard) engine failure 20 minutes after takefoff from…NTSB WPR12WA331Accident · 3 fatalForeign investigationBell 206 · Chuxiong City, China, ChinaOn July, 7 2012, about 1525 UTC, a Bell 206L, P2 HCY, crashed into the Qingshanzui Reservoir in Chuxiong City, China. The helicopter was operated by Yunnan General Aviation Co. Ltd., under the pertinent civil regulation of China. The aircraft was…NTSB ERA12WA451Accident · 1 fatalForeign investigationEmbraer EMB820 · Espinosa Municipality, BrazilOn July 6, 2012, at 1340 Universal Coordinated Time (UTC), a Piper PA-31-350 (Embraer 820C), Brazilian registration PT-ENG, operated by Microsurvev Aerogeof. E Cons. Cient. Ltda, was destroyed during a forced landing following a loss of power to both engines.…NTSB DCA12WA109Accident · Serious injuriesForeign investigationBoeing 777-222 · Narita, JapanNTSB DCA12WA108Accident · Serious injuriesForeign investigationBoeing 747-400 · Tokyo, JapanOn July 5, 2012, a Boeing 747-400, HL7473, operated by Korean Air Lines Co., Ltd., as flight KAL2711, departed from the Gimpo International Airport (GMP), Seoul, South Korea, en route to the Tokyo International Airport (HND), Tokyo, Japan. Approximately 100…NTSB DCA12WA105Incident · No injuriesForeign investigationAirbus A319 · Okinawa, JapanOn July 5, 2012, about 1324 Japan Standard Time (0424 UTC), an Airbus A319-112, (B2332), operated by China Eastern Airlines Co., Ltd., was instruction to hold short of the runway at the Naha Airport (OKA), Okinawa, Japan; however, the flight crew taxied onto…NTSB DCA12WA104Accident · Serious injuriesForeign investigationBoeing 737 · Frankfurt, GermanyOn 5 July, 2012, at approximately 1100 UTC, a SunExpress Deutschland B737-800, registration D-ASXE, encountered turbulence during cruise between Gaziantep, Turkey, and Frankfurt, Germany. Of the 86 passengers and crew onboard, one crew member received serious…NTSB ERA12WA444Accident · 2 fatalForeign investigationLancair · Concepcio, ArgentinaOn July 3, 2012, about 1230 coordinated universal time (0930 local time), a Lancair IV-P, Argentine registration LV-X243, was substantially damaged when it impacted terrain in Concepcion, Corrientes Province, Argentina. The pilot and the passenger were…NTSB DCA12WA102Incident · No injuriesForeign investigationBoeing 767-323 · Sao Paulo, BrazilThe Brazilian Centro de Investigação e Prevenção de Acidentes Aeronáuticos (CENIPA) has notified the NTSB of an incident involving a Boeing 767 that occurred on July 3, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU…NTSB DCA12WA107Incident · No injuriesForeign investigationBoeing 777 · Urumqi, ChinaThe Civil Aviation Authority of China (CAAC) has notified the NTSB of an incident involving a Boeing 777-300 that occurred on July 2, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CAAC investigation under the provisions of ICAO…NTSB CEN12WA418Accident · 1 fatalClass 5 · ForeignBell 412 · Valencia, SpainOn July 2, 2012, about 1430 universal coordinated time (UTC), a Bell 412EP helicopter, Spanish registration EC-KSJ, impacted the Forata reservoir near Valencia, Spain. The pilot, the sole occupant, is missing. Pieces of the helicopter have been located on the…NTSB CEN12WA449Accident · Minor injuriesForeign investigationBell 214 · Gulf of Mexico, MexicoOn June 29, 2012, about 1200 central daylight time, a Bell 412 helicopter, XA-ICL, landed hard in the Gulf of Mexico off the coast of Ciudad del Carmen, Mexico. The pilot and 2 crew all received minor injuries. The helicopter sank in the water and has not…NTSB CEN12WA412Accident · 1 fatalForeign investigationHughes 369 · Lieser, GermanyOn June 29, 2012, at 0705 UTC, a Hughes HU369D helicopter, German registration D-HLUX, owned and operated by Hahn Helicopters Flugdienste GmbH, was destroyed when it struck a powerline and subsequently impacted terrain near Lieser, Germany. The pilot, the…NTSB CEN12WA397Accident · 2 fatalForeign investigationCessna 152 · Cascais, PortugalOn June 26, 2012, about 2135 coordinated universal time, a Cessna 152, Portuguese registration CS-AUR, sustained substantial damage when it impacted terrain near Cascais, Portugal. The pilot and one passenger were fatally injured. Night conditions prevailed…NTSB CEN12WA411Accident · 2 fatalForeign investigationCessna 150 · Strasswalchen, AustriaOn June 21, 2012, at 1332 UTC, a Reims Aviation F-150L, Austrian registration OE-ATV, was destroyed when it departed controlled flight and impacted terrain 3 miles east of Strasswalchen, Austria. The pilot and passenger on board were fatally injured. Visual…NTSB ENG12WA029Incident · No injuriesForeign investigationAirbus A320 · Auckland, New Zealand, New ZealandOn 20 June 2012, an Airbus A320 (Registration ZK-OJQ) operated by Air New Zealand suffered a bird-strike on its right-hand engine on approach to Wellington Aerodrome (New Zealand). The aircraft landed safely, after which Air New Zealand Maintenance carried…NTSB DCA12WA099Incident · No injuriesForeign investigationBoeing 737 · Taoyuan, TaiwanThe Taiwan Aviation Safety Council (ASC) has notified the NTSB of an accident involving a Boeing 737 that occurred on June 20th, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the ASC investigation under the provisions of ICAO Annex…NTSB DCA12WA097Accident · No injuriesForeign investigationBoeing 767 · Tokyo, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 767-300 that occurred on June 20, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex…