NTSB investigations, 2009
160 cases where NTSB found Performance/control parameters, general.
Cases per year
| 2008 | 101 |
|---|---|
| 2009 | 160 |
| 2010 | 86 |
| 2011 | 103 |
| 2012 | 81 |
| 2013 | 99 |
| 2014 | 104 |
| 2015 | 68 |
| 2016 | 50 |
| 2017 | 63 |
| 2018 | 64 |
| 2019 | 59 |
| 2020 | 48 |
| 2021 | 27 |
| 2022 | 41 |
| 2023 | 44 |
| 2024 | 45 |
| 2025 | 17 |
| 2026 | 9 |
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\", '01062000'))
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", '01062000')) 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 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 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 WPR10CA064Accident · Minor injuriesData collectionFinal reportBell Helicopter Textron 206L-1 · Grand Canyon, AZThe pilot's failure to maintain control of the helicopter.NTSB ERA10CA065Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Georgetown, KYThe pilot's failure to maintain adequate clearance from the surface during lateral hover, which resulted in dynamic rollover.NTSB ERA10CA064Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Pahokee, FLThe pilot’s failure to maintain control of the helicopter.NTSB CEN10LA050Accident · 1 fatalLimited investigationFinal reportAugustine David L Sonex · Burnet, TXThe pilot’s failure to maintain aircraft control, resulting in an aerodynamic stall. Contributing to the accident was the loss of engine power due to a clogged fuel screen that resulted in fuel starvation caused by the builder's inappropriate use of a fuel…NTSB CEN10FA044Accident · 3 fatalField investigationFinal reportBeech A36 · Spring Branch, TXThe pilot's failure to maintain control of the airplane during cruise flight in instrument meteorological conditions. Contributing to this accident was the pilot’s lack of recent experience in flying in instrument meteorological conditions.NTSB CEN10LA041Accident · 2 fatalLimited investigationFinal reportWicks Air Center Hornet · Bonham, TXThe pilot's loss of control shortly after takeoff due to spatial disorientation in fog and/or low-level clouds.NTSB ERA10CA033Accident · No injuriesData collectionFinal reportElkins Christen Eagle II · Athens, KYThe pilot's improper liftoff, resulting in a collision with the ground during climbout.NTSB WPR10CA019Accident · Minor injuriesData collectionFinal reportCessna 172S · Honolulu, HIThe student pilot's distraction and subsequent loss of airplane control after the cabin window opened during the takeoff roll.NTSB CEN10LA012Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · Weeping Water, NEThe pilot’s failure to maintain aircraft control resulting in a stall. Contributing to the accident was the stuck exhaust valve resulting in the partial loss of engine power.NTSB WPR10CA013Accident · No injuriesData collectionFinal reportCessna 172H · Tucson, AZThe pilot's failure to maintain directional control during the takeoff ground roll.NTSB CEN10CA013Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Bingham, NEThe pilot's impairment due to alcohol consumption and failure to maintain aircraft control.NTSB ERA10LA007Accident · 1 fatalLimited investigationFinal reportCase Richard L VAN RV-6 · Magnolia, NCThe pilot's continued visual flight into instrument meterological conditions and his subsequent failure to maintain aircraft control. Contributing to the accident was the pilot's inadequate preflight evaluation of the weather.NTSB CEN10CA010Accident · Serious injuriesData collectionFinal reportAerostar International RX-7 · Albuquerque, NMThe pilot’s failure to maintain adequate clearance from a known obstacle and the pilot’s failure to maintain control of the balloon during the sudden climb following the ejection of the passenger.NTSB CEN10LA001Accident · Serious injuriesLimited investigationFinal reportDusenberry Mark J 1905 Wright Flyer · Dayton, OHThe pilot's failure to maintain control of the airplane during the flight, which resulted in an aerodynamic stall.NTSB ERA09LA536Accident · 1 fatalLimited investigationFinal reportDuke Paul Challenger II · Lumberton, MSThe non-certificated pilot’s failure to maintain clearance from trees during a go-around procedure for unknown reasons.NTSB CEN09FA601Accident · 1 fatalField investigationFinal reportCessna T210 · Hilltop Lakes, TXThe loss of control of the airplane in dark night light conditions due to the pilot’s spatial disorientation.NTSB CEN09CA604Accident · No injuriesData collectionFinal reportBell 407 · Fort Worth, TXFailure of the pilot to maintain control during landing.NTSB ANC09CA106Accident · Serious injuriesData collectionFinal reportRittal Alfred Timothy Glastar · Tuluksak, AKA loss of control for an undetermined reason during the takeoff portion of an aborted landing at an off-airport site, resulting in a collision with terrain.NTSB CEN09LA597Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Columbia, MOThe pilot's continued visual flight into instrument meteorological conditions, which included low ceilings and fog, and his failure to maintain control of the airplane. Contributing to the accident was the partial loss of engine power as a result of water…NTSB ANC09CA105Accident · No injuriesData collectionFinal reportPiper PA-22 · Seward, AKThe pilot's selection of unsuitable terrain for takeoff, resulting in a loss of control and a nose over during the takeoff roll.NTSB ERA09CA518Accident · No injuriesData collectionFinal reportPiper PA46 · Chamblee, GAThe pilot's failure to maintain aircraft control during landing. Contributing to the accident was pilot fatigue.NTSB CEN09CA583Accident · No injuriesData collectionFinal reportSierra E5A Replica · Port Huron, MIThe pilot's failure to maintain aircraft control during landing.NTSB ERA09FA515Accident · 1 fatalField investigationFinal reportCirrus SR-22 · Rock Hill, SCThe pilot's failure to maintain aircraft control and altitude while maneuvering after takeoff.NTSB WPR09CA433Accident · No injuriesData collectionFinal reportSwalley Mark H CH 701 SP · Bremerton, WAThe pilot's inadequate compensation for the gusty wind conditions and failure to maintain aircraft control.NTSB ANC09CA093Accident · No injuriesData collectionFinal reportAeronca 15AC · Kotzebue, AKThe pilot's delay in aborting the off-airport landing resulting in a hard landing.NTSB CEN09LA571Accident · Minor injuriesLimited investigationFinal reportMesserschmitt-Boelkow-Blohm BO-105S · Thibodaux, LAThe pilot's inability to maintain control due to the mechanic's inadvertent switching of two cyclic control tubes of different lengths during maintenance.NTSB CEN09CA577Accident · No injuriesData collectionFinal reportKetonen Schreder · Ionia, MIThe pilot failed to maintain control of the glider during the aero-tow launch.NTSB ANC09CA096Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot’s decision to land on unsuitable terrain, which resulted in a loss of control and a collision with trees.NTSB CEN09CA568Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-1C · Holland, MIThe pilot's failure to maintain control of the airplane during the landing and subsequent go-around.NTSB CEN09CA556Accident · No injuriesData collectionFinal reportAlon A2 · Richmond Hts., OHThe pilot's failure to maintain control of the airplane during the landing flare.NTSB CEN09LA543Accident · 2 fatalLimited investigationFinal reportSportflight International Astra HKS · Bloomfield, INThe pilot's failure to maintain control of the airplane while maneuvering.NTSB CEN09CA539Accident · No injuriesData collectionFinal reportDunn David RAF 2000 C · Lakeville, MNThe pilot's failure to maintain control of the aircraft during the landing flare.NTSB CEN09LA527Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-802A · Corning, IAThe in-flight loss of control due to the pilot's impairment as a result of hypoxia. Contributing to the accident was the pilot's decision to operate the unpressurized airplane at an altitude requiring supplemental oxygen without having any oxygen available.NTSB CEN09CA548Accident · No injuriesData collectionFinal reportPiper PA-15 · Plainwell, MIA loss of control on takeoff for undetermined reasons.NTSB ERA09LA452Accident · 1 fatalLimited investigationFinal reportMaxair Drifter · Bumpass, VAThe accelerated stall induced by the pilot in a steep turn to avoid obstacles during takeoff. Contributing to the accident were the pilot’s chosen takeoff path and the density altitude.NTSB ERA09LA450Accident · 2 fatalLimited investigationFinal reportStump Bradley Kolb · Calhoun, TNThe pilot’s decision to perform aerobatics at a low altitude and his failure to maintain control of the airplane while performing aerobatics.NTSB ERA09CA449Accident · No injuriesData collectionFinal reportCessna 182 · Milford, PAThe pilot's failure to maintain control during takeoff.NTSB CEN09LA512Accident · 1 fatalLimited investigationFinal reportHooper James A Bushby MUS · Gladwin, MIThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB CEN09CA509Accident · No injuriesData collectionFinal reportCessna 172S · Bluffton, OHThe student pilot's failure to compensate for wind conditions and maintain aircraft control during the landing.NTSB CEN09CA504Accident · Minor injuriesData collectionFinal reportVanderhoof Steve AIR Comman · Mentone, INThe pilot's failure to maintain aircraft control during the landing and subsequent impact with a parked aircraft.NTSB ERA09TA440Accident · Minor injuriesFinal reportEurocopter AS 350B3 · Jacksonville, FLThe flight instructor's improper decision to attempt hover flight without hydraulic power and his subsequent loss of control.NTSB WPR09LA386Accident · Serious injuriesLimited investigationFinal reportAirborne Windsports PTY XT-912-L · Lihue, HIThe flight instructor's failure to maintain control of the airplane following an in-flight encounter with turbulence during descent.NTSB WPR09LA381Accident · Serious injuriesLimited investigationFinal reportSchempp Hirth Discus CS · Williams, CAThe pilot's failure to maintain clearance with terrain after intentionally releasing from the tow plane at a low altitude during the initial climb.NTSB WPR09LA380Accident · Serious injuriesLimited investigationFinal reportDavenport DAVE-EZ · Santa Monica, CAThe loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control during the forced landing.NTSB WPR09LA378Accident · 1 fatalLimited investigationFinal reportGray RV-6 · Caldwell, IDThe pilot's failure to maintain adequate airspeed that led to a stall/spin while maneuvering in the traffic pattern.NTSB CEN09CA484Accident · Minor injuriesData collectionFinal reportPiper PA22 · Terrell, TXThe pilot's improper decision to continue the approach and landing during thunderstorm activity, resulting in the loss of aircraft control.