NTSB investigations, 2000, TX

34 cases where the phase of flight was Enroute.

Cases per year

19622026
NTSB investigations, 2000, 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\") = 2000
    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 FTW01FA043Accident · 1 fatalField investigationFinal reportBell 407 · Gilchrist, TXThe loss of control for reasons undetermined.Dec 29, 2000 · N407MM · DestroyedNTSB FTW01LA036Accident · No injuriesLimited investigationFinal reportBell 206B · Rockport, TXthe loss of engine power during cruise flight due to the fatigue fracture of the compressor coupling adapter. A contributing factor was the high sea condition existing for the forced landing.Dec 1, 2000 · N222LM · Substantial damageNTSB FTW01LA028Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Valley Spring, TXthe loss of engine power due to fuel exhaustion after the pilot became lost during cruise flight. A contributing factor was the dark night condition.Nov 27, 2000 · N18609 · Substantial damageNTSB FTW01LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-310P · Gainesville, TXthe loss of engine power due to improper splicing of the TIT thermocouple leads by unknown persons, which led to over temperature operation of the engine due to inaccurate TIT gauge readings. Contributing factors were the manufacturer's stamp on the top of…Nov 27, 2000 · N9298Y · Substantial damageNTSB FTW01FA025Accident · 1 fatalField investigationFinal reportCessna 172N · Katy, TXthe failure of both pilot's to maintain visual lookout during cruise flight. A contributory factor was the sun glare, which obscured the Cessna 150 pilot's visual lookout.Nov 26, 2000 · N6521D · 2 aircraft · Substantial damageNTSB FTW01FA021Accident · 1 fatalField investigationFinal reportEurocopter AS350B2 · Houston, TXthe pilot's failure to maintain obstacle clearance while maneuvering, which resulted in an in-flight collision with objects. Contributing factors were the dark night and low ceilings.Nov 17, 2000 · N126TV · DestroyedNTSB FTW01LA016Accident · Serious injuriesLimited investigationFinal reportSteven R. Jackson Harmon Rocket 2 · Houston, TXThe collapsing of the inner liner of the induction air hose, resulting in a restriction of airflow to the engine and subsequent loss of engine power. A factor was the lack of suitable terrain for the forced landing.Oct 20, 2000 · N47SR · DestroyedNTSB FTW01LA009Accident · Minor injuriesLimited investigationFinal reportBellanca BL17-30 · Waller, TXthe loss of engine power during climb to cruise due to the failure of the crankshaft counterweight. A contributing factor was the lack of suitable terrain for the forced landing.Oct 12, 2000 · N4882V · Substantial damageNTSB FTW01FA007Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Cotulla, TXThe pilot's failure to refuel the airplane which resulted in fuel exhaustion and subsequent loss of engine power. Also contributing to the accident was the pilot's failure to feather the engine.Oct 10, 2000 · N3390P · Substantial damageNTSB FTW01LA005Accident · 2 fatalLimited investigationFinal reportHolt Thorpe T-18C · Imperial, TXthe failure of the propeller blade due to fatigue, which originated from a corrosion crack. A contributory factor was the pilot/owner's failure to ensure that the propeller was overhauled at the manufacturer's recommended interval.Oct 4, 2000 · N85LH · DestroyedNTSB FTW01LA004Accident · Serious injuriesLimited investigationFinal reportBell 206-L1 · Jasper, TXThe pilot's inadvertent VFR flight into instrument meteorological conditions, which resulted in his failure to maintain control of the helicopter. Factors were the fog and the pilot's lack of instrument flight experience.Oct 2, 2000 · N321CA · Substantial damageNTSB FTW00LA272Accident · Serious injuriesLimited investigationFinal reportPorterfield LP65 · Corsicana, TXThe failure of the pilot to refuel the airplane, which resulted in fuel exhaustion. A factor was the pilot's inadequate preflight planning and the lack of suitable terrain for the forced landing.Sep 30, 2000 · N25563 · Substantial damageNTSB FTW00LA242Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-35 · Corsicana, TXthe in-flight separation of the propeller blade, which resulted from intergranular corrosion and fatigue cracking.Aug 24, 2000 · N770MA · Substantial damageNTSB FTW00FA245Accident · 1 fatalField investigationFinal reportCessna 421C · Hunt, TXthe loss of left engine power as a result of the owner's failure to overhaul the engine before further flight after the lubrication system was found contaminated with metal. Contributing factors were the pilot's decision to fly the aircraft with a…Aug 24, 2000 · N421NT · DestroyedNTSB FTW00LA230Accident · Minor injuriesLimited investigationFinal reportAeronca 65-CA · Liberty Hill, TXthe pilot's inadvertent activation of the left rudder control, which resulted in a loss of control while in cruise flight.Aug 14, 2000 · N33783 · Substantial damageNTSB FTW00IA228Incident · Minor injuriesIncident investigationFinal reportEmbraer EMB-120ER · San Angelo, TXthe improper installation of the right elevator trim control wheel by company mechanics, which resulted in an elevator trim malfunction.Aug 12, 2000 · N16718 · No damageNTSB FTW00LA213Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Stephenville, TXThe collision with a bird while in cruise flight.Jul 14, 2000 · N99236 · Substantial damageNTSB FTW00LA207Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Columbus, TXthe failure of both magnetos of the dual-magneto single-drive unit. A factor contributing to the accident was the lack of suitable terrain for the forced landing.Jul 12, 2000 · N3392E · Substantial damageNTSB FTW00LA204Accident · No injuriesLimited investigationFinal reportCessna 402A · Del City, TXthe total loss of engine power on both engines during cruise due to fuel starvation as a result of the pilot's improper use of the fuel selectors. Contributing factors were the pilot's lack of familiarity with the aircraft, and the lack of suitable terrain…Jul 8, 2000 · N402NA · Substantial damageNTSB FTW00LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Mcallen, TXLoss of engine power for reasons undetermined. A factor was the lack of suitable terrain for the forced landing.Jun 19, 2000 · N94290 · Substantial damageNTSB FTW00LA202Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sugar Land, TXThe pilot's improper fuel tank selection, which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.Jun 8, 2000 · N9407W · Substantial damageNTSB FTW00LA176Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Del Rio, TXThe separation of the #3 connecting rod, piston, and cylinder. A factor was the lack of suitable terrain for the forced landing.Jun 7, 2000 · N39827 · Substantial damageNTSB FTW00LA168Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Garwood, TXthe loss of engine power in cruise flight as a result of the failure of the right magneto. A contributing factor was the lack of suitable terrain for the forced landing.Jun 2, 2000 · N8886S · Substantial damageNTSB FTW00LA160Accident · Minor injuriesLimited investigationFinal reportCessna 195 · Kaufman, TXThe failure of the left magneto, which resulted in a partial loss of engine power. Factors were the fouled number 3, 4, and 5 rear spark plugs and the lack of suitable terrain for the precautionary landing.May 28, 2000 · N9876A · Substantial damageNTSB FTW00LA131Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Lancaster, TXthe loss of engine power for undetermined reasons.Apr 25, 2000 · N5269C · Substantial damageNTSB FTW00LA127Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Tomball, TXEngine seizure due to the rupture of an oil cooler line.Apr 19, 2000 · N7038V · Substantial damageNTSB FTW00LA119Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Lubbock, TXThe pilot's incorrect positioning of the fuel selector which resulted in fuel starvation. Factors were the pilot's lack of familiarity with the fuel system due to an inadequate checkout by a flight instructor, and the lack of suitable terrain for the forced…Apr 7, 2000 · N5682T · Substantial damageNTSB LAX00LA146Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2G7 · Dallas, TXThe en route cruise encounter with forecast moderate turbulence.Apr 3, 2000 · N910AW · No damageNTSB FTW00LA106Accident · Minor injuriesLimited investigationFinal reportWard Acro · Beasley, TXThe loss of engine power for an undetermined reason.Mar 25, 2000 · N79RW · Substantial damageNTSB FTW00LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Slidell, TXThe pilot's improper approach planning, which resulted in a downwind landing. A factor was the loss of engine power for undetermined reasons.Jan 21, 2000 · N6179Q · Substantial damageNTSB FTW00LA068Accident · No injuriesLimited investigationFinal reportMooney M20K · Tyler, TXThe failure of the crankshaft drive gear as a result of fatigue, which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.Jan 19, 2000 · N1157G · Substantial damageNTSB FTW00LA059Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Sweeney, TXThe pilot's excessive flare resulting in a hard landing. Factors were the loss of engine power for undetermined reasons, the power lines on final approach and the dark night conditions.Jan 10, 2000 · N8954N · Substantial damageNTSB FTW00LA058Accident · No injuriesLimited investigationFinal reportCessna A185F · Houston, TXthe loss of engine power during climb as a result of fatigue cracking of the #4 cylinder head and its subsequent separation from its barrel.Jan 3, 2000 · N999SW · Substantial damageNTSB FTW00LA057Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Odessa, TXThe separation of the #1 piston pin due to fatigue, which resulted in a total loss of engine power. A factor was the lack of suitable terrain for the forced landing.Jan 2, 2000 · N4389W · Substantial damage