NTSB investigations, 2010, Outside the U.S.
2 cases where the sequence of events included Landing gear collapse.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 2 |
| 2011 | 6 |
| 2012 | 6 |
| 2013 | 3 |
| 2014 | 7 |
| 2015 | 9 |
| 2016 | 12 |
| 2017 | 10 |
| 2018 | 10 |
| 2019 | 11 |
| 2020 | 6 |
| 2021 | 13 |
| 2022 | 13 |
| 2023 | 12 |
| 2024 | 14 |
| 2025 | 12 |
| 2026 | 7 |
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\") = 2010
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\" = '094' 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") = 2010 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" = '094' 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 WPR11WA164Incident · No injuriesForeign investigationDe Havilland DHC8 · Blenheim, New ZealandOn September 20, 2010, at 0400 universal coordinated time, a de Havilland Canada, DHC-8-300, ZK-NEB, experienced a nose gear collapse after landing at Blenheim Airport, New Zealand. The airplane was operated by Air Nelson Ltd, as a commercial passenger…NTSB ENG10WA052Incident · No injuriesForeign investigationBoeing 747 · Hong Kong, ChinaOn September 21, 2010, 0930 Coordinated Universal Time (UTC), an Air Cargo Germany, a Boeing B-747-412F,registered as D-ACGD, was performing a left turn to line up with Runway 25L for take-off 31C at Hong Kong International Airport. Just before finishing the…