NTSB investigations, 2011
4 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\") = 2011
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") = 2011 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 ANC11CA092Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Deadhorse, AKThe pilot's continued visual flight into instrument meteorological conditions.NTSB WPR11FA319Accident · 2 fatalField investigationFinal reportPiper PA-22-135 · Verlot, WAThe non-instrument rated pilot’s decision to continue visual flight into clouds and his failure to maintain clearance from terrain while maneuvering in an area of reduced visibility, low clouds, and mountain obscuration.NTSB WPR11FA241Accident · 3 fatalField investigationFinal reportCessna R172K · Cold Springs, NVThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in a controlled collision with terrain.NTSB CEN11FA347Accident · 1 fatalField investigationFinal reportBeech F33A · Taos, NMThe pilot’s continued visual flight into instrument meteorological conditions, which resulted in loss of situational awareness, and a possible encounter with icing conditions.