NTSB investigations, NV
19 cases where the sequence of events included Aerodynamic stall/spin.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 3 |
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 1 |
| 2022 | 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\" = 'NV' 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" = 'NV' 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 WPR23LA018Accident · No injuriesClass 4 · LimitedFinal reportPiper J3F-60 · Herlong, NVThe pilot's failure to maintain adequate separation during a formation flight, which resulted in an encounter with wake turbulence, an aerodynamic stall, and collision with terrain.NTSB WPR22FA240Accident · 1 fatalClass 3 · FieldFinal reportExtra Flugzeugbau EA 300/L · Boulder City, NVThe failure of the pilot to maintain control of the airplane by exceeding the airplane’s critical angle of attack while maneuvering in a turning climb at a low altitude, which resulted in an aerodynamic stall and spin from which the pilot was unable to…NTSB WPR20CA102Accident · No injuriesData collectionFinal reportMooney M20K · Minden, NVThe pilot’s failure to complete a before landing checklist, which resulted in his delayed extension of the landing gear, and his subsequent exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA20CA030Accident · No injuriesData collectionFinal reportPiper PA18 · Gerlach, NVThe pilot's exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall.NTSB WPR19LA141Accident · Serious injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Boulder City, NVThe pilot’s improper monitoring and failure to maintain airspeed during a critical phase of flight, which resulted in an exceedance of the airplane’s critical angle of attack, an aerodynamic stall, and subsequent impact with terrain.NTSB WPR19TA018Accident · Serious injuriesFinal reportAudenried Kitfox S7 SuperSport · Flanigan, NVThe pilot's failure to maintain airspeed during a sharp turn at low altitude, which resulted in an aerodynamic stall.NTSB WPR18FA253Accident · 1 fatalClass 2 · FieldFinal reportCommander 114 · Jean, NVThe pilot failed to maintain adequate speed while maneuvering at a low attitude during night and entered an aerodynamic stall and subsequent spin.NTSB GAA17CA291Accident · No injuriesData collectionFinal reportCessna T182 · Carson City, NVThe pilot’s unstabilized approach during the landing flare and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB WPR17LA072Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Carson City, NVA total loss of engine power due to internal corrosion of the fuel manifold valve. Also causal was the pilot's decision to return to the runway following the loss of engine power shortly after takeoff, and his exceedance of the airplane's critical angle of…NTSB GAA16CA444Accident · Minor injuriesData collectionFinal reportP Z L -Warszawa-Cnpsl PZL 104 Wilga · Austin, NVThe pilot's failure to maintain an appropriate descent rate during the base to final turn, which resulted in a forced landing, and an intentional aerodynamic stall. Contributing to the accident was the pilot's excessive braking, which resulted in a nose over…NTSB GAA16CA026Accident · No injuriesData collectionFinal reportRans S-7 · Gerlach, NVThe pilot's failure to maintain pitch and airspeed control, in conjunction with full flaps, while maneuvering at a low altitude, resulting in a tail-stall and subsequent impact with the ground.NTSB WPR14FA132Accident · 1 fatalField investigationFinal reportCessna 120 · Carson City, NVThe pilot’s delayed decision to initiate a course-reversal turn when the airplane was unable to attain sufficient altitude to cross a mountain range, which resulted in the airplane exceeding its critical angle of attack and entering an aerodynamic stall…NTSB WPR13FA376Accident · 2 fatalField investigationFinal reportUrban Air Sro Samba XXL · Carson City, NVThe pilot's failure to maintain adequate airspeed while maneuvering, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin. Contributing to the accident was the improper location of the parachute…NTSB WPR11CA231Accident · No injuriesData collectionFinal reportLet L 33 Solo · Sparks, NVThe pilot’s failure to maintain an adequate airspeed during landing, which resulted in an aerodynamic stall.NTSB WPR10LA208Accident · Minor injuriesLimited investigationFinal reportBibbee Cozy Mark IV · North Las Vegas, NVThe airplane's inability to recover from a stall due to the builder's failure to comply with design specifications and update the pilot’s operating handbook, which would have highlighted the discrepancies in the airplane's build-up.NTSB WPR09GA407Accident · 1 fatalFinal reportAir Tractor AT-802A · Austin, NVThe pilot’s failure to maintain a stabilized approach prior to the retardant drop and his subsequent failure to release the retardant load, resulting in a stall/mush and collision with terrain.NTSB WPR09FA258Accident · 4 fatalField investigationFinal reportCessna 320D · Fallon, NVThe pilot’s inadequate airspeed, which resulted in an aerodynamic stall.NTSB WPR09FA235Accident · 5 fatalField investigationFinal reportBeech 95 · Minden, NVThe pilot's failure to maintain an adequate airspeed while maneuvering during a low altitude maneuver that resulted in a stall.NTSB WPR09LA004Accident · 1 fatalLimited investigationFinal reportBonde TF-51D · Sandy Valley, NVThe pilot's failure to maintain adequate airspeed while maneuvering to land, resulting in an aerodynamic stall. Contributing to the accident was the pilot's diverted attention while attempting to extend the landing gear.