Fatal NTSB investigations, OK
13 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2021 | 1 |
| 2022 | 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\" = 'OK' 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.
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" = 'OK' 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
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 CEN22LA321Accident · 2 fatalClass 3 · LimitedFinal reportJust Highlander · Bennington, OKThe pilot’s exceedance of the airplane’s critical angle of attack which resulted in an aerodynamic stall and loss of control.NTSB CEN21LA396Accident · 1 fatalClass 3 · LimitedFinal reportMonnett Moni · Tulsa, OKAn aerodynamic stall/spin and loss of control for reasons that could not be determined based on the available information.NTSB CEN17FA138Accident · 1 fatalField investigationFinal reportBeech V35 · Union City, OKThe pilot's improper recovery from a spin.NTSB CEN15LA432Accident · 1 fatalLimited investigationFinal reportRans S18 · Shattuck, OKThe noncertificated pilot’s failure to maintain control of the unregistered airplane during initial climb and his subsequent exceedance of the airplane’s critical angle-of-attack, which resulted in a stall/spin.NTSB CEN13FA137Accident · 3 fatalField investigationFinal reportBeech 95-B55 (T42A) · Mangum, OKThe airplane's aerodynamic stall/spin at low altitude and subsequent impact with terrain for reasons that could not be determined during postaccident examinations. Contributing to the accident was the pilot's lack of currency/proficiency.NTSB CEN13FA051Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Anadarko, OKThe pilot’s use of excessive bank angle while maneuvering in the airport traffic pattern, which resulted in an accelerated stall.NTSB CEN11FA434Accident · 1 fatalField investigationFinal reportSchaffer Gary W Lancair · Yukon, OKThe pilot's use of an excessive bank angle while in the airport traffic pattern, which resulted in an accelerated stall. Contributing to the accident were the pilot’s lack of experience in the airplane and the pilot’s distracted attention to the rough running…NTSB CEN11LA082Accident · 1 fatalLimited investigationFinal reportCessna 172M · Velma, OKThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in an inadvertent stall and subsequent impact with terrain. Contributing to the accident was the pilot's relative inexperience in pipeline patrols.NTSB CEN10FA385Accident · 3 fatalField investigationFinal reportCessna 177B · Owasso, OKThe pilot’s failure to maintain adequate airspeed during an engine-out approach to the runway, resulting in an aerodynamic stall and spin. Contributing to the accident was the pilot’s inadequate preflight planning, which resulted in a loss of engine power due…NTSB CEN10LA276Accident · 2 fatalLimited investigationFinal reportCovell Kevin Scott Vans RV-4 · Collinsville, OKA loss of engine power shortly after takeoff for undetermined reasons. Contributing to the accident was the pilot's decision to make a 180-degree turn at low level.NTSB CEN10LA043Accident · 2 fatalLimited investigationFinal reportMoore Skybolt/BM · Altus, OKThe pilot's poor judgment by performing intentional low-level maneuvers that resulted in an inadvertent stall/spin at an altitude to low to affect a safe recovery.NTSB CEN09FA230Accident · 1 fatalField investigationFinal reportCessna 337C · Stillwater, OKThe total loss of dual engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB DFW08FA060Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Lindsay, OKThe flight instructor's failure to maintain control of the airplane, which resulted in an inadvertent stall while maneuvering.