NTSB investigations, CA
417 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1982 | 33 |
|---|---|
| 1983 | 30 |
| 1984 | 12 |
| 1985 | 14 |
| 1986 | 18 |
| 1987 | 31 |
| 1988 | 11 |
| 1989 | 15 |
| 1990 | 15 |
| 1991 | 24 |
| 1992 | 20 |
| 1993 | 15 |
| 1994 | 20 |
| 1995 | 12 |
| 1996 | 10 |
| 1997 | 14 |
| 1998 | 9 |
| 1999 | 4 |
| 2000 | 19 |
| 2001 | 16 |
| 2002 | 15 |
| 2003 | 14 |
| 2004 | 13 |
| 2005 | 12 |
| 2006 | 10 |
| 2007 | 11 |
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350) 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 SEA08LA012Accident · No injuriesLimited investigationFinal reportBeech F35 · San Carlos, CAA total loss of engine power for undetermined reasons. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB SEA07LA248Accident · Serious injuriesLimited investigationFinal reportHigher Class Sport Hornet · Santa Paula, CAA loss of engine power during a go-around for undetermined reasons. Contributing to the accident was the flight instructor's failure to maintain adequate airspeed while maneuvering following the loss of power.NTSB LAX07CA267Accident · Minor injuriesData collectionFinal reportHughes 269C · Ramona, CAa loss of engine power for undetermined reasons.NTSB LAX07LA148Accident · 2 fatalLimited investigationFinal reportHill Europa XS · Livermore, CAthe loss of engine power for an undetermined reason during the initial climb, and the pilot's failure to maintain adequate airspeed while attempting a return to runway maneuver, which resulted in a stall/spin.NTSB LAX07CA135Accident · Minor injuriesData collectionFinal reportCessna 150L · Watsonville, CAa partial loss of engine power for undertermined reasons during takeoff.NTSB LAX07LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Palo Alto, CAa loss of engine power for undetermined reasons.NTSB SEA07CA085Accident · No injuriesData collectionFinal reportPiper PA-18 · Tulare, CAThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX07LA102Accident · No injuriesLimited investigationFinal reportCessna 182Q · Banning, CALoss of engine power while on final approach for undetermined reasons. Contributing to the accident was the unfavorable wind condition.NTSB SEA07LA066Accident · No injuriesLimited investigationFinal reportScherer Europa · Upland, CAThe pilot's inadequate condition inspection and subsequent loss of engine power due to fuel starvation as a result of a blocked fuel filter.NTSB LAX07LA075Accident · Minor injuriesLimited investigationFinal reportJihlavan KP-5 · Moorpark, CAa partial loss of power for undetermined reasons.NTSB SEA07LA048Accident · Serious injuriesLimited investigationFinal reportNavion G Model · El Centro, CAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and the glare from the sun.NTSB LAX07FA049Accident · Serious injuriesField investigationFinal reportBeech B36TC · Buena Park, CAa fuel starvation induced loss of engine power due to pilot's inadequate fuel system management.NTSB LAX07LA015Accident · No injuriesLimited investigationFinal reportWilliams Bowers Fly Baby-1A · Oakdale, CAa loss of engine power due to the pilot's failure to use carburetor heat during conditions that were conducive to carburetor icing.NTSB LAX07LA003Accident · 2 fatalLimited investigationFinal reportUlfeldt Kitfox IV-1200 · Gridley, CAThe pilot's failure to maintain an adequate airspeed while attempting a return to runway maneuver that led to a stall spin. The reason for the power loss was not ascertained.NTSB LAX06LA280Accident · No injuriesLimited investigationFinal reportSikorsky S-55 · Paramount, CAthe loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the landing.NTSB LAX06LA265Accident · Minor injuriesLimited investigationFinal reportCessna A150M · Red Bluff, CAThe pilot's improper mixture leaning technique, which lead to thermal damage and seizure of the exhaust valves.NTSB LAX06LA214Accident · No injuriesLimited investigationFinal reportCessna T210M · Hayward, CAA loss of power for undetermined reasons.NTSB LAX06LA204Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Camarillo, CAa loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the emergency landing.NTSB LAX06LA198Accident · Serious injuriesLimited investigationFinal reportCessna 182B · El Dorado, CAA loss of engine power for undetermined reasons and encounter with trees during the forced landing.NTSB LAX06LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Oxnard, CAThe loss of engine power for undetermined reasons.NTSB LAX06LA169Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Tracy, CAloss of power for undetermined reasons.NTSB LAX06FA075Accident · 3 fatalField investigationFinal reportBeech V35A · Valley Center, CAthe pilot's failure to maintain an adequate airspeed margin following a loss of engine power in the takeoff initial climb, resulting in a stall/spin. While the laboratory tests indicated the presence of an unknown biological contaminant in the fuel manifold…NTSB LAX06LA067Accident · Minor injuriesLimited investigationFinal reportForrest Haynes Lancair 320 · Ramona, CAThe loss of engine power for undetermined reasons.NTSB LAX06FA055Accident · 2 fatalField investigationFinal reportBeech A23 · Mammoth Lakes, CAa loss of engine power for undetermined reasons, and, the failure of the pilot to maintain an adequate airspeed while maneuvering following the loss of power, which resulted in a stall/spin.NTSB LAX06LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lodi, CAa loss of engine power for undetermined reasons. A factor was the trees.NTSB LAX05CA320Accident · No injuriesData collectionFinal reportAeronca 7AC · Snelling, CAthe loss of engine power for undetermined reasons.NTSB LAX05LA317Accident · No injuriesLimited investigationFinal reportCessna A185F · Tracy, CAloss of engine power for undetermined reasons.NTSB LAX05CA310Accident · Minor injuriesData collectionFinal reportClark Vans RV8 · Sonoma, CAa loss of engine power due to the failure of the master electrical power switch, which removed power to the electronic ignition.NTSB LAX05LA303Accident · Minor injuriesLimited investigationFinal reportNorth American Navion A · Chowchilla, CAthe loss of engine power for undetermined reasons.NTSB LAX05LA242Accident · 1 fatalLimited investigationFinal reportQuicksilver Mxlii 101 Sport · Galt, CAloss of engine power for undetermined reasons, and the pilot's failure to maintain an adequate airspeed while maneuvering for a forced landing that resulted in a stall and uncontrolled descent into terrain.NTSB LAX05LA186Accident · Minor injuriesLimited investigationFinal reportClassic Waco YMF-5 · Santa Barbara, CAa loss of engine power due to carburetor ice aggravated by the poor operating condition of the magnetos and the improper magneto-to-engine timing.NTSB LAX05LA100Accident · 1 fatalLimited investigationFinal reportAyres S2R · Firebaugh, CAthe loss of engine power during takeoff climb resulting from the fatigue failure of one of the compressor turbine blades; the cause of the fatigue failure could not be definitively determined.NTSB LAX05LA077Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Chico, CAA loss of engine power during approach to land for undetermined reasons.NTSB LAX05FA041Accident · 2 fatalField investigationFinal reportCessna 411 · Corona, CAA loss of engine(s) power for undetermined reasons. Also causal was the pilot's failure to maintain the airplane's minimum controllable airspeed (Vmc) during the initial climb following a loss of power in one engine, which resulted in a loss of aircraft…NTSB LAX05LA022Accident · No injuriesLimited investigationFinal reportBell 47D1 · San Martin, CAA loss of power for undetermined reasons.NTSB LAX04FA226Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Columbia, CAThe loss of engine power for undetermined reason during takeoff-initial climb, and the pilot's failure to maintain sufficient airspeed to avoid a stall/mush. Factors associated with the accident are an inadvertent stall/mush, and the pilot's failure to abort…NTSB LAX04LA216Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Palmdale, CAThe momentary loss of engine power for undetermined reasons.NTSB LAX04LA204Accident · No injuriesLimited investigationFinal reportRocket Flyers LLC · Tipton, CAA loss of engine power due to fuel starvation as a result of air migrating into the fuel control unit. The ultimate reason for the air entry into the fuel control unit was not determined.NTSB LAX04LA182Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Martin, CAthe loss of engine power for undetermined reasons.NTSB LAX04LA166Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Placerville, CAa loss of engine power due to an improperly sized and installed set of sealing gaskets in the gascolator, which resulted in fuel starvation. A factor to the accident was the unsuitable terrain for the forced landing.NTSB LAX04CA147Accident · No injuriesData collectionFinal reportCessna 182E · Sonora, CAthe pilot's inadequate preflight inspection and failure to ensure adequate fuel was aboard, which resulted in fuel exhaustion and loss of engine power.NTSB LAX04LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Mariposa, CAThe total loss of engine power for undetermined reasons.NTSB LAX04LA126Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Tracy, CAA loss of engine power for undetermined reasons during cruise flight.NTSB LAX04LA124Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Upland, CAA partial loss of engine power for undetermined reasons during takeoff.NTSB LAX04LA112Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Palmdale, CAloss of engine power for undetermined reasons.NTSB LAX04CA098Accident · No injuriesData collectionFinal reportCessna 172P · Granada Hills, CAthe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.NTSB LAX04LA083Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Rialto, CAThe pilot's inadequate in-flight planning/decision by his fuel mismanagement and his delay in initiating remedial action which resulted in fuel exhaustion and the loss of engine power.NTSB LAX04LA073Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Temecula, CAa loss of engine power for undetermined reasons.NTSB LAX04LA060Accident · No injuriesLimited investigationFinal reportCessna 172S · Watsonville, CAloss of engine power for undetermined reasons.NTSB LAX04LA047Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Visalia, CAa loss of engine power for undetermined reasons.