NTSB investigations, ID
8 cases where NTSB found Sloped/uneven terrain.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2019 | 1 |
| 2021 | 3 |
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 c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA' 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 WPR22LA036Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Mackay, IDThe pilot’s failure to maintain directional control during the landing roll, which resulted in the airplane veering into a ditch and nosing over.NTSB WPR21LA293Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F-28A · Mountain Home, IDThe pilot's improper fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent hard landing on uneven terrain.NTSB WPR21LA229Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4 · Cascade, IDThe pilot’s failure to maintain clearance from a ditch, which resulted in impact with terrain.NTSB GAA19CA365Accident · No injuriesData collectionFinal reportCessna 182 · Burley, IDThe pilot's improper landing flare during landing in a gusting, right quartering tailwind, which resulted in the airplane wheel barrowing and a subsequent runway overrun, impact with terrain, and noseover.NTSB WPR14CA221Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · McCall, IDLoss of directional control during landing rollout due to a wind disturbance, which resulted in a runway veeroff and impact with a ditch.NTSB WPR12LA410Accident · 1 fatalLimited investigationFinal reportSchoepflin DA-4-550 · Viola, IDThe pilot's failure to maintain airplane control while maneuvering, resulting in an aerodynamic stall/spin with insufficient altitude to recover.NTSB WPR10CA049Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Lewiston, IDThe pilot's delayed decision to execute a go-around in gusting winds and with up-sloping terrain.NTSB LAX08LA217Accident · No injuriesLimited investigationFinal reportLancair LC41-550FG · Hailey, IDThe loss of directional control while taxiing due to the failure of the right brake.