OpenAirDocs.org

NTSB investigations, 2017, IA

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19622026

Where

Open the map

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 year(c.\"eventDate\") = 2017
    AND c.\"eventStateOrRegion\" = 'IA' AND c.\"eventCountry\" = 'USA'
  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 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.Dec 23, 2017 · N20XA · Substantial damageNTSB CEN18LA051Accident · No injuriesLimited investigationFinal reportCessna 172C · Algona, IAThe No. 1 cylinder head separating at the cylinder head-to-barrel interface and the subsequent total loss of engine power.Dec 9, 2017 · N8856B · Substantial damageNTSB 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.Nov 6, 2017 · N7085M · Substantial damageNTSB DCA17CA217Accident · Serious injuriesData collectionFinal reportBoeing 737-8H4 · Sioux City, IAthe flight attendant accidentally pouring hot water on his hand which resulted in a 2nd degree burn.Sep 25, 2017 · N500WR · No damageNTSB GAA17CA436Accident · No injuriesData collectionFinal reportBell 47G 3B · Toterville, IAThe pilot’s failure to maintain rotor rpm while maneuvering at low altitude with low airspeed and a tailwind.Jul 24, 2017 · N47AH · Substantial damageNTSB 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.Jul 22, 2017 · N83K · Substantial damageNTSB CEN17CA346Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Logan, IAThe pilot’s failure to maintain clearance from a wire during an agricultural application flight.Jul 20, 2017 · N192E · Substantial damageNTSB GAA17CA422Accident · No injuriesData collectionFinal reportPiper PA32 · Marion, IAThe pilot’s failure to maintain directional control during the landing roll.Jul 15, 2017 · N31841 · Substantial damageNTSB 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.Jul 9, 2017 · N929DE · Substantial damageNTSB 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.Jul 3, 2017 · N711NN · Substantial damageNTSB 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…Jul 1, 2017 · N62JN · Substantial damageNTSB GAA17CA338Accident · No injuriesData collectionFinal reportPiper PA 28 · Estherville, IAThe student pilot's failure to maintain crosswind correction during a go-around in gusting wind conditions.Jun 14, 2017 · N33764 · Substantial damageNTSB 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.Jun 3, 2017 · N34462 · Substantial damageNTSB 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.Apr 17, 2017 · N822DC · Substantial damageNTSB CEN17LA156Accident · No injuriesLimited investigationFinal reportLoomis Xenon 4 · Knoxville, IAA partial loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the failure of the owners to obtain proper materials regarding the operation and maintenance of the engine.Apr 17, 2017 · N912XV · Substantial damageNTSB CEN17FA147Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Oxford, IAThe failure of the pilot receiving instruction to recover from the practice stall before the airplane entered a spin and the flight instructor's inadequate monitoring of the pilot receiving instruction and delayed remedial action to recover the airplane.Apr 7, 2017 · N9179J · Destroyed