NTSB investigations, 2022
14 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\") = 2022
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") = 2022 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 WPR23FA034Accident · 4 fatalClass 2 · FieldFinal reportTextron 208B · Snohomish, WAThe pilot’s improper recovery following a departure from controlled flight after an intentional aerodynamic stall, which resulted in an exceedance of airspeed limitations, airframe overstress, and a subsequent inflight breakup.NTSB ANC23FA003Accident · 2 fatalClass 3 · FieldFinal reportAirborne Windsports Edge XT-912L · Mokuleia, HIStructural failure of the wing for undetermined reasons, which resulted in a loss of control.NTSB ERA23FA007Accident · 1 fatalClass 3 · FieldFinal reportSeamax M-22 · East Hampton, NYAn inflight separation of the right wing as a result of the manufacturer’s application of a bolt and nut in the upper wing strut attachment point that was inconsistent with the nut design intent and usage limitations.NTSB CEN22LA442Accident · No injuriesClass 3 · LimitedInvestigation openPiper PA-18 · Battle Creek, MINTSB WPR22FA345Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46 · Seligman, AZThe student pilot’s continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, exceedance of the airplane’s design limitations, and in-flight breakup.NTSB DCA22WA136Incident · No injuriesClass 5 · Foreign737 800 · Dubrovnik, CroatiaNTSB ANC22LA040Accident · No injuriesClass 3 · LimitedFinal reportCessna U206F · Kodiak, AKThe failure of the right main landing gear leg due to fatigue cracks that initiated from corrosion pitting.NTSB WPR22LA183AccidentClass 4 · LimitedFinal reportPyka Pelican · Winters, CADelamination of the uncrewed aircraft systems’ right wing skin surfaces from the wing spar that resulted in a spin and impact with terrain.NTSB WPR22FA169Accident · 2 fatalClass 3 · FieldFinal reportBearhawk LSA · Kalispell, MTAn excessive pitch control input for undetermined reasons while the airplane was operating above maneuvering speed, which led to a structural failure of the right wing during cruise flight. Contributing to the accident was the poor construction quality of the…NTSB ENG22WA024IncidentClass 5 · ForeignBoeing 737 · Queensland, AustraliaNTSB ERA22LA171Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Sparta, TNMaintenance personnel’s failure to properly affix left main landing gear components, which led to the failure of the left main landing gear during the accident flight.NTSB WPR22LA136Accident · No injuriesClass 3 · LimitedFinal reportDowner Bellanca 14-19-2 · Prosser, WAAn inadequately welded elevator attachment lug, which caused the elevator to partially detach from its bellcrank, resulting in flutter and structural damage.NTSB WPR22FA100Accident · 1 fatalClass 3 · FieldFinal reportMoynihan Richard D Vans RV-7A · White Hills, AZThe pilot’s improper aerobatic maneuver leading to an airspeed that exceeded the airplane’s design limits, which resulted in rudder flutter and an in-flight breakup.NTSB ERA22LA123Accident · No injuriesClass 3 · LimitedFinal reportBritten-Norman BN-2A-9 · Culebra, PRThe flight crew’s failure to arrest the descent rate during the non-standard approach, which resulted in a hard landing and failure of the right-wing structure. Contributing was the flight instructor’s selection of a challenging approach for initial training.