# NTSB investigations, Outside the U.S.: Collision with terr/obj (non-CFIT)

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 6 of 7 · 331 cases

## Cases, newest first

- [NTSB ERA13WA103](https://openairdocs.org/ntsb/ERA13WA103.md): Piper PA28 · Minas City, Brazil · Accident · 2 fatal · Foreign investigation · Dec 26, 2012 · PR-NAX · Destroyed
  > On 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…
- [NTSB ERA13WA066](https://openairdocs.org/ntsb/ERA13WA066.md): Aerospatiale AS-355F1 · Great Guana Cay, Bahamas · Accident · 1 fatal · Foreign investigation · Nov 22, 2012 · C6-APV · Substantial damage
  > On November 22, 2012, about 1310 eastern standard time, an Aerospatiale AS 355F1, Bahamian registration C6-APV, registered to Pioneer Caribbean Logistics Ltd., impacted terrain while attempting to land at Baker's Bay Resort, Great Guana Cay, Bahamas. The…
- [NTSB ERA13WA063](https://openairdocs.org/ntsb/ERA13WA063.md): Cessna 525B · Sao Paulo, Brazil · Accident · Serious injuries · Foreign investigation · Nov 11, 2012 · PR-MRG · Substantial damage
  > On November 11, 2012, at 1921 universal coordinated time, a Cessna Citation 525B, Brazilian registration PR-MRG, sustained substantial damage when it overran the runway during landing. One of the 2 crewmembers received serious injuries and the other received…
- [NTSB CEN13WA061](https://openairdocs.org/ntsb/CEN13WA061.md): Reims-Cessna F150 · Birr, Ireland, Ireland · Accident · 2 fatal · Foreign investigation · Nov 11, 2012 · EI-AST · Destroyed
  > On November 11, 2012, about 1655 Western European time, a Reims-Cessna, model F150H, single engine airplane, EI-AST, was destroyed when it impacted terrain near Birr Airfield (EIBR), Birr, Ireland. The two pilots were fatally injured. The airplane was…
- [NTSB ERA13WA050](https://openairdocs.org/ntsb/ERA13WA050.md): Cessna 206 · Kiim, Ecuador · Accident · Serious injuries · Foreign investigation · Oct 31, 2012 · HC-CBG · Substantial damage
  > On October 31, 2012, about 1545 coordinated universal time (1045 local time), a Cessna 206, Ecuadorian registration HC-CBG, was substantially damaged during a forced landing in Kiim, Ecuador. The Ecuadorian commercial pilot was seriously injured. The airplane…
- [NTSB CEN13WA020](https://openairdocs.org/ntsb/CEN13WA020.md): Mooney M20E · Speichersdorf, Germany · Accident · 2 fatal · Foreign investigation · Oct 21, 2012 · D-EMHE · Destroyed
  > On October 21, 2012, about 1520 coordinated universal time, a Mooney M20E, D-EMHE was destroyed following a loss of control during initial climb from Rosenthal Field Ploessen Airport (EDQP), near Speichersdorf, Germany. The pilot and passenger were fatally…
- [NTSB ERA13WA030](https://openairdocs.org/ntsb/ERA13WA030.md): Piper PA25 · Juquiá Municipality, Brazil · Accident · 1 fatal · Foreign investigation · Oct 3, 2012 · PT-DOX · Destroyed
  > On 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 ERA13WA085](https://openairdocs.org/ntsb/ERA13WA085.md): Thrush S2R-T34 · Naranjal, Ecuador · Accident · No injuries · Foreign investigation · Oct 2, 2012 · HC-CFU · Substantial damage
  > On 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 ERA12WA590](https://openairdocs.org/ntsb/ERA12WA590.md): Piper PA34 · Ilheus, Brazil · Accident · 1 fatal · Foreign investigation · Sep 25, 2012 · PT-RDG · Substantial damage
  > On 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 ERA12WA591](https://openairdocs.org/ntsb/ERA12WA591.md): Cessna 210 · Roraima, Brazil · Accident · 1 fatal · Foreign investigation · Sep 24, 2012 · PT-KSB · Substantial damage
  > On 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 ERA13WA205](https://openairdocs.org/ntsb/ERA13WA205.md): Cessna 172N · Acreúna Municipality, Brazil · Accident · 4 fatal · Foreign investigation · Sep 9, 2012 · N1009F · Destroyed
- [NTSB ERA12WA534](https://openairdocs.org/ntsb/ERA12WA534.md): Gulfstream G-164B · Calabozo, Venezuela · Accident · 1 fatal · Foreign investigation · Aug 24, 2012 · YV264A · Substantial damage
  > On 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 ERA12WA530](https://openairdocs.org/ntsb/ERA12WA530.md): Embraer EMB711 · Sta Barbara D'Oeste, Brazil · Accident · 4 fatal · Foreign investigation · Aug 18, 2012 · PT-NKA · 2 aircraft · Substantial damage
  > On 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 CEN12WA681](https://openairdocs.org/ntsb/CEN12WA681.md): Mcdonnell Douglas 500 · Kastire, Latvia · Accident · No injuries · Foreign investigation · Jul 12, 2012 · OH-HJR · Substantial damage
  > On 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 ERA12WA446](https://openairdocs.org/ntsb/ERA12WA446.md): Robinson R22 · Sao Paulo, Brazil · Accident · 2 fatal · Foreign investigation · Jul 11, 2012 · PT-HOL · Destroyed
  > On 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 ERA12WA451](https://openairdocs.org/ntsb/ERA12WA451.md): Embraer EMB820 · Espinosa Municipality, Brazil · Accident · 1 fatal · Foreign investigation · Jul 6, 2012 · PT-ENG · Destroyed
  > On 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 ERA12WA383](https://openairdocs.org/ntsb/ERA12WA383.md): Piper PA-28R-200 · São Paulo, Brazil · Accident · 1 fatal · Foreign investigation · Jun 2, 2012 · PT-KRF · Destroyed
- [NTSB ERA12WA504](https://openairdocs.org/ntsb/ERA12WA504.md): Piper PA-28-235 · Tartu, Estonia · Accident · Minor injuries · Foreign investigation · May 4, 2012 · YL-MED · Destroyed
  > On May 4, 2012, about 2055 universal coordinated time, a Piper PA-28-235, Latvian registration YL-MED, was substantially damaged when it impacted a ditch, during a forced landing at night after a loss of power near Tartu Ulenurme Airport (EETU), Tartu,…
- [NTSB WPR12WA197](https://openairdocs.org/ntsb/WPR12WA197.md): Cessna 150 · Bourke, Australia, Australia · Accident · 1 fatal · Foreign investigation · Apr 29, 2012 · VH-UWR · Substantial damage
  > On April 29, 2012, at 0800 universal coordinated time, a Cessna 150M, VH-UWR, collided with the terrain during a mustering operation near Bourke, Australia. The airplane was operated by a private individual under the pertinent civil regulations of Australia.…
- [NTSB ERA12WA353](https://openairdocs.org/ntsb/ERA12WA353.md): Embraer EMB712 · Morro do Manduba Guaruja, Brazil · Accident · 2 fatal · Foreign investigation · Apr 26, 2012 · PT-NUH · Substantial damage
  > On April 26, 2012, about 1845 Universal Coordinated Time (UTC), an Embraer 712, Brazilian registration PT-NUH, operated by the Aeroclube de Itanhaem, crashed under unknown circumstances in a dense forest area in Morro do Manduba Guaruja Municipality, Sao…
- [NTSB ERA12WA249](https://openairdocs.org/ntsb/ERA12WA249.md): Beech 300 · Puerto Aguiree, Chile · Accident · 8 fatal · Foreign investigation · Mar 22, 2012 · CC-AEB · Destroyed
  > On March 22, 2012, at 0358 UTC, a Beech BE 300, Chilean registration CC-AEB registered to Banco Popular Espanol, S.A. and operated by Inaer Helicopter Chile SA as an air ambulance flight, departed controlled flight at Flight level 280 while in radio contact…
- [NTSB ERA12WA240](https://openairdocs.org/ntsb/ERA12WA240.md): Cessna 182 · Barrancabermeja, Colombia · Accident · 3 fatal · Foreign investigation · Mar 17, 2012 · HK1441G · Substantial damage
  > On March 17, 2012, about 2145 universal coordinated time (1645 local time), a Cessna 182M, Colombian registration HK1441G, was substantially damaged when it impacted transmission lines, then terrain, about 3 nautical miles south of Aeropuerto Yariguies…
- [NTSB ERA12WA239](https://openairdocs.org/ntsb/ERA12WA239.md): Piper PA28R · Eliseu Martins, Brazil · Accident · 3 fatal · Foreign investigation · Mar 6, 2012 · PT-NKS · Destroyed
  > On March 6, 2012, about 1400 universal coordinated time, a Piper PA-28R-200, Brazilian registration PT-NKS, was destroyed when it impacted terrain, following a loss of control during cruise flight near Eliseu Martins, Brazil. The foreign certificated pilot…
- [NTSB ERA12WA238](https://openairdocs.org/ntsb/ERA12WA238.md): Beech 95B55 · Cameta, Brazil · Accident · 4 fatal · Foreign investigation · Feb 16, 2012 · PT-LOU · Destroyed
  > On February 16, 2012, about 1230 universal coordinated time, a Beech 95-B55, Brazilian registration PT-LOU, was destroyed when it impacted trees and terrain shortly after takeoff in Cameta Municipality, State of Mato Para, Brazil. The foreign certificated…
- [NTSB CEN12WA138](https://openairdocs.org/ntsb/CEN12WA138.md): Piper PA-31-235 · Powys, Wales, United Kingdom, United Kingdom · Accident · No injuries · Foreign investigation · Jan 18, 2012 · G-BWHF · Substantial damage
  > On January 18, 2012, about 1145 universal time (UTC), a United Kingdom registered Piper PA-31-235, G-BWHF, sustained substantial damage when it impacted terrain near Leighton Welshpool, Powys, Wales, United Kingdom. The pilot and the passenger were fatally…
- [NTSB DCA12FA024](https://openairdocs.org/ntsb/DCA12FA024.md): Bell 214 · Camp Bastion, Afghanistan · Accident · 3 fatal · Field investigation · Final report · Jan 16, 2012 · N5748M · Destroyed
  > the overtravel of the collective sleeve, which led to a severe and sudden reduction in main rotor blade collective pitch, resulting in a loss of control of the helicopter. The reason for the collective sleeve overtravel could not be determined since much of…
- [NTSB ERA12WA159](https://openairdocs.org/ntsb/ERA12WA159.md): Beech A36 · Mato Grosso, Brazil · Accident · 3 fatal · Foreign investigation · Jan 14, 2012 · PR-RGF · Destroyed
  > On January 14, 2012, about 1000 universal coordinated time, a Beech A36, Brazilian registration PR-RGF, was destroyed when it impacted terrain, following a loss of control during cruise flight into deteriorating weather near Mato Grosso, Brazil. The…
- [NTSB ERA12WA105](https://openairdocs.org/ntsb/ERA12WA105.md): Cirrus SR20 · Minas Gerias, Brazil · Accident · 2 fatal · Foreign investigation · Nov 26, 2011 · PR-LJL · Substantial damage
  > On 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…
- [NTSB ERA12WA136](https://openairdocs.org/ntsb/ERA12WA136.md): Piper PA36 · Machala, Ecuador · Accident · No injuries · Foreign investigation · Nov 23, 2011 · HCBHJ · Substantial damage
  > On 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…
- [NTSB ERA12WA099](https://openairdocs.org/ntsb/ERA12WA099.md): Cessna 210 · Cuiaba, Brazil · Accident · 4 fatal · Foreign investigation · Nov 12, 2011 · PT-VMG · Substantial damage
  > On 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…
- [NTSB ERA12WA092](https://openairdocs.org/ntsb/ERA12WA092.md): Piper PA-25 · Meteropolitana, Chile · Accident · No injuries · Foreign investigation · Nov 11, 2011 · CC-ABM · Substantial damage
  > On 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…
- [NTSB ERA12WA041](https://openairdocs.org/ntsb/ERA12WA041.md): Bell 412 · Santa Rosa, Venezuela · Accident · Serious injuries · Foreign investigation · Oct 15, 2011 · YVO126 · Substantial damage
  > On 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…
- [NTSB CEN12WA033](https://openairdocs.org/ntsb/CEN12WA033.md): Diamond DA20 · Amurrio, Spain · Accident · 2 fatal · Foreign investigation · Oct 14, 2011 · EC-KDS · Substantial damage
  > On 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…
- [NTSB CEN11WA639](https://openairdocs.org/ntsb/CEN11WA639.md): Piper PA-31P · Ciudad Apodaca, Mexico · Accident · 2 fatal · Foreign investigation · Sep 12, 2011 · N69DJ · Destroyed
- [NTSB WPR11WA421](https://openairdocs.org/ntsb/WPR11WA421.md): Hughes 369D · South Malekula, Vanuatu, Vanuatu · Accident · 1 fatal · Foreign investigation · Aug 28, 2011 · YJ-HEL · Substantial damage
  > On 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 CEN11WA617](https://openairdocs.org/ntsb/CEN11WA617.md): Robinson R44 · St. Ferdinand, Canada · Accident · 4 fatal · Foreign investigation · Aug 28, 2011 · C-GEBY · Substantial damage
  > On 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 ERA11WA470](https://openairdocs.org/ntsb/ERA11WA470.md): Piper PA30 · Region del Bio Bio, Chile · Accident · 2 fatal · Foreign investigation · Aug 20, 2011 · CC-CTT · Substantial damage
  > On 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 ERA11WA472](https://openairdocs.org/ntsb/ERA11WA472.md): Agusta AW139 · Brazil · Accident · 4 fatal · Foreign investigation · Aug 19, 2011 · PR-SEK · Substantial damage
  > On 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 ERA11WA268](https://openairdocs.org/ntsb/ERA11WA268.md): Grumman G164 · Volgodonsk, Russia · Accident · Minor injuries · Foreign investigation · Apr 20, 2011 · RA-1398G · Substantial damage
  > On April 20, 2011, about 1010 Universal Coordinated Time (UTC), a Grumman G-164A Agcat, Russian registration RA-1398G, operated by a private individual, was substantially damaged during a forced landing following a loss of engine power near Volgodonsk, Rostov…
- [NTSB ERA11WA189](https://openairdocs.org/ntsb/ERA11WA189.md): Cessna 182 · Calamar, Colombia · Accident · 1 fatal · Foreign investigation · Mar 14, 2011 · HK1084 · Substantial damage
  > On March 14, 2011, about 0815 universal coordinated time, a Cessna, 182N, Colombian registration, HK1084, operated by Transportes Aereos del Ariari, crashed while returning to Aerodromo Jorge E. Gonzalez- San Jose Guaviare (SKSJ), Calamar, Colombia, shortly…
- [NTSB ERA11WA362](https://openairdocs.org/ntsb/ERA11WA362.md): Cessna 152 · Kingston, Jamaica · Accident · Minor injuries · Foreign investigation · Mar 4, 2011 · 6Y-JGA · Substantial damage
  > On March 4, 2011, about 1000 eastern standard time, a Cessna 152, Jamaican registration 6Y-JGA, was substantially damaged during a forced landing, following a total loss of engine power during initial climb from Norman Manley International Airport (MKJP),…
- [NTSB WPR11WA129](https://openairdocs.org/ntsb/WPR11WA129.md): Cessna 310R · Bathurst Island, Australia, Australia · Accident · 1 fatal · Foreign investigation · Feb 5, 2011 · VH-XGX · Substantial damage
  > On February 5, 2011, at 1255 universal coordinated time, a Cessna 310R, VH-XGX, operated by a private individual, collided with terrain near Bathurst Island, Australia. The airplane was substantially damaged and the pilot, the sole occupant, was killed. The…
- [NTSB WPR11WA127](https://openairdocs.org/ntsb/WPR11WA127.md): Robinson R44 · Cessnock, Australia, Australia · Accident · 2 fatal · Foreign investigation · Feb 4, 2011 · VH-HFH · Substantial damage
  > On February 4, 2011, at 0047 universal coordinated time, a Robinson R-44, VH-HFH, operated by Aero Logistics Pty, collided with terrain during an instructional flight near Cessnock, Australia. The helicopter was substantially damaged and the pilot and a…
- [NTSB ERA11WA119](https://openairdocs.org/ntsb/ERA11WA119.md): Avions Robin DR400 · Guidonia Montecelio, Italy · Accident · 1 fatal · Foreign investigation · Jan 11, 2011 · I-ITAV · Destroyed
  > On January 11, 2011, about 1430 universal coordinated time, an Avions Pierre Robin, DR400/180R, Italian registration I-ITAV, crashed during takeoff, while towing a glider, and was destroyed by fire. The airplane was departing Guidonia Airport (LIRG), Guidonia…
- [NTSB ERA11WA126](https://openairdocs.org/ntsb/ERA11WA126.md): Piper · Corupa, Brazil · Accident · 1 fatal · Foreign investigation · Jan 3, 2011 · PT-DJS · Substantial damage
  > On January 03, 2011, at 1200 coordinated universal time (10:00 local time), a Piper PA-25-260, Brazilian registration PT-DJS, incurred substantial damage when it impacted terrain for unknown reasons near, Corupa, Santa Catarina, Brazil,. The pilot was fatally…
- [NTSB ERA11WA098](https://openairdocs.org/ntsb/ERA11WA098.md): Bell 206 · Aracuju, Brazil · Accident · 1 fatal · Foreign investigation · Dec 21, 2010 · PR-HQB · Substantial damage
  > On December 21, 2010, about 1300 universal coordinated time, a Bell 206B, Brazilian registration PR-HQB, during an approach for landing; encountered a strong wind gust, impacted the terrain, and was substantially damaged in Aracaju, Segripe, Brazil. The pilot…
- [NTSB ERA11WA088](https://openairdocs.org/ntsb/ERA11WA088.md): Piper PA-32R-301T · Roma, Italy · Accident · 1 fatal · Foreign investigation · Dec 8, 2010 · N58SE · Destroyed
  > On December 8, 2010, at 1443 UTC, a Piper PA-32R-301T, N58SE, registered to Aircraft Guaranty Title Corporation Trustee,collided with a bus depot after departing runway 34 from Roma Urbe Airport (LIRU), Roma, Italy. The airplane had been recently purchased by…
- [NTSB ERA11WA075](https://openairdocs.org/ntsb/ERA11WA075.md): Piper PA-25 · Tapurah City, Brazil · Accident · 1 fatal · Foreign investigation · Nov 18, 2010 · PT-WOP · Destroyed
  > On November 18, 2010, about 1700 Universal Coordinated Time (UTC), a Piper PA-25-235, Brazilian registration PT-WOP, operated by Aeroagricola Boa Safra Ltda, lost control and crashed into trees during an agricultural flight at the Marape Farm, Tapurah City,…
- [NTSB WPR11WA020](https://openairdocs.org/ntsb/WPR11WA020.md): Cessna 172 · Durham Downs, Australia, Australia · Accident · 2 fatal · Foreign investigation · Oct 18, 2010 · VH-VSK · Substantial damage
  > On October 18, 2010, at 1230 universal coordinated time, a Cessna 172S, VH-VSK, collided with the terrain near Durham Downs, Australia. The airplane was operated by S. Kidman & Co LTD. The pilot and passenger were killed and the airplane was substantially…
- [NTSB ERA11WA008](https://openairdocs.org/ntsb/ERA11WA008.md): Cessna 402 · Nassau, Bahamas · Accident · 9 fatal · Foreign investigation · Oct 5, 2010 · C6NLH · Substantial damage
  > On October 5, 2010, about 1236 Atlantic standard time, a Cessna 402C, Bahamian registration C6-NLH, registered to and operated by Lebocruise Air Limited, crashed into Lake Killarney shortly after takeoff from the Lynden Pindling International Airport (MYNN),…

Next page: https://openairdocs.org/ntsb-events/470/sequence.md?state=OF&page=7

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/470/sequence?page=6&state=OF

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.