NTSB investigations, 2004, TX

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

Cases per year

19822026
NTSB investigations, 2004, TX per year, 1982–2026: 110 cases
19825
19834
19849
19856
19866
19873
19885
19897
19907
19913
19924
19939
19944
19955
19962
19972
19981
19993
20007
20012
20022
20032
20045
20052
20063
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\") = 2004
    AND c.\"eventStateOrRegion\" = 'TX' 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 DFW05CA021Accident · No injuriesData collectionFinal reportBellanca BL-17-30A · Roanoke, TXThe disconnection of the engine mixture control cable due to improper maintenance which resulted in a loss of engine power.Sep 27, 2004 · N28086 · Substantial damageNTSB DCA04IA066Incident · No injuriesIncident investigationFinal reportBoeing B-777 · Houston, TXthe failure of a high pressure turbine blade which damaged an oil seal and allowed smoke to enter the cabin. Contributing to the blade failure was the mis-labeling of the blade's part number by the manufacturer, which allowed the blade to remain in service…Aug 11, 2004 · G-VIID · Minor damageNTSB FTW04LA131Accident · No injuriesLimited investigationFinal reportCooke Rotorway Exec · Willis, TXThe partial loss of engine power due to the failure of the #1 cylinder valve retainer clip. A contributing factor was the lack of suitable terrain for the forced landing.May 15, 2004 · N319RC · Substantial damageNTSB FTW04LA109Accident · No injuriesLimited investigationFinal reportSpannagel RV-8A · Borger, TXA partial loss of engine power as a result of inadequate clearance between the journals and bearings.Apr 15, 2004 · N82LS · Substantial damageNTSB FTW04LA059Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Fort Worth, TXThe pilot's failure to maintain control and the partial loss of engine power as a result of an improperly installed mixture control linkage.Jan 9, 2004 · N3289P · Substantial damage