NTSB investigations, 2015, TX

7 cases where the sequence of events included Aircraft maintenance event.

Cases per year

20082026
NTSB investigations, 2015, TX per year, 2008–2026: 44 cases
20082
20092
20103
20112
20126
20131
20141
20157
20161
20172
20184
20191
20201
20213
20223
20231
20242
20252

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\") = 2015
    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\" = '040' 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 GAA15CA242Accident · No injuriesData collectionFinal reportCessna 305A · Midlothian, TXThe failure of the brake line tubing for the right main landing gear brake, due to a non-standard method used to secure the brake line, which resulted in a loss of control during landing, and a ground loop.Aug 29, 2015 · N5255G · Substantial damageNTSB CEN15LA336Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Austin, TXA total loss of engine power due to an excessively rich fuel mixture as a result of the improper adjustment of the fuel pump aneroid.Aug 4, 2015 · N17544 · Substantial damageNTSB CEN15LA329Accident · 1 fatalLimited investigationFinal reportO'Dell Aeromaster · Sulphur Springs, TXA total loss of engine power for reasons that could not be determined because postimpact damage precluded a thorough examination of the airplane. Contributing to the accident was the pilot's failure to maintain control following the loss of engine power,…Jul 31, 2015 · N55J · DestroyedNTSB CEN15CA324Accident · Serious injuriesData collectionFinal reportAero Commander 100 · San Antonio, TXThe pilot's improper decision to attempt flight with an unairworthy airplane and improper starting procedure that resulted in an uncontrolled takeoff without the pilot aboard. Contributing was the inoperative airplane battery/engine starter.Jul 23, 2015 · N5542M · Substantial damageNTSB CEN15LA298Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Houston, TXMaintenance personnel's improper installation of the propeller governor, which resulted in damage to the governor drive gear and its subsequent failure and a subsequent loss of engine power.Jul 7, 2015 · N422PB · Substantial damageNTSB CEN15FA269Accident · 1 fatalField investigationFinal reportGrumman American Avn. AA-5 · Fredericksburg, TXThe pilot's failure to maintain adequate airspeed following a partial loss of engine power during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Also causal was the mechanic's…Jun 14, 2015 · N6552L · Substantial damageNTSB CEN15LA138Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Slaton, TXMaintenance personnel’s improper installation of the engine data monitor (EDM), which was not in accordance with the supplemental type certificate instructions and resulted in engine warning indications and the pilot’s subsequent reaction to the warning…Feb 5, 2015 · N602PB · Substantial damage