NTSB investigations, WI

228 cases where the phase of flight was Maneuvering.

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 = 450)
  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 CHI83FA351Accident · No injuriesField investigationFinal reportSwain Rutan Longeze · Oshkosh, WIThe acft nosed over during a forced landing after a power loss. The acft collided with tall corn during the landing rolland swerved into the corn. Examination of the carburetor revealed pieces of a soft brownish-white somewhat elastic substance in the float…Aug 2, 1983 · N4ZZ · Substantial damageNTSB CHI83FA243Accident · 1 fatalField investigationFinal reportPestes RV-3 · Oshkosh, WIThe accident occurred during a 'showcase' flyby at the annual eaa convention. The acft was flying #4 position in a formation of 4 acft. The flt was executing a very steep, near 90 deg bank left turn at 300-500 ft when the acft's came up & over putting the…Jul 31, 1983 · N45AP · DestroyedNTSB CHI83FA258Accident · 2 fatalField investigationFinal reportCessna T210L · Porter Township, WIBoth occupants were rated plts. The plt in the right front seat of the acft had applied for membership with the organization that owned the plane. He may have been receiving informal instruction in the operation of the acft. During flt, the acft was observed…Jun 15, 1983 · N732CD · DestroyedNTSB CHI83FU004Accident · Serious injuriesFinal reportPara-Sail Glider · Battle Creek, WIThe ultralight vehicle was observed flying low over a golf course. As it approached a tall tree, witnesses heard the addition of power. However, a wing hit the tree & the ultralight spiraled down & impacted the ground. The plt did not possess an FAA plt…Jun 12, 1983 · UNREG · Substantial damageNTSB CHI83LA245Accident · No injuriesLimited investigationFinal reportAeronca 7ECA · Wentworth, WIThe CFI stated that he gave the student a simulated emergency landing. When the acft was about 10-20 ft above the ground a gust of wind caught the acft. The acft dropped suddenly and hit the ground. The landing gear folded and the fuselage and wing tips were…Jun 8, 1983 · N2563F · Substantial damageNTSB CHI83LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Rice Lake, WIThe acft hit a ditch and nosed over during a forced landing after the engine quit. The plt was on a cross country and had landed enroute 3 times without refueling. With the assistance of eau claire fss he overflew Rice Lake arpt but could not find it. The…Apr 19, 1983 · N1491T · Substantial damageNTSB CHI83LA109Accident · No injuriesLimited investigationFinal reportCessna 150 · Calumetville, WITais Cessna 150 collided with snow covered terrain while practicing the results of 'ground effect'. The weather was VMC and no flight plan was filed. The pilot was not injured in the accident. The flight originated at fond du lac WI at 1200 CST on feb. 12,…Feb 12, 1983 · N11454 · Substantial damageNTSB CHI83LA107Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Mauston, WIThe acft collided with a frozen lake during a low pass while sight seeing. The pilot stated that he dropped down to 250 feet AGL to see if anyone was fishing and hit a downdraft. The acft descended and made contact with the snow and ice covered lake. The…Feb 11, 1983 · N6126T · Substantial damageNTSB CHI83FA069Accident · 2 fatalField investigationFinal reportNorth American T-6G · Genoa City, WIPrior to the accident the acft flew over the arpt at tree-top level with the gear retracted. The acft then landed. After spending about 15 min on the ground the plts took off to the west. The gear was retracted immediately after takeoff & the acft remained…Jan 2, 1983 · N3168G · DestroyedNTSB CHI83FA016Accident · 1 fatalField investigationFinal reportLuscombe 8A · Delavan, WIThe airport manager stated that the aircraft had been flying for about 45 min when it returned to the airport. He reported that the pilot made a low pass over the runway, as if he was checking the wind for landing. He saw the pilot start to climb and enter a…Oct 15, 1982 · N1094K · DestroyedNTSB CHI82FA357Accident · 2 fatalField investigationFinal reportFlitecraft Senior Aero · Footville, WIThe home built aircraft was on a familiarization flight for the pilot in the right seat. One witness stated he saw the aircraft (at about 2000 ft AGL) enter a nose high (straight up) attitude followed by a nose low (straight down) attitude. A spin then…Sep 18, 1982 · N119P · DestroyedNTSB CHI82DA281Accident · No injuriesFinal reportEnstrom 280C · Spring Green, WIThe aircraft was on a photographic flight for the purpose of taking pictures of a piece of farm equipment. The first pass was made at about 50 ft AGL, heading into the wind. A turn was then made downwind, back toward the farm equipment. At about that time,…Jul 29, 1982 · N5698M · Substantial damageNTSB CHI82FA267Accident · No injuriesField investigationFinal reportRobinson R22 · Milwaukee, WIAs the student plt was practicing a hovering maneuver, the acft started moving to the left & losing altitude slowly. The CFI was adding collective pitch when the left skid contacted the ground & the acft rolled over. The left skid, m/r blades & tailboom…Jul 23, 1982 · N9031F · Substantial damageNTSB CHI82FA255Accident · 2 fatalField investigationFinal reportAeronca 7AC · Pine Valley Tow, WIThe acft was observed flying at a low altitude to a point 1/4 mi NE of the town over a wooded area & began a turn to the left. During the turn the bank continued to increase & then the nose dropped & the acft descended steeply into the trees. The police…Jul 19, 1982 · N85580 · DestroyedNTSB CHI82DA241Accident · Serious injuriesFinal reportCessna 188B · Stevens Point, WIThe pilot stated that when he was pulling up from a swath run, he noticed a left spray nozzle was leaking. At the same time, he noticed a person on the porch of a house that he was flying over. As he looked to see if the house and person would be avoided, the…Jul 8, 1982 · N9284G · DestroyedNTSB CHI82DA238Accident · No injuriesFinal reportPiper PA-28-200R · Black River Fal, WIThe pilot stated that during flight, he encountered an engine problem and started to land on a road, but then the engine began to run better, so he continued to his destination. After landing, he discovered that a portion of the vertical stabilizer (about 18…Jul 4, 1982 · N56339 · Substantial damageNTSB CHI82FA141Accident · 2 fatalField investigationFinal reportCessna 152 · Kenosha, WIThe aircraft crashed in a steep nosed down attitude while the pilot and one passenger were on a local flight. Prior to the accident, witnesses observed the pilot practicing stalls below 1000 ft. no precrash failures were found. The last entry in the pilot's…Apr 29, 1982 · N48732 · DestroyedNTSB CHI81FEP44Accident · 1 fatalClosedSteen Skyblt · Hartford, WISep 5, 1981 · N81GS · DestroyedNTSB CHI81FA095Accident · 2 fatalClosedPiper PA-18 · Chippewa Falls, WISep 2, 1981 · N99053 · DestroyedNTSB CHI81FEP27Accident · Minor injuriesClosedCessna 172N · Hartford, WIJul 4, 1981 · N8913G · DestroyedNTSB CHI81FEP34Accident · No injuriesClosedSikorsky HRS-1 · Rosedale, WIJul 2, 1981 · N4782S · DestroyedNTSB CHI81FA054Accident · 1 fatalClosedPiper PA-28 · Johnstown Ctr, WIMay 9, 1981 · N6921W · DestroyedNTSB CHI80FEP58Accident · No injuriesClosedPiper PA-25 · Evansville, WISep 26, 1980 · N7627Z · Substantial damageNTSB CHI80FEP55Accident · 1 fatalClosedBensen B-8M · Franksville, WISep 14, 1980 · N37512 · Substantial damageNTSB CHI80FEP54Accident · Minor injuriesClosedPiper PA-22 · Howard, WISep 13, 1980 · N7801D · Substantial damageNTSB CHI80DEP36Accident · No injuriesClosedBell 47G-3B · Plainfield, WIJun 11, 1980 · N73995 · Substantial damageNTSB CHI79FEP79Accident · 1 fatalClosedFly-Baby 1-A · Watertown, WISep 30, 1979 · N6518 · DestroyedNTSB CHI79DEP78Accident · Minor injuriesClosedPiper PA-25 · Pound, WISep 19, 1979 · N9769P · DestroyedNTSB CHI79FA054Accident · 2 fatalClosedCessna 140 · Springbrook, WIJul 1, 1979 · N1972J · DestroyedNTSB CHI79FEP45Accident · Serious injuriesClosedEaa Biplane P2 · Cottage Grove, WIMay 8, 1979 · N14Z · DestroyedNTSB CHI78FEP45Accident · Minor injuriesClosedSnow S2C · Bancroft, WIJul 11, 1978 · N1638S · DestroyedNTSB CHI78FEP13Accident · No injuriesClosedCessna 150-J · Necedha, WIJan 29, 1978 · N51042 · Substantial damageNTSB CHI77FEP49Accident · Serious injuriesClosedHughes 269B · Waupaca, WIAug 2, 1977 · N9448F · Substantial damageNTSB CHI77FEP41Accident · No injuriesClosedSnow S2C · Nekoosa, WIJun 25, 1977 · N1670S · Substantial damageNTSB CHI77FA010Accident · 1 fatalClosedCessna 150E · Depere, WIDec 4, 1976 · N3526J · DestroyedNTSB CHI76AC059Accident · 1 fatalClosedBoeing A75N1 · Lake Geneva, WIMay 4, 1976 · N56945 · DestroyedNTSB CHI76AC023Accident · 2 fatalClosedPiper PA-22 · Cataract, WISep 7, 1975 · N3279B · DestroyedNTSB CHI76DEP13Accident · Minor injuriesClosedStearman A75N1 · Portage, WIAug 11, 1975 · N55891 · DestroyedNTSB CHI76FER01Accident · Minor injuriesClosedPiper PA-25 · Balsam Lake, WIJul 26, 1975 · N4799Y · Substantial damageNTSB CHI76DEP06Accident · No injuriesClosedStearman A75N1 · Alma Center, WIJul 22, 1975 · N55898 · Substantial damageNTSB CHI76AC003Accident · 4 fatalClosedGrum Amer AA-5 · Hammond, WIJul 19, 1975 · N5875L · DestroyedNTSB CHI76DEP03Accident · No injuriesClosedPiper PA-25 · Bancroft, WIJul 15, 1975 · N4659Y · Substantial damageNTSB CHI75DEP24Accident · No injuriesClosedBoeing A75 · Lone Rock, WISep 8, 1974 · N55898 · Substantial damageNTSB CHI75FEP19Accident · 1 fatalClosedBoeing A75N1 · Plover, WISep 1, 1974 · N60334 · DestroyedNTSB CHI75DEP16Accident · No injuriesClosedBoeing A75N1 · Friendship, WIAug 17, 1974 · N61836 · DestroyedNTSB CHI75FEP11Accident · 2 fatalClosedThorpe T-18 · Oshkosh, WIAug 6, 1974 · N193N · DestroyedNTSB CHI74FEP13Accident · No injuriesClosedBell 47D1 · Centerville, WIAug 6, 1974 · N3655F · Substantial damageNTSB CHI74AC092Accident · 3 fatalClosedPiper PA-22 · Oshkosh, WIMay 17, 1974 · N1664A · Substantial damageNTSB CHI74FEP09Accident · Minor injuriesClosedCessna 120 · Okauchee, WIAug 11, 1973 · N76245 · Substantial damageNTSB CHI73DEP66Accident · Minor injuriesClosedBell 47G-5 · Appleton, WIJun 24, 1973 · N7840S · Substantial damage