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 ANC13WA088Incident · No injuriesForeign investigationMooney M20J · Wonju, South KoreaOn October 17, 2012, at 1703 local time, a Korean registered Mooney M20J airplane, HL1062, had a loss of engine power, and an off airport landing about 7 miles northwest of the Wonju Airport, Republic of Korea. The airplane was operated by Korea Aerospace…NTSB ERA13WA031Accident · 1 fatalForeign investigationRobinson R-44 · Moscow, RussiaNoneNTSB DCA13WA003Incident · No injuriesForeign investigationBombardier CL600 2C10 · Lorient, FranceOn 16 October, 2012, at approximately 1923 UTC (2123 local time), a Canadair CRJ-700, registration F-GRZE, operated by Britair as flight 5937 from Paris to Lorient (France), landed on Lorient Airport runway 25, and proceeded to overrun the end of the runway,…NTSB CEN13WA140Accident · Serious injuriesForeign investigationPiper PA34 · Victoriaville, CanadaOn October 15, 2012, at 1402 eastern daylight time, a Piper PA-34-200, Canadian registration C-GNAS, owned and operated by Nadeau Air Service, was substantially damaged when it impacted terrain near Victoriaville, Quebec, Canada, following a catastrophic…NTSB DCA13RA001Accident · Serious injuriesForeign investigationBoeing 737 · Antalya, TürkiyeThe Directorate General of Civil Aviation (DGCA), of the Republic of Turkey, has notified the NTSB of an accident involving a Boeing 737-800 that occurred on October 14, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the DGCA…NTSB DCA13WA177Incident · No injuriesForeign investigationBoeing 737 · Tabing, IndonesiaThe National Transportation Safety Committee (KNKT) of Indonesia has notified the NTSB of an accident involving a Boeing 737 that occurred on October 13, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the Indonesia KNKT's…NTSB DCA13WA002Accident · No injuriesForeign investigationMcdonnell Douglas MD11 · Sao Paulo, BrazilNTSB ERA13WA108Incident · No injuriesForeign investigationSikorsky S61 · Carauari, BrazilOn October 10, 2012, at 1630 Coordinated Universal Time (UTC), a Sikorsky S-61, Brazilian registration PR-HRU, experienced a loss of power in the number one engine and performed a single-engine landing to Carauari Airport, Carauari Municipality, Brazil. The…NTSB ENG13RA002Incident · No injuriesForeign investigationAirbus A330 · Paris, France, FranceOn October 11, 2012, a TAM Linhas Aéreas Airbus A330-223, Brazilian registration number PT-MVE, flight number JJ8055, experienced an No. 2 (left) engine (a Pratt & Whitney PW4168 turbofan) failure after take-off from Charles De Gaulle (CDG) airport, Paris…NTSB ENG13WA001Incident · No injuriesForeign investigationBeech 1900 · Lyon, FranceOn October 09, 2012, at 9:40 am local time, a Beechcraft 1900, F-GOPE, operated by Hex'Air, experienced a elevator trim system failure after take-off at Lyon-Saint Exupery airport(LFLL), France. A post flight inspection revealed that the elevator trim forward…NTSB ERA13WA156Accident · 1 fatalForeign investigationCessna 172S · Izmir, TürkiyeOn October 6, 2012, at 0915 Coordinated Universal Time (UTC), a Cessna 172S, Turkish registration TC-CBI, operated by the Turkish Aeronautical Association, impacted mountainous terrain during an instructional flight, near Izmir, Turkey. The flight instructor…NTSB DCA13WA174Incident · No injuriesForeign investigationCessna 210 - N · Outjo, NamibiaOn October 6, 2012 about 1400 UTC, V5-YUL, Cessna 210N, had a partial loss of engine power followed by a precautionary landing near Outjo, Namibia. Visual meteorological conditions existed at the time. None of the 4 occupans were injured. The airplane was not…NTSB ENG15WA014Incident · No injuriesForeign investigationBoeing 737 - 73V · Incheon, South KoreaOn October 5, 2012, an Easter Jet Boeing 737-700 powered by two CFM 56-7B20 turbofan engines experienced a No. 2 engine failure while climbing through 22,500 feet after takeoff from Gimpo International Airport, Seoul, South Korean. The flight crew shutdown…NTSB WPR13WA014Accident · 1 fatalForeign investigationRobinson R22 · Halls Creek, Australia, AustraliaOn October 3, 2012, at about 1100 universal coordinated time, a Robinson Helicopter Company, R-22 Beta, VH-LLF, sustained substantial damage when it collided with the side of a canyon near the Halls Creek Aerodrome, Australia. The pilot was fatally injured.…NTSB ERA13WA030Accident · 1 fatalForeign investigationPiper PA25 · Juquiá Municipality, BrazilOn October 03, 2012, at 1100 universal coordinated time, a Piper PA-25-260, Brazilian registration PT-DOX, was destroyed when it impacted the ground and was consumed by fire after colliding with high-tension electric wires. The pilot was fatally injured. The…NTSB ERA13WA085Accident · No injuriesForeign investigationThrush S2R-T34 · Naranjal, EcuadorOn October 2, 2012, a Thrush S2R-T34, Ecuadorian registration HC-CFU, operated by a private owner, was substantially damaged following an engine failure and collision with terrain near Naranjal Province, Guayas, Ecuador. The flight's last departure point and…NTSB DCA12WA159Accident · No injuriesForeign investigationBoeing 777 · Rome, ItalyOn September 30, 2012, about 1305 Coordinated Universal Time (UTC), a Boeing 777-200 sustained damage to the forward left passenger door and aircraft structure when a jetbridge was moved during boarding operations at Rome Fiumicino Airport, Rome, Italy. There…NTSB CEN12WA664Accident · 6 fatalForeign investigationCessna 414A · Innsbruck, AustriaNTSB DCA12RA153Accident · 19 fatalForeign investigationKathmandu, NepalOn September 28, 2012, a Sita Air Dornier 228, registration 9N-AHA, with Garrett (Honeywell) TPE 331 engines, reported a bird strike shortly and crash shortly after takeoff from Kathmandu-Tribhuvan Airport (KTM), Kathmandu, Nepal. The three crew members and…NTSB CEN13WA028Accident · No injuriesForeign investigationCirrus SR22 · Vienna, AustriaOn September 26, 2012, at 0819 coordinated universal time, a Cirrus SR22, Slovenian registration S5-DIW, sustained substantial damage during a hard landing to Runway 29 at Vienna International Airport (LOWW), Vienna, Austria. The pilot and two passengers were…NTSB ERA12WA590Accident · 1 fatalForeign investigationPiper PA34 · Ilheus, BrazilOn September 25, 2012, about 0155 universal coordinated time, a Piper PA-34-200T, Brazilian registration PT-RDG, was substantially damaged when it impacted the Atlantic Ocean, shortly after takeoff from the Ilheus Jorge Amado Airport (SBIL), Ilheus, Bahia,…NTSB ERA12WA591Accident · 1 fatalForeign investigationCessna 210 · Roraima, BrazilOn September 24, 2012, about 0400 hours local, or 0800 UTC, a Cessna 210L, Brazilian registration PT-KSB, departed controlled flight and crashed shortly after takeoff from Pouso Da Aguilia Airport (SWPD), Roraima, Brazil. Visual meteorological conditions…NTSB DCA12WA146Accident · No injuriesForeign investigationBoeing 767-332 · Sao Paulo, BrazilNTSB DCA12WA147Incident · No injuriesForeign investigationBoeing 737 · Riyadh, Saudi ArabiaOn Spetember 13, 2012 a Boeing 737 operated by Royal Air Moroc experienced a failure of the left nosewheel after landing on runway 33L at King Khalid International Airport, Riyadh, Saudi Arabia. While taxing off the runway, pilot requested ground support due…NTSB DCA12RA148Incident · No injuriesForeign investigationBoeing 747-8F · Shanghai, ChinaOn September 11, 2012 at about 1109 China Standard Time (0309 UTC), a Boeing 747-8F, registration VQ-BLR, equipped with GEnx-2B engines and operated by Air Bridge Cargo Airlines, experienced an engine failure and subsequently rejected takeoff at Shanghai…NTSB ERA13WA205Accident · 4 fatalForeign investigationCessna 172N · Acreúna Municipality, BrazilNTSB ERA12WA577Accident · 1 fatalForeign investigationCessna 172R · Macapá, BrazilOn September 12, 2012, about 2112 universal coordinated time, a Cessna 172R, Brazilian registration PT-WYK, was destroyed when it collided with terrain under unknown circumstances near Macapa ´, Brazil. The non-certificated pilot was fatally injured. The…NTSB DCA12WA144Incident · No injuriesForeign investigationBoeing 747-47UF · Melbourne, AustraliaOn September 9, 2012 a Boeing 747 operated by Atlas Air did not comply with the height and tracking requirements of the BADGR SIX STAR to Melbourne Airport. The investigation is being conducted by the Australian Transport Safety Bureau. www.atsb.gov.auNTSB ERA12WA556Accident · 2 fatalForeign investigationCessna 402 · Rome, ItalyOn September 7, 2012, about 1100 Universal Time Coordinate (UTC), a Cessna 402B, Italian registration I-EJRA, operated by Rilievi Aerofotogrammetrici, impacted the ground near Rome, Italy. Visual meteorological conditions prevailed and flight plan information…NTSB DCA12WA145Incident · No injuriesForeign investigationBoeing 737-800 · Gran Canaria, SpainThe Civil Aviation Accident and Incident Investigation Commission (CIAIAC) of Spain, has notified the NTSB of an accident involving a Boeing 737-800 that occurred on September 7, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB DCA12RA143Incident · No injuriesForeign investigationBoeing 737 · Mexico City, MexicoOn September 5, 2012, an Aeromexico Boeing 737-800, registration XA-JOY, experienced heavy vibration during the landing roll and multiple ceiling panels and passenger service units fell down in the aft cabin at Benito Juárez Mexico City International Airport…NTSB CEN12WA610Accident · No injuriesForeign investigationSocata TB200 · Evora Aerodrome, PortugalOn September 5, 2012, at 1053 coordinated universal time, a Socata TB200, Portuguese registration CS-DEH, owned by CAE Global Academy of Evora and piloted by a student pilot, received substantial damage when it impacted terrain under unknown circumstances…NTSB ERA12WA552Accident · Minor injuriesForeign investigationAgusta Bell 206-3B · Al Ain, United Arab EmiratesOn September 4, 2012, about 0730 coordinated universal time (1130 gulf standard time), an Augusta-Bell 206-3B, United Arab Emirates registration A6-FTB, was substantially damaged when it impacted terrain in a flight training area near Al Ain International…NTSB DCA12WA142Incident · No injuriesForeign investigationBoeing 737 · Bonn, GermanyOn September 3, 2012, at approximately 101 UTC time, a XL Airways B737-800, registration D-AXLF, while on a non-scheduled revenue flight from Koln to Bonn, Germany, reported smoke in the cockpit and in the cabin. The flight landed safely and there were no…NTSB CEN12WA677Accident · 2 fatalForeign investigationRobinson R44 · Nyons, FranceOn September 3, 2012, about 0845 UTC, a Robinson R44 helicopter, Spanish registration EC-IVT, was destroyed when while in level cruise it departed controlled flight and impacted in mountainous terrain near Nyons, France. The pilot and a passenger on board the…NTSB ENG12RA034Accident · 3 fatalForeign investigationBritten Norman BN2B · Taipei, Taiwan R.O.C., TaiwanOn August 30, 2012, a Britten-Norman BN-2B-26 Islander plane, registration number B-68801, powered by two Lycoming 0-540-E4C5 reciprocating engines crashed in a high mountain area in northern Taiwan Republic of China while performing an aerial photography…NTSB DCA12WA131Incident · No injuriesForeign investigationBoeing 767 · London, United KingdomThe United Kingdom Air Accident Investigation Branch (AAIB) has notified the NTSB of an accident involving a Boeing 767 airplane that occurred on August 27, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB ERA12WA544Accident · 3 fatalForeign investigationCessna 210N · Agua Clara, BrazilOn August 25, 2012, at 1215 Universal Coordinated Time (UTC), a Cessna 210N, Brazilian registration PT-OKZ, operated by a private individual, was destroyed following a collision with terrain near Agua Clara, Brazil. The flight originated at Tres Lagoas,…NTSB CEN12WA575Accident · 4 fatalForeign investigationCessna 172 · Moorefield, CanadaOn August 24, 2012, about 2030 eastern daylight time, a Cessna 172S, Canadian registration C-FNET, was substantially damaged on impact with terrain near Moorefield, Ontario, Canada. The pilot and three passengers sustained fatal injuries. Visual…NTSB WPR12WA374Accident · 4 fatalForeign investigationPiper PA31 · Bontang, Indonesia, IndonesiaOn August 24, 2012, at 0551 universal coordinated time, a Piper PA-31-350, PK-IWH, operated by PT. Intan Angkasa Air Service under the pertinent civil regulations of Indonesia, collided with Mt. Tundung Mayang, near Bontang, Indonesia, at an elevation of…NTSB ERA12WA534Accident · 1 fatalForeign investigationGulfstream G-164B · Calabozo, VenezuelaOn August 24, 2012, about 2000 universal coordinated time, a Gulfstream G-164B, Venezuelan registration YV264A, registered to Fumiwan C.A, was substantially damaged when it impacted terrain during an aerial application. The pilot was fatally injured. The…NTSB DCA12WA133Accident · No injuriesForeign investigationDouglas DC9 · Santo Domingo, VenezuelaThe Venezuela Dirección General para la Prevención e Investigación de Accidentes Aéreos (PIAA) has notified the NTSB of an accident involving a Douglas DC-9-82 that occurred on August 24, 2012. The NTSB has appointed a U.S. Accredited Representative to assist…NTSB CEN12WA674Accident · 4 fatalForeign investigationPilatus PC12 · Solemont (Doubs), FranceNTSB ERA12WA554Accident · Serious injuriesForeign investigationBell 212 · Malvinas, PeruOn August 23, 2012, about 2020 universal coordinated time (1520 local time), a Bell 212, Peruvian registration OB-1912-P, operated by Los Andes S.A.C., was substantially damaged when it impacted terrain while approaching a jungle landing site about 19…NTSB DCA12WA140Incident · No injuriesForeign investigationBoeing 747-400 · Jeddah, Saudi ArabiaThe Kingdom of Saudi Arabia, General Authority of Civil Aviation (GACA), has notified the NTSB of an ground collision accident involving a Boeing 747-300 and a Boeing 747-400 that occurred on August 20, 2012. The NTSB has appointed a U.S. Accredited…NTSB ERA12WA530Accident · 4 fatalForeign investigationEmbraer EMB711 · Sta Barbara D'Oeste, BrazilOn August 18, 2012, at 1140 UTC an Embraer EMB-711C (Piper PA-28R-200), Brazilian registration PT-NKA, registered to a private owner, and a Embraer EMB-711C (Piper PA-28R-200), Brazilian registration PT-NIR, registered to a private owner, collided in cruise…NTSB CEN12WA646Accident · No injuriesForeign investigationBeech A60 · Hyères, FranceNTSB CEN12WA560Accident · 2 fatalForeign investigationPaulistinha 56-C1 56-C1 · Braga, PortugalThis report is under the jurisdiction and control of the Portuguese Government.NTSB DCA12WA127Incident · No injuriesForeign investigationBoeing 747-400 · London, United KingdomThe United Kingdom's Air Accidents Investigations Branch (AAIB), has notified the NTSB of an accident involving a Boeing 747-400 that occurred on August 17, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB CEN12WA562Accident · 2 fatalForeign investigationPiper PA-38-112 · Bruera, Cheshire, United KingdomOn August 16, 2012, about 1940 universal coordinated time, a Piper PA-38-112 airplane, United Kingdom registration G-BODP, impacted terrain during an instructional flight near Bruera, Cheshire, United Kingdom. The flight instructor and student pilot were…