NTSB investigations, 2012, Outside the U.S.
3 cases where the sequence of events included Ground collision.
Cases per year
| 2011 | 1 |
|---|---|
| 2012 | 3 |
| 2013 | 4 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 6 |
| 2020 | 2 |
| 2021 | 8 |
| 2022 | 6 |
| 2023 | 11 |
| 2024 | 8 |
| 2025 | 11 |
| 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\") = 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\" = '200' 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" = '200' 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 DCA12WA140Incident · No injuriesForeign investigationBoeing 747-400 · Jeddah, Saudi ArabiaThe Kingdom of Saudi Arabia, General Authority of Civil Aviation (GACA), has notified the NTSB of an ground collision accident involving a Boeing 747-300 and a Boeing 747-400 that occurred on August 20, 2012. The NTSB has appointed a U.S. Accredited…NTSB DCA12WA064Incident · No injuriesForeign investigationBoeing 737 - 800 · Seville, SpainThe Spanish Comisión de Investigación de Accidentes e Incidentes de Aviación Civil (CIAIAC) has notified the NTSB of an accident involving two Boeing 737 airplanes that occurred on April 13, 2012. The NTSB has appointed a U.S. Accredited Representative to…NTSB DCA12WA103Incident · No injuriesForeign investigationBoeing 737-800 · Stockholm, SwedenOn January 7, 2012, the left winglet of a Boeing 737-800, TC-SNM, operated by SunExpress, impacted the right horizontal stabilizer of a parked airplane while taxiing at the Arlanda Airport (ARN), Stockholm, Sweden. There were no reported injuries to the…