NTSB investigations, 2015, 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\") = 2015
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") = 2015 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 DCA16WA028Incident · No injuriesForeign investigationBoeing 777 223 · Madrid, SpainThe Spanish CIAIAC has notified the NTSB of a ground collision involving an Iberia Airlines A330 and an American Airlines 777 that occurred on December 06, 2015, in Madrid, Spain. The NTSB has appointed a U.S. Accredited Representative to assist the CIAIAC…NTSB DCA15WA102Accident · No injuriesForeign investigationBoeing Boeing 737-8AS · Dublin, IrelandThe Air Accidents Investigation Unit f Ireland (AAIU-IE) has notified the NTSB of an accident involving a Boeing 737-8AS airplane that occurred on April 01, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU's investigation under…NTSB ENG15WA016Incident · No injuriesForeign investigationFokker F28 - 0070 · Amsterdam, NetherlandsOn March 05, 2015, about 1215 LCL, a Fokker F28, PH-WXC, On March 5, 2015, a Fokker F28 experienced a braking failure while on the ramp and struck a ground power unit (GPU) at Schiphol Airport (EHAM), Amsterdam, the Netherlands.The incident is being…