NTSB investigations
18 cases where the probable cause includes Fuselage main structure.
Cases per year
| 2009 | 3 |
|---|---|
| 2010 | 1 |
| 2011 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 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 c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.\"inProbableCause\" AND starts_with(f.\"findingCode\", '01035310')) 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 c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f."inProbableCause" AND starts_with(f."findingCode", '01035310')) 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 DCA26LA142Accident · No injuriesClass 4 · LimitedFinal reportBoeing 787 · Houston, TXThe captain’s inadvertent activation of the takeoff/go around switch at touchdown that caused an increase in the airplane pitch attitude that was not corrected before the lower fuselage contacted the runway.NTSB DCA26LA115Accident · No injuriesClass 4 · LimitedFinal reportAirbus A321-271NX · San Francisco, CAThe first officer’s excessive aft sidestick input combined with decaying airspeed during initiation of a go-around, resulting in an increase in the airplane pitch attitude and subsequent lower fuselage contacting the runway.NTSB DCA25LA085Accident · No injuriesClass 4 · LimitedFinal reportBoeing 767 · San Bernardino, CAEncounter with windshear during landing which resulted in a tailstrike.NTSB CEN23LA319Accident · No injuriesClass 3 · LimitedFinal reportAlisport Silent 2 Electro · Wallis, TXThe failure of the tail boom structure due to cyclic torsion overloading as of a result of flutter in the empennage. The reason for the flutter could not be determined.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 CEN20LA327Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman G164 · Alicia, ARInadequate maintenance of panel fasteners, which led to a side panel coming loose during takeoff and the pilot having to make a subsequent forced landing to a flooded rice field when the airplane became difficult to control.NTSB ANC20LA064Accident · No injuriesClass 3 · LimitedFinal reportPiper PA22 · Soldotna, AKThe delamination of the fabric material from the fuselage above the windscreen due to failed adhesive, which resulted in disrupted airflow and a subsequent hard landing.NTSB WPR19LA171Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Deer Park, WAAn empennage flutter event for reasons that could not be determined based on the available information.NTSB GAA18CA329Accident · No injuriesData collectionFinal reportDobbs George Coot · Malone, WIThe pilot’s improper decision to take off with a known structural issue, which resulted in hull damage.NTSB WPR17FA089Accident · 1 fatalField investigationFinal reportAppleby Nieuport 28 · Paso Robles, CAThe failure of unknown personnel to properly safety an elevator control cable turnbuckle, which disconnected in flight resulting in loss of pitch control. Contributing to the accident was the inadequate design of the experimental airplane, which did not…NTSB DCA16FA217Accident · No injuriesField investigationFinal reportBoeing 737-700 · Pensacola, FLA low-cycle fatigue crack in the dovetail of fan blade No. 23, which resulted in the fan blade separating in flight and impacting the fan case. This impact caused the fan blade to fracture into fragments that traveled farther than expected into the inlet,…NTSB GAA15CA251Accident · Minor injuriesData collectionFinal reportAir Tractor AT 402A · Fort Pierre, SDThe pilot's failure to maintain obstacle clearance, which resulted in the airplane striking guy-wires during aerial application operations.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 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 CEN11IA108Incident · No injuriesIncident investigationFinal reportPiaggio P180 · Columbus, OHThe failure of water to properly drain through the fuselage drain holes, thus becoming trapped and freezing around the flight control cables, which resulted in the loss of control authority to the airplane's ailerons, elevator, and rudder.NTSB CEN09LA586Accident · No injuriesLimited investigationFinal reportCessna 172S · Duluth, MNThe pilot's failure to maintain aircraft control during landing, resulting in a hard landing and a propeller strike with the ground.NTSB CEN09CA521Accident · No injuriesData collectionFinal reportMaule M-4-220C · Abernathy, TXThe failure of the fuselage's tube structure due to corrosion during a hard landing.NTSB CEN09LA379Accident · No injuriesLimited investigationFinal reportUrban Air Sro UFM-13 · Bourne Stage, TXThe pilot’s exceedance of the aircraft’s placarded never-exceed speed (Vne), resulting in aerodynamic flutter in the empennage and the subsequent in-flight structural failure of the aft portion of the fuselage.