NTSB investigations, 2009, GA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 | 1 |
|---|---|
| 1963 | 2 |
| 1964 | 77 |
| 1965 | 114 |
| 1966 | 113 |
| 1967 | 140 |
| 1968 | 101 |
| 1969 | 126 |
| 1970 | 117 |
| 1971 | 131 |
| 1972 | 142 |
| 1973 | 89 |
| 1974 | 117 |
| 1975 | 77 |
| 1976 | 103 |
| 1977 | 113 |
| 1978 | 120 |
| 1979 | 95 |
| 1980 | 92 |
| 1981 | 83 |
| 1982 | 82 |
| 1983 | 84 |
| 1984 | 79 |
| 1985 | 75 |
| 1986 | 56 |
| 1987 | 63 |
| 1988 | 61 |
| 1989 | 51 |
| 1990 | 60 |
| 1991 | 61 |
| 1992 | 54 |
| 1993 | 38 |
| 1994 | 49 |
| 1995 | 47 |
| 1996 | 48 |
| 1997 | 49 |
| 1998 | 54 |
| 1999 | 38 |
| 2000 | 42 |
| 2001 | 49 |
| 2002 | 49 |
| 2003 | 51 |
| 2004 | 46 |
| 2005 | 32 |
| 2006 | 44 |
| 2007 | 54 |
| 2008 | 49 |
| 2009 | 47 |
| 2010 | 48 |
| 2011 | 44 |
| 2012 | 39 |
| 2013 | 30 |
| 2014 | 34 |
| 2015 | 33 |
| 2016 | 42 |
| 2017 | 35 |
| 2018 | 35 |
| 2019 | 39 |
| 2020 | 36 |
| 2021 | 37 |
| 2022 | 42 |
| 2023 | 37 |
| 2024 | 44 |
| 2025 | 24 |
| 2026 | 27 |
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.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
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."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' 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 ERA10LA107Accident · No injuriesLimited investigationFinal reportMaule M5 · LaGrange, GAThe failure of the right main landing gear for undetermined reasons.NTSB ERA10LA053Accident · No injuriesLimited investigationFinal reportHughes 369 · Baxley, GAA loss of engine power due to fuel starvation resulting from the pilot’s inadequate preflight inspection of the main fuel valve position.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 ERA10CA036Accident · Serious injuriesData collectionFinal reportBoeing 767-432ER · Atlanta, GAUnforecasted turbulence resulting in a flight attendant being injured.NTSB ERA10LA026Accident · 2 fatalLimited investigationFinal reportFuji LM1 · Athens, GAAn aerodynamic stall shortly after takeoff for undetermined reasons.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 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 ERA09LA510Accident · No injuriesLimited investigationFinal reportSocata TB 9 Tampi · Milner, GAThe failure of the No. 3 cylinder exhaust valve for undetermined reasons.NTSB ERA09LA516Accident · Minor injuriesLimited investigationFinal reportSiai-Marchetti F.260 · Atlanta, GAA total loss of engine power due to a fuel system air leak as a result of a deteriorated O-ring seal in the fuel shut-off cock. Contributing to the accident was the exceedance of the suggested overhaul schedule for the fuel shut-off cock.NTSB ERA09LA490Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bainbridge, GAA total loss of engine power due to the loss of camshaft timing as a result of the displacement of the idler gear assembly.NTSB ERA09FA487Accident · 2 fatalField investigationFinal reportSocata TB20 · Pavo, GAThe pilot’s continued visual flight into instrument meteorological conditions, with embedded intense thunderstorms, heavy rain, and severe to extreme turbulence, resulting in an in-flight separation of the left wing due to overstress.NTSB ERA09CA484Accident · No injuriesData collectionFinal reportPiper PA-34 · Savannah, GAThe student pilot's failure to maintain pitch control during landing and the flight instructor's delayed remedial action, resulting in a hard landing.NTSB ERA09LA476Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Fairmount, GAA total loss of engine power due to fuel starvation as a result of a contaminated fuel strainer.NTSB ERA09LA474Accident · No injuriesLimited investigationFinal reportCessna T210M · Dalton, GAThe failure of the right main landing gear actuator downlock spring.NTSB ERA09LA470Accident · No injuriesLimited investigationFinal reportCessna A188B · McRae, GAA total loss of engine power due to pre-ignition/detonation as a result of a fuel control malfunction.NTSB ERA09LA460Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Acworth, GAThe loss of engine power due to the fatigue failure of the third-stage turbine wheel airfoil.NTSB ERA09CA462Accident · No injuriesData collectionFinal reportUnknown Sabre-Trike · Crandall, GAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.NTSB ERA09LA480Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Donalsonville, GAThe failure of the right main gear strut due to an improper weld repair by maintenance personnel.NTSB ERA09CA445Accident · Serious injuriesData collectionFinal reportDestiny XLT · Athens, GAThe pilot’s failure to maintain obstacle clearance during climbout.NTSB ERA09CA442Accident · Minor injuriesData collectionFinal reportRans S12 · Quitman, GAThe pilot's failure to maintain obstacle clearance on final approach.NTSB ERA09CA432Accident · Minor injuriesData collectionFinal reportBingham Chuck Rotorway 1 · Atlanta, GAThe pilot's failure to maintain control of the helicopter while hovering in gusting wind conditions.NTSB ERA09LA412Accident · 1 fatalLimited investigationFinal reportJames O'Bert Vari-Eze · Columbus, GAThe pilots improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ERA09LA385Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Brinson, GAThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the make and model airplane.NTSB ERA09CA387Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Winder, GAThe pilot's failure to obtain the proper touchdown point during a practice forced landing, and the flight instructor's delayed decision to initiate a go-around.NTSB ERA09LA369Accident · 2 fatalLimited investigationFinal reportP&M Quikr · Cedar Town, GAA loss of aircraft control for an undetermined reason.NTSB ERA09CA366Accident · Minor injuriesData collectionFinal reportCessna 210-5(205) · Porterdale, GAThe loss of engine power due to fuel exhaustion as a result of the pilot's use of improper fuel caps. Contributing to the accident was the pilot’s selection of an unsuitable area for landing.NTSB ERA09CA362Accident · No injuriesData collectionFinal reportCessna T206H · Columbus, GAThe pilot's improper flare, which resulted in a hard landing.NTSB ERA09IA338Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B1 · Atlanta, GAThe failure of the left main landing gear to extend due to high levels of particulate contamination in the hydraulic fluid.NTSB ERA09IA326Incident · No injuriesIncident investigationFinal reportIniziative Sky Arrow · Marietta, GAAn electrical fire due to the lack of a positive locking mechanism for the fuse retainer in the main fuse block, which resulted in voltage fluctuations that caused thermal damage to the avionics cooling fan. Contributing to the incident was the student…NTSB ERA09CA318Accident · No injuriesData collectionFinal reportPiper PA28 · Elberton, GAThe student pilot's improper recovery from a bounced landing.NTSB ERA09CA274Accident · No injuriesData collectionFinal reportCessna 150K · Waycross, GAThe student pilot's failure to maintain aircraft control during approach in gusty conditions. Contributing to the accident was the student pilot's misunderstanding of the airspeed indicator.NTSB ERA09CA268Accident · No injuriesData collectionFinal reportDiamond DA20 · Townsend, GAThe pilot's failure to maintain directional control during a landing roll with a crosswind. Contributing to the accident was the pilot's lack of experience in the make and model airplane.NTSB ERA09LA258Accident · 1 fatalLimited investigationFinal reportCessna A188B · Pinehurst, GAThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB ERA09LA257Accident · No injuriesLimited investigationFinal reportMaule M-5-180C · Moultrie, GAA loss of engine power due to carburetor icing as a result of the maintenance technician's failure to detect and correct the condition of the carburetor heat duct.NTSB ERA09LA231Accident · 1 fatalLimited investigationFinal reportHoward William C KR-2 · Valdosta, GAAn in-flight fire for undetermined reasons.NTSB ERA09LA222Accident · Serious injuriesLimited investigationFinal reportRogers Kenneth J Flaglor Scooter · Griffin, GAA total loss of engine power due to the failure of the engine-driven fuel pump. Contributing to the accident was unsuitable terrain for a forced landing and the pilot’s preexisting medical condition.NTSB ERA09CA225Accident · No injuriesData collectionFinal reportCessna 150L · Brunswick, GAThe student pilot's failure to maintain aircraft control while landing in gusting crosswinds.NTSB ERA09LA224Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas MD88 · Atlanta, GAThe flight attendant’s failure to properly restrain herself after taking her jumpseat.NTSB ERA09LA203Accident · Serious injuriesLimited investigationFinal reportWayne O Robinson S6S Rans · Cartersville, GAThe pilot's failure to maintain airspeed following a partial loss of engine power during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was chafed wires in the ignition system.NTSB ERA09CA216Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Atlanta, GAThe failure of the pilot to maintain clearance with a parked airplane.NTSB ERA09FA185Accident · 3 fatalField investigationFinal reportCessna 182P · Carrollton, GAThe pilot's decision to continue visual flight rules flight into an area of reduced visibility weather conditions, which resulted in disorientation and subsequent loss of aircraft control.NTSB ERA09CA175Accident · No injuriesData collectionFinal reportCessna 172 · Reidsville, GAThe pilot's failure to maintain control of the airplane during an attempted recovery from a stall/spin.NTSB ERA09CA149Accident · No injuriesData collectionFinal reportD-Fly UL Stork · Jackson, GAThe pilot's inadvertent activation of an engine cutoff switch during cruise flight.NTSB ERA09CA138Accident · No injuriesData collectionFinal reportMD Helicopter 369E · Atlanta, GAWind gusts during engine shutdown, which resulted in the main rotor blades contacting the tailboom.NTSB ERA09LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Jasper, GAA total loss of engine power for an undetermined reason.NTSB ERA09CA171Accident · No injuriesData collectionFinal reportCessna 120 · Woodstock, GAA loss of engine power, as reported by the pilot, for undetermined reasons.NTSB ENG09IA002Incident · No injuriesIncident investigationFinal reportBoeing 777 · Atlanta, GAThe fan blade fractured due to a fatigue crack that was the result of the combination of the breakdown of the fan blade lubrication system and residual fatigue life usage following the last overhaul of the fan blade. Contributing to the fracture was the…