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.

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…Jun 10, 1984 · N93431 · DestroyedNTSB 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…Apr 1, 1984 · N7389V · Substantial damageNTSB 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…Jan 18, 1984 · N9555T · Substantial damageNTSB 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.Oct 1, 1983 · N22774 · Substantial damageNTSB 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…Aug 10, 1983 · UNREG · Substantial damageNTSB 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…Aug 4, 1983 · N1369N · DestroyedNTSB 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…Jul 31, 1983 · N8632D · Substantial damageNTSB 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…May 28, 1983 · N2164X · Substantial damageNTSB 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…Apr 15, 1983 · N9215P · DestroyedNTSB 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…Mar 10, 1983 · N5587Q · Substantial damageNTSB 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…Feb 27, 1983 · N5769F · DestroyedNTSB 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…Feb 12, 1983 · N5277X · DestroyedNTSB 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,…Nov 21, 1982 · N22WB · Substantial damageNTSB 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.Nov 18, 1982 · N6078U · DestroyedNTSB 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.Sep 7, 1982 · N50318 · Substantial damageNTSB 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.Aug 30, 1982 · N7746Q · DestroyedNTSB 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.Aug 28, 1982 · N8186X · DestroyedNTSB 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…Jul 31, 1982 · N21254 · Minor damageNTSB 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…Jul 28, 1982 · N3092P · Substantial damageNTSB 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…Jul 11, 1982 · N77697 · Substantial damageNTSB 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…Jun 15, 1982 · N421CB · Substantial damageNTSB 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…May 18, 1982 · N9698T · Substantial damageNTSB 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…Feb 20, 1982 · N63213 · Substantial damageNTSB CHI82FEP01Accident · No injuriesClosedCessna 150J · Waukesha, WIOct 1, 1981 · N51046 · Substantial damageNTSB CHI81FA104Accident · 3 fatalClosedCessna 210 · Mosinee, WISep 25, 1981 · N9582T · DestroyedNTSB CHI81DEP39Accident · No injuriesClosedLuscombe 8A · Egg Harbor, WIJul 19, 1981 · N21996 · Substantial damageNTSB CHI81DEP31Accident · No injuriesClosedCessna 172A · Franklin, WIJul 9, 1981 · N9896Q · Substantial damageNTSB CHI81DEP21Accident · Minor injuriesClosedPiper PA-28 · Genoa City, WIJun 7, 1981 · N8459F · Substantial damageNTSB CHI81FEM13Accident · No injuriesClosedMaule M4 · Weidman, WIApr 18, 1981 · N40312 · Substantial damageNTSB CHI81DEP17Accident · Minor injuriesClosedCessna 172 · Green Bay, WIApr 17, 1981 · N1303U · Substantial damageNTSB CHI81FA038Accident · Serious injuriesClosedBeech 95-C55 · Eau Claire, WIMar 26, 1981 · N168F · DestroyedNTSB CHI81FA024Accident · 1 fatalClosedPiper PA-32 · Lyons Twp, WIFeb 2, 1981 · N300AC · DestroyedNTSB CHI81FEP07Accident · No injuriesClosedCessna 150L · Spencer, WINov 2, 1980 · N6773G · Substantial damageNTSB CHI81FEP05Accident · No injuriesClosedCessna 150L · Rhinelander, WIOct 11, 1980 · N7730G · Substantial damageNTSB CHI81DEP04Accident · No injuriesClosedPiper PA-28 · Cottage Grove, WIOct 7, 1980 · N4817L · Substantial damageNTSB CHI80FEP49Accident · Minor injuriesClosedVarga 2150A · Fort Atkinson, WIAug 19, 1980 · N5083V · Substantial damageNTSB CHI80FEP46Accident · 1 fatalClosedSkyhopper 20 · Oshkosh, WIAug 2, 1980 · N45802 · Substantial damageNTSB CHI80FEP45Accident · 2 fatalClosedVari-Eze 01 · Oshkosh, WIAug 1, 1980 · N7EJ · DestroyedNTSB CHI80DEP41Accident · No injuriesClosedBlanik L-13 · Middleton, WIJul 16, 1980 · N90889 · Substantial damageNTSB CHI80FEP40Accident · No injuriesClosedPitts S-1C · Wyocena, WIJul 13, 1980 · N2761 · Substantial damageNTSB CHI80FEP39Accident · No injuriesClosedCessna 182K · Wilmot, WIJul 3, 1980 · N3013Q · Substantial damageNTSB CHI80DEP30Accident · Minor injuriesClosedCessna 172M · Ixonia, WIMay 17, 1980 · N73362 · Substantial damageNTSB CHI80DEP11Accident · No injuriesClosedPiper PA-28 · Rio Creek, WIDec 29, 1979 · N15651 · Substantial damageNTSB CHI80DA017Accident · 2 fatalClosedCessna 310R · Green Bay, WIDec 21, 1979 · N78ST · DestroyedNTSB CHI80FEP06Accident · No injuriesClosedCessna 172 · Portage, WINov 24, 1979 · N1468V · Substantial damageNTSB CHI80FEP05Accident · Serious injuriesClosedCessna 150M · Omro, WINov 11, 1979 · N45718 · Substantial damageNTSB CHI80FEP04Accident · Minor injuriesClosedCessna 152 · Lake Geneva, WIOct 19, 1979 · N714VN · Substantial damageNTSB CHI79DER07Accident · No injuriesClosedPiper PA-28 · Birchwood, WISep 15, 1979 · N1934T · DestroyedNTSB CHI79FER05Accident · Minor injuriesClosedTaylorcraft BC12-D · Woodville, WIAug 13, 1979 · N43930 · Substantial damageNTSB CHI79FEP71Accident · Serious injuriesClosedMunninghoff FW-190 · Oshkosh, WIAug 5, 1979 · N14926 · Destroyed