NTSB investigations, MI

9 cases where the first occurrence was “Abrupt maneuver”.

Cases per year

19862026
NTSB investigations, MI per year, 1986–2026: 9 cases
19861
19871
19891
19922
19961
19972
20001

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 100)
  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 CHI00LA228Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Harbor Springs, MIthe pilot selected the wrong runway direction in which to land and he did not perform a go-around when he realized the landing approach was too high. Factors associated with the accident were the tailwind condition, the improper glidepath, and the intentional…Jul 28, 2000 · N345CD · Substantial damageNTSB CHI97FA300Accident · 2 fatalField investigationFinal reportBeech T34B · Fremont, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall. Also causal was the pilot's ostentatious display.Sep 25, 1997 · N777SU · DestroyedNTSB CHI97FA116Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Holland, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent impact with trees and then a residence. A related factor was turbulence.Apr 26, 1997 · N3126Z · DestroyedNTSB CHI97LA010Accident · 2 fatalLimited investigationFinal reportDellicker Starduster TOO SA300 · Eaton Rapids, MIthe pilot's failure to maintain adequate airspeed and subsequent inadvertent stall of the airplane. A factor was the ostentatious display.Oct 13, 1996 · N7691 · DestroyedNTSB CHI92LA253Accident · No injuriesLimited investigationFinal reportLake LA-4 · Pontiac, MIThe instructor pilot's directing a turn to change heading in the flare.Aug 13, 1992 · N8WW · Substantial damageNTSB CHI92DEC03Accident · 1 fatalFinal reportJarrell RV-3 · Jackson, MIAn overload and total failure of the rear wing attach fitting.Aug 6, 1992 · N50WP · DestroyedNTSB CHI89LA103Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Milan, MIThe pilot's excessive rotation, which resulted in an inadvertent mushed stall and collision with trees.Jun 5, 1989 · N5011C · DestroyedNTSB FTW87MA135Accident · 2 fatalMajor investigationFinal reportMBB BO-105CBS · Bay City, MIAcft was involved in EMS static demonstration at beaver township fire dept, near Bay City. Following demonstration, shortly after takeoff, the pilot attempted a steep downwind turn at low altitude. Reported winds at the time of the accident were 250 degrees…Jun 7, 1987 · N550H · DestroyedNTSB CHI87DEM01Accident · 1 fatalFinal reportBrown Acro Sport II · Grand Haven, MIAccording to the pilot after takeoff he leveled off to gain airspeed and then entered a 60 degree pitch up attitude. The pilot stated at about 400 feet AGL he noticed the airspeed was lower than 'normal'. Shortly thereafter the aircraft stalled and entered a…Oct 19, 1986 · N3045E · Destroyed