NTSB investigations, 2009
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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 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 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 DCA10WA007Incident · No injuriesForeign investigationAirbus A330 · Brisbane, AustraliaOn October 28, 2009, an Airbus A330-200, operated by Jetstar Airways experienced an airspeed anomaly during cruise flight over the equatorial Pacific Ocean area. The was no damage and no injuries. The Australian ATSB is investigating.NTSB ERA10CA036Accident · Serious injuriesData collectionFinal reportBoeing 767-432ER · Atlanta, GAUnforecasted turbulence resulting in a flight attendant being injured.NTSB CEN10LA032Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Walsh, COA partial loss of engine power due to failure of the No. 2 cylinder as a result of the failure of the repair facility to properly torque the lower four nuts on the cylinder.NTSB CEN10LA031Accident · 2 fatalLimited investigationFinal reportAeronca 7AC · Gaylord, MIThe pilot's failure to maintain adequate airspeed during a low altitude turn resulting in an aerodynamic stall/spin and loss of control.NTSB CEN10FA029Accident · 1 fatalField investigationFinal reportBeech A36TC · Kalamazoo, MIThe loss of engine power for an undetermined reason.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 ERA10WA035Accident · 5 fatalForeign investigationHawker BAe-125-800B · Minsk, BelarusOn October 26, 2009, at 1934 universal coordinated time (2134 local standard time), a Hawker-Beech BAe-125-800, Russian registration RA-02807, operated by S-Air, was destroyed when it impacted forested terrain during a go-around attempt at Minsk-2…NTSB ERA10LA041Accident · Serious injuriesLimited investigationFinal reportBoeing 717-200 · Pleasant Grove, NCThe captain's excessive maneuver in response to a traffic alert and collision avoidance system (TCAS) alert, which resulted in a serious injury to a flight attendant. Contributing to the accident was the operator's inadequate TCAS training and guidance.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 CEN10CA033Accident · No injuriesData collectionFinal reportCessna 172N · Marysville, OHThe student pilot's failure to maintain directional control during landing.NTSB WPR10LA032Accident · Serious injuriesLimited investigationFinal reportPowrachute PC 2000 · Leadore, IDThe stuck throttle cable and the pilot's failure to maintain adequate airspeed during landing, which resulted in an inadvertent aerodynamic stall and hard landing.NTSB ERA10LA032Accident · Serious injuriesLimited investigationFinal reportBell 206 · Eupora, MSA loss of engine power due to fuel contamination of the helicopter’s fuel supply.NTSB ERA10LA031Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Brooksville, FLA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight fuel planning.NTSB ERA10FA029Accident · 1 fatalField investigationFinal reportCessna 172P · Bennington, VTThe pilot’s failure to maintain clearance from terrain during a night approach. Contributing to the accident was the pilot’s non-standard traffic pattern over higher terrain.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 WPR10CA084Accident · No injuriesData collectionFinal reportGolden Circle Tierra I · Jensen, UTA loss of engine power, as reported by the pilot, for undetermined reasons.NTSB WPR10CA037Accident · No injuriesData collectionFinal reportSocata TB200 · Edwards, CAThe pilot's improper flare resulting in a hard landing. Contributing to the accident was the sunglare.NTSB WPR10CA031Accident · No injuriesData collectionFinal reportPiper J4 · El Cajon, CAThe left-seat pilot's failure to maintain directional control during the landing roll.NTSB WPR10CA030Accident · No injuriesData collectionFinal reportPiper PA18 · Chandler, AZThe student pilot's failure to maintain directional control while landing.NTSB ERA10FA028Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Zephyrhills, FLA total loss of engine power during a night approach for undetermined reasons.NTSB ERA10CA039Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Scranton, SCThe pilot’s failure to maintain control of the helicopter.NTSB CEN10IA030Incident · No injuriesIncident investigationFinal reportCurtiss Wright P-40E · Lincoln, NEThe right landing gear's partial retraction during landing due to paint contamination of the landing gear handle detent.NTSB WPR10FA029Accident · No injuriesField investigationFinal reportAgusta A119 · Blythe, CAThe loss of engine power during cruise flight for undetermined reasons.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 WPR10CA028Accident · No injuriesData collectionFinal reportEurocopter AS 350 B3 · Marana, AZThe improper use of the throttle by the pilot receiving instruction, and the check pilot's inadequate supervision and delayed remedial action, which resulted in the collision with terrain.NTSB ERA10WA044Accident · 1 fatalForeign investigationBritten Norman BN2A · Kralendijk, Bonaire, NTOn October 22, 2009, about 1417 universal coordinated time, a Britten Norman BN-2A/26, PJ-SUN, experienced a right engine failure during cruise flight, and subsequently ditched in the Caribbean Sea, near Kralendijk, Bonaire, Netherlands Antilles. The airplane…NTSB ERA10LA026Accident · 2 fatalLimited investigationFinal reportFuji LM1 · Athens, GAAn aerodynamic stall shortly after takeoff for undetermined reasons.NTSB ERA10FA027Accident · 2 fatalField investigationFinal reportCessna U206G · Elizabethton, TNThe pilot’s failure to remain clear of rising terrain while maneuvering at low altitude.NTSB DCA10WA005Incident · No injuriesForeign investigationBoeing 737 · Budapest, HungaryOn October 22, 2009, a Sky Airlines Boeing 737-400, registration TC-SKD, conducted an emergency descent due to a rapid decompression and diverted to Budapest Ferihegy International Airport (LHSM), Budapest, Hungary. There were no injuries to the 6 crew…NTSB CEN10CA026Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Grand Forks, NDThe flight instructor's failure to ensure the landing gear was extended prior to landing.NTSB WPR10LA034Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Cedar City, UTThe failure of the landing gear accumulator/regulator and the installation of the improper priority valve, which precluded the landing gear from extending and locking into place.NTSB WPR10FA027Accident · 1 fatalField investigationFinal reportCessna T210G · Provo, UTA total loss of engine power due to fuel starvation as a result of the pilot’s inadequate preflight inspection.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 ERA10FA024Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Summerville, SCFlight into terrain for undetermined reasons.NTSB ERA10CA030Accident · No injuriesData collectionFinal reportCessna 182 · White Plains, NYThe pilot's failure to attain the proper touchdown point, resulting in a landing overrun. Contributing to the accident was the pilot’s excessive airspeed in an attempt to comply with air traffic control’s request to expedite his landing.NTSB DCA10RA010Accident · 6 fatalForeign investigationBoeing 707 · Sharjah, United Arab EmiratesOn October 21, 2009, a Sudan Airways, B-707, registration ST-AKW, crashed shortly after takeoff from runway 30 at Sharjah International Airport, Sharjah, UAE. The six crewmembers on board were fatally injured and the airplane was destroyed. The intended…NTSB DCA10IA001Incident · No injuriesIncident investigationFinal reportAirbus A320 · Minneapolis, MNThe flight crew's failure to monitor the airplane’s radio and instruments and the progress of the flight after becoming distracted by conversations and activities unrelated to the operation of the flight.NTSB DCA10WA004Accident · No injuriesForeign investigationMcdonnell Douglas MD11 · Ciudad de la Costa, UruguayNTSB CEN10CA025Accident · No injuriesData collectionFinal reportCessna 172S · Grand Forks, NDThe student pilot's improper landing flare and recovery from a bounced landing.NTSB OPS10IA001Incident · No injuriesIncident investigationFinal reportBoeing 767 · Atlanta Hartsfield Intl. Apt. (KATL), GAThe flight crew’s failure to identify the correct landing surface due to fatigue. Contributing to the cause of the incident were (1) the flight crew’s decision to accept a late runway change, (2) the unavailability of the approach light system and the…NTSB ERA10LA023Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Winnsboro, SCThe flight instructor's failure to monitor the simulated emergency procedure, resulting in a hard landing. Contributing to the accident was the intentional throttle application by one of the flightcrew.NTSB ENG10WA004Incident · No injuriesForeign investigationBoeing 737 · Melbourne Airport, AustraliaOn October 20, 2009, at 0900 local time, a Virgin Blue Airlines Boeing 737-800 airplane, registration VH-VUI, experienced a failure of the right main landing gear outboard wheel assembly during landing at Melbourne Airport in Melbourne, Australia. No one was…NTSB DCA10WA003Incident · No injuriesForeign investigationBoeing 737 · Manchester, United KingdomOn October 19, 2009, a Thomsonfly Boeing 737-330, registration G-CELI, aborted takeoff after experiencing a right yaw at about 100 knots at Manchester Airport (EGCC), Manchester, United Kingdom. There was no damage to the airplane or injuries to the…NTSB CEN10CA024Accident · No injuriesData collectionFinal reportCessna 170B · London, OHThe pilot's failure to maintain directional control during the takeoff roll.NTSB WPR10CA024Accident · No injuriesData collectionFinal reportCessna A185F · Sand Coulee, MTThe pilot's failure to maintain directional control during landing with a crosswind.NTSB ERA10FA020Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Oliver Springs, TNThe pilot's loss of directional control while landing on a wet turf runway, which resulted in a runway excursion and collision with a tree.NTSB CEN10LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Peoria, ILA loss of engine power for undetermined reasons during climb out after takeoff, which resulted in a forced landing to a roadway.NTSB CEN10FA021Accident · Minor injuriesField investigationFinal reportCessna P210N · Rifle, COThe pilot’s failure to properly identify the power lever and, instead, manipulating the propeller condition lever.NTSB CEN10CA109Accident · No injuriesData collectionFinal reportSkistmas George Pietnpol Aircamper · Toledo, OHThe pilot's failure to maintain directional control during landing.NTSB WPR10LA021Accident · Serious injuriesLimited investigationFinal reportAerotrike Naked Cobra · Virgin, UTA loss of engine power during cruise flight for undetermined reasons.