NTSB investigations, WI

394 cases where the phase of flight was Initial climb.

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 = 350)
  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 CHI88DEP02Accident · Serious injuriesFinal reportBeech V35B · Waukesha, WIShortly after liftoff in IMC, the acft descended to the ground. The plt had been cleared for a rt turn but the controller noticed the acft turning left at about 50 ft AGL. The plt later could not stop the drifting to the left. The lndg gear was raised and the…Nov 30, 1987 · N6679J · DestroyedNTSB CHI88IA003Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Milwaukee, WIAircraft landed without further incident after exhaust centerbody fell away from the #1 engine during initial climb. The centerbody landed on private property with no property damage. A service bulletin issued by the manufacturer to inspect the centerbody and…Oct 5, 1987 · N157US · Minor damageNTSB MKC87FA161Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Solon Springs, WIThe surviving pax rprtd that drg initial climb after takeoff, the eng suddenly stopped & did not respond to atmts of a restart. The plt turned back toward the arpt, but was unable to reach the rwy. The acft impacted large trees in a wooded area, then crashed…Aug 15, 1987 · N5831D · DestroyedNTSB CHI87FA191Accident · No injuriesField investigationFinal reportBeech B90 · Milwaukee, WIOn departure the crew identified an in flight fire. An immediate shutdown of electrical, environmental and pressurization systems was initiated and a return was made to the airport with a successful landing. The fire was discovered to have occurred in the…Aug 9, 1987 · N425K · Substantial damageNTSB CHI87LA137Accident · No injuriesLimited investigationFinal reportAircoupe A-2-DEX · Iola, WIThe aircraft experienced a loss of engine power shortly after takeoff and was forced to make an emergency landing next to the runway. On landing roll the nose wheel of the aircraft stuck in the ground, flipping the aircraft over onto its back. According to a…May 31, 1987 · N6509Q · DestroyedNTSB CHI87LA131Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Neillsville, WIA student & instructor (CFI) were on a dual x-country flt fm elroy to Neillsville & rtrn. The flt to Neillsville was uneventfull. After the acft was on the gnd aprx 20 min, hot starting procedures were used to start the eng for the rtrn flt. Eng runup &…May 17, 1987 · N50499 · DestroyedNTSB CHI87LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Footville, WIPilot landed in a field to practice an emergency landing. After two unsuccessful attempts to takeoff from the soft, plowed field, the pilot taxiied onto a two-lane road. On lift off the left wing struck a road sign.May 5, 1987 · N49752 · Substantial damageNTSB CHI87LA102Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Merrill, WIAircraft lost power on takeoff and plt made a forced landng in a rough field. The left main gear collapsed and substantial damage to the outer two feet of the right wing was sustained. Inspection of the aircraft after the accident did not disclose cause of…Mar 21, 1987 · N25333 · Substantial damageNTSB CHI87LA073Accident · No injuriesLimited investigationFinal reportCessna 182M · East Troy, WIThe aircraft was cruising at approximately 2000 feet AGL when the engine began running rough. The plt stated that he added carburetor heat and leaned the mixture, but the engine continued to run rough. The plt elected to make a precautionary landing in an…Feb 2, 1987 · N71383 · Substantial damageNTSB CHI86FEP08Accident · Minor injuriesFinal reportNorth American T28D-FENNEC · Madison, WIAfter the aircraft was initally taxied for takeoff, the pilot returned to the ramp and stated that he was experiencing engine problems. He inquired at an FBO about chartering an aircraft to take himself and his son to an experimental aircraft association…Aug 1, 1986 · N128RM · Substantial damageNTSB CHI86LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Middleton, WIThe CFI and student had been practicing touch-and-go's and had just made a full stop landing. The CFI reported that during a subsequent soft field takeoff, accelleration seemed a little slow, and after lift-off, the aircraft seemed to stop accelerating…Jul 26, 1986 · N2444N · Substantial damageNTSB CHI86FER07Accident · No injuriesFinal reportCessna 172P · Webster, WIShortly after lift-off, the plt noted a loss of power as the acft was climbing, about 40 ft above the rwy. He rprtd the eng 'appeared to run a little above idle.' He landed the acft on the remaining rwy, but it contd off the departure end & nosed over. No…May 17, 1986 · N99583 · Substantial damageNTSB CHI86FEP01Accident · 2 fatalFinal reportCessna 177 · Portage, WISeveral witnesses stated that upon climbout following a low pass, smoke came out of the engine and the engine sputtered. The aircraft was then seen in a steep turn. During this turn the wings reached a vertical position and the aircraft descended to the…Mar 29, 1986 · N29849 · DestroyedNTSB CHI86LA010Accident · Serious injuriesLimited investigationFinal reportBeech K35 · New Lisbon, WIAccording to the plt, acft preflight, engine runup and warm up were normal. Takeoff and initial climb up to approx 300 ft AGL were normal also. At this point the engine quit and the plt performed a forced landing in a clover field below him. The acft was…Oct 14, 1985 · N6060E · DestroyedNTSB DCA85AA036Accident · 31 fatalFinal reportDouglas DC-9-14 · Milwaukee, WIThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-87/01. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Drg…Sep 6, 1985 · N100ME · DestroyedNTSB CHI85LA328Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lakewood, WIThe student plt and his pax had landed on an airstrip on a golf course. On takeoff the student plt lifted off early and stalled back on the turf. He then lost directional control, veered off the airstrip and struck a golfer in the back with the outer section…Jul 27, 1985 · N7183R · Substantial damageNTSB CHI85LA131Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Madison, WIThe acft collided with a snowbank during takeoff after the plt lost directional control. The takeoff was attempted on rwy 22. The wind was from 180 degrees at 13 KTS.Mar 6, 1985 · N2365F · Substantial damageNTSB CHI85LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · Chambers Island, WIThe plt reported that during takeoff upon reaching an alt of 8-10 ft AGL a down draft was encountered and the acft contacted the rwy on the rt landing gear which was in the transient position. He reported he was able to remain airborne but the rate of climb…Nov 22, 1984 · N21596 · DestroyedNTSB CHI84LA389Accident · Minor injuriesLimited investigationFinal reportDenil Sonera II · De Pere, WIPlt stated that on initial climb, he became distracted by an insect in the cockpit and the acft drifted off the right side of the rwy, colliding with telephone lines near the end of the rwy.Sep 10, 1984 · N2265N · Substantial damageNTSB CHI84LA386Accident · No injuriesLimited investigationFinal reportPiper PA25 · Sheboygan, WIPlt initiated takeoff in strong gusty x-wind. Approaching tree line, acft began to sink. Plt turned to avoid trees and stalled acft. Load jettison was too late to aid in stall recovery and acft mushed into ground.Sep 7, 1984 · N4571Y · Substantial damageNTSB CHI84IA373Incident · No injuriesIncident investigationFinal reportBoeing 737-291 · Madison, WIShortly after lift-off & while climbing thru about 150 ft AGL, there was a loud noise from the left eng when it failed. The aircrew secured the left eng, returned to the arpt & made a single eng landing without further incident. An investigation revealed that…Aug 29, 1984 · N7351F · No damageNTSB CHI84FA364Accident · 4 fatalField investigationFinal reportCessna A185F · Lake Delton, WIThe float plane crashed shortly after taking off from Lake Delton while of a sight-seeing flt. The acft was used daily during the tourist season on flts of aprx 15 min long. This was the 8th or 9th flt of the day & was the 4th or 5th flt since refueling. A…Aug 26, 1984 · N61584 · DestroyedNTSB CHI84LA339Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Washington Is., WIThe acft stalled and crashed after the engine lost power at about 50 ft AGL during takeoff. The acft caught fire after touchdown. The fire consumed the cockpit and cabin. An examination of wreckage showed the fuel selector on the left tank. The left tank had…Aug 6, 1984 · N3505Q · Substantial damageNTSB CHI84LA332Accident · No injuriesLimited investigationFinal reportArnold Forest Quickie 2 · Grantsburg, WIThe acft made one forced landing after engine trouble. The plt cleaned the fuel filters and took off for a test flt. The engine failed during takeoff. Post accident inspection of the engine showed it would run but the oil pressure was very low.Aug 5, 1984 · CGUER · DestroyedNTSB CHI84LU006Accident · Serious injuriesFinal reportPterodactyl Fledgling · Hartford, WIThe ultralight was in the takeoff climb at about 75 ft AGL when the engine failed. During the emergency forced landing, the acft landed hard on upsloping terrain & the nose gear failed in overload. Investigation revealed that an ignition wire was worn and had…Jul 7, 1984 · UNREG · Minor damageNTSB CHI84LU003Accident · Serious injuriesFinal reportEipper Quicksilver MXL · Orfordville, WIThe operator, flying off a local street, had just off-loaded a passenger when another individual asked for a ride. The operator agreed and was on takeoff climb when the passenger interferred with the controls resulting in an uncontrolled descent and ground…Jun 12, 1984 · UNREG · DestroyedNTSB CHI84LA213Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Port Washington, WIThe plt stated that after takeoff from a sod field covered with tall grass, the acft drifted to the right of the rwy. While bringing the acft back to the center of the rwy, the acft stalled. The nose gear hit the ground & collapsed, the left wing hit a fence…Jun 3, 1984 · N2665L · DestroyedNTSB CHI84LA210Accident · Minor injuriesLimited investigationFinal reportWagner Cuby WAG-A-BOND · Lyons, WIThe plt noticed '...a little power loss...' After takeoff at about 550 AGL. He turned downwind & flew a normal traffic pattern, but at a lower altitude. The acft stalled during the base turn. The plt stated that the loss of power was due to the mixture…May 27, 1984 · N34WA · Substantial damageNTSB CHI84LA174Accident · Serious injuriesLimited investigationFinal reportGable Sonerai II · Berlin, WIThis homebuilt acft stalled during a forced landing after an engine failure. The plt reported that the engine temperature went to 650 degrees which was an overheat condition. The plt stated that he tried to return to the arpt but stalled 20 ft short of rwy 27…May 5, 1984 · N3994G · Substantial damageNTSB CHI84LA176Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Ft Atkinson, WIThe acft stalled during a short field takeoff after a landing during which full up trim was used. The student plt did not use a checklist or reset the trim prior to takeoff.May 4, 1984 · N25583 · Substantial damageNTSB CHI84LA161Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Genoa City, WIAfter takeoff, the plt had made 2 turns & had attained an alt of about 200 ft AGL when the eng sputtered & lost power. He was unable to turn & land on the rwy, but continued straight ahead to avoid houses & trees. During an emergency landing, the acft…Apr 26, 1984 · N6737W · Substantial damageNTSB CHI83FA370Accident · Minor injuriesField investigationFinal reportZenair Cricket MC12 · Oshkosh, WIDuring a formation takeoff, the plt was flying in a left wingman position & the flt entered a relatively steep climb. The plt stated that the airspeed was slightly above the stall speed at about 100 to 150 ft AGL when the left eng lost power & the acft began…Aug 5, 1983 · CGAYW · Substantial damageNTSB CHI83FA350Accident · Serious injuriesField investigationFinal reportMonnett Moni · Omro, WIAccording to witnesses, the wind was northwesterly at about 20 KTS & the rwy heading of the dirt strip was 030 deg. The plt made a low pass over the strip, then made a touch-&-go landing. On the 3rd apch, the acft touched down about 800 to 900 ft from the…Aug 1, 1983 · N3919X · Substantial damageNTSB CHI83LA219Accident · No injuriesLimited investigationFinal reportPiper PA25 · Tomah, WIThe acft lost power and made a forced landing immediately after takeoff on an aerial application mission. The landing gear collapsed during the landing. The pilot stated that the accident occurred on the 5th flt of the day after taking off on runway 27 and…May 17, 1983 · N4521Y · Substantial damageNTSB CHI83LA174Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Middleton, WIAccording to the instructor pilot the student did not release enough back pressure or use enough right rudder after the acft became airborne. The acft drifted left and was going to stall. The instructor took over and landed the acft. The left main gear came…Apr 21, 1983 · N2444N · Substantial damageNTSB CHI83LA055Accident · No injuriesLimited investigationFinal reportCessna 175 · Neenah, WIPilot took off in short ground run. Crosswind blew aircraft to east side of runway. No climb established. Aircraft flew into trees alongside runway. Alignment with runway not maintained.Dec 10, 1982 · N6588E · Substantial damageNTSB CHI83LA037Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Black River Fal, WIAfter flying in the local area about 1 hr, the pilot landed at the airport. While taxiing back to the hangar, he elected to make another short flight. The aircraft was taxied back to the runway and a takeoff was made. No engine runup or carburetor heat check…Nov 17, 1982 · N813A · Substantial damageNTSB CHI82DA359Accident · Serious injuriesFinal reportScorpion Too · Sheboygan Falls, WIThe pilot made a turn after takeoff and the aircraft vibrated and crashed. No malfunction was found.Sep 19, 1982 · N49JF · DestroyedNTSB CHI82IA331Incident · No injuriesIncident investigationFinal reportSwearingen SA-226TC · Appleton, WIThe right main gear "in transit" light remained on after gear retraction on a training flight. Various methods of remedial action did not cure the problem. A landing on runway 21 was executed with the nose and left main gear in the down position. The right…Sep 2, 1982 · N261S · Minor damageNTSB CHI82FA304Accident · Serious injuriesField investigationFinal reportHiller UH12L4 · Wisconsin Dells, WIDuring climb, at about 200 ft AGL, the m/r lost RPM. During autorotation the eng RPM increased beyond the red line when the plt added power. The helicopter made a hard landing in a residential area. Inspection of the mercury clutch revealed that the exterior…Aug 12, 1982 · N3748Z · Substantial damageNTSB CHI82DA287Accident · No injuriesFinal reportBeech A23A · Grantsburg, WIThe pilot could not start the aircraft with the mixture in the normal (rich) position. The mixture was set to lean and the engine started. During takeoff, the engine lost power and the pilot landed off the end of the runway. This was the first flight since an…Jul 31, 1982 · N3683Q · Substantial damageNTSB CHI82DA277Accident · Minor injuriesFinal reportCessna 172P · Bruce, WIThe pilot departed an alfalfa field that was eight inches high and heavily saturated with dew. A witness stated that upon takeoff the nose of the aircraft was abruptly raised, the aircraft rose about 50 feet, the left wing dropped, the aircraft descended, and…Jul 28, 1982 · N53056 · Substantial damageNTSB CHI82DA253Accident · No injuriesFinal reportCessna A185F · Lake Delton, WIThe float equipped aircraft was being operated on its first flight of the day. After takeoff, the pilot noted a deterioration of power as he was climbing through about 400 ft AGL. He was unable to restore the power and could not maintain level flight. During…Jul 17, 1982 · N8375Q · Substantial damageNTSB CHI82DA192Accident · No injuriesFinal reportErcoupe 415-C · Fort Atkinson, WIThe safety bolt on the propeller hub failed allowing the propeller to separate from the aircraft. The pilot landed in a plowed field.May 29, 1982 · N93616 · Substantial damageNTSB CHI82FA145Accident · 1 fatalField investigationFinal reportCessna 172M · Pardeeville, WIAccording to witnesses the aircraft made a routine takeoff followed by an immediate left climbing turn. The aircraft was observed to lose airspeed and descend into the ground. Witnesses stated that the engine was running until ground impact.May 2, 1982 · N12696 · DestroyedNTSB CHI82DA063Accident · Serious injuriesFinal reportBellanca 8KCAB · Franklin, WIAfter a 1.8 hour flight, the fixed base operator serviced the aircraft with 15 gallons of fuel. The pilot stated that he drained the sumps as part of his preflight. The pretakeoff checks and takeoff roll were normal. At about 75 to 100 feet AGL, the engine…Feb 21, 1982 · N1218E · Substantial damageNTSB CHI82FEP09Accident · 1 fatalClosedOsprey 2 · Madison, WINov 14, 1981 · N209DW · DestroyedNTSB CHI82FEP05Accident · No injuriesClosedPiper PA-28 · Waukesha, WIOct 20, 1981 · N6327W · Substantial damageNTSB CHI82FEP03Accident · Serious injuriesClosedCessna 402B · Park Falls, WIOct 4, 1981 · N4613N · DestroyedNTSB CHI81FER54Accident · No injuriesClosedCessna A185E · Superior, WIJul 26, 1981 · N70049 · Substantial damage