NTSB investigations, IA

6 cases where NTSB found Inspection.

Cases per year

20082026
NTSB investigations, IA per year, 2008–2026: 6 cases
20081
20111
20141
20191
20201
20211

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\", '020615'))
  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 CEN21LA419Accident · Minor injuriesClass 4 · LimitedFinal reportThatcher CX4 · Marshalltown, IAThe pilot’s failure to properly determine the correct fuel quantity during preflight inspection that resulted in a loss of engine power during approach due to fuel exhaustion.Sep 9, 2021 · N306TA · Substantial damageNTSB CEN20CA253Accident · Minor injuriesClass 4 · Data collectionFinal reportBeech 23 · Davenport, IAThe pilot's failure to properly configure the airplane for takeoff, which resulted in the exceedance of the airplane's critical angle of attack, an aerodynamic stall, and subsequent impact with terrain.Jun 27, 2020 · N18873 · Substantial damageNTSB CEN20LA014Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Swea City, IAThe pilot's failure to replace the oil filler cap during his preflight inspection, which resulted in oil starvation and a subsequent total loss of engine power.Oct 25, 2019 · N1443E · Substantial damageNTSB CEN14LA472Accident · No injuriesLimited investigationFinal reportOhlgren Brent E RV-6A · Marshalltown, IAA loss of engine power due to fuel exhaustion as a result of the pilot's misjudgment of the amount of fuel onboard prior to flight.Sep 1, 2014 · N419B · Substantial damageNTSB CEN11LA402Accident · Serious injuriesLimited investigationFinal reportCessna P210R · Albia, IAThe pilot's inadequate preflight inspection, in which he did not detect that less fuel was on board the airplane than planned, which precipitated a loss of engine power due to fuel exhaustion during initial descent.Jun 18, 2011 · N900SR · Substantial damageNTSB CHI08CA251Accident · Minor injuriesData collectionFinal reportAir Tractor AT-301B · Monticello, IAPoor preflight planning in that the pilot failed to assure an adequate fuel supply was on board for the flight which resulted in fuel exhaustion. Factors associated with the accident were the low altitude of the airplane when the loss of power occurred and…Aug 13, 2008 · N3161D · Substantial damage