NTSB investigations, 2009
839 cases where NTSB found Aircraft oper/perf/capability.
Cases per year
| 2008 | 816 |
|---|---|
| 2009 | 839 |
| 2010 | 676 |
| 2011 | 755 |
| 2012 | 751 |
| 2013 | 642 |
| 2014 | 708 |
| 2015 | 664 |
| 2016 | 737 |
| 2017 | 719 |
| 2018 | 729 |
| 2019 | 691 |
| 2020 | 598 |
| 2021 | 590 |
| 2022 | 625 |
| 2023 | 591 |
| 2024 | 560 |
| 2025 | 432 |
| 2026 | 216 |
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 year(c.\"eventDate\") = 2009
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0106'))
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") = 2009 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0106')) 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 ANC10LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKThe pilot’s failure to ensure that the airplane’s fuel selector valve was on before takeoff, resulting in a loss of engine power due to fuel starvation, and his subsequent decision to attempt a low altitude turn towards the departure airport, resulting in an…NTSB CEN10CA086Accident · No injuriesData collectionFinal reportHoover Frank RV-8 · Houma, LAThe pilot's failure to maintain directional control during the landing roll.NTSB CEN10CA089Accident · Minor injuriesData collectionFinal reportLyman Randall/Scott David Avid Flyer · Eldon, MOThe pilot's inability to climb or maintain proper airspeed due to the improper pitch setting of the propeller.NTSB ERA10FA099Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Heflin, ALThe student pilot's failure to maintain adequate airspeed during night, adverse weather conditions, which resulted in an aerodynamic stall/spin. Contributing to the accident was the student pilot's decision to attempt a flight that he was not qualified for…NTSB WPR10CA089Accident · No injuriesData collectionFinal reportCessna 172M · Albion, IDThe pilot's failure to maintain clearance from mountainous terrain while maneuvering in gusting winds.NTSB WPR10CA096Accident · No injuriesData collectionFinal reportStinson SR-8B · Auburn, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA10LA098Accident · Serious injuriesLimited investigationFinal reportCzech Aircraft Works Sportcruiser · Suffolk, VAThe pilot's inadequate recovery from a stall and inadvertent spin. Contributing to the accident was the improperly marked airspeed indicator and the airplane manufacturer's improper airspeed information. Also contributing was the instructor's inadequate…NTSB WPR10CA088Accident · No injuriesData collectionFinal reportAviat A1-A · West Jordon, UTThe pilot's failure to maintain directional control of the airplane during the landing roll in gusting wind conditions.NTSB CEN10CA082Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Abilene, TXThe pilot's failure to maintain directional control during the air taxi with shifting winds.NTSB CEN10CA077Accident · No injuriesData collectionFinal reportCessna 172P · Ames, IAThe pilot's failure to maintain directional control while attempting a takeoff on an ice-covered runway.NTSB ANC10CA010Accident · No injuriesData collectionFinal reportStinson 108-1 · Selawik, AKThe pilot's failure to maintain a proper descent rate during landing, resulting in a hard landing.NTSB WPR10LA082Accident · Minor injuriesLimited investigationFinal reportEADS Socata TBM 700 · Truckee, CAThe pilot’s failure to maintain an adequate airspeed and clearance from terrain during an attempted go-around. Contributing to the accident was the pilot's decision to land on a partially obscured runway.NTSB CEN10LA074Accident · Serious injuriesLimited investigationFinal reportGibson Mark Manta 503 · Magnolia, TXThe pilot's failure to maintain clearance from a static wire while maneuvering and his improper decision to fly with a low overcast sky.NTSB WPR10CA081Accident · No injuriesData collectionFinal reportCessna 182P · Payson, AZThe pilot's improper landing flare, which resulted in a hard landing.NTSB CEN10CA075Accident · No injuriesData collectionFinal reportCessna 172 · Pearland, TXThe student pilot's failure to control the airplane's descent rate during the short-field landing, resulting in a hard landing. Contributing to the accident was the flight examiner's delayed response.NTSB WPR10FA078Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Ojai, CAAirspeed was not maintained, which resulted in a loss of control and the airplane entering into a stall/spin to the ground. Contributing to the accident was a loss of engine power due to carburetor icing.NTSB ERA10FA091Accident · 4 fatalField investigationFinal reportCessna 172S · Kissimmee, FLThe pilot's decision to depart under special VFR flight at night when instrument meteorological conditions prevailed at the departure airport and along the route of flight and his continued VFR flight into instrument meteorological conditions, which resulted…NTSB CEN10FA065Accident · 2 fatalField investigationFinal reportNew Piper PA-46-500TP · Mendoza, TX***This report was modified on May 22, 2014. Please see the docket for this accident to view the original report.*** The pilot's spatial disorientation, which resulted in his loss of airplane control. Contributing to the pilot's spatial disorientation was the…NTSB WPR10CA073Accident · No injuriesData collectionFinal reportCessna 172M · Diamond Point, WAThe pilot's inadequate compensation for the variable and unfavorable wind conditions.NTSB ERA10LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Hatteras, NCThe pilot's inability to maintain directional control during an aborted takeoff for undetermined reasons.NTSB CEN10LA068Accident · No injuriesLimited investigationFinal reportBeech V35 · Dodge City, KSThe failure of the pitot heat system in icing conditions resulting in an inoperative airspeed indicator which led to an inadvertant stall while on final approach. Contributing to the accident was the pilot's decision to fly into known icing conditions.NTSB WPR10LA072Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Clarksburg, CAThe pilot’s improper touchdown point and excessive airspeed during landing, which resulted in a runway overrun.NTSB WPR10CA086Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Nogales, AZThe student's improper landing flare and the flight instructor's inadequate remedial action.NTSB CEN10CA062Accident · No injuriesData collectionFinal reportCessna 172S · Mt. Comfort, INThe pilot's failure to maintain directional control of the airplane while touching down during the landing.NTSB WPR10LA069Accident · Serious injuriesLimited investigationFinal reportMahre Starduster SA300 · Zillah, WAThe pilot’s failure to maintain aircraft control during a low-altitude maneuver.NTSB ERA10LA086Accident · 2 fatalLimited investigationFinal reportCox Busby Mustang · Plant City, FLThe pilot’s failure to maintain adequate airspeed following a loss of engine power for undetermined reasons.NTSB ERA10LA085Accident · Serious injuriesLimited investigationFinal reportTail Feather Sea Rey · Sanibel Island, FLThe pilot’s failure to add power during a low-level turn, which resulted in a loss of airspeed and a subsequent stall.NTSB ERA10LA082Accident · 1 fatalLimited investigationFinal reportPiper PA-32RT-300 · Memphis, TNThe pilot's failure to execute a timely missed approach and subsequent failure to maintain aircraft control, after he was unable to establish the airplane on the instrument approach. Contributing to the accident was the pilot's possible impairment due to his…NTSB WPR10CA071Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Stockton, CAThe pilot’s inadequate compensation for a crosswind condition.NTSB WPR10CA067Accident · Minor injuriesData collectionFinal reportPiper PA-25-260 · Llano, CAThe pilot's inadequate compensation for the gusting crosswind conditions and failure to maintain lateral and directional control.NTSB WPR10CA066Accident · Minor injuriesData collectionFinal reportNephew Alan H Kitfox · Agua Caliente Springs, CAThe pilot's failure to maintain an adequate glide path that ensured obstacle clearance during final approach to land.NTSB WPR10CA065Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Long Beach, CAThe flight instructor's failure to arrest the helicopter's descent and to maintain lateral control during a hovering autorotation practice.NTSB WPR10CA064Accident · Minor injuriesData collectionFinal reportBell Helicopter Textron 206L-1 · Grand Canyon, AZThe pilot's failure to maintain control of the helicopter.NTSB ERA10FA088Accident · 1 fatalField investigationFinal reportPiper PA-30 · Raneille, WVThe pilot's improper decision to attempt visual flight into deteriorating night weather conditions, and his subsequent controlled flight into terrain.NTSB CEN10FA057Accident · 1 fatalField investigationFinal reportCessna 182P · Kewanee, ILThe pilot's decision to initiate a visual night flight without recent night flight experience and his failure to maintain altitude during departure.NTSB ERA10CA078Accident · No injuriesData collectionFinal reportCessna 172 · Panancea, FLThe pilot's failure to maintain directional control during the landing rollout.NTSB CEN10CA061Accident · No injuriesData collectionFinal reportCessna 305A · Rochester, INThe pilot's failure to maintain directional control during landing.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 WPR10CA062Accident · No injuriesData collectionFinal reportCessna 172 · Yucca Valley, CAThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control of the airplane.NTSB WPR10CA061Accident · Minor injuriesData collectionFinal reportBoeing A75N1 · Deer Valley, AZThe pilot's failure to maintain directional control.NTSB ERA10CA071Accident · No injuriesData collectionFinal reportCirrus SR-22 · Everglades City, FLThe pilot's failure to maintain directional control during the attempted go-around.NTSB ERA10CA087Accident · Minor injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2004 Bravo · Ashland, VAThe pilot’s failure to maintain adequate clearance from trees during the landing approach.NTSB ERA10CA075Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Lebanon, PAThe pilot’s failure to arrest the helicopter descent during the simulated engine out maneuver resulting in a hard landing.NTSB ERA10CA068Accident · No injuriesData collectionFinal reportCessna C185F · Auburn, METhe pilot’s failure to maintain directional control while landing.NTSB WPR10CA057Accident · No injuriesData collectionFinal reportBell 206B · Lyons, ORThe pilot's inadvertent encounter with a vortex ring state (settling with power) condition while he was descending, and his improper initial remedial action.NTSB ERA10CA069Accident · No injuriesData collectionFinal reportParadise USA Paradise P-1 Slsa LW · Plant City, FLThe pilot's improper flare while landing, which resulted in a hard landing.NTSB ERA10CA076Accident · No injuriesData collectionFinal reportClassic Waco YMF · Dunnellon, FLThe certified flight instructor’s delayed response to the student pilot's loss of directional control while landing, which resulted in a ground-loop. Contributing to the accident was the student pilot's loss of directional control.NTSB ERA10CA067Accident · No injuriesData collectionFinal reportRobert Wood Thorp T18 · Newburgh, NYThe pilot's failure to maintain directional control during the landing rollout.NTSB ERA10LA066Accident · 2 fatalLimited investigationFinal reportPiper PA-28-140 · Newcomb, NYThe pilot’s failure to maintain clearance from mountainous terrain during descent at night, with low clouds and fog.NTSB ERA10LA063Accident · Minor injuriesLimited investigationFinal reportCurtiss Wright Travel AIR · Fort Myers, FLThe pilot's improper recovery from a bounced landing and failure to maintain directional control, which resulted in a ground loop. Contributing to the accident was the pilot's minimal experience in the airplane make and model.