NTSB investigations, 2021, TX

9 cases where the sequence of events included Loss of engine power (partial).

Cases per year

20082026
NTSB investigations, 2021, TX per year, 2008–2026: 168 cases
20087
200912
20109
20117
201215
201311
201411
201510
20168
201710
20189
201913
20208
20219
20225
20234
20246
20258
20266

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\") = 2021
    AND c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 CEN22LA036Accident · No injuriesClass 3 · LimitedFinal reportCessna 177 · Hudson Oaks, TXThe partial loss of engine power due to fuel exhaustion. Contributing was the pilot’s improper fuel planning.Oct 31, 2021 · N29615 · Substantial damageNTSB CEN22LA002Accident · Minor injuriesClass 3 · LimitedFinal reportBeech B23 · Lamesa, TXThe loss of engine power for a reason that could not be determined.Oct 2, 2021 · N6996Q · Substantial damageNTSB CEN21LA391Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 320 · Windthorst, TXA forced landing due to a loss of engine power on the right engine for a reason that could not be determined based on the available evidence.Aug 29, 2021 · N222L · Substantial damageNTSB CEN21LA375Accident · No injuriesClass 3 · LimitedFinal reportHaley Highlander · Waller, TXA loss of engine power due to fuel exhaustion.Aug 14, 2021 · N100GH · Substantial damageNTSB CEN21LA473Accident · Minor injuriesClass 3 · LimitedFinal reportBeech 35-A33 · Mineral Wells, TXA partial loss of engine power for reasons that could not be determined based on available evidence.Jul 23, 2021 · N5ML · Substantial damageNTSB CEN21LA293Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Porter, TXThe pilot’s decision to continue the takeoff with degraded engine performance, which resulted in an inability to climb and a subsequent forced landing. The reason for the engine’s degraded performance could not be determined based on available information.Jun 25, 2021 · N4216J · Substantial damageNTSB CEN21LA273Accident · No injuriesClass 3 · LimitedFinal reportTony Dubeansky RV10 · Fort Worth, TXA partial loss of engine power due to a separated electronic ignition system connector. Contributing to the accident was the location of the ignition boxes, which provided limited access to the connectors for visual inspection.Jun 16, 2021 · N878TD · Substantial damageNTSB CEN21LA176Accident · No injuriesClass 3 · LimitedFinal reportBeech B35 · Pearland, TXThe partial loss of engine power due to a crack in the No. 1 cylinder for unknown reasons.Apr 3, 2021 · N5240C · Substantial damageNTSB CEN21LA133Accident · No injuriesClass 3 · LimitedFinal reportAero Commander S2R · Alamo, TXThe partial loss of engine power due to water-contaminated fuel.Feb 9, 2021 · N5679X · Substantial damage