NTSB investigations, CA
23 cases where NTSB found Maintenance/inspections.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 3 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 3 |
| 2021 | 1 |
| 2022 | 2 |
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\", '010105'))
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", '010105')) 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 WPR22LA149Accident · No injuriesClass 3 · LimitedFinal reportDietrich Ryan S-4 Coyote 1 · Chula Vista, CAThe pilot/owner and maintenance personnel’s improper installation of the right wing’s aft lift strut to the right wing, which resulted in a loss of lift during takeoff, an uncommanded right roll, and an impact with terrain.NTSB WPR22LA090Accident · Minor injuriesClass 3 · LimitedFinal reportTextron TTX Inc. T240 · Ravendale, CAThe inadequate maintenance and inspection of the engine induction system, which resulted in the separation of the right induction tube from the turbocharger compressor outlet and the subsequent loss of engine power during departure.NTSB WPR22LA005Accident · No injuriesClass 3 · LimitedFinal reportBeech B36TC · Los Banos, CAThe total loss of engine power due to the improper installation of the No. 4 connecting rod bolt nut during a recent overhaul.NTSB WPR18LA058Accident · No injuriesLimited investigationFinal reportCessna 210 · San Bernardino, CAThe fatigue failure of the left main landing gear (MLG) saddle, which resulted in the pilot's inability to extend the left MLG. Contributing to the accident was the pilot's improper decision to fly the airplane before the annual inspection was completed and…NTSB WPR17LA188Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · El Dorado Hills, CAMaintenance personnel's inadequate routine maintenance on the helicopter engine, which led to low cylinder compression, improper magneto timing, and camshaft lobe wear, which subsequently resulted in degraded engine performance.NTSB WPR17LA097Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Santa Barbara, CAA total loss of engine power during cruise flight due to the failure of an engine piston rod for reasons that could not be determined due to extensive damage.NTSB WPR16LA134Accident · No injuriesLimited investigationFinal reportBell OH 58A · Brawley, CAThe engine's degraded performance due to excessive wear of the engine bleed valve, which prevented it from closing during the accident flight. Contributing to the accident was the operator's failure to overhaul the bleed valve within the…NTSB WPR15FA121Accident · Serious injuriesField investigationFinal reportRyan Aeronautical ST3KR · Santa Monica, CAA total loss of engine power during initial climb when the carburetor main metering jet became unseated, which led to an extremely rich fuel-to-air ratio. Contributing to the accident was the lack of adequate carburetor maintenance instructions. Contributing…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 WPR14CA295Accident · No injuriesData collectionFinal reportCessna R182 · El Monte, CAThe failure of the right main landing gear pivot assembly. Contributing to the accident was the owner's failure to perform an inspection of the assembly in accordance with the manufacturer's service bulletin.NTSB WPR14LA130Accident · No injuriesLimited investigationFinal reportGrumman G164 - A · Caruthers, CAAn undetected fatigue crack in the landing gear leg, which initiated at an electrical arc-induced damage site of undetermined origin and resulted in landing gear failure. Contributing to the severity of damage to the airplane was the close proximity of an…NTSB WPR13LA404Accident · No injuriesLimited investigationFinal reportBell 47G5 · King City, CAThe failure of the helicopter’s center frame tube due to a fatigue crack and corrosion originating from a welded surface. Contributing to the accident was maintenance personnel’s inadequate inspection of the helicopter during its most recent 100-hour…NTSB WPR13LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Corona, CATotal loss of engine power during the landing approach due to insect debris in the carburetor metering valve, which resulted in fuel starvation.NTSB WPR12LA315Accident · No injuriesLimited investigationFinal reportPiper PA-32S-300 · Adelanto, CAThe pilot’s failure to maintain directional control during the aborted takeoff, which was aborted due to fuel starvation as a result of an inadvertent in-flight activation of the fuel drain activation lever by the passenger. Contributing to the accident was…NTSB WPR12FA012Accident · 3 fatalField investigationFinal reportBeech E33 · Daggett, CAA loss of engine power due to the separation of a connecting rod, and the pilot's failure to maintain airplane control during a sudden maneuver to avoid power lines during the descent, which resulted in an unrecoverable aerodynamic stall and subsequent spin.…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 WPR11LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · Santa Ana, CAThe failure of the left main landing gear due to the lack of lubrication.NTSB WPR11LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chino, CAFatigue cracking of the upper torque-link attach lugs on the left main landing gear strut, which resulted in separation of the left main landing gear during taxi.NTSB WPR11FA059Accident · 1 fatalField investigationFinal reportMooney M20R · Hollister, CAThe pilot did not ensure the airplane was loaded within its weight and balance envelope, which resulted in longitudinal instability and a loss of aircraft control during the initial climb.NTSB WPR10LA126Accident · Serious injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58A · Escalon, CAA loss of engine power during cruise flight due to the fatigue failure of the pneumatic fuel-to-governor control line. Also causal was the inadequate installation of the pneumatic line by maintenance personnel, and the pilot’s decision to continue flight with…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 WPR09LA337Accident · Minor injuriesLimited investigationFinal reportEngineering & Research 415C · Corona, CAA total loss of engine power during cruise flight for undetermined reasons.NTSB LAX08LA292Accident · No injuriesLimited investigationFinal reportCessna T210N · Oakland, CAA loss of engine power while maneuvering due to the disintegration of the number two main bearing, which resulted in a fracture of the crankshaft. Contributing to the accident was inadequate maintenance.