NTSB investigations, CA
40 cases where the sequence of events included Part(s) separation from AC.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 5 |
| 2010 | 2 |
| 2011 | 2 |
| 2012 | 1 |
| 2014 | 4 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 4 |
| 2018 | 5 |
| 2019 | 4 |
| 2020 | 5 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '338' 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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '338' 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 WPR23LA112Accident · 1 fatalClass 3 · LimitedFinal reportStar Lite SL1 · Corning, CAThe student pilot’s loss of airplane control during an intentional aerobatic maneuver, which resulted in an inflight separation of the left wing and subsequent impact with the terrain.NTSB DCA22FA082Accident · No injuriesClass 3 · FieldFinal reportJoby Aero JAS4-2 · Jolon, CAThe separation of a propeller blade during expansion flight testing that resulted in cascading effects to include the separation of multiple propulsion motor/propeller assemblies and the loss of remote pilot control of the aircraft. Contributing to the…NTSB WPR21FA300Accident · 4 fatalClass 3 · FieldFinal reportRobinson Helicopter R66 · Colusa, CAThe pilot’s abrupt flight control input that led to mast bumping and a subsequent in-flight breakup.NTSB WPR20CA275Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Susanville, CAThe pilot's failure to maintain directional control during takeoff with a tailwind, which resulted in a subsequent collapse of the right main landing gear.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 WPR20CA064Accident · Minor injuriesData collectionFinal reportAirborne XT912 · Hawthorne, CAThe student pilot's failure to arrest the airplane’s descent rate, which resulted in a hard landing.NTSB WPR20LA062Accident · No injuriesClass 3 · LimitedFinal reportCessna 172H · El Monte, CAThe inflight separation of a section of a propeller blade due to a fatigue crack which resulted in a forced landing.NTSB WPR20CA060Accident · No injuriesData collectionFinal reportCessna 150 · Twentynine Palms, CAThe pilot's poor preflight planning, during which he failed to verify the proper procedure to activate the runway lights; his inability to locate the airport without lighting; and the airplane’s subsequent low-fuel state as he circled looking for the airport,…NTSB WPR20LA026Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 · Livermore, CAThe improper installation of the flight control stick, which resulted in separation of the flight control stick from the stick stub assembly and an uncontrolled descent and impact with terrain.NTSB WPR19LA255Accident · No injuriesClass 3 · LimitedFinal reportSikorsky S58 · Azusa, CAThe in-flight separation of a section of the tail rotor blade due to a fatigue crack, which resulted in the pilot’s forced autorotation into a field.NTSB WPR19LA242Accident · No injuriesClass 3 · LimitedFinal reportLockheed C130 · Santa Barbara, CAThe failure of the No. 3 bleed air duct due to corrosion, which resulted in numerous system failures and the pilot’s inability to maintain directional control during the landing roll.NTSB WPR19FA079Accident · 5 fatalClass 3 · FieldFinal reportCessna 414 · Yorba Linda, CAThe pilot’s failure to maintain airplane control after entering instrument meteorological conditions (IMC) while climbing due to spatial disorientation, which resulted in the exceedance of the airplane’s design stress limits and subsequent in-flight break-up.…NTSB GAA19CA014Accident · No injuriesData collectionFinal reportCessna 172 · Stockton, CAThe student pilot's failure to maintain directional control during takeoff.NTSB WPR18FA171Accident · 2 fatalClass 2 · FieldFinal reportBeech A35 · Hesperia, CAThe pilot's failure to maintain airplane control during an attempted return to the airport following the separation of the spinner bulkhead during takeoff as a result of fatigue cracking. Contributing to the accident was the pilot's improper decision to fly…NTSB WPR18FA143Accident · 1 fatalField investigationFinal reportI.C.A.-Brasov IS 29D · Avenal, CAThe pilot's improper installation of the wings onto the glider, which resulted in an in-flight wing separation. Contributing to the accident were the pilot's limited familiarity with the design and a lack of reliable assembly guidance.NTSB WPR18FA088Accident · 4 fatalField investigationFinal reportHastings Thomas G Cirrus VK 30 · Agua Dulce, CAThe driveshaft fracture due to overstress loading and rotational bending as a result of the under-torqued nuts on the elastomeric couplings backing off and the subsequent in-flight separation of the horizontal fairing due to contact with the separated end of…NTSB GAA18CA102Accident · No injuriesData collectionFinal reportPiper PA 28 · Corona, CAThe student pilot and flight instructor’s failure to see and avoid powerlines during a simulated emergency landing, which resulted in a wire strike during a go-around.NTSB GAA18CA077Accident · No injuriesData collectionFinal reportCzech Sport Aircraft a.s. Sport Cruiser · Sacramento, CAThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.NTSB WPR17LA167Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Santa Ana, CAThe pilot's failure to maintain helicopter control while maneuvering during takeoff.NTSB GAA17CA321Accident · No injuriesData collectionFinal reportAg-Cat G 164 · Tulelake, CAThe pilot’s improper decision to perform a low altitude fly-by over ground equipment, which resulted in the airplane striking the equipment.NTSB GAA17CA146Accident · No injuriesData collectionFinal reportKaman Aerospace K 1200 · Julian, CAThe pilot’s failure to conduct a thru-flight walkaround inspection, which resulted in the engine cowling remaining open and subsequently separating from the helicopter and striking the main rotor blades and vertical stabilizer during departure.NTSB GAA16CA430Accident · No injuriesData collectionFinal reportPzl-Swidnik PW 6U · Llano, CAThe pilot’s failure to properly secure the two aft canopy latches during the preflight inspection, which resulted in the canopy separating from the glider during the takeoff roll and substantial damage to the vertical stabilizer.NTSB GAA16LA056Accident · No injuriesLimited investigationFinal reportAirbus EC135 · Apple Valley, CAThe ingestion of a towel from an unsecured storage container at the landing site into the helicopter's fenestron during the landing.NTSB WPR16LA018Accident · No injuriesLimited investigationFinal reportCessna 120 · Lone Pine, CAThe fracture of the left main landing gear (MLG) wheel axle due to fatigue, which resulted in the separation of the left MLG wheel during takeoff from a dirt airstrip.NTSB GAA16CA010Accident · No injuriesData collectionFinal reportGrosch Starduster TOO SA 30 · Lincoln, CAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop, left main landing gear collapse, and the left wing striking the runway.NTSB WPR15LA025Accident · No injuriesLimited investigationFinal reportCessna 172S · Santa Monica, CAThe separation of a section of a propeller blade due to fatigue cracking. Contributing to the accident was the operator’s failure to comply with the manufacturer’s maintenance and inspection instructions.NTSB WPR14LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Lone Pine, CAThe fatigue failure of a propeller blade due to a propeller strike by/of an unidentified object at an unknown time.NTSB WPR14LA141Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Porterville, CAThe student pilot’s failure to maintain directional control during takeoff.NTSB WPR14LA096Accident · 2 fatalLimited investigationFinal reportMorrisey 2150 · Pismo Beach, CAThe in-flight separation of a wing for reasons that could not be determined because the wreckage was not recovered from the ocean.NTSB WPR12LA115Accident · Serious injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · Farmington, CAThe in-flight separation of the wood portion of one main rotor blade while maneuvering at low level, the reason for which could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR11LA273Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Marysville, CAThe separation of the right main landing gear during takeoff, due to fatigue.NTSB WPR11CA157Accident · No injuriesData collectionFinal reportAeronca 7EC · Big Bear City, CAThe pilot's improper maintenance, which resulted in a wheel separating from the airplane during takeoff, and the airplane's subsequent nose over during the landing rollout.NTSB WPR10LA381Accident · 2 fatalLimited investigationFinal reportAdvertising Mgmt & Consulting Velocity Super XLRG5 · San Diego, CAThe pilot did not close and secure the right passenger door, which resulted in an in-flight separation of the door and subsequent loss of engine power due to the door’s collision with the rear-mounted engine assembly.NTSB WPR10LA117Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A · Shafter, CAThe loss of a main rotor blade counterweight due to corrosion. Contributing to the accident was the failure of the operator to perform the initial and recurrent inspections required by a Service Bulletin to detect the corrosion in the counterweight.NTSB WPR09CA434Accident · No injuriesData collectionFinal reportCessna 195 · Camarillo, CAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR09LA340Accident · No injuriesLimited investigationFinal reportBender Kitfox · Valencia, CAThe failure and separation of a propeller blade for undetermined reasons.NTSB WPR09FA234Accident · 2 fatalField investigationFinal reportUpton Bakeng Duce · Ramona, CAAn in-flight separation of the right wing, which resulted from the pilot's performance of a maneuver that produced aerodynamic loads that exceeded the wing spar’s degraded strength. The wing spar strength degradation was due to the builder's failure to comply…NTSB WPR09IA187Incident · No injuriesIncident investigationFinal reportLiberty Aerospace Liberty XL-2 · Camarillo, CAThe cruise flight separation of the canopy door. Contributing to the incident was the pilot's failure to ensure that the left side door was securely closed prior to takeoff.NTSB WPR09FA104Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Fillmore, CAAn in-flight break-up while maneuvering as a result of the main rotor blades diverging from the normal plane of rotation and severing the tailboom. The underlying reason for the main rotor divergence could not be determined.NTSB LAX08LA183Accident · Minor injuriesLimited investigationFinal reportRobinson R44 II · Topanga, CAThe in-flight separation of the tail rotor gear box for an undetermined reason. Contributing to the accident was the hilly terrain, which was unsuitable for a forced landing.