NTSB investigations, 2015, Outside the U.S.
12 cases where the sequence of events included Miscellaneous/other.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 6 |
| 2011 | 2 |
| 2012 | 11 |
| 2013 | 12 |
| 2014 | 5 |
| 2015 | 12 |
| 2016 | 10 |
| 2017 | 7 |
| 2018 | 11 |
| 2019 | 10 |
| 2020 | 6 |
| 2021 | 10 |
| 2022 | 18 |
| 2023 | 20 |
| 2024 | 19 |
| 2025 | 32 |
| 2026 | 4 |
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\") = 2015
AND c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '900' 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"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") = 2015 AND c."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '900' 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
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 CEN16WA072Accident · 1 fatalForeign investigationMooney M20K · Mascouche, CanadaOn December 28, 2015, about 2227 universal coordinated time, a Canadian registered Mooney M20K, C-GUXC, impacted terrain while attempting to land at Mascouche (CSK3), Quebec, Canada. The pilot was fatally injured and the passenger was seriously injured. The…NTSB DCA16WA031Accident · 1 fatalForeign investigationEclipse 500 · Swellendam, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Eclipse Aviation 500 airplane that occurred on December 07, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA investigation…NTSB CEN16WA060Incident · No injuriesForeign investigationSikorsky S92 · Wexford, IrelandOn December 6, 2015, at 1415 universal coordinated time, a Sikorsky S92 helicopter, Irish registration EI-ICG, was involved in an off shore rescue operation. Two victims were being recovered when one of the victims slipped from the recue harness, fell back…NTSB DCA16WA007Incident · No injuriesForeign investigationBoeing 737 · Paderborn, GermanyThe German Federal Bureau of Aircraft Accidents Investigation (BFU) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on October 20, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation…NTSB ERA15WA346Accident · Minor injuriesForeign investigationBell 206L-3 · Boyaca, ColombiaOn September 1, 2015, about 1925 UTC, a Bell 206L-3, HK 3311, registered to and operated by Sociedad Aerea De Ibague, was landed hard in a field during a forced landing near Municipality of Chita, Boyaca, Colombia. Visual meteorological conditions prevailed…NTSB ENG15WA036Incident · No injuriesForeign investigationBoeing 737 · Quetta, PakistanThe government of Pakistan has notified the NTSB of an accident involving a Boeing 737-400 airplane that occurred on July 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the…NTSB CEN15WA302Incident · No injuriesForeign investigationRobinson R-22 Beta II · Hradec Kralove, Czech Republic, CzechiaOn June 29, 2015, about 0806 coordinated universal time (UTC), a Robinson R-22 Beta II, OK-ZYZ, experienced an in-flight anomaly and the pilot conducted an emergency autorotation to a field about 10 miles west of Hradec Kralove, Czech Republic. The two pilots…NTSB WPR15WA188Accident · 1 fatalForeign investigationRobinson R44 - Undesignat · Timber Creek, Australia, AustraliaOn June 14, 2015, at 1100 local time, a Robinson R44, VH-KJJ, collided with terrain under unknown circumstances near Timber Creek, Australia. The helicopter was operated under the pertinent civil regulation of the government of Australia. The helicopter was…NTSB DCA15WA210Incident · No injuriesForeign investigationBoeing 737 · Nauru, NauruThe Australian Transport Safety Board (ATSB) has notified the NTSB of an accident involving a BOEING 737 that occurred on June 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the provisions of ICAO…NTSB DCA15WA130Incident · No injuriesForeign investigationBoeing 737 - 4D7 · Turin, ItalyThe Agenzia Nazionale per la Sicurezza del Volo (ANSV) has notified the NTSB of an incident involving a Boeing 737-400, which occurred on June 7, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV investigation under the…NTSB DCA15WA178Incident · No injuriesForeign investigationBoeing Boeing 777-228 IGW · Douala, CameroonThe Bureau d'Enquêtes et d'Analyses pour la sécurité de l'aviation civile (BEA) has notified the NTSB of an incident involving a Boeing 777-200, which occurred on May 2, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BEA…NTSB CEN15WA178Accident · 3 fatalForeign investigationPiper PA32RT - 300T · Sudbury, Canada