OpenAirDocs.org

NTSB investigations, 2011, Outside the U.S.

180,598 investigations by the National Transportation Safety Board since 1962: 174,578 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 per year

19622026

Latest cases

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\") = 2011
    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 ERA12WA133Accident · 2 fatalForeign investigationPiper PA28 · Andres Bello,Tachira, VenezuelaOn December 29, 2011, about 1415 universal coordinated time, a Piper PA28-161, Columbian registration HK3934, was substantially damaged when it impacted terrain while in cruise flight near Andres Bello, Tachira, Venezuela. The two pilots were fatally injured.…Dec 29, 2011 · HK3934 · Substantial damageNTSB DCA12WA022Accident · No injuriesForeign investigationBoeing 737 · Yogyakarta, IndonesiaThe Komite Nasional Keselamatan Transportasi of Indonesia (KNKT) has notified the NTSB of an incident involving a Boeing 737 that occurred on December 20, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under the…Dec 20, 2011 · PK-CKM · Substantial damageNTSB DCA12CA023Accident · No injuriesData collectionFinal reportUniversity Of Kansas Meridian · McMurdo, AYan aerodynamic stall induced by an inadvertent autopilot Home command. The Home command was entered following a loss of the direct radio link due to improperly set failsafe settings, and an unintentional latching of Home mode from an earlier functionality…Dec 19, 2011 · UNREG · Substantial damageNTSB CEN12WA105Accident · 2 fatalForeign investigationCessna 177A · Ottawa, CanadaOn December 14, 2011, at 1920 eastern standard time, a Cessna model 177A, Canadian registration C-FEFQ, collided with terrain 2 nautical miles west of Ottawa Macdonald-Cartier International Airport (CYOW), Ottawa, Canada. The flight had been cleared for the…Dec 15, 2011 · C-FEFQ · Substantial damageNTSB DCA13WA052Incident · No injuriesForeign investigationBeech 1900 · Goose Bay, CanadaOn 10 December 2011, at 1028 Newfoundland Standard Time, an Exploits Valley Air Services Hawker Beechcraft 1900D aircraft (registration C-GLHO, serial number UE-266), operating as Air Canada Express flight EV7645, was conducting a scheduled passenger flight…Dec 10, 2011 · C-GLHO · No damageNTSB ERA12WA113Accident · 1 fatalForeign investigationRobinson R44 · Sao Bento do Sul, BrazilOn December 9, 2011 at 1630 universal coordinated time, a Robinson R44, Brazilian registration PR-KLA, operated by SASH Locacao de Veiculos LTDA, as a personal flight, impacted terrain in the vicinity of Fazenda Coqueiros, Sao Bento do Sul, Santa Catarina,…Dec 9, 2011 · PR-KLA · Substantial damageNTSB WPR12WA063Accident · 1 fatalForeign investigationCessna 210 · Roma, Australia, AustraliaOn December 7, 2011, at 0530 universal coordinated time, a Cessna 210M, VH-WBZ, collided with terrain near Roma, Australia. The airplane was substantially damaged and the pilot, the sole occupant, was fatally injured. The flight was operated under the…Dec 7, 2011 · VH-WBZ · Substantial damageNTSB ERA12WA104Accident · No injuriesForeign investigationPiper PA28 · Bogota, ColombiaOn December 6, 2011, about 1815 Universal Coordinated Time (UTC), a Piper PA-28-236, Columbian registration HK2308, operated by Aeroclub de Colombia, incurred substantial damage to the left wing and separated the left main gear when it collided with a tree…Dec 6, 2011 · HK2308 · Substantial damageNTSB DCA12WA018Incident · No injuriesForeign investigationBoeing 737 · Seoul, South KoreaThe Korean Aviationand Railway Accident Investigation Board (ARAIB) has notified the NTSB of an accident involving a Boeing 737 that occurred on December 4, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the ARAIB investigation under…Dec 4, 2011 · HL-7796 · Minor damageNTSB DCA12WA030Incident · No injuriesForeign investigationBoeing 777 · Maldives, MaldivesThe UAE General Civil Aviation Authority (GCAA) has notified the NTSB of an incident involving a Boeing 777 that occurred on December 2, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA investigation under the provisions of…Dec 2, 2011 · A6-EMR · Minor damageNTSB ERA12WA103Accident · 4 fatalForeign investigationCessna TU206 · Cerro Escalera, PeruOn December 1, 2011, about 2048 UTC, a Cessna TU206G, Peruvian registration OB-1299, registered to and operated by Palmas del Espino S.A., collided with mountainous terrain near Cerro Escalera, Peru. Weather conditions at the altitude, location, and time of…Dec 1, 2011 · OB-1299 · Substantial damageNTSB ERA12WA105Accident · 2 fatalForeign investigationCirrus SR20 · Minas Gerias, BrazilOn November 26, 2011, about 1300 universal coordinated time, a Cirrus SR20, Brazilian registration PR-LJL, operated by a private individual, was substantially damaged when it impacted terrain in Carmo do Cajuri Municipality, Minas Gerais, Brazil. The pilot…Nov 26, 2011 · PR-LJL · Substantial damageNTSB DCA12WA019Accident · No injuriesForeign investigationGulfstream American G 1159 · Huambo, AngolaOn November 26, 2011, about 1300 UTC, N811DE, a Grumman G-1159 Gulfstream G-II, a private flight operated by Wings Over Africa, was involved in a runway excursion following a rejected takeoff. None of the 10 persons aboard were injured. The aircraft was…Nov 26, 2011 · N811DE · Substantial damageNTSB ERA12WA086Accident · Serious injuriesForeign investigationBell 212 · Quito, EcuadorOn November 25, 2011, about 1640 coordinated universal time (1140 local time), a Bell 212, Ecuadorian registration HC-CLH, operated by Aeromaster Airways, S.A., was substantially damaged when it impacted steep terrain next to the company's helipad in Quito,…Nov 25, 2011 · HC-CLH · Substantial damageNTSB ERA12LA085Accident · Serious injuriesLimited investigationFinal reportPiper PA 46-350P · Caribbean Sea, A1The total loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered. Contributing to the accident was the pilot’s failure to comply with the airplane and engine limitations, and his decision to…Nov 24, 2011 · N534P · Substantial damageNTSB ERA12WA136Accident · No injuriesForeign investigationPiper PA36 · Machala, EcuadorOn November 23, 2011, about 2000 coordinated universal time, a Piper PA-36-300, Ecuadorian registration HC-BHJ, operated by Aerorient Fumigacion Aerea, was substantially damaged when the pilot made a forced landing following loss of engine power in a banana…Nov 23, 2011 · HCBHJ · Substantial damageNTSB ERA12WA091Incident · No injuriesForeign investigationPiper PA23 · Quibdo, ColombiaOn November 23, 2011, about 1717 UTC, a Piper PA-23-250, Colombian registration HK1263, operated by Aerolineas Alas de Colombia LTDA, experienced collapse of the left main landing gear during the landing roll at the El Carano Airport (SKUI), Quibdo, Colombia.…Nov 23, 2011 · HK1263 · Minor damageNTSB ERA12WA102Accident · 1 fatalForeign investigationCessna 210 · Alto Alegre, BrazilOn November 22, 2011, at 1740 universal time coordinated, a Cessna Aircraft, Model 210L, Brazilian registration PT-IOT, impacted the ground after reporting an engine failure near Aldeia Hali Katu, in the Alto Alegre Municipality, Roraima, Brazil. The airplane…Nov 22, 2011 · PT-IOT · Substantial damageNTSB ERA12WA089Accident · 2 fatalForeign investigationPiper PA-28-236 · Mercedes, ArgentinaOn November 21, 2011, about 1320 coordinated universal time, a Piper PA-28-236, Argentine Air Force designation PF-449, and a Cessna 152, Argentine registration LV-OOF, collided while on approach to Mercedes Airfield (MRD), Mercedes, Buenos Aires Province,…Nov 21, 2011 · PG-449 · 2 aircraft · Minor damageNTSB OPS12WA150Incident · No injuriesForeign investigationEmbraer EMB-145LR · Toronto, CanadaOn November 18, 2011, American Eagle (EGF) flight 4125, an EMB-145, landed on runway 24L at Toronto Lester B. Pearson International Airport (CYYZ) and exited the runway at taxiway D4 with instructions to hold short of runway 24R. EGF4125 subsequently crossed…Nov 18, 2011 · N620AE · No damageNTSB ERA12WA073Accident · 2 fatalForeign investigationCessna 150 · Santa Rosa, EcuadorOn November 14, 2011, about 2020 coordinated universal time (1520 local time), a Cessna 150M, Ecuadorian registration HC-BJA, was substantially damaged when it impacted rising terrain in the Girón Alto mountains near Santa Rosa, Ecuador. The Ecuadorian pilot…Nov 14, 2011 · HC-BJA · Substantial damageNTSB ERA12WA072Accident · 2 fatalForeign investigationCessna 210 · Cayman Brac, Cayman IslandsOn November 14, 2011, at 0525 universal coordinated time, a Cessna 210, registered in Mexico as XB-LLD, was substantially damaged when it struck wires and trees under unknown circumstances at Cayman Brac, Cayman Islands. The pilot and his passenger were…Nov 14, 2011 · XB-LLD · Substantial damageNTSB CEN12WA069Accident · 2 fatalForeign investigationCirrus Design SR22 · Gleisweiler, GermanyNov 14, 2011 · N956CD · Substantial damageNTSB CEN12WA068Accident · 4 fatalForeign investigationCirrus SR22 · Katowice, PolandOn November 13, 2011, about 1821 UTC, SP-IKP, a Polish registered Cirrus SR22 airplane, operated by a private pilot, sustained substantial damage when the airplane impacted trees and terrain near the Katowice-Pyrzowice airport, near Katowice, Poland. The…Nov 13, 2011 · SP-IKP · Substantial damageNTSB ERA12WA099Accident · 4 fatalForeign investigationCessna 210 · Cuiaba, BrazilOn November 12, 2011, about 2000 universal coordinated time, a Cessna 210N, Brazilian registration PT-VMG, was substantially damaged when it impacted terrain shortly after takeoff in Cuiaba Municipality, State of Mato Grosso, Brazil. The Brazilian…Nov 12, 2011 · PT-VMG · Substantial damageNTSB CEN12WA067Accident · 1 fatalForeign investigationPiper PA28 · Alderney, United KingdomOn November 12, 2011, about 1540 universal coordinated time (UTC), G-BXRG, a United Kingdom registered Piper PA-28-181, owned by Alderney Flying Training LTD, sustained presumed substantial damage when the airplane ditched and sunk in the English Channel…Nov 12, 2011 · G-BXRG · Substantial damageNTSB CEN12WA063Accident · 2 fatalForeign investigationHughes 500 · Andratx, SpainOn November 12, 2011, approximately 1020 coordinated universal time, a Hughes 500E, British registration G-WOOW, impacted terrain under unknown circumstances near Andratx, Mallorca, Spain. The pilot and passenger were both fatally injured. A post crash fire…Nov 12, 2011 · G-WOOW · Substantial damageNTSB ERA12WA092Accident · No injuriesForeign investigationPiper PA-25 · Meteropolitana, ChileOn November 11, 2011, at 1345 UTC, a Piper PA-25-260, Chilean registration CC-ABM, registered to and operated by Sociedad De Ttrabajos Aeros Aeropacifico LTDA as a personal flight experienced a partial loss of engine power on initial takeoff climb, in the…Nov 11, 2011 · CC-ABM · Substantial damageNTSB DCA12RA012Accident · 8 fatalForeign investigationEurocopter AS332L · Mexico City, MexicoOn November 11, 2011, a Eurocopter AS 332L Super Puma, registration XC-UHM, operated by Fuerza Aerea Mexicana (Presidential Use), crashed in a rural area south of Mexico City, enroute from Camp Marte, Mexico to Cuernavaca, Mexico. The eight passengers and…Nov 11, 2011 · XC-UHM · Substantial damageNTSB CEN12WA223Accident · 1 fatalForeign investigationPiper PA-31 · Cottens, SwitzerlandThe accident investigation is under the jurisdiction and control of the Swiss government. This report is for informational purposes only and contains only information released by or obtained from the Swiss government or the Swiss Accident Investigation Board.…Nov 10, 2011 · HB-LOT · DestroyedNTSB CEN12WA092Accident · 1 fatalForeign investigationSocata TBM 700 · Lyon, FranceNov 9, 2011 · N228CX · Substantial damageNTSB ERA12WA067Incident · No injuriesForeign investigationCessna 402 · Quibdo, ColombiaOn November 4, 2011, about 1640 UTC, a Cessna 402C, Colombian registration HK4417, registered to and operated by AeroEjecutivos De Antioquia S.A. experienced collapse of the left main landing gear during the takeoff roll from El Carano Airport (SKUI), Quibdo,…Nov 4, 2011 · HK4417 · Minor damageNTSB DCA12WA011Incident · No injuriesForeign investigationBoeing 777 · Munich, GermanyOn November 3, 2011, at about 1210 local time (1110 UTC), a Boeing 777-300, 9V-SWQ, experienced a runway excursion upon landing on runway 08R at Franz Joseph Strauss Munich Airport (EDDM), Munich, Germany. None of the 143 passengers or 15 crewmembers were…Nov 3, 2011 · 9V-SWQ · Minor damageNTSB CEN12RA052Accident · 3 fatalClass 5 · ForeignBell 206L · Kapuskasing, CanadaOn November 2, 2011, about 0958 eastern daylight time (EDT), a Bell 206L helicopter, Canadian registration C-GDQH, was substantially damaged during an in-flight collision with terrain in Kapuskasing, Ontario, Canada. The pilot and 2 passengers sustained fatal…Nov 2, 2011 · C-GDQH · Substantial damageNTSB DCA12WA009Accident · No injuriesForeign investigationBoeing 767 · Warsaw, PolandOn November 1, 2011, LOT Polskie Linie Lotnicze flight 16, a Boeing 767, registration SP-LPC, conducted an emergency gear up landing on runway 33 at Warszawa-Frédéric Chopin Airport (EPWA), Warsaw, Poland. There were no injuries to the passengers and…Nov 1, 2011 · SP-LPC · Substantial damageNTSB DCA12WA010Accident · No injuriesForeign investigationBoeing 777 - 200 · Nani, KenyaOn October 28, 2011 about 1544 hours UTC, a Boeing 777-200LR, registration number A7-BBD, operated by Qatar Airways, encountered inflight turbulence, during cruise flight near Nani, Kenya. A cabin crew member received serious injuries. The flight originated…Oct 28, 2011 · A7-BBD · No damageNTSB CEN12WA046Accident · 3 fatalForeign investigationPiper PA-31T · Toulouse, FranceUnder the jurisdiction and control of the French government.Oct 28, 2011 · OE-FKG · Substantial damageNTSB ANC12WA007Accident · No injuriesForeign investigationVancouver, CanadaOn October 27, 2011, about 1600 pacific daylight time, a Beechcraft King Air 100, C-GXRX, operated by Northern Thunderbird Air, Inc. as a non-scheduled passenger flight, collided with terrain while attempting to land at the Vancouver International Airport,…Oct 27, 2011 · Substantial damageNTSB DCA12WA007Accident · No injuriesForeign investigationBoeing 737 - 800 · Faro, PortugalTheAir AccidentInvestigation Unit (AAIU) ofIrelandhas notified the NTSB of an accidentinvolving a B737-8AS that occurred on October 20, 2011. The NTSBhas appointed a U.S. Accredited Representative to assist the AAIU investigationunder the provisions of ICAO…Oct 24, 2011 · EI-DPA · Substantial damageNTSB CEN12WA040Accident · 2 fatalForeign investigationCessna 210G · Veracruz, MexicoOct 23, 2011 · N5894F · Substantial damageNTSB WPR12WA186Accident · No injuriesForeign investigationPiper PA-34-220T · Karachi, PakistanOn October 20, 2011, at 1138 local time, a Piper PA-34-220T, Pakistan registry AP-BDK, was substantially damaged during a forced landing following a dual engine failure while in cruise flight. The aircraft was operated by M/S Schon Air Limited of Karachi,…Oct 20, 2011 · AP_BDK · Substantial damageNTSB DCA12WA005Accident · Serious injuriesForeign investigationBoeing 777 · Putong, ChinaOn October 17, 2011, a Singapore Airlines B777-300, Singapore registration 9V-SYH, operating as a passenger flight between Shanghai, China and Singapore, encountered turbulence while in cruise flight about 10nm east of waypoint KARAN. One passenger was…Oct 17, 2011 · 9V-SYH · No damageNTSB DCA12WA006Incident · No injuriesForeign investigationBangkok, ThailandOn October 16, 2011, a Qantas Airlines B747-400, Australian registration VH-OJS, experienced abnormal exhaust temperatures and vibrations in the number 3 engine while climbing. The engine was shutdown and the flight returned to Bangkok. There were no…Oct 16, 2011 · No damageNTSB ERA12WA041Accident · Serious injuriesForeign investigationBell 412 · Santa Rosa, VenezuelaOn October 15, 2011, at 1933 UTC, a Bell 412SP, YV0126, registered to and operated by Electrificacion del Caroni (EDELCA), as a business flight, collided with trees while on approach to Macagua Airport, Santa Rosa, Venezuela. The Venezuelan Government…Oct 15, 2011 · YVO126 · Substantial damageNTSB ENG12WA002Accident · 28 fatalForeign investigationDe Havilland DHC8 · Madang, Papua New Guinea, Papua New GuineaOn 13 Oct 2011, at about 1715, at about 10,000 feet during the descent for landing, the overspeed warning horn of a PNG Airlines DHC-8-102 aircraft, Papua New Guinea registration P2-MCJ sounded. At 1717, the crew made a MAYDAY call to ATC, indicating that…Oct 14, 2011 · P2-MCJ · DestroyedNTSB DCA12RA003Accident · 9 fatalForeign investigationCessna 208B · Xakanaka, BotswanaOn October 14, 2011, about 1350 local time, A2-AKD, a Cessna 208B chartered flight, crashed shortly after takeoff from an airstrip near Xakanaka, Botswana. Visual meteorological conditions prevailed. Of the 12 persons on board, the pilot and 8 passengers were…Oct 14, 2011 · A2-AKD · Substantial damageNTSB CEN12WA686Accident · 2 fatalForeign investigationPiper PA-28-140 · Petit-Beauregard, SwitzerlandOn October 14, 2011, at 0857 universal coordinated time, a Piper PA-28-140 airplane, G-BBEF, impacted terrain near Petit-Beauregard, Fontaines-sur-Grandson, Switzerland. The pilot and passenger were both fatally injured. The airplane was destroyed. The…Oct 14, 2011 · G-BBEF · DestroyedNTSB CEN12WA033Accident · 2 fatalForeign investigationDiamond DA20 · Amurrio, SpainOn October 14, 2011, at 1040 universal coordinated time, a Diamond DA20-C1 airplane, EC-KDS, sustained substantial damage when it impacted terrain near Amurrio, Spain. The two crewmembers sustained fatal injuries. The accident investigation is under the…Oct 14, 2011 · EC-KDS · Substantial damageNTSB DCA12WA002Incident · No injuriesForeign investigationBoeing 767 · Kansai, JapanOn October 12, 2011, at Kansai International Airport, a Boeing 767-300, registered N588HA, operated by Hawaiian Airlines Inc. (HAL450), received ATC instruction to hold short of runway A. The Hawaiian Airlines airplane entered into the runway at about 21:37.…Oct 12, 2011 · N588HA · 2 aircraft · No damageNTSB ENG12RA028Incident · No injuriesForeign investigationBoeing 737 · Antalya, TürkiyeOn October 10, 2011, a Sky Airlines B737-400 (TC-SKF), S/N 26291 flight ZY 8756 from BADEN (EDSB) to Antalya (LTAI) experience a right landing gear collapse during the landing sequence at Runway 18C. The landing gear tire deflated and A/C collapsed on the…Oct 10, 2011 · TC-SKF · Minor damage