NTSB investigations, 2011
12 cases where NTSB found Sloped/uneven terrain.
Cases per year
| 2008 | 26 |
|---|---|
| 2009 | 17 |
| 2010 | 5 |
| 2011 | 12 |
| 2012 | 13 |
| 2013 | 10 |
| 2014 | 21 |
| 2015 | 16 |
| 2016 | 16 |
| 2017 | 18 |
| 2018 | 33 |
| 2019 | 36 |
| 2020 | 8 |
| 2021 | 12 |
| 2022 | 6 |
| 2023 | 5 |
| 2024 | 3 |
| 2025 | 9 |
| 2026 | 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\", '03021017'))
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", '03021017')) 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 ERA12CA095Accident · No injuriesData collectionFinal reportBell 206L-3 · Wingate, NCThe certified flight instructor did not select an adequate landing site for the practice autorotation.NTSB ANC12CA005Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Portage, AKThe pilot's selection of unsuitable terrain for landing.NTSB CEN11CA674Accident · No injuriesData collectionFinal reportCessna 172N · Wadsworth, OHThe pilot's misjudgment of his speed and distance, which resulted in an overrun.NTSB WPR11CA435Accident · Serious injuriesData collectionFinal reportAerostar International S-60A · Park City, UTThe pilot’s failure to maintain control of the balloon during the landing on uneven ground.NTSB WPR11FA426Accident · Serious injuriesField investigationFinal reportEnstrom 280FX · Heber City, UTThe pilot’s failure to ensure that there was sufficient fuel onboard to conduct the flight, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the severity of the passengers’ injuries was the operator’s failure to provide…NTSB ERA11CA486Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Gaithersburg, MDThe pilot's decision to continue taxiing with restricted windshield visibility.NTSB ANC11CA082Accident · No injuriesData collectionFinal reportPiper PA-20 · Tyonek, AKThe student pilot’s decision to take off toward a hill with a gusting tailwind. Contributing was the pilot's premature rotation that prevented the airplane from climbing over the hill.NTSB WPR11LA290Accident · Minor injuriesLimited investigationFinal reportChristen Industries Pitts S-1T · Alkali Lake, ORThe loss of engine oil during cruise flight due to the failure of the front bearing oil seal.NTSB CEN11CA400Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Charleston, ILThe pilot's selection of unsuitable terrain to take off after making a precautionary landing.NTSB CEN11CA241Accident · Minor injuriesData collectionFinal reportCessna 150M · Garland, TXThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB ANC11CA018Accident · No injuriesData collectionFinal reportCessna A185F · Aniak, AKThe inadvertent contact with a rut in the snow while taxiing, resulting in the collapse of the right main landing gear.NTSB WPR11TA087Accident · No injuriesFinal reportPiper PA-18-180 · Shoshoni, WYA total loss of engine power for undetermined reasons.