NTSB investigations, IL

408 cases where the phase of flight was Takeoff.

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 = 300)
  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 CHI91LA081Accident · No injuriesLimited investigationFinal reportCessna 172N · Lansing, ILInadequate compensation for wind conditions and failure to maintain directional control. A factor related to the accident is the snow covered runway.Jan 22, 1991 · N5345D · Substantial damageNTSB CHI90LA241Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Schaumburg, ILThe pilot's failure to attain a proper climb rate after takeoff. Factors related to the accident are misjudgement of the aircraft takeoff weight, and overconfidence in the ability of the aircraft.Aug 25, 1990 · N29463 · DestroyedNTSB CHI90LA234Accident · No injuriesLimited investigationFinal reportBeech P-35 Bonanza · Joliet, ILThe delay in initiating the aborted takeoff.Aug 15, 1990 · N8699M · Substantial damageNTSB CHI90LA110Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Lodge, ILFailure of the pilot to maintain directional control during takeoff. The crosswind and the soft/uneven terrain were factors related to the accident.Apr 8, 1990 · N55JJ · Substantial damageNTSB CHI90LA014Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, ILImproper planning/decision by the pilot, which resulted in his failure to attain sufficient airspeed. Factors related to the accident were: the runway condition & obstructions.Oct 21, 1989 · N9487T · Substantial damageNTSB CHI89LA182Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Newark, ILInadequate supervision by the flight instructor (CFI) and his delay in aborting the takeoff. Factors related to the accident were: malfunction of the flap system, which resulted in an improper flap setting for takeoff, and the soft runway condition.Sep 11, 1989 · N4841P · Substantial damageNTSB CHI89IA180Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-80 · Chicago, ILThe failure of the controller to clarify the confusing communications, to correct the pilot's misinterpretation of the instructions being given, and the failure of the supervisor to properly monitor the situation. Factors related to the incident were the…Aug 31, 1989 · N490AA · 2 aircraft · No damageNTSB CHI89IA054Incident · No injuriesIncident investigationFinal reportShort Brothers SD360 · Chicago, ILThe PIC followed a clearance intended for another airplane.Mar 8, 1989 · N366MQ · No damageNTSB CHI89LA032Accident · No injuriesLimited investigationFinal reportCessna 152II · Lake In The Hls, ILThe pilot in command failed to maintain directional control of the aircraft while correcting for a crosswind. Contributing to the cause is the pilot's lack of experience.Dec 16, 1988 · N714ZE · Substantial damageNTSB CHI89IA018Incident · No injuriesIncident investigationFinal reportBoeing B-727-200A · Chicago, ILOn departure from Chicago, Illinois, o'hare airport the aircraft experienced a loss of the inboard left main wheel. The aircraft diverted to detroit, Michigan, where it was landed with no damage to the aircraft and no injuries to the crew or passengers.…Oct 24, 1988 · N277US · Minor damageNTSB CHI89LA007Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbondale, ILThe student pilot, while on the takeoff roll on his first solo flight, experienced a loss of directional control which he failed to correct. The aircraft swerved to the left and departed the runway, striking a VASI installation before coming to a stop. The…Oct 9, 1988 · N98395 · Substantial damageNTSB CHI88DEV03Accident · No injuriesFinal reportHughes 369HS · Ashland, ILAs the helicopter was taking off, there was a loss of rotor RPM which was accompanied by a loss of fuel flow to the eng. The plt aborted the takeoff, but during touchdown, the main rotor blades flexed downward & severed the . Tail boom. An inspn of the eng…Jul 28, 1988 · N9033F · Substantial damageNTSB CHI88DEE05Accident · No injuriesFinal reportWeatherly 620 · Dekalb, ILAn on ground encounter with weather.Jul 11, 1988 · N4605P · Substantial damageNTSB CHI88IA141Incident · No injuriesIncident investigationFinal reportSwearingen SA226-TC · Chicago, ILFailure of the front motor bearing in the sas servo motor assembly, and the resultant 'jamming' of the elevator control cables. The pilot aborted the takeoff as a result of the vibration in the yoke.Jun 22, 1988 · N329BA · No damageNTSB CHI88DCA01Accident · No injuriesFinal reportBell 206B · Cahokia, ILThe instructor was giving a pilot an employment evaluation in the helicopter when during the startup the pilot prematurely added full power causing the helicopter to rotate rapidly to the right. The helicopter had been positioned on a trailer. During the…Mar 10, 1988 · N13Q · Substantial damageNTSB CHI88IA015Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Chicago, ILThe south rwys (32L, 9R, & 4R) were being ctld by the south LCL ctlr (slc) & the north rwys (9L & 4L) were ctld by the north LCL ctlr (nlc). At 1543:26, slc told united flt 973 (Boeing 737) to hold on 32L & expect a 3 min delay bfr tkof. Air Wisconsin flt 954…Oct 29, 1987 · N305UA · 2 aircraft · No damageNTSB CHI87IA183Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Chicago, ILAfter ldg the co B727 was directed to make two right turns and follow an acft that had landed in front of him. The pilot made one right turn and taxied down an empty runway. This taxi route crossed an active runway. An aa#DC-10 on takeoff roll, at 110 knots,…Aug 3, 1987 · N113AA · 2 aircraft · No damageNTSB CHI87IA109Incident · No injuriesIncident investigationFinal reportBoeing 727-222 · Chicago, ILA united airlines Boeing 727 domestic passenger flight was holding short of runway 32L at the Chicago-o'hare international airport awaiting clearance for an intersection takeoff. A northwest airlines Boeing 747 international passenger flight was holding in…Apr 7, 1987 · N7258U · No damageNTSB CHI87DEE05Accident · Serious injuriesFinal reportResney Commander 447 · Lansing, ILThe acft made a forced landing in a field due to fuel starvation. The acc plt offered to fly the acft out. He had 30 min of dual flt in this type acft. He sat on the left side of the acft for the flt which resulted in an unbalanced condition. The acft entered…Mar 8, 1987 · N447MR · Substantial damageNTSB CHI87LA064Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Decatur, ILFollowing taxi to rwy 36, the plt stated that he completed an engine run-up. On the takeoff roll, the acft swerved to the left before colliding with a snowbank approximately 800 feet from the apch end of the rwy. According to the plt, opposite rudder was…Jan 23, 1987 · N2536A · Substantial damageNTSB CHI87LA020Accident · No injuriesLimited investigationFinal reportCessna 310R · Belvidere, ILDuring takeoff roll, the acft door popped open at a point too late to abort the takeoff. The PIC tried to hold the door closed while the second plt flew the acft around the traffic pattern. Just prior to touchdown, the door opened wider and the PIC reached to…Nov 8, 1986 · N6096C · Substantial damageNTSB CHI86FA235Accident · No injuriesField investigationFinal reportFairchild SA-266TC · Galesburg, ILAll landing gear on the aircraft prematurely retracted during takoff rotation. The captain aborted the takeoff and the aircraft slid to a stop on the runway. Subsequent gear retraction tests revealed no mechanical malfunctions within the landing gear system.…Sep 25, 1986 · N327BA · Substantial damageNTSB CHI86LA186Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Mattoon, ILThe glider was being towed for takeoff behind a tow plane. According to the glider instructor, the initial acceleration appeared normal. As the tow plane and the glider neared the end of the runway, the glider instructor believed the tow plane was…Jul 28, 1986 · N65901 · Substantial damageNTSB CHI86MA142Incident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-9-31 · Chicago, ILU.S. Air flight 373 passed over American airlines flight 695 at the intersection of runways 32R and 4L while both aircraft were taking off. Both aircraft had been cleared for takeoff by the local controller at o'hare tower. The aircraft came within twenty…May 17, 1986 · N973VJ · 2 aircraft · Minor damageNTSB CHI86FEE01Accident · Minor injuriesFinal reportCessna 172 · Marseilles, ILThe takeoff was being made from an arpt which is on the grounds of a golf course. During takeoff the nose wheel struck the raised terrain of a golf tee located aprx 75 ft left of the rwy 18 centerline and 1000 ft from the departure end of the rwy. The plt…Mar 23, 1986 · N97266 · Substantial damageNTSB CHI86LA087Accident · No injuriesLimited investigationFinal reportCessna 340A · Wheeling, ILAccording to the plt the left eng lost pwr at rotation. He could then not correct the left ground track deviation with right rudder. To avoid obstacles at the edge of the rwy he pulled the acft off the ground but the acft soon settled back down, sustaining…Feb 16, 1986 · N2743Y · Substantial damageNTSB CHI86LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chicago, ILDuring takeoff roll the aircraft ran off the right side of runway 28. The student pilot operating the controls for this solo flight stated that he did not hold enough left aileron into the wind to compensate for the crosswind he was experiencing. Winds at the…Jan 5, 1986 · N6422Q · Substantial damageNTSB CHI85IA369Incident · No injuriesIncident investigationFinal reportFokker F27-500 · Chicago, ILAt about the time full power was obtained the heard a loud bang followed by a fire warning for the left engine. The takeoff was aborted and the crew shut down the engine. The passengers were deplaned on the taxiway after it was determined the fire was out &…Sep 9, 1985 · N242MA · Minor damageNTSB CHI85LA355Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Ashkum, ILThe left wing of the acft contacted crops during an attempted takeoff. The plt reported liftoff was too soon and the acft veered left contacted crops. The plt stated that he should have stayed on rwy longer.Aug 21, 1985 · N99666 · Substantial damageNTSB CHI85LA353Accident · No injuriesLimited investigationFinal reportCessna 170B · West Chicago, ILDuring application of pwr during a touch-and go landing the acft 'started to get sideways' on the rwy. The plt allowed the acft to drift off the left side of the rwy into the grass. A ground loop subsequently occurred which substantially damaged the acft.…Aug 21, 1985 · N2209D · Substantial damageNTSB CHI85FEE02Accident · Serious injuriesFinal reportBalloon Works Firefly AX-7 · Somonauk, ILThe Balloon collided with powerlines during takeoff. The wind was reported as 10-15 mph with gusts. The operation was canceled due to the wind after 6 successful launches. The last plt was reportedly pressured to go by his pass'g and a gust of wind blew them…Jun 18, 1985 · N40532 · Substantial damageNTSB CHI85IA042Incident · No injuriesIncident investigationFinal reportCessna T210L · Wheeling, ILDuring a preflt, just prior to takeoff, the plt checked the flt controls & full travel of the controls was achieved. He initiated the takeoff, but when he applied back pressure on the elevator control, it would only move about 1 inch. He aborted the takeoff…Nov 3, 1984 · N21YF · Minor damageNTSB CHI85LA030Accident · No injuriesLimited investigationFinal reportMoore Quicksilver MX II · Aurora, ILPlt landed in open field to tighten his scarf, which had become loose and posed a possible hazard. A second ultralight landed to see of the plt had problems, then departed toward the east, successfuly negotiating a 10 kt x-wind. Plt elected to takeoff in same…Oct 28, 1984 · N3998J · DestroyedNTSB CHI84LA387Accident · No injuriesLimited investigationFinal reportMooney M20E · Lansing, ILThe plt had just demonstrated the acft for sale and filed an IFR flt plan. Run up and pre-takeoff checks were rushed to beat void clearance time. Just before liftoff, plt noted sluggish acceleration but believed insufficient runway remained to successfully…Sep 8, 1984 · N10SF · Substantial damageNTSB CHI84IA301Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Chicago, ILThe #2 wheel assembly separated from the acft during takeoff roll. Flt was diverted to atlanta, GA, where an uneventful landing was made. Inspection revealed the axle failure occurred as a result of fatigue crack propagation of numerous prior cracks in the…Jul 16, 1984 · N464DA · Minor damageNTSB CHI84LA182Accident · Minor injuriesLimited investigationFinal reportBeech E18S · Marion, ILThe acft crashed after takeoff from rwy 29 at williamson county airport. The plt stated that she mismanaged the fuel system & that she 'probably tookoff on fumes.' She further stated that she should have told the company 'I'm to tired to make this flt.'May 11, 1984 · N561S · DestroyedNTSB CHI84LA183Accident · No injuriesLimited investigationFinal reportCessna 182N · Minonk, ILThe acft ran off the departure end of the rwy during an aborted takeoff. After the nose gear collapsed the acft nosed over. Investigation revealed that the plt lowered 10 deg of flaps instead of the recommended 20 deg for a soft field takeoff. He used about…May 5, 1984 · N9268G · Substantial damageNTSB CHI84IA093Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-8-61 · Chicago, ILAs the capt applied power & released brakes to begin the takeoff, the acft started to drift to the right. The capt stated that he closed the throttles & put the #1 & #2 throttles in reverse. The acft then began to veer left & spun around nearly 1-1/2 times.…Jan 24, 1984 · N8081U · Minor damageNTSB CHI84LA085Accident · No injuriesLimited investigationFinal reportCessna 140 · Huntley, ILThe student plt allowed the acft to drift left during takeoff in spite of verbal instructions by the CFI to correct the situation. The acft continued toward a snowbank and the CFI did not take corrective action on the controls in time to avoid a collision…Jan 15, 1984 · N76310 · Substantial damageNTSB CHI84LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrisburg, ILThe acft nosed over during takeoff roll while on a solo training flt. The pilot applied too much right rudder then over compensated with left rudder and brake. The acft went off the left side of the rwy into soft mud and nosed over.Oct 14, 1983 · N66937 · Substantial damageNTSB CHI83LA424Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Wheeling, ILThe acft went off the rwy and collapsed the landing gear after power loss during takeoff. Three of the passengers furnished statements and 2 seemed to think that the left engine quit. The acft turned to the right but the pilot did notknow which engine quit.…Sep 12, 1983 · N62971 · Substantial damageNTSB CHI83LA396Accident · No injuriesLimited investigationFinal reportCessna 172 · Princeton, ILThe turf rwy was wet from recent rains. The plt stated that during takeoff, the acft had accelerated to near the rotation speed when it was slowed by a soft spot in the rwy near mid field. At the same point, an upslope portion of the rwy was encountered & the…Aug 28, 1983 · N12862 · Substantial damageNTSB CHI83LA385Accident · No injuriesLimited investigationFinal reportCessna 150 · Savanna, ILThe plt reported the winds were from 160 deg at 7 KTS & that he back taxied on rwy 14 to takeoff. He reported that during the takeoff roll, he encountered a right x-wind, & when he was aprx 2/3 of the way down the rwy, the acft veered to the left. After…Aug 17, 1983 · N11279 · DestroyedNTSB CHI83LA384Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Blue Island, ILAcft ran off side of rwy & the left wing collided with corn stalks causing the acft to spin 180 deg.Aug 15, 1983 · N2527N · Substantial damageNTSB CHI83LA364Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Lansing, ILThe acft had just been given an annual inspection & the plt was on the 1st flt back to the home arpt. He reported that before takeoff, he noted that the eng would not idle below 850 RPM. He elected to continue with the flt. During the takeoff roll, he pulled…Aug 6, 1983 · N53122 · Substantial damageNTSB CHI83FA251Accident · Serious injuriesField investigationFinal reportBoeing 727-222A · Chicago, ILDuring the takeoff roll, the #1 eng failed & the takeoff was aborted at aprx 70 KTS. The aircrew taxied the acft clear of the rwy & stopped on the reverse high speed turnoff. The aircrew of another company acft transmitted that the #1 eng was on fire. There…Jun 11, 1983 · N7273U · Substantial damageNTSB CHI83FA205Accident · Serious injuriesField investigationFinal reportBeech A36 · Minonk, ILThe plt reported that during takeoff from a private farm strip, he had only 70 KTS as he apchd the end of the rwy. By then, there was not enough room to abort & he believed the acft had insufficient airspeed to clear wires along a roadway about 330 ft from…May 9, 1983 · N6039Z · Substantial damageNTSB CHI83FA092Accident · No injuriesField investigationFinal reportObryon Mustang II · West Chicago, ILThe home built acft was on its 1st flt after being constructed. The takeoff was initiated on rwy 33 with the wind from 030 deg at 10 KTS. The plt reported that during the takeoff, the right wing lifted, but the left wing would not come up. When control became…Jan 26, 1983 · N77HJ · Substantial damageNTSB CHI82DA362Accident · No injuriesFinal reportCessna 172 · Park Forest, ILThe pilot stated there was a partial loss of power during the takeoff roll. He reported that there was insufficient runway remaining to stop when the power loss occurred. The available airspeed was used to "hop" over a 3-foot embankment, but the nose gear,…Sep 19, 1982 · N5605J · Substantial damageNTSB CHI82DA316Accident · No injuriesFinal reportBeech G18S · Chicago, ILDuring takeoff on runway 13R, the aircraft swerved to the left just as it obtained tailwheel lift-off speed. The aircraft then struck a dirt bank and was damaged. Both the pilot and the aircraft operator stated that the left main tire lost pressure, but they…Aug 31, 1982 · N38RM · Substantial damage