NTSB investigations, 2012, TX

15 cases where the phase of flight was Enroute.

Cases per year

19622026
NTSB investigations, 2012, TX per year, 1962–2026: 2,385 cases
19621
19631
196458
196547
196650
196756
196849
196958
197055
197156
197252
197368
197467
197552
197667
197763
197870
197980
198073
198176
198264
198346
198461
198554
198642
198745
198843
198947
199032
199130
199230
199343
199425
199536
199635
199723
199828
199925
200034
200129
200230
200327
200431
200527
200624
200717
200822
200922
201016
201118
201215
201318
201422
201515
201618
201716
201829
201929
202022
202114
202214
202318
202415
202522
202613

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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\") = 2012
    AND c.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
  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 CEN13LA119Accident · No injuriesLimited investigationFinal reportBell 407 · Big Lake, TXThe loss of engine power due to the fatigue failure of the outer combustion case at the fuel nozzle port. Contributing to the accident was the operator’s failure to conduct the recommended routine inspections of the outer combustion case.Dec 29, 2012 · N534MT · Substantial damageNTSB CEN13LA111Accident · No injuriesLimited investigationFinal reportPiper L-18C · Graham, TXThe failure of an engine connecting rod and the subsequent loss of oil pressure, which resulted in a total loss of engine power.Dec 19, 2012 · N3134G · Substantial damageNTSB CEN13FA105Accident · 2 fatalField investigationFinal reportBeech E-90 · Amarillo, TXThe pilot’s loss of control of the airplane after encountering icing conditions and heavy to extreme turbulence and the subsequent exceedance of the airplane’s design limit, which led to an in-flight breakup.Dec 15, 2012 · N67PS · Substantial damageNTSB CEN13LA104Accident · No injuriesLimited investigationFinal reportCessna 172M · Arcola, TXThe loss of engine power during initial climb for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.Dec 7, 2012 · N172BJ · Substantial damageNTSB CEN13FA073Accident · 1 fatalField investigationFinal reportCessna 421C · Wells, TXThe pilot’s decision to continue the flight into an area of extreme weather, which led to the in-flight encounter with a thunderstorm and structural failure of the wings and tail.Nov 27, 2012 · N67SR · Substantial damageNTSB CEN13FA010Accident · 3 fatalField investigationFinal reportRobinson Helicopter R44 II · Blanco, TXThe pilot's loss of helicopter control as a result of spatial disorientation due to dark night conditions and marginal visual flight rules weather conditions.Oct 12, 2012 · N474FA · Substantial damageNTSB CEN12FA561Accident · No injuriesField investigationFinal reportSavage Air Epic LT · San Saba, TXThe improper installation of flexible fuel lines, which resulted in a partial collapse of the inner wall of the fuel lines and a subsequent a loss of engine power due to fuel starvation.Aug 4, 2012 · N603JS · Substantial damageNTSB CEN12FA520Accident · No injuriesField investigationFinal reportPiper PA-38-112 · Fate, TXA total loss of engine power for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.Aug 4, 2012 · N2552C · Substantial damageNTSB CEN12LA501Accident · Serious injuriesLimited investigationFinal reportBeech H35 · Holly Lake Ranch, TXThe incomplete maintenance performed by maintenance personnel, which resulted in a total loss of engine power.Aug 1, 2012 · N4684D · Substantial damageNTSB DCA12LA091Accident · Serious injuriesLimited investigationFinal reportBoeing 737-724 · Winnie, TXthe flight crew's penetration of a rapidly developing thunderstorm cell in an area of forecasted convective activity. The serious injuries were the result of a misunderstanding between the captain and cabin crew regarding the potential for turbulence.Jun 13, 2012 · N16709 · No damageNTSB CEN12LA257Accident · No injuriesLimited investigationFinal reportClifton Breezy · Laneville, TXA loss of engine power due to carburetor ice.Apr 23, 2012 · N6155M · Substantial damageNTSB CEN12LA181Accident · No injuriesLimited investigationFinal reportSikorsky 269C · Staples, TXThe pilot's failure to attain the proper descent rate during autorotation, which resulted in a hard landing. Contributing to the accident were the inflight vibrations and loss of torque pedal response for undetermined reasons.Mar 5, 2012 · N1099N · Substantial damageNTSB CEN12FA164Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Albany, TXThe loss of flight instrumentation due to a failed vacuum pump while flying a night without a discernable horizon, which resulted in the pilot's spatial disorientation and an in-flight loss of control and impact with terrain. Contributing was the continued…Feb 21, 2012 · N7147P · Substantial damageNTSB CEN12FA152Accident · 1 fatalField investigationFinal reportVarga 2150A · Frankston, TXThe loss of engine power due to carburetor ice, which resulted in the pilot ditching the airplane into the lake. Contributing to the accident was the pilot’s decision not to apply carburetor heat.Feb 8, 2012 · N8293J · Substantial damageNTSB OPS12IA303Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Farmersville, TXThe flight's continued operation through an area containing substantial convective weather activity. Contributing to the accident was the air traffic control/traffic management unit's lack of awareness and recognition of the effect of weather movement on the…Jan 25, 2012 · N639AE · No damage