NTSB investigations, 2013
19 cases where the sequence of events included Aircraft structural failure.
Cases per year
| 2008 | 21 |
|---|---|
| 2009 | 35 |
| 2010 | 23 |
| 2011 | 21 |
| 2012 | 22 |
| 2013 | 19 |
| 2014 | 14 |
| 2015 | 16 |
| 2016 | 15 |
| 2017 | 9 |
| 2018 | 19 |
| 2019 | 12 |
| 2020 | 10 |
| 2021 | 7 |
| 2022 | 14 |
| 2023 | 13 |
| 2024 | 15 |
| 2025 | 2 |
| 2026 | 3 |
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\") = 2013
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '337' 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 year(c."eventDate") = 2013 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '337' 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 ERA14FA077Accident · 2 fatalField investigationFinal reportPiper PA-30 · Biglerville, PAThe noninstrument-rated pilot's spatial disorientation after inadvertently encountering instrument meteorological conditions at night and his subsequent loss of airplane control.NTSB CEN14IA085Incident · No injuriesIncident investigationFinal reportBeech E90 · Eau Claire, WIThe failure of the copilot’s windshield inner layer due to a peel chip that developed as a result of mechanical and thermal expansion stresses.NTSB ERA14MA060Accident · 2 fatalMajor investigationFinal reportFairchild SA227-AC · La Alianza, PRThe flight crew's excessive elevator input during a rapid descent under night lighting conditions, which resulted in the overstress and breakup of the airplane. Contributing to the accident was an initial loss of airplane control for reasons that could not be…NTSB CEN14FA064Accident · 1 fatalField investigationFinal reportCessna T210 · Cedaredge, COThe pilot's spatial disorientation while operating in dark night conditions in snow showers and his subsequent failure to maintain airplane control, which resulted in overstress of the airplane and an in-flight breakup. Contributing to the loss of control was…NTSB CEN14LA056Accident · 1 fatalLimited investigationFinal reportPearson Jon M Dragonfly · Anahuac, TXThe incorrect installation by the pilot, who was not a certificated mechanic or repairman, of the main rotor head bearing block, which resulted in the in-flight separation of the rotor head.NTSB CEN14FA009Accident · 2 fatalField investigationFinal reportCessna 500 · Derby, KSThe airplane's encounter with severe icing conditions, which resulted in structural icing, and the pilot's increased workload and subsequent disorientation while maneuvering in instrument flight rules (IFR) conditions with malfunctioning flight instruments,…NTSB ERA13FA424Accident · 1 fatalField investigationFinal reportBrown Robert K RV7A · Hamilton Township, NJThe pilot's improper aerobatic maneuver that resulted in a loss of control, exceedance of the airplane's design limitations, and a subsequent in-flight breakup of the airplane.NTSB WPR13LA404Accident · No injuriesLimited investigationFinal reportBell 47G5 · King City, CAThe failure of the helicopter’s center frame tube due to a fatigue crack and corrosion originating from a welded surface. Contributing to the accident was maintenance personnel’s inadequate inspection of the helicopter during its most recent 100-hour…NTSB CEN13LA514Accident · Minor injuriesLimited investigationFinal reportChallenger II · Emporia, KSThe right wing’s folding up in flight for reasons that could not be determined because an examination did not reveal any abnormalities with the airframe that would have precluded normal operation.NTSB ERA13FA253Accident · 3 fatalField investigationFinal reportPiper PA-34-200T · Johnstown, NYThe pilot's loss of control due to spatial disorientation in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations, and a subsequent in-flight breakup.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 ERA13LA199Accident · Minor injuriesLimited investigationFinal reportMaxfly Inc/Mckay WM Searey · Polk City, FLThe improper installation of incorrect attachment hardware by maintenance personnel during an undocumented repair, which resulted in an in-flight structural failure and subsequent loss of aircraft control. Contributing to the accident was the covering of the…NTSB ERA13LA198Accident · No injuriesLimited investigationFinal reportFranke Russell J Searey · Polk City, FLAn inadvertent encounter with the water wake from a larger amphibious airplane before takeoff and the pilot's subsequent inadequate preflight inspection of the airplane during which he failed to note damage caused by the wake encounter.NTSB CEN13FA213Accident · 2 fatalField investigationFinal reportSchleicher Alexander · Littlefield, TXThe pilot’s improper decision to conduct aerobatic maneuvers in a glider not approved for such maneuvers. Contributing to the accident was the degradation of the adhesive holding the wing together, which should have been detected either during the last annual…NTSB CEN13FA192Accident · 3 fatalField investigationFinal reportSikorsky S-76A++ · Grand Lake, LAFracture of the red tail rotor blade spar, which resulted in the separation and departure of the red tail rotor blade from the helicopter and subsequent compromised tail gearbox. The red tail rotor blade was not recovered, thus the cause of the initial…NTSB CEN13LA186Accident · 1 fatalLimited investigationFinal reportFisher Michael E Celebrity · Terrell, TXThe pilot’s exceedance of the airplane’s design stress limits while performing aerobatic maneuvers.NTSB WPR13FA123Accident · 1 fatalField investigationFinal reportAvions Fairey Tipsy Nipper T-66 · Winters, CAThe airplane's impact with a turkey vulture in cruise flight, which resulted in the structural failure of the right wing and the subsequent loss of control.NTSB WPR13FA086Accident · 2 fatalField investigationFinal reportBeech V35A · Woody, CAAn in-flight encounter with icing conditions during descent, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall followed by an in-flight breakup.NTSB ERA13RA106Accident · 7 fatalClass 5 · ForeignBoeing-Vertol 234 · Pucallpa, Peru, PeruOn January 7, 2013, about 2002 universal coordinated time (1502 local time), a Boeing-Vertol 234, N241CH, operated by Columbia Helicopters Peru, S.A.C., was destroyed during an inflight breakup and subsequent impact with terrain near Pucallpa, Peru. The U.S.…