NTSB investigations, CA
89 cases where the sequence of events included Sys/Comp malf/fail (non-power).
Cases, newest first
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\" = '330' 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" = '330' 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 WPR13LA214Accident · No injuriesLimited investigationFinal reportCessna 421A · Oakland, CAA failure of the left main landing gear pivot bolt in overstress during landing.NTSB WPR13LA184Accident · Serious injuriesLimited investigationFinal reportBeech A36TC · Big Bear City, CAThe improper overhaul of the propeller, which resulted in the installation of an incorrect propeller actuating pin and deformation of the ferrule hole and led to the pin’s fatigue failure. Contributing to the accident was the failure of multiple owners and…NTSB WPR13LA112Accident · No injuriesLimited investigationFinal reportCessna 305A · Camarillo, CAA tailwheel vibration upon touchdown and the subsequent loss of directional control for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR12LA233Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Wilton, CAThe failure of the hopper gate mechanism and subsequent sulfur fire during a low-level maneuver.NTSB WPR12LA081Accident · Minor injuriesLimited investigationFinal reportMas Events Nemesis · Camarillo, CAA partial loss of engine power during cruise flight due to incorrectly installed airframe components, which came into contact with a high pressure fuel line and resulted in its failure. Contributing to the accident was an undetermined failure of the primary…NTSB WPR12LA096Accident · No injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58A · Brawley, CAThe failure of the main rotor mast due to fatigue cracks that originated from corrosion pits. Contributing to the accident was the operator’s failure to adhere to the manufacturer’s recommended overhaul interval for the main rotor mast.NTSB WPR12LA097Accident · No injuriesLimited investigationFinal reportBeech 58P · Santa Ana, CAThe pilot’s failure to review or execute any applicable checklist procedures or troubleshoot or take corrective action before landing despite indications that the landing gear was not extended. Contributing to the accident were the pilot’s misunderstanding of…NTSB WPR12LA052Accident · No injuriesLimited investigationFinal reportBeech 76 · San Carlos, CAThe collapse of the right main landing gear during the turn off the runway due to the failure of the A-frame assembly.NTSB WPR11LA303Accident · Serious injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58C · Brentwood, CAThe failure of the main rotor mast due to fatigue cracking originating from corrosion pits.NTSB WPR11LA282Accident · No injuriesLimited investigationFinal reportHiller UH12E · Hanford, CAThe separation of the tail rotor drive gear shaft due to torsional fatigue of its threaded portion, which resulted in a loss of tail rotor control.NTSB WPR11LA363Accident · No injuriesLimited investigationFinal reportCessna 340A · Fullerton, CAThe pilot's inability to maintain directional control during landing due to the left brake's degraded performance due to oil contamination, which resulted from the fatigue failure of an oil line component.NTSB DCA11PA075Accident · Minor injuriesFinal reportBoeing 707-321B · Point Mugu, CAthe failure of a midspar fitting, which was susceptible to fatigue cracking and should have been replaced with a newer, more fatigue-resistant version of the fitting as required by an airworthiness directive. Also causal was an erroneous maintenance entry…NTSB WPR11LA205Accident · Minor injuriesLimited investigationFinal reportBennett Midjet Mustang I · Ramona, CAThe pilot's inability to maintain directional control during the landing roll due to the overload separation of the left brake master cylinder from the left rudder pedal assembly.NTSB WPR11LA119Accident · No injuriesLimited investigationFinal reportCzech Sportplanes Sro Dynamic · Palm Springs, CAInadvertent opening of the airplane canopy during the landing approach in a downdraft, which resulted in a rapid descent and hard landing.NTSB WPR11LA092Accident · No injuriesLimited investigationFinal reportCessna 310C · Lancaster, CAThe pilot did not maintain an appropriate descent profile during the approach. Contributing to the accident was that the pilot did not follow checklist procedures.NTSB WPR11LA063Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Rialto, CAFatigue cracking of the left main landing gear leg, which resulted in a gear collapse during landing.NTSB WPR10TA318Accident · No injuriesFinal reportBell UH-1H · Santa Barbara, CAThe failure of left tailboom upper attachment fitting as a result of fatigue.NTSB WPR10LA276Accident · Serious injuriesLimited investigationFinal reportCzech Aircraft Works Sportcruiser · San Diego, CAThe inadvertent opening of the aircraft canopy during the takeoff climb, which distracted the pilot and resulted in his failure to maintain aircraft control. Contributing to the accident was a lack of guidance in the manufacturer's pilot operating handbook…NTSB WPR10LA275Accident · Minor injuriesLimited investigationFinal reportAirborne Windsports PTY Edge X · Alturas, CAFracture of a mast support cable due to corrosion, which resulted in a loss of control during the landing roll.NTSB WPR10IA256Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Ontario, CAFailure of the airplane’s nose landing gear to extend for undetermined reasons.NTSB WPR10LA253Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Robbins, CAThe failure of the wheel hub flange, which allowed the over size tire to expand and impinge on the brake disc and caliper, which resulted in a loss of control during the landing.NTSB WPR10LA252Accident · Serious injuriesLimited investigationFinal reportLuscombe Silvaire S-LSA-8C · Bakersfield, CAThe pilot's continued operation of the airplane with known mechanical deficiencies, which resulted in a loss of engine power due to fuel starvation.NTSB WPR09LA341Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Westley, CAThe failure of the landing gear hydraulic line socket, which resulted in a hydraulic leak and in-flight fire. Contributing to the accident was the failure of the owner and/or maintenance facility to comply with the maintenance manual hose replacement schedule.NTSB WPR09LA307Accident · No injuriesLimited investigationFinal reportGunnoe Velocity · Livermore, CAThe failure of the right brake due to a restricted brake rotor and subsequent brake fluid line failure as a result of inadequate maintenance.NTSB WPR09LA287Accident · No injuriesLimited investigationFinal reportHoward Long EZ · Placerville, CAThe pilot's inability to maintain directional control during the landing roll due to a jammed brake cable.NTSB WPR09LA290Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · Columbia, CAThe failure of the left main landing gear drag link as a result of overstress fracture. Contributing to the accident was maintenance personnel's failure to detect a small crack in the left main landing gear drag link during the most recent annual inspection.NTSB WPR09LA245Accident · No injuriesLimited investigationFinal reportCessna 172N · Desert Center, CAA partial loss of engine power due to low compression from an obstructed intake valve. Contributing to the accident was the pilot’s decision to shut down the engine while in flight.NTSB WPR09CA134Accident · No injuriesData collectionFinal reportKreps Thorp T-18-C · Palm Springs, CAA loss of directional control due to the fatigue failure of a tubular steel gear leg along a corroded weld line.NTSB WPR09LA098Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Oceanside, CAA defective alternator wire splice that resulted in an intermittent electrical system malfunction and erroneous fuel gauge readings, and, a loss of engine power for an undetermined reason.NTSB WPR09CA094Accident · No injuriesData collectionFinal reportJones Rodney V Wittman TA · Yucca Valley, CAA loss of directional control due to a weld joint failure of the left rudder pedal.NTSB WPR09LA082Accident · Minor injuriesLimited investigationFinal reportStits Flut-R-Bug SA6B · Los Olivos, CAA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's improper decision to depart from a road with a known unresolved engine problem.NTSB SEA08IA217Incident · No injuriesIncident investigationFinal reportDiamond DA 40 · San Carlos, CAThe improper assembly of the governor during manufacture.NTSB SEA08CA202Accident · No injuriesData collectionFinal reportMooney M20K · Trinity Center, CAThe complete loss of engine power due to fuel exhaustion as a result of a leak in the fuel system. Contributing to the accident was the rough terrain the airplane encountered during the forced landing.NTSB LAX08CA293Accident · No injuriesData collectionFinal reportBrubaker F1 · Truckee, CAThe failure of the bolts securing the tail wheel to its attach point that resulted in a loss of directional control.NTSB LAX08LA242Accident · No injuriesLimited investigationFinal reportGlaser-Dirks Flugzeugbau DG-100G · Truckee, CAA malfunction of the tow release mechanism.NTSB DCA08MA076Accident · No injuriesClass 1 · MajorFinal reportBoeing 767 · San Francisco, CAThe design of the supplemental oxygen system hoses and the lack of positive separation between electrical wiring and electrically conductive oxygen system components. The lack of positive separation allowed a short circuit to breach a combustible oxygen hose,…NTSB LAX08LA066Accident · Serious injuriesLimited investigationFinal reportBartle Lancair IV-P · Murrieta/Temecu, CAA total loss of engine power while on approach due to the electrical overload of a fuse caused by the builder's inadequate design and installation of the electrical ignition system.NTSB LAX08LA063Accident · 1 fatalLimited investigationFinal reportWilson RV-7 · Nevada City, CAThe improper installation of the fuel pump, leading to a fatigue failure of the pump's lever arm and subsequent loss of engine power. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB LAX08LA056Accident · No injuriesLimited investigationFinal reportSmith Zodiac 601XL · Murrieta, CAA loss of engine power due to fuel starvation, which was induced by the electrical system lacking sufficient power to run all of the electrical devices on the airplane and the electrical fuel pump.