NTSB investigations, 2009
180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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 per year
| 1962 | 72 |
|---|---|
| 1963 | 78 |
| 1964 | 5,253 |
| 1965 | 5,377 |
| 1966 | 5,912 |
| 1967 | 6,339 |
| 1968 | 5,199 |
| 1969 | 5,027 |
| 1970 | 4,915 |
| 1971 | 4,825 |
| 1972 | 4,430 |
| 1973 | 4,398 |
| 1974 | 4,565 |
| 1975 | 4,403 |
| 1976 | 4,314 |
| 1977 | 4,412 |
| 1978 | 4,624 |
| 1979 | 4,165 |
| 1980 | 3,921 |
| 1981 | 3,836 |
| 1982 | 3,545 |
| 1983 | 3,514 |
| 1984 | 3,405 |
| 1985 | 3,055 |
| 1986 | 2,831 |
| 1987 | 2,774 |
| 1988 | 2,685 |
| 1989 | 2,502 |
| 1990 | 2,479 |
| 1991 | 2,419 |
| 1992 | 2,328 |
| 1993 | 2,283 |
| 1994 | 2,229 |
| 1995 | 2,281 |
| 1996 | 2,150 |
| 1997 | 2,121 |
| 1998 | 2,195 |
| 1999 | 2,175 |
| 2000 | 2,183 |
| 2001 | 2,031 |
| 2002 | 2,000 |
| 2003 | 2,062 |
| 2004 | 1,930 |
| 2005 | 2,001 |
| 2006 | 1,826 |
| 2007 | 1,984 |
| 2008 | 1,882 |
| 2009 | 1,783 |
| 2010 | 1,786 |
| 2011 | 1,848 |
| 2012 | 1,834 |
| 2013 | 1,561 |
| 2014 | 1,534 |
| 2015 | 1,581 |
| 2016 | 1,662 |
| 2017 | 1,635 |
| 2018 | 1,687 |
| 2019 | 1,626 |
| 2020 | 1,396 |
| 2021 | 1,645 |
| 2022 | 1,700 |
| 2023 | 1,678 |
| 2024 | 1,693 |
| 2025 | 1,655 |
| 2026 | 1,342 |
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 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 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 WPR10RA093Accident · 6 fatalClass 5 · ForeignCessna 185 · Baindoang, PNG, Papua New GuineaOn December 30, 2009, about 0618 UTC (coordinated universal time), a Papua New Guinea (PNG) registered Cessna 185E, P2-MJL, made a forced emergency landing on mountainous terrain following a loss of oil pressure, about 1 nautical mile southwest of a remote…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 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 ENG10WA007Incident · No injuriesForeign investigationBogota, ColombiaOn December 27, 2009, an Embraer EMB-190 operated by Aero Republica, a Colombian-certificated air carrier, experienced a fire in the left engine, a General Electric CF34-10E, after takeoff from El Dorado International Airport, Bogotá, Colombia. The airplane…NTSB CEN10LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Alexandria, LAA loss of engine power for undetermined reasons.NTSB CEN10IA084Incident · No injuriesIncident investigationFinal reportATR ATR72 · Dallas, TXA fatigue failure of an elevator stop bracket, which resulted in a partial jam of the elevator control. Contributing to the failure was the improper installation of shim stacks, poor alignment of the brackets, and cyclic stresses acting on the lower stop,…NTSB ERA10LA102Accident · 1 fatalLimited investigationFinal reportDavis Michael J Longez · Dexter, KYThe loss of engine power due to the chaffing and grounding of the single magneto's ignition lead.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 CEN10LA085Accident · No injuriesLimited investigationFinal reportCessna 210A · Robert Lee, TXThe collapse of the right main landing gear during landing for unknown reasons.NTSB CEN10LA083Accident · No injuriesLimited investigationFinal reportBeech B35 · Santa Fe, NMAn engine overpressure condition that resulted in oil getting on the exhaust and producing smoke which entered the cockpit. Contributing to the accident was the pilot's obscured vision due to smoke.NTSB CEN10LA078Accident · Serious injuriesLimited investigationFinal reportBell Helicopter Textron Canada 407 · Decatur, TXThe pilot's inadequate preflight inspection and the momentary loss of engine power due to snow or ice ingestion.NTSB CEN10CA081Accident · Minor injuriesData collectionFinal reportCessna 182P · Bowie, TXA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to properly secure the right wing fuel cap and monitor the available fuel supply.NTSB WPR10CA089Accident · No injuriesData collectionFinal reportCessna 172M · Albion, IDThe pilot's failure to maintain clearance from mountainous terrain while maneuvering in gusting winds.NTSB ERA10LA101Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · St. Petersburg, FLA loss of engine power for undetermined reasons.NTSB CEN10FA079Accident · No injuriesField investigationFinal reportSikorsky S-76C++ · Gulf of Mexico (Gulf of Mexico)The pilot's failure to fully land the helicopter prior to entering a turn in strong, crosswind conditions, which resulted in a dynamic rollover.NTSB WPR10WA110Accident · Serious injuriesForeign investigationGarlick TH1F · Canowindra, AustraliaOn December 23, 2009, at 1850 local time, a Garlick TH-1F helicopter (modified Bell 204), Australian registry VH-UHD, registered to and operated by Coloundra Helicopter Center Pty, Ltd., collided with trees and terrain while maneuvering during an aerial fire…NTSB WPR10LA092Accident · No injuriesLimited investigationFinal reportCessna 402C · Moab, UTThe pilot's decision to depart on a snow covered runway, which resulted in a loss of control and encounter with terrain. Contributing to the accident was the airport manager's failure to adhere to the Airport Certification Manual and close the runway due to…NTSB WPR10CA096Accident · No injuriesData collectionFinal reportStinson SR-8B · Auburn, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA10LA100Accident · No injuriesLimited investigationFinal reportFpna A-22 Valor · Hunting Island, SCMaintenance personnel's inadequate inspection of the oil system's fittings during a routine oil servicing, which resulted in oil starvation due to a loose and/or detached oil line B-nut fitting that led to the engine seizing while in flight.NTSB DCA10RA017Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Kingston, JamaicaNTSB WPR10LA091Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Camas, WAThe left magneto's broken p-lead, which led to the engine inadvertently starting while the pilot was turning the propeller by hand.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 ENG10RA017Incident · No injuriesForeign investigationBombardier DHC-8 · London, United KingdomOn 12/21/2009 a Bombardier DHC-8-402 (G-JEDI) suffered a loss of AC electrical power on departure from London Gatwick Airport. The crew returned to London Gatwick for an uneventful landing. Subsequent maintenance revealed heat damage to a wiring loom in the…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 ERA10RA097Accident · 2 fatalForeign investigationDassault/Sud Falcon 20 · Matthew Town, BahamasOn December 17, 2009, about 1922 eastern standard time, a Dassault Falcon 20, N28RK, crashed in a remote area approximately 12 miles east of Matthew Town, Inagua, Bahamas. The 2 pilots were killed and the airplane was destroyed. Night, visual meteorological…NTSB DCA10CA018Accident · Minor injuriesData collectionFinal reportBombardier CL600 2C10 · Dallas, TXThe fueler's falling asleep in the fueling truck with the truck in neutral and without the parking brake set, which allowed the truck to roll until it impacted the airplane.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 WPR10LA087Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Corona, CAA loss of engine power for undetermined reasons.NTSB ENG10RA009Incident · No injuriesForeign investigationBoeing 747 · Changi Airport, SingaporeOn December 17, 2009, a Boeing B747-200F airplane, Reg. 9V-JEB, operated by Jett8 Cargo, experienced a commanded engine in-flight shutdown and air turn back to Changi Airport, Singapore,following an uncontained LPT failure of its No. 4 GE CF6-50 engine, at…NTSB DCA10WA028Accident · No injuriesForeign investigationBoeing 727 · Manaus, BrazilOn December 17, 2009, a TAF Cargo B727, Brazilian registration PR-MTL, struck trees on approach to the Manaus Airport. The airplane went around and diverted. The airplane had damage to the leading edge, slats, and landing gear. This accident is being…NTSB WPR10WA148Accident · Serious injuriesForeign investigationRobinson R-44 · Montreal, Canada, CanadaOn December 16, 2009, at 0720 eastern standard time, a Robinson R-44, Canadian registered C-GDSF, executed an emergency landing near the Bonaventure Highway, in Montreal, Canada. The pilot and passenger were seriously injured, and the helicopter was…NTSB WPR10FA085Accident · Serious injuriesField investigationFinal reportEurocopter AS350BA (FX2) · Hana, Maui, HIAn uncommanded engine shutdown due to an improperly calibrated fuel control unit (FCU) and power turbine governor (PTG). Also causal was the operator’s inadequate maintenance practices and procedures that failed to properly assess and correct the FCU and PTG…NTSB WPR10LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · San Jose, CAA total loss of engine power due to water contamination in the fuel system as a result of the pilot's inadequate preflight inspection.NTSB ERA10FAMS1Accident · 1 fatalMissing aircraftFinal reportCirrus SR22 · Gulf of MexicoUndetermined (airplane and pilot missing).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 DCA10IA015Incident · No injuriesIncident investigationFinal reportBoeing MD · Charlotte, NCThe Captain's failure to initiate a go-around from a Category III approach when satisfactory tracking performance was not maintained below the required altitude resulting in excessive bank angle maneuvers at low altitude. Factors contributing to the incident…NTSB ERA10WA312Accident · 5 fatalForeign investigationBeech 58 · Guarico, VenezuelaOn December 13, 2009, about 2040 UTC, a Beech 58, of Venezuelan registration, YV2473, registered to and operated by Aeronaves Baron, C.A., impacted terrain during takeoff from the Mata de Juajua Airport (SVCS), near Estatdo Guárico, Venezuela. Visual…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 CEN10FA071Accident · 1 fatalField investigationFinal reportCessna 310R · Alva, OKThe pilot's impairment due to medication use, a migraine headache, or both, and his decision to continue the approach below minimums without the proper visual references, resulting in the subsequent collision with terrain. Contributing to the accident was the…NTSB WPR10LA090Accident · No injuriesLimited investigationFinal reportCessna 310 · Pasco, WAThe failure of the right main landing gear up-lock.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 WPR10CA081Accident · No injuriesData collectionFinal reportCessna 182P · Payson, AZThe pilot's improper landing flare, which resulted in a hard landing.NTSB CEN10LA076Accident · No injuriesLimited investigationFinal reportBeech 200 · St. Louis, MOThe pilot's failure to properly follow the manual landing gear extension procedure, resulting in a gear-up landing.NTSB CEN10FA070Accident · 2 fatalField investigationFinal reportPiper PA-30 · Port Mansfield, TXThe pilot’s failure to maintain clearance with the water while on approach (VFR) to land.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.