Fatal NTSB investigations, IA

13 cases where the first occurrence was “In flight encounter with weather”.

Cases per year

19822026
Fatal NTSB investigations, IA per year, 1982–2026: 13 cases
19822
19832
19841
19851
19871
19881
19981
20001
20032
20071

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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 240)
  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 CHI07FA073Accident · 4 fatalField investigationFinal reportCessna 340A · Council Bluffs, IAThe pilot's continued flight into adverse weather, and his failure to maintain altitude during the instrument approach. Contributing factors were the presence of severe icing, moderate turbulence, and low-level wind shear.Feb 17, 2007 · N111SC · DestroyedNTSB CHI04FA044Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Brooklyn, IAThe pilot's inadequate planning/decision resulting in VFR flight into IMC, and his failure to maintain terrain clearance resulting in in-flight collision with terrain. Contributing factors to the accident were the pilot's lack of an instrument rating, his…Dec 18, 2003 · N3733W · Substantial damageNTSB CHI03FA094Accident · 3 fatalField investigationFinal reportBeech A36 · New Vienna, IAThe improper planning/decision by the pilot to fly into forecast icing conditions with an airplane not equipped with a certified deice system. The continued flight in known icing conditions and the flight to an alternate destination not performed by the pilot…Mar 28, 2003 · N1636W · DestroyedNTSB CHI00FA171Accident · 1 fatalField investigationFinal reportCessna 210J · Sumner, IAfailure of the pilot to maintain clearance with the terrain after flight into adverse weather. Contributing factors were the thunderstorms and lack of instrument certification by the pilot.Jun 25, 2000 · N3396S · DestroyedNTSB CHI98FA309Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · New Hampton, IAThe pilot's inadequate preflight/planning inspection and his continued flight into known adverse weather conditions that led to spatial disorientation and loss of aircraft control. Also causal was the pilot exceeded the design limits of the airplane causing…Aug 10, 1998 · N9350N · DestroyedNTSB MKC88FA176Accident · 1 fatalField investigationFinal reportBeech C23 · Belle Plaines, IAThe non-instrument rated pilot received a full weather briefing prior to departure during which he was advised that VFR flight was not recommended. In addition he was advised that, while conditions were forecast to improve, the possibility for scattered…Sep 22, 1988 · N6022C · DestroyedNTSB MKC87FA106Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Sioux City, IAThe PIC had telephoned the fss at huron, s.d. for enr wx to Sioux City, IA, fm Sioux falls, s.d., late the evening of may 20. The fcst indicated IFR flt cond's with intermittent trsms along the rte throughout the fcst period. The PIC dptd Sioux falls, s.d. at…May 21, 1987 · N4982J · DestroyedNTSB MKC85FA066Accident · 3 fatalField investigationFinal reportPiper PA-23 · Cedar Rapids, IAPlt reported no forward vis due to ice on windshield. N1291P then diverted to cid which has rapcon. The temp at the surface was 32 degs f but was reported to be higher at 4,000 ft MSL. The flt climbed to 4,000 ft and began losing the ice but then reported…Mar 3, 1985 · N1241P · DestroyedNTSB MKC84FA131Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Sheldon, IAAt about 1015 CDT, while en route, the plt radioed a fss & requested the Kansas city wx. VMC conditions were reported at Kansas city, but the plt was informed of an AIRMET, which provide a caution of low ceilings & reduce visibilities across his route of flt.…May 4, 1984 · N3761R · DestroyedNTSB MKC83FA127Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Newton, IAThe non-instrument rated plt took off on a x-country flt at night. When advised of wx along his route, he requested & recieved radar advisories. A short time later, he reported that he was in a storm. For about 10 minutes, the radar controller was…Jun 12, 1983 · N5509V · DestroyedNTSB MKC83FA065Accident · 2 fatalField investigationFinal reportCessna TR182 · Garwin, IADuring a briefing for a flt to western Oklahoma, the plt was advised that IMC wx was forcasted along the route. He changed his destination to waterloo, IA & was advised of IMC in that area also. While en route, the acft crashed in a field covered with snow.…Feb 9, 1983 · N6144T · DestroyedNTSB MKC82FCD10Accident · 2 fatalFinal reportPiper 28-236 · Liscomb, IAN2157A departed on a VFR flight to marshalltown, IA. There is no record of a pilot weather briefing prior to departure. The reported weather at waterloo airport at the approximate time of the accident was: measured ceiling 600 foot overcast, visibility one…Sep 7, 1982 · N2157A · Substantial damageNTSB MKC82FA161Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Mediapolis, IADuring the 1725 CDT wx briefing the plt was informed that the Kansas city area would be 1600 ft broken, occassional 800 ft broken, 3/4 mi visibility with thunderstorms & moderate rain with strong surface winds about 35K. The forecast was valid to 2200 CDT.…Aug 30, 1982 · N56373 · Destroyed