NTSB investigations, Outside the U.S.

504 cases where the defining event was Loss of control in flight.

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 c.\"eventCountry\" <> 'USA'
    AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240')
  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 DCA15WA054Accident · 3 fatalForeign investigationHal Dhruv · Tena, EcuadorThe Civil Aviation Authority of Ecuador has notified the NTSB of an accident involving an Ecuadorian Air Force Hal Dhruv helicopter, which occurred on January 27, 2015. The NTSB has appointed a U.S Accredited Representative to assist. All investigative…Jan 27, 2015 · FAE-605 · DestroyedNTSB DCA15WA053Accident · Minor injuriesForeign investigationHal Dhruv · Guayaquil, EcuadorThe Civil Aviation Authority of Ecuador has notified the NTSB of an accident involving a HAL Dhruvhelicopter, which occurred on January 13, 2015. The NTSB has appointed a U.S Accredited Representative to assist.All investigative information will be released…Jan 13, 2015 · FAE-603 · Substantial damageNTSB CEN15WA113Incident · No injuriesForeign investigationSaab-Scania Saab 2000 · Sumburgh, United KingdomOn December 15, 2014, about 1955 coordinated universal time, a SAAB-Scania SAAB 2000 airplane, G-LGNO, lost elevator control following a lightning strike on approach to Sumburgh Airport, Sumburgh, United Kingdom. The damage to the airplane is unknown. The…Dec 15, 2014 · G-LGNONTSB DCA15WA031Accident · No injuriesForeign investigationBeech F33 - A · Krugersdorp, South AfricaDec 8, 2014 · ZS-KHE · DestroyedNTSB DCA15WA030Accident · 4 fatalForeign investigationRobinson R44 - II · Dar es Salaam, TanzaniaNov 29, 2014 · 5H-TWA · DestroyedNTSB ERA15WA061Accident · 1 fatalForeign investigationPiper PA-25-235 · Cidade Gaúcha, State of Paraná, BrazilOn November 17, 2014, about 1758 universal coordinated time, a Piper PA-25-235, Brazilian registration PR-WIZ, was destroyed when it impacted the ground in a sugar cane field in Cidade Gaúcha, Paraná, Brazil. The pilot was fatally injured. The flight was…Nov 17, 2014 · PR-WIZ · DestroyedNTSB ERA15WA026Accident · 1 fatalForeign investigationCessna 310R · Governors Harbor, BahamasOct 24, 2014 · N310WL · Substantial damageNTSB CEN14WA420Accident · 1 fatalForeign investigationQuicksilver MXL Sport II · Cuenca, SpainOn August 8, 2014, about 1920 coordinated universal time, a Quicksilver MXL Sport II, motorized ultralight (ULM) aircraft, registry EC-FL8, was substantially damaged after impacting terrain during takeoff. The pilot was fatally injured. At the time of the…Aug 8, 2014 · EC-FL8 · Substantial damageNTSB WPR14LA309Accident · 2 fatalLimited investigationFinal reportBeech A36 · Pago Pago, AntarcticaA loss of airplane control during the initial climb in gusting wind conditions for reasons that could not be determined because the wreckage was not recovered from the ocean.Jul 22, 2014 · N20TC · DestroyedNTSB WPR14WA304Accident · 1 fatalForeign investigationCessna 182 - L · Albury Aerodrome, AustraliaOn July 20, 2014 about 1600 local time, a Cessna 182L airplane, Australian registration VH-TRS, collided with terrain near Albury Aerodrome, New South Wales, Australia. The airplane sustained substantial damage and the pilot was fatally injured. The airplane…Jul 20, 2014 · VH-TRS · Substantial damageNTSB CEN14RA340Accident · 11 fatalForeign investigationPiper PA 31P · Czestochowska, PolandJul 5, 2014 · N11WB · DestroyedNTSB CEN14WA292Accident · 1 fatalForeign investigationSchweizer 269C · Cerfontaine, Belgium, BelgiumOn June 13, 2014, about 1500 UTC, a Schweizer 269C, OO-JCS (s/n S1749) impacted terrain at the airfield of Cerfontaine, Belgium (EBCF). The helicopter was destroyed. One pilot was fatally injured and one pilot was seriously injured. This investigation is…Jun 13, 2014 · OO-JCS · DestroyedNTSB ERA14WA275Accident · 5 fatalForeign investigationBeech B200 · Colonia, UruguayOn May 27, 2014, about 1050 coordinated universal time (UTC), a Beechcraft B200, Argentina registration LV-CNT, was substantially damaged when it impacted the water near Rio de la Plata, Uruguay. The Argentinian pilot and four of the passengers were fatally…May 27, 2014 · LV-CNT · Substantial damageNTSB ERA14WA264Accident · 2 fatalClass 5 · ForeignBeech 58P · Trinidad, BoliviaMay 23, 2014 · CP-2544 · DestroyedNTSB ERA14WA247Accident · 2 fatalForeign investigationCessna 140A · Cachoeira do Sul, BrazilOn May 10, 2014, at 2025 coordinated universal time, a Cessna 140A, Brazilian registration PT-AGS, experienced a loss of control and subsequently impacted terrain near Cachoeira do Su, Brazil. The two pilots onboard were fatally injured. The instructional…May 10, 2014 · PT-AGS · Substantial damageNTSB CEN14WA214Accident · 4 fatalForeign investigationCessna 172 - M · Gracias, HondurasOn April 23, 2014, at 1900 universal coordinated time, a Cessna 172M airplane, bearing Honduran registration HR-AVH, was destroyed upon impact with trees and terrain under unknown circumstances, near Gracias, Department of Lempira, in the Republic of…Apr 23, 2014 · HR-AVN · DestroyedNTSB CEN14WA206Accident · 7 fatalForeign investigationSui RY, Laurinen Janne, KääRiä Comp AIR 8 · Jamijarvi, FinlandOn April 20, 2014, at 1240 UTC, a Comp Air 8, Finnish registration OH-XDZ, was destroyed when it departed controlled flight and subsequently impacted in a forest near Jamijarvi Airfield (EFJM), Jamijarvi, Finland. A post-impact fire ensued. Eight of the 10…Apr 20, 2014 · OH-XDZ · DestroyedNTSB WPR14WA164Accident · 2 fatalForeign investigationQuest Kodiak · Jayapura, Papua, Indonesia, IndonesiaOn April 9, 2014, at 0025 universal coordinated time, a Quest Aircraft Company, Kodiak-100, PK-SDF, during takeoff from Doyo Baru Airstrip, Jayapura, Papua, Indonesia, the airplane lost altitude and struck the airport fence and subsequently came to rest on a…Apr 9, 2014 · PK-SDF · Substantial damageNTSB ERA14WA186Accident · 1 fatalForeign investigationBoeing B75 · Lujan, ArgentinaOn March 29, 2014, about 1900 coordinated universal time, a Boeing B75 Stearman, Argentine registration LV-HAF, was substantially damaged when it impacted the ground during the initial climb after takeoff from the Lujan Airport, Lujan, Argentina. The pilot…Mar 29, 2014 · LV-HAF · Substantial damageNTSB ERA14WA196Accident · 2 fatalForeign investigationRobinson R22 - Beta · Ribeirão Preto, BrazilOn March 23, 2014, about 1355 universal coordinated time, a Robinson R22 Beta, Brazilian registration PP-SSP, was substantially damaged when it impacted the ground on a corn plantation in Ribeirao Preto, Brazil. The pilot and a passenger were fatally injured.…Mar 23, 2014 · PP-SSP · Substantial damageNTSB WPR14WA154Accident · 5 fatalForeign investigationCessna U206 - G · Caboolture, AustraliaOn March 22, 2014 about 1123 local time, a Cessna 206 airplane, Australian registration VH-FRT, crashed shortly after takeoff near Caboolture, Australia. The airplane was substantially damaged and the pilot and four passengers were fatally injured. The…Mar 22, 2014 · VH-FRT · DestroyedNTSB ERA14WA132Accident · 2 fatalForeign investigationRobinson R22 - Beta · Rio de Janeiro, BrazilOn February 18, 2014, about 1315 universal coordinated time, a Robinson R22 - BETA, Brazilian registration PT-YFV, was destroyed when it impacted water, near Rio de Janeiro, Brazil. The flight instructor and student pilot were fatally injured. The local…Feb 18, 2014 · PT-YFV · DestroyedNTSB ERA14WA131Accident · 2 fatalForeign investigationRobinson R44 · Braganca, BrazilOn February 15, 2014, about 2200 coordinated universal time (UTC), a Robinson, R 44 helicopter, Brazilian registration PT-YMF, was destroyed when it impacted the ground in a dense forest in the Bragança Municipality, in the State of Pará, Brazil. The…Feb 15, 2014 · PT-YMF · Substantial damageNTSB DCA14WA179Accident · 3 fatalForeign investigationBeech C90 · Lanseria, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Beech C90-GTI airplane that occurred on February 03, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA investigation under the…Feb 3, 2014 · ZS-CLT · DestroyedNTSB ERA14WA079Accident · 4 fatalForeign investigationCessna 172A · Teresina Municipality, BrazilOn December 26, 2013, about 2148 universal coordinated time (UTC), a Cessna 172, Brazilian registration PT-CNL, was destroyed while conducting touch and go landings in the Teresina Municipality, State of Piauí, Brazil. The pilot, copilot, and 2 passengers…Dec 16, 2013 · PT-CNL · DestroyedNTSB CEN14WA062Accident · 6 fatalForeign investigationSocata TBM 700 · Mouffy, FranceNov 19, 2013 · N115KC · DestroyedNTSB ERA14WA036Accident · 2 fatalForeign investigationPiper PA-34-200 · Marica, BrazilOn October 21, 2013, about 1840 universal coordinated time (UTC), a Piper PA-34-200, Brazilian registration PT-KGK, while on a local training flight, impacted in a lagoon, after a loss of control, in Marica Municipality – State of Rio de Janeiro, Brazil. The…Oct 21, 2013 · PT-KGK · DestroyedNTSB ANC14WA003Accident · 3 fatalForeign investigationKawasaki BK117-B2 · Tatacka, TaiwanOn October 16, 2013, about 1209 Coordinated Universal Time, a Kawasaki BK-117 helicopter, Taiwan Island registration number B-77009, operated by Sunrise Airlines, was destroyed following a loss of control while landing near Yushan N. Peak Weather Staion,…Oct 16, 2013 · Foreign · DestroyedNTSB DCA14WA177Accident · No injuriesForeign investigationEmbraer EMB120 · Lagos, NigeriaThe Nigeria Accident Investigation Bureau (NAIB) has notified the NTSB of an accident involving an Embraer120 airplane that occurred on October 03, 2013. The NTSB has appointed a U.S. Accredited Representative to assist NAIB's investigation under the…Oct 3, 2013 · 5N-BJY · DestroyedNTSB CEN13WA566Accident · 4 fatalForeign investigationCessna 421 - C · Colombier-Saugnieu, FranceSep 24, 2013 · N556MB · DestroyedNTSB ERA13WA430Accident · 3 fatalForeign investigationCessna R172K · Morona Santiago, EcuadorSep 21, 2013 · HC-BGT · DestroyedNTSB ANC13WA103Accident · Serious injuriesForeign investigationBeech A36 - TC · Ami, JapanOn August 18, 2013, about 0520 coordinated universal time (UTC), a Japaneese registered Beechcraft A36 airplane, JA4152, lost control during a go-around near Ami, Japan. The pilot and one passenger were seriously injured, and two passengers sustained minor…Aug 18, 2013 · JA4152 · Substantial damageNTSB CEN13WA480Accident · 3 fatalForeign investigationSocata TBM-700 · Vertaizon, FranceAug 8, 2013 · N850GC · Substantial damageNTSB ERA13WA387Accident · 1 fatalForeign investigationEmbraer 711ST · Paragominas, BrazilOn August 4, 2013, about 2230 universal coordinated time, an Embraer EMB-711ST (Piper PA-28RT-201T), Brazilian registration PT-RHI, operated by a private individual, was substantially damaged when it impacted terrain while on approach to the Aeroporto de…Aug 4, 2013 · PT-RHI · Substantial damageNTSB ERA13WA376Accident · 4 fatalForeign investigationBeech 58 · Jundiai Municipality, BrazilOn August 3, 2013, at 1524 Universal Coordinated Time (UTC), a Beech model 58, Brazilian registration PT-LKG, operated by a private owner, was destroyed following a collision with terrain on approach to Jundiai Airport (SBJD), State of Sao Paulo, Brazil. The…Aug 3, 2013 · PT-LKG · DestroyedNTSB CEN13WA578Accident · 2 fatalClass 5 · ForeignCirrus Design SR20 · Poncins, FranceOn July 31, 2013, about 1420 universal coordinated time, a Cirrus SR-20 airplane, F-HCPT, impacted terrain near Poncins, France. The two occupants were fatally injured. This investigation is under the jurisdiction of the government of France. Any further…Jul 31, 2013 · F-HCPT · DestroyedNTSB ERA13WA356Accident · 2 fatalForeign investigationBeech G36 · Bonito, BrazilOn July 19, 2013, about 1330 universal coordinated time (UTC), a Hawker Beechcraft G16, Brazilian registration PR-KEX, registered to a private owner and operated by a private individual, impacted terrain during flight in the vicinity of the Bonito…Jul 19, 2013 · PR- KEX · DestroyedNTSB DCA13WA129Accident · No injuriesForeign investigationCirrus SR20 · Randburg, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cirrus SR20 airplane that occurred on July 18, 2013. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…Jul 18, 2013 · ZS-CAP · DestroyedNTSB ERA13WA332Accident · 2 fatalForeign investigationCessna 172N · Buenos Aires, ArgentinaOn July 16, 2013, about 2007 coordinated universal time, a Cessna 172N, Argentine registration LV-BPP, was substantially damaged when it impacted terrain while on approach to land at the Quilmes Airport (SADQ), Buenos Aires, Argentina. The flight instructor…Jul 16, 2013 · LV-BPP · Substantial damageNTSB ERA13WA287Accident · 4 fatalForeign investigationPiper PA22 · Taisha, EcuadorOn June 13, 2013, at 2028 coordinated universal time (1528 local time), a Piper PA-22-135, Ecuadorian registration HC-CMX, was destroyed when it impacted terrain shortly after taking off from Taisha Airport (SETH), Taisha, Morona-Santiago, Ecuador, en route…Jun 13, 2013 · HC-CMX · Substantial damageNTSB CEN13WA404Accident · Minor injuriesForeign investigationCirrus Design SR22 GTS G3 · Gloucestershire, United KingdomJun 6, 2013 · N936CT · Substantial damageNTSB DCA13MA081Accident · 7 fatalClass 1 · MajorFinal reportBoeing 747-400 BCF · Bagram, AfghanistanNational Airlines' inadequate procedures for restraining special cargo loads, which resulted in the loadmaster's improper restraint of the cargo, which moved aft and damaged hydraulic systems Nos. 1 and 2 and horizontal stabilizer drive mechanism components,…Apr 29, 2013 · N949CA · DestroyedNTSB WPR13WA435Incident · No injuriesForeign investigationRobinson R22 - Beta · New Plymouth, New Zealand, New ZealandOn March 30, 2013, at 1300 local time, a Robinson R22 Beta II, ZK-HIE, while maneuvering during an instructional flight near New Plymouth, New Zealand, experienced a sudden roll to the right and pitched down. The certified flight instructor and student pilot…Mar 30, 2013 · ZK-HIE · Minor damageNTSB ERA13WA162Accident · 3 fatalForeign investigationBeech 35 · Los Amores, Santa Fe, ArgentinaOn March 9, 2013, about 2030 coordinated universal time (UTC), a Beech 35, Paraguayan registration ZP-BAM, was destroyed when it impacted terrain in Los Amores, Santa Fe Province, Argentina. The pilot and two passengers were fatally injured. The flight…Mar 9, 2013 · ZP-BAM · DestroyedNTSB ERA13WA176Accident · 1 fatalClass 5 · ForeignCirrus Design SR-22 · Tiros, BrazilOn February 27, 2013, about 1840 coordinated universal time (UTC), a Cirrus Design Corporation, SR-22, Brazilian registration PR-SLS, was destroyed when it impacted the ground shortly after takeoff from a farm field in the Tiros Municipality, in the State of…Feb 27, 2013 · PR-SLS · DestroyedNTSB ERA13WA165Accident · 1 fatalForeign investigationPiper PA-36-300 · Quevedo, EcuadorOn February 14, 2013, about 1310 coordinated universal time (UTC), a Piper PA-36-300, Ecuadorian registration HC-BJM, operated by CIA FAP S.A., was substantially damaged when it impacted the ground during an aerial application flight. The Ecuadorian pilot was…Feb 14, 2013 · HC-BJM · Substantial damageNTSB ERA13WA135Accident · 4 fatalForeign investigationCessna 172 · La Matanza, ArgentinaOn February 8, 2013, at 2250 Coordinated Universal Time (UTC), a Cessna 172, Argentine registration LV-GEU, impacted terrain while maneuvering at an altitude of approximately 500 feet in the vicinity of Matanza Airport (SADZ), La Matanza, Argentina. The local…Feb 8, 2013 · LV-GEU · Substantial damageNTSB ERA13RA125Accident · 3 fatalForeign investigationRobinson R44 · Asuncion, ParaguayOn February 2, 2013, about 2115 local time (February 3, 2013, 0015 coordinated universal time), a Robinson R44, Paraguayan registration ZP-HAH, operated by Helitactica S.A., was destroyed when it impacted sparsely populated terrain about 27 nautical miles…Feb 2, 2013 · ZP-HAH · DestroyedNTSB CEN13WA126Accident · 5 fatalForeign investigationPiper PA34 · Saint Pierre de Bressieux, FranceOn January 5, 2013, at 1235 coordinated universal time, a Piper PA-34-200T airplane, Morocco registration, CN-DAY, crashed in mountainous terrain near Saint Pierre de Bressieux, France. The pilot and four passengers were fatally injured. The accident…Jan 5, 2013 · CN-DAY · Substantial damageNTSB ERA13WA103Accident · 2 fatalForeign investigationPiper PA28 · Minas City, BrazilOn December 26, 2012, at 2050 universal coordinated time, a Piper PA-28-181, Brazilian registration PR-NAX, was destroyed when it impacted the ground after the crew lost control during a go around. The instructor pilot and student were fatally injured. The…Dec 26, 2012 · PR-NAX · Destroyed