NTSB investigations, IA
23 cases where NTSB found Planning/preparation.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 3 |
| 2010 | 4 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2019 | 1 |
| 2022 | 1 |
| 2023 | 3 |
Where
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\", '020610'))
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", '020610')) 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 CEN23LA396Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Neola, IAThe pilot’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN23LA326Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Charles City, IAThe pilot’s improper preflight of the helicopter to ensure that it was within the loading and performance limitations that resulted in settling and impact with terrain during initial climb.NTSB CEN23LA163Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150J · Buffalo, IAA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning. Contributing to the accident were the unreliable fuel quantity gauges and the improperly adjusted mixture control, which increased the fuel consumption…NTSB CEN23LA091Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Pocahantas, IAThe pilot’s landing flare which resulted in a bounced landing and the nose landing gear collapsing. Contributing to the accident was the airplane's encounter with adverse weather conditions which led to structural icing that affected flight characteristics…NTSB GAA19CA173Accident · Minor injuriesData collectionFinal reportPereira Osprey · Independence, IAThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB CEN16LA310Accident · 2 fatalLimited investigationFinal reportPiper PA-11 · Indianola, IAThe pilot's inadequate preflight planning, which resulted in the airplane being operated above its maximum gross weight, degraded its climb performance, and led to an aerodynamic stall during the initial climb.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 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 CEN13LA570Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Algona, IAFuel exhaustion as a result of the pilot's failure to ensure he had sufficient fuel on board to complete the planned flight. Contributing to the accident was the incomplete information provided by the airport's AWOS.NTSB CEN12CA435Accident · No injuriesData collectionFinal reportBell 47G-3B-2 · Treynor, IAThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11CA532Accident · No injuriesData collectionFinal reportAlon A-2A · Rolfe, IAThe pilot's decision to execute a precautionary landing to unsuitable terrain.NTSB CEN11FA507Accident · 1 fatalField investigationFinal reportSikorsky UH-34D · Wilton, IAThe inadequate performance planning by the pilot that resulted in reduced climb capability while transitioning to an out-of-ground effect hover with a left pedal turn.NTSB CEN11LA366Accident · No injuriesLimited investigationFinal reportCessna 150F · Sully, IAThe pilot's failure to attain an adequate climb rate during the initial takeoff, resulting in the airplane settling back down and departing the runway. Contributing to the accident was the pilot's inadequate preflight planning and preparation.NTSB CEN11LA148Accident · No injuriesLimited investigationFinal reportBeech H35 · Des Moines, IAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB CEN10CA323Accident · Serious injuriesData collectionFinal reportMcculley Ronald W-8 · Lamoni, IAThe non-certificated pilot's decision to attempt a takeoff that exceeded the airplane's performance capability, which resulted in an overrun.NTSB CEN10CA178Accident · No injuriesData collectionFinal reportCessna 172N · Ankeny, IAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate in-flight fuel monitoring.NTSB CEN10CA100Accident · Minor injuriesData collectionFinal reportCessna P172D · Cedar Rapids, IAThe pilot's continued visual flight into instrument meteorological conditions and his failure to maintain a proper glidepath during the approach. Contributing to the accident was the pilot's lack of instrument proficiency.NTSB CEN09CA533Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Whittemore, IAThe pilot's lack of preflight planning and remedial action with resulted in the airplane's inability to climb out of ground effect.NTSB 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.NTSB CEN09FA377Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Sanborn, IAA loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel planning and failure to refuel.NTSB CHI08CA290Accident · No injuriesData collectionFinal reportUnknown Supercat · Redding, IAThe pilot's failure to properly manage the fuel supply of the airplane which resulted in fuel exhaustion. Contributing to the accident was the hilly terrain encountered during the subsequent forced landing.NTSB CHI08FA150Accident · 1 fatalField investigationFinal reportSocata TBM 700 (850) · Iowa City, IAThe pilot's improper decision to depart with a preexisting tailwind and failure to abort takeoff. Contributing to the severity of the injuries was the failure to properly restrain (FAA-required) the child passenger.NTSB CHI08LA108Accident · Serious injuriesLimited investigationFinal reportCessna 172L · Fairfax, IAFuel exhaustion as a result of the pilot's inadequate preflight inspection and inaccurate fuel calculations.