NTSB investigations, IA

6 cases where NTSB found Incorrect action selection.

Cases per year

20112026
NTSB investigations, IA per year, 2011–2026: 6 cases
20111
20131
20151
20211
20231
20251

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\", '02041010'))
  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.

NTSB CEN25LA351Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Nora Springs, IAThe pilot’s improper decision-making for the attempted landing, which resulted in a runway overrun due to inadequate runway landing distance with a quartering tailwind. Contributing to the accident was the wet condition of the runway.Aug 28, 2025 · N45JN · Substantial damageNTSB CEN23LA192Accident · No injuriesClass 4 · LimitedFinal reportNorth American-Buehn T-6G · Ankeny, IAThe pilot’s inadvertent retraction of the landing gear control lever, resulting in a gear-up landing on the runway.May 20, 2023 · N42JM · Substantial damageNTSB CEN21LA393Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401B · Storm Lake, IAThe pilot’s failure to maintain adequate airspeed during a landing approach with a tailwind that resulted in a landing overrun and impact with terrain.Sep 1, 2021 · N5081W · Substantial damageNTSB CEN15CA203Accident · No injuriesData collectionFinal reportCessna 195A · Independence, IAThe pilot's attempt to land in strong crosswind conditions, resulting in his on-ground loss of control. Contributing to the accident was the crosswind that exceeded the crosswind limits of the airplane.Apr 18, 2015 · N1558D · Substantial damageNTSB CEN13CA289Accident · No injuriesData collectionFinal reportCessna 172S · Ankeny, IAThe student pilot's improper flare which resulted in a hard landing.May 14, 2013 · N947SP · Substantial damageNTSB CEN11IA270Incident · No injuriesIncident investigationFinal reportEmbraer EMB-135KL · Dubuque, IAThe airport authorities' improper decision to deactivate the jet bridge braking system which created an unsafe condition by the gate agents not being able to stop the bridge from impacting the airplane during a wind gust.Apr 3, 2011 · N377SK · Minor damage