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 CHI94LA308Accident · No injuriesLimited investigationFinal reportThalman Thorp T-18 · Kenosha, WIthe pilot's failure to use carburetor heat in carburetor icing conditions. A factor associated with the accident is the prevailing carburetor icing conditions.Sep 2, 1994 · N2911 · Substantial damageNTSB CHI94FA258Accident · Minor injuriesField investigationFinal reportKeuthan, Charles J. Buccaneer II · Oshkosh, WIthe pilot's inadvertent stall of the airplane. Factors were the tailwind condition and the pilot's inadequate compensation for the tailwind.Aug 1, 1994 · N5296C · Substantial damageNTSB CHI94FA248Accident · 2 fatalField investigationFinal reportConsolidated-Vultee BT-13A · Racine, WILoss of power for undetermined reason(s). The dark night was a related factor.Jul 29, 1994 · N79752 · DestroyedNTSB CHI94LA216Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Shiocton, WIthe pilot's failure to maintain Vso during takeoff. Factors related to the accident was the disregard for performance data and trees.Jul 1, 1994 · N7472X · DestroyedNTSB CHI94LA210Accident · No injuriesLimited investigationFinal reportTaylorcraft BL-65 · Peshtigo, WIthe pilot's failure to maintain airspeed during the takeoff which resulted in an inadvertent stall. A factor related to the accident was the tall grass on the airstrip.Jun 25, 1994 · N26690 · Substantial damageNTSB CHI94LA179Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lodi, WIthe pilot's failure to maintain direction control which resulted from a inadequate compensation for the crosswind conditions. Factors related to the accident were the pilot's diverted attention, the crosswind, the trees which were contacted.May 29, 1994 · N55835 · Substantial damageNTSB CHI94LA156Accident · No injuriesLimited investigationFinal reportCessna 150F · Chippewa Falls, WIthe loss of engine power due to a binding carburetor heat door.May 12, 1994 · N6872F · Substantial damageNTSB CHI94DER01Accident · Minor injuriesFinal reportJohnson Avid Flyer Mark IV · New Richmond, WICarburetor ice, and the owner/builder's inadequate airplane/equipment design, in that there was no carburetor heat/control installed in the airplane. Factors related to the accident were: the weather (carburetor icing conditions), and obstacles (trees) in the…Apr 17, 1994 · N312RJ · Substantial damageNTSB CHI94DEP02Accident · No injuriesFinal reportCorby Starlet · Watertown, WIThe pilot-in-command's improper use of the elevator and his lack of familiarity with the aircraft.Mar 5, 1994 · N754RG · Substantial damageNTSB CHI93LA367Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Crivitz, WIfuel starvation caused by foreign matter in the fuel tank strainer.Sep 19, 1993 · N6752N · Substantial damageNTSB CHI93LA366Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Madison, WIthe loose fuel selector handle/valve which resulted in an inability to properly switch fuel tanks.Sep 17, 1993 · N823PJ · Substantial damageNTSB CHI93DEP05Accident · Minor injuriesFinal reportBell 47-G5 · Fulton, WIthe failure (fracture) of the number one cylinder intake valve retainer (keeper).Aug 25, 1993 · N1464W · Substantial damageNTSB CHI93FA296Accident · Serious injuriesField investigationFinal reportGrumman G58A · Oshkosh, WIThe pilot-in-command's inadvertent use of the mixture resulting in a lean mixture.Aug 1, 1993 · N3025 · Substantial damageNTSB CHI93LA237Accident · Serious injuriesLimited investigationFinal reportDaniel Squire HI-MAX · Omro, WIthe pilot's inadequate preflight planning and preparation. A factor in the accident is the downdraft.Jun 27, 1993 · N200D · Substantial damageNTSB CHI93LA205Accident · No injuriesLimited investigationFinal reportCessna 172P · Hartford, WIThe failure of the number four cylinder and unsuitable terrain.Jun 14, 1993 · N55404 · Substantial damageNTSB CHI93LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · West Bend, WITotal loss of engine power due to the failure of the pilot to select the fuel tank with the most fuel.Dec 21, 1992 · N8806J · Substantial damageNTSB CHI93LA045Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Milwaukee, WIThe pilot's failure to maintain a proper altitude.Dec 1, 1992 · N6761E · Substantial damageNTSB CHI92DEP05Accident · No injuriesFinal reportReif Avid Flyer · Shiocton, WIFailure of the pilot-in-command to obtain a proper climb rate, and his lack of total expereince in the type of airplane.Sep 2, 1992 · N4220X · Substantial damageNTSB CHI92DEP03Accident · Serious injuriesFinal reportStuart J. Carter Moni · Eau Claire, WIThe pilot-in-command's failure to maintain airspeed.Aug 15, 1992 · N3944C · Substantial damageNTSB CHI92FA218Accident · 1 fatalField investigationFinal reportBull KR-2 · Oshkosh, WIA loss of control in flight due to pilot incapacitation as a result of a heart attack.Aug 2, 1992 · N86QT · DestroyedNTSB CHI92LA165Accident · No injuriesLimited investigationFinal reportCessna 140 · Howard, WIAn inadequate preflight inspection by the pilot in command and a loss of engine power from contaminated fuel.Jun 9, 1992 · N2776N · Substantial damageNTSB CHI91DEP13Accident · Serious injuriesFinal reportMerritt Robertson B1-RD · Menasha, WIInadequate visual look out whih resulted in a wire strike and uncontrolled descent.Sep 7, 1991 · UNREG · DestroyedNTSB CHI91LA283Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Burlington, WIThe pilot's exceeding the airplane's licensed gross weight and the pilot's improper preflight planning and preparation.Aug 31, 1991 · N9514R · Substantial damageNTSB CHI91LA265Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Mosinee, WIThe pilot's poor preflight planning/preparation, and the selection of unsuitable terrain for takeoff. A related factor was the grassy runway (farm field).Aug 14, 1991 · N38189 · Substantial damageNTSB CHI91DEP11Accident · Serious injuriesFinal reportEnglish Pietenpol Aircamper · Brodhead, WIErosion of an exhaust valve.Jul 27, 1991 · N14961 · Substantial damageNTSB CHI91LA177Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Depere, WIThe pilot's failure to correct a mushed stall during liftoff. A factor in the accident was the pilot's failure to compensate for wind conditions.May 31, 1991 · N4090N · DestroyedNTSB CHI91LA060Accident · No injuriesLimited investigationFinal reportCessna 150D · Ft. Atkinson, WIThe pilot's failure to refuel. A factor was unsuitable terrain for landing.Jan 6, 1991 · N4286U · Substantial damageNTSB CHI90MA244Accident · 5 fatalMajor investigationFinal reportBell 206B · Elkhorn, WIImproper planning/decision by the pilot, and his failure to attain adequate altitude before flying over rising terrain at night. Factors related to the accident were: darkness, fog, haze, rising terrain, and the lack of visual cues that were available to the…Aug 27, 1990 · N16933 · DestroyedNTSB CHI90FA236Accident · 7 fatalField investigationFinal reportPiper PA-32R-300 · Watertown, WIInitiation of VFR flight into adverse weather and instrument meteorologial conditions. Factors which contributed to the accident were the adverse weather conditions and the pilot's self-induced pressure to maintain currency.Aug 19, 1990 · N4070Q · DestroyedNTSB CHI90DER01Accident · No injuriesFinal reportPiper PA-28-140 · New Richmond, WIThe pilot's inadequate preflight inspection, which resulted in the gascolator drain being left open.Jul 12, 1990 · N5330F · Substantial damageNTSB CHI90DEP07Accident · No injuriesFinal reportBell 47-G2 · Hatley, WIThe partial loss of power due to sticking intake valves.Jul 10, 1990 · N6768D · Substantial damageNTSB CHI90LA164Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Cornell, WIThe pilot's inadequate preflight resulted in a loss of engine power due to contamination in the fuel system.Jun 30, 1990 · N41RP · DestroyedNTSB CHI90DEP05Accident · No injuriesFinal reportCirrus Klappmeier Cirrus VF-30 · Baraboo, WIManufacturer's inadequate equipment design to prevent a fuel leak which resulted in an in-flight fire. A factor related to the accident was the lack of an unsuitable forced landing area.Jun 14, 1990 · N888EK · DestroyedNTSB CHI90DEP04Accident · Serious injuriesFinal reportGoss KR-2 · Kenosha, WIFailure of the pilot to maintain control of the aircraft, while flying it with a laterally imbalanced condition. Factors related to the accident were: the pilot's lack of flying experience, and his lack of familiarity with this aircraft.May 27, 1990 · N777BG · DestroyedNTSB CHI90DEP02Accident · Serious injuriesFinal reportRotec Panther 2+ · Holmen, WIInadvertent partial deployment of the emergency ballistic recovery parachute resulting in a loss of engine thrust and aerodynamic control of the aircraft.Dec 1, 1989 · UNREG · Substantial damageNTSB CHI90DEP01Accident · Serious injuriesFinal reportWychen Challenger II · Warrens, WIA broken cranskshaft which resulted in the loss of power. A factor related to the accident was: the lack of suitable terrain for a forced landing.Oct 22, 1989 · N91269 · Substantial damageNTSB CHI89DEP11Accident · Minor injuriesFinal reportTierra II Panther 2 Plus · Tomah, WIThe pilot's premature liftoff, which resulted in a stall/mush and subsequently impact on the runway.Aug 23, 1989 · N22KK · Substantial damageNTSB CHI89FA165Accident · Serious injuriesField investigationFinal reportBell 47G-2A-1 · Wisconsin Dells, WIAttempt by the pilot to exceed the hover performance capabilities of the helicopter, and operating outside the weight and balance limitations. The pilot's overconfidence in the helicopter's ability and his subsequent failure to adequately prepare and plan…Aug 14, 1989 · N49HB · Substantial damageNTSB CHI89FA154Accident · Minor injuriesField investigationFinal reportRyan PT-22 · Oshkosh, WIThe experimental aircraft association's (eaa's) inadequate procedure for providing control and separation of aircraft, its inadequate surveillance of the operation, and inadequate coordination by ground personnel. Related factors were: the ground personnel's…Jul 31, 1989 · N54403 · 2 aircraft · Substantial damageNTSB CHI89DEP07Accident · Minor injuriesFinal reportHiller UH-12E · Blackriverfalls, WIPilot-in-command's failure to jettison the external load followed by his misjudgement of distance to avoid collision with the external load.Jul 20, 1989 · N48313 · DestroyedNTSB CHI89FA113Accident · 1 fatalField investigationFinal reportCessna 150L · Wisc Rapids, WIThe pilot's failure to assure that the flaps were in the up position during takeoff. A factor related to the accident was the pilot's lack of familiarity with aircraft.Jun 18, 1989 · N6878G · DestroyedNTSB CHI89LA053Accident · No injuriesLimited investigationFinal reportAeronca 7KCAB · Pine Creek, WIThe pilot's selection of unsuitable terrain which resulted in the failure to achieve a proper climb rate which resulted in the collision with trees. Contributing to the accident was the uphill, snow covered terrain.Mar 5, 1989 · N9044L · Substantial damageNTSB CHI89LA044Accident · No injuriesLimited investigationFinal reportCessna 150J · Osceola, WIInadequate preflight by the student pilot, inadequate supervision (to assure a proper preflight) by the instructor pilot (CFI), and water contamination of the fuel. The terrain was considered to be a contributing factor.Jan 15, 1989 · N61306 · Substantial damageNTSB CHI88LA232Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Watertown, WIThe pilot in command's improper selection of the fuel tank, and his subsequent failure to maintain control of the aircraft.Sep 8, 1988 · N9346C · DestroyedNTSB CHI88LA215Accident · No injuriesLimited investigationFinal reportCessna 170 · Boyceville, WIShortly after lift-off, the aircraft encountered a gust of wind and the pilot failed to compensate adequately for the wind conditions. The pilot experienced a loss of aircraft control and decided to reject the takeoff and execute a landing. The aircraft…Aug 21, 1988 · N3804V · Substantial damageNTSB CHI88LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140E · Glidden, WIWhile attempting to takeoff from a 2,175' grass strip, with the aircraft loaded near maximum gross weight, the pilot approached the end of the runway without having attained liftoff airspeed. The pilot lifted the aircraft off the ground prematurely and was…Aug 18, 1988 · N4476T · Substantial damageNTSB CHI88LA193Accident · No injuriesLimited investigationFinal reportCessna 172 · Milwaukee, WIAug 7, 1988 · N65711 · Substantial damageNTSB CHI88DEP08Accident · No injuriesFinal reportMonnett Sonerai II · Wisc Rapids, WIThe plt rprtd that drg takeoff, the eng lost power as the acft was climbing thru about 200' AGL. An emerg lndg was made in the best available area, which was a golf course on rolling terrain. Drg the lndg roll, the plt applied brakes, but was unable to stop…Aug 1, 1988 · N79TG · Substantial damageNTSB CHI88DEP06Accident · No injuriesFinal reportHuntley Challenger II · Platteville, WIAfter climbing about 100' after takeoff, a partial power loss occurred & the plt initiated a left turn to rtrn to the arpt. Unable to reach the arpt, an emerg lndg was made in a corn field & the acft was damaged. No airframe failure was found & the eng ran…Jul 12, 1988 · N51012 · Substantial damageNTSB CHI88LA116Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · La Crosse, WIMay 21, 1988 · N9686S · Substantial damage