NTSB investigations, MI

8 cases where NTSB found Wire.

Cases per year

20082026
NTSB investigations, MI per year, 2008–2026: 8 cases
20081
20121
20152
20162
20181
20201

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 c.\"eventStateOrRegion\" = 'MI' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022032'))
  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 CEN20CA387Accident · Serious injuriesClass 4 · Data collectionFinal reportPowrachute Airwolf · Casco, MIThe pilot's decision to takeoff towards known obstacles which resulted in an impact with a power line.Aug 11, 2020 · N465JP · Substantial damageNTSB CEN18LA123Accident · 1 fatalLimited investigationFinal reportMills Michael S1L · Dewitt, MIThe pilot's failure to see and avoid power lines due to sun glare.Mar 22, 2018 · N197X · Substantial damageNTSB CEN16LA363Accident · Serious injuriesLimited investigationFinal reportCGS Hawk Aero II · Holland, MIThe improper installation of quick release connectors in the fuel lines, which was not in accordance with the engine manufacturer's maintenance instructions and allowed air to be introduced into the fuel system and resulted in a partial loss of engine power.…Sep 3, 2016 · N4513S · DestroyedNTSB CEN16LA236Accident · 1 fatalLimited investigationFinal reportCessna 150L · Detroit, MIThe pilot’s disregard of the banner-tow operator's policy regarding the maximum allowable flight duration, which resulted in a total loss of engine power due to fuel exhaustion.Jun 28, 2016 · N6622G · Substantial damageNTSB GAA15CA227Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Sandusky, MIThe pilot's failure to monitor the landing environment while operating in a confined off-airport site resulting in a wire strike and substantial damage to the helicopter.Jul 15, 2015 · N8337Z · Substantial damageNTSB CEN15LA235Accident · Serious injuriesLimited investigationFinal reportLathrop Steven A B8M · Ravenna, MIA total loss of engine power due to carburetor icing.May 1, 2015 · N5606X · DestroyedNTSB CEN12LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Pinconning, MIThe pilot's failure to properly align his airplane with the runway during final approach. Contributing to the accident was the sunglare that obscured the pilot's view of the runway.Mar 21, 2012 · N2389P · Substantial damageNTSB CHI08CA278Accident · No injuriesData collectionFinal reportCessna 185 · Newberry, MIThe pilot's failure to maintain clearance from the wires on approach. Contributing to the accident was the sunshine, as reported by the pilot.Sep 5, 2008 · N80MW · Substantial damage