NTSB investigations, 2008, Outside the U.S.
5 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\") = 2008
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") = 2008 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 ERA09WA206Accident · 3 fatalForeign investigationBeech V35 · Valenca, BrazilOn December 30, 2008, about 1240 UTC, or 1040 local, a Beech V35B, Brazilian registration PT-JKU, registered to and operated by Unibase Engenharia e Pavimentacao Ltda, collided with mountainous terrain near Valenca, RJ, Brazil. Instrument meteorological…NTSB CEN09WA082Accident · 2 fatalForeign investigationLearjet Lear 23 · Tlaxcala, MexicoOn December 7, 2008 at approximately 1815 central standard time (CST) a twin-engine turbo fan, Learjet 23, Mexican Registration XC-LGD, was destroyed when it impacted a lake while on final approach to an unlit day visual flight rules airport near Tlaxcala,…NTSB WPR09WA042Accident · 4 fatalForeign investigationPiper PA31-350 · Bathurst, Australia, AustraliaOn November 7, 2008, approximately 0930 coordinated universal time (UTC), a Piper PA-31-350, Australian registration VH-OPC, shortly after take-off, collided with terrain about three nautical miles north of the Bathurst Airport, New South Wales, Australia.…NTSB CEN09WA022Accident · 3 fatalForeign investigationCessna 402 · Monterrey, MexicoOn October 17, 2008, a Cessna 402C with Mexican Registration XC-HAQ departed on Runway 02 from Del Norte Airport (MMAN), near Monterrey, Nuevo Leon, Mexico at 1308 central daylight time (CDT) and was on climb out to cruise when radar contact was lost at 1315.…NTSB DCA08RA095Accident · 17 fatalForeign investigationBeech 1900 · Bukavu, Congo - KinshasaOn September 1, 2008 about 1510 UTC, ZS-OLD, Beech 1900C, operated by Air Serv International, collided with high terrain during approach to Bukavu, Democratic Republic of Congo (DRC). The pilot, copilot, and 15 passengers were fatally injured. The airplane…