NTSB investigations, OH
19 cases where the defining event was Aerodynamic stall/spin.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 2 |
| 2017 | 2 |
| 2018 | 2 |
| 2022 | 1 |
| 2025 | 2 |
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\" = 'OH' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '241')
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" = 'OH' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '241') 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 ERA25LA176Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150 · Kingston, OHThe pilot’s exceedance of the airplanes’ critical angle of attack resulting in a stall at an altitude too low to recover.NTSB ERA25FA163Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 310Q · Midvale, OHOn April 1, 2025, about 1704 eastern daylight time, a Cessna 310Q, N8242Q, was substantially damaged when it was involved in an accident near Midvale, Ohio. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ERA22LA267Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Bluffton, OHThe student pilot’s loss of control during climb after an aborted landing, which resulted in an aerodynamic stall.NTSB GAA18CA470Accident · Minor injuriesData collectionFinal reportWalter C Smythe Tango XR · Mansfield, OHThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall.NTSB CEN18LA171Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Orrville, OHThe pilot's failure to attain adequate airspeed during the soft field takeoff, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB GAA17CA297Accident · Minor injuriesData collectionFinal reportCGS Hawk · Findlay, OHThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB CEN17FA108Accident · 1 fatalField investigationFinal reportMacleod Homebuilt · Springfield, OHThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and loss of airplane control at an altitude too low for a safe recovery.NTSB CEN16MA036Accident · 9 fatalClass 1 · MajorFinal reportBritish Aerospace HS 125 700A · Akron, OHThe flight crew's mismanagement of the approach and multiple deviations from company standard operating procedures, which placed the airplane in an unsafe situation and led to an unstabilized approach, a descent below minimum descent altitude without visual…NTSB GAA15CA141Accident · No injuriesData collectionFinal reportSchweizer SGS 2 32 · Middlefield, OHThe student pilot's incorrect pitch and roll rate control inputs which resulted in an aerodynamic stall and incipient spin at a low altitude.NTSB CEN13CA556Accident · Serious injuriesData collectionFinal reportCessna 152 · Wadsworth, OHThe pilot's failure to adequately maintain airspeed during a go-around.NTSB CEN12LA448Accident · Serious injuriesLimited investigationFinal reportChapman Mark A Trike · Marlboro, OHThe student pilot’s failure to maintain adequate airspeed during a turn, which resulted in an aerodynamic stall.NTSB CEN12FA115Accident · 3 fatalField investigationFinal reportBeech 19A · McArthur, OHThe pilot’s failure to maintain airplane control during an attempted go-around.NTSB CEN10CA225Accident · Minor injuriesData collectionFinal reportSchweizer SGS1-34 · Waynesville, OHThe pilot's failure to maintain adequate airspeed which resulted in an aerodynamic stall.NTSB CEN10FA097Accident · 4 fatalField investigationFinal reportMitsubishi MU-2B-60 · Elyria, OHThe pilot's failure to maintain adequate airspeed during the instrument approach, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN10LA035Accident · Serious injuriesLimited investigationFinal reportBlanik L-13 · Middlefield, OHThe student pilot's improper control inputs which resulted in the inadvertent stall of the glider.NTSB CEN09LA440Accident · 1 fatalLimited investigationFinal reportAntares MA-33 · Centerburg, OHThe pilot's failure to maintain adequate airspeed resulting in an aerodynamic stall.NTSB CEN09FA099Accident · 1 fatalField investigationFinal reportPiper PA-32R · North Canton, OHThe pilot’s inappropriate control inputs as a result of spatial disorientation, which led to an aerodynamic stall and loss of control. Contributing to the accident were the pilot's decision to conduct flight into known icing conditions, ice accumulation that…NTSB CHI08FA248Accident · 1 fatalField investigationFinal reportBeech 58TC · Marysville, OHThe pilot's failure to maintain sufficient airspeed during the base to final turn resulting in an aerodynamic stall.NTSB CHI08FA156Accident · 6 fatalField investigationFinal reportCessna U206C · Fremont, OHThe pilot’s failure to maintain airplane control for an undetermined reason, which resulted in an inadvertent stall. Contributing to the accident was the pilot's poor judgment in continuing to fly with his severe visual deficiency. Also contributing to the…