NTSB investigations, 2012
7 cases where NTSB found Obscuration.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2010 | 5 |
| 2011 | 4 |
| 2012 | 7 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 4 |
| 2020 | 1 |
| 2021 | 3 |
| 2022 | 1 |
| 2024 | 4 |
Where
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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03035030'))
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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03035030')) 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 WPR13FA053Accident · 1 fatalField investigationFinal reportCessna 182D · Bondurant, WYThe noninstrument-rated pilot’s failure to maintain clearance from terrain while maneuvering around weather.NTSB CEN12FA639Accident · 2 fatalField investigationFinal reportMooney M20J · Teddys Peak, COThe pilot's decision to continue flight into deteriorating weather conditions, including fog and mountain obscuration, and his failure to maintain clearance with known rising terrain along the route of flight, which resulted in controlled flight into terrain.NTSB ANC12LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Coldfoot, AKThe pilot's failure to maintain clearance from terrain while maneuvering to reverse course.NTSB ANC12CA089Accident · No injuriesData collectionFinal reportMaule M-5-210C · Coldfoot, AKThe pilot's delayed decision to turn around while flying through a narrow mountain pass, which resulted in a forced landing and impact with terrain.NTSB ERA12FA409Accident · 1 fatalField investigationFinal reportRaytheon C90GT · Morgantown, WVThe pilot's inadequate preflight route planning and in-flight route and altitude selection, which resulted in an in-flight collision with a communications tower in possible instrument meteorological conditions. Contributing to the accident were the pilot's…NTSB WPR12FA255Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Mountain Home, IDThe noninstrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.NTSB WPR12FA098Accident · 2 fatalField investigationFinal reportCessna 210 · Morgan, UTThe non-instrument-rated pilot’s poor planning and continued visual flight rules flight into instrument meteorological conditions and failure to maintain clearance from mountainous terrain.