NTSB investigations, 2015
16 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\") = 2015
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") = 2015 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 WPR16FA041Accident · 5 fatalField investigationFinal reportPiper PA 32RT-300T · Bakersfield, CAThe noninstrument-rated pilot's decision to conduct and continue the flight despite forecast and en route instrument meteorological conditions (IMC), which were not conducive to safe operation under visual flight rules. Also causal to the accident was the…NTSB GAA16CA080Accident · Minor injuriesData collectionFinal reportAviat A1 · Broadus, MTThe pilot's failure to maintain clearance from the wires while flying at a low altitude resulting in a wire strike, a loss of airplane control, and the consequent impact with terrain.NTSB WPR16FA036Accident · 2 fatalClass 3 · FieldFinal reportBarnett Allen S RV7 · Hurricane, UTThe pilot’s aerobatic maneuver leading to airspeeds above the airplane’s never exceed speed, which resulted in rudder flutter and an in-flight breakup.NTSB ERA16FA033Accident · 1 fatalField investigationFinal reportZenith CH701 · Okeechobee, FLAn in-flight structural failure due to a severely corroded wing strut, which resulted in a loss of airplane control.NTSB CEN16LA027Accident · No injuriesLimited investigationFinal reportBell 407 · San Antonio, TXThe failure of the No. 3 tail rotor adapter and shaft due to a loss of torque on the retaining nut. Contributing to the accident was the lack of a requirement to inspect the tail rotor assembly for security in the helicopter manufacturer's maintenance manual…NTSB GAA16CA039Accident · No injuriesData collectionFinal reportBell 407 · Cameron, LAThe pilot's failure to remove a main rotor blade tiedown, which resulted in substantial damage to a main rotor blade when the engine was started.NTSB ERA16FA001Accident · 4 fatalField investigationFinal reportPiper PA32R · Westminster, SCThe pilot's loss of airplane control for reasons that could not be determined based on the available information.NTSB ERA15FA331Accident · 1 fatalField investigationFinal reportCornell W F/Sahakian J A JR Giles 202 (G202) · Newburgh, NYSeparation of the vertical and horizontal stabilizers from the fuselage due to a fracture that initiated at the bond between the left horizontal stabilizer and the flange that attached the horizontal stabilizer to the fuselage skin. The failure was likely…NTSB CEN15WA364Accident · Minor injuriesForeign investigationMX MX2 · Châteauneuf-sur-Cher, FranceNTSB CEN15FA268Accident · 1 fatalField investigationFinal reportPiper PA 32 · Cuba, MOThe pilot's continued flight into thunderstorm activity, which resulted in his loss of airplane control, the exceedance of the airplane's design limits, and its subsequent in-flight breakup. Contributing to the accident was the pilot's reliance on onboard…NTSB DCA15CA117Accident · No injuriesData collectionFinal reportTitan Aerospace Holdings Solara 50 · Otto, NMstructural failure of the left wing due to an overspeed condition.NTSB ERA15LA328Accident · No injuriesLimited investigationFinal reportGulfstream Aerospace G IV · Caribbean Sea, A1The in-flight failure of the cabin pressurization relief/safety valve (CPRV) due to an obstruction of the CPRV static port, which allowed the airplane to overpressurize. The reason for the initial overpressurization condition could not be determined.NTSB WPR15LA142Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW 27 · Reno, NVThe glider's encounter with severe turbulent atmospheric conditions after the pilot inadvertently entered clouds, which led to his inability to maintain a proper airspeed and the subsequent in-flight breakup of the glider.NTSB WPR15FA140Accident · 1 fatalField investigationFinal reportQuicksilver Enterprises MXL II · Petaluma, CAThe pilot's failure to maintain control of the airplane while maneuvering, which resulted in an uncontrolled descent and structural failure. Contributing to the accident was the pilot's impairment from his use of diphenhydramine.NTSB ENG15RA012Accident · No injuriesForeign investigationRobinson R44 - II · Waikaia, New ZealandOn January 23, 2015, a Robinson R44 II experienced a severe in-flight vibration, after which the pilot successfully landed the helicopter. A subsequent inspection found a crack on one of the main rotor blades. This incident is being investigated by the New…NTSB CEN15LA104Accident · 1 fatalLimited investigationFinal reportBaker Bobby J Safari · The Woodlands, TXAn in-flight separation of the helicopter’s horizontal stabilizer due to undetected fatigue cracking of the stabilizer spar, which resulted in a loss of control.