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.
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" 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 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.NTSB 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.NTSB CHI94FA248Accident · 2 fatalField investigationFinal reportConsolidated-Vultee BT-13A · Racine, WILoss of power for undetermined reason(s). The dark night was a related factor.NTSB 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.NTSB 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.NTSB 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.NTSB CHI94LA156Accident · No injuriesLimited investigationFinal reportCessna 150F · Chippewa Falls, WIthe loss of engine power due to a binding carburetor heat door.NTSB 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…NTSB CHI94DEP02Accident · No injuriesFinal reportCorby Starlet · Watertown, WIThe pilot-in-command's improper use of the elevator and his lack of familiarity with the aircraft.NTSB CHI93LA367Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Crivitz, WIfuel starvation caused by foreign matter in the fuel tank strainer.NTSB 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.NTSB CHI93DEP05Accident · Minor injuriesFinal reportBell 47-G5 · Fulton, WIthe failure (fracture) of the number one cylinder intake valve retainer (keeper).NTSB CHI93FA296Accident · Serious injuriesField investigationFinal reportGrumman G58A · Oshkosh, WIThe pilot-in-command's inadvertent use of the mixture resulting in a lean mixture.NTSB 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.NTSB CHI93LA205Accident · No injuriesLimited investigationFinal reportCessna 172P · Hartford, WIThe failure of the number four cylinder and unsuitable terrain.NTSB 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.NTSB CHI93LA045Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Milwaukee, WIThe pilot's failure to maintain a proper altitude.NTSB 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.NTSB CHI92DEP03Accident · Serious injuriesFinal reportStuart J. Carter Moni · Eau Claire, WIThe pilot-in-command's failure to maintain airspeed.NTSB 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.NTSB 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.NTSB CHI91DEP13Accident · Serious injuriesFinal reportMerritt Robertson B1-RD · Menasha, WIInadequate visual look out whih resulted in a wire strike and uncontrolled descent.NTSB 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.NTSB 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).NTSB CHI91DEP11Accident · Serious injuriesFinal reportEnglish Pietenpol Aircamper · Brodhead, WIErosion of an exhaust valve.NTSB 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.NTSB CHI91LA060Accident · No injuriesLimited investigationFinal reportCessna 150D · Ft. Atkinson, WIThe pilot's failure to refuel. A factor was unsuitable terrain for landing.NTSB 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…NTSB 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.NTSB CHI90DER01Accident · No injuriesFinal reportPiper PA-28-140 · New Richmond, WIThe pilot's inadequate preflight inspection, which resulted in the gascolator drain being left open.NTSB CHI90DEP07Accident · No injuriesFinal reportBell 47-G2 · Hatley, WIThe partial loss of power due to sticking intake valves.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB CHI88LA193Accident · No injuriesLimited investigationFinal reportCessna 172 · Milwaukee, WINTSB 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…NTSB 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…NTSB CHI88LA116Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · La Crosse, WI