NTSB investigations, 2015, TX

12 cases where the sequence of events included Nose over/nose down.

Cases per year

20082026
NTSB investigations, 2015, TX per year, 2008–2026: 147 cases
20085
20098
20107
20116
201212
20137
201414
201512
201610
20176
20189
201912
20204
20216
20224
20239
20246
20257
20263

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\" = '096' 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 CEN16LA068Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Baytown, TXThe pilot's failure to maintain directional control during landing in gusting wind conditions.Dec 19, 2015 · N2694F · Substantial damageNTSB GAA16CA024Accident · No injuriesData collectionFinal reportCessna 120 · McKinney, TXThe pilot's use of excessive brake input during the recovery from the ground loop, which resulted in a nose over.Oct 17, 2015 · N2099V · Substantial damageNTSB CEN15LA292Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Shenandoah, TXThe pilot's delayed application of carburetor heat, which resulted in the total loss of engine power due to carburetor icing during cruise flight.Jul 3, 2015 · N2320U · Substantial damageNTSB CEN15LA286Accident · No injuriesLimited investigationFinal reportDon W Guice Zodiac 601XL · Seagoville, TXThe engine overheating, which resulted in a partial loss of engine power, due to the pilot's operation of the engine with a higher-than-specified oil quantity level.Jun 29, 2015 · N253DG · Substantial damageNTSB GAA15CA104Accident · No injuriesData collectionFinal reportCessna 150F · Harlingen, TXThe student pilot's failure to maintain directional control while landing with a crosswind.May 30, 2015 · N8126S · Substantial damageNTSB CEN15LA243Accident · No injuriesLimited investigationFinal reportCessna TR182 · Tulia, TXThe partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical anomalies that would have precluded normal operation.May 27, 2015 · N4645T · Substantial damageNTSB CEN15LA239Accident · Minor injuriesLimited investigationFinal reportAyres S2R G6 · Tivoli, TXThe failure of the fuel control unit due to the worn stub shaft spline, which resulted in an engine overspeed. Contributing to the accident was maintenance personnel's inadequate inspection of the fuel control unit.May 20, 2015 · N3300U · Substantial damageNTSB GAA15CA023Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · Ropesville, TXThe pilot's failure to maintain directional control during landing.Mar 27, 2015 · N20062 · Substantial damageNTSB CEN15LA206Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-301T · Stephenville, TXThe partial loss of engine power after takeoff for undetermined reasons, which necessitated a forced landing, during which the airplane impacted trees and a power line.Mar 27, 2015 · N9284 · Substantial damageNTSB GAA15CA012Accident · Minor injuriesData collectionFinal reportPiper PA 12 · Midland, TXThe pilot's excessive braking during the landing roll.Mar 19, 2015 · N2722M · Substantial damageNTSB GAA15CA010Accident · No injuriesData collectionFinal reportJabiru USA Sport J250 SP · Hondo, TXThe student pilot's failure to maintain directional control during landing roll, which resulted in a loss of control. Contributing to this accident was the flight instructor's delayed remedial action.Mar 12, 2015 · N638J · Substantial damageNTSB CEN15LA099Accident · No injuriesLimited investigationFinal reportCessna 195B · Llano, TXThe pilot’s overrotation of the airplane when lifting the tail during the takeoff roll, which allowed the propeller to come in contact with the runway and resulted in a reduction in engine power and the pilot’s subsequent loss of directional control.Jan 6, 2015 · N2125C · Substantial damage