NTSB investigations, WI
424 cases where the phase of flight was Approach.
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 = 500)
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 = 500)
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 CHI84FA226Accident · 1 fatalField investigationFinal reportHiller UH-12E · Merrimac, WIThe acft crashed and burned after an in-flt explosion at about 75 ft AGL as the acft approached to land. The acft had experienced electrical problems of overheating generators and irregular voltage outputs on 2 previous occasions. The pltwas told after some…NTSB CHI84LA146Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30 · Delavan, WIThe plt reported that when he was descending from 3500 ft MSL to traffic pattern alt (2000 ft MSL), he switched the fuel selector from the left fuel tank to the right tank. Upon entering the traffic pattern, he made his prelanding checks. When he advanced the…NTSB CHI84LA088Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Holman, WIAfter flying in the local area for aprx 40 minutes the plt decided to shoot a landing at an airpark before returning to his home arpt. The plt stated that he applied carb heat on the downwind leg and then returned it to off position. He flew the remainder of…NTSB CHI84LA006Accident · No injuriesLimited investigationFinal reportCessna 150 · Neenah, WIThe plt was not lined up with the rwy during final & executed a go-around. He applied full power, retracted flaps, & theacft dropped onto the rwy nose gear first. The student plt had 5 hrs of dual & was no endorsed for solo flt.NTSB CHI83LU007Accident · Serious injuriesFinal reportBerwin Waspair Tomcat Tour · Oconomowoc, WIThe ultralight collided with a tree during a go-around. The acft encountered an updraft during the landing attempt and the pilot decided to go-around. The acft was not able to gain alt fast enough to clear a tree at the end of the field. The pilot was in…NTSB CHI83LA357Accident · 1 fatalLimited investigationFinal reportBlack KR1 · Franklin, WIThe acft was observed to touchdown on rwy 27; become airborne, climb out and turn toward the airport crashing 500 ft short of the rwy. FAA examination of the wreckage did not reveal any evidence of flight control failure/malfunction or pre-impact plt…NTSB CHI83LA354Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Juneau, WIThe pilot stated that he made the approach at 85-90 mph with 40 degrees flaps and 1100 RPM. The winds were from 270 degrees at 10 KTS gusting to 20 KTS the acft started to sink on the short final and the pilot applied power and pulled back on the stick in an…NTSB CHI83LA233Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Woodruff, WIThe plt was briefed on the wx before departing waukegan, IL. At the destination, Woodruff, WI, the wx was forecasted to be VFR, except for light rain & the chance of scattered thunderstorms. While en route, the plt checked on the wx & spoke with another plt…NTSB CHI83FA166Accident · 1 fatalField investigationFinal reportPiper PA24-260 · Middleton, WIDuring arrival at night, the plt was cleared for a vor-b apch to the morey arpt, an uncontrolled facility at an elevation of 928 ft MSL. Rwy 13/31 at the arpt had low intensity rwy lights which could be activated by keying the radio on 123.5 mhz. The circling…NTSB CHI83LA131Accident · No injuriesLimited investigationFinal reportMooney M20C · Solon Springs, WIThe pilot reported that when he departed Solon Springs, WI at 2100 CST, the weather was windy, but the sky was clear. He landed at minneapolis, MN to pick up a passenger, then departed on a return flight to Solon. While returning, he encountered snow. The…NTSB CHI83FA123Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Beloit, WIReportedly, the plt had not flown for 2 or 3 months before his flts on 2/27/83. On that day, he took off & made 5 touch-and-go landings, then stopped for a cup of coffee. The plt then departed again on a 2nd flt. Aprx 1/2 hr later, smoke was observed from the…NTSB CHI83FA108Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Reedsburg, WIThe acft impacted a quonset-type bldg while apparently on an unusual type approach for landing. One witness observed theacft make a low south to north pass over the rwy & then pull up into a loop that culminated in the quonset impact. Another witness observed…NTSB CHI83LA045Accident · No injuriesLimited investigationFinal reportPitts S1S · Wonewoc, WIThe pilot stated that when he turned on final and slipped the aircraft to lose altitude. While reducing the power to idle the gear tangled in high grass (weeds), causing the aircraft to lose additional altitude. He stated the aircraft tumbled forward,…NTSB CHI83LA040Accident · Serious injuriesLimited investigationFinal reportPiper 601P · Sheboygan, WIThe plt noticed haze in lights at destination but had excellent ground contact throughout the approach. At threshold he entered dense ground fog & lost all visual contact. The acft crashed during the go-around.NTSB CHI82DA340Accident · No injuriesFinal reportCessna 150H · Genoa City, WIReturning from a cross-country flight the pilot overshot the touchdown point. During the go-around, the engine quit and the aircraft hit a tree. The pilot stated that he did not evaluate his fuel consumption properly.NTSB CHI82FA329Accident · 1 fatalField investigationFinal reportCessna 310Q · Near Woodruff, WIAt approximately 2050, the acft was cleared for a NDB approach to lakeland arpt. At 2100, the acft crashed into a heavily wooded area 8.5 mi nw of the arpt.NTSB CHI82DA328Accident · Minor injuriesFinal reportCessna 172 · Kenosha, WIN8186X crashed 300 feet short of Kenosha airport, runway 06. The pilot stated the elevator control failed to respond during the approach. However, an on-site investigation failed to reveal any mechanical failure or malfunction.NTSB CHI82IA284Incident · No injuriesIncident investigationFinal reportCessna 182P · Oshkosh, WIThe pilot entered traffic pattern downwind as number 3 for landing. Traffic pattern spacing required a three mile final approach over lake winnebago. The pilot stated that there were two slower aircraft preceeding him and that spacing between aircraft was…NTSB CHI82DA278Accident · No injuriesFinal reportPiper PA-23 · Ladysmith, WIA ferry permit was issued to fly the aircraft to the rusk county airport for an annual inspection. The previous annual inspection had been on 8/20/80. During the arrival at the destination, the approach was high, so the pilot elected to go around. At about…NTSB CHI82DA244Accident · No injuriesFinal reportFairchild 24R-46A · Franklin, WIThe pilot took off and remained in the traffic pattern to land on runway 27. He estimated that the wind was from 300 degrees at 10 knots. He reported that on final approach, he got too low; then about 200 ft short of the runway, his head wind was blocked by…NTSB CHI82FA209Accident · No injuriesField investigationFinal reportCessna 421 · Racine, WIThe plt stated he experienced moderate to severe turbulence enroute. A coupled ILS approach was flown without problems, but the plt stated he had to work hard. The flt broke out at about 1,000 ft MSL & at this time he acquired visual contact with the rwy. He…NTSB CHI82DA173Accident · No injuriesFinal reportCessna 210 · Loganville, WIDuring landing approach the engine lost power and the pilot attempted to land in an open field. The aircraft failed to clear a terrace and the nose gear separated from the airplane. The pilot stated, "while concentrating on the various aspects of operation in…NTSB CHI82DA061Accident · No injuriesFinal reportCessna 150 · Franklin, WIWhile practicing a no-flap landing, the student allowed the aircraft to descend below the normal glide path. The instructor told the student that they were going to be low and to add power. Power was added, but soon thereafter, the aircraft touched down short…NTSB CHI82FEP01Accident · No injuriesClosedCessna 150J · Waukesha, WINTSB CHI81FA104Accident · 3 fatalClosedCessna 210 · Mosinee, WINTSB CHI81DEP39Accident · No injuriesClosedLuscombe 8A · Egg Harbor, WINTSB CHI81DEP31Accident · No injuriesClosedCessna 172A · Franklin, WINTSB CHI81DEP21Accident · Minor injuriesClosedPiper PA-28 · Genoa City, WINTSB CHI81FEM13Accident · No injuriesClosedMaule M4 · Weidman, WINTSB CHI81DEP17Accident · Minor injuriesClosedCessna 172 · Green Bay, WINTSB CHI81FA038Accident · Serious injuriesClosedBeech 95-C55 · Eau Claire, WINTSB CHI81FA024Accident · 1 fatalClosedPiper PA-32 · Lyons Twp, WINTSB CHI81FEP07Accident · No injuriesClosedCessna 150L · Spencer, WINTSB CHI81FEP05Accident · No injuriesClosedCessna 150L · Rhinelander, WINTSB CHI81DEP04Accident · No injuriesClosedPiper PA-28 · Cottage Grove, WINTSB CHI80FEP49Accident · Minor injuriesClosedVarga 2150A · Fort Atkinson, WINTSB CHI80FEP46Accident · 1 fatalClosedSkyhopper 20 · Oshkosh, WINTSB CHI80FEP45Accident · 2 fatalClosedVari-Eze 01 · Oshkosh, WINTSB CHI80DEP41Accident · No injuriesClosedBlanik L-13 · Middleton, WINTSB CHI80FEP40Accident · No injuriesClosedPitts S-1C · Wyocena, WINTSB CHI80FEP39Accident · No injuriesClosedCessna 182K · Wilmot, WINTSB CHI80DEP30Accident · Minor injuriesClosedCessna 172M · Ixonia, WINTSB CHI80DEP11Accident · No injuriesClosedPiper PA-28 · Rio Creek, WINTSB CHI80DA017Accident · 2 fatalClosedCessna 310R · Green Bay, WINTSB CHI80FEP06Accident · No injuriesClosedCessna 172 · Portage, WINTSB CHI80FEP05Accident · Serious injuriesClosedCessna 150M · Omro, WINTSB CHI80FEP04Accident · Minor injuriesClosedCessna 152 · Lake Geneva, WINTSB CHI79DER07Accident · No injuriesClosedPiper PA-28 · Birchwood, WINTSB CHI79FER05Accident · Minor injuriesClosedTaylorcraft BC12-D · Woodville, WINTSB CHI79FEP71Accident · Serious injuriesClosedMunninghoff FW-190 · Oshkosh, WI