NTSB investigations, CA
203 cases where NTSB found Fluids/misc hardware.
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 12 |
| 2010 | 12 |
| 2011 | 13 |
| 2012 | 15 |
| 2013 | 13 |
| 2014 | 8 |
| 2015 | 17 |
| 2016 | 13 |
| 2017 | 12 |
| 2018 | 12 |
| 2019 | 10 |
| 2020 | 15 |
| 2021 | 6 |
| 2022 | 8 |
| 2023 | 10 |
| 2024 | 10 |
| 2025 | 2 |
| 2026 | 3 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0107'))
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", '0107')) 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 WPR26LA268Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-18 · Colusa, CAThe pilot's inadequate fuel planning and in-flight decision making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR26LA207Accident · No injuriesClass 4 · LimitedFinal reportBell 47G-2 · Mettler, CAThe pilot's failure to ensure the loading hose had been disconnected before takeoff, which resulted in an interrupted takeoff and subsequent loss of control. Contributing to the accident was the ground loader's failure to disconnect the hose before…NTSB WPR26LA173Accident · No injuriesClass 4 · LimitedFinal reportPipistrel Alpha Trainer · Salinas, CAThe flight instructor’s inadequate preflight inspection which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR26LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Temecula, CAThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR25LA073AccidentClass 4 · LimitedFinal reportCessna 150D · Temple City, CAThe flight instructor’s unfamiliarity with the fuel quantities the fuel measuring dip stick measured and inadequate preflight inspection which resulted in fuel exhaustion.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 WPR25LA004Accident · No injuriesClass 3 · LimitedFinal reportCessna 172L · El Monte, CAA total loss of engine power due to contaminated fuel.NTSB WPR24LA218Accident · Minor injuriesClass 3 · LimitedFinal reportTL Ultralight Sting RG · Rio Linda, CAA loss of engine power due to fuel exhaustion. Contributing to the accident was a fuel quantity indication that was inconsistent with the actual fuel state of the airplane, which likely led the pilot to overestimate the amount of fuel remaining onboard.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 WPR24LA212Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA31 · Lemoore, CAThe pilot’s improper in-flight decision making which resulted in a total loss of engine power due to fuel exhaustion and a subsequent emergency landing.NTSB WPR24LA167Accident · Minor injuriesClass 4 · LimitedFinal reportCanadian Car & Foundry Harvard MK IV · Modesto, CAThe pilot’s improper fuel tank selection, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was a malfunctioning fuel selector at low fuel levels.NTSB WPR24LA174Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-C33A · San Diego, CAA partial loss of engine power due to water contamination of the fuel system.NTSB WPR24FA123Accident · 1 fatalClass 3 · FieldFinal reportAyres S2R-G10 · Derner, CAThe pilot’s failure to adequately monitor his fuel supply, resulting in fuel exhaustion, a total loss of engine power, and the airplane’s impact with terrain.NTSB WPR24LA114Accident · No injuriesClass 4 · LimitedFinal reportMooney M20K · Farmington, CAThe pilot’s improper preflight fuel planning that resulted in the loss of engine power due to fuel exhaustion.NTSB WPR24LA106Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Whitethorn, CAA total loss of engine power due to water-contaminated fuel.NTSB WPR24FA056Accident · 1 fatalClass 3 · FieldFinal reportVans RV8 · Corona, CAFuel contamination from the pilot’s improper application of a sealant to the fuel tank, which resulted in a partial loss of engine power on takeoff.NTSB WPR24FA037Accident · 1 fatalClass 3 · FieldFinal reportCessna P210N · San Diego, CAA total loss of engine power due to fuel exhaustion. Contributing to the accident were the pilot’s inadequate flight and fuel planning and his decision to fly in night instrument meteorological conditions despite his lack of recent instrument flight.NTSB WPR24LA030Accident · No injuriesClass 3 · LimitedFinal reportArrow Falcon Exporters UH-1H · Firebaugh, CAAn on-ground fuel fire for reasons that could not be determined due to extensive thermal damage.NTSB WPR23LA349Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172N · Compton, CAThe total loss of engine power on takeoff due to water-contaminated fuel. Contributing to the accident was the inadequately maintained fuel system, which resulted in water entering the fuel tanks through the filler caps.NTSB WPR23LA197Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210 · Redding, CAA fuel leak caused by an age-degraded fuel pressure sender hose, which resulted in fuel starvation and a loss of engine power. Contributing to the accident was inadequate maintenance.NTSB WPR23LA176Accident · No injuriesClass 4 · LimitedFinal reportAkroTech Giles G-202 · Santa Barbara, CAA fire that resulted from venting fuel coming into contact with hot exhaust surfaces or exhaust gases. Contributing to the fire was the design and location of the main tank fuel vent.NTSB WPR23LA131Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-4-220C · Santa Ynez, CAThe pilot’s inadequate fuel planning, which resulted in a loss of engine power due to fuel starvation.NTSB WPR23LA118Accident · No injuriesClass 4 · LimitedFinal reportBell UH-1B · Orland, CAThe pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a loss of engine power.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 WPR23LA091Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · San Diego, CAThe flight instructor’s failure to maintain altitude while maneuvering to another runway after the engine cowling opened shortly after takeoff. Contributing to the accident was the failure of both the student pilot and flight instructor to conduct an adequate…NTSB WPR23LA074Accident · Minor injuriesClass 4 · LimitedFinal reportRoyse Ralph L Glasair · Cottonwood, CAThe pilot’s fuel mismanagement which resulted in fuel starvation and a total loss of engine power.NTSB WPR22LA308Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 195 · El Cajon, CAThe pilot’s failure to verify the fuel quantity prior to departure, which led to a loss of engine power due to fuel exhaustion.NTSB WPR22LA271Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32-301 · San Jose, CAThe pilot’s inadequate preflight inspection and fuel management, which resulted in fuel starvation, a total loss of engine power, and an impact with terrain.NTSB WPR22LA268Accident · Minor injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Huntington Beach, CAA total loss of engine power due to fuel starvation and the pilot’s mismanagement of the available fuel at an altitude too low for recovery. Contributing was the pilot’s delayed decision to switch fuel tanks.NTSB WPR22LA243Accident · No injuriesClass 4 · LimitedFinal reportMooney M20C · Oxnard, CAFuel starvation due to an inappropriately maintained and modified fuel selector valve.NTSB WPR21LA368Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Sacramento, CAThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR22LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna T210L · Lancaster, CAA total loss of engine power due to the pilot’s inadequate fuel management which resulted in fuel starvation and subsequent collision with a fence during landing.NTSB WPR22LA076Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172H · Los Angeles, CAThe pilot’s inadequate preflight inspection during which he failed to remove all water contamination in the fuel system, which resulted in a total loss of engine power on takeoff. Contributing to the accident was the condition of the fuel caps, which allowed…NTSB WPR22FA022Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Ukiah, CAA power interruption due to water-contaminated fuel, which resulted in the student pilot aborting the takeoff and landing hard. Contributing to the accident were a leak in the left fuel tank that allowed water to enter and damage to the fuel tank that…NTSB WPR21LA342Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 58 · Palo Alto, CAThe fuelers addition of the incorrect fuel to the fuel tanks which resulted in a total loss of engine power.NTSB WPR21LA200Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164C · Glenn, CAThe pilot’s fuel mismanagement, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport hard landing.NTSB WPR21LA146Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · Watsonville, CAThe pilot’s inadequate fuel management which resulted in the loss of engine power due to fuel starvation.NTSB WPR21LA119Accident · No injuriesClass 3 · LimitedFinal reportMooney M20E · Livermore, CAA total loss of engine power due to fuel starvation as a result of corrosion and rust in the fuel injection servo.NTSB WPR21LA104Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Riverside, CAFuel starvation due to the pilot’s inadequate weather and fuel planning, which resulted in a total loss of engine power.NTSB WPR21LA075Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35 · Santa Ynez, CAThe pilot’s mismanagement of fuel, which resulted in fuel starvation and a total loss of engine power.NTSB WPR21LA055Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · San Bernardino, CAA total loss of engine power due to fuel contamination. Contributing to the accident was an inadequate preflight inspection.NTSB WPR21FA044Accident · 1 fatalClass 3 · FieldFinal reportPiper PA38 · Grass Valley, CAA total loss of engine power due to the pilot’s improper fuel management, which resulted in fuel starvation.NTSB WPR21LA022Accident · No injuriesClass 4 · LimitedFinal reportPiper J3-C65 · El Cajon, CAThe pilot's inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR21LA019Accident · Serious injuriesClass 3 · LimitedFinal reportGlasair III · Hayward, CAA total loss of engine power due to fuel starvation because of a clogged fuel filter. Contributing to the accident was the improper maintenance and inspection of the fuel filter.NTSB WPR21LA012Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Bishop, CAA loss of engine power due to the pilot’s inadvertent closure of the mixture control which starved the engine of fuel and resulted in a hard landing and collision with terrain.NTSB WPR20LA311Accident · Serious injuriesClass 3 · LimitedFinal reportNorth American B25N · Stockton, CAA total loss of engine power due to fuel exhaustion. Contributing to the accident was the erroneous fuel gauge indications and inadequate preflight planning and inspectionNTSB WPR20LA259Accident · Serious injuriesClass 3 · LimitedFinal reportRutan Vari EZE · Kelso Valley, CAThe pilot’s failure to secure the fuel cap, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR20LA234Accident · No injuriesClass 3 · LimitedFinal reportMontana Coyote · Jamul, CAA total loss of engine power due to an obstructed fuel line and fuel starvation, which resulted in a forced landing and collision with a fence. Contributing to the accident was the long duration of aircraft storage that allowed for contaminants to develop and…NTSB WPR20CA199Accident · No injuriesClass 4 · Data collectionFinal reportBeech D 45 · Ione, CAThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and impact with terrain.NTSB WPR20LA172Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R · Imperial, CAThe pilot's loss of control during a landing roll due to a failure of the main O-ring in the right brake assembly, which resulted in a loss of brake pressure and subsequent brake failure.