NTSB investigations, 2014, 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\") = 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\" = '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") = 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" = '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 WPR14WA128Accident · No injuriesForeign investigationHughes 369D · Moonlight Creek, New Zealand, New ZealandOn February 25, 2014, at 2055 universal coordinated time, a Hughes 369D, ZK-IQQ, was substantially damaged when the main rotor blades contacted and severed the tailboom at the conclusion of an autorotation and landing near Moonlight Creek, New Zealand. The…NTSB DCA14WA056Accident · Serious injuriesForeign investigationBoeing 737-900 · Surabaya, IndonesiaThe Indonesian National Transportation Safety Committee (NTSC) has notified the NTSB of an accident involving a Boeing 737-900 that occurred on February 1, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the NTSC investigation under…NTSB DCA14WA059Incident · No injuriesForeign investigationBoeing 737 · Grand Cayman, Cayman IslandsThe Air Accidents Investigation Branch of the UK (AAIB-UK) has notified the NTSB of an accident involving a Boeing 737 that occurred on January 15, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB-UK's investigation under the…