NTSB investigations, 2014, Outside the U.S.
2 cases where the sequence of events included Landing gear not configured.
Cases per year
| 2010 | 2 |
|---|---|
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2016 | 2 |
| 2017 | 3 |
| 2018 | 4 |
| 2020 | 1 |
| 2021 | 7 |
| 2022 | 1 |
| 2023 | 4 |
| 2024 | 5 |
| 2025 | 2 |
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\" = '095' 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" = '095' 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 ERA15WA207Accident · No injuriesForeign investigationBeech B300 · Samara, RussiaOn November 25, 2014, about 1852 universal coordinated time, a Beechcraft Corporation B300, Russian registration RA-02778, was substantially damaged when it landed with the landing gear retracted and slid off the runway at Kurumoch International Airport…NTSB DCA14WA030Accident · Serious injuriesForeign investigationBoeing 767-3W0ER · Madinah, Saudi ArabiaThe Kingdom of Saudi Arabia, Aviation Investigation Bureau (AIB), has notified the NTSB of an accident involving a Boeing 767-300 that occurred on January 5, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AIB investigation under…