NTSB investigations, 2010, TX

19 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026
NTSB investigations, 2010, TX per year, 2008–2026: 303 cases
200814
200917
201019
201121
201215
201315
201421
201516
201619
201711
201825
201920
202021
202111
202213
202311
202415
202514
20265

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\") = 2010
    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\" = '440' 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 CEN11IA146Incident · No injuriesIncident investigationFinal reportColumbia LC41 · Milsap, TXA total loss of engine power in flight due to a loss of engine oil for reasons that could not be determined during a postaccident teardown examination of the engine.Dec 24, 2010 · N921DZ · Minor damageNTSB CEN11LA083Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Nocagdoches, TXA total loss of power in both engines for undetermined reasons.Nov 28, 2010 · N36405 · Substantial damageNTSB CEN11LA084Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Navada, TXThe loss of engine power due to debris obstructing the fuel filter, which resulted in fuel starvation. Contributing to the accident was the pilot's inadequate airspeed during the forced landing, which resulted in an aerodynamic stall.Nov 27, 2010 · N4541L · Substantial damageNTSB CEN11LA061Accident · Serious injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Fruitvale, TXA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Nov 5, 2010 · N971WA · Substantial damageNTSB CEN11LA043Accident · No injuriesLimited investigationFinal reportPiper PA46-500TP · Port Mansfield, TXThe total loss of engine power for undetermined reasons because examination of the airframe and engine did not reveal any anomalies that would have contributed to the loss of engine power.Oct 29, 2010 · N234PM · Substantial damageNTSB CEN11LA034Accident · No injuriesLimited investigationFinal reportCessna T210N · Presidio, TXA loss of engine power due to fuel exhaustion for undetermined reasons.Oct 25, 2010 · N200WT · Substantial damageNTSB CEN11CA028Accident · Minor injuriesData collectionFinal reportWeddington Double Eagle · Temple, TXThe loss of engine power for undetermined reasons.Oct 16, 2010 · N132BE · Substantial damageNTSB CEN10CA568Accident · No injuriesData collectionFinal reportBeech D17S · Fort Worth, TXThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Sep 21, 2010 · N17GB · Substantial damageNTSB CEN10CA549Accident · No injuriesData collectionFinal reportCessna 182D · Houston, TXThe loss of engine power during the initial climb due to decreased engine oil quantity and pressure as a result of the engine's oil cap not being adequately secured.Sep 20, 2010 · N9071X · Substantial damageNTSB CEN10CA536Accident · No injuriesData collectionFinal reportCessna A188B · Hondo, TXThe pilot’s delayed action to arrest the airplane’s descent, which resulted in a collision with terrain.Sep 6, 2010 · N731PQ · Substantial damageNTSB CEN10LA478Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Justin, TXA loss of engine power due to fuel starvation as a result of the pilot's delay in transferring fuel from the gravity feed wing tanks to the main tank.Aug 14, 2010 · N85065 · Substantial damageNTSB CEN10LA455Accident · Serious injuriesLimited investigationFinal reportGarlick OH-58A · Kountze, TXA loss of engine power due to fuel exhaustion as a result of the pilot’s improper fuel planning.Jul 31, 2010 · N305SD · Substantial damageNTSB CEN10LA425Accident · Minor injuriesLimited investigationFinal reportSmith Aerostar · Cleburne, TXA total loss of engine power due to fuel starvation as a result of the pilot’s improper fuel management. Contributing to the accident were the critical fuel placards that were difficult to see due to the airplane's paint scheme.Jul 22, 2010 · N601AT · DestroyedNTSB CEN10LA416Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Krum, TXA total loss of engine power in flight due to carburetor icing.Jul 14, 2010 · N35645 · Substantial damageNTSB CEN10LA217Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Alpine, TXA total loss of engine power for undetermined reasons.Apr 21, 2010 · N9197F · Substantial damageNTSB CEN10CA179Accident · Minor injuriesData collectionFinal reportCessna 182M · Hamilton, TXThe pilot’s failure to maintain clearance from a static power line while maneuvering at a low altitude.Mar 30, 2010 · N71229 · Substantial damageNTSB CEN10LA140Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Slaton, TXThe loss of engine power due to the insufficient clamping force between the two crankcase halves and each cylinder to the crankcase.Mar 5, 2010 · N2036Y · Substantial damageNTSB CEN10LA131Accident · No injuriesLimited investigationFinal reportLacour Long-EZE SR7-1 · Falfurrias, TXA total loss of engine power due to a failure of the crankshaft behind the No. 3 connecting rod journal for undetermined reasons.Mar 1, 2010 · N97EZ · Substantial damageNTSB CEN10CA087Accident · No injuriesData collectionFinal reportMaule M-4-220C · Pearsall, TXA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning.Jan 2, 2010 · N2028U · Substantial damage