NTSB investigations, MI

21 cases where NTSB found Experience/qualifications.

Cases per year

20082026
NTSB investigations, MI per year, 2008–2026: 21 cases
20084
20102
20111
20124
20132
20142
20171
20192
20202
20211

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\", '020310'))
  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 CEN21LA104Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA-24-250 · New Hudson, MIThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of an instrument rating and the low visibility at the time…Jan 2, 2021 · N8347P · DestroyedNTSB CEN20LA399Accident · 2 fatalClass 3 · LimitedFinal reportVans RV9 · Zeeland, MIThe pilot’s failure to maintain airspeed during a visual approach in dark night conditions, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the accident was the pilot’s lack of recent flight experience at night.Sep 19, 2020 · N94KJ · DestroyedNTSB CEN20LA272Accident · 1 fatalClass 3 · LimitedFinal reportGolden Circle Air T-Bird · Grosse Ile, MIThe noncertificated pilot’s failure to maintain clearance from trees while maneuvering at low altitude in gusting wind conditions. Contributing to the accident was the pilot’s lack of flight experience.Jul 11, 2020 · N50JH · Substantial damageNTSB CEN19FA134Accident · 1 fatalClass 2 · FieldFinal reportAlliant Destiny 2000 · New Era, MIThe pilot's failure to maintain aircraft control while maneuvering that resulted in collapse of the canopy and an uncontrolled descent into terrain.May 4, 2019 · N65481 · DestroyedNTSB CEN19LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Adrian, MIThe airframe and powerplant mechanic's lack of experience in the overhaul of the engine model and the improper torque of the crankshaft gear bolt, which resulted in fatigue failure of the bolt and a total loss of engine power during an approach for landing.Jan 13, 2019 · N8892E · Substantial damageNTSB CEN17LA341Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Ray, MIThe pilot's failure to maintain a proper approach speed, which resulted in in a hard landing and a runway excursion. Contributing to the accident was the pilot's decision to fly the airplane without an instructor onboard.May 27, 2017 · N5584U · Substantial damageNTSB CEN14CA428Accident · Minor injuriesData collectionFinal reportGreat Lakes 2T 1A 2 · Frankfort, MIThe pilot's improper recovery from a bounced landing in gusty, crosswind conditions. Contributing to the accident was the pilot lack of recent tail wheel landing experience.Aug 3, 2014 · N80AM · Substantial damageNTSB CEN14FA110Accident · 1 fatalField investigationFinal reportCessna 310R · Waterford, MIThe pilot's controlled flight into terrain during an instrument landing system approach at night in instrument flight rules conditions. Contributing to the accident were the operator's inadequate training of the pilot, the operator's failure to provide a…Jan 11, 2014 · N3829G · DestroyedNTSB CEN13LA401Accident · 1 fatalLimited investigationFinal reportJDT 1600R · Chesaning, MIThe failure of the propeller reduction gearbox and the pilot’s subsequent failure to maintain adequate airspeed, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall and spin. Contributing to the accident were…Jul 6, 2013 · UNREG · DestroyedNTSB CEN13FA364Accident · 4 fatalField investigationFinal reportCessna 172M · Waterford, MIThe pilot's failure to retract the wing flaps before attempting to take off, due to his lack of familiarity with the airplane make and model, which prevented the airplane from maintaining adequate altitude for takeoff.Jun 21, 2013 · N9926Q · DestroyedNTSB CEN13FA067Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hillsdale, MIThe pilot's failure to maintain clearance from terrain during a straight-in night visual flight rules approach to land in hazy weather conditions. Contributing to the accident were the pilot's lack of recent night flying experience, the nonfunctional…Nov 21, 2012 · N40781 · Substantial damageNTSB CEN13FA038Accident · No injuriesField investigationFinal reportPiaggio P180 · Boyne City, MIThe select/bypass valve's failure to seal correctly because of improper shimming, which resulted in an uncommanded and uncontrollable left turn during landing. Contributing to the accident was the overhaul facility's improper overhaul of the steering manifold.Oct 31, 2012 · N401WS · Substantial damageNTSB CEN12LA565Accident · No injuriesLimited investigationFinal reportKolb MK-3 · Onondaga, MIThe noncertificated pilot's inadequate preflight planning, which resulted in landing on a runway of inadequate length and subsequent runway excursion.Aug 19, 2012 · N520SK · Substantial damageNTSB CEN12LA483Accident · Serious injuriesLimited investigationFinal reportEipper Quicksilver MXL II · Goodrich, MIThe operation of an unregistered and unairworthy airplane by a non-certificated pilot. Contributing to the accident was the non-certificated pilot’s improper preflight inspection, which resulted in a total loss of engine power due to water/debris…Jul 21, 2012 · UNREG · Substantial damageNTSB CEN12FA010Accident · 1 fatalField investigationFinal reportBrinkerhuff Gerald G Q200 · Holland, MIThe pilot failed to maintain sufficient altitude during the landing approach, which resulted in the airplane contacting an approach light. Contributing to the accident was the setting sun, which most likely obscured the pilot’s vision.Oct 6, 2011 · N2935R · Substantial damageNTSB CEN11LA014Accident · Serious injuriesLimited investigationFinal reportDrake Ronald A Acro Sport 1 · Fowlerville, MIThe pilot's loss of control during a go-around maneuver following a bounced landing. Contributing to the accident was the pilot's limited experience in the make and model airplane.Oct 11, 2010 · N53DB · Substantial damageNTSB CEN10FA101Accident · 2 fatalField investigationFinal reportCessna 172 · Holland, MIThe pilot's decision to take off in known instrument meteorological conditions without instrument currency or recent instrument experience, which led to spatial disorientation resulting in an inadvertent spin. Contributing to the accident was the pilot's lack…Jan 17, 2010 · N8405E · DestroyedNTSB CEN09FA083Accident · 1 fatalField investigationFinal reportCessna 206H · Kalkaska, MIThe pilot's failure to maintain clearance from trees and terrain during the instrument-flight-rules flight. Contributing to the accident was the pilot's failure to comply with instrument flight procedures and his lack of recent instrument flight experience.Dec 6, 2008 · N6053B · DestroyedNTSB CEN09FA015Accident · 1 fatalField investigationFinal reportCessna 150G · Cedar Lake, MIThe student pilot's failure to maintain adequate clearance after takeoff. Contributing to the accident was the pilot's overall lack of flight experience.Oct 11, 2008 · N3623J · Substantial damageNTSB CHI08FA132Accident · 1 fatalField investigationFinal reportFairchild Hiller FH-1100 · Comstock, MIA loss of engine power in flight due to fuel exhaustion resulting from the pilot's inadequate fuel management. Contributing to the accident was the unsuitable terrain for a forced landing.May 16, 2008 · N5049F · DestroyedNTSB CHI08CA094Accident · No injuriesData collectionFinal reportCessna 182 · Traverse City, MIThe unstabalized approach performed by the student pilot and the go-around not performed by the student pilot. Additional causes were the inadequate recovery from a bounced landing and the directional control not obtained by the student pilot. Contributing…Mar 26, 2008 · N5338B · Substantial damage