NTSB investigations, 2013, Outside the U.S.
3 cases where the sequence of events included Hard landing.
Cases per year
| 2009 | 4 |
|---|---|
| 2010 | 3 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 3 |
| 2014 | 3 |
| 2015 | 11 |
| 2016 | 7 |
| 2017 | 2 |
| 2018 | 1 |
| 2020 | 5 |
| 2021 | 8 |
| 2022 | 3 |
| 2023 | 5 |
| 2024 | 1 |
| 2025 | 3 |
| 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\") = 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\" = '092' 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" = '092' 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 CEN14WA068Accident · No injuriesForeign investigationBell 407 · Rio Ablajo, HondurasOn November 16, 2013, approximately 1030 central standard time, a Bell 407 helicopter, HR-AXO, sustained substantial damage during a hard landing for undetermined reasons near Rio Ablajo, Honduras. The pilot and six passengers were not injured. Visual…NTSB ERA13WA439Accident · No injuriesForeign investigationBell 206B · Matoes do Norte, BrazilOn August 30, 2013, at 1555 coordinated universal time (1255 local time), a Bell 206B, Brazilian registration PT-HUE, was substantially damaged following a loss of engine power and a subsequent forced landing in Matões do Norte, Maranhão, Brazil. The pilot…NTSB DCA13WA110Accident · No injuriesForeign investigationSaab 340 · Mangrove Cay, BahamasThe Air Accident Investigation and Prevention Unit (AAIPU) of the Bahamas, has notified the NTSB of an accident involving a SAAB 340 that occurred on June 13, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIPU investigation…