NTSB investigations, 2011
6 cases where NTSB found Aircraft capability, general.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 7 |
| 2010 | 3 |
| 2011 | 6 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 5 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 3 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 4 |
| 2024 | 1 |
| 2025 | 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\", '01061000'))
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", '01061000')) 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 ERA12CA040Accident · No injuriesData collectionFinal reportEngineering & Research 415-C · Mebane, NCThe pilot's delay in aborting the takeoff.NTSB ANC11CA085Accident · No injuriesData collectionFinal reportMaule M-5-210C · Tok, AKThe pilot's failure to go-around soon enough to preclude the necessity of a forced landing due to the airplane's inability to outclimb ascending terrain.NTSB WPR11CA365Accident · No injuriesData collectionFinal reportCessna 162 · Rawlings, WYThe pilot's decision to attempt a takeoff at a density altitude that was outside the performance envelope of the airplane. Also causal was the flight's likely encounter with a sudden tailwind gust.NTSB WPR11FA228Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Rock Springs, WYThe pilot’s decision to continue flight into an area of known adverse weather, which resulted in an accumulation of structural ice that led to a loss of control and in-flight breakup. Also causal was the pilot’s inadequate preflight weather planning.NTSB CEN11CA325Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Golden, COThe pilot’s decision to operate the helicopter at a high density altitude near terrain, which resulted in a settling with power condition.NTSB CEN11CA167Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Anoka, MNThe student pilot's control inputs that resulted in an inadvertent dynamic rollover and the CFI's inadequate supervision of the flight.