NTSB investigations, 2011, Outside the U.S.

4 cases where NTSB found Aircraft.

Cases per year

20082026
NTSB investigations, 2011, Outside the U.S. per year, 2008–2026: 61 cases
20085
20098
20104
20114
20124
20136
20145
20153
20172
20183
20195
20203
20222
20231
20243
20253

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'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01'))
  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 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 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…Aug 19, 2011 · PR-SEK · Substantial damageNTSB CEN11WA412Accident · Serious injuriesForeign investigationMcDonnell Douglas Helicopter 369E · Glastonbury, United KingdomOn June 19, 2011, at 1420 universal coordinated time (UTC), a McDonnell Douglas Helicopter Company model 369E, United Kingdom registration G-KSWI, s/n 0204E, was substantially damaged during an emergency landing after experiencing a mechanical failure of the…Jun 19, 2011 · G-KSWI · Substantial damageNTSB ERA11WA209Accident · Serious injuriesForeign investigationCessna 182 · Palora, EcuadorOn Feburary 14, 2011, about 1935, universal coordinated time, a Cessna 182E, Ecuadorian registration HC-CDL, registered to and operated by Fundación Amazónica., incurred substantial damage during a force landing in rough terrain due to a total loss of engine…Feb 14, 2011 · HC-CDL · Substantial damage