NTSB investigations, 2019, TX

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

Cases per year

20082026
NTSB investigations, 2019, 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\") = 2019
    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 CEN20LA051Accident · No injuriesClass 3 · LimitedFinal reportEnstrom F28 · Danbury, TXThe failure of the engine's No.3 intake valve resulting is a loss of engine power and a rollover following the autorotation to soft ground.Dec 31, 2019 · N57SJ · Substantial damageNTSB CEN20LA020Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus SR22 · Tyler, TXA total loss of engine power as a result of detonation due to a combination of improper magneto to engine timing and a rich fuel mixture.Nov 22, 2019 · N969JM · Substantial damageNTSB CEN20LA018Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Houston, TXThe pilot's failure to select the proper fuel tank before departure, which resulted in fuel starvation and a total loss of engine power.Nov 9, 2019 · N7703J · Substantial damageNTSB CEN20LA016Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Springtown, TXA total loss of engine power for undetermined reasons.Oct 13, 2019 · N75139 · Substantial damageNTSB CEN19LA326Accident · No injuriesClass 3 · LimitedFinal reportVans Vans RV-10 · Lancaster, TXA partial loss of engine power due to a faulty magneto/ignition system, which resulting in a forced landing.Sep 21, 2019 · N569JC · Substantial damageNTSB CEN19LA316Accident · 1 fatalClass 3 · LimitedFinal reportInfinity Powered Parachutes IPP2 · Eustace, TXThe pilot’s failure to see and avoid a power line. Contributing was the pilot’s decision to fly at an altitude too low to avoid obstacles.Sep 12, 2019 · N6035L · Substantial damageNTSB CEN19LA299Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Conroe, TXA partial loss of engine power for reasons that could not be determined based on the available evidence.Aug 31, 2019 · N55633 · Substantial damageNTSB CEN19LA295Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT502 · Olney, TXA loss of thrust control due to a propeller surge event, which resulted in a forced landing shortly after takeoff.Aug 29, 2019 · N8517Q · Substantial damageNTSB CEN19LA275Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Rio Grande City, TXThe loss of engine power following an increase in oil temperature for undetermined reasons during cruise flight, which resulted in a forced landing on unsuitable terrain.Aug 15, 2019 · N150CR · Substantial damageNTSB CEN19LA232Accident · No injuriesClass 3 · LimitedFinal reportCessna 152 · Fredericksburg, TXA total loss of engine power for undetermined reasons.Jul 21, 2019 · N48410 · Substantial damageNTSB CEN19LA193Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R22 · Garwood, TXThe pilots' failure to maintain clearance from a power line during low level operations.Jun 29, 2019 · N7143Y · Substantial damageNTSB CEN19LA187Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Danbury, TXA failed electrical relay, which provided an improper indication of a governor and clutch problem, which resulted in the pilot conducting a precautionary landing during which he failed to maintain sufficient main rotor speed.Jun 28, 2019 · N26498 · Substantial damageNTSB DCA19CA170Accident · No injuriesData collectionFinal reportBoeing CV2 · Beeville, TXA higher than expected and accounted for crosswind which initiated a lateral deviation, and resulted in the aircraft reaching the limits of the geo-fence area triggering a contingency forced landing.Jun 21, 2019 · N243XT · Substantial damageNTSB CEN19LA158Accident · Serious injuriesClass 3 · LimitedFinal reportBoeing B75N1 · Fredericksburg, TXThe loss of engine power for undetermined reasons.May 29, 2019 · N60955 · Substantial damageNTSB CEN19TA131Accident · No injuriesClass 3Final reportAir Tractor AT 602 · Quanah, TXThe pilot's failure to maintain clearance from the power line during a low altitude aerial application maneuver.Apr 28, 2019 · N602AM · Substantial damageNTSB CEN19LA129Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 23 · Sulphur Spring, TXThe pilot’s inadequate preflight inspection, during which he failed to detect the water contamination in the left fuel, which resulted in a partial loss of power in the left engine. Contributing to the accident was the total loss of power in the right engine…Apr 27, 2019 · N233P · Substantial damageNTSB CEN19TA073Accident · Serious injuriesFinal reportBeech A36 · Fort Worth, TXThe pilot's improper fuel management, which resulted in fuel starvation and a loss of engine power.Jan 27, 2019 · N36PS · Substantial damageNTSB CEN19LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA32RT · Pflugerville, TXThe pilot's fuel mismanagement and his improper use and placement of the fuel selector, contrary to operating procedures, which resulted in a partial loss of engine power due to fuel starvation.Jan 27, 2019 · N39650 · Substantial damageNTSB CEN19LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Aguilares, TXThe loss of engine power due to fuel starvation.Jan 20, 2019 · N99308 · Substantial damageNTSB CEN19LA065Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Uvalde, TXThe slipping of the sprag clutch due to galling of the sprags and corresponding sprag contact surfaces within the clutch assembly, which rendered the helicopter uncontrollable.Jan 8, 2019 · N484AB · Substantial damage