NTSB investigations, 1985, IL

9 cases where the phase of flight was Approach.

Cases per year

19632026
NTSB investigations, 1985, IL per year, 1963–2026: 625 cases
19631
196423
196515
196620
196733
196831
196928
197020
197125
197221
197320
197417
197520
197611
197720
197821
197920
198019
198116
19827
198310
198413
19859
198612
19876
198815
19898
19908
19917
199210
19936
19948
19956
19964
19974
19983
19992
20006
20013
20025
20034
20042
20054
20066
20075
200810
20093
20105
20114
20124
20135
20146
20154
20162
20173
20181
20192
20203
20211
20223
20237
20243
20255

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\") = 1985
    AND c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 500)
  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 CHI85LA378Accident · Minor injuriesLimited investigationFinal reportSchweizer 134 · Hampshire, ILThe pilot reportedly failed to use spoilers on final. The approach was high so he attempted a 180 degree turn at the departure end of the runway. The glider stalled and collided with the ground.Sep 14, 1985 · N7627 · Substantial damageNTSB CHI85LA342Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, ILThe student plt stated that he began the flt with 13 gallons of fuel. Following 1 3/4 hrs in the traffic pattern he turned onto left base leg for a full-stop landing on rwy 09. At this point the eng began to lose pwr. He could not reach the rwy and performed…Aug 8, 1985 · N65619 · Substantial damageNTSB CHI85LA337Accident · No injuriesLimited investigationFinal reportCessna 402B · Moline, ILThe acft was landed on soft terrain 1500 ft short of the rwy following a total loss of pwr. The plt reported he failed to use fuel from the aux tanks during the flt and he exhausted the fuel in the main tanks. The fuel boost pumps are located in the main…Aug 7, 1985 · N100FG · Substantial damageNTSB CHI85LA309Accident · No injuriesLimited investigationFinal reportCessna 150D · Lincoln, ILWhen the plt added pwr on final apch, the eng did not respond. An emergency landing was made in a rough fld. The relative humidity was aprx 60%. No mechanical failures/malfunctions were discovered during an eng examination.Jul 23, 1985 · N4460U · Substantial damageNTSB CHI85IA212Incident · No injuriesIncident investigationFinal reportBoeing 727-023 · Chicago, ILAmerican airlines flt 57 had departed baltimore for Chicago. On final approach at ohare the crew discovered the nose gear would not extend. The fe made three attempts to crank down the gear all of which were unsucessful. After landing with nose gear up all…May 28, 1985 · N1984 · Minor damageNTSB CHI85LA132Accident · No injuriesLimited investigationFinal reportCessna 172 · Champaign, ILDuring a practice asr apch using a vision restricting device the plt in command exceeded the mda and crashed in a field aprx 1 mile from the airport. Recommended altitudes were being issued by ATC. The safety plt issued a warning concerning the low alt as the…Mar 8, 1985 · N4332Q · Substantial damageNTSB CHI85LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Lacon, ILWhile on final apch moderate turbulence was experienced. A 200 to 300 foot verticle loss of alt occurred. The plt added pwr and increased the pitch attitude. Before alt could be regained the acft contacted a utility pole. The apch was being made to rwy 18.…Mar 5, 1985 · N3012L · Substantial damageNTSB CHI85IA118Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9 · Champaign, ILOzark flt #814 momentarily touched down with the left main landing gear 16 ft off the left side of rwy 31. When 50 ft above minimums during the ILS rwy 31 apch the f/o called rwy in sight. Captain asked for landing lights which the f/o turned on. Captain…Feb 11, 1985 · N978Z · No damageNTSB CHI85LA086Accident · No injuriesLimited investigationFinal reportCessna 310Q · Plato Center, ILThe acft experienced a nose gear collapse during landing. The plt stated that while on final apch the acft contacted a 3-4 ft high snowbank near the end of the rwy which resulted in the nose gear collapse. He continued to state the snowbank was difficult to…Jan 9, 1985 · N7513Q · Substantial damage