NTSB investigations, WI

580 cases where the phase of flight was Enroute.

Cases, newest first

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 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 CHI93FA139Accident · 2 fatalField investigationFinal reportCessna 172I · Ettrick, WIAn inflight explosion of a toluene-based fluid inside the airplane's cockpit.Apr 18, 1993 · N8337L · DestroyedNTSB CHI93IA140Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-ATP · Oshkosh, WIan inoperative engine nacelle anti-ice system, and ice ingestion.Apr 11, 1993 · N855AW · No damageNTSB CHI93LA077Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Minocqua, WIThe pilot's failure to properly align the aircraft with the landing area.Jan 26, 1993 · N37224 · Substantial damageNTSB CHI93LA005Accident · Minor injuriesLimited investigationFinal reportUnivair 415C · Waukesha, WIThe pilot's inadequate remedial actions and his misjudged emergency procedure (approach to landing).Oct 5, 1992 · N99256 · Substantial damageNTSB CHI93LA004Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Mountain, WIThe pilot's failure to refuel the airplane.Oct 3, 1992 · N560C · Substantial damageNTSB CHI92LA283Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Baldwin, WISpatial disorientation as the pilot attempted visual flight procedures in instrument meteorological conditions.Sep 21, 1992 · N90BF · DestroyedNTSB CHI92FA223Accident · 2 fatalField investigationFinal reportEdra/Mcdermitt Seabird/Petrel · Oshkosh, WIInadequate quality control during the manufacturing process resulting in the in-flight structural failure of the tailboom.Aug 3, 1992 · N109SB · DestroyedNTSB CHI92FA215Accident · 2 fatalField investigationFinal reportCessna P210N · Mineral Point, WIThe pilot's inadvertent stall and descent into terrain during a forced landing. Related factors are the manufacturer's undertorqued crankcase halves and inadequate surveillance, the pilot's delay in setting up the proper descent rate, and the altered aircraft…Jul 29, 1992 · N6503W · Substantial damageNTSB CHI92LA194Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Belmont, WIThe pilot's poor planning/decision making. Related factors are the low ceilings and fog, the dark night, the pilot's inaccurate weather evaluation and diverted attention, and the pilot's failure to maintain clearance from the higher terrain encountered.Jul 3, 1992 · N9735J · DestroyedNTSB CHI92LA206Accident · Serious injuriesLimited investigationFinal reportBoeing 727-200 · Janesville, WIThe captain's delay in issuing instructions to the flight attendants to take their seats, and his poor crew coordination. A factor in the accident was the turbulence in clouds.Jul 2, 1992 · N7467U · No damageNTSB CHI92FA188Accident · Minor injuriesField investigationFinal reportBeech 24R · Oak Creek, WIA result of inadequate aircraft maintenance inspection on behalf of the company maintenance personnel.Jun 25, 1992 · N2195W · DestroyedNTSB CHI92LA137Accident · Serious injuriesLimited investigationFinal reportBell 47-G2A · Dousman, WIThe in-flight loss of the swash plate drive link bolt which allowed the swash plate drive assembly to disconnect.Apr 30, 1992 · N52HB · Substantial damageNTSB CHI92FA120Accident · 2 fatalField investigationFinal reportCessna 182 · Port Washington, WIThe continuation of VFR flight into IMC conditions, by a (pilot) unknown, and not maintaining aircraft control by a (pilot) unknown.Apr 1, 1992 · N1230D · DestroyedNTSB CHI92FA119Accident · 1 fatalField investigationFinal reportCessna 172H · Browntown, WISpatial disorientation and the pilot's failure to maintain control of the airplane. Factors associated with this accident were the snow conditions, an inadequate weather evaluation by both the student and instructor, over confidence in personal ability,…Apr 1, 1992 · N3884R · DestroyedNTSB CHI92FA059Accident · 4 fatalField investigationFinal reportCessna 172N · Cumberland, WIFailure to maintain aircraft control by the pilot in commnd. Factors in the accident are the pilot's continued flight into known adverse weather, a blocked pitot static system, lack of total expereince in type of operation, and lack of total expereince in…Dec 17, 1991 · N73920 · DestroyedNTSB CHI92LA015Accident · No injuriesLimited investigationFinal reportNorth American Navion D · Lake Geneva, WIFatigue failure of the crankshaft. A factor in the accident was inadequate quality control by other maintenance personnel.Oct 20, 1991 · N10JF · Substantial damageNTSB CHI92LA003Accident · No injuriesLimited investigationFinal reportCessna 150M · Marion, WIThe failure of the exhaust and intake valves. Factors contributing to the accident were downhill terrain and a collapsed nosegear.Oct 8, 1991 · N704CW · Substantial damageNTSB CHI91IA223Incident · No injuriesIncident investigationFinal reportBeech B200 · Greenbay, WIInadequate airframe design, which resulted in the in-flight separation of the left engine's outboard aft upper cowl door.Jul 22, 1991 · N770M · Minor damageNTSB CHI91DEP07Accident · No injuriesFinal reportCessna 182M · Wissota, WIThe pilot in command's misjudgment of the proper touchdown point during an emergency landing and the pilot in command's failure to refuel the airplane.Jun 8, 1991 · N91691 · Substantial damageNTSB CHI91DEP06Accident · No injuriesFinal reportAvid Flyer Avid Flyer · Endeavor, WIThe pilot in command's inability to effectively eliminate carburetor ice to avoid an emergency landing.Jun 7, 1991 · N369AF · Substantial damageNTSB CHI91FA126Accident · 2 fatalField investigationFinal reportBeech F.33A · Chippewa Falls, WIThe first pilot's continued flight in known adverse weather. Factors in the accident were the first pilot's poor weather evaluation, the second pilot's complacency and the first pilot's self induced pressure to complete a checkout in model.Apr 9, 1991 · N8012T · DestroyedNTSB CHI91LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Oskosh, WIRefueling not performed resulting in loss of engine power due to fuel exhaustion. Factors related to the accident were misjudged fuel consumption calculations and non suitable terrain.Apr 7, 1991 · N24399 · Substantial damageNTSB CHI91LA096Accident · No injuriesLimited investigationFinal reportCessna 152 · Osseo, WIFuel exhaustion which occurred when the pilot became lost/disoriented. Factors related to the accident were: the pilot's lack of total experience, the terrain condition, and a fence.Feb 10, 1991 · N49288 · Substantial damageNTSB CHI91LA047Accident · 2 fatalLimited investigationFinal reportCessna 175 · Boscobel, WIThe pilot's continued VFR flight into instrument meteorological conditions (IMC) and his failure to remain clear of the trees. Factors related to the accident were: the adverse weather conditions and the pilot's lack of instrument experience.Dec 19, 1990 · N6626E · DestroyedNTSB CHI91DEP02Accident · Serious injuriesFinal reportCessna 172P · Hayward, WIThe pilot-in-command's intentional flight into known adverse weather.Nov 9, 1990 · N64406 · DestroyedNTSB CHI91LA017Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Portage, WIThe PIC became lost and disorientated and performed a premature precautionary landing.Oct 27, 1990 · N738AP · Substantial damageNTSB CHI90DEP11Accident · Minor injuriesFinal reportVarga Kachina 2150A · Neenah, WIThe pilot's misjudgement of the fuel supply, and his failure to refuel the aircraft. Contributing to the accident was the unsuitable, soft terrain encountered.Sep 22, 1990 · N8422J · Substantial damageNTSB CHI90LA266Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIFuel exhaustion. Contributing factor was the unsuitable terrain.Sep 15, 1990 · N67758 · Substantial damageNTSB CHI90DEP10Accident · No injuriesFinal reportBrose Cirrus VK-30 · Baraboo, WIThe pilot's inadequate preflight and misjudgement of the amount of fuel on board, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel. The inoperative fuel totalizer was a related factor.Aug 28, 1990 · N420A · Substantial damageNTSB CHI90DER06Accident · 1 fatalFinal reportMooney M20C · Webster, WIThe pilot's failure to maintain control of the airplane. Factors related to the accident were: the dark night, the pilot's alcohol impairment, and his night flying restriction.Aug 12, 1990 · N9468V · DestroyedNTSB CHI90LA209Accident · No injuriesLimited investigationFinal reportCessna 150 · Oshkosh, WILoss of engine power for an undetermined reason.Jul 30, 1990 · N11948 · Substantial damageNTSB CHI90LA201Accident · No injuriesLimited investigationFinal reportBryant Rowland T-18 · Fisk, WIThe pilot-in-command of the thorp T-18'S failure to maintain a sufficient visual lookout to avoid a collision with the Cessna 170A. Contributing was the limited visibility forward and to the right in the thorp T-18.Jul 30, 1990 · N66BR · 2 aircraft · Substantial damageNTSB CHI90LA210Accident · No injuriesLimited investigationFinal reportPiper J-3 CUB · Clay Banks, WIPilot's failure to maintain an adequate visual lookout during the descent. Contributing factors are the pilot's poor weather evaluation, and continued VFR flight into IFR conditions.Jul 29, 1990 · N1455N · Substantial damageNTSB CHI90LA157Accident · Minor injuriesLimited investigationFinal reportBeech K-35 · Oshkosh, WIFuel mismanagement.Jun 18, 1990 · N123AT · Substantial damageNTSB CHI90DEP03Accident · No injuriesFinal reportJames A Nelson ZEN AIR CH701 · Raymond, WIManufacturer's inadequate design of the fuel drain. Contributing was the pilot-in-command's disregarding the fuel supply which resulted in fuel exhaustion.Apr 3, 1990 · N360JN · Substantial damageNTSB CHI90LA074Accident · No injuriesLimited investigationFinal reportMBB BK-117A-1 · Janesville, WIThe pilot-in-command failed to ensure that the engine cowling latches were properly secured prior to departing on the maintenance test flight; the cowling came loose during flight, and contacted the main rotor blades before it separated from the helicopter.Jan 30, 1990 · N117M · Substantial damageNTSB CHI90LA072Accident · No injuriesLimited investigationFinal reportBeech E18S · Oak Creek, WIImproper planning/decision by the pilot. Factors related to the accident were: the adverse weather conditions, accumulation of structural and/or induction ice, and dark night.Jan 25, 1990 · N48K · Substantial damageNTSB CHI90FA055Accident · 3 fatalField investigationFinal reportBeech A24R · Merrill, WIFlight into known adverse weather by the pilot, and structural/wing ice. Factors related to the accident were: the icing conditions and trees in the area of the accident.Dec 28, 1989 · N37329 · DestroyedNTSB CHI90LA046Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lacrosse, WIThe student pilot's improper pre-flight planning/preparation, which did not include a plan to refuel the aircraft as necessary. The student pilot's lack of total experience contributed to this accident, as did the cfi's inadequate supervision of the student.Dec 18, 1989 · N704NP · Substantial damageNTSB CHI89LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Watertown, WIImproper planning/decision by the pilot and his misjudgement of distance and speed during the landing, which resulted in failure to attain a proper touchdown point. Contributing factors were: the weather conditions, the pilot's continued flight into…Jul 29, 1989 · N3954R · Substantial damageNTSB CHI89FA150Accident · No injuriesField investigationFinal reportProspector FK-1 · Chilton, WIThe pilot's poor in flight planning in that he diverted his attention and continued the flight beyond the original period planned. Before takeoff the pilot was aware of his fuel endurance.Jul 29, 1989 · N4XK · Substantial damageNTSB CHI89DEP08Accident · No injuriesFinal reportJames Eggleston Varieze · Cottage Grove, WIThe pilot misjudged altitude and distance to the runway and failed to attain the proper touchdown point for a landing. Factors related to the accident were: adverse weather conditions and uneven terrain short of the runway.Jul 29, 1989 · N13EG · Substantial damageNTSB CHI89DEP09Accident · No injuriesFinal reportCabrinha/Free Spirit 412 · Waukesha, WIThe plt became lost/disoriented and allowed fuel exhaustion to occur before accomplishing remedial action. Factors related to the accident were: the adverse environmental conditions and the road sign and vehicles in the emergency landing area.Jul 28, 1989 · N412RC · Substantial damageNTSB CHI89LA141Accident · No injuriesLimited investigationFinal reportCessna R172K · Wisconsin Dells, WIFailure of the pilot to insure the oil filler cap was properly secured when he serviced the aircraft before takeoff, and subsequent loss of oil and oil exhaustion. The tree was considered to be a contributing factor.Jul 22, 1989 · N736DA · Substantial damageNTSB CHI89LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Necedah, WIPilot-in-command's improper use of the fuel selector.May 27, 1989 · N4526Z · Substantial damageNTSB CHI89DEP05Accident · Minor injuriesFinal reportPiper PA-25-235 · Suring, WIImproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of fuel. Factors related to th accident were: the lack of suitable terrain and trees in the emergency landing area.May 22, 1989 · N4395Y · Substantial damageNTSB CHI89DEP04Accident · No injuriesFinal reportHiller UH-12E · Waterford, WIThe pilot's inability to maintain control during an autorotational landing attempt following the failure of the main rotor drive train torsional coupling.May 22, 1989 · N3829 · Substantial damageNTSB CHI89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Waunakee, WISlippage of a bearing, which resulted in blockage of the lubrication system, and subsequent failure of a connecting rod.May 14, 1989 · N7465P · Substantial damageNTSB CHI89FA049Accident · 3 fatalField investigationFinal reportCessna 172RG · Mosinee, WISpatial disorientation of the pilot as a result of initiating the flight into known adverse weather. Factors related to the accident were: dark night, snow, and low ceilings.Feb 8, 1989 · N6525V · DestroyedNTSB CHI89DEP01Accident · 1 fatalFinal reportCessna T337G · Green Bay, WIThe pilot's loss of aircraft control, due to the loss of cockpit/instrument panel lighting for an undetermined reason, the inoperative penlight, and subsequent spatial disorientation of the pilot. Factors related to the accident were: darkness and the adverse…Jan 26, 1989 · N6CF · Destroyed