NTSB investigations, 2011
5 cases where the defining event was Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 60 |
|---|---|
| 2009 | 20 |
| 2010 | 39 |
| 2011 | 5 |
| 2016 | 1 |
| 2018 | 1 |
| 2019 | 8 |
| 2020 | 13 |
| 2021 | 56 |
| 2022 | 76 |
| 2023 | 59 |
| 2024 | 55 |
| 2025 | 61 |
| 2026 | 15 |
Where
Open the mapLatest 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\") = 2011
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '470')
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") = 2011 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '470') 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 WPR11WA129Accident · 1 fatalForeign investigationCessna 310R · Bathurst Island, Australia, AustraliaOn February 5, 2011, at 1255 universal coordinated time, a Cessna 310R, VH-XGX, operated by a private individual, collided with terrain near Bathurst Island, Australia. The airplane was substantially damaged and the pilot, the sole occupant, was killed. The…NTSB WPR11WA127Accident · 2 fatalForeign investigationRobinson R44 · Cessnock, Australia, AustraliaOn February 4, 2011, at 0047 universal coordinated time, a Robinson R-44, VH-HFH, operated by Aero Logistics Pty, collided with terrain during an instructional flight near Cessnock, Australia. The helicopter was substantially damaged and the pilot and a…NTSB WPR11CA105Accident · No injuriesData collectionFinal reportLantz Lake Tahoe Special · Redding, CAThe airplane's unintentional collision with debris during a water landing.NTSB ERA11WA119Accident · 1 fatalForeign investigationAvions Robin DR400 · Guidonia Montecelio, ItalyOn January 11, 2011, about 1430 universal coordinated time, an Avions Pierre Robin, DR400/180R, Italian registration I-ITAV, crashed during takeoff, while towing a glider, and was destroyed by fire. The airplane was departing Guidonia Airport (LIRG), Guidonia…NTSB ERA11WA126Accident · 1 fatalForeign investigationPiper · Corupa, BrazilOn January 03, 2011, at 1200 coordinated universal time (10:00 local time), a Piper PA-25-260, Brazilian registration PT-DJS, incurred substantial damage when it impacted terrain for unknown reasons near, Corupa, Santa Catarina, Brazil,. The pilot was fatally…