NTSB investigations, 2008, Outside the U.S.
9 cases where the sequence of events included Unknown or undetermined.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 9 |
| 2010 | 20 |
| 2011 | 19 |
| 2012 | 16 |
| 2013 | 26 |
| 2014 | 40 |
| 2015 | 60 |
| 2016 | 78 |
| 2017 | 69 |
| 2018 | 79 |
| 2019 | 46 |
| 2020 | 50 |
| 2021 | 49 |
| 2022 | 50 |
| 2023 | 55 |
| 2024 | 59 |
| 2025 | 70 |
| 2026 | 207 |
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\" = '000' 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" = '000' 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 ERA09WA113Accident · 12 fatalForeign investigationBritten Norman BN-2A MK III · Turks and Caicos, Turks & Caicos IslandsNTSB ERA09WA037Accident · 3 fatalForeign investigationBeech 65A90 · Timehri, GuyanaNTSB ERA09WA028Accident · 1 fatalClass 5 · ForeignHawker-Beechcraft 100 · Bauru, BrazilNTSB NYC08WA308Accident · 2 fatalForeign investigationRobinson R-44 · Muzino Village, RussiaNTSB DFW08WA240Accident · 1 fatalForeign investigationCessna 501 · Las Americas, Dominican RepublicNTSB DCA08WA086AccidentForeign investigationBoeing 767 - 200 · Budapest, HungaryOn July 29, 2008, at 1607 local Budapest time, a Krasnojarsky Airlines Boeing 767-200, EI-GBA, experienced an inadvertent deployment of an emergency escape slide after takeoff from Budapest, Hungary. The flight continued to its destination of Domodedovo…NTSB DCA08WA074AccidentForeign investigationFairchild SA226 · Bergen, NorwayOn June 20, 2008, at 1032 local Norwegian time, a Helitrans AS Fairchild Aircraft Corporation SA226-T(B), registration LN-SFT, crashing into the North Sea approximately 15 NM West of Bergen Airport (ENBR), Bergen, Norway. The aircraft was on a training flight…NTSB DCA08WA073Accident · 4 fatalForeign investigationCessna 210 · Nairegi Enkera, KenyaOn June 10, 2008, about 1200 UTC, a Cessna 210, registration 5Y-BE, a chartered flight, was en route when it collided with high terrain near Nairegi Enkera, Kenya. The airplane was on a visual flight; instrument meteorological conditions prevailed due to low…NTSB CHI08FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 310N · Keflavík, IcelandThe reported loss of both engines' power during cruise for undetermined reasons.