NTSB investigations, CA
9 cases where NTSB found Empennage structure.
Cases per year
| 2010 | 2 |
|---|---|
| 2011 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2024 | 1 |
Where
Latest 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010355'))
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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010355')) 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 DCA24LA206Accident · No injuriesClass 3 · LimitedFinal reportBoeing 737-8 · Oakland, CADamage to the standby rudder power control unit connection to the vertical fin due to an extreme high wind event while the airplane was parked, which remained undetected and resulted in anomalous operation of the standby rudder power control unit.…NTSB DCA20LA107Accident · No injuriesClass 3 · LimitedFinal reportBoeing 737 · Victorville, CAImproper installation of dorsal fin attach bolts which caused the dorsal fin to separate during flight, substantially damaging the left horizontal stabilizer.NTSB DCA20IA034Incident · No injuriesIncident investigationFinal reportAirbus AS 350 B2 · Los Angeles, CAan inflight collision with a hard object of polycarbonate construction, with size and features consistent with that of a small UAS (drone).NTSB WPR17FA117Accident · 1 fatalField investigationFinal reportCessna 180 · Ventura, CAThe pilot's abrupt and substantial pullup maneuver while flying the airplane above the maneuvering speed, which resulted in an in-flight breakup. The reason for the pilot's maneuver could not be determined based on the available evidence.NTSB WPR17LA034Accident · No injuriesClass 3 · LimitedFinal reportBell OH 58A · Sacramento, CAThe failure of the vertical stabilizer due to fatigue.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 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 WPR10LA306Accident · No injuriesLimited investigationFinal reportLuscombe 11A · Merced, CAThe pilot’s inability to maintain airplane control during cruise flight due to the failure of the elevator trim tab as a result of missing hardware for the elevator control cable bellcrank to elevator torque tube attachment bracket.NTSB WPR10CA226Accident · No injuriesData collectionFinal reportBeech B35 · Burbank, CAThe airplane's encounter with turbulence while at an airspeed above maneuvering airspeed, which exceeded the limit load of the stabilizers and ruddervators.