NTSB investigations, 1997, IL

11 cases where the phase of flight was Landing.

Cases per year

19642026
NTSB investigations, 1997, IL per year, 1964–2026: 1,788 cases
196491
196578
1966103
1967120
196889
196971
197073
197163
197252
197359
197453
197547
197653
197742
197860
197944
198038
198140
198238
198340
198434
198516
198622
198722
198822
198922
199021
199113
199219
199312
199413
19958
199616
199711
199812
199915
200012
200115
200210
200322
200410
20059
20068
20079
200815
20099
201014
201118
20128
20132
20146
201510
20169
20178
20188
20198
20209
20214
202210
20238
20246
20257
20262

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\") = 1997
    AND c.\"eventStateOrRegion\" = 'IL' 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 CHI98LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Waukegan, ILthe pilot's not identifying unsuitable terrain (snowbank) in the landing area, and his not selecting the proper touchdown point. A factor was the snowbank.Dec 14, 1997 · N68318 · Substantial damageNTSB CHI98LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Sandwich, ILthe pilot's inability to maintain flying airspeed resulting in an inadvertent stall/mush. A factor contributing to this accident was the wind gust.Oct 5, 1997 · N73899 · Substantial damageNTSB CHI98IA007Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Chicago, ILan improper repair to a crack in a brake flange hole on the left main landing gear outboard axle, and subsequent fatigue failure of the axle.Oct 4, 1997 · N129SW · Minor damageNTSB CHI97LA296Accident · No injuriesLimited investigationFinal reportCessna 150M · Salem, ILthe student pilot's improper flare and improper recovery from a bounced landing.Sep 13, 1997 · N66547 · Substantial damageNTSB CHI97LA265Accident · Minor injuriesLimited investigationFinal reportCessna P210 · Grayslake, ILexcessive airspeed and the pilot's failure to attain the proper touchdown point during landing. Factors associated with the accident were inadequate aircraft preflight and the ditch.Aug 20, 1997 · N44C · DestroyedNTSB CHI97LA247Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Hampshire, ILthe pilot's failure to maintain directional control of the airplane during landing, and his excessive use of brakes, which resulted in a nose over. Factors relating to the accident were: the crosswind condition, and the pilot's lack of experience in the make…Aug 5, 1997 · N5066X · Substantial damageNTSB CHI97LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Lansing, ILthe pilot's inadequate compensation for wind conditions, and his failure to maintain sufficient airspeed to flare during the landing. The crosswind was a related factor.Jun 24, 1997 · N99BF · Substantial damageNTSB CHI97LA180Accident · No injuriesLimited investigationFinal reportCessna 172RG · Chicago, ILthe pilot inadvertently executed a wheels up landing.Jun 22, 1997 · N6280R · Substantial damageNTSB CHI97LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Grayslake, ILthe pilot's misjudgment of the aircraft's speed and runway distance available. Factors were an off-field ditch and a tailwind condition.May 13, 1997 · N8309L · Substantial damageNTSB CHI97LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Rochelle, ILthe student pilot's delay in aborting the takeoff and the use of excessive braking after deciding to abort the takeoff. A factor was the pilot's failure to maintain runway alignment during the landing.May 6, 1997 · N5225B · Substantial damageNTSB CHI97LA111Accident · No injuriesLimited investigationFinal reportCessna 177 · Rantoul, ILthe student pilot's improper flare and improper recovery from a bounced landing.Apr 19, 1997 · N3489T · Substantial damage