Fatal NTSB investigations, 1997, WI

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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

19642026
Fatal NTSB investigations, 1997, WI per year, 1964–2026: 459 cases
19645
196512
19664
196710
196812
196913
19709
19718
197210
197311
197415
19757
197611
197712
197811
197915
19807
198111
19829
198313
198411
19855
19865
19879
19887
19898
199011
19919
199212
199310
19942
19957
19965
19976
199810
19995
20007
200113
20025
20035
200410
20056
20066
20075
200810
20094
20102
20118
20122
20132
20144
20157
20164
20176
20185
20192
20201
20217
20222
20235
20241
20251
20262

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\") = 1997
    AND c.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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 CHI98LA061Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Sturtevant, WIThe pilot's misjudgment of altitude/distance and her failure to maintain adequate visual lookout. Also causal was the pilot's failure to maintain adequate obstacle clearance. A contributing factor was the pilot experiencing a visual illusion.Dec 13, 1997 · N5454S · DestroyedNTSB CHI97FA248Accident · 1 fatalField investigationFinal reportValley Adventurers Adventurer 333 · Fond Du Lac, WIThe kit manufacturer's use of inadequate material in construction of the airplane, his inadequate application of quality controls resulting in the debonding of the horizontal stabilizer. Factors were the total loss of the horizontal stabilizer, the elevator,…Aug 5, 1997 · N323VA · DestroyedNTSB CHI97FA252Accident · 2 fatalField investigationFinal reportBeech 76 · New Richmond, WIThe certified flight instructor's inadequate supervision and delayed remedial action and the flight crew's lack of aircraft control. A factor was loss of control while maneuvering downwind by one of the pilot's.Aug 4, 1997 · N18960 · DestroyedNTSB CHI97FA245Accident · 2 fatalField investigationFinal reportPeck Osprey 2 · Poygen, WIA loss of control in flight for undetermined reasons.Aug 4, 1997 · N4442C · DestroyedNTSB CHI97LA239Accident · 1 fatalLimited investigationFinal reportBriegleb BG-12A · Superior, WIthe separation of the wing from the glider for undetermined reasons.Aug 2, 1997 · N5516V · DestroyedNTSB CHI97FA084Accident · 4 fatalField investigationFinal reportDouglas DC-3C/BT-67R · Newton, WIfailure of the Beech A36 pilot to maintain clearance from the modified Douglas DC-3, while positioning the A36 for photography of the DC-3.Mar 15, 1997 · TZ389 · 2 aircraft · Destroyed