NTSB investigations, 2012
110 cases where NTSB found Airspeed.
Cases per year
| 2008 | 159 |
|---|---|
| 2009 | 137 |
| 2010 | 99 |
| 2011 | 142 |
| 2012 | 110 |
| 2013 | 99 |
| 2014 | 93 |
| 2015 | 97 |
| 2016 | 93 |
| 2017 | 84 |
| 2018 | 89 |
| 2019 | 73 |
| 2020 | 76 |
| 2021 | 79 |
| 2022 | 76 |
| 2023 | 61 |
| 2024 | 66 |
| 2025 | 31 |
| 2026 | 19 |
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 year(c.\"eventDate\") = 2012
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062010'))
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 year(c."eventDate") = 2012 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01062010')) 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 CEN13CA120Accident · No injuriesData collectionFinal reportRobidoux Lionel Wittman W 10 · Hobart, INThe pilot’s failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall and subsequent hard landing.NTSB WPR13FA076Accident · 3 fatalField investigationFinal reportMckenzie Lancair IV-P Turbine · Lakeside, CAThe pilot’s failure to maintain airspeed while attempting a visual climb through a broken cloud layer, which resulted in a stall/spin.NTSB CEN13LA116Accident · Serious injuriesLimited investigationFinal reportSeguine Swift II · San Antonio, TXThe pilot's failure to attain a proper pitch attitude and airspeed during initial climb, which resulted in an aerodynamic stall.NTSB WPR13LA045Accident · 1 fatalLimited investigationFinal reportPiper PA-32 · ObyanA partial loss of engine power shortly after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation and the pilot’s failure to maintain airplane control during…NTSB CEN13LA062Accident · 1 fatalLimited investigationFinal reportJabiru USA Sport J250-SP · Jacksonville, TXThe pilot's failure to maintain adequate airspeed during initial climb following an aborted landing, which resulted in an aerodynamic stall and spin at a low altitude.NTSB CEN13FA060Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA-1B · Burlington, WIThe pilot’s failure to maintain control of the airplane while maneuvering at a low altitude, which resulted in an inadvertent stall and spin.NTSB ANC13LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Akiachak, AKThe pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion, and the pilot’s failure to maintain adequate airspeed during the subsequent forced landing, which resulted in an inadvertent stall.NTSB WPR13FA036Accident · 2 fatalField investigationFinal reportNorth Wing Scout X-C · Waterville, WAThe pilot's failure to maintain control of the airplane while maneuvering at a low altitude, which resulted in a stall and subsequent spin from which he was unable to recover.NTSB CEN13LA054Accident · 1 fatalLimited investigationFinal reportCessna P210N · Conway, ARThe pilot's inadequate preflight inspection, which failed to detect the lack of fuel and resulted in fuel exhaustion during climb, and the pilot's subsequent failure to maintain airplane control, which resulted in an aerodynamic stall at low altitude from…NTSB CEN13LA055Accident · Serious injuriesLimited investigationFinal reportCentral Ohio Dragonfly Club DRAGONFLY-C · Darbyville, OHThe total loss of engine power due to a cold-seizure event that occurred at a low altitude, which precluded the pilot's recovery from an inadvertent aerodynamic stall/spin.NTSB CEN13FA045Accident · 1 fatalField investigationFinal reportCessna 150F · Gothenburg, NEThe student pilot’s failure to maintain adequate airspeed on final approach, which resulted in an inadvertent aerodynamic stall and subsequent impact with terrain.NTSB WPR13LA025Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Mariner · Lake Havasu, AZThe pilot’s unintentional and unrecognized entry into a vortex ring state as a result of conducting a course reversal turn into a tailwind while at a low altitude and airspeed, which resulted in an uncontrolled descent into water.NTSB ERA13FA032Accident · 2 fatalField investigationFinal reportSwift Museum Foundation GC-1A · East Moriches, NYThe failure of the pilot to maintain airspeed, while attempting a precautionary landing for reasons that could not be determined from the available evidence. Contributing to the accident was the pilot’s pitch-up reaction to birds that took flight during his…NTSB ERA13LA018Accident · No injuriesLimited investigationFinal reportSikorsky S-55B · Yorktown, NYThe pilot's improper decision to perform a downwind precautionary landing and the helicopter’s resultant settling with power and impact with terrain.NTSB ERA13LA015Accident · Serious injuriesLimited investigationFinal reportVelline'S Breezy RLU-1 · Madison, GAThe pilot’s failure to maintain airspeed following a loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation, and the airplane’s…NTSB CEN13CA005Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Colorado Springs, COThe pilot’s failure to maintain airspeed during the landing with known structural icing, which resulted in the airplane’s stall. Contributing to the accident was the pilot’s failure to divert to an area where conditions were not conducive to icing.NTSB WPR13LA002Accident · 1 fatalLimited investigationFinal reportWood Mustang II FB · San Manuel, AZThe pilot's failure to maintain adequate airspeed while maneuvering to final approach due to his distraction by the low engine oil pressure, which resulted in an aerodynamic stall.NTSB WPR13LA003Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Rockport, WAThe pilot's failure to maintain sufficient rotor rpm during a precautionary landing, which resulted in a hard landing.NTSB ANC12CA115Accident · No injuriesData collectionFinal reportCessna 182A · Port Lions, AKThe pilot's decision to take off with ice- and snow-contaminated wings.NTSB WPR12TA436Accident · Minor injuriesFinal reportMcdonnell Douglas Heli 369FF · Las Vegas, NVThe pilot’s failure to maintain sufficient airspeed while performing a 270-degree practice autorotation with a gusting tailwind at a high-density altitude.NTSB WPR12FA432Accident · 1 fatalField investigationFinal reportKundel Vans RV 7A · Laramie, WYThe pilot’s decision to attempt a landing with a gusting tailwind, which resulted in his loss of airplane control during final approach and a subsequent aerodynamic stall/spin.NTSB ERA12LA586Accident · No injuriesLimited investigationFinal reportStewart Mw/Stewart JD Sonerai 2L · Titusville, FLThe pilot's failure to attain the proper landing approach speed and touchdown point, which resulted in a runway excursion after touchdown and collision with a ditch.NTSB ERA12FA567Accident · Minor injuriesField investigationFinal reportBeech 400 · Macon, GAThe pilot’s failure to maintain proper airspeed, which resulted in the airplane touching down too fast on the wet runway with inadequate runway remaining to stop and a subsequent runway overrun. Contributing to the landing overrun were the flight crewmembers’…NTSB ANC12LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Talkeetna, AKThe flight instructor's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an inadvertent stall.NTSB CEN12LA636Accident · 1 fatalLimited investigationFinal reportJDT Mini-Max 1500R · Cameron, MOThe pilot's failure to maintain adequate airspeed during initial climb, which resulted in an aerodynamic stall and spin at a low altitude.NTSB CEN12FA638Accident · 1 fatalField investigationFinal reportMchenry George B JR KR2S · Pueblo, COThe pilot’s loss of airplane control while maneuvering to land, which resulted in a stall and uncontrolled descent.NTSB WPR12FA421Accident · No injuriesField investigationFinal reportFrederick F 1 · Reno, NVThe pilot’s operation of the airplane above the established never-exceed speed and the incorrect installation of the trim tab control horn, which resulted in the flutter of the left elevator trim tab.NTSB ERA12FA561Accident · 2 fatalField investigationFinal reportHall Don H RV-7 · Cumming, GAThe pilot’s failure to maintain airspeed while maneuvering, resulting in an aerodynamic stall and collision with terrain.NTSB CEN12CA656Accident · Minor injuriesData collectionFinal reportFairchild PT-19A · Cape Girardeau, MOThe pilot’s failure to maintain sufficient airspeed during a low approach, which resulted in an aerodynamic stall.NTSB WPR12LA410Accident · 1 fatalLimited investigationFinal reportSchoepflin DA-4-550 · Viola, IDThe pilot's failure to maintain airplane control while maneuvering, resulting in an aerodynamic stall/spin with insufficient altitude to recover.NTSB DCA12IA141Incident · No injuriesIncident investigationFinal reportDe Havilland DHC8 · Soldotna, AKan in-flight loss of control due to the flight crew's inattention to airspeed, pitch attitude, and engine power during the climb leading to an aerodynamic stall. Contributing to the incident was the flight crew's failure to recognize and properly recover from…NTSB WPR12FA395Accident · 1 fatalField investigationFinal reportSkykits USA Savannah ADV · Murtaugh, IDThe pilot's failure to maintain adequate airspeed while maneuvering at or above the airplane's maximum ceiling, which resulted in a stall and a subsequent loss of airplane control. Contributing to the accident was the pilot's decision to operate the airplane…NTSB ANC12LA096Accident · Serious injuriesLimited investigationFinal reportTaylorcraft F21 · Willow, AKThe pilot’s failure to maintain control of the airplane after a loss of engine power during takeoff due to carburetor ice.NTSB CEN12LA605Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G 103 Twin II · El Paso, TXThe pilot‘s failure to maintain glider control while attempting to take off using a ground winch, which resulted in an inadvertent stall low to the ground. Contributing to the accident was the ground winch, which was unable to produce enough speed for a…NTSB CEN12FA601Accident · 1 fatalField investigationFinal reportAeronca 7AC · Brighton, MIThe pilot’s failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the severity of…NTSB WPR12LA396Accident · No injuriesLimited investigationFinal reportBeech G35 · Oceano, CAThe pilot’s exceedance of the design maneuvering speed during descent in turbulence, which resulted in structural damage to the aft fuselage.NTSB CEN12CA588Accident · Minor injuriesData collectionFinal reportTrick Trikes Stss · Wanamingo, MNThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.NTSB ERA12FA513Accident · 1 fatalField investigationFinal reportMcleod Alan FW-190 1/2 Scale · Columbus, GAThe pilot’s failure to maintain airspeed while maneuvering following a partial loss of engine power. Contributing to the accident was the pilot’s decision not to land on the remaining runway ahead, and the partial loss of engine power due to carburetor ice.NTSB CEN12LA541Accident · No injuriesLimited investigationFinal reportCessna 177RG · Litchfield, ILThe pilot's failure to maintain airplane control during the landing and the subsequent aborted landing.NTSB CEN12FA534Accident · 1 fatalField investigationFinal reportBeech G18 - S · Taylorville, ILThe pilot's failure to maintain adequate airspeed and use the appropriate flaps setting during sport-parachuting operations, which resulted in an aerodynamic stall/spin and a subsequent loss of control. Contributing to the accident was the pilot’s failure to…NTSB CEN12LA538Accident · No injuriesLimited investigationFinal reportCantlon Starduster Too SA300 · Galion, OHThe pilot's failure to maintain directional control and a proper pitch attitude and airspeed while performing an aborted landing.NTSB CEN12LA529Accident · No injuriesLimited investigationFinal reportPiper PA32RT · Palo Pinto, TXThe pilot's failure to maintain directional control and a proper pitch attitude and airspeed while performing a go-around.NTSB CEN12CA509Accident · No injuriesData collectionFinal reportCessna 182Q · Three Lakes, WIThe pilot's excessive touchdown speed, which resulted in a bounced landing. Contributing to the accident was the pilot's lack of recent experience in flying light airplanes.NTSB CEN12LA490Accident · Serious injuriesLimited investigationFinal reportSmith Applebay Zuni II · Gregory, MIThe glider pilot’s failure to maintain sufficient altitude and airspeed while turning to the base leg of the traffic pattern, which resulted in a stall/spin and impact with trees and terrain.NTSB WPR12CA320Accident · No injuriesData collectionFinal reportPiper PA-30 · Yelm, WAThe pilot's failure to maintain an adequate airspeed on approach and his inadequate flare, which resulted in a hard landing.NTSB CEN12CA465Accident · Serious injuriesData collectionFinal reportMooney M20J · Oshkosh, WIThe pilot’s excessive airspeed at touchdown and his loss of control of the airplane during the landing roll.NTSB ERA12FA467Accident · 1 fatalField investigationFinal reportBrenholt Larry R RV-4 · Cedartown, GAThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions and his failure to maintain airspeed while maneuvering for a forced landing, which resulted in an aerodynamic stall and collision with terrain.NTSB CEN12LA460Accident · 1 fatalLimited investigationFinal reportChamberlain Gerald Escapade · Rutland, OHThe pilot’s inadequate fuel management, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the inadvertent stall during the pilot’s emergency landing and the pilot’s decision to continue flight in deteriorating…NTSB ERA12FA465Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Berlin, MDPilot incapacitation of unknown origin, which resulted in the airplane’s loss of control and an inadvertent aerodynamic stall/spin.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.