NTSB investigations, 2013, Outside the U.S.
3 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\") = 2013
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") = 2013 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 CEN13WA560Accident · No injuriesForeign investigationBeech 76 - NO Series · Dublin, IrelandOn September 20, 2013, at 1703 hours universal coordinated time, a Beech model 76 Duchess, Ireland registration EI-BUN, was involved in a runway excursion after landing at the Weston Airfield (EIWT), Dublin, Ireland. The flight instructor and pilot receiving…NTSB DCA13WA171Accident · No injuriesForeign investigationBeech E90 · Rustenburg, South AfricaNTSB DCA13WA063Accident · No injuriesForeign investigationSwearingen 227 · Dublin, IrelandThe AAIU of Ireland has notified the NTSB of an accident involving a Swearingen 227 that occurred on March 07, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU-Ireland's investigation under the provisions of ICAO Annex 13 as…