NTSB investigations, IL

533 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\" = 'IL' 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 CHI05FA212Accident · Minor injuriesField investigationFinal reportCessna 421C · Wheeling, ILThe pilot's improper in-flight decision to execute a go-around without raising the landing gear and raising the flaps to the full UP position, resulting in low airspeed and the airplane stalling. Contributing factors to the accident included the pilot's…Aug 5, 2005 · N421KC · DestroyedNTSB CHI05LA122Accident · Serious injuriesLimited investigationFinal reportCessna R182 · Vandalia, ILThe pilot's failure to maintain control of the airplane due to undetermined reasons.May 21, 2005 · N7361Y · Substantial damageNTSB CHI05LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Buffalo Grove, ILFatigue fracture of the engine crankshaft during initial climb after takeoff resulting in a complete loss of engine power. Contributing factors were the trees and the highway.Oct 29, 2004 · N6764P · Substantial damageNTSB CHI05LA018Accident · No injuriesLimited investigationFinal reportKramer Glasair III · Schaumburg, ILFuel starvation for undetermined reasons during initial climb after takeoff. Contributing factors were the fence and fence post impacted during the forced landing.Oct 26, 2004 · N6158N · Substantial damageNTSB CHI05LA004Accident · 1 fatalLimited investigationFinal reportMalone Vans RV-6A · Joliet, ILThe total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight and inadequate fuel consumption calculations, also causal was the pilot's failure to maintain aircraft control during the forced landing. A factor was the…Oct 15, 2004 · N85MM · DestroyedNTSB CHI04LA131Accident · 1 fatalLimited investigationFinal reportZorn EAA Sport Bi-Plane · Mazon, ILThe pilot's failure to maintain airspeed while maneuvering which resulted in a stall. A factor associated with the accident was the pilot's unfamiliarity with the handling characteristics of the airplane.May 29, 2004 · UNREG · Substantial damageNTSB CHI04LA070Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Casey, ILThe pilot not maintaining aircraft control during the loss of engine power and his improper remedial action during the encountered uncommanded roll (VMC roll). An additional cause was the pilot's failure to obtain a maintenance inspection by a qualified…Feb 15, 2004 · N4332P · Substantial damageNTSB CHI04FA029Accident · Minor injuriesField investigationFinal reportLearjet 24D · Belleville, ILThe total loss of power to the right engine and the partial loss of power to the left engine after the airplane encountered a flock of birds during initial climb out, resulting in impeded ram induction airflow.Nov 12, 2003 · N77JL · DestroyedNTSB CHI04LA016Accident · Serious injuriesLimited investigationFinal reportOostdik M-18-X · Pana, ILThe pilot's attention was diverted to a person on the ground which resulted in his failure to maintain altitude/clearance with trees . A contributing factor to the accident were trees.Oct 18, 2003 · N53TW · Substantial damageNTSB CHI03FA202Accident · 1 fatalField investigationFinal reportCessna 150L · Schaumburg, ILThe pilot not maintaining airplane control and the inadvertent stall he encountered during initial climb.Jul 8, 2003 · N10257 · DestroyedNTSB CHI03LA161Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Gridley, ILThe checklist not followed by the pilot and the fuel starvation of the engine. The incorrect fuel tank selector position by the pilot,, and the lack of recurrent training were contributing factors.Jun 15, 2003 · N20553 · Substantial damageNTSB CHI03FA150Accident · Serious injuriesField investigationFinal reportCessna 172M · West Chicago, ILThe abrupt pull-up initiated by the pilot during takeoff before airspeed was attained resulting in a stall. Factors contributing to the accident were the pilot's failure to maintain directional control of the airplane on takeoff and the crosswind.Jun 7, 2003 · N13474 · DestroyedNTSB CHI02LA274Accident · Minor injuriesLimited investigationFinal reportBrooks Sonerai 2L · Canton, ILThe partial failure of the ignition system, the induction air leak at the carburetor mounting plate, and the pilot's inadvertant stall during the forced landing. Contributing factors were the crack in the electronic ignition coil, and the improper…Sep 6, 2002 · N356RB · Substantial damageNTSB CHI02LA136Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Lake in Hills, ILIt was not possible for the pilot to land the airplane at a proper touchdown point during the aborted takeoff and unsuitable terrain was encountered off the end of the runway. Factors associated with the accident were a proper climb rate was not achieved…May 19, 2002 · N210AB · Substantial damageNTSB CHI01FA234Accident · 3 fatalField investigationFinal reportCessna 177 · Benton, ILThe pilot's failure to maintain adequate airspeed, resulting in a stall.Jul 22, 2001 · N235LA · DestroyedNTSB CHI01FA233Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Chenoa, ILThe inadvertent stall the pilot encountered during his turn with an in-flight loss of engine power due to fuel starvation on initial climbout and the improper in-flight decision he made to continue the turn. Factors were the fuel starvation and the incorrect…Jul 21, 2001 · N27AP · Substantial damageNTSB CHI01LA164Accident · No injuriesLimited investigationFinal reportBoeing Stearman A-75 · Marissa, ILThe pilot's manuever to avoid obstructions and his failure to abort takeoff. The pilot's failure to establish adequate climb, and the transmission wire are contributing factors.Jun 8, 2001 · N4558N · Substantial damageNTSB CHI01LA149Accident · 1 fatalLimited investigationFinal reportGeertz Zenith CH 200 · Kankakee, ILThe loss of control on initial climbout for undetermined reasons.May 27, 2001 · N77VZ · DestroyedNTSB CHI01LA023Accident · No injuriesLimited investigationFinal reportErcoupe 415-E · Minier, ILthe carburetor ice and after takeoff, the unsuitable terrain the pilot encountered during the forced landing. Factors were the carburetor icing conditions and the plowed field condition.Oct 23, 2000 · N94176 · Substantial damageNTSB CHI01LA019Accident · No injuriesLimited investigationFinal reportZenair CH2000 · Springfield, ILthe loose carburetor heat control clamp bolt and carburetor heat not available to the pilot. Factors were the low altitude, the carburetor icing conditions, the fence and the security gate.Oct 21, 2000 · N420ZA · Substantial damageNTSB CHI00FA276Accident · 2 fatalField investigationFinal reportBeech E-55 · Grafton, ILThe pilot not maintaining aircraft control and altitude/clearance from the river. Factors to the accident included the pilot not obtaining an air traffic control clearance prior to departure into instrument meteorological conditions, the pilot becoming…Aug 30, 2000 · N9047V · DestroyedNTSB CHI00LA270Accident · Minor injuriesLimited investigationFinal reportRaven AS-55A · Lincoln, ILThe pilot failed to maintain clearance with the power lines. Factors associated with the accident were the pilot's attention was diverted and the power lines which the balloon contacted.Aug 25, 2000 · N1073R · Substantial damageNTSB CHI00LA260Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Chapin, ILthe pilot's failure to refuel the aircraft prior to the flight and exhaustion of the fuel supply. A factor to the accident was the embankment.Aug 17, 2000 · N304JF · Substantial damageNTSB CHI00LA162Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Joliet, ILthe engine failure for undetermined reasons. Factors were the low altitude, remedial action not possible by the pilot, and the ditch.Jun 4, 2000 · N3232H · Substantial damageNTSB CHI00FA039Accident · 2 fatalField investigationFinal reportCessna 310N · Danville, ILAircraft control not being maintained by the flight instructor and the flight instructor's inadequate supervision of the flight. Factors to the accident were the flight instructor's VFR flight into IMC weather conditions, the inadequate preflight…Dec 10, 1999 · N5038Q · DestroyedNTSB CHI99LA358Accident · No injuriesLimited investigationFinal reportBosick Pulsar · Belleville, ILA loss of engine power for undetermined reasons.Sep 23, 1999 · N9550 · Substantial damageNTSB CHI99LA288Accident · No injuriesLimited investigationFinal reportCessna 172G · Glenarm, ILthe pilot's selection of the wrong runway for the prevailing winds. Factors were the pilot's misunderstanding of the wind information and the tailwind.Aug 13, 1999 · N4425L · Substantial damageNTSB CHI99LA268Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401B · Edelstein, ILan inadequate fuel supply which resulted in fuel exhaustion. Factors associated with the accident were the low altitude at which the power loss occurred and the corn crop the airplane contacted.Jul 31, 1999 · N61775 · Substantial damageNTSB CHI99LA228Accident · Minor injuriesLimited investigationFinal reportMcmillan Zodiac CH 601 HD · Nauvoo, ILThe pilot's failure to follow the airplane checklist to pin the canopy before departure, resulting in the opening of the canopy on take off and the subsequent aerodynamic stall and ground collision.Jul 12, 1999 · N6781Z · Substantial damageNTSB CHI99LA110Accident · Serious injuriesLimited investigationFinal reportSocata TB-9C · Cahokia, ILthe in-flight loss of control by the student pilot due to wind turbulence. Additional causes were the flight instructor's inadequate supervision of the flight and the flight instructor's decision to continue the touch and go after encountering turbulence on…Mar 18, 1999 · N508PC · Substantial damageNTSB CHI99LA092Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lawrenceville, ILthe fatigue fracture of the landing gear actuator.Feb 15, 1999 · N9506D · Substantial damageNTSB CHI98LA255Accident · Minor injuriesLimited investigationFinal reportCessna 172N · New Lenox, ILLoss of engine power for undetermined reasons.Jul 24, 1998 · N4813D · Substantial damageNTSB CHI98LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Barrington Hill, ILThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush and subsequent in-flight collision with trees.Apr 14, 1998 · N6300E · Substantial damageNTSB CHI98LA091Accident · No injuriesLimited investigationFinal reportCessna 210G · Springfield, ILThe failure of left main landing gear saddle resulting in the pilot's inability to extend the left gear. A factor was maintenance personnel's failure to comply with the related airworthiness directive.Feb 4, 1998 · N5842F · Substantial damageNTSB CHI98LA089Accident · No injuriesLimited investigationFinal reportChinese A/F Aero Ind Dev CTR PL-1B · Sugar Grove, ILinadequate design of the carburetor heat system by the manufacturer, and subsequent carburetor ice, which resulted in loss of engine power and a forced landing. Factors relating to the accident were: carburetor icing (weather) conditions, and obstructions and…Feb 1, 1998 · N830JT · Substantial damageNTSB CHI98FA074Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-30 · Wayne, ILthe pilot in command failed to maintain control of the aircraft. A factor was the lack of experience of the pilot and copilot in the type and model of aircraft. An additional factor was the pilot did not follow the proper procedure when the flaps were raised…Dec 30, 1997 · N999WB · DestroyedNTSB CHI97LA261Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Hinckley, ILthe failure of the glider pilot to properly handle his airplane during the initial takeoff climb which resulted in the tow pilot's inability to maintain control of his airplane.Aug 16, 1997 · N9781P · DestroyedNTSB CHI97FA133Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Savoy, ILthe pilot's improper preflight planning/preparation and her not maintaining airspeed. Factors were fuel exhaustion and entering an inadvertent stall.May 18, 1997 · N383AV · DestroyedNTSB CHI97LA068Accident · No injuriesLimited investigationFinal reportCessna 172 · West Chicago, ILThe loss of power for undetermined reasons.Feb 8, 1997 · N13611 · Substantial damageNTSB CHI96LA328Accident · No injuriesLimited investigationFinal reportCessna 182P · Cahokia, ILthe pilot misjudged his planned approach during the precautionary landing and the failed to obtain a proper touchdown point. Factors relating to the accident were: the loose oil filler cap, the uneven terrain on which the landing was made, the runway lights…Sep 7, 1996 · N6590M · Substantial damageNTSB CHI96FA264Accident · 1 fatalField investigationFinal reportHoffman, Wolf, Flugzeugbau H-36 · Waukegan, ILfailure of the pilot to maintain adequate airspeed, while maneuvering to land, which resulted in an inadvertent stalled and collision with the terrain. A factor relating to the accident was: the loose engine cowling.Jul 31, 1996 · N86PS · DestroyedNTSB CHI96LA142Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Naperville, ILthe pilot allowed the airplane to become airborne prematurely, which resulted in a stall after liftoff.Apr 24, 1996 · N680V · Substantial damageNTSB CHI95FA301Accident · 1 fatalField investigationFinal reportKiesel Easy Varieze · Dwight, ILinadequate preflight planning by the pilot. A factor associated with this accident was the pilot did not perform an aborted takeoff is sufficient time to safely stop.Sep 2, 1995 · N17BK · DestroyedNTSB CHI95IA215Incident · Minor injuriesIncident investigationFinal reportATR 72-212 · Chicago, ILthe flight attendant's failure to follow procedures which resulted in her inadvertently opening the main cabin door in flight. Factors associated with the incident were: the flight attendant's fatigue due to lack of sleep and a long duty day, interference…Jul 10, 1995 · N440AM · Minor damageNTSB CHI95FA200Accident · 1 fatalField investigationFinal reportCocchi Lancair 320 · Marengo, ILpilot incapacitation due to cardiac arrhythmia (heart attack).Jun 24, 1995 · N3118J · DestroyedNTSB CHI95FA182Accident · 2 fatalField investigationFinal reportGrumman G-21E · West Chicago, ILThe pilot allowed excessive nose-up rotation of the airplane during lift-off, and failed to obtain and/or maintain adequate airspeed, which resulted in an inadvertent stall and collision with the terrain. Factors relating to the accident were: the pilot's…Jun 14, 1995 · N121H · DestroyedNTSB CHI95FA161Accident · Serious injuriesField investigationFinal reportBeech A35 · Downers Grove, ILfuel contamination (water), and the pilot's inadequate aircraft preflight. A factor was trees.May 30, 1995 · N8480A · DestroyedNTSB CHI95LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Rock Falls, ILthe failure of the pilot to refuel prior to fuel exhaustion. A factor in the accident was the pilot's poor preflight planning/preparation.Apr 20, 1995 · N9418D · Substantial damageNTSB CHI95IA119Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Chicago, ILthe inadequacy or deterioration of lubricating grease in the wheel bearing, which led to the total bearing failure and subsequent loss of the wheel. Factors were the insufficiently defined procedures for repacking the bearing, along with an insufficient…Apr 7, 1995 · N9090U · Minor damageNTSB CHI95FA041Accident · 4 fatalField investigationFinal reportCessna P210N · Savoy, ILThe failure of the pilot to maintain a positive rate of climb during the night takeoff. Factors related to the accident were: lack of visual cues, the weather conditions, and the dark night.Nov 13, 1994 · N4895K · Destroyed