Fatal NTSB investigations, WI

14 cases where the phase of flight was Unknown.

Cases per year

19642026
Fatal NTSB investigations, WI per year, 1964–2026: 14 cases
19641
19671
19692
19822
19831
19901
19931
19941
19971
19991
20051
20141

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 c.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 990)
  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 CEN14LA336Accident · 1 fatalLimited investigationFinal reportNorthwing Design Apache Sport · Omro, WIThe pilot’s failure to maintain adequate airspeed to compensate for a newly installed wing, which resulted in the aircraft stalling and the subsequent loss of control.Jul 3, 2014 · N2725T · Substantial damageNTSB CHI05FA274Accident · 3 fatalField investigationFinal reportRobinson R44 · Drummond, WIClearance not obtained/maintained by the pilot during an unknown phase of flight. Contributing factors were the improper use of procedures by the pilot, the inadequate surveillance of the operation by company/management, and the wire.Sep 24, 2005 · N9158U · Substantial damageNTSB CHI99FA129Accident · 2 fatalField investigationFinal reportCessna 152 · Superior, WIthe Certified Flight Instructor failed to maintain control of the airplane.Apr 14, 1999 · N4611B · DestroyedNTSB CHI97FA248Accident · 1 fatalField investigationFinal reportValley Adventurers Adventurer 333 · Fond Du Lac, WIThe kit manufacturer's use of inadequate material in construction of the airplane, his inadequate application of quality controls resulting in the debonding of the horizontal stabilizer. Factors were the total loss of the horizontal stabilizer, the elevator,…Aug 5, 1997 · N323VA · DestroyedNTSB CHI94FA330Accident · 1 fatalField investigationFinal reportBell 47G-5A · Wisconsin Rpds, WIUndetermined.Mar 22, 1994 · N2991W · DestroyedNTSB CHI93FAMS3Accident · 2 fatalMissing aircraftFinal reportLake LA-4 · Superior, WIundetermined.Apr 18, 1993 · N7608L · DestroyedNTSB CHI90FAMS3Accident · 2 fatalMissing aircraftFinal reportCessna 172M · Kewaunee, WIUndetermined.Aug 14, 1990 · N9529H · DestroyedNTSB CHI84FAMS1Accident · 1 fatalMissing aircraftFinal reportMooney M20C · Near Green Bay, WIAfter a taking off at 2029 CST, the plt climbed to 7000 ft & flew on a southerly heading toward the oshkosh VOR. At 2030, the plt indicated that he had a radio problem, but he remained in radio contact with ATC until a freq change at 2039, then no further…Nov 22, 1983 · N9232M · DestroyedNTSB CHI83FA049Accident · 2 fatalField investigationFinal reportAeronca 11CC · Spencer, WIThe acft was observed in a steep left turn at low altitude then impacting the ground straight down. Both propeller blades were bent back with no evidence of twisting. Approximately 1/2 inch of ice was found in the fuel line gascolator.Nov 27, 1982 · N4110E · DestroyedNTSB CHI82FA342Accident · 1 fatalField investigationFinal reportBeech H35 · Beaver Dam, WIAt about 1530 CDT, the aircraft departed madison, WI on a flight to the dodge county airport at juneau, WI. According to a fixed base operator at juneau, the pilot had made arrangements to fly the aircraft there on that date for an annual inspection. At 1544,…Sep 16, 1982 · N4676D · DestroyedNTSB CHI70A0027Accident · 7 fatalClosedLear Jet 23A · Racine, WINov 6, 1969 · N1021B · DestroyedNTSB CHI70F0097Accident · 1 fatalClosedPiper PA-18 · Berlin, WIJun 21, 1969 · N4308Z · DestroyedNTSB CHI67A0086Accident · 1 fatalClosedGlobe GC-1B · Sheboygan, WIJan 11, 1967 · N3738K · DestroyedNTSB UNK64X3060Accident · 2 fatalClosedTaylorcraft BC12-D · Tomahawk, WIJul 26, 1964 · N95159 · Destroyed