NTSB investigations, GA
35 cases where the sequence of events included Miscellaneous/other.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 5 |
| 2017 | 2 |
| 2018 | 5 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 1 |
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 c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ERA24LA286Accident · No injuriesClass 3 · LimitedFinal reportGrumman G-164A · Toccoa, GAThe pilot’s failure to set the engine speed control fully forward during takeoff, resulting in an engine surge and subsequent loss of control during landing.NTSB ERA23LA376Accident · No injuriesClass 2 · LimitedFinal reportEmbraer S A EMB-545 · St. Simons Island, GAThe control laws of the angle of attack limiter protection system, which precluded the system from disengaging during an approach in gusting wind conditions, limiting the flight crew’s ability to control the airplane’s pitch and resulting in a hard landing.NTSB ERA23LA279Accident · Serious injuriesClass 4 · LimitedFinal reportEdmisten Robert Eugene SR Rans S-14 Airaile · Bonaire, GAThe pilot’s failure to properly adjust the propeller’s pitch angle, which resulted in a loss of thrust and an inability to maintain altitude.NTSB ERA22FA161Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Dahlonega, GAThe pilot’s delay in initiating a go-around and his failure to maintain airplane control during the initial climb, which resulted in the exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB ERA22FA004Accident · 2 fatalClass 3 · FieldFinal reportDassault Falcon 20 · Thomson, GAThe flight crew’s continuation of an unstable dark night visual approach and the captain’s instruction to use air brakes during the approach contrary to airplane operating limitations, which resulted in a descent below the glide path, and a collision with…NTSB CEN21LA224Accident · Serious injuriesClass 3 · LimitedFinal reportDJI Matrice · Young Harris, GAThe remote pilot-in-command’s (RPIC) decision to physically hold onto the drone’s landing gear in flight, which resulted in the rotors striking his hand and causing serious injury. Contributing to the accident was the RPIC’s inadequate preflight planning and…NTSB ERA20CA232Accident · No injuriesClass 4 · Data collectionFinal reportAyres S2R · Perry, GAThe reported malfunction of the aileron flight control system during takeoff for reasons that could not be determined.NTSB ERA20CA112Accident · Minor injuriesClass 4 · Data collectionFinal reportBeech 58 · Augusta, GAThe pilot's failure to land and stop the airplane within the available runway, which resulted in a runway overrun. Contributing to the outcome was the pilot's inadvertent feathering of both propellers during approach to landing.NTSB GAA19CA191Accident · No injuriesData collectionFinal reportPiper PA32 · Swainsboro, GAThe pilot's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and the landing gear collapsing.NTSB GAA19CA088Accident · No injuriesData collectionFinal reportPiper PA28 · Cornelia, GAThe flight instructor's failure to maintain the runway heading during an attempted takeoff in gusting crosswind conditions, which resulted in a collision with trees.NTSB ERA19LA057Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Kennesaw, GAThe total loss of engine power due to the interruption of oil circulation for reasons that could not be determined based on the available evidence.NTSB GAA18CA458Accident · No injuriesData collectionFinal reportAllen W Inks Virus SW · Clayton, GAThe pilot’s failure to maintain a proper descent rate, which resulted in a hard, bounced landing and runway overrun.NTSB ERA18LA176Accident · No injuriesLimited investigationFinal reportCessna 337 · Atlanta, GAAn area of pitting and corrosion on the surface of the aluminum hydraulic line connecting the emergency handle/pump to the electric hydraulic pump, which resulted in a loss of hydraulic pressure and the pilot’s inability to extend the landing gear.NTSB GAA18CA273Accident · Minor injuriesData collectionFinal reportChristopher Lord ELA Eclipse 10 · Calhoun, GAThe student pilot’s failure to maintain sufficient airspeed, which resulted in a loss of altitude and necessitated a sudden descent to unsuitable terrain.NTSB ERA18LA044Accident · No injuriesLimited investigationFinal reportPiper PA34 · Thomasville, GAA stone becoming lodged in a left main landing gear (MLG) drag link, which resulted in the failure of the left MLG to extend and lock.NTSB ERA17LA109Accident · Minor injuriesLimited investigationFinal reportErcoupe 415 · Dawsonville, GAA decrease in oil pressure due to the pilot's unintentional overfilling of the engine oil sump, and the pilot's subsequent decision to perform an off-airport precautionary landing, which resulted in impact with a tree.NTSB ERA17LA020Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12 D · Vaughn, GAA total loss of engine power for reasons that could not be determined because postaccident examination of the airplane and engine did not reveal any evidence of preimpact malfunctions or failures that would have precluded normal operation.NTSB GAA16CA451Accident · No injuriesData collectionFinal reportAyres S 2R · Cordele, GAThe pilot’s failure to maintain clearance from power lines during an agricultural application flight while flying toward the sun.NTSB GAA16CA497Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Brunswick, GAThe total loss of engine power during takeoff due to a loose B-nut on the fuel flow divider input fuel line fitting, which resulted in a fuel leak and fuel starvation.NTSB ERA16LA261Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Calhoun, GAThe helicopter owner’s failure to ensure the helicopter’s airworthiness and the inadequate inspection and maintenance of the helicopter's landing gear dampers, which resulted in ground resonance during throttle application. Contributing to the damage of the…NTSB GAA16CA374Accident · Minor injuriesData collectionFinal reportCessna 150 · Cleveland, GAFailure of the left main landing gear attachment during the landing roll, which resulted in a left landing gear collapse, and damage to the left wing and aileron.NTSB ERA15LA270Accident · No injuriesLimited investigationFinal reportAyres S2R T34 · Climax, GAA loss of thrust on takeoff for reasons that could not be determined, because postaccident examination of the engine and propeller assembly did not reveal any mechanical anomalies that would have precluded normal operation.NTSB ERA15CA152Accident · No injuriesData collectionFinal reportCessna 182L · Waycross, GAThe pilot's failure to use any airport guidance while taxiing, which resulted in geographic disorientation and a takeoff attempt from an inadequate length and unsuitable surface.NTSB ERA14LA422Accident · No injuriesLimited investigationFinal reportAckland Jeffrey Dean SH 3R · Columbus, GAThe mechanic’s improper installation of the landing gear extend/retract switch, which resulted in the retraction of the landing gear during the aborted takeoff.NTSB ERA14CA239Accident · Serious injuriesData collectionFinal reportTaylorcraft BC 65 · Summerville, GAThe pilot's selection of an inadequate altitude during low level maneuvering, which resulted in an in-flight collision with trees.NTSB ERA13LA337Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, GAThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the airplane's perceived lack of performance for reasons that could not be determined due to insufficient information.NTSB ERA13TA237Accident · No injuriesFinal reportBell OH-58C · Jekyll Island, GAThe pilot's failure to maintain rotor rpm in the normal operating range during a practice autorotation, which resulted in a hard landing. Contributing to the accident was the inadequate supervision by the flight instructor.NTSB ERA13MA139Accident · 5 fatalMajor investigationFinal reportBeech 390 · Thomson, GAThe pilot's failure to follow airplane flight manual procedures for an antiskid failure in flight and his failure to immediately retract the lift dump after he elected to attempt a go-around on the runway. Contributing to the accident were the pilot's lack of…NTSB ERA12LA401Accident · Serious injuriesLimited investigationFinal reportBeech 400A · Atlanta, GAThe flight crew's failure to obtain the proper airspeed for landing, which resulted in the airplane touching down too fast with inadequate runway remaining to stop and a subsequent runway overrun. Contributing to the accident were the failure of either pilot…NTSB ERA11FA462Accident · Serious injuriesField investigationFinal reportBeech B19 · Whitesburg, GAThe student pilot did not retract the wing flaps during a go-around, which decreased the airplane’s climb performance and resulted in an in-flight collision with trees.NTSB ERA11CA131Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Atlanta, GAThe pilot's wrong turn while taxiing resulting in a collision with a sign.NTSB ERA10CA465Accident · No injuriesData collectionFinal reportStearman E75 · Jackson, GAThe pilot's diverted attention toward an unsecured engine cowl door after takeoff which resulted in his failure to maintain airspeed and altitude. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane.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 NYC08CA151Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Columbus, GAThe flight instructor's improper decision to abort the takeoff after the cabin door latch opened. Contributing to the accident was the cabin door unlatching.NTSB MIA08CA049Accident · Serious injuriesData collectionFinal reportAirborne Redback · Jefferson, GAThe failure of the pilot-in-command to maintain control of the airplane and his poor weather evaluation before attempting to taxi the airplane. A factor in the accident was the failure of airport personnel to correct the inaccurate wind information reported…