NTSB investigations, 2011, TX

30 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 2011, 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\") = 2011
    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 CEN12CA130Accident · No injuriesData collectionFinal reportMaule M-7-235 · Eldorado, TXThe pilot's inadequate in-flight planning and decision-making, which resulted in a loss of control during a crosswind landing.Dec 28, 2011 · N6129T · Substantial damageNTSB CEN12CA104Accident · No injuriesData collectionFinal reportCessna 421B · Pampa, TXThe pilot's inadequate aircraft control during landing, which resulted in a hard landing.Dec 9, 2011 · N421CE · Substantial damageNTSB CEN12LA087Accident · No injuriesLimited investigationFinal reportAviat A-1B · Gainesville, TXThe right main gear tire contacting the brake caliper, which resulted in an uncommanded brake effect on the wheel.Nov 23, 2011 · N252U · Substantial damageNTSB CEN12CA081Accident · No injuriesData collectionFinal reportFenton Davis DA-2A · Center, TXThe pilot’s inadequate compensation for gusty, crosswind conditions while landing, which resulted in a loss of directional control. Contributing to the accident was the pilot's lack of familiarity with the airplane.Nov 23, 2011 · N808F · Substantial damageNTSB CEN12TA004Accident · Minor injuriesFinal reportEurocopter EC120B · McAllen, TXThe pilot's improper use of the collective while landing, which resulted in an unrecoverable forward pitching moment. Contributing to the accident was the pilot's improper decision not to go-around.Oct 4, 2011 · N3925A · Substantial damageNTSB CEN11LA658Accident · No injuriesLimited investigationFinal reportMark Divita RV-8 · Lancaster, TXThe failure of the tailwheel to remain locked during a crosswind landing, which resulted in a loss of directional control.Sep 18, 2011 · N98D · Substantial damageNTSB CEN11CA655Accident · No injuriesData collectionFinal reportBeech B90 · Hillsboro, TXThe pilot's failure to obtain a proper touchdown point, which resulted in a runway undershoot.Sep 17, 2011 · N125A · Substantial damageNTSB CEN11CA684Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Fort Worth, TXThe certified flight instructor’s improper flare during a simulated emergency landing.Sep 3, 2011 · N242BC · Substantial damageNTSB CEN11CA670Accident · No injuriesData collectionFinal reportCessna 140 · Conroe, TXThe pilot's excessive use of brakes during the landing.Sep 1, 2011 · N76521 · Substantial damageNTSB CEN11CA564Accident · No injuriesData collectionFinal reportBeech 35-C33 · Rockwall, TXThe pilot's loss of control while landing with a tailwind due to his misinterpretation of the wind conditions.Aug 11, 2011 · N12CA · Substantial damageNTSB CEN11CA583Accident · No injuriesData collectionFinal reportMooney M20K · Cresson, TXThe pilot’s inadequate recovery from a bounced landing and subsequent failure to maintain directional control of the airplane.Jul 23, 2011 · N1149D · Substantial damageNTSB CEN11CA503Accident · No injuriesData collectionFinal reportAero Commander 100 · Llano, TXThe student pilot's failure to attain the proper touchdown point and the flight instructor's delayed remedial action.Jul 20, 2011 · N3656X · Substantial damageNTSB CEN11LA483Accident · Serious injuriesLimited investigationFinal reportMooney M20S · San Antonio, TXThe pilot’s failure to maintain aircraft control during the go-around maneuver.Jul 18, 2011 · N442PT · Substantial damageNTSB CEN11CA461Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Amarillo, TXThe pilot's failure to lower the landing gear prior to landing.Jul 4, 2011 · N5621P · Substantial damageNTSB CEN11CA450Accident · Minor injuriesData collectionFinal reportAmerican Champion 7GCBC · Sugar Land, TXThe pilot's failure to maintain directional control during landing.Jul 2, 2011 · N79RA · Substantial damageNTSB CEN11CA440Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Flugzeugbau DUO Discus · Stonewall, TXThe loss of directional control during an off-field landing in gusting wind.Jul 1, 2011 · N533BG · Substantial damageNTSB CEN11CA363Accident · No injuriesData collectionFinal reportCubCrafters CC11-160 · Goldthwaite, TXThe pilot's encounter with a berm during the landing roll, resulting in the airplane nosing over.May 27, 2011 · N844ES · Substantial damageNTSB CEN11CA331Accident · Minor injuriesData collectionFinal reportCessna 172R · Fort Worth, TXThe student pilot's improper recovery from the bounced landing and the flight instructor's delayed remedial action.Apr 28, 2011 · N411ES · Substantial damageNTSB CEN11CA288Accident · No injuriesData collectionFinal reportPiper PA-30 · Austin, TXThe pilot’s loss of directional control during landing which resulted in a runway excursion.Apr 12, 2011 · N171ST · Substantial damageNTSB CEN11CA257Accident · No injuriesData collectionFinal reportCessna 172K · San Antonio, TXThe student pilot's inadequate compensation for wind while landing in gusty wind conditions.Apr 1, 2011 · N79286 · Substantial damageNTSB CEN11LA251Accident · Minor injuriesLimited investigationFinal reportCessna 425 · Canadian, TXThe pilot’s continuation of the approach with excessive airspeed, which resulted in a hard landing and a loss of directional control.Mar 28, 2011 · N410VE · Substantial damageNTSB CEN11CA248Accident · No injuriesData collectionFinal reportCessna 172N · Graham, TXThe pilot's failure to maintain directional control during landing.Mar 26, 2011 · N9961E · Substantial damageNTSB CEN11CA242Accident · No injuriesData collectionFinal reportDarrow Stephen A Aventura · Ferris, TXThe pilot’s loss of aircraft control during landing.Mar 21, 2011 · N1317L · Substantial damageNTSB CEN11LA223Accident · No injuriesLimited investigationFinal reportLearjet 25 · Houston, TXThe flying pilot's failure to attain the proper touchdown point in low-visibility conditions, which resulted in a runway overrun. Contributing to the accident was mission pressure to land at that airport.Mar 4, 2011 · XA-TWH · Substantial damageNTSB CEN11CA215Accident · No injuriesData collectionFinal reportArion Lightning · Brownsville, TXThe pilot’s failure to maintain adequate airspeed on final approach, resulting in a loss of control and a hard landing.Mar 2, 2011 · N125GD · Substantial damageNTSB CEN11LA210Accident · No injuriesLimited investigationFinal reportCessna LC42-550FG · Llano, TXThe pilot's improper recovery from a bounced landing.Feb 27, 2011 · N1018Q · Substantial damageNTSB CEN11CA212Accident · No injuriesData collectionFinal reportBeech G35 · Brenham, TXThe pilot’s failure to extend the landing gear during the approach resulting in a gear-up landing.Feb 27, 2011 · N437D · Substantial damageNTSB CEN11CA157Accident · No injuriesData collectionFinal reportAeronca 7AC · Corsicana, TXThe student pilot’s failure to maintain directional control during landing.Jan 24, 2011 · N81800 · Substantial damageNTSB CEN11CA155Accident · No injuriesData collectionFinal reportCessna R182 · Houston, TXThe failure of the landing gear to fully extend and lock in the down position due to the inoperative electric pump motor.Jan 19, 2011 · N6187S · Substantial damageNTSB CEN11LA142Accident · No injuriesLimited investigationFinal reportAmerican Legend AL3 · McKinney, TXThe pilot's loss of directional control during landing.Jan 2, 2011 · N102PJ · Substantial damage