NTSB investigations, 2022, FL

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

Cases per year

20082026
NTSB investigations, 2022, FL per year, 2008–2026: 110 cases
20084
20095
20106
201111
20126
20134
20144
20152
20166
20176
201812
20198
20206
20219
20225
20235
20245
20254
20262

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\") = 2022
    AND c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    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 ERA23LA020Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 100 · New Smyrna Beach, FLThe pilot’s exceedance of the critical angle of attack during takeoff and corresponding stall/mush. Contributing to the accident were the pilot’s operation of the airplane above the maximum specified gross weight.Oct 13, 2022 · N3885X · Substantial damageNTSB ERA22LA394Accident · Minor injuriesClass 4 · LimitedFinal reportSutphin John E Rans S-12 · Hilliard, FLThe pilot’s failure to maintain an adequate airspeed, which resulted in an aerodynamic stall.Aug 31, 2022 · N8028W · Substantial damageNTSB ERA22FA384Accident · 2 fatalClass 3 · FieldFinal reportMXR Technologies MX2 · Osteen, FLThe pilot’s loss of airplane control while performing aerobatic maneuvers, which resulted in the airplane entering an inverted flat spin that continued until the airplane impacted terrain.Aug 24, 2022 · N263MX · Substantial damageNTSB ERA22LA332Accident · Serious injuriesClass 4 · LimitedFinal reportWhitten Robinson Aventura II · Meritt Island, FLThe pilot’s failure to maintain control of the airplane during final approach to land, which resulted in an exceedance of the airplane’s critical angle of attack, aerodynamic stall, and collision with a fence and terrain.Jul 23, 2022 · N709CW · Substantial damageNTSB ERA22FA218Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · Altha, FLThe pilot’s failure to perform a preflight weight and balance calculation and his operation of the flight at an excessive takeoff weight, resulting in an exceedance of the airplane’s critical angle of attack after liftoff and an aerodynamic stall from which…May 3, 2022 · N6413B · Destroyed