NTSB investigations, 1990, IL

15 cases where the phase of flight was Enroute.

Cases per year

19632026
NTSB investigations, 1990, IL per year, 1963–2026: 901 cases
19632
196420
196521
196626
196731
196820
196924
197038
197128
197221
197326
197427
197534
197629
197723
197824
197922
198017
198124
198219
198322
198416
198514
198611
198714
198815
198914
199015
199111
199217
199322
199419
199513
199612
199710
199810
199912
200011
200111
200212
20039
20048
200510
20069
200712
20089
20095
20106
20119
20127
20132
20148
20155
201610
20172
20183
20195
20205
20212
20225
20235
20253
20265

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\") = 1990
    AND c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
  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 CHI91DEE02Accident · Minor injuriesFinal reportMaule M-4-220C · Romeoville, ILThe pilot's inadequate preflight inspection resulting in power loss from fuel contamination. A factor in the accident was the owner's failure to accomplish airworthiness directive 84-9-7 which provided direct, convenient access to sample and purge the main…Dec 11, 1990 · N40614 · Substantial damageNTSB CHI91LA043Accident · No injuriesLimited investigationFinal reportCessna 152 · Joliet, ILInadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid each other's aircraft.Dec 8, 1990 · N48779 · 2 aircraft · Substantial damageNTSB CHI90DEV10Accident · 1 fatalFinal reportCarlson Commander Elite · Jerseyville, ILThe pilot's failure to maintain control of the gyroplane.Sep 30, 1990 · N60AC · DestroyedNTSB CHI90LA276Accident · No injuriesLimited investigationFinal reportMooney M20E · Morrison, ILImproper maintenance of the propeller blade by unknown persons and the subsequent failure of the blade in fatigue during cruise flight. A factor was: unsuitable terrain.Sep 27, 1990 · N7197U · Substantial damageNTSB CHI90LA256Accident · Serious injuriesLimited investigationFinal reportBoeing B75N1 · Marseilles, ILThe pilot-in-command's failure to maintain adequate visual outlook to avoid collision with a wire while conducting intentional low level flight.Sep 5, 1990 · N62438 · Substantial damageNTSB CHI90FA233Accident · No injuriesField investigationFinal reportPiper PA-23-160 · Odell, ILA loss of left engine power due to oil accumulation in the right magneto and a non-usable spark lead from the left magneto. In addition, the right engine was unable to provide adequate power to maintain altitude due to a partial blockage in the carburetor by…Aug 16, 1990 · N4231P · Substantial damageNTSB CHI90FA174Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Ashton, ILA loss of aircraft control for an unknown reason, while en route in instrument meteorological conditions (IMC) on a dark night, and the pilot exceeding the design stress limits of the aircraft while attempting to recover from uncontrolled flight. Factors…Jul 11, 1990 · N43515 · DestroyedNTSB CHI90LA169Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Aurora, ILFuel exhaustion. A factor in the accident was inaccurate fuel consumption calculations by the pilot.Jul 9, 1990 · N33332 · Substantial damageNTSB CHI90IA166Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Chicago, ILThe pilot-in-command's inadequate weather evaluation. Factors in the incident were the weather and artcc's failure to issue a weather advisory.Jun 29, 1990 · N948ML · No damageNTSB CHI90DEE06Accident · No injuriesFinal reportPiper PA 28 140 · Savanna, ILThe pilot's misjudgement of the airplane's fuel supply, resulting in fuel exhaustion.Jun 24, 1990 · N5744F · Substantial damageNTSB CHI90DEV06Accident · Minor injuriesFinal reportCessna 210 · Salem, ILImproper positioning of the fuel selector by the pilot, which resulted in fuel starvation, and the pilot's improper emergency procedure.Jun 9, 1990 · N191A · Substantial damageNTSB CHI90LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Monee, ILEngine failure due to oil starvation resulting from improper maintenance and directive compliance associated with the failed part.Mar 23, 1990 · N4490X · Substantial damageNTSB CHI90FA096Accident · 2 fatalField investigationFinal reportPiper PA-60-601P · Bartonville, ILThe pilot allowed the aircraft to exceed its design stress limits after encountering adverse weather. Factors related to the accident were: the pilot's improper evaluation of the weather and the adverse weather condtions.Mar 10, 1990 · N410HC · DestroyedNTSB CHI90FA087Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300 · Lostant, ILFlight into known adverse weather conditions by the pilot and structural (wing) icing. Factors related to the accident were: the adverse weather conditions and the pilot's overconfidence in the aircraft's ability.Feb 23, 1990 · N3063B · DestroyedNTSB CHI90LA079Accident · No injuriesLimited investigationFinal reportCessna 177B · Raleigh, ILInadequate preflight by the pilot and fuel exhaustion due to an inadequate supply of fuel. The unreliable fuel quantity gauge was a related factor.Feb 12, 1990 · N35100 · Substantial damage