NTSB investigations, 1983, WI

4 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.

Cases per year

19822026
NTSB investigations, 1983, WI per year, 1982–2026: 110 cases
19825
19834
19849
19859
19864
19874
19888
19899
19907
19917
19923
199312
19944
19954
19965
19973
19983
19991
20002
20012
20021
20032
20052

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\") = 1983
    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\" = 353)
  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 CHI84LA032Accident · No injuriesLimited investigationFinal reportCessna 150 · La Crosse, WIThe acft was ditched in lake onalaska after the engine quit about 1 mile short of destination. After the accident the acft was pulled from the lake and examined. The 3 FAA inspectors who examined the acft verified that there was not enough fuel in the acft to…Oct 30, 1983 · N23183 · Substantial damageNTSB CHI84LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Waupaca, WIPlt had made missed approaches at wausau & mosinee. Plt informed artc that he had a fuel problem. While receiving vectors to Waupaca arpt the eng quit & the acft crashed into trees. Total time of flt was 4+33. The right tank fuel filler cap was loose & the…Oct 7, 1983 · N7695J · Substantial damageNTSB CHI83FA351Accident · No injuriesField investigationFinal reportSwain Rutan Longeze · Oshkosh, WIThe acft nosed over during a forced landing after a power loss. The acft collided with tall corn during the landing rolland swerved into the corn. Examination of the carburetor revealed pieces of a soft brownish-white somewhat elastic substance in the float…Aug 2, 1983 · N4ZZ · Substantial damageNTSB CHI83LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Rice Lake, WIThe acft hit a ditch and nosed over during a forced landing after the engine quit. The plt was on a cross country and had landed enroute 3 times without refueling. With the assistance of eau claire fss he overflew Rice Lake arpt but could not find it. The…Apr 19, 1983 · N1491T · Substantial damage