NTSB investigations, 2009
231 cases where the defining event was Loss of control in flight.
Cases per year
| 2008 | 253 |
|---|---|
| 2009 | 231 |
| 2010 | 202 |
| 2011 | 247 |
| 2012 | 241 |
| 2013 | 213 |
| 2014 | 246 |
| 2015 | 216 |
| 2016 | 217 |
| 2017 | 215 |
| 2018 | 194 |
| 2019 | 232 |
| 2020 | 198 |
| 2021 | 191 |
| 2022 | 195 |
| 2023 | 171 |
| 2024 | 141 |
| 2025 | 155 |
| 2026 | 82 |
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\") = 2009
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '240') 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 ERA10WA106Accident · 1 fatalForeign investigationHughes 369 · Pitalito, ColombiaOn December 29, 2009, about 1655 universal coordinated time (1155 local time), a Hughes 369D, Colombian registration HK4177, operated by Sociedad Aerea de Ibague, was substantially damaged during a forced landing in Pitalito, Huila, Colombia. The Colombian…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 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 ERA10WA096Accident · 1 fatalForeign investigationHuber Hartmut Express · Berry Island, BahamasOn December 12, 2009, at 1300 UTC, an experimental, amateur-built Harmut Huber Express, N93HE, operated by a private individual, crashed into the water on short final approach to Chub Cay Airport (MYBC), Berry Island, Bahamas. The pilot was killed and the…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 CEN10FA063Accident · 1 fatalField investigationFinal reportPiper PA-31T2 · Harrison, MIA loss of aircraft control for undetermined reasons.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 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 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 ERA10CA071Accident · No injuriesData collectionFinal reportCirrus SR-22 · Everglades City, FLThe pilot's failure to maintain directional control during the attempted go-around.NTSB WPR10LA059Accident · 1 fatalLimited investigationFinal reportCessna 182K · Susanville, CAThe pilot's decision to takeoff into weather conditions conducive to ice accumulation, which resulted in an inadvertent stall/spin while maneuvering in the initial climb. Contributing to the accident was the likely accumulation of snow and ice on the airborne…NTSB WPR10FA055Accident · 3 fatalField investigationFinal reportAerospatiale AS350BA · Doyle, CAThe pilot became spatially disoriented while maneuvering on a dark night, which resulted in a loss of helicopter control.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 DCA10RA031Accident · No injuriesForeign investigationBeech 1900 - D · Nairobi, KenyaOn November 9, 2009 about 0517 UTC, Kenyan registry 5Y-VVQ, a Beech 1900D, a chartered cargo flight, had a loss of control and collided with the ground during a visual approach for landing at Wilson Airport, Nairobi, Kenya. The airplane had turned back to…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 CEN10LA049Accident · 1 fatalLimited investigationFinal reportLockwood AIR-CAM · Mount Victory, OHThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall and spin. Contributing to the accident was the pilot's unfamiliarity with the airplane subsequent to float installation.NTSB CEN10CA045Accident · No injuriesData collectionFinal reportCessna 150H · Paoli, INThe pilot's failure to maintain directional control of the airplane during landing.NTSB ANC10LA006Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Kenai, AKThe pilot's decision to fly at a low altitude in strong winds and turbulence, resulting in a loss of control and a collision with terrain.NTSB WPR10LA046Accident · Serious injuriesLimited investigationFinal reportEurocopter AS350BA · Globe, AZThe pilot receiving instruction’s failure to maintain adequate airspeed or control of the helicopter during a simulated hydraulic failure maneuver, which resulted in a hard landing. Contributing to the accident was the flight instructor’s delayed remedial…NTSB ERA10FA048Accident · 2 fatalField investigationFinal reportCessna 172S · Tallahassee, FLThe pilots' spatial disorientation during flight in dark conditions, which resulted in an uncontrolled descent into terrain.NTSB ERA10CA045Accident · No injuriesData collectionFinal reportBeech 77 · Gainesville, FLThe pilot's failure to maintain aircraft control during landing.NTSB ERA10FA040Accident · 2 fatalField investigationFinal reportCessna 310J · Lawrenceville, GAThe pilot’s loss of aircraft control while maneuvering in instrument meteorological conditions, as a result of spatial disorientation.NTSB ERA10WA060Accident · 2 fatalForeign investigationRobinson R22B · Verona, ItalyOn October 26, 2009, at 1300 coordinated universal time, a Robinson R22B helicopter, Italian registration I-ANSO, was substantially damaged when it impacted water in Lake Garda, near Verona, Italy. The pilot and a passenger were fatally injured. Visual…NTSB CEN10FA028Accident · 4 fatalField investigationFinal reportBeech B100 · Benavides, TXThe pilot's failure to avoid severe weather, and the air traffic controller's failure to provide adverse weather avoidance assistance, as required by Federal Aviation Administration directives, both of which led to the airplane's encounter with a severe…NTSB CEN10FA027Accident · 2 fatalField investigationFinal reportCommander 114-B · Adrian, MIThe pilot did not maintain control of the airplane due to spatial disorientation while on an instrument approach in instrument meteorological conditions.NTSB ERA10LA025Accident · Serious injuriesLimited investigationFinal reportArgence Enas A. Christen Eagle · Hernando, MSThe pilot's failure to maintain adequate airspeed during a return to the airport, which resulted in an aerodynamic stall and spin.NTSB CEN10WA058Accident · 2 fatalForeign investigationPilatus PC12 · Weert, NetherlandsOn October 16, 2009, at 0730 universal coordinated time, a Pilatus PC-12/47 airplane, Dutch registered PH-RUL, registered to E.S. Management BV, was destroyed when it impacted terrain near Weert, The Netherlands. Visual meteorological conditions prevailed at…NTSB WPR10CA015Accident · Serious injuriesData collectionFinal reportLet Blanik L-13 · Llano, CAThe student pilot's improper use of the airbrakes while on approach for landing.NTSB ANC10CA002Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Nondalton, AKThe pilot's decision to attempt a landing in weather conducive to strong downdrafts, resulting in a loss of control.NTSB WPR10LA010Accident · 1 fatalLimited investigationFinal reportCruz SE5A Replica · Phoenix, AZThe pilot's failure to maintain airspeed during initial climb, which resulted in a stall/spin and impact with the ground.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 WPR10FA009Accident · 1 fatalField investigationFinal reportPiper PA-12 · Burlington, WAThe pilot's in-flight loss of control due to his failure to correctly connect the elevator control cables during the restoration/rebuild of the airplane. Contributing to this accident was the pilot's decision to perform a high-speed taxi test prior to having…NTSB ERA10CA010Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Lewiston, METhe loss of tail rotor effectiveness (LTE) resulting from hovering the helicopter in a tailwind.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 CEN09LA611Accident · 1 fatalLimited investigationFinal reportMckenna James E AVID-CATAL · Inks Lake, TXThe pilot’s decision to take off with a known airframe deficiency.NTSB ERA09WA546Accident · 2 fatalForeign investigationPiper PA18 · Barbones, Ecuador, EcuadorOn September 25, 2009, about 1330 central standard time, a Piper PA-18-150, Ecuadorian registration HC-AHD, registered to and operated by FumiPalma S.A., crashed following a loss of engine power, while on an approach for landing at the Pista Bardones, El Oro,…NTSB ERA09CA545Accident · No injuriesData collectionFinal reportKermit Weeks Quicksilver · Polk City, FLThe pilot’s failure to adequately inspect the landing gear floats for water prior to takeoff.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 WPR09FA459Accident · 2 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Forest Grove, ORThe flight crew’s failure to maintain adequate main rotor speed while maneuvering, which resulted in a main rotor blade stall and an uncontrolled descent into terrain.NTSB ERA09LA527Accident · 2 fatalLimited investigationFinal reportCessna 172 · Lowndesville, SCThe pilot's inadequate preflight planning and improper decision to continue flight into deteriorating weather conditions, which resulted in spatial disorientation after entering instrument flight conditions.NTSB WPR09LA451Accident · No injuriesLimited investigationFinal reportRaytheon B200 · Hayward, CAThe pilot's failure to maintain directional control after takeoff. Contributing to the accident was the pilot's inadequate preflight and failure to follow the airplane manufacturer's checklist to ensure that the rudder trim control and right propeller control…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 WPR09LA432Accident · Serious injuriesLimited investigationFinal reportCessna P206B · Truckee, CAThe pilot’s failure to maintain adequate airspeed for flight, which resulted in an aerodynamic stall and subsequent impact with the ground. Contributing to the accident was the intermittent failure of the stall warning system due to a contaminated switch.NTSB WPR09LA442Accident · Serious injuriesLimited investigationFinal reportSix Chuter SR 7 · Hooper, UTThe non-certificated pilot’s failure to maintain an adequate airspeed for the powered parachute while maneuvering at a low altitude.NTSB ERA09LA503Accident · 1 fatalLimited investigationFinal reportPiper PA-11 · Quincy, FLThe pilot’s improper use of flight controls following a partial loss of engine power for undetermined reasons. Contributing to the accident was the pilot’s impairment from the use of an over-the-counter sedating antihistamine.NTSB ERA09LA501Accident · 2 fatalLimited investigationFinal reportKeithley Thomas E Starduster Too · St. Matthews, SCA loss of airplane control during approach for undetermined reasons.