NTSB investigations, GA
21 cases where NTSB found Aircraft structures.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 1 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 1 |
| 2021 | 1 |
| 2023 | 2 |
| 2024 | 4 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0103'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0103')) 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 ERA25LA070Accident · Serious injuriesClass 4 · LimitedFinal reportWilliam M Clapp CLAPP-SABERWING · Valdosta, GAA hard landing and subsequent gear collapse due to the pilot’s failure to securely close the airplane canopy and its subsequent opening on short final.NTSB ERA25LA040Accident · Minor injuriesClass 4 · LimitedFinal reportHughes 369D · Waycross, GAAn encounter with a foreign object, which resulted in a loss of control and collision with terrain.NTSB DCA24FA299Accident · Minor injuriesClass 3 · FieldFinal reportAirbus A350-941 · College Park, GADelta Air Lines flight crew’s loss of situation awareness of the clearance between their right wingtip and the empennage of an Endeavor Air airplane holding on a perpendicular taxiway, resulting in their wingtip colliding with the other airplane’s empennage.…NTSB DCA24LA295Accident · No injuriesClass 4 · LimitedFinal reportAirbus A330-323 · Atlanta, GADelta Air Lines flight crew’s incorrect evaluation of the clearance between their airplane and the airplane directly ahead of them as they made a 90 degree right turn onto an adjacent taxiway.NTSB ERA23FA330Accident · 1 fatalClass 3 · FieldFinal reportCessna P210 · Junction City, GAThe pilot’s continued flight into a known area of adverse weather, which resulted in the penetration of a severe thunderstorm, the pilot’s loss of airplane control, and the airplane’s subsequent in-flight breakup.NTSB ERA23FA209Accident · 2 fatalClass 3 · FieldFinal reportCessna 177B · Watkinsville, GAThe pilot’s spatial disorientation and subsequent loss of airplane control, which resulted in an in-flight overload separation of the right wing during the uncontrolled descent.NTSB ERA22FA009Accident · 4 fatalClass 3 · FieldFinal reportCessna P210 · Atlanta, GAThe pilot’s failure to ensure that his seat was properly secured before initiating the takeoff, which resulted in a loss of control during the initial climb. Contributing to the accident was the lack of an installed secondary seat stop, and the airplane’s aft…NTSB ERA19FA118Accident · 1 fatalClass 3 · FieldFinal reportHughes 369 · Talking Rock, GAA fatigue failure of the overrunning clutch subassembly due to abnormal bending loads due to cracks on the center engine mount, which resulted in an inflight loss of power. Contributing to the accident was the helicopter's low altitude and airspeed when the…NTSB ERA19FA068Accident · 1 fatalClass 2 · FieldFinal reportSaberwing Saberwing · Adel, GAThe in-flight failure of the fuselage, as a result of the pilot conducting maneuvers that exceeded the structural capabilities of the airplane.NTSB GAA19CA029Accident · No injuriesData collectionFinal reportCapital Holdings 226 CCX-2000 · Dahlonga, GAThe pilot's improper landing flare, which resulted in a bounced landing and his subsequent failure to maintain directional control. Also causal to the accident was the pilot’s failure to retract the flaps during the aborted landing, which resulted in the…NTSB ERA17LA253Accident · No injuriesLimited investigationFinal reportWaco UPF 7 · Brunswick, GAThe failure of the right main landing gear strut brace for reasons that could not be determined based on the available evidence.NTSB ERA17FA222Accident · 4 fatalField investigationFinal reportPiper PA23 · Chatsworth, GAThe noninstrument-rated pilot's continued visual flight rules flight into adverse weather conditions, which resulted in an encounter with severe convective activity, spatial disorientation, a loss of airplane control, and a subsequent in-flight breakup.…NTSB GAA17CA004Accident · Serious injuriesData collectionFinal reportAirborne Windsports PTY Edge XT 912 L · Fort Valley, GAThe failure of the aircraft’s right overcenter washout strut split ring, which resulted in the pilot’s inability to maintain lateral control of the aircraft and subsequent ground impact.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 ENG13IA027Incident · No injuriesIncident investigationFinal reportBoeing 747 · Atlanta, GAFailure of the right inboard foreflap outboard fitting due to fatigue and bearing anomalies on the sequence carriages which resulted in the partial separation of the right inboard foreflap. Contributing to the incident was the failure of maintenance personnel…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 ERA12LA195Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Americus, GAThe failure of maintenance personnel to properly secure a portion of the right wing leading edge, which resulted in the separation of the associated section of the leading edge during takeoff and the loss of directional control during the subsequent landing.NTSB ERA12FA018Accident · 1 fatalField investigationFinal reportBerger Michael A Waiex · Washington, GAThe in-flight failure of the aircraft’s Y-tail attachment structure during maneuvering flight due to overload. Contributing to the accident was, the kit manufacturer’s use of 14 CFR Part 23, Appendix A design guidelines intended for a conventional tail…NTSB ERA11FA431Accident · 1 fatalField investigationFinal reportBeech G35 · Byron, GAThe pilot’s sustained flight at airspeeds in excess of the airplane's never exceed speed during a steep descent, which resulted in a subsequent in-flight structural failure due to overstress.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.