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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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,…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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,…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB CHI81FEP44Accident · 1 fatalClosedSteen Skyblt · Hartford, WINTSB CHI81FA095Accident · 2 fatalClosedPiper PA-18 · Chippewa Falls, WINTSB CHI81FEP27Accident · Minor injuriesClosedCessna 172N · Hartford, WINTSB CHI81FEP34Accident · No injuriesClosedSikorsky HRS-1 · Rosedale, WINTSB CHI81FA054Accident · 1 fatalClosedPiper PA-28 · Johnstown Ctr, WINTSB CHI80FEP58Accident · No injuriesClosedPiper PA-25 · Evansville, WINTSB CHI80FEP55Accident · 1 fatalClosedBensen B-8M · Franksville, WINTSB CHI80FEP54Accident · Minor injuriesClosedPiper PA-22 · Howard, WINTSB CHI80DEP36Accident · No injuriesClosedBell 47G-3B · Plainfield, WINTSB CHI79FEP79Accident · 1 fatalClosedFly-Baby 1-A · Watertown, WINTSB CHI79DEP78Accident · Minor injuriesClosedPiper PA-25 · Pound, WINTSB CHI79FA054Accident · 2 fatalClosedCessna 140 · Springbrook, WINTSB CHI79FEP45Accident · Serious injuriesClosedEaa Biplane P2 · Cottage Grove, WINTSB CHI78FEP45Accident · Minor injuriesClosedSnow S2C · Bancroft, WINTSB CHI78FEP13Accident · No injuriesClosedCessna 150-J · Necedha, WINTSB CHI77FEP49Accident · Serious injuriesClosedHughes 269B · Waupaca, WINTSB CHI77FEP41Accident · No injuriesClosedSnow S2C · Nekoosa, WINTSB CHI77FA010Accident · 1 fatalClosedCessna 150E · Depere, WINTSB CHI76AC059Accident · 1 fatalClosedBoeing A75N1 · Lake Geneva, WINTSB CHI76AC023Accident · 2 fatalClosedPiper PA-22 · Cataract, WINTSB CHI76DEP13Accident · Minor injuriesClosedStearman A75N1 · Portage, WINTSB CHI76FER01Accident · Minor injuriesClosedPiper PA-25 · Balsam Lake, WINTSB CHI76DEP06Accident · No injuriesClosedStearman A75N1 · Alma Center, WINTSB CHI76AC003Accident · 4 fatalClosedGrum Amer AA-5 · Hammond, WINTSB CHI76DEP03Accident · No injuriesClosedPiper PA-25 · Bancroft, WINTSB CHI75DEP24Accident · No injuriesClosedBoeing A75 · Lone Rock, WINTSB CHI75FEP19Accident · 1 fatalClosedBoeing A75N1 · Plover, WINTSB CHI75DEP16Accident · No injuriesClosedBoeing A75N1 · Friendship, WINTSB CHI75FEP11Accident · 2 fatalClosedThorpe T-18 · Oshkosh, WINTSB CHI74FEP13Accident · No injuriesClosedBell 47D1 · Centerville, WINTSB CHI74AC092Accident · 3 fatalClosedPiper PA-22 · Oshkosh, WINTSB CHI74FEP09Accident · Minor injuriesClosedCessna 120 · Okauchee, WINTSB CHI73DEP66Accident · Minor injuriesClosedBell 47G-5 · Appleton, WI