NTSB investigations, 2012
25 cases where NTSB found Wing structure.
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 14 |
| 2010 | 17 |
| 2011 | 15 |
| 2012 | 25 |
| 2013 | 12 |
| 2014 | 11 |
| 2015 | 10 |
| 2016 | 14 |
| 2017 | 7 |
| 2018 | 14 |
| 2019 | 6 |
| 2020 | 6 |
| 2021 | 9 |
| 2022 | 9 |
| 2023 | 12 |
| 2024 | 12 |
| 2025 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 2012
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010357'))
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") = 2012 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010357')) 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 ERA13FA071Accident · 1 fatalField investigationFinal reportGreen Gary E Thorp T-18 · Pahokee, FLThe descent and overstress of the airplane during the descent, which resulted in the in-flight breakup of the airplane.NTSB CEN13FA073Accident · 1 fatalField investigationFinal reportCessna 421C · Wells, TXThe pilot’s decision to continue the flight into an area of extreme weather, which led to the in-flight encounter with a thunderstorm and structural failure of the wings and tail.NTSB WPR13FA056Accident · 2 fatalField investigationFinal reportMcdaniel RV-6-CH · Scio, ORThe pilot's decision to perform aerobatics in an airplane that was prohibited from aerobatics as stated in its operating limitations document, which resulted in the failure of the right wing spar.NTSB WPR13LA050Accident · 1 fatalLimited investigationFinal reportSater Coot A-Amphib · San Andreas, CAThe pilot's excessive flight control inputs, which led to flight that exceeded the structural limits of the airplane and resulted in structural failure of both wings.NTSB ERA13LA061Accident · No injuriesLimited investigationFinal reportCessna 550 · Greenwood, SCCollision with a deer during the landing roll, which resulted in a compromised fuel tank and a postimpact fire.NTSB ERA13LA037Accident · No injuriesLimited investigationFinal reportCessna 172D · Indian Trail, NCThe pilot’s improper use of flaps for takeoff, which resulted in the airplane’s failure to attain adequate climb airspeed and subsequent collision will trees during takeoff.NTSB WPR12LA442Accident · 1 fatalLimited investigationFinal reportAir Creation Tanarg · Safford, AZThe pilot’s failure to maintain airplane control while maneuvering in high wind conditions and his failure to adjust the trim appropriately. Contributing to the accident was the airplane’s nonstandard modified wing configuration.NTSB CEN12FA628Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Bullard, TXThe pilot's maneuver, which exceeded the airplane's structural limit and resulted in an in-flight breakup.NTSB ERA12LA537Accident · 2 fatalLimited investigationFinal reportQuad City Ultralights Challenger II · Ocala, FLThe pilot's inadvertent overstress of the airplane, which resulted in the in-flight separation of the outer section of the right wing.NTSB WPR12LA377Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Everett, WAA hard landing likely made by the private pilot on a solo flight that preceded the dual instructional flight during which the wing damage became obvious.NTSB CEN12LA578Accident · 2 fatalLimited investigationFinal reportDestiny XLT · Hart, MIThe partial deflation of the powered parachute canopy when the pilot flew the aircraft into an area with gusty wind conditions. Contributing to the accident were the modifications that changed the flying characteristics of the parachute.NTSB CEN12CA548Accident · No injuriesData collectionFinal reportSchleicher ASW22 · Uvalde, TXThe pilot did not fully stow the glider’s airbrakes, which prevented the glider from obtaining adequate airspeed during the takeoff roll.NTSB CEN12LA500Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Newellton, LAThe pilot's inadequate takeoff planning and his use of an improper flap setting, which resulted in a runway excursion and collision with terrain during takeoff.NTSB CEN12LA459Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Wisner, LAThe pilot’s inadequate takeoff planning that did not consider the reduced acceleration due to a rough, turf runway and his use of an improper flap setting, which resulted in a collision with terrain during takeoff.NTSB WPR12FA297Accident · Serious injuriesField investigationFinal reportMooney M20L · Scottsdale, AZThe pilot's failure to maintain airplane control during an aborted landing, and the flight instructor’s delayed remedial action. Contributing to the accident were the pilot’s improper landing flare, which resulted in a bounced landing, and his premature flap…NTSB CEN12FA421Accident · 1 fatalField investigationFinal reportBeech E90 · Karnack, TXThe pilot's inadvertent flight into thunderstorm activity, which resulted in the loss of airplane control and the subsequent exceedance of the airplane's design limits and in-flight breakup. Contributing to the accident was the failure of air traffic control…NTSB ANC12CA063Accident · No injuriesData collectionFinal reportPiper PA-32-301 · King Salmon, AKAn in-flight collision with a bird during cruise flight.NTSB WPR12CA288Accident · Minor injuriesData collectionFinal reportDg-Flugzeugbau DG-500MB · Richland, WAThe failure of the spoilers to retract because the right wing spoiler’s lower plate became jammed, which resulted in the glider not having enough lift to make it to the runway surface.NTSB ERA12CA414Accident · No injuriesData collectionFinal reportCessna 177 · West Milford, NJThe pilot's improper full flap retraction while performing a go-around maneuver, which resulted in a loss of airplane control.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 CEN12LA349Accident · 1 fatalLimited investigationFinal reportFlower Roger P J D · Spring Valley, OHThe in-flight failure of the left wing spar, which resulted in the in-flight separation of the left wing.NTSB ERA12FA385Accident · 6 fatalField investigationFinal reportPilatus PC-12/47 · Lake Wales, FLThe failure of the pilot to maintain control of the airplane while climbing to cruise altitude in instrument meteorological conditions (IMC) following disconnect of the autopilot. The reason for the autopilot disconnect could not be determined during…NTSB WPR12TA445Accident · No injuriesFinal reportBeech C90 · Boise, IDExcessive loading on the left wing, which occurred over a period of time. Contributing to the accident was maintenance personnel’s failure to adequately inspect and document the left wing damage.NTSB CEN12FA196Accident · 3 fatalField investigationFinal reportBeech 35 · Glencoe, MNThe non-instrument-rated pilot’s continued flight into instrument meteorological conditions, which resulted in the design limits of the airplane being exceeded and an in-flight breakup.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.