NTSB investigations, 2012, Outside the U.S.
6 cases where NTSB found Not determined, general.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 18 |
| 2010 | 9 |
| 2011 | 14 |
| 2012 | 6 |
| 2013 | 5 |
| 2014 | 3 |
| 2015 | 2 |
| 2018 | 1 |
| 2025 | 12 |
| 2026 | 8 |
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\") = 2012
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\", '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.
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") = 2012 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", '05000000')) 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 CEN13WA173Accident · No injuriesForeign investigationSwearingen SA226 · Murcia, SpainOn November 13, 2012, at 1205 coordinated universal time, a Swearingen Fairchild SA-226-TC, Spanish registered EC-JYC, operated by Zorex.org, sustained minor damage during the takeoff roll from the Murcia-San Javier Airport (LELC), Murcia, Spain. Visual…NTSB CEN12WA560Accident · 2 fatalForeign investigationPaulistinha 56-C1 56-C1 · Braga, PortugalThis report is under the jurisdiction and control of the Portuguese Government.NTSB ANC12WA087Accident · 1 fatalForeign investigationPiper PA-30 · Kelowna, CanadaOn August 13, 2012, about 1729 Pacific daylight time, a Piper PA-30 airplane, (Canadian Registration C-GLGJ) was on a VFR flight plan from Penticton to Boundary Bay, British Columbia. The Canadian Joint Rescue Coordination Centre received an ELT signal, and a…NTSB CEN12WA685Accident · 3 fatalForeign investigationPiper PA-30 · Soyapango, El SalvadorOn July 11, 2012, at 1212 coordinated universal time, a Piper PA-30, El Salvador-registered YS-125P, operated by Escuela De Pilotos Dargonza, was destroyed when it impacted terrain near Soyapango, El Salvador. Visual meteorological conditions prevailed at the…NTSB ERA12WA353Accident · 2 fatalForeign investigationEmbraer EMB712 · Morro do Manduba Guaruja, BrazilOn 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 CEN12WA679Accident · 2 fatalForeign investigationRobinson R22 · Huy, BelgiumThis accident is under the jurisdiction and control of the Belgium government.