NTSB investigations, IA

7 cases where NTSB found Rough terrain.

Cases per year

20082026
NTSB investigations, IA per year, 2008–2026: 7 cases
20082
20092
20151
20161
20211

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\", '03021015'))
  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 CEN21FA207Accident · 1 fatalClass 3 · FieldFinal reportCessna T210M · Oxford, IAThe pilot’s loss of directional control during landing in gusting crosswind conditions that exceeded the airplane’s capability and his decision to attempt to takeoff from a field, which resulted in collision with a power pole/line and terrain.May 2, 2021 · N1215M · DestroyedNTSB GAA16CA393Accident · No injuriesData collectionFinal reportCessna 188 · What Cheer, IAThe loss of engine power for undetermined reasons due to the pilot not making the airplane or engine available for examination, which resulted in a forced landing and an impact with terrain.Jul 25, 2016 · N9979G · Substantial damageNTSB GAA15CA137Accident · No injuriesData collectionFinal reportPiper PA 24 · Charles City, IAThe pilot's inadequate pre-flight fuel planning resulting in fuel exhaustion and a collision with terrain.Jun 25, 2015 · N5152P · Substantial damageNTSB CEN09CA516Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Harlan, IAThe pilot's failure to perform accurate weight and balance calculations which resulted in exceeding the maximum takeoff weight and the airplane's climb capability.Aug 10, 2009 · N4598 · Substantial damageNTSB CEN09CA455Accident · No injuriesData collectionFinal reportForster SA-300 · Iowa City, IAthe loss of engine power for undetermined reasons.Jul 22, 2009 · N7BT · Substantial damageNTSB CEN09CA121Accident · No injuriesData collectionFinal reportCessna 150M · Greene, IAA loss of engine power due to undetermined reasons. Contributing to the accident was the rough, snow-covered terrain.Dec 31, 2008 · N899CB · Substantial damageNTSB CHI08CA242Accident · No injuriesData collectionFinal reportSchweizer G-164A · Jefferson, IAThe loss of engine power for an undetermined reason and the unsuitable terrain encountered during the forced landing. The corn crop was a factor.Aug 8, 2008 · N73PB · Substantial damage