NTSB investigations, 2000, TX

25 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 2000, TX per year, 1964–2026: 3,413 cases
1964154
1965175
1966168
1967202
1968118
1969133
1970101
197197
197275
197378
197481
197576
197686
197782
197872
197984
198087
198191
198274
198361
198461
198548
198640
198748
198824
198926
199024
199119
199222
199321
199416
199528
199635
199735
199827
199935
200025
200124
200227
200331
200433
200529
200629
200732
200834
200928
201042
201130
201232
201332
201428
201522
201639
201726
201833
201924
202036
202123
202238
202334
202427
202526
202625

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 = 550)
  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 FTW01LA038Accident · Minor injuriesLimited investigationFinal reportBell 206B3 · Hurst, TXthe flight instructor's failure to maintain directional control during the practice hydraulic off run-on landing. Contributing factors were the gusty wind conditions, and the non-breakaway runway edge light.Dec 18, 2000 · N8240G · Substantial damageNTSB FTW01LA040Accident · No injuriesLimited investigationFinal reportCartercopter Model 1 · Olney, TXThe pilot's delay in lowering the collective during a run-on landing, which resulted in a runway overrun. A factor was the muddy terrain.Dec 13, 2000 · N121CC · Substantial damageNTSB FTW00LA261Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Burnet, TXThe pilot's failure to maintain directional control of the airplane while landing. A factor was the crosswind.Sep 16, 2000 · N34NC · Substantial damageNTSB FTW00LA249Accident · No injuriesLimited investigationFinal reportCessna 170A · Mexia, TXThe pilot's inadequate compensation for wind conditions. Factors were the gusty crosswind and the pilot's failure to perform a go-around upon encountering a windshift/crosswind.Sep 5, 2000 · N1447D · Substantial damageNTSB FTW00LA240Accident · No injuriesLimited investigationFinal reportCessna 172P · San Antonio, TXThe pilot's failure to maintain control during landing. A factor was the reported wind gust.Aug 21, 2000 · N98873 · Substantial damageNTSB FTW00LA238Accident · No injuriesLimited investigationFinal reportCessna 152 · Wichita Falls, TXThe student pilot's delayed landing flare and failure to recover from the ensuing bounced landing.Aug 21, 2000 · N4711L · Substantial damageNTSB FTW00LA217Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Olney, TXThe pilot's inadequate compensation for wind conditions. A factor was the gusty crosswind.Jul 27, 2000 · N7501X · Substantial damageNTSB FTW00LA215Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Lubbock, TXThe pilot's improper aircraft handling as a result of his alcohol impairment.Jul 20, 2000 · N3996Y · Substantial damageNTSB FTW00LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Greenville, TXThe pilot's improper flare, which resulted in a hard landing.Jul 4, 2000 · N1709T · Substantial damageNTSB FTW00LA185Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Mckinney, TXThe flight instructor's inadequate supervision of the landing resulting in the loss of directional control by the student pilot.Jun 24, 2000 · N8427K · Substantial damageNTSB FTW00LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mesquite, TXThe pilot's improper compensation for the existing crosswind condition. A factor was the crosswind.Jun 8, 2000 · N4861T · Substantial damageNTSB FTW00LA177Accident · No injuriesLimited investigationFinal reportStarduster Too SA300 · Spicewood, TXThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the muddy terrain condition.Jun 7, 2000 · N1011Z · Substantial damageNTSB FTW00LA174Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Greenville, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop.Jun 6, 2000 · N45880 · Substantial damageNTSB FTW00LA165Accident · No injuriesLimited investigationFinal reportHard Capella XLS · Taylor, TXThe pilot's failure to maintain directional control during the landing roll. A factor was the pilot's lack of experience in the make and model of the accident aircraft.May 28, 2000 · N427LM · Substantial damageNTSB FTW00LA152Accident · Serious injuriesLimited investigationFinal reportCameron V-90 · Frisco, TXThe pilot's inadequate passenger briefing for a high wind landing. A factor was the wind.May 22, 2000 · N6012C · No damageNTSB FTW00LA148Accident · No injuriesLimited investigationFinal reportCessna 172H · Mesquite, TXThe flight instructor's inadequate supervision of the student pilot during the landing.May 13, 2000 · N2440L · Substantial damageNTSB FTW00LA145Accident · No injuriesLimited investigationFinal reportBell 47G · San Antonio, TXThe improper touchdown performed by the flight instructor.May 9, 2000 · N14408 · Substantial damageNTSB FTW00LA125Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Arlington, TXThe failure of the pilot to maintain directional control during the landing roll. A factor was the pilot's total lack of experience in tailwheel airplanes.Apr 15, 2000 · N2868Z · Substantial damageNTSB FTW00FA101Accident · Minor injuriesField investigationFinal reportSaab 340B · Killeen, TXthe captain's failure to follow standard operating procedure for landing on a contaminated ruway in that he touched down long, which combined with his delayed braking resulted in a runway overrun. Contributing factors were the captain's failure to maintain…Mar 22, 2000 · N353SB · Substantial damageNTSB FTW00LA099Accident · No injuriesLimited investigationFinal reportCessna 402C · San Antonio, TXThe pilot's inadequate handling of the aircraft during the landing flare/touchdown resulting in a hard landing that collapsed the left main landing gear.Mar 16, 2000 · N11NX · Substantial damageNTSB FTW00LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's failure to maintain aircraft control during landing. A factor was the crosswind condition.Mar 1, 2000 · N48821 · Substantial damageNTSB FTW00LA088Accident · No injuriesLimited investigationFinal reportCessna 172K · Alpine, TXThe pilot's failure to maintain aircraft control during landing. A factor was the crosswind condition.Feb 26, 2000 · N46469 · Substantial damageNTSB FTW00LA086Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · New Ulm, TXThe pilot's failure to maintain clearance with a fence during the aborted landing.Feb 26, 2000 · N8967C · Substantial damageNTSB FTW00LA077Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Sarita, TXThe failure of the pilot to maintain main rotor rpm, which resulted in a hard landing.Jan 27, 2000 · N2330F · Substantial damageNTSB FTW00LA060Accident · No injuriesLimited investigationFinal reportCessna 172R · Angleton, TXThe pilot's failure to maintain control of the airplane during landing. A factor was the gust of wind.Jan 10, 2000 · N8292 · Substantial damage