NTSB investigations, 2011
14 cases where the defining event was Aircraft structural failure.
Cases per year
| 2008 | 15 |
|---|---|
| 2009 | 21 |
| 2010 | 16 |
| 2011 | 14 |
| 2012 | 9 |
| 2013 | 10 |
| 2014 | 12 |
| 2015 | 9 |
| 2016 | 11 |
| 2017 | 5 |
| 2018 | 13 |
| 2019 | 4 |
| 2020 | 8 |
| 2021 | 6 |
| 2022 | 9 |
| 2023 | 8 |
| 2024 | 8 |
| 2025 | 1 |
| 2026 | 2 |
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\") = 2011
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '337')
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") = 2011 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '337') 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 CEN12FA108Accident · 5 fatalField investigationFinal reportPiper PA-32-260 · Bryan, TXThe pilot’s inadvertent encounter with severe weather, which resulted in the airplane’s left wing failing in positive overload. Contributing to the accident was the pilot’s reliance on outdated weather information that he received on his in-cockpit…NTSB CEN12FA098Accident · 4 fatalField investigationFinal reportSocata TB21 · Silverton, COThe non-instrument-rated pilot’s decision to embark on a flight through forecasted instrument meteorological conditions (IMC), and his subsequent flight into IMC, which resulted in the pilot’s spatial disorientation and subsequent maneuvering of the airplane…NTSB WPR12MA034Accident · 5 fatalMajor investigationFinal reportEurocopter EC 130 B4 · Pukoo, HIThe pilot's failure to maintain clearance from mountainous terrain while operating in marginal weather conditions, which resulted in the impact of the horizontal stabilizer and lower forward portion of the fenestron with ground and/or vegetation and led to…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 WPR11LA459Accident · No injuriesLimited investigationFinal reportMcarthur Steen Skybolt · Greenleaf, IDStructural failure of the upper left wing during aerobatic flight.NTSB WPR11MA454Accident · 11 fatalClass 1 · MajorFinal reportNorth American/Aero Classics P-51D · Reno, NVThe reduced stiffness of the elevator trim tab system that allowed aerodynamic flutter to occur at racing speeds. The reduced stiffness was a result of deteriorated locknut inserts that allowed the trim tab attachment screws to become loose and to initiate…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 ERA11LA415Accident · 2 fatalLimited investigationFinal reportPolaris Polar Star · Dewees Island, SCThe non-certificated pilot’s operation of the unregistered airplane while impaired by alcohol. Contributing to the accident was the pilot’s performance of aerobatic maneuvers that exceeded the structural limits of the aircraft, which resulted in failure of…NTSB CEN11IA280Incident · No injuriesIncident investigationFinal reportBeech 90B · Chickasha, OKThe mechanic's improper installation of the aileron.NTSB DCA11MA039Accident · Minor injuriesMajor investigationFinal reportBoeing 737 · Yuma, AZthe improper installation of the fuselage crown skin panel at the S-4L lap joint during the manufacturing process, which resulted in multiple site damage fatigue cracking and eventual failure of the lower skin panel. Contributing to the injuries was flight…NTSB WPR11LA172Accident · No injuriesLimited investigationFinal reportBeech G35 · Whidbey Island, WAThe pilot's failure to prioritize flying over navigation due to his diverted attention, which allowed the airplane to near a restricted area, which, in turn, led the pilot to enter a rapid avoidance maneuver and subsequently lose airplane control.…NTSB WPR11FA155Accident · 1 fatalField investigationFinal reportMuse KR2 · Newberry Springs, CAThe airplane’s encounter with severe turbulence, which resulted in the in-flight breakup of the airplane. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB CEN11LA209Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Kingsville, TXA pre-existing crack in the front spar of the right horizontal stabilizer near a riveted fitting, causing it to fail and separate from the airplane in flight. Contributing to the accident was the failure of maintenance personnel comply with existing service…NTSB ERA11LA141Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Baltimore, MDAn in-flight overload failure of the left elevator inboard balance weight rib for undetermined reasons.