NTSB investigations, 2000, IN

13 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 2000, IN per year, 1964–2026: 1,004 cases
196448
196560
196649
196769
196849
196927
197024
197131
197227
197325
197417
197530
197621
197723
197837
197924
198022
198115
198217
198325
198415
198521
198614
198717
198814
198911
199016
19917
19928
199311
19946
19959
199613
19976
19989
19998
200013
20014
20026
20038
200411
20056
20069
20073
20089
200911
20108
201111
20124
20138
20145
20156
20169
20176
20182
20196
20203
20217
202211
20235
20242
20252
20264

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\" = 'IN' 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 CHI01LA058Accident · No injuriesLimited investigationFinal reportCessna 172N · Elkhart, INThe loss of directional control by the student pilot and the inadequate remedial action and inadequate supervision by the certified flight instructor. Factors were the snow and ice covered runway and the snowbank.Dec 30, 2000 · N6326F · Substantial damageNTSB CHI00TA306Accident · Minor injuriesFinal reportBell 47G-5A · Economy, INThe pilot failed to maintain control of the helicopter while attempting a landing on unsuitable terrain. A factor associated with the accident was the grass covered, down slope in the terrain.Sep 22, 2000 · N14841 · Substantial damageNTSB CHI00LA303Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-325 · Jeffersonville, INthe pilot's inadequate normal braking and the pilot's inability to stop the airplane on the runway. Factors relating to this accident were the hydroplaning conditions, wet runway, the tailwind, the trees, and the ravine.Sep 20, 2000 · N63706 · Substantial damageNTSB CHI00LA297Accident · No injuriesLimited investigationFinal reportPiper PA-22/20 · Marion, INthe pilot failed to maintain directional control during landing. A factor was the dust devil.Sep 1, 2000 · N3383A · Substantial damageNTSB CHI00LA293Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Sellersburg, INthe improper servicing of the emergency extension assembly and the gear extension not verified by company maintenance personnel. Factors were the failure of the hydraulic system's motor, normal and emergency gear extension not available to the pilot, and the…Sep 1, 2000 · N1334T · Substantial damageNTSB CHI00LA233Accident · No injuriesLimited investigationFinal reportCessna 180 · Jeffersonville, INThe pilot failed to maintain directional control of the airplane while landing. A factor associated with the accident was the crosswind.Aug 1, 2000 · N1774C · Substantial damageNTSB CHI00LA232Accident · No injuriesLimited investigationFinal reportCessna 152 · Indianapolis, INthe non-pilot rated passenger's improper flare and not relinquishing the controls, and the pilot's inadequate remedial action and the pilot's poor decision to practice instruction with an unqualified pilot prior to becoming a Certified Flight Instructor.Jul 29, 2000 · N93289 · Substantial damageNTSB CHI00LA218Accident · No injuriesLimited investigationFinal reportYakovlev YAK 52 · Mooresville, INthe brakes not available to the pilot. Factors were the improperly serviced brake system, the improper adjustment of the brakes by maintenance personnel, the trees, and the pilot's decision not to use the available alternate airport.Jul 24, 2000 · N6223X · Substantial damageNTSB CHI00LA219Accident · No injuriesLimited investigationFinal reportMcCann Wheeler Express/FT · Fort Wayne, INthe obstructed brake pedals and the unavailable brakes to the pilot. Factors were the parked airplane and the fence.Jul 1, 2000 · N521MC · Substantial damageNTSB CHI00LA161Accident · No injuriesLimited investigationFinal reportCessna T210N · Indianapolis, INthe unlocked main landing gear and the manual gear extension not performed by the pilot. The electrical system failure was a contributing factor.Jun 12, 2000 · N7426N · Substantial damageNTSB CHI00LA150Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Salem, INthe inadequate compensation for the wind conditions and the failure of the pilot to maintain directional control. A factor to the accident was the crosswind condition.Jun 3, 2000 · N1686P · Substantial damageNTSB CHI00LA102Accident · No injuriesLimited investigationFinal reportBeech A36 · Bloomington, INdirectional control not maintained and maximum gross weight was exceeded by the pilot in command.Mar 31, 2000 · N91TD · Substantial damageNTSB CHI00LA068Accident · No injuriesLimited investigationFinal reportBeech A23 · Knox, INthe instructor pilot not performing remedial action on the student's right drift during the flare. Factors were the student not maintaining directional control, the student not maintaining proper centerline alignment, and the snowbank.Feb 3, 2000 · N1489L · Substantial damage