NTSB investigations, 2000, TX

8 cases where the phase of flight was Takeoff.

Cases per year

19642026
NTSB investigations, 2000, TX per year, 1964–2026: 933 cases
196434
196524
196640
196722
196821
196924
197027
197130
197217
197315
197419
197519
197616
197727
197815
197919
198012
198130
198218
198316
198414
198510
198618
198714
198811
198912
19906
19917
19922
19938
19948
199517
19968
19977
19986
19999
20008
20018
20027
20039
200411
20058
20069
200716
20085
200911
201018
201113
201222
201311
201416
201514
201619
20176
201817
201913
202012
202112
202213
20237
202415
20258
202623

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 = 300)
  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 FTW00LA191Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Godley, TXThe pilot's inadequate preflight planning and his delay in aborting the takeoff.Jul 1, 2000 · N231RR · Substantial damageNTSB FTW00FA146Accident · 6 fatalField investigationFinal reportBeech BE-95-B55 · Houston, TXthe loss of control on takeoff as a result of the pilot's failure to remove the flight control lock due to his inadequate preflight inspection. A contributing factor was the pilot exceeding the aircraft's certificated maximum weight and balance limitations.May 12, 2000 · N4005A · DestroyedNTSB FTW00LA110Accident · No injuriesLimited investigationFinal reportCessna A188B · Perryton, TXThe pilot's failure to maintain directional control during the takeoff roll. A factor was the crosswind.Mar 13, 2000 · N4833Q · Substantial damageNTSB FTW00LA098Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Garwood, TXThe failure of the left magneto, which resulted in the partial loss of engine power during takeoff.Mar 13, 2000 · N6637 · Substantial damageNTSB FTW00LA095Accident · No injuriesLimited investigationFinal reportBeech 65-B80 · Midland, TXThe separation of the right main landing gear tire tread which resulted in damage to the right main landing gear mounting structure.Mar 10, 2000 · N8071R · Substantial damageNTSB FTW00LA085Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Weir, TXThe delayed aborted takeoff by the pilot. Factors were the pilot's intentional ground loop/swerve and the tail wind.Feb 19, 2000 · N76190 · Substantial damageNTSB FTW00FA070Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-26A · San Antonio, TXthe pilot's failure to maintain the minimum controllable airspeed following a loss of engine power during the initial takeoff climb. Contributing factors to the accident were both pilot's lack of total experience in the make and model of the accident airplane…Jan 22, 2000 · N386TM · DestroyedNTSB FTW00LA069Accident · No injuriesLimited investigationFinal reportCessna 310Q · Spring Branch, TXThe pilot's delay in aborting the takeoff. A factor was the open cabin door.Jan 20, 2000 · N310GG · Substantial damage