NTSB investigations, MN
14 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 2 |
| 2020 | 1 |
| 2023 | 1 |
| 2024 | 1 |
Where
Open the mapLatest 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\" = 'MN' 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.
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" = 'MN' 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN24FA125Accident · 2 fatalClass 3 · FieldFinal reportGlobe GC-1B · Afton, MNThe pilot’s failure to maintain airplane control while maneuvering, which resulted in an aerodynamic stall and spin.NTSB CEN23FA248Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7CCM · Duluth, MNThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed, which resulted in an aerodynamic stall and loss of control.NTSB CEN20CA250Accident · No injuriesClass 4 · Data collectionFinal reportHatz Hatz CB 1 · Red Wing, MNThe pilot's failure to perform a go around following a bounced landing that resulted in an aerodynamic stall.NTSB CEN17LA304Accident · Serious injuriesLimited investigationFinal reportRoger M Allen RA2 · Hector, MNThe pilot’s improper installation of the control stick hardware, which resulted in a loss of elevator control in flight.NTSB CEN17LA238Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · Mahnomen, MNThe pilot’s failure to abort the takeoff after recognizing a partial loss of engine power during the takeoff roll and his subsequent inability to maintain adequate airspeed during a turn to avoid power lines, which resulted in an aerodynamic stall. The…NTSB CEN15FA181Accident · 2 fatalField investigationFinal reportPiper J-4A · Pine River, MNThe pilot' failure to maintain adequate airspeed after takeoff, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot's decision to conduct the flight…NTSB CEN15CA036Accident · Minor injuriesData collectionFinal reportFlight Design CTLSi · White Bear Lake, MNThe pilot's exceedance of the airplane's critical angle of attack during the landing, which resulted in an inadvertent aerodynamic stall, a hard landing, and a nose over.NTSB CEN14LA066Accident · No injuriesLimited investigationFinal reportQuad City Challenger I · Winsted, MNThe pilot’s failure to maintain airspeed while maneuvering for a precautionary landing after the light sport airplane started vibrating, which led to an inadvertent aerodynamic stall.NTSB CEN11LA623Accident · 1 fatalLimited investigationFinal reportHoffmann HK36R Super Dimona · Winsted, MNThe pilot did not maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.NTSB CEN11LA332Accident · Serious injuriesLimited investigationFinal reportUnregistered Quicksilver MXL II · Crookston, MNThe pilot’s improper airspeed while maneuvering to land, which resulted in an aerodynamic stall/spin at a low altitude.NTSB CEN10LA484Accident · Serious injuriesLimited investigationFinal reportRammel Thomas W Searey · Cokato, MNSeparation of the composite skin on one of the three propeller blades that resulted in an in-flight vibration, and the pilot's failure to maintain clearance with the water while maneuvering to avoid obstacles in preparation for a precautionary landing.NTSB CEN10LA188Accident · Serious injuriesLimited investigationFinal reportBeech 95 · Eden Prairie, MNThe fatigue failure of an intake valve spring on the right engine, which resulted in a partial loss of engine power on takeoff.NTSB CEN09LA224Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F19 · Lake Vermillion, MNThe pilot's failure to maintain proper pitch control resulting in a stall/spin.NTSB CHI08LA228Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Maple Lake, MNThe certified flight instructor's delayed remedial action to the encountered stall. Contributing to the accident was the student pilot's slow airspeed and inadvertent stall.