NTSB investigations, 2002, AR

10 cases where the first occurrence was “Loss of engine power”.

Cases per year

19822026
NTSB investigations, 2002, AR per year, 1982–2026: 143 cases
198210
19833
19844
19856
19862
19876
19884
19891
19905
19916
19926
19936
19949
199511
19968
19974
19985
19995
20001
20015
200210
20038
20046
20056
20064
20072

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\" = 'AR' 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.

NTSB FTW03LA052Accident · No injuriesLimited investigationFinal reportShepherd Kolb Mark III · Norfork, ARThe loss of engine power due to fuel contamination. Contributing to the accident were the trees.Nov 28, 2002 · N4672D · Substantial damageNTSB FTW03LA050Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Weiner, ARThe loss of engine power due to a compressor stall for undetermined reasons. A contributing factor was the soft terrain.Nov 20, 2002 · N502RS · Substantial damageNTSB FTW03LA026Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Marshall, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Oct 31, 2002 · N35866 · Substantial damageNTSB FTW03LA023Accident · No injuriesLimited investigationFinal reportBeech A23 · Farmington, ARThe loss of engine power due to the failure of the mechanical fuel pump.Oct 22, 2002 · N1451L · Substantial damageNTSB FTW02LA183Accident · Serious injuriesLimited investigationFinal reportBeech V35A · Leslie, ARThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.Jun 17, 2002 · N800MD · Substantial damageNTSB FTW02LA168Accident · No injuriesLimited investigationFinal reportErcoupe ERCO-415-E · Conway, ARThe loss of engine power for undetermined reasons. Factors were the pilots necessity to avoid a power line during the emergency descent and the lack of suitable terrain for the forced landing.May 31, 2002 · N94769 · Substantial damageNTSB FTW02LA163Accident · Minor injuriesLimited investigationFinal reportPiper J-5 · Greers Ferry, ARThe loss of engine power for undetermined reasons. A factor was the probability of carburetor ice.May 26, 2002 · N38399 · Substantial damageNTSB FTW02LA161Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Aubrey, ARThe failure of a compressor turbine blade(s) for an undetermined reason.May 24, 2002 · N4025Y · Substantial damageNTSB FTW02LA151Accident · 1 fatalLimited investigationFinal reportNolan RV-4 · Jonesboro, ARThe loss of engine power for an undetermined reason.May 15, 2002 · N437BN · Substantial damageNTSB FTW02LA137Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Tuckerman, ARThe pilot's operation of the airplane with a known equipment deficiency, which resulted in fuel leakage and a loss of engine power due to fuel exhaustion. A contributing factors was the lack of suitable terrain for the forced landing.May 2, 2002 · N3146S · Substantial damage