NTSB investigations, 1995, WI

5 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.

Cases per year

19822026
NTSB investigations, 1995, WI per year, 1982–2026: 49 cases
19824
19833
19843
19851
19864
19873
19881
19893
19912
19922
19933
19942
19955
19963
20033
20045
20051
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 year(c.\"eventDate\") = 1995
    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\" = 351)
  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 CHI96LA007Accident · Minor injuriesLimited investigationFinal reportRoisum Team MINI-MAX · Neenah, WIFuel starvation due to fuel filter blockage. Factors associated with the accident were the manufacturers design of the fuel filter and the builder/pilots decision to use an automotive type fuel filter.Oct 11, 1995 · N42BX · Substantial damageNTSB CHI95LA295Accident · No injuriesLimited investigationFinal reportKraetzner SKY-BUGGY · Princeton, WIthe loss of engine power due to the blocked float valve seat in the carburetor and the pilot's failure to have the proper maintenance inspection performed on the airplane.Aug 20, 1995 · N16626 · DestroyedNTSB CHI95LA290Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Port Washington, WIthe failure of the #2 cylinder due to fatigue cracking. A factor was the soft terrain.Aug 20, 1995 · N55404 · Substantial damageNTSB CHI95FA242Accident · No injuriesField investigationFinal reportRevolution Helicopter MINI-500 · Oshkosh, WIthe inadequate design of the helicopter skid shoes. Factors related to the accident were: false indications of rotor rpm and EGT which led to seizure of the piston.Jul 27, 1995 · N500ZZ · Substantial damageNTSB CHI95LA187Accident · No injuriesLimited investigationFinal reportBell 47J2A · Elkhorn, WIloss of power as a result of an intake valve failure due to improper maintenance performed during the major engine overhaul, and pilot misjudgment of the flare during autorotation.Jun 19, 1995 · N470RA · Substantial damage