NTSB investigations, 1998, WI

12 cases where the phase of flight was Enroute.

Cases per year

19642026
NTSB investigations, 1998, WI per year, 1964–2026: 580 cases
196411
196512
196614
196715
196812
196925
19709
197112
197214
197312
197415
197518
19767
197719
197821
197918
19809
198111
19825
198313
198413
198512
198611
198710
198812
198913
199014
19919
199211
199316
19948
199515
19967
19977
199812
19995
20007
20015
20028
20035
200411
20056
20074
20087
20096
20106
20116
20124
20136
20143
20155
20162
20174
20185
201910
20201
20216
20222
20235
20243
20251
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\") = 1998
    AND c.\"eventStateOrRegion\" = 'WI' 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 CHI99LA048Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Burlington, WICarburetor ice, the pilot's inadequate pre-flight planning/preparation resulting in his flight into poor weather conditions, and the pilot's improper use of carburetor heat. Factors contributing to this accident were the carburetor icing conditions, the…Dec 4, 1998 · N395AC · Substantial damageNTSB CHI98LA367Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-220T · Schofield, WIThe inadvertent deactivation of the fuel selector and the emergency procedure not followed by the pilot-in-command. The tree was a contributing factor.Sep 26, 1998 · N900JH · Substantial damageNTSB CHI98FA349Accident · 3 fatalField investigationFinal reportBeech 58 · Oakdale, WIThe installation of the door seal inflation system by company personnel. An additional cause was the emergency procedures not followed by the pilot-in-command. A contributing factor was the trees.Sep 16, 1998 · N4574Q · DestroyedNTSB CHI98FA356Accident · 2 fatalField investigationFinal reportCessna 310R · Seymour Twp., WIthe pilots of both airplanes not maintaining visual separation from the other airplane.Sep 1, 1998 · N5056J · 2 aircraft · DestroyedNTSB CHI98FA343Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Beaver Dam, WIThe continued flight into adverse weather conditions and aircraft control not maintained by the pilot-in-command. Contributing factors were the improper preflight planning/preparation and lack of certification by the pilot-in-command in addition to the…Aug 28, 1998 · N2931Z · DestroyedNTSB CHI98FA344Accident · 2 fatalField investigationFinal reportCessna A185F · Phillips, WIThe pilot's failure to maintain adequate altitude/clearance with trees. Contributing factors were fog, rain showers, and the trees.Aug 4, 1998 · N888KS · DestroyedNTSB CHI98FA287Accident · 1 fatalField investigationFinal reportNavion A · Coloma, WIFailure of the pilot to maintain proper altitude, and his failure to maintain adequate visual lookout to see and avoid obstructions. The transmission wire was a contributing factor.Aug 1, 1998 · N8991H · DestroyedNTSB CHI98LA283Accident · No injuriesLimited investigationFinal reportAero Commander 685 · Middleton, WIThe fuel starvation of the aircraft in addition to the improper aircraft preflight and premature gear extension by the pilot-in-command. The blocked fuel vent system is a contributing factor.Jul 29, 1998 · N414C · Substantial damageNTSB CHI98LA176Accident · Minor injuriesLimited investigationFinal reportWaters Vortex · Monroe, WIthe pilot's failure to maintain rotor RPM. A factor associated with the accident was the soft terrain on which the gyrocopter touched down.May 27, 1998 · N1025Y · Substantial damageNTSB CHI98LA171Accident · No injuriesLimited investigationFinal reportStemme S10V · Plymouth, WIthe improper in-flight decision of the pilot in command to initiate a turn at a close proximity to the ground. Factors to the accident were the starting procedures not being followed and the inadequate altitude to initiate the engine restart.May 19, 1998 · N97MT · Substantial damageNTSB CHI98FA153Accident · 4 fatalField investigationFinal reportCommander 114-B · Lagrange, WIthe pilot not maintaining aircraft control during cruise flight and exceeding the airplane's design stress limits. Factors in this accident was the pilot's lack of total experience in the airplane and the clouds.May 15, 1998 · N6059C · DestroyedNTSB CHI98IA136Incident · No injuriesIncident investigationFinal reportRobinson R22 Beta · Franklin, WIThe mechanic's failure to follow the manufacturer's maintenance rebuilding instructions.Apr 27, 1998 · N8331F · Minor damage