NTSB investigations, IA

20 cases where NTSB found Monitoring environment.

Cases per year

20092026
NTSB investigations, IA per year, 2009–2026: 20 cases
20091
20103
20112
20121
20141
20151
20161
20172
20181
20213
20221
20231
20251
20261

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\", '02021545'))
  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 CEN26LA256Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Coralville, IAThe pilot’s failure to maintain clearance from a power line during a low-level aerial application flight.Jul 16, 2026 · N322TC · Substantial damageNTSB CEN25LA285Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Walcott, IAThe pilot’s failure to maintain clearance from the crops during an aerial application flight.Jul 23, 2025 · N802BF · Substantial damageNTSB CEN23LA328Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Hanlontown, IAThe pilot’s failure to maintain clearance from a cable during spray operations.Jul 26, 2023 · N467HA · Substantial damageNTSB CEN22FA347Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT502 · Ute, IAThe pilot’s inflight collision with a power line during aerial application.Jul 30, 2022 · N501MW · DestroyedNTSB CEN21LA350Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Waukon, IAThe pilot’s failure to maintain adequate clearance from a powerline during an agricultural application pass.Aug 4, 2021 · N775AK · Substantial damageNTSB CEN21LA339Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · West Liberty, IAThe pilot’s failure to see and avoid a wire while maneuvering at low altitude during an aerial application flight, resulting in a collision with the wire.Jul 20, 2021 · N983HA · Substantial damageNTSB CEN21LA313Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT802 · Newell, IAThe pilot’s failure to maintain adequate clearance from crops during an agricultural flight.Jul 11, 2021 · N949TM · Substantial damageNTSB GAA18CA453Accident · Minor injuriesData collectionFinal reportRobinson R44 · Elma, IAThe pilot's failure maintain clearance from power lines during an agricultural application flight.Jul 27, 2018 · N466EL · Substantial damageNTSB CEN18LA025Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Larchwood, IAThe pilot's loss of situational awareness, which resulted in his failure to maintain adequate clearance from powerlines.Nov 6, 2017 · N7085M · Substantial damageNTSB CEN17CA346Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Logan, IAThe pilot’s failure to maintain clearance from a wire during an agricultural application flight.Jul 20, 2017 · N192E · Substantial damageNTSB CEN16LA289Accident · Minor injuriesLimited investigationFinal reportBell OH 58A · Lake Mills, IAThe pilot's inadequate visual lookout, which resulted in a wire strike.Jul 22, 2016 · N288NS · Substantial damageNTSB CEN15LA344Accident · 1 fatalLimited investigationFinal reportErickson Larry D RAF 2000 GT · Humboldt, IAThe pilot’s loss of gyroplane control while maneuvering at low altitude.Aug 9, 2015 · N315LK · Substantial damageNTSB CEN14LA487Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 II · Macedonia, IAThe pilot’s inadequate visual lookout, which resulted in a collision with a static line.Sep 6, 2014 · N699TQ · Substantial damageNTSB CEN12LA443Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Red Oak, IAThe pilot's failure to maintain clearance from the ground-support vehicle during landing.Jul 14, 2012 · N556MM · Substantial damageNTSB CEN11CA565Accident · No injuriesData collectionFinal reportWeatherly 201C · Bronson, IAThe pilot's failure to maintain clearance from terrain while maneuvering during an aerial application flight.Aug 10, 2011 · N9054W · Substantial damageNTSB CEN11CA535Accident · No injuriesData collectionFinal reportTexas Helicopter OH-13H/M74A · Joice, IAThe pilot's failure to maintain clearance from the wire.Aug 1, 2011 · N51857 · Substantial damageNTSB CEN10CA446Accident · Minor injuriesData collectionFinal reportBell 206 · St. Olaf, IAThe pilot's failure to maintain clearance from wires during the agricultural flight.Jul 28, 2010 · N275RA · Substantial damageNTSB CEN10CA445Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502B · Zwingle, IAThe pilot's failure to maintain clearance from wires during the agricultural flight.Jul 28, 2010 · N6030U · Substantial damageNTSB CEN10CA428Accident · No injuriesData collectionFinal reportBell 206B · New Hampton, IAThe pilot's failure to maintain clearance from wires.Jul 23, 2010 · N40TA · Substantial damageNTSB CEN09CA483Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Royal, IAThe pilot's failure to maintain clearance from the crop during an aerial application maneuver.Aug 3, 2009 · N6701Z · Substantial damage