Fatal NTSB investigations, MO

11 cases where the sequence of events included Aerodynamic stall/spin.

Cases per year

20102026
Fatal NTSB investigations, MO per year, 2010–2026: 11 cases
20101
20121
20131
20141
20152
20161
20181
20212
20231

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\" = 'MO' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '241' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 CEN23FA304Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Osage Beach, MOThe pilot’s failure to properly set the stabilator trim before takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall during takeoff.Jul 13, 2023 · N8225N · Substantial damageNTSB CEN22LA001Accident · 2 fatalClass 3 · LimitedFinal reportTandem Air-Bike · Warrensburg, MOThe improper judgment of both pilots to attempt a flight while impaired by drugs/medications and their failure to maintain control of the aircraft, which resulted in an aerodynamic stall and impact with terrain.Oct 3, 2021 · UNREG · DestroyedNTSB CEN21FA380Accident · 1 fatalClass 3 · FieldFinal reportPiper J3C-65 · Adrian, MOThe pilot’s failure to maintain control of the airplane which resulted in an aerodynamic stall and impact with terrain.Aug 22, 2021 · N70643 · Substantial damageNTSB CEN18FA384Accident · 2 fatalField investigationFinal reportCessna 150 · Festus, MOA total loss of engine power due to fuel exhaustion and the pilot's subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to initiate and continue the…Sep 21, 2018 · N7152S · Substantial damageNTSB CEN16FA378Accident · 2 fatalField investigationFinal reportPiper PA 28-235 · Lee's Summit, MOThe pilot's improper control inputs during takeoff, which resulted in the exceedance of the airplane's critical angle of attack and subsequent departure stall, and loss of airplane control.Sep 20, 2016 · N8983W · Substantial damageNTSB CEN15FA282Accident · 1 fatalField investigationFinal reportChristen Industries Pitts S-2B · Cameron, MOThe pilot’s failure to maintain airplane control during a low-level aerobatic flight maneuver.Jun 27, 2015 · N877UP · Substantial damageNTSB CEN15FA267Accident · 4 fatalField investigationFinal reportBeech A36 · Huggins, MOThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack, which resulted in an aerodynamic stall and loss of control.Jun 12, 2015 · N3193W · DestroyedNTSB CEN15FA060Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Boonville, MOThe pilot's failure to maintain adequate airspeed during a forced landing following a total loss of engine power due to fuel starvation, which resulted in the airplane exceeding its critical angle of attack, and an aerodynamic stall at a low altitude.…Nov 30, 2014 · N6629V · Substantial damageNTSB CEN13FA496Accident · 2 fatalField investigationFinal reportMooney M20J · Kansas City, MOThe pilot's improper decision to attempt continued flight after a momentary loss of engine power with usable runway remaining. Contributing to the accident were the pilot's premature retraction of the landing gear, the loss of engine power due to fuel system…Aug 18, 2013 · N9201R · Substantial damageNTSB CEN12LA636Accident · 1 fatalLimited investigationFinal reportJDT Mini-Max 1500R · Cameron, MOThe pilot's failure to maintain adequate airspeed during initial climb, which resulted in an aerodynamic stall and spin at a low altitude.Sep 16, 2012 · N3533D · Substantial damageNTSB CEN11FA008Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Springfield, MOThe pilot's failure to maintain control of the airplane during an attempted go-around, which led to an aerodynamic stall.Oct 6, 2010 · N9695U · Substantial damage