NTSB investigations, IA
30 cases where NTSB found Directional control.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 2 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 2 |
| 2016 | 3 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 3 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 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\", '01062020'))
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", '01062020')) 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 CEN26LA154Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F-28F · Oelwein, IAThe pilot's failure to maintain directional control during the hover taxi with a quartering tailwind.NTSB CEN24LA154Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Tiger Moth DH 82A · Council Bluffs, IAThe pilot's failure to maintain directional control during the takeoff with a direct gusting crosswind.NTSB CEN23LA428Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-31A · Maurice, IAThe pilot’s failure to maintain directional control during the landing.NTSB CEN23LA251Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Osceola, IAThe pilot’s failure to maintain directional control of the tailwheel equipped airplane during a crosswind landing.NTSB CEN22LA396Accident · Minor injuriesClass 4 · LimitedFinal reportJavron Experimental PA18 Replica · Osceola, IAThe stuck right brake at landing which resulted in a loss of control.NTSB CEN21LA433Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Council Bluffs, IAThe student pilot’s failure to maintain directional control during a touch and go landing.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 CEN19LA322Accident · No injuriesClass 3 · LimitedFinal reportCessna 195A · Pocahontas, IAOverload failure of the left main landing gear during landing, which resulted in a loss of directional control.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 WPR19FA022Accident · 4 fatalClass 2 · FieldFinal reportPiper PA28 · Guthrie Center, IAPilot incapacitation due to carbon monoxide poisoning as a result of an undetected crack in an engine exhaust muffler, which permitted entry of exhaust gasses into the cabin via the cabin heat system.NTSB GAA18CA317Accident · No injuriesData collectionFinal reportAeronca 7AC · Vinton, IAThe pilot’s failure to maintain directional control while landing in gusting tailwind conditions.NTSB GAA18CA156Accident · No injuriesData collectionFinal reportStinson 108 · Cedar Rapids, IAThe pilot’s improper landing flare, which resulted in a loss of directional control and a nose-over.NTSB GAA17CA422Accident · No injuriesData collectionFinal reportPiper PA32 · Marion, IAThe pilot’s failure to maintain directional control during the landing roll.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 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 GAA16CA257Accident · No injuriesData collectionFinal reportAeronca 11AC · Vinton, IAThe pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and ground loop.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 CEN14LA493Accident · No injuriesLimited investigationFinal reportDavis Benny Christen Eagle II · Vinton, IAThe pilot's loss of directional control during landing after the airplane encountered uneven pavement at the intersection with a crossing runway.NTSB CEN14LA138Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Marion, IAThe pilot’s failure to attain a touchdown on the runway’s hard surface, which resulted in a loss of directional control.NTSB CEN13CA529Accident · No injuriesData collectionFinal reportCessna 172R · Council Bluff, IAThe student pilot's loss of directional control during takeoff.NTSB CEN13CA290Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Pella, IAThe pilot's failure to maintain directional control during landing.NTSB CEN12CA503Accident · No injuriesData collectionFinal reportPiper PA-16 · Keokuk, IAThe pilot’s loss of directional control during the landing roll in a variable crosswind, which resulted in a runway excursion.NTSB CEN12LA209Accident · 1 fatalLimited investigationFinal reportWalling Vans RV-3 · Larchwood, IAThe pilot's failure to maintain directional control of the airplane after landing.NTSB CEN12CA213Accident · No injuriesData collectionFinal reportCessna 172R · Council Bluffs, IAThe student pilot’s improper flare and inadequate recovery from a bounced landing, which resulted in a loss of directional control.NTSB CEN11CA065Accident · No injuriesData collectionFinal reportWelch Thomas RV9 · Sac City, IAThe pilot's loss of directional control while landing with a gusting wind.NTSB CEN10CA349Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Webster, IAThe pilot misjudged his speed and distance during landing, which resulted in an overrun.NTSB CEN10CA077Accident · No injuriesData collectionFinal reportCessna 172P · Ames, IAThe pilot's failure to maintain directional control while attempting a takeoff on an ice-covered runway.NTSB CHI08CA074Accident · No injuriesData collectionFinal reportSwearingen SA-226AT · Ankeny, IAThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the snow on the runway and the snowbank.