NTSB investigations, IA
15 cases where NTSB found Incorrect action performance.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 5 |
| 2013 | 1 |
| 2014 | 1 |
| 2021 | 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\", '02041015'))
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", '02041015')) 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 CEN26LA113Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P-MENTOR · Des Moines, IAThe solo student pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in a loss of directional control and a runway excursion.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 CEN15FA008Accident · 1 fatalField investigationFinal reportPiper PA46 · Dubuque, IAThe pilot's loss of airplane control while attempting to fly a missed approach procedure in instrument meteorological conditions.NTSB CEN13LA463Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Vinton, IAThe pilot's operation of the helicopter at high gross weight and high density altitude while still in ground effect, which reduced the efficiency of the rotor system and the amount of lift produced, which resulted in a collision with terrain. Contributing to…NTSB CEN13CA087Accident · No injuriesData collectionFinal reportCessna 150F · Red Oak, IAThe loss of control while landing due to the solo student pilot's delay to execute a go-around and his improper control inputs during a bounced landing.NTSB CEN12LA441Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Elkader, IAThe pilot's failure to attain the proper touchdown point while landing on the wet grass runway.NTSB CEN12LA247Accident · No injuriesLimited investigationFinal reportHughes 269A · Grinnell, IAThe pilot's improper liftoff technique, which resulted in ground resonance, and the pilot's delayed recognition of the ground resonance.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 CEN11CA535Accident · No injuriesData collectionFinal reportTexas Helicopter OH-13H/M74A · Joice, IAThe pilot's failure to maintain clearance from the wire.NTSB CEN11LA367Accident · Minor injuriesLimited investigationFinal reportJones Cozy Mark IV · Sioux City, IAThe pilot's improper installation of the gascolator gasket during the airplane's last condition inspection, which resulted in a partial loss of engine power while maneuvering.NTSB CEN11LA168Accident · No injuriesLimited investigationFinal reportErtz Mark G Zodiac 601XL · Burlington, IAThe Model 1 pilot's inadequate visual lookout and subsequent failure to see and avoid the Zodiac.NTSB CEN10CA434Accident · No injuriesData collectionFinal reportAir Tractor 502B · Whittemore, IAThe pilot's failure to abort the takeoff, which resulted in an aerodynamic stall.NTSB CEN10CA428Accident · No injuriesData collectionFinal reportBell 206B · New Hampton, IAThe pilot's failure to maintain clearance from wires.NTSB CHI08LA108Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Fairfax, IAFuel exhaustion as a result of the pilot's inadequate preflight inspection and inaccurate fuel calculations.