Fatal NTSB investigations, 2002

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

Cases per year

19822026
Fatal NTSB investigations, 2002 per year, 1982–2026: 155 cases
19826
19838
19846
19859
198611
19874
198812
19897
199012
19914
19925
19935
19945
199512
19968
19973
19988
19995
20003
20011
20026
20033
20043
20053
20065
20071

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.\"highestInjuryLevel\" = 'Fatal'
    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 ATL03FA009Accident · 2 fatalField investigationFinal reportBeechcraft A60 · Jesup, GAThe loss of power in one engine and the loss of control for undetermined reasons.Oct 24, 2002 · N73CR · DestroyedNTSB NYC02FA178Accident · 7 fatalField investigationFinal reportBeechcraft 58P · Swanzey, NH**This report was modified on 2/24/2016. Refer to the public docket for this accident for additional information.** the pilot's improper preflight planning and his decision to depart with known landing gear system mechanical deficiencies, which resulted in a…Sep 2, 2002 · N6688D · DestroyedNTSB DEN02GA085Accident · 1 fatalFinal reportAerospatiale SA315B · Estes Park, COthe pilot's abrupt collective input during water application to a forest fire. Contributing factors were encountering a vortex ring state, the inadvertent settling with power, the low altitude, and the mountainous terrain.Jul 31, 2002 · N3978Y · DestroyedNTSB CHI02LA166Accident · 1 fatalLimited investigationFinal reportJacobs Rutan Vari Viggen · Urbana, ILThe pilot's failure to abort the takeoff. Additional factors included the partial loss of engine power due to an excessively rich mixture as a result of a bad accelerator pump housing seal, and the pilot failed to maintain control of the airplane.Jun 16, 2002 · N915D · DestroyedNTSB 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 NYC02FA068Accident · 1 fatalField investigationFinal reportCessna T210N · Teterboro, NJImproper maintenance by other maintenance personnel, which resulted in the air filter element being sucked into and blocking the turbocharger inlet, and a subsequent power loss. Factors in the accident were the pilot's failure to maintain airspeed and the…Mar 9, 2002 · N2BS · Destroyed