NTSB investigations, 1990, WI

5 cases where the first occurrence was “In flight collision with terrain/water”.

Cases per year

19822026
NTSB investigations, 1990, WI per year, 1982–2026: 54 cases
19823
19837
19841
19853
19863
19871
19883
19892
19905
19911
19931
19951
19961
19983
20002
20011
20022
20033
20043
20055
20061
20072

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\") = 1990
    AND c.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
    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\" = 230)
  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 CHI90MA244Accident · 5 fatalMajor investigationFinal reportBell 206B · Elkhorn, WIImproper planning/decision by the pilot, and his failure to attain adequate altitude before flying over rising terrain at night. Factors related to the accident were: darkness, fog, haze, rising terrain, and the lack of visual cues that were available to the…Aug 27, 1990 · N16933 · DestroyedNTSB CHI90FA236Accident · 7 fatalField investigationFinal reportPiper PA-32R-300 · Watertown, WIInitiation of VFR flight into adverse weather and instrument meteorologial conditions. Factors which contributed to the accident were the adverse weather conditions and the pilot's self-induced pressure to maintain currency.Aug 19, 1990 · N4070Q · DestroyedNTSB CHI90FAMS3Accident · 2 fatalMissing aircraftFinal reportCessna 172M · Kewaunee, WIUndetermined.Aug 14, 1990 · N9529H · DestroyedNTSB CHI90LA107Accident · No injuriesLimited investigationFinal reportCessna 150G · Franklin, WIInadequate compensation for wind conditions by the pilot, and his failure to maintain runway alignment during the attempted go-around (aborted landing). The wind conditions and soft terrain were related factors.Apr 5, 1990 · N3876J · Substantial damageNTSB CHI90FA065Accident · 1 fatalField investigationFinal reportCessna 402B · Appleton, WIThe pilot's decision to continue flight into known adverse weather conditions resulting in a windshear encounter with insufficient altitude for recovery. The existing adverse weather conditions were factors.Jan 17, 1990 · N87163 · Destroyed