NTSB investigations, 2004, WI

5 cases where the first occurrence was “Loss of engine power”.

Cases per year

19822026
NTSB investigations, 2004, WI per year, 1982–2026: 82 cases
19823
19832
19844
19852
19863
19872
19883
19891
19901
19921
19932
19943
19952
19961
19973
19986
19997
20003
20016
200211
20033
20045
20053
20062
20073

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\") = 2004
    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\" = 350)
  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 CHI04FA290Accident · 3 fatalField investigationFinal reportBeech B95A · Burlington, WIThe improper maintenance of the fuel servo resulting in a loose adjustment nut and subsequent failure of the fuel injection servo which led to a complete loss of power on the right engine. Other causes were the pilot's failure to obtain or maintain minimum…Sep 30, 2004 · N1703Y · DestroyedNTSB CHI04LA256Accident · 1 fatalLimited investigationFinal reportClaxton S-12 · Oconomowoc, WIThe loss of engine power due to the seizure of the pistons and the pilot's failure to maintain airspeed which resulted in an inadvertent stall. The previous damage to the pistons due to earlier seizure occurrences was a factor.Sep 12, 2004 · UNREG · DestroyedNTSB CHI04LA167Accident · No injuriesLimited investigationFinal reportBeech 200 · Green Bay, WIThe loss of engine power after takeoff for an undetermined reason.Jun 30, 2004 · N432FA · Substantial damageNTSB CHI04CA138Accident · No injuriesData collectionFinal reportMerkel Acro Sport II · Beloit, WIInaccurate fuel consumption calculations which resulted in fuel exhaustion. Factors associated with the accident were the pilot's continued flight with an inoperable fuel quantity indicator and the wires which the airplane contacted during the forced landing.Jun 5, 2004 · N796DM · Substantial damageNTSB CHI04CA118Accident · No injuriesData collectionFinal reportPiper PA-12 · Hartford, WIThe loss of engine power for undetermined reasons. A factor to the accident was the soft terrain encountered during the forced landing.May 9, 2004 · N2368M · Substantial damage