NTSB investigations, 2002, CA

7 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.

Cases per year

19822026
NTSB investigations, 2002, CA per year, 1982–2026: 168 cases
198211
198312
19847
198510
19864
19878
19887
198910
19909
19919
19925
19936
19948
19954
19966
19971
19989
19993
20006
20014
20027
20031
20045
20057
20066
20073

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 year(c.\"eventDate\") = 2002
    AND 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\" = 352)
  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.

NTSB LAX03LA004Accident · No injuriesLimited investigationFinal reportRans S-12 XL · Los Banos, CAThe loss of engine power for undetermined reasons and his failure to maintain adequate airspeed resulting in a stall. A contributing factor was the pilot's decision to conduct a downwind takeoff.Oct 9, 2002 · UNREG · Substantial damageNTSB LAX03GA001Accident · Serious injuriesFinal reportMcDonnell Douglas 600N · Rialto, CAan engine deceleration event due to a loose HMU fuel line fitting, which was a result of inadequate maintenance procedures in the 100/300-hour inspection. Also causal was the flying pilot's and pilot-in-command's delayed recognition of the power loss, as well…Oct 4, 2002 · N625SB · Substantial damageNTSB LAX02LA249Accident · Minor injuriesLimited investigationFinal reportArns Spacewalker II · Irvine, CALoss of engine power due to an exhaust system leak and vapor lock.Aug 10, 2002 · N185MD · Substantial damageNTSB LAX02LA218Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Compton, CAthe failure and separation of a fan belt for the engine cooling system. A factor in the accident was the inadequate annual inspection 14 hours prior to the accident.Jul 7, 2002 · N2483B · Substantial damageNTSB LAX02LA172Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Lake Thomas A., CAa partial loss of engine power due to the partial malfunction of the left magneto and leakage of the ignition leads for that magneto, due to inadequate maintenance inspections. Factors in the accident include the high density altitude, the maintenance…May 24, 2002 · N79944 · Substantial damageNTSB LAX02FA148Accident · 3 fatalField investigationFinal reportBeech C23 · Oak Shores, CAthe number 1 cylinder exhaust valve fractured and separated resulting in a loss of engine power and an off airport forced landing. A finding in the accident was the owner's failure to maintain the engine in accordance with the manufacturer's recommendations.Apr 28, 2002 · N9180S · DestroyedNTSB LAX02LA136Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lake Los Angele, CAa reconditioned engine cylinder barrel failure due to previous rust damage and improper maintenance practices.Apr 15, 2002 · N211CA · Substantial damage