OpenAirDocs.org

NTSB investigations, 2005, 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\") = 2005
    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 CHI06CA049Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Spirit Lake, IAThe pilot using an unsuitable runway and not maintaining directional control during the landing leading to the nose over on impact with snow. A factor was the snow that remained on the runway after plowing.Dec 21, 2005 · N4680Z · Substantial damageNTSB CHI06CA046Accident · Minor injuriesData collectionFinal reportCessna 150M · Algona, IAThe pilot's inadvertent flight into unexpected instrument conditions and his visual look out not possible during takeoff leading to the nose over during the emergency landing after takeoff. Factors were the unexpected fog and the dark night conditions.Dec 21, 2005 · N9292U · Substantial damageNTSB CHI06FA026Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Ankeny, IAThe pilot's failure to preflight the airplane, the pilot's improper in-flight decision not to land the airplane on the runway when he had the opportunity, and the inadvertent stall when the pilot allowed the airspeed to get too low. Factors that contributed…Nov 8, 2005 · N27177 · DestroyedNTSB CHI06CA008Accident · Minor injuriesData collectionFinal reportCessna 310R · Ottumwa, IAThe pilot misjudged his altitude and airspeed while landing which resulted in the airplane stalling 20 feet above the runway. A factor associated with the accident was the pilot's execution of the approach when reported weather conditions were below the…Oct 13, 2005 · N310SK · Substantial damageNTSB CHI05CA224Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Mount Ayr, IAThe pilot's selection of a wrong runway, and the misjudged distance/speed which resulted in an overrun. Contributing factors were the tailwind, and the ditch.Sep 21, 2005 · N6266W · Substantial damageNTSB CHI05LA229Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Marshalltown, IAThe loss of engine power for undetermined reasons during initial climb and the unsuitable landing area encountered by the pilot during a forced landing.Aug 12, 2005 · N9632 · Substantial damageNTSB CHI05LA214Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Marshalltown, IAThe loss of engine power for an undetermined reason. A factor was the corn crop.Aug 7, 2005 · N636U · Substantial damageNTSB CHI05LA213Accident · Serious injuriesLimited investigationFinal reportWeatherly 620-B · Osage, IAThe partial loss of engine power for an undetermined reason. Contributing factors were the wires and the trees.Aug 6, 2005 · N6305W · DestroyedNTSB CHI05CA209Accident · No injuriesData collectionFinal reportNational Ballooning 751-12 · Indianola, IAThe in-flight fire due to the loose fuel line connection as a result of the pilot's inadequate preflight. A factor was the power lines.Aug 2, 2005 · N3219T · Substantial damageNTSB CHI05LA113Accident · No injuriesLimited investigationFinal reportMattson Zenith 601XL · Dike, IAA loss of engine power for undetermined reasons and the pilot misjudged the forced landing approach. Factors associated with the accident were the fence and the ditch which the airplane contacted.May 10, 2005 · N824M · Substantial damageNTSB CHI05LA083Accident · 1 fatalLimited investigationFinal reportMooney M20E · Bloomfield, IAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin. The low altitude was a factor.Mar 28, 2005 · N6092Q · DestroyedNTSB CHI05LA082Accident · 2 fatalLimited investigationFinal reportMatthews Christen Eagle II · Iowa City, IAThe pilot not maintaining airplane control and airspeed, and the stall/spin encountered during aerobatic maneuvering. A factor in the accident was the pilot exceeding the published airplane's aft center of gravity limit and a factor in the pilot rated…Mar 27, 2005 · N85SM · DestroyedNTSB CHI05FA080Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · West Union, IAThe pilot's failure to abort the takeoff, his failure to maintain adequate airspeed during the takeoff, and the pull-up to avoid obstacles which resulted in an inadvertent stall. Factors associated with the accident were the pilot's failure to maintain…Mar 27, 2005 · N8966W · Destroyed