NTSB investigations, Outside the U.S.

82 cases where NTSB found Not determined, general.

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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '05000000'))
  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 ERA11WA126Accident · 1 fatalForeign investigationPiper · Corupa, BrazilOn 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…Jan 3, 2011 · PT-DJS · Substantial damageNTSB CEN11WA105Accident · 2 fatalForeign investigationRobinson R22 · Tourrettes-sur-Loup, FranceOn December 9, 2010, at 0755 coordinated universal time, a Robinson R22, United Kingdom registered G-CBVL, operated by Spiral Wing, Ltd., was destroyed when it impacted mountainous terrain under unknown circumstances near Tourrettes-sur-Loup, France. Visual…Dec 9, 2010 · G-CBVL · DestroyedNTSB CEN11RA024Accident · 4 fatalForeign investigationBeech A36 · Ensenada, MexicoOn October 15, 2010, at 2200 coordinated universal time (1400 local), a Beech A36, US registered N212DB, owned by Lyon Roger C Trustee and piloted by an instrument rated private pilot, was destroyed when it impacted terrain under unknown circumstances near…Oct 15, 2010 · N212DB · DestroyedNTSB CEN10WA534Accident · Minor injuriesForeign investigationCessna 208 · Pointe a Pitre, GuadeloupeOn September 5, 2010, at 1919 coordinated universal time, a Cessna 208B, French registered F-OIXZ, operated by Tropic Airlines, was substantially damaged during a forced landing near Pointe a Pitre, Guadeloupe. Visual meteorological conditions prevailed at…Sep 5, 2010 · F-OIXZ · Substantial damageNTSB CEN10WA585Accident · 2 fatalForeign investigationSchweizer 269C · Saint Gondon, FranceOn July 25, 2010, at 0800 coordinated universal time, a Schweizer 269C, French registered F-GJGQ, was destroyed when it impacted trees in a wooded area under unknown circumstances near Saint-Gondon, France. Visual meteorological conditions prevailed at the…Jul 25, 2010 · F-GJGQ · DestroyedNTSB ENG10IA038Incident · No injuriesIncident investigationFinal reportBoeing 767 · Athens, GreeceA short circuit involving the light in position L3 on the squib test panel. The specific cause of the short circuit could not be determined.Jun 16, 2010 · N196DN · Minor damageNTSB CEN10WA150Accident · 3 fatalForeign investigationCessna 421 · Tegucigalpa, HondurasThis investigation is under the jurisdiction and control of the Honduran government.Mar 10, 2010 · TG-JYM · DestroyedNTSB CEN10WA148Accident · 2 fatalForeign investigationAlon Aircoupe A2-A · Ciborro, Montemor-o-Novo, PortugalThis accident is under the jurisdiction and control of the Portuguese government.Mar 6, 2010 · CS-AIG · DestroyedNTSB CEN10WA134Accident · 2 fatalForeign investigationCessna 150 · Waldzell, AustriaThis accident is under the jurisdiction and control of the Austrian government.Feb 28, 2010 · OE-CFT · Substantial damageNTSB CEN10WA121Accident · 2 fatalForeign investigationCessna 550B · Reinhardtsdorf-Schöna, GermanyThis investigation is under the jurisdiction and control of the German Government.Feb 14, 2010 · OK-ACH · DestroyedNTSB ERA10RA097Accident · 2 fatalForeign investigationDassault/Sud Falcon 20 · Matthew Town, BahamasOn December 17, 2009, about 1922 eastern standard time, a Dassault Falcon 20, N28RK, crashed in a remote area approximately 12 miles east of Matthew Town, Inagua, Bahamas. The 2 pilots were killed and the airplane was destroyed. Night, visual meteorological…Dec 18, 2009 · N28RK · DestroyedNTSB ERA10WA312Accident · 5 fatalForeign investigationBeech 58 · Guarico, VenezuelaOn December 13, 2009, about 2040 UTC, a Beech 58, of Venezuelan registration, YV2473, registered to and operated by Aeronaves Baron, C.A., impacted terrain during takeoff from the Mata de Juajua Airport (SVCS), near Estatdo Guárico, Venezuela. Visual…Dec 13, 2009 · YV2473 · Substantial damageNTSB CEN10WA066Accident · 3 fatalForeign investigationBeech F90 · Egelsbach, GermanyUnder the jurisdiction and control of the German government.Dec 7, 2009 · D-IDVK · DestroyedNTSB WPR10WA070Accident · 4 fatalForeign investigationRobinson R44 · Netanya, Israel, IsraelThe accident is under the jurisdiction of, and is being investigated, by the State of Israel, Ministry of Transport, Aviation Incidents and Accidents Investigation (AIAI).Nov 24, 2009 · 4X-BDM · Substantial damageNTSB ERA10WA044Accident · 1 fatalForeign investigationBritten Norman BN2A · Kralendijk, Bonaire, NTOn October 22, 2009, about 1417 universal coordinated time, a Britten Norman BN-2A/26, PJ-SUN, experienced a right engine failure during cruise flight, and subsequently ditched in the Caribbean Sea, near Kralendijk, Bonaire, Netherlands Antilles. The airplane…Oct 22, 2009 · PJ-SUN · Substantial damageNTSB CEN10WA003Accident · 1 fatalForeign investigationCessna F172N · Sulzberg, GermanyUnder the jurisdiction and control of the German government.Oct 2, 2009 · D-EDVG · DestroyedNTSB CEN09WA582Accident · 2 fatalForeign investigationReims F172 · Commune de Brethencourt, FranceUnder the jurisdiction and control of the French government.Sep 8, 2009 · F-BXIU · 2 aircraft · DestroyedNTSB CEN10WA486Accident · 2 fatalForeign investigationCessna T206 · Hamburg Harbour, GermanyOn August 22, 2009, at 1252 coordinated universal time, a Cessna T206H, was substantially damaged when it nosed over during a water landing at Hamburg Harbour, Hamburg, Germany. Visual meteorological conditions prevailed at the time of the accident. The pilot…Aug 22, 2009 · Substantial damageNTSB CEN09WA524Accident · 2 fatalForeign investigationBeech 99 · Évora, PortugalUnder the jurisdiction and control of the Portuguese government.Aug 14, 2009 · F-BTME · DestroyedNTSB CEN09WA454Accident · 1 fatalForeign investigationCirrus SR22 · Perrigny, FranceUnder the jurisdiction and control of the French government.Jul 18, 2009 · N752CD · DestroyedNTSB ERA09WA406Accident · Serious injuriesForeign investigationPiper PA-34-200T · Imperatrize, Maranhao, BrazilOn July 3, 2009, at 2146 UTC, a Piper PA-34-200T, PT-RFU, registered to and operated by Heringer Taxi Aereo LTD, as a cargo flight,lost engine power on one engine after takeoff from Imperatriz, Maranhao Airport, Brazil. The pilot attempted to return to the…Jul 3, 2009 · PT-RFU · Substantial damageNTSB CEN09WA333Accident · 1 fatalForeign investigationCessna 172H · Uddevalla, SwedenUnder the jurisdiction and control of the Swedish government.Jun 1, 2009 · SE-GUP · DestroyedNTSB CEN09WA240Accident · 2 fatalForeign investigationSchweizer 269C · Kilshanchoe, IrelandThis is under the jurisdiction and control of the Irish government.Apr 1, 2009 · EI-CZL · DestroyedNTSB ERA09WA223Accident · 1 fatalForeign investigationBeech A36 · Querencia, BrazilNoneMar 8, 2009 · PT-LKH · DestroyedNTSB CEN09WA177Accident · 2 fatalForeign investigationDassault Falcon · Samedan, SwitzerlandThis is under the jurisdiction and control of the Swiss government.Feb 12, 2009 · VP-BAF · DestroyedNTSB ERA09WA166Accident · 24 fatalForeign investigationEmbraer EMB110 · Coari, BrazilOn February 7, 2009, at 1810 universal time coordinates, an Embraer EMB 110P1, Brazilian registry PT-SEA, operated by Manaus Aerotaxi as a commuter flight, experienced an unknown problem after take-off from the Coari, Amazonas Airport (SWKO) in Coari, Brazil,…Feb 7, 2009 · PR-SAE · DestroyedNTSB CEN09WA138Accident · 1 fatalForeign investigationPiper PA-42-720 · Konigstein, GermanyThis is under the jurisdiction and control of the German Government.Jan 19, 2009 · DIDIA · DestroyedNTSB CEN09WA129Accident · 1 fatalForeign investigationEurocopter Deutsch EC 135 T2 · Molesmes, FranceUnder the jurisdiction and control of the French government.Jan 2, 2009 · F-HBMA · DestroyedNTSB ERA09WA075Accident · 3 fatalForeign investigationBell 206 · Vetas, ColombiaNone.Nov 24, 2008 · HK4361 · Substantial damageNTSB CEN09WA033Accident · 2 fatalForeign investigationCirrus Design SR22 · Zurich, SwitzerlandUnder the jurisdiction and control of the Swiss Government.Oct 22, 2008 · N467BD · DestroyedNTSB LAX08WA133Accident · Serious injuriesForeign investigationBell 206L1 · Foasi, PNG, IndonesiaThe cause will be determined by the Indonesian National Transportation Safety Committee.Feb 12, 2008 · P2-IHI · Substantial damageNTSB CHI08FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 310N · Keflavík, IcelandThe reported loss of both engines' power during cruise for undetermined reasons.Feb 11, 2008 · N5030Q · Substantial damage