NTSB investigations, CA
286 cases where NTSB found Aircraft power plant.
Cases per year
| 2008 | 21 |
|---|---|
| 2009 | 28 |
| 2010 | 19 |
| 2011 | 24 |
| 2012 | 14 |
| 2013 | 12 |
| 2014 | 12 |
| 2015 | 14 |
| 2016 | 11 |
| 2017 | 19 |
| 2018 | 14 |
| 2019 | 19 |
| 2020 | 17 |
| 2021 | 12 |
| 2022 | 14 |
| 2023 | 13 |
| 2024 | 18 |
| 2025 | 4 |
| 2026 | 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\", '0105'))
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", '0105')) 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 WPR26LA115Accident · No injuriesClass 4 · LimitedFinal reportMightyfly MF-100 · Atwater, CAA control system anomaly, which resulted in the overload and failure of one of the propulsion motor systems during the transition from hover to forward flight.NTSB WPR25LA175Accident · No injuriesClass 3 · LimitedFinal reportCessna 182P · Hyampom, CAThe pilot’s failure to use carburetor heat, which resulted in a loss of engine power due to carburetor icing and a subsequent impact with terrain during a forced landing.NTSB WPR25LA095Accident · No injuriesClass 4 · LimitedFinal reportQuicksilver Aeronautics L-S2S · Geyserville, CAThe pilot’s failure to secure the coolant cap during the preflight inspection, which resulted in a total loss of engine power due to overheating and a subsequent forced landing.NTSB WPR25LA091Accident · No injuriesClass 4 · LimitedFinal reportCessna 182N · Auburn, CAThe pilot’s improper use of throttle and brakes during engine start that resulted in a loss of control and impact with a hangar.NTSB WPR25LA082Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172K · Columbia, CAA partial loss of engine power for undetermined reasons.NTSB WPR25LA039Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32-300 · Pomona, CAA total loss of engine power during final approach for reasons that could not be determined.NTSB WPR25LA011Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Corcoran, CAA total loss of engine power due to the pilot's improper manipulation of the condition lever during flight, which resulted in fuel starvation and a forced landing.NTSB WPR24LA314Accident · Minor injuriesClass 3 · LimitedFinal reportCessna U206G · West Sacramento, CAFailure of the No. 4 cylinder fuel injection assembly tube and subsequent total loss of engine power.NTSB WPR24FA287Accident · Serious injuriesClass 3 · FieldFinal reportPitts S1 · Santa Paula, CAThe total loss of engine power at low altitude for reasons that could not be determined.NTSB WPR24LA267Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-201T · Sacramento, CAA loss of engine power during the initial climb due to the detachment of the turbocharger’s inlet sleeve as a result of the installation of an incorrect sleeve clamp.NTSB WPR24LA269Accident · No injuriesClass 3 · LimitedFinal reportProtech PT2 · Lodi, CAA reported loss of engine power for reasons that could not be determined.NTSB WPR24LA261Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Winchester, CAA total loss of engine power due to a fatigue fracture of the crankshaft.NTSB WPR24LA229Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · San Diego, CAA failure of the No. 2 cylinder due to fatigue cracking as the result of an undersized fillet radius around the edge of the cylinder head dome.NTSB WPR24LA210Accident · No injuriesClass 3 · LimitedFinal reportLancair LC42-550FG · Humboldt Bay, CAMaintenance personnel’s incorrect installation of an engine rocker cover gasket, which resulted in oil exhaustion and subsequent loss of engine power during the initial climb.NTSB WPR24LA160Accident · Minor injuriesClass 3 · LimitedFinal reportSteen Skybolt · Santa Maria, CAA total loss of engine power during approach for reasons that could not be determined.NTSB WPR24LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna 172G · Lakeport, CAThe pilot’s inadequate use of carburetor heat, which resulted in a total loss of engine power shortly after takeoff due to fuel starvation as a result of carburetor ice.NTSB WPR24LA135Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 17-31ATC · El Cajon, CAMaintenance personnel’s improper installation of an engine-driven vacuum pump, which resulted in oil starvation to the engine and a subsequent total loss of engine power. Contributing to the accident was the A&P IA’s lack of supervision.NTSB WPR24LA121Accident · No injuriesClass 3 · LimitedFinal reportKitfox Series 5 · Yucca Grove, CAThe pilot’s improper repair of the oil sump, which resulted in a loss of oil pressure and collision with terrain during a precautionary landing.NTSB WPR24LA117Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Acton, CAThe pilots inability to fully turn off the carburetor heat which resulted in a reduction of engine power and reduced climb performance. Contributing to the accident was the pilots delayed recovery from the simulated emergency landing.NTSB WPR24LA093Accident · Minor injuriesClass 3 · LimitedFinal reportBell 47G-3B-1 · Garey, CAMaintenance personnel’s failure to properly check the torque paint on a fuel control unit B-nut, which resulted in the loosening of the B-nut, a loss of engine power at a low altitude, and a subsequent impact with terrain.NTSB WPR24LA081Accident · Serious injuriesClass 3 · LimitedFinal reportChristopher Randall Raptor Junior 540 · Camarillo, CAA total loss of engine power due to the loss of power to the electronic fuel injection and ignition system, which was the result of a loose connection between a common ground feed-through stud and the ground bus.NTSB WPR24FA080Accident · 1 fatalClass 3 · FieldFinal reportSwanson R/Swanson S RV-6 · Concord, CAA total loss of engine power during takeoff due to a separated fuel line and the pilot’s subsequent failure to maintain control of the airplane. Contributing to the accident were the pilot's medical condition and the effects of multiple impairing substances.NTSB WPR24LA070Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-502A · Stratford, CAA partial loss of engine power due to the malfunction of the engine compressor bleed-off valve.NTSB WPR24LA041Accident · No injuriesClass 3 · LimitedFinal reportBell OH-58A · Brawley, CAA total loss of engine power due to the failure of the No. 8 bearing and the subsequent failure of the scavenge oil pump.NTSB WPR24LA023Accident · No injuriesClass 3 · LimitedFinal reportVans RV-12 · Novato, CAA partial loss of engine power during initial climb for undetermined reasons.NTSB WPR23LA352Accident · Serious injuriesClass 3 · LimitedFinal reportWayne Toddun Sling 4 TSI · San Pedro, CAA total loss of engine power due to a failure of the No. 4 cylinder exhaust valve from overheating and excessive wear.NTSB WPR23LA341Accident · No injuriesClass 3 · LimitedFinal reportBellanca 7ECA · El Cajon, CAA total loss of engine power for undetermined reasons.NTSB WPR23FA299Accident · 2 fatalClass 3 · FieldFinal reportCzech Sport SportCruiser · Van Nuys, CAThe misalignment of the carburetor piston slides, which resulted in a partial loss of engine power, and the flight instructor’s failure to maintain control of the airplane during an emergency landing, leading to an aerodynamic stall and impact with terrain.NTSB WPR23LA264Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A185F · La Mesa, CAA total loss of engine power for undetermined reasons.NTSB WPR23LA262Accident · Serious injuriesClass 4 · LimitedFinal reportBeech P35 · Shelter Cove, CAA partial loss of engine power for reasons that could not be determined because the airplane was not located and recovered.NTSB WPR23LA249Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Meeks Bay, CAA loss of engine power for reasons that could not be determined based on the available information.NTSB WPR23LA239Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Alturas, CAA loss of engine power due to the failure of the right magneto distributor gear and the pilot’s decision to conduct a test flight with known mechanical issues.NTSB WPR23LA156Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Riverside, CAThe pilot’s failure to use carburetor heat during an extended ground delay before takeoff, which resulted in a total loss of engine power during initial climb due to carburetor ice.NTSB WPR23LA121Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · San Andreas, CAA loss of engine power for undetermined reasons.NTSB WPR23LA098Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210N · Murrieta, CAA loss of engine power during the turn from base to final for undetermined reasons. Contributing to the accident was the pilot’s decision to not maintain traffic pattern altitude, which resulted in the off-airport landing.NTSB WPR23LA094Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Carlsbad, CAA failure of the No. 2 piston connecting rod bearing due to oil starvation for reasons that could not be determined, which resulted in a complete loss of engine power.NTSB WPR23LA077Accident · Serious injuriesClass 3 · LimitedFinal reportBeech V35B · Livermore, CAThe pilot’s inadvertent use of the mixture control instead of the throttle, which resulted in fuel starvation and the subsequent loss of engine power.NTSB WPR23FA073Accident · 1 fatalClass 3 · FieldFinal reportCessna 150A · Santa Monica, CAA failure of the No. 1 piston connecting rod bearing journal due to oil starvation for reasons that could not be determined, which resulted in a complete loss of engine power.NTSB WPR23FA044Accident · 1 fatalClass 3 · FieldFinal reportGallagher XLT-RG · Banning, CAAn inflight engine fire for reasons that could not be determined that resulted in impact with terrain.NTSB WPR22LA351Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172L · Ventura, CAA partial loss of engine power due to the fatigue fracture of the No. 4 exhaust valve.NTSB WPR22FA335Accident · 1 fatalClass 3 · FieldFinal reportRutan Varieze · Columbia, CAThe pilot’s improper maintenance of the ignition system, which led to an ignition system failure and a loss of engine power.NTSB WPR22LA333Accident · Serious injuriesClass 3 · LimitedFinal reportBell 407 · Mount Baldy, CAThe pilot’s failure to ensure the throttle was properly positioned before commencing an approach to land, which resulted in a low rotor rpm condition and impact with terrain. Contributing to the accident was a worn throttle detent.NTSB WPR22FA331Accident · 1 fatalClass 3 · FieldFinal reportYakovlev YAK-11 · Shafter, CAThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the loss of engine oil pressure shortly after takeoff.NTSB WPR22LA316Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150H · Vacaville, CAThe partial loss of engine power due to a stuck exhaust valve.NTSB WPR22LA287Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Livermore, CAThe total loss of engine power due to an inadequately maintained fuel injection servo.NTSB WPR22FA265Accident · 1 fatalClass 3 · FieldFinal reportNorth American T-28B · Fallbrook, CAA loss of power due to an unmaintained carburetor diaphragm and inoperative electric fuel pump that resulted in fuel starvation to the engine.NTSB WPR22LA259Accident · Minor injuriesClass 3 · LimitedFinal reportSocata TB21 · San Marcos, CAThe failure of the mechanical fuel pump due to internal friction for reasons that could not be determined based on available evidence, which resulted in a total loss of engine power.NTSB WPR22LA174Accident · Serious injuriesClass 3 · LimitedFinal reportBell Helicopter Textron Canada 407 · Livermore, CALoss of engine power due to the pilot inadvertently selecting engine IDLE mode while in flight, which reduced rotor and engine speed to a level that could not sustain flight.NTSB WPR22LA133Accident · Serious injuriesClass 3 · LimitedFinal reportAdams Dennis Allen Varieze · Mojave, CAThe failure of the carburetor intake Sceet tubing, which resulted in a total loss of engine power.NTSB WPR22LA099Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Napa, CAThe loss of engine power for undetermined reasons, which resulted in an off-airport landing on unimproved terrain.