NTSB investigations
10 cases where NTSB found Vertical stabilizer.
Cases per year
| 2008 | 2 |
|---|---|
| 2011 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2023 | 1 |
| 2024 | 1 |
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 starts_with(f.\"findingCode\", '01035530')) 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 starts_with(f."findingCode", '01035530')) 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 ERA24LA250Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Vero Beach, FLExcessive side loading of the vertical stabilizer.NTSB CEN24LA035Accident · No injuriesClass 4 · LimitedFinal reportGrassman Timothy B RV-14A · Houston, TXThe bird strike to the airplane’s vertical stabilizer during an approach for landing.NTSB WPR17FA134Accident · 2 fatalField investigationFinal reportJordan John RV7 · Arlington, AZThe inflight overstress separation of the vertical stabilizer and rudder during flight which resulted in the pilot's inability to maintain airplane control. Contributing to the accident was an inflight collision with a bird.NTSB WPR17LA034Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58A · Sacramento, CAThe failure of the vertical stabilizer due to fatigue.NTSB CEN16LA281Accident · 2 fatalLimited investigationFinal reportVans RV9 · Springfield, OHThe pilot’s decision to fly into known thunderstorms, which resulted in an in-flight breakup.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 CEN14LA508Accident · 2 fatalLimited investigationFinal reportBrupbacher Chris CB2000 · Reserve, LAThe failure of the flight control rod bearing due to an undetected preexisting corrosion-induced crack, which resulted in the main rotor blades going to full pitch and the rotor mast folding; this allowed the pusher propeller to strike and sever the tail.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 CEN09LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-285 · Silverton, TXThe pilot's failure to maintain clearance from a transmission wire.NTSB LAX08LA160Accident · 1 fatalLimited investigationFinal reportQuad City Ultralight Challenger LSS · Moses Lake, WAThe pilot's inability to maintain control due to an in-flight separation of the vertical fin as a result of the failure of the airplane's builder to properly secure the vertical fin to the fuselage.