NTSB investigations, 2011, Outside the U.S.
14 cases where NTSB found Not determined.
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\") = 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\", '05'))
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") = 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", '05')) 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 ERA12LA085Accident · Serious injuriesLimited investigationFinal reportPiper PA 46-350P · Caribbean Sea, A1The total loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered. Contributing to the accident was the pilot’s failure to comply with the airplane and engine limitations, and his decision to…NTSB CEN12WA223Accident · 1 fatalForeign investigationPiper PA-31 · Cottens, SwitzerlandThe accident investigation is under the jurisdiction and control of the Swiss government. This report is for informational purposes only and contains only information released by or obtained from the Swiss government or the Swiss Accident Investigation Board.…NTSB CEN12WA046Accident · 3 fatalForeign investigationPiper PA-31T · Toulouse, FranceUnder the jurisdiction and control of the French government.NTSB CEN11WA690Accident · No injuriesForeign investigationPiper PA 28 · Montpellier, FranceOn September 16, 2011, a Piper PA 28, French resistered F-HMAT, was substantially damaged during a forced landing following a loss of engine power near Montpellier, France. Visual meteorological conditions prevailed at the time of the accident. No one was…NTSB CEN11WA587Accident · 2 fatalForeign investigationGardan GY80-160 · Mauterndorf, AustriaUnder the jurisdiction and control of the Austrian Government.NTSB CEN11WA592Accident · 1 fatalForeign investigationSocata TB10 · Kufstein, AustriaUnder the jurisdiction and control of the Austrian government.NTSB CEN11WA407Accident · 2 fatalForeign investigationPiper PA-39 · Mont Agel, FranceUnder the jurisdiction and control of the French government.NTSB CEN11WA394Accident · 1 fatalForeign investigationAmerican Blimp A60PLUS · Reichelheim, GermanyUnder the jurisdiction and control of the German government.NTSB WPR11WA176Accident · 4 fatalForeign investigationPiper PA-32R · Moree, AustraliaThe accident is under the jurisdiction of and is being investigated by the Australian Transport Safety Bureau.NTSB ERA11WA189Accident · 1 fatalForeign investigationCessna 182 · Calamar, ColombiaOn 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 CEN11WA691Accident · No injuriesForeign investigationPiper PA46-500TP · Lausanne, SwitzerlandOn March 8, 2011, at 1430 coordinated universal time, a Piper PA 46-500TP, N747AW, was substantially damaged while landing at the Lausanne-La Blécherette Airport (LSGL), Lausanne, Switzerland. Visual meteorological conditions prevailed at the time of the…NTSB CEN11WA214Accident · 2 fatalForeign investigationCessna P210 · Armentières sur Avre, FranceUnder the jurisdiction and control of the French government.NTSB CEN11WA159Incident · Minor injuriesForeign investigationBeech B200 · Montpellier, FranceThe accident investigation is under the jurisdiction and control of the French government. This report is for informational purposes only and contains only information released by or obtained from the French government or Bureau d’Enquêtes et d’Analyses.…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…