NTSB investigations, 2012, Outside the U.S.
6 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\") = 2012
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") = 2012 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 DCA13WA020Incident · No injuriesForeign investigationBoeing MD-82 · Johannesburg, South AfricaOn November 13, 2012, a McDonnell Douglas MD-80, registration ZS-TOG, experienced a wheel failure on the left hand main gear during takeoff from O.R.Tambo International Airport (FAJS), , South Africa. The chartered flight was enroute to Kamuzu International…NTSB DCA13WA023Incident · No injuriesForeign investigationBoeing 737 · Casablanca, MoroccoOn October 24, 2012 a Boeing 737-800, registration CN-ROA experienced a nosewheel failure during taxiing after landing at the Casablanca / Mohammed V Airport. The airplane was operated by Royal Air Maroc as flight 471 from Tunis, Tunisia. There were no…NTSB DCA13WA002Accident · No injuriesForeign investigationMcdonnell Douglas MD11 · Sao Paulo, BrazilNTSB CEN12WA364Incident · No injuriesForeign investigationPiper PA23 · Igualada, Spain, SpainOn June 9, 2012 about 1000 UTC, a Spanish registered Piper PA-23-250, EC-GCF, sustained minor damage when the left main landing gear collapsed during landing at Igualada Aerodrome, Spain. The pilot crew and five passengers on board the airplane were not…NTSB DCA12WA073Accident · No injuriesForeign investigationConvair 440 · Ciudad de Guatemala, GuatemalaNTSB DCA12WA161Incident · No injuriesForeign investigationBoeing 737 · Karachi, PakistanOn April 22, 2012, at about 12:35 local time, a Shaheen Boeing 737-400, registration number AP-BJN, operating as flight NL122 from Islamabad (ISB) to Karachi (KHI), Pakistan had the left main landing gear collapse upon landing KHI. It is reported that there…