NTSB investigations, IA
4 cases where NTSB found Lateral/bank control.
Cases per year
| 2019 | 1 |
|---|---|
| 2021 | 1 |
| 2024 | 1 |
| 2025 | 1 |
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\" = 'IA' 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\", '01062023'))
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" = 'IA' 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", '01062023')) 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 CEN25LA172Accident · No injuriesClass 4 · LimitedFinal reportGolden Circle Air T-Bird · Dallas Center, IAThe pilot’s failure to maintain adequate roll control of the light sport airplane while on final approach to the airstrip with a crosswind.NTSB CEN24LA355Accident · Minor injuriesClass 4 · LimitedFinal reportJust SuperStol · Mount Vernon, IAThe pilot’s failure to maintain airplane control during a go-around which resulted in an aerodynamic stall and collision with terrain.NTSB CEN21FA299Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Lamoni, IAThe pilot did not maintain aircraft control during an attempted go-around after a bounced landing, which resulted in impact with terrain and a postimpact fire.NTSB GAA19CA428Accident · Minor injuriesData collectionFinal reportRobinson R44 · Council Bluff, IAThe pilot's improper cyclic input during liftoff from a landing deck, which resulted in the right skid hooking onto an opening on the landing deck and a subsequent dynamic rollover.