NTSB investigations, 2012, Outside the U.S.
3 cases where the sequence of events included Collision during takeoff/land.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 4 |
| 2016 | 3 |
| 2017 | 11 |
| 2018 | 4 |
| 2019 | 5 |
| 2020 | 4 |
| 2021 | 6 |
| 2022 | 8 |
| 2023 | 8 |
| 2024 | 8 |
| 2025 | 2 |
| 2026 | 1 |
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\" = '490' 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" = '490' 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 CEN12WA268Accident · Minor injuriesForeign investigationRobinson · Wuppertal-Langerfeld, GermanyOn April 28, 2012, at 1650 coordinated universal time, a Robinson R44 helicopter, D-HARV, impacted terrain near Wuppertal-Langerfeld, Germany. The pilot and 3 passengers sustained minor injuries. Visual meteorological conditions prevailed for the flight. The…NTSB ERA12WA243Accident · 1 fatalForeign investigationBell 407 · Podnovye, RussiaOn March 22, 2012, about 0615 coordinated universal time, a Bell 407, Russian registration RA-01931, was substantially damaged when it impacted electrical utility wires and the Volga River while on approach to a private landing area near Podnovye, Russia. The…NTSB ERA12WA238Accident · 4 fatalForeign investigationBeech 95B55 · Cameta, BrazilOn February 16, 2012, about 1230 universal coordinated time, a Beech 95-B55, Brazilian registration PT-LOU, was destroyed when it impacted trees and terrain shortly after takeoff in Cameta Municipality, State of Mato Para, Brazil. The foreign certificated…