NTSB investigations, 2004, UT

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

Cases per year

19822026
NTSB investigations, 2004, UT per year, 1982–2026: 37 cases
19822
19831
19843
19852
19873
19882
19891
19901
19911
19923
19932
19941
19961
19981
20005
20022
20044
20051
20061

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\") = 2004
    AND c.\"eventStateOrRegion\" = 'UT' 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\" = 351)
  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 DEN04LA105Accident · No injuriesLimited investigationFinal reportMooney M20C · Escalante, UTthe improper installation of an oil pan quick-drain fitting resulting in the loss of engine oil, failure of the engine, and subsequent impact with terrain following an attempted forced landing. A contributing factor was the lack of suitable terrain for a…Jul 18, 2004 · N6773U · Substantial damageNTSB DEN04LA098Accident · No injuriesLimited investigationFinal reportCessna T210N · Spanish Fork, UTthe improper reassembly of the engine following major overhaul (application of Permatex over entire crankcase surfaces). Contributing factors included the number 2 main bearing and crankshaft shifting forward, causing the alternator drive shaft and other…Jul 5, 2004 · N5408A · Substantial damageNTSB DEN04LA083Accident · No injuriesLimited investigationFinal reportAyres S-2R · Beaver, UTthe in-flight failure of the engine's P3 tube which resulted in the loss of engine power and the subsequent impact with terrain during a forced landing. Contributing factors include the lack of suitable terrain for a forced landing and the fence.May 31, 2004 · N5686X · Substantial damageNTSB DEN04LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · West Jordan, UTthe failure of the exhaust valve for the engine's number one cylinder, resulting in the exhaust valve/piston contact and the subsequent total loss of engine power. Contributing factors include the lack of suitable terrain for a forced landing and the snow…Feb 12, 2004 · N66952 · Substantial damage