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 CHI03FA138Accident · 4 fatalField investigationFinal reportPiper PA-31P · Woodruff, WIThe pilot's failure to follow the before take-off checklist which led to an improper selection of the auxilliary fuel tanks for the takeoff leading to the subsequent fuel starvation of the left engine. Additional causes were the pilot not maintaining minimum…May 25, 2003 · N36DR · DestroyedNTSB CHI03LA016Accident · No injuriesLimited investigationFinal reportLaFerriere Vans RV-4 · Lake Geneva, WIThe loss of engine power due to carburetor ice. A contributing factor was the ditch adjacent to the roadway.Oct 27, 2002 · N994RV · Substantial damageNTSB CHI02LA290Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Chetek, WIThe pilot's failure to maintain directional control of the airplane, and his failure to maintain clearance from the utility pole. A factor was the utility pole.Sep 15, 2002 · N9598C · Substantial damageNTSB CHI02LA268Accident · 1 fatalLimited investigationFinal reportRebholz Rans S-10 · Cottage Grove, WIThe pilot's decision to turn back to the airport following the loss of engine power during initial climb, the pilot not maintaining airspeed and aircraft control, which resulted in the stall at a low altitude. An additional cause was the seizure of the engine…Sep 4, 2002 · N92PD · Substantial damageNTSB CHI02CA267Accident · No injuriesData collectionFinal reportTomash Avid Flyer · Camp Lake, WIThe total failure of the engine ignition system, and the unsuitable terrain encountered during the forced landing. The low altitude was a contributing factor.Aug 31, 2002 · N369AF · Substantial damageNTSB CHI02LA158Accident · No injuriesLimited investigationFinal reportBeech B35 · Lakewood, WIThe pilot's failure to maintain control of the aircraft during takeoff when he encountered a stall after failing to maintain airspeed.Jun 10, 2002 · N352GF · Substantial damageNTSB CHI02LA053Accident · No injuriesLimited investigationFinal reportCessna 172L · Reedsburg, WIThe pilot inadvertently released the seat adjustment mechanism which resulted in the seat sliding back during takeoff, and his subsequent failure to maintain control of the airplane. A factor associated with the accident was the runway light control box,…Dec 9, 2001 · N4303Q · Substantial damageNTSB CHI01LA313Accident · Serious injuriesLimited investigationFinal reportGelasi Aircamper · Bloomfield, WIAircraft control not possible due to the inadvertent control interference by the front seat passenger. Factors to the accident were the restricted control stick movement and the encountered stall.Sep 3, 2001 · N7172B · Substantial damageNTSB CHI01LA271Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-310P · Milwaukee, WIthe rich fuel mixture and the unsuitable landing area encountered by the pilot. Contributing factors were the high output of the fuel pump and the low altitude.Aug 10, 2001 · N9106V · Substantial damageNTSB CHI01LA264Accident · Minor injuriesLimited investigationFinal reportBeech 23 · West Bend, WIThe pilot not following the aircraft fuel management procedures. Factors were the fuel starvation, the low altitude, the manufacturers service instruction not complied with, and the tree.Aug 6, 2001 · N2367J · Substantial damageNTSB CHI01LA216Accident · No injuriesLimited investigationFinal reportStemme S10-VT · Antigo, WIThe cause of the loss of engine power and in-flight fire was undetermined.Jul 14, 2001 · N502SC · DestroyedNTSB CHI01LA200Accident · No injuriesLimited investigationFinal reportCessna 175 · Tomahawk, WIThe inadequate preflight preparation that did not include calculating the density altitude and the pilot not maintaining clearance from the second row of trees on initial climb. Factors include those trees and the high density altitude present at the time of…Jul 8, 2001 · N103DL · Substantial damageNTSB CHI01LA157Accident · Minor injuriesLimited investigationFinal reportCessna 150D · Milltown, WIThe stall/mush encountered by the pilot during that takeoff. Factors were the pilot's excessive lowering of the flaps during the takeoff and the trees.Jun 10, 2001 · N5919T · Substantial damageNTSB CHI01FA111Accident · 1 fatalField investigationFinal reportCessna 501 · Ashwaubenon, WIThe pilot not maintaining aircraft control while maneuvering after takeoff and the pilot's inadequate preflight planning and preparation. Factors relating to the accident were the pilot's diverted attention while maneuvering after takeoff, the pilot's…Apr 2, 2001 · N405PC · DestroyedNTSB CHI01LA074Accident · No injuriesLimited investigationFinal reportCessna 150H · Burlington, WIAircraft control not maintained by the pilot during the landing roll. Factors to the accident were the loss of engine power for undetermined reasons, the end of the runway being snow-covered, and the snowbank.Jan 28, 2001 · N22026 · Substantial damageNTSB CHI01LA038Accident · No injuriesLimited investigationFinal reportCessna T210L · Madison, WIThe cause of the loss of engine power is undetermined. Factors in the accident included the fence and the localizer antennas.Nov 17, 2000 · N29233 · Substantial damageNTSB CHI01LA013Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Baraboo, WIthe failure of the number five intake valve spring during initial climbout and that there was no suitable terrain during the forced landing. A factor was the corn crop.Oct 12, 2000 · N6175K · Substantial damageNTSB CHI00LA294Accident · No injuriesLimited investigationFinal reportBeech B24 · Necedah, WIThe pilot did not properly flare the airplane during the aborted takeoff and he failed to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the partial power loss for undetermined reasons and the…Sep 10, 2000 · N4342W · Substantial damageNTSB CHI00FA263Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Watertown, WIAircraft control not being maintained during initial climb resulting in a stall/mush. Factors to the accident were the pilot's inadequate preflight planning/preparation, the pilot operating over the airplane's certified maximum gross weight, and the pilot…Aug 15, 2000 · N8126V · DestroyedNTSB CHI00LA167Accident · Serious injuriesLimited investigationFinal reportRans Employee Flying Club Rans S-12 XL · Prairie Du Sac, WIA loss of engine power due to fuel starvation as a result of an obstructed fuel nozzle.Jun 18, 2000 · N43886 · DestroyedNTSB CHI00FA129Accident · 3 fatalField investigationFinal reportCessna 172M · Cornell, WIthe pilot not maintaining aircraft control and the stall/spin he encountered. A factor was the extended flaps.May 2, 2000 · N13145 · DestroyedNTSB CHI99FA311Accident · 1 fatalField investigationFinal reportWalker Breezy · Janesville, WIthe inadvertent stall. A factor relating to this accident was the pilot's excessive climb rate.Aug 27, 1999 · N12BZ · DestroyedNTSB CHI99FA296Accident · 1 fatalField investigationFinal reportJohannes-Robert Acrosport RJ-2 · Campbellsport, WIThe loss of control during initial climb for undetermined reasons.Aug 14, 1999 · N42J · DestroyedNTSB CHI99LA255Accident · Minor injuriesLimited investigationFinal reportBuss Avid Flyer Mark IV · New London, WIthe inadequate preflight planning/preparation by the pilot. Factors to the accident were the powerplant seizing and the misjudged flare by the pilot.Jul 10, 1999 · N392SB · Substantial damageNTSB CHI99LA069Accident · No injuriesLimited investigationFinal reportCessna 150C · Middleton, WIinadequate aircraft preflight by the pilot and the ice in the fuel system. A factor associated with the accident was the ravine which the airplane contacted during the forced landing.Jan 20, 1999 · N1956Z · Substantial damageNTSB CHI98LA360Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Amery, WIA loss of engine power due to fatigue failure of the crankshaft from frictional heating for undetermined reasons. A related factor was the unsuitable terrain.Sep 23, 1998 · N5245A · Substantial damageNTSB CHI98LA314Accident · No injuriesLimited investigationFinal reportValentin Taifun 17E · Lake Geneva, WIthe pilot's failure to maintain directional control and obtain proper climb rate during initial climb after takeoff. A factor was trees.Aug 15, 1998 · N17NT · Substantial damageNTSB CHI98FA286Accident · Minor injuriesField investigationFinal reportMonocoupe 70 · New Holstein, WIThe pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing.Jul 31, 1998 · NC6740 · Substantial damageNTSB CHI98LA270Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Sheboygan, WIThe pilot's inadequate fuel management which led to fuel exhaustion.Jul 23, 1998 · N7199M · Substantial damageNTSB CHI98LA227Accident · Minor injuriesLimited investigationFinal reportCommonwealth 185 · Oregon, WIthe improper adjustment of the carburetor by an unqualified person. Factors to the accident were the annual inspection not being complied with and the lack of recent experience of the pilot.Jun 28, 1998 · N92997 · Substantial damageNTSB CHI98LA226Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Osceola, WIthe student pilot's incomplete preflight, and the instructor pilot's inadequate supervision of the student's preflight. Factors were the fuel contaminated with water, and the roadway encountered during the forced landing rollout.Jun 28, 1998 · N50433 · Substantial damageNTSB CHI98LA213Accident · No injuriesLimited investigationFinal reportCessna 310N · Janesville, WIother maintenance personnel not installing nose landing gear door linkage. Factors were the unsecured landing gear door, the nose landing gear becoming jammed and the gear extension not possible by the pilot.Jun 20, 1998 · N5030Q · Substantial damageNTSB CHI98LA105Accident · Minor injuriesLimited investigationFinal reportAero Commander 680FLP · Fond Du Lac, WIthe pilot's misjudged weather evaluation . Factors were turbulence, the pilot's inability to attain a proper climb rate, unsuitable terrain encountered in the landing area, and crops.Mar 13, 1998 · N777MX · Substantial damageNTSB CHI97LA282Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Portage, WIthe pilot's inadequate preflight preparation, and subsequent fuel exhaustion. Factors relating to this accident were: the guard rail, the highway, and the ditch.Aug 27, 1997 · N9026H · Substantial damageNTSB CHI97LA224Accident · Serious injuriesLimited investigationFinal reportBeech B-23 · Watertown, WIa loss of engine power due to undetermined reason(s).Jul 24, 1997 · N9120T · DestroyedNTSB CHI97LA011Accident · Serious injuriesLimited investigationFinal reportAero Commander 685 · Eden, WIa partial loss of engine power due to improper adjustment of the fuel pump by an unqualified person (pilot-in-command) and the pilot's inadequate preflight planning which resulted in his selection of unsuitable terrain for the attempted takeoff. The pilot's…Oct 19, 1996 · N58RG · DestroyedNTSB CHI96FA327Accident · 1 fatalField investigationFinal reportBeech 23 · Tomahawk, WIthe student pilot's impairment of judgment and performance due to alcohol which led to his initiation of VFR flight into instrument meteorological conditions and loss of control. Factors were: the dark night and the weather conditions.Sep 5, 1996 · N2338Z · DestroyedNTSB CHI96LA286Accident · Serious injuriesLimited investigationFinal reportSchuler T Bird II · Fond Du Lac, WIloss of engine power because of improperly insulated ignition wiring. Factors relating to the accident were improper maintenance; and high obstructions in the emergency landing area, which the pilot had to avoid, resulting in a collision with terrain.Aug 12, 1996 · N31774 · Substantial damageNTSB CHI96LA288Accident · No injuriesLimited investigationFinal reportBeech 23 · Wilmot, WIimproper planning/decision by the flight instructor (CFI) by failing to ensure that the airplane would be able to clear brush and trees near the departure end of the runway.Aug 10, 1996 · N1823Q · DestroyedNTSB CHI96LA262Accident · Minor injuriesLimited investigationFinal reportPiper PA-J3C · Camp Lake, WIseizure of the number 2 piston. Inadequate maintenance was a related factor.Jul 31, 1996 · N3445K · Substantial damageNTSB CHI96LA215Accident · No injuriesLimited investigationFinal reportLoehle-Avia 5151RG · Fond Du Lac, WIthe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and loss of engine power. A factor relating to the accident was: the design/location of the fuel tank selector.Jun 25, 1996 · N5151N · Substantial damageNTSB CHI96LA027Accident · Minor injuriesLimited investigationFinal reportBeech 33 · Lone Rock, WIa partial loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed during his attempt to land the airplane back on the runway. A factor in the accident was the pilot's decision not to land in the suitable fields…Nov 4, 1995 · N9559Y · Substantial damageNTSB CHI96LA016Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Oconomowoc, WIa loss of engine power for undetermined reasons. A factor associated with the accident was the unsuitable terrain on which to make the forced landing.Oct 25, 1995 · N4555C · Substantial damageNTSB CHI96LA003Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Thorp, WIthe pilot's failure to abort the takeoff and the premature liftoff which resulted in an inadvertent stall. Factors relating to this accident are improper planning and decision by the pilot, and the tall, wet grass.Oct 9, 1995 · N9090X · Substantial damageNTSB CHI95LA315Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Milwaukee, WIthe pilot's premature liftoff which resulted in a stall.Sep 9, 1995 · N2596N · Substantial damageNTSB CHI95LA309Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Walworth, WIloss of engine power which occurred for an undetermined reason. A factor was the soft terrain in the emergency landing site.Sep 3, 1995 · N5465B · Substantial damageNTSB CHI95LA295Accident · No injuriesLimited investigationFinal reportKraetzner SKY-BUGGY · Princeton, WIthe loss of engine power due to the blocked float valve seat in the carburetor and the pilot's failure to have the proper maintenance inspection performed on the airplane.Aug 20, 1995 · N16626 · DestroyedNTSB CHI95LA176Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Viroqua, WIThe loss of engine power for undetermined reasons.Jun 9, 1995 · N5762W · Substantial damageNTSB CHI95LA141Accident · Minor injuriesLimited investigationFinal reportSorrel SNS-4 · Menomonee Falls, WIthe pilot's failure to maintain clearance with transmission wires. A factor in the accident was the transmission wires.May 1, 1995 · N2026 · Substantial damageNTSB CHI94LA317Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Princeton, WIthe pilot's premature liftoff.Sep 8, 1994 · N4188Q · Substantial damage