NTSB investigations, IA
77 cases where NTSB found Physical environment.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 5 |
| 2010 | 6 |
| 2011 | 2 |
| 2012 | 4 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 7 |
| 2017 | 9 |
| 2018 | 4 |
| 2019 | 3 |
| 2020 | 5 |
| 2021 | 4 |
| 2022 | 6 |
| 2023 | 4 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 1 |
Where
Open the mapLatest 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\", '0302'))
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", '0302')) 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 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.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.NTSB CEN25LA066Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Monticello, IAThe on-ground collision with a deer on the runway during the landing roll.NTSB CEN24LA054Accident · No injuriesClass 4 · LimitedFinal reportCessna 560XL · Council Bluffs, IAAn in-flight collision with a bird during decent.NTSB CEN23LA428Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-31A · Maurice, IAThe pilot’s failure to maintain directional control during the landing.NTSB CEN23LA342Accident · 1 fatalClass 4 · LimitedFinal reportBell 206B · Denison, IAThe pilot’s inflight distraction, which resulted in his failure to see and avoid wires.NTSB CEN23LA328Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Hanlontown, IAThe pilot’s failure to maintain clearance from a cable during spray operations.NTSB CEN23FA059Accident · 1 fatalClass 3 · FieldFinal reportEngineering & Research Ercoupe 415-C · Corning, IAThe pilot’s failure to maintain clearance from obstructions during a go-around, which resulted in impact with powerlines, a tree, and the ground.NTSB DCA23LA067Accident · No injuriesClass 4 · LimitedFinal reportAirbus A320 · Red Oak, IAMultiple bird strikes during descent.NTSB CEN22LA366Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Maynard, IAAn impact with a powerline as a result of an unexpected wind gust.NTSB CEN22LA356Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 150A · Indianola, IAThe pilot’s failure to maintain clearance from power lines during low-level maneuvering.NTSB CEN22FA347Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT502 · Ute, IAThe pilot’s inflight collision with a power line during aerial application.NTSB CEN22LA371Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-T65 · Wyman / Washington, IAThe pilot not maintaining sufficient altitude to clear an obstruction during the aerial application flight.NTSB CEN22LA084Accident · No injuriesClass 4 · LimitedFinal reportTextron 525 · Dubuque, IAAn inflight collision with a flock of geese that resulted in substantial damage to the vertical stabilizer.NTSB 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.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.NTSB CEN21LA118Accident · No injuriesClass 4 · LimitedFinal reportBeech 300 · Davenport, IAThe pilot’s failure to maintain directional control of the airplane, and the flight instructor’s inadequate oversight during a simulated engine out takeoff that resulted in a runway excursion and impact with a snowbank.NTSB CEN20CA155Accident · No injuriesData collectionFinal reportVans RV 3 · Independence, IAThe pilot's failure to maintain directional control during a high-speed taxi with a quartering tailwind, which resulted in a runway excursion and impact with a fence and terrain.NTSB CEN20LA145Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Sidney, IAA loss of engine power for reasons that could not be determined.NTSB CEN20LA136Accident · 2 fatalClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Audubon, IAThe pilot’s failure to recognize and avoid the power line during the low-altitude flight. Contributing to the accident was the pilot’s fatigue, which affected the pilot’s ability to see and avoid the power line.NTSB CEN20CA120Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Ankeny, IAThe pilot's improper starting procedure, which allowed the airplane to move forward over the wheel chocks and impact him and a hangar when he subsequently hand propped the engine.NTSB CEN20CA064Accident · Serious injuriesData collectionFinal reportGuimbal Cabri G2 · Independence, IAThe student pilot's failure to maintain helicopter control while maneuvering to land, which resulted in impact with an airplane and a hangar.NTSB GAA19CA363Accident · No injuriesData collectionFinal reportCessna 150 · Elkader, IAThe pilot's delayed decision to go around, which resulted in a collision with trees and terrain.NTSB GAA19CA193Accident · No injuriesData collectionFinal reportCessna 172 · Pella, IAThe student pilot's failure to maintain the runway heading and the flight instructor's delayed remedial action during landing, which resulted in the instructor landing the airplane in grass left of the runway and a subsequent nose-over.NTSB GAA19CA172Accident · No injuriesData collectionFinal reportCessna 172 · Oskaloosa, IAThe student pilot's failure to maintain directional control during landing with a left quartering tailwind, which resulted in a runway excursion, impact with a snowbank, and a nose-over.NTSB GAA19CA001Accident · No injuriesData collectionFinal reportCessna 340 · Keokuk, IAThe pilot's failure to correctly identify the runway environment during an instrument approach at night in instrument meteorological conditions because he mistook building lights for runway lights, which resulted in landing short of the runway.NTSB GAA18CA545Accident · Minor injuriesData collectionFinal reportCirrus SR22 · Mason City, IAThe pilot’s improper hand propping procedure, which resulted in a runaway airplane and subsequent impact with a hangar.NTSB GAA18CA453Accident · Minor injuriesData collectionFinal reportRobinson R44 · Elma, IAThe pilot's failure maintain clearance from power lines during an agricultural application flight.NTSB CEN18CA185Accident · No injuriesData collectionFinal reportCessna 120 · Harlan, IAThe pilot’s late go-around during a bounced landing, which led to an aerodynamic stall and impact with terrain.NTSB CEN18FA060Accident · 1 fatalField investigationFinal reportX-Air XA85 · Oskaloosa, IAThe pilot's low altitude flight into a power line due to his impairment from an acute physiologic event during the flight. Contributing to the pilot's impairment was his use of two sedating medications.NTSB 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.NTSB GAA17CA433Accident · No injuriesData collectionFinal reportStinson SR9 · Bode, IAThe pilot’s decision to take off from an unimproved bean field with insufficient length for the airplane to clear adjacent corn stalks.NTSB CEN17CA346Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Logan, IAThe pilot’s failure to maintain clearance from a wire during an agricultural application flight.NTSB CEN17LA263Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Corydon, IAA total loss of engine power for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.NTSB GAA17CA578Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC41 · Eagle Grove, IAThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB CEN17FA249Accident · 1 fatalField investigationFinal reportFlight Design Ctsw · Monticello, IAThe pilot's decision to fly with his large dog in the two-seat, light sport airplane, and the dog's likely contact with the flight controls during landing, which resulted in the pilot's loss of airplane control and a subsequent aerodynamic stall when the…NTSB GAA17CA317Accident · No injuriesData collectionFinal reportCessna 177 · Guttenberg, IAThe pilot’s failure to maintain an adequate approach path, which resulted in the left wing impacting a street sign.NTSB GAA17CA238Accident · No injuriesData collectionFinal reportCheung David S Vans RV6 · Indianola, IAThe pilot’s failure to maintain an adequate approach path, which resulted in a long landing and subsequent runway overrun.NTSB CEN16LA320Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · Des Moines, IAThe two separations in the induction system due to improper installation and/or maintenance, which resulted in a partial loss of engine power during initial climb.NTSB CEN16LA316Accident · No injuriesLimited investigationFinal reportSchabacker Konrad J Acro Sport II · Winterset, IAThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in an on-ground collision with two parked airplanes.NTSB CEN16LA292Accident · 1 fatalLimited investigationFinal reportAir Tractor AT 402 · Sac City, IAThe pilot's failure to maintain adequate clearance from power lines. Contributing to the accident was the pilot's failure to circle over the field to identify hazards before beginning the aerial application.NTSB 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.NTSB CEN16LA289Accident · Minor injuriesLimited investigationFinal reportBell OH 58A · Lake Mills, IAThe pilot's inadequate visual lookout, which resulted in a wire strike.NTSB GAA16CA154Accident · No injuriesData collectionFinal reportNicholson David F RV 9 · Allison, IAThe pilot's improper soft-field landing technique, which resulted in a nose landing gear collapse and a nose over.NTSB GAA16CA093Accident · No injuriesData collectionFinal reportCessna 172 · Newton, IAThe pilot's failure to maintain airplane control during the takeoff, resulting in a runway excursion, and airplane nose over.NTSB CEN16LA032Accident · No injuriesLimited investigationFinal reportCessna 177RG · Red Oak, IAThe improper torque of the engine’s No. 3 cylinder intake pipe bolts, which resulted in the separation of the pipe and a partial loss of engine power.NTSB CEN15LA344Accident · 1 fatalLimited investigationFinal reportErickson Larry D RAF 2000 GT · Humboldt, IAThe pilot’s loss of gyroplane control while maneuvering at low altitude.NTSB 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.NTSB CEN14LA487Accident · 1 fatalLimited investigationFinal reportRobinson Helicopter R44 II · Macedonia, IAThe pilot’s inadequate visual lookout, which resulted in a collision with a static line.NTSB CEN13CA337Accident · No injuriesData collectionFinal reportStiegelmeyer John R Vans RV-7A · Vinton, IAThe inadvertent collision with a deer during landing.