NTSB investigations, 2014, Outside the U.S.
10 cases where the sequence of events included Controlled flight into terr/obj (CFIT).
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 10 |
| 2010 | 8 |
| 2011 | 27 |
| 2012 | 21 |
| 2013 | 23 |
| 2014 | 10 |
| 2015 | 20 |
| 2016 | 17 |
| 2017 | 13 |
| 2018 | 13 |
| 2019 | 17 |
| 2020 | 9 |
| 2021 | 11 |
| 2022 | 11 |
| 2023 | 8 |
| 2024 | 13 |
| 2025 | 9 |
| 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\") = 2014
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\" = '120' 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") = 2014 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" = '120' 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 ERA15RA047Accident · 9 fatalForeign investigationGates Learjet 35A · Freeport, BahamasNTSB WPR14WA318Accident · 1 fatalForeign investigationCessna T210N · Inverell, Australia, AustraliaOn July 4, 2014, at 1325 local time, a Cessna T210N, VH-ZFW, collided with terrain shortly after takeoff from Inverell, Australia. The airplane was operated by the pilot under the pertinent civil regulations of the government of Australia. The airplane was…NTSB ERA14WA287Accident · 3 fatalForeign investigationCessna 172N · Premana Lecco, ItalyNTSB ERA14WA246Accident · Serious injuriesForeign investigationCessna T206H · Macas, EcuadorOn May 14, 2014, about 1600 local time, a Cessna T206H, Ecuadorian registration HC-CFE, was substantially damaged when it impacted power lines while returning to land at Edmundo Carvajal Airport (SEMC), Macas, Ecuador, with smoke in the cockpit. The…NTSB ERA14WA221Accident · 2 fatalForeign investigationPiper PA-31 · Santander, ColombiaOn May 3, 2014, about 1500 coordinated universal time, a Piper PA-31, Canadian registration C-GSVM, was substantially damaged when it impacted terrain near Santander, Colombia. The pilot and passenger were fatally injured. The local survey flight departed…NTSB ERA14WA207Accident · 4 fatalForeign investigationEmbraer EMB-720D · Aripuanã, BrazilOn April 6, 2014, about 1130 universal coordinated time, an Embraer EMB-720D, Brazilian registration PT-ROS, was destroyed when it impacted trees and terrain near Aripuanã, Brazil. The pilot and three passengers were fatally injured. The flight originated…NTSB ERA14WA187Accident · 1 fatalForeign investigationPiper PA-30 · Collagna, ItalyOn April 4, 2014, at 0920 Coordinated Universal Time (UTC), a Piper PA-30, N678AL, was destroyed when it impacted terrain during cruise flight near Collagna, Italy. The pilot, the sole occupant, was fatally injured. The flight was operated by a private…NTSB CEN14WA184Accident · 2 fatalForeign investigationCessna T210L · San Marcos, GuatemalaOn April 1, 2014, about 1340 local time, a Cessna T210L, single engine airplane, N732JY, was destroyed after impacting mountainous terrain near San Marcos, Guatemala. The pilot and passenger were fatally injured. About 1318 the airplane departed from…NTSB WPR14WA311Accident · Serious injuriesForeign investigationRobinson Helicopter R22 Beta · Borroloola, Australia, AustraliaOn March 27, 2014, at 0900 universal coordinated time, a Robinson R22 Beta, VH-HRX, collided with terrain near Borroloola, Australia during an aerial mustering flight. The helicopter was operated by the pilot under the pertinent civil regulations of the…NTSB ERA14WA092Accident · 5 fatalForeign investigationBell 206 - L3 · Antioquia, Colombia