NTSB investigations, IN
34 cases where NTSB found Airspeed.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 3 |
| 2019 | 3 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 2 |
Where
Latest 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\" = 'IN' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'IN' AND c."eventCountry" = 'USA' 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 CEN26LA146Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Madison, INThe pilot’s failure to maintain proper airspeed during takeoff and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN26LA106Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Lafayette, INThe flight instructor's inadequate supervision of the student during a stall recovery that developed into unusual attitude and exceedance of the airplane’s never exceed airspeed which resulted in structural damage to the airplane.NTSB CEN25LA385Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver MX II · Rossville, INThe pilot's failure to maintain adequate airspeed while maneuvering at a low altitude, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's distraction.NTSB CEN25LA382Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · South Bend, INThe pilot’s failure to maintain control of the airplane during a go around which resulted in an aerodynamic stall. Contributing to the accident was the loss of directional control during the landing roll.NTSB CEN24FA340Accident · 4 fatalClass 3 · FieldFinal reportPiper PA 46-350P · Anderson, INThe pilot’s inadequate airspeed management during the missed approach which resulted in an inadvertent aerodynamic stall and loss of control at low altitude.NTSB CEN24LA309Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Salem, INThe pilot’s excessive airspeed during a landing, which resulted in a runway overrun and collision with terrain.NTSB CEN24FA278Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-602 · Oxford, INThe pilot’s exceedance of the airplane’s critical angle of attack and failure to maintain adequate airspeed while maneuvering during an agricultural flight, which resulted in an aerodynamic stall and a loss of control at too low of an altitude to recover.…NTSB CEN22LA292Accident · No injuriesClass 4 · LimitedFinal reportMagnaghi Aeronautica SKY Arrow LSA · West Lafayette, INThe pilot’s failure to maintain proper airspeed while landing in gusting winds, which resulted in a hard landing and a runway excursion.NTSB CEN21LA262Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150H · Muncie, INThe non-certificated pilot's failure to maintain aircraft control on departure in high density altitude conditions which resulted in an aerodynamic stall.NTSB CEN19LA225Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T188 · Knox, INThe pilot's exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and loss of airplane control.NTSB CEN19FA148Accident · 2 fatalClass 2 · FieldFinal reportCessna S550 · Greenfield, INThe pilot's failure to fully advance the power levers during the takeoff and initial climb, which led to his failure to maintain sufficient airspeed and resulted in the exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB CEN19FA135Accident · Serious injuriesClass 2 · FieldFinal reportPiper PA34 · Anderson, INThe loss of left engine power due to an incorrectly adjusted fuel servo and the airplane's nose up trim which resulted in the airplane steep climb, loss of airspeed, and aerodynamic stall and subsequent impact with terrain.NTSB CEN19FA044Accident · 1 fatalField investigationFinal reportPiper PA24 · Valparaiso, INThe pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall and spin.NTSB CEN19FA035Accident · 1 fatalField investigationFinal reportPiper PA 30 · Marion, INThe pilot's exceedance of the airplane's critical angle of attack following a loss of the left engine power shortly after takeoff, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the loss of left…NTSB CEN18LA165Accident · Serious injuriesLimited investigationFinal reportPiper PA 34-200 · Valparaiso, INThe pilot receiving instruction’s failure to maintain a safe operating airspeed, which resulted in a loss of airplane control. Contributing to the accident was the flight instructor's failure to monitor the pilot's airspeed control.NTSB CEN17LA144Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Fort Wayne, INThe pilot receiving instruction’s failure to maintain airplane control during a crosswind landing in high gusting winds, and the flight instructor’s failure to maintain a proper airspeed and angle of attack during the go-around, which resulted in an…NTSB CEN16FA216Accident · 2 fatalField investigationFinal reportCessna 150F · Rockville, INThe pilot's use of an improper soft-field takeoff procedure, which resulted in the airplane having insufficient airspeed to climb out of ground effect and its subsequent impact with trees near the departure end of the runway.NTSB GAA16LA329Accident · Serious injuriesLimited investigationFinal reportMini Max 1200 · Batesville, INThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to depart without obtaining flight training in the…NTSB CEN16LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA24 · Kentland, INThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical anomalies that would have precluded normal operation. Contributing to the accident was the flight…NTSB CEN15CA373Accident · No injuriesData collectionFinal reportErcoupe 415-C · Alexandria, INThe pilot's failure to maintain/attain adequate airspeed and attitude during landing that resulted in a hard landing. Contributing was the pilot's diverted attention to air traffic and the reduction of perceptible audio cues due to noise attenuating headsets.NTSB CEN14CA481Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Plymouth, INThe sun glare and the pilot's subsequent loss of airplane control.NTSB CEN14LA243Accident · 1 fatalLimited investigationFinal reportHoffius Stowe Challenger II · Attica, INThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack while maneuvering at low altitude, which led to an aerodynamic stall and loss of control. Contributing to the accident was the installation of an…NTSB CEN14LA045Accident · No injuriesLimited investigationFinal reportSutphin Rans S-12 · French Lick, INThe pilot's failure to maintain adequate airspeed while in a steep turn, which resulted in an aerodynamic stall/mush at a low altitude.NTSB CEN13LA455Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lafayette, INThe pilot’s failure to maintain adequate airspeed in gusting wind conditions during the initial climb after takeoff, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.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 CEN11FA645Accident · 2 fatalField investigationFinal reportRemos Aircraft Gmbh Flugzeugba GX · Noblesville, INThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude. Contributing was the pilot's decision to maneuver at an altitude below that required for congested areas, which did not afford an adequate margin for stall recovery.NTSB CEN11LA194Accident · 1 fatalLimited investigationFinal reportTaylorcraft DCO-65 · Americus, INThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall.NTSB CEN11CA004Accident · No injuriesData collectionFinal reportCessna 172N · Wabash, INThe student pilot's failure to maintain proper airspeed during the landing and certificated flight instructor's failure to execute a go-around.NTSB CEN10CA301Accident · No injuriesData collectionFinal reportCessna 421B · Anderson, INThe pilot’s failure to establish proper rotation and liftoff speed during the takeoff roll.NTSB CEN10FA233Accident · 2 fatalField investigationFinal reportJetProp DLX Piper PA46 · New Albany, INThe pilot’s failure to maintain airspeed in instrument meteorological conditions, which resulted in an aerodynamic stall.NTSB CEN09CA435Accident · No injuriesData collectionFinal reportFlight Design Ctsw · North Vernon, INThe pilot's improper landing flare which resulted in a stall and nose over during touchdown.NTSB CEN09CA317Accident · Serious injuriesData collectionFinal reportCessna 182E · Martinsville, INThe pilot's failure to attain the proper touchdown point during landing and his delay in initiating a successful go-around, which resulted in a loss of airspeed and an aerodynamic stall.NTSB CEN09CA131Accident · No injuriesData collectionFinal reportCessna 150M · Sellersburg, INThe student pilot's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall at a low altitude. An additional cause was the flight instructor's delayed remedial action.NTSB CEN09LA088Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B16 · Gary, INThe pilot's excessive airspeed and improper flare while landing in gusting winds.