NTSB investigations, 2000, TX

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

Cases per year

19822026
NTSB investigations, 2000, 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\") = 2000
    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 FTW00LA190Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Whitney, TXThe partial loss of engine power, which resulted from the worn carburetor.Jun 29, 2000 · N6932N · Substantial damageNTSB FTW00LA175Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Nacogdoches, TXthe loss of engine power during a go-around resulting from the failure of the worn carburetor heat control cable. A contributing factor was the lack of suitable terrain for the forced landing.Jun 8, 2000 · N29383 · Substantial damageNTSB FTW00LA160Accident · Minor injuriesLimited investigationFinal reportCessna 195 · Kaufman, TXThe failure of the left magneto, which resulted in a partial loss of engine power. Factors were the fouled number 3, 4, and 5 rear spark plugs and the lack of suitable terrain for the precautionary landing.May 28, 2000 · N9876A · Substantial damageNTSB FTW00TA116Accident · Minor injuriesFinal reportHughes OH-6A · El Paso, TXThe failure of the pilot to maintain rotor rpm during an autorotation, which resulted in a hard landing. A factor was the partial loss of engine power resulting from the separation of the power control line due to fatigue, as a consequence of improper…Apr 13, 2000 · N6187Y · Substantial damageNTSB FTW00LA108Accident · Minor injuriesLimited investigationFinal reportNorth American T-28B · Bridgeport, TXThe partial loss of engine power for an undetermined reason.Mar 27, 2000 · N28NE · Substantial damageNTSB FTW00LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe failure of the left magneto, which resulted in the partial loss of engine power during takeoff.Mar 13, 2000 · N6637 · Substantial damageNTSB FTW00LA058Accident · No injuriesLimited investigationFinal reportCessna A185F · Houston, TXthe loss of engine power during climb as a result of fatigue cracking of the #4 cylinder head and its subsequent separation from its barrel.Jan 3, 2000 · N999SW · Substantial damage