NTSB investigations, CA
122 cases where the sequence of events included Aerodynamic stall/spin.
Cases, newest first
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\" = 'CA' 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" = 'CA' 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 WPR11FA059Accident · 1 fatalField investigationFinal reportMooney M20R · Hollister, CAThe pilot did not ensure the airplane was loaded within its weight and balance envelope, which resulted in longitudinal instability and a loss of aircraft control during the initial climb.NTSB WPR10LA417Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Mammoth Lakes, CAThe pilot’s failure to maintain adequate airspeed and airplane control during takeoff in high density altitude conditions, which resulted in an aerodynamic stall.NTSB WPR10FA325Accident · 1 fatalField investigationFinal reportCessna 152 · Venice, CAThe pilot's failure to maintain adequate airspeed and airplane control during initial climb, which resulted in an aerodynamic stall/spin and subsequent impact with the ground.NTSB WPR10LA293Accident · 2 fatalLimited investigationFinal reportRans Coyote II S6 · Lincoln, CAThe pilot’s failure to maintain adequate airspeed while in a turn, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the increased drag on the airplane with the doors removed.NTSB WPR10LA268Accident · Serious injuriesLimited investigationFinal reportPiper PA-20 · Nelson, CAThe pilot's loss of aircraft control during an undetermined phase of flight, which resulted in an aerodynamic stall/spin and subsequent collision with terrain.NTSB WPR10LA063Accident · 1 fatalLimited investigationFinal reportBudd Lancair Legacy · Watsonville, CAA loss of engine power due to oil starvation and the pilot's failure to maintain airspeed while approaching the landing area resulting in an aerodynamic stall, rapid descent, and collision with terrain.NTSB WPR09LA432Accident · Serious injuriesLimited investigationFinal reportCessna P206B · Truckee, CAThe pilot’s failure to maintain adequate airspeed for flight, which resulted in an aerodynamic stall and subsequent impact with the ground. Contributing to the accident was the intermittent failure of the stall warning system due to a contaminated switch.NTSB WPR09LA419Accident · 2 fatalLimited investigationFinal reportJames B. Taplin RV-6 · Orland, CAThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall/spin.NTSB WPR09LA357Accident · 2 fatalLimited investigationFinal reportWeiss Lancair · Santa Clarita, CAThe pilot's failure to maintain adequate airspeed and control while maneuvering.NTSB WPR09FA326Accident · 1 fatalField investigationFinal reportCessna 150 · South Lake Tahoe, CAA partial loss of engine power due to a malfunctioning carburetor and the pilot’s failure to maintain adequate airspeed while maneuvering to return to the runway. Contributing to the accident was the high density altitude.NTSB WPR09FA200Accident · 2 fatalField investigationFinal reportChampion 7ECA · San Jose, CAThe pilot's failure to maintain airspeed while maneuvering within a canyon in mountainous terrain, which resulted in an inadvertent stall/spin.NTSB WPR09CA178Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Monterey, CAThe pilot's inadequate compensation for the wind conditions and failure to attain/maintain an adequate airspeed, which resulted in an aerodynamic stall.NTSB WPR09FA133Accident · 2 fatalField investigationFinal reportMooney M20E · Rio Linda, CAA partial loss of engine power for undetermined reasons and the pilot's failure to maintain an adequate airspeed while maneuvering during the initial climb, which resulted in a stall/spin.NTSB LAX08LA211Accident · 1 fatalLimited investigationFinal reportCessna 152 · Piru, CAThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.NTSB LAX08LA191Accident · 2 fatalLimited investigationFinal reportCessna 172S · Oceanside, CAFailure of the pilot to regain airplane control during an intentional stall/spin maneuver.NTSB LAX08LA187Accident · No injuriesLimited investigationFinal reportCessna R172K · Big Bear City, CAThe pilot's failure to attain and maintain an adequate airspeed that led to a stall/mush. Contributing to the accident was the lack of suitable terrain for an off airport landing and a high density altitude.NTSB SEA08LA145Accident · 2 fatalLimited investigationFinal reportPoulin L/Cullen D Lancair Legacy · Murrieta, CAThe pilot's inadequate preflight planning, which resulted in the loss of engine power due to fuel exhaustion, and the pilot's failure to maintain flying speed, which resulted in an inadvertent stall/spin and the subsequent collision with terrain.NTSB LAX08FA152Accident · 4 fatalField investigationFinal reportBeech V35B · Fall River Mills, CAThe pilot's failure to maintain adequate airspeed while maneuvering for landing, resulting in an aerodynamic stall.NTSB LAX08FA115Accident · 2 fatalField investigationFinal reportCessna 150J · Sonora, CAThe pilot's failure to maintain airspeed while maneuvering, resulting in an aerodynamic stall and loss of aircraft control. Contributing to the accident were rising mountainous terrain and a high density altitude.NTSB LAX08LA108Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Columbia, CAThe flight instructor's decision to attempt takeoff with an engine discrepancy and subsequent failure to abort takeoff when the airplane did not attain adequate airspeed during the initial climb, resulting in an aerodynamic stall. Contributing to the accident…NTSB LAX08CA102Accident · No injuriesData collectionFinal reportCessna 172S · Gualala, CAThe pilot's decision not to use all of the available runway, his premature rotation and failure to obtain and maintain an adequate airspeed to continue the takeoff that resulted in a stall/mush, an aborted takeoff, a runway overrun, and a collision with…NTSB LAX08FA068Accident · 3 fatalField investigationFinal reportMooney M20C · Riverside, CAThe pilot's failure to maintain airspeed and aircraft control, resulting in an aerodynamic stall.