NTSB investigations, 2011, 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\") = 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.
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
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 ANC12WA001Accident · 2 fatalForeign investigationCessna 208B · Utsigi Point, NT, CanadaOn October 4, 2011, about 1730 coordinated universal time, a Cessna 208B airplane registered to Air Tindi, Yellowknife, Northwest Territories, Canada sustained substantial when it impacted tree-covered terrain under unknown circumstances near Utsigi Point,…NTSB ERA12WA026Accident · 4 fatalForeign investigationBeech V35 · Maraba Paulista, BrazilOn October 1, 2011, about 2345 coordinated universal time (2045 local time), a Beechcraft V35, Brazilian registration PT-CTL, was substantially damaged when it impacted terrain between the cities of Maraba Paulista and Presidente Venceslau, Sao Paulo State,…NTSB CEN11WA683Accident · 1 fatalForeign investigationBell 212 · Bienservida, SpainNTSB ERA11WA520Accident · 2 fatalForeign investigationBeech D35 · Avare, BrazilOn September 29, 2011, about 1824 Universal Coordinated Time (UTC), a Beech D35, Brazilian registration PT-AVK, operated by a private owner, was destroyed following a collision with terrain at Santarém Municipality, State of Pará, Brazil. The local flight…NTSB DCA11WA108Accident · 18 fatalForeign investigationAviocar CASA C212 · Aceh, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an accident involving a Aviocar CASA C212 that occurred on September 29, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation…NTSB DCA11WA107Accident · No injuriesForeign investigationBoeing DC-9 · Puerto Ordaz, VenezuelaThe Venezuelan Junta Investigadora de Accidentes de Aviación Civil (JIAAC) has notified the NTSB of an incident involving a Boeing DC-9 that occurred on September 26, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the JIAAC's…NTSB WPR11WA476Accident · 2 fatalForeign investigationBell 412SP · Mataram, West Nusa, IndonesiaOn September 25, 2011, at 1341 local time (0541 UTC) a Bell Helicopter 412SP, Indonesia registry PK-OVC, crashed in a jungle under unknown circumstances 150 kilometers east of Selaparang Airport, Mataram, West Nusa Tenggara, Indonesia. The Helicopter was…NTSB DCA11WA103Accident · 19 fatalForeign investigationBeech 1900 · Bishankhunarayan, NepalOn September 25, 2011, at about 0734 local time (0149 UTC), a Hawker Beechcraft 1900D, registered in Nepal as 9N-AEK, crashed near the village of Bishankhunarayan, Nepal. Bishankhunarayan is approximately 15 km south of the capital, Kathmandu. The 3…NTSB WPR11RA480Incident · No injuriesForeign investigationAirbus A319 · Hassi Messaoud, AlgeriaOn September 22, 2011, about 2300 Coordinated Universal Time (UTC), Air France flight 558, an Airbus A319, F-GRXN, declared an emergency during cruise flight following an indication of smoke in the lavatory. The crew and passengers were not injured, and the…NTSB ANC12WA011Accident · No injuriesForeign investigationEurocopter AS350-B3 · Higashikagawa, JapanOn September 22, 2011, about 1012 Japan standard time, a Eurocopter AS350-B3 helicopter, Japanese registration JA6522, sustained substantial damage as the result of an in-flight fire in the baggage compartment during cruise flight near Higashikagawa City,…NTSB ERA11WA499Accident · 3 fatalForeign investigationBeech 99 · Cap Haitien, HaitiOn September 20, 2011, at 2130 universal coordinated time, a Hawker Beechcraft BE-99A, registered in Haiti as HH-APA, was substantially damaged when it impacted terrain while on approach to the Cap Haitien International Airport (MTCH), Cap Haitien, Haiti. The…NTSB DCA11WA099Incident · No injuriesForeign investigationAirbus A320 · Cusco, PeruOn September 19, 2011, at 1620 UTC, an Airbus A320-233, N493TA, experienced smoke in the cockpit. The airplane landed uneventfully at Alejandro Velasco Astete International Airport (SPZO), Peru, its original destination. None of the passengers or crewmembers…NTSB ERA11WA515Accident · 1 fatalForeign investigationPiper PA-34-220T · Jatai Municipality, BrazilOn September 18, 2011, about 2330 universal coordinated time, a Piper PA-34-220T, Brazilian registration PT-GCC, was substantially damaged when it impacted terrain near Jatai Municipality, Goias, Brazil. The certificated pilot was fatally injured. The local…NTSB ERA11WA518Accident · No injuriesForeign investigationGates Lear Jet 35 · Valencia, Carabobo, VenezuelaOn September 17, 2011, about 2135 universal coordinated time, a Gates Lear Jet 35, N535LC, was substantially damaged while landing at the Arturo Michelena Airport (SVVA), Valencia, Carabobo, Venezuela. The two pilots and five passengers were not injured. The…NTSB DCA11RA100Accident · Serious injuriesForeign investigationEmbraer E190 · Quito, EcuadorOn September 16, 2011, an Ecuadoran Embraer EMB-190, registration HC-CEZ, overran runway 35 while landing at Quito, Ecuador. The airplane was substantially damaged and there were 5 serious injuries among the 97 passengers and 5 crew. The investigation is…NTSB CEN11WA690Accident · No injuriesForeign investigationPiper PA 28 · Montpellier, FranceOn September 16, 2011, a Piper PA 28, French resistered F-HMAT, was substantially damaged during a forced landing following a loss of engine power near Montpellier, France. Visual meteorological conditions prevailed at the time of the accident. No one was…NTSB ERA11WA498Accident · 3 fatalForeign investigationBeech G-58 · Parana, BrazilOn September 13, 2011, about 1135, Universal Coordinated Time (UTC), a Hawker Beechcraft G-58, Brazilian registration PR-KST, operated by a private owner, lost control during a climb while enroute to Fortaleza do Guapore` Farm, State of Mato Grosso (SSDP),…NTSB CEN11WA639Accident · 2 fatalForeign investigationPiper PA-31P · Ciudad Apodaca, MexicoNTSB ERA11WA509Accident · 2 fatalForeign investigationRobinson R44 · Rio de Janeriro, BrazilOn September 10, 2011, about 2330 universal coordinated time, a Robinson R44 II, Brazilian registration PR-CEC, was substantially damaged when it impacted wooded terrain during an aerial photography flight, near Rio de Janeiro, Brazil. The foreign…NTSB DCA11WA109Incident · No injuriesForeign investigationBoeing 737 · Phuket, ThailandOn September 10, 2011, at about 1842 local time, a Shanghai Airlines B737-800, registration #B-5088, ran off the side of runway 27 at Phuket International Airport (HKT), Phuket, Thailand, and was able to turn back onto the runway. The aircraft sustained minor…NTSB ANC11CA101Accident · Serious injuriesData collectionFinal reportDouglas DC-8-62F · Yakota, JapanThe passenger's decision to ignore the fasten seatbelt sign, resulting in serious injury to the passenger during a turbulence encounter.NTSB WPR11WA475Accident · 2 fatalForeign investigationCessna 208B · Wamean, West Papua, IndonesiaOn September 9, 2011, at 1223 local time (0323 UTC) a Cessna 208B, Indonesia registry PK-VVE, collided with mountainous terrain 8 nautical miles north east of Wamena Airport, Wamena, West Papau, Indonesia. The aircraft was operated by Susi Air under the…NTSB WPR11WA484Accident · No injuriesForeign investigationAerospatiale AS350 · Rockhampton, Australia, AustraliaOn September 8, 2011, at 0203 universal coordinated time, an Aerospatiale Industries AS-350BA, VH-RDU, collided with the terrain near Rockhampton, Australia. The helicopter was substantially damaged. Of the three occupants on board, two were fatally injured…NTSB DCA11WA105Incident · Minor injuriesForeign investigationBoeing 737 · Hamamatsu City, JapanOn September 6, 2011, at 22:50 local time (13:50 UTC), a Boeing 737-700, registration JA16AN, operated by Air Nippon Co., Ltd., entered an unusual attitude and lost altitude about 43km south of Hamamatsu City, Shizuoka Prefecture, Japan, as the aircraft was…NTSB DCA11RA098Accident · 8 fatalForeign investigationM7Aero SW3 · Trinidad, BoliviaOn September 6, 2011, an Aerocon Swearingen SA-227 Metroliner, registration CP-2548 performing flight A4-238 from Santa Cruz to Trinidad (Bolivia) with 7 passengers and 2 crew, was on approach to Trinidad when radio contact was lost. The airplane was located…NTSB CEN11WA628Accident · No injuriesForeign investigationEmbraer EMB-145LR · Ottawa, CanadaNTSB WPR11WA438Accident · 1 fatalForeign investigationRobinson R44 · Plutonic Aero., Australia, AustraliaOn September 3, 2011, at 0330 universal coordinated time, a Robinson R44, Australia registry VH-HCA, collided with terrain while maneuvering near Plutonic Aerodrome, Australia. The helicopter was operated by Wieland Helicopter Company under the pertinent…NTSB ERA11WA508Accident · 3 fatalForeign investigationRobinson R44 · Sao Sebastiao, BrazilOn August 30, 2011, about 1158 Universal Coordinated time (UTC), a Robinson R44 II, Brazilian registration PP-CLE, registered to Old Ducan S.A., and operated by Seisa Clerman EMP. Imobiliarios LTDA, crashed near Sao Sebastiao Municipality, State of Sao Paulo,…NTSB CEN11WA603Accident · 1 fatalForeign investigationCessna TU206G · Sioux Lookout, CanadaNTSB WPR11WA421Accident · 1 fatalForeign investigationHughes 369D · South Malekula, Vanuatu, VanuatuOn August 28, 2011, at 1500 universal coordinated time, a Hughes 369D, Vanuatu registration YJ-HEL, collided with the ground after the attached long-line became entangled in the rotor system near Malekula, Vanuatu. The helicopter was operated by Vanuatu…NTSB CEN11WA626Accident · 4 fatalForeign investigationCessna F150 · Zell am See, AustriaOn August 28, 2011, at 1343 coordinated universal time, a German registered Cessna 150, D-EEAW, and a German registered Diamond HK-36R, D-KILL, collided in-flight near Zell am See, Austria. The two persons on board the Cessna and the two persons on board the…NTSB CEN11WA622Accident · 1 fatalForeign investigationCessna F172 · Mugeln, GermanyOn August 28, 2011, a Reims Aviation, Cessna F172N, German registration D-EOEM, operated by Flaming Air GmbH, was substantially damaged when it crashed near Oehna Airfield (EDBO), Megeln, Germany, under unknown circumstances. The pilot, the sole person on…NTSB CEN11WA621Accident · Serious injuriesForeign investigationCessna 150 · Stockstadt am Main, GermanyNTSB CEN11WA619Accident · No injuriesForeign investigationCessna 206 · Kumla, SwedenOn August 28, 2011, at 1606 UTC, a Cessna U206E, Swedish registration SE-FMU, was substantially damaged when the airplane lost engine power during parachute jump operations and impacted terrain during a forced landing in a field near Kumla, Sweden. The pilot…NTSB CEN11WA617Accident · 4 fatalForeign investigationRobinson R44 · St. Ferdinand, CanadaOn August 27, 2011, at 2115 eastern daylight time, a Robinson R44 helicopter, C-GEBY, sustained substantial damage when it impacted terrain shortly after takeoff near St. Ferdinand, Quebec, Canada. The pilot and three passengers sustained fatal injuries. The…NTSB CEN11WA587Accident · 2 fatalForeign investigationGardan GY80-160 · Mauterndorf, AustriaUnder the jurisdiction and control of the Austrian Government.NTSB ERA11WA470Accident · 2 fatalForeign investigationPiper PA30 · Region del Bio Bio, ChileOn August 20, 2011, at 1650 universal coordinated time, a Piper PA-30, Chilean registration CC-CTT, was substantially damaged when it impacted terrain, after its right wing separated in-flight while maneuvering, over Region del Bio Bio, Chile. The pilot and…NTSB DCA11RA097Accident · No injuriesForeign investigationBoeing 737 · Resolute, CanadaOn August 20, 2011, about 1230 central daylight time (local), a Boeing 737-200, Canadian registration CGNWN, operated by First Air in a combination passenger/freight configuration as flight 6560 and equipped with Pratt & Whitney JT8D engines, impacted terrain…NTSB ERA11WA472Accident · 4 fatalForeign investigationAgusta AW139 · BrazilOn August 19, 2011, at 1948 coordinated universal time (16:48 local time), an Agusta, AW139, helicopter, Brazilian registration PT-SEK, impacted into the Atlantic Ocean, near an oil rig, identifier P-65, the helicopter sank in waters with a recorded floor…NTSB WPR11WA393Accident · 3 fatalForeign investigationAerospatiale AS355 · Marree, Australia, AustraliaOn August 18, 2011, at 1008 universal coordinated time, an Aerospatiale AS 355F2, VH-NTV, operated by Australian Broadcasting Corporation, collided with terrain shortly after takeoff near Marree, Australia. The helicopter was substantially damaged and…NTSB ENG11WA046Incident · No injuriesForeign investigationAirbus A320 · Stockholm-Skavsta Airport, SwedenOn August 18, 2011, at about 2056 UTC, an Airbus 320-233, HA-LPB, operated by Wizz Air Hungary Légiközlekedési Kft, experienced a No. 1 engine undercowl fire during shutdown following landing at Stockholm-Skavsta Airport, Nyköping, Sweden. Flames at the No. 1…NTSB ERA11WA464Accident · 2 fatalForeign investigationCessna 152 · Finca Arrayanes, ColombiaOn August 17, 2011, about 1930 Universal Coordinated Time (UTC), a Cessna 152, Columbian registration HK2597G, operated by Academia de Pilotos de Aviacion, was destroyed following a collision with terrain in Finca Arrayanes, Colombia. The flight instructor…NTSB WPR11WA385Accident · 2 fatalForeign investigationPiper PA-28-180 · Horsham, Victoria, AustraliaOn August 15, 2011, about 0850 UTC (1850 local time), a Piper PA-28-180, Australian registry VH-POJ, collided with terrain near the Horsham aerodrome, Horsham, Victoria, Australia. The airplane was operated by a private owner under the auspices of the…NTSB ENG11WA045Incident · No injuriesForeign investigationBombardier CRJ701 · Lyon, France, FranceOn August 15, 2011, a BritAir Bombardier (Canadair)CRJ701 Regional Jet, powered by two General Electric CF34-8C5B1 turbofan engines, experienced an No. 1 (left) engine failure during takeoff from the Lyon Saint Exupery Airport (LYS), Lyon France. The flight…NTSB DCA11WA094Accident · 10 fatalForeign investigationBell 412 · Bitung, IndonesiaOn August 3, 2011, at about 1429 local time (0629 UTC), a Bell 412 helicopter, registration PK-FUG, operated by Nyaman Air, crashed in the jungle on the side of Dua Saudara Mountain in the North Sulawesi province of Indonesia, approximately 25 km from the…NTSB DCA11WA093Incident · No injuriesForeign investigationBoeing 757 · Leipzig-Halle, GermanyOn July 31, 2011, at about 1610 UTC, a European Air Transport Leipzig GmbH B757-200, registration D-ALEA, reported an unusual smell in the cockpit after departure from Leipzig-Halle, Germany. There was no damage to the aircraft, and there were no injuries.…NTSB DCA11RA092Accident · Serious injuriesForeign investigationBoeing 737 · Georgetown, GuyanaOn July 30, 2011, at 1:25 am local time (0525 UTC), a Boeing 737-800, Trinidad & Tobago registration 9Y-PBM, operated by Caribbean Airlines as flight 523, overran the runway upon landing at Cheddi Jagan International Airport, Georgetown, Guyana. Of the 156…NTSB CEN11WA592Accident · 1 fatalForeign investigationSocata TB10 · Kufstein, AustriaUnder the jurisdiction and control of the Austrian government.NTSB DCA11WA090Incident · No injuriesForeign investigationBoeing 777 · Cairo, EgyptOn July 29, 2011, a Boeing B777-200, registration SU-GBP, operated by EgyptAir, experienced a fire in the right hand lower portion of the cockpit area, adjacent to the electronic flight bag and an electrical power panel. The aircraft was in the process of…NTSB DCA11FA091Accident · Serious injuriesField investigationFinal reportBoeing 747-422 · Tangshan, Chinaan inadvertent encounter with convectively induced turbulence likely due to radar limitations and convective weather developing upwards into the flight path.