NTSB investigations, 2009, 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\") = 2009
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") = 2009 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 ERA10WA012Accident · 3 fatalForeign investigationAerospatiale AS350 · Cusco, PeruOn October 1, 2009, about 2205 UTC, a Eurocopter AS350-B3, Peruvian registration OB-1911-P, operated by Coyotair S.A.C., was destroyed following an impact with terrain near Cusco, Peru. The helicopter impacted against a hill side at approximately 11,700 feet…NTSB CEN09WA529Accident · 2 fatalForeign investigationBell 412 · Manzanillo, MexicoOn August 7, 2009 a Bell Helicopter model 212 was destroyed when it impacted the ground in low visibility mountainous terrain. The pilot and on board mechanic were killed. The helicopter is located near a mountain top and is not accessible. When to helicopter…NTSB ERA09WA408Accident · 2 fatalForeign investigationBeech A36 · Masizo del Roraima, Venezuela, VenezuelaOn July 16, 2009, about 1640 Atlantic standard time, the wreckage of a Beechcraft A36 A, N354RA, was located on the “Ilu – Tepuy” mountain, within the sector of Masizo del Roraima, Bolivar, Venezuela. The pilot had filed a flight plan from the Maurice Bishop…NTSB WPR09WA296Accident · 1 fatalForeign investigationRobinson R22 · Paraburdoo, AustraliaOn June 25, 2009 at 2230 local time, a Robinson R22 helicopter, Australia registry VH-HXO, collided with the ground near Paraburdoo, Western Australia. The helicopter was owned and operated by a private individual and was on a non-commercial cross country…NTSB ERA09WA288Accident · 5 fatalForeign investigationCessna 172 RG · Santa Cruz, BoliviaOn May 11, 2008, about 1930 Atlantic standard time, a Cessna 172 RG, Bolivian registration CP-2492, , registered to and operated by a private individual, impacted a tree with its left’s wing and then the ground, where a fire ensued. The accident sight was…NTSB ERA09WA279Accident · 2 fatalForeign investigationCirrus Design SR22 · Mt. Ainos, GreeceNone.NTSB ERA09WA241Accident · 4 fatalForeign investigationCessna 210 · Concepcion, BoliviaOn April 11, 2009, at 2305 universal coordinated time (1905 local time), a Cessna 210M, Bolivian registration CP-1373, was destroyed when it impacted terrain shortly after taking off from Concepcion Airport (SLCP), Concepcion, Bolivia. The certificated…NTSB CEN09WA240Accident · 2 fatalForeign investigationSchweizer 269C · Kilshanchoe, IrelandThis is under the jurisdiction and control of the Irish government.NTSB ERA09WA218Accident · 7 fatalForeign investigationBeech BE-200 · Quito, EcuadorNone.NTSB CEN09WA138Accident · 1 fatalForeign investigationPiper PA-42-720 · Konigstein, GermanyThis is under the jurisdiction and control of the German Government.