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.
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" 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 CHI01LA302Accident · No injuriesLimited investigationFinal reportSwearingen SA226-T · West Chicago, ILthe checklist not followed and the directional control not maintained by the pilot. A contributing factor was the left propeller’s start locks being engaged.NTSB CHI01LA199Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Albion, ILthe maintenance performed on the airplane by the unqualified pilot The unsuitable takeoff area selected by the pilot was an additional cause. The ditch was a contributing factor.NTSB CHI01LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Mattoon, ILthe pilot's failure to maintain directional control. Factors were the crosswind, the pilots lack of total experience, and the snow covered terrain adjacent to the runway.NTSB CHI01LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincoln, ILThe pilot's failure to maintain directional control on the runway. Factors relating to this accident were the aborted takeoff attempt, the pilot's improper in-flight planning/decision, and the snowbank.NTSB CHI01LA021Accident · No injuriesLimited investigationFinal reportBeech A36 · Quincy, ILthe evasive maneuver not possible by the pilot and the deer on the runway. A factor was the dark night.NTSB CHI00IA248Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42-2000 · Chicago, ILthe improper takeoff clearance issued by the local controller.NTSB CHI00LA203Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Streator, ILthe pilot's preflight planning was inadequate which resulted in taking off in the wrong direction on the runway. Factors associated with the accident were the tailwind condition and the crop that the airplane contacted.NTSB CHI00IA125Incident · No injuriesIncident investigationFinal reportBoeing 777-223ER · Chicago, ILthe flightcrew not detecting the runway closure NOTAM and the Air Traffic Control personnel on the metering, ground, and local positions giving an improper clearance to taxi to a closed runway. Factors were the closed runway, ATIS information not issued by…NTSB CHI00FA027Accident · 3 fatalField investigationFinal reportBeech 200 · Chicago, ILOn ground collision with the lake for undetermined reasons.NTSB CHI00IA009Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-51 · Chicago, ILThe landing gear's wheel separation due to the improper installation of the wheel by company maintenance personnel using incomplete maintenance steps, and the maintenance steps not listed in the manufacturer's manual. Factors were the airport perimeter wall…NTSB CHI99IA351Incident · No injuriesIncident investigationFinal reportCessna 402B · Chicago, ILThe failure of the pilot in command to maintain clearance with ground obstructions.NTSB CHI99LA330Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Sparta, ILThe pilot's decision not to use all of the available. A factor to the accident was the ditch.NTSB CHI99LA279Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Schaumburg, ILthe CFI's delay in taking remedial action to maintain directional control of the airplane. A factor associated with the accident was the student's improper use of the brakes.NTSB CHI99LA087Accident · No injuriesLimited investigationFinal reportSocata TB 9 Tampico · Cahokia, ILthe pilot's improper decision to initiate the takeoff with insufficient runway remaining. A factor associated with the accident was pilot's failure to obtain clarification from the controller regarding the clearance.NTSB CHI98LA335Accident · No injuriesLimited investigationFinal reportCessna 172 · Harrisburg, ILthe loss of engine power for undetermined reasons.NTSB CHI98FA296Accident · 1 fatalField investigationFinal reportCessna 340A · Chicago, ILthe pilot's improper use of the throttle in not using full power for takeoff, the pilot's failure to use proper aborted takeoff procedures, and the inadvertant stall/mush. A factor associated with the accident was inadequate preflight/planning by the pilot.NTSB CHI98LA221Accident · No injuriesLimited investigationFinal reportCessna T310R · Wheeling, ILthe pilot's inadequate compensation for the wind conditions which resulted in a lack of directional control of the aircraft. Factors to the accident were the two airport signs and the crosswind.NTSB CHI98LA063Accident · No injuriesLimited investigationFinal reportBeech 1900C · Rockford, ILimproper installation of aileron cables by the maintenance personnel, inadequate inspection by the company's maintenance personnel of maintenance performed, and inadequate preflight by the pilot.NTSB CHI97LA185Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Manito, ILloss of engine power for undetermined reason(s).NTSB CHI97IA117Incident · Minor injuriesIncident investigationFinal reportBoeing 737-200 · Chicago, ILinadequate nickel plating was applied to the compressor disk during the rework process at the operator's overhaul facility, which resulted in a brittle fracture in the disk and an uncontained engine failure. A factor was the operator's lack of written…NTSB CHI97LA104Accident · No injuriesLimited investigationFinal reportCessna 177 · Harrisburg, ILthe loss of engine power followed by an engine fire for reason or reasons undetermined.NTSB CHI97MA017Accident · 4 fatalMajor investigationFinal reportGulfstream G-IV · Wheeling, ILfailure of the pilot-in-command (PIC) to maintain directional control of the airplane during the takeoff roll in a gusty crosswind, his failure to abort the takeoff, and failure of the copilot to adequately monitor and/or take sufficient remedial action to…NTSB CHI96TA260Accident · No injuriesFinal reportSchweizer SGS 2-33AK · Mattoon, ILthe pilot's failure to maintain directional control of the glider. Factors were the runway sign and the failure of the pilot to maintain a visual lookout.NTSB CHI95LA318Accident · Minor injuriesLimited investigationFinal reportMaule M-5 · Belvidere, ILinadequate visual lookout by the pilots of both airplanes, which resulted in failure of each pilot to see-and-avoid the other airplane.NTSB CHI95LA280Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Champaign, ILthe pilot's failure to maintain directional control of the airplane during takeoff.NTSB CHI95LA256Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Naperville, ILThe pilot's failure to maintain directional control during the takeoff roll. Contributing factors were the pilot's lack or recent experience in tailwheel equipped aircraft and failure to abort the takeoff early enough to prevent the accident.NTSB CHI95LA218Accident · No injuriesLimited investigationFinal reportBeech C24R · Freeport, ILthe pilot's failure to maintain control of the airplane during the aborted takeoff.NTSB CHI95LA203Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Hampshire, ILthe pilot's failure to attain liftoff speed. A factor in the accident was the ditch.NTSB CHI95IA142Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC10-10 · Chicago, ILfailure of the safety wire and/or safety wire lug arm on one of the stage one to two disk flange bolts due to an inadequate safetying method.NTSB CHI94LA264Accident · No injuriesLimited investigationFinal reportBeech D17R · Sandwich, ILthe failure of the pilot to lower the landing gear. Factors related to the accident were the loss of engine rpm, for undetermined reasons, and the diverted attention of the pilot.NTSB CHI94LA247Accident · No injuriesLimited investigationFinal reportCessna 182 · Greenwood, ILthe pilot-in-command's (CFI) inadequate aircraft preflight inspection and improper aborted takeoff. Related factors are the blocked pitot/static system, and the CFI's inadequate supervision during the preflight and takeoff.NTSB CHI94LA175Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Toulon, ILthe improper reassembly of the main rotor blade dampers and the underservicing of the landing gear skid hydraulic struts which resulted in ground resonance of the helicopter when the first takeoff after reassembly was attempted.NTSB CHI94LA160Accident · No injuriesLimited investigationFinal reportCessna 175 · Plainfield, ILfuel contamination (water), and inadequate aircraft preflight inspection.NTSB CHI94LA151Accident · No injuriesLimited investigationFinal reportAeronca 11 AC · Carmi, ILpoor preflight planning/preparation. Factors associated with the accident were the high vegetation (grass) and the ditch.NTSB CHI94LA061Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Dekalb, ILwas an aborted takeoff not performed by the pilot-in-command. Factors related to the accident were the partial power loss for undetermined reasons and the continued operation of the airplane with a deficiency.NTSB CHI93LA353Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 Twin Astir · New Douglas, ILFailure of the glider tow attachment. Factors related to the accident were the improper emergency procedure by the student, and the flight instructor's delayed remedial action..NTSB CHI93LA233Accident · Minor injuriesLimited investigationFinal reportBeech E35 · Virgil, ILThe pilot's failure to abort takeoff.NTSB CHI93LA211Accident · No injuriesLimited investigationFinal reportMonnett Sonerai IIL · De Kalb, ILThe pilot in command's inability to maintain directional control due to inadequate compensation for wind conditions.NTSB CHI93IA069Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-311 · Savoy, ILThe total failure of the inboard right main landing gear wheel axle during the initial climb.NTSB CHI92LA248Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lincoln, ILA premature liftoff and failure to maintain directional control during a takeoff ground run by the pilot in command. A delay in taking remedial action by the designated pilot examiner is an additional cause.NTSB CHI92LA187Accident · No injuriesLimited investigationFinal reportBeech M35 · Dekalb, ILThe pilot's failure to use proper nose wheel steering which resulted in a loss of directional control.NTSB CHI92LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Rockford, ILThe flight instructor's premature liftoff. Related factors are the instructor's lack of total experience in the accident make and model airplane, and the unsuitable terrain encountered during the roll-out.NTSB CHI92IA061Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-30 · Chicago, ILThe local controller's not understanding read back of radio communications. Factors include the pilot-in-command of flight 73 not understanding verbal instructions; local controller not visually identifying the aircraft; and inadequate surveillance (FAA) in…NTSB CHI91LA261Accident · No injuriesLimited investigationFinal reportPiper PA-32-R300 · Lake In Hills, ILThe pilot's failure to perform an adequate preflight by assuring the gear lever was in the down and locked position.NTSB CHI91LA201Accident · No injuriesLimited investigationFinal reportPiper PA-28-201R · Wheeling, ILThe pilot in command's inadequate pre-flight inspection. Factors contributing to this accident were the landing gear lever not being engaged, the use of an inadequate procedure by the pilot-in-command, and the inadvertent gear retraction during takeoff roll.NTSB CHI91LA194Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Mundelein, ILThe pilot in command's not maintaining visual contact with the previously identified airplane.NTSB CHI91DEE05Accident · Minor injuriesFinal reportCharles Raucci, JR. Firebolt · Schaumburg, ILThe pilot not following the specification for installation of the fuel tank vent.NTSB CHI91DEV01Accident · No injuriesFinal reportCessna A188B · Bluffs, ILThe pilot's failure to maintain directional control.NTSB CHI91LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Wonder Lake, ILFailure of the student pilot to maintain directional control during takeoff. Her lack of flying expereince was a related factor.NTSB CHI91LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Newark, ILThe pilot in command's poor preflight planning and improper weather evaluation.