NTSB investigations, IL
333 cases where the phase of flight was Maneuvering.
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 = 450)
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 = 450)
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 CHI01FA165Accident · Serious injuriesField investigationFinal reportVanderBeek Christen Eagle II · Plainfield, ILthe improper in-flight planning/decision and the aircraft control not maintained by the pilot. The thunderstorm outflow was a contributing factor.NTSB CHI01LA125Accident · No injuriesLimited investigationFinal reportPiper J5A · Brussels, ILthe partial loss of engine power for undetermined reasons and the high vegitation encountered during the precautionary landing.NTSB CHI01LA135Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Warsaw, ILthe rocker assembly failure during low level maneuvering. Factors were the soft and sandy terrain and the unsuitable terrain the pilot encountered during the forced landing.NTSB CHI01LA119Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Du Quoin, ILloss of engine power for undetermined reasons, the pilot operating the helicopter outside of the height-velocity curve, and the pilot's failure to maintain control of the helicopter during the emergency landing. Factors relating to the accident were the…NTSB CHI00FA186Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Capron, ILThe pilot attempting an aerobatic maneuver at a low altitude and the pilot not maintaining clearance from the terrain. A factor to the accident was the pilot disregarding the federal aviation regulations concerning the minimum altitudes required for aerobatic…NTSB CHI00FA110Accident · Minor injuriesField investigationFinal reportHughes 369D · Lemont, ILthe loss of engine power for undetermined reasons. A factor was the operation within the cross "hatched area" of the helicopter's height/velocity curve by the company.NTSB CHI00LA093Accident · Serious injuriesLimited investigationFinal reportLockwood Eagle II · Marengo, ILThe pilot's failure to maintain aircraft control.NTSB CHI00FA003Accident · 1 fatalField investigationFinal reportBeech D-45 · Oswego, ILthe visual lookout not obtained by the pilot of the Beech T-34 and the inadequate procedure by the Lima Lima Flying Squadron. The delayed entry into the maneuver by the pilot of the Beech D-45 was a contributing factor.NTSB CHI99FA342Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Warrensburg, ILAircraft control not being maintained by the private pilot candidate and the inadequate supervision by the FAA Designated Examiner. Factors relating to the accident were the inadvertent spin, the unsuccessful remedial action attempted by the flightcrew, and…NTSB CHI99FA120Accident · No injuriesField investigationFinal reportExtra Flugzeugbau 300S · Dow, ILa fatigue failure of the upper left longeron and adjacent diagonal cross member near the horizontal stabilizer attach point. A factor related to the accident was that the manufacturer informed the operator that they were already in compliance with the latest…NTSB CHI98LA192Accident · No injuriesLimited investigationFinal reportGrumman G164 · Somonauk, ILthe pilot's misjudgment of distance. Factors were wind gusts and crops.NTSB CHI98FA172Accident · 1 fatalField investigationFinal reportPiper J-3C · Morris, ILThe pilot's failure to maintain aircraft control during low altitude flight.NTSB CHI98FA159Accident · 4 fatalField investigationFinal reportBell 206L-1 · Arlington Hgts, ILLoss of helicopter control for unknown reasons.NTSB CHI98LA121Accident · Serious injuriesLimited investigationFinal reportExtra Flugzeugbau EA-300 · Chenoa, ILthe pilot experienced GLOC (G induced loss of consciousness) while performing an aerobatic maneuver. Fatigue was a factor.NTSB CHI98FA070Accident · 4 fatalField investigationFinal reportPiper PA-32-301 · Hampshire, ILthe pilot's intentional flight into known icing conditions, and the accumulation of ice on the leading edges of the airplane's empennage and wings leading to the inadvertent stall/mush. A factor contributing to this accident was the icing conditions.NTSB CHI98LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Robinson, ILthe pilot's improper decision to continue flight into adverse weather conditions The low ceiling and the heavy rain were factors.NTSB CHI98GA025Accident · 2 fatalFinal reportAerospatiale AS350B · Frankfort, ILthe pilot in command misjudged the clearance with the terrain during a dark night maneuvering approach to a runway. A related factor was the dark night conditions.NTSB CHI97FA293Accident · 2 fatalField investigationFinal reportKeaggy-David Skybolt · Adeline, ILThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB CHI97LA287Accident · Serious injuriesLimited investigationFinal reportHiggens Rans S-12 XL · Tuscola, ILthe pilot's failure to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall.NTSB CHI97LA211Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Springfield, ILfailure of the pilot to maintain safe altitude/clearance from the terrain. Factors relating to this accident were: the hazy weather condition, the resultant difficulty in keeping the other airplane in sight, and the pilot's diverted attention, while looking…NTSB CHI97LA199Accident · No injuriesLimited investigationFinal reportSnow S2C · Viola, ILthe pilot's inadequate preflight planning/preparation by failing to ensure there was an inadequate supply of fuel for the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Uneven terrain in the emergency landing area was a…NTSB CHI97LA150Accident · Serious injuriesLimited investigationFinal reportGrumman G164 · Illinois City, ILfailure of the pilot to see and maintain clearance from a static wire. The proximity of the wire was a related factor.NTSB CHI97LA077Accident · No injuriesLimited investigationFinal reportBeech A36 · Matherville, ILa loss of engine as a result of the pilot-in-command's improper positioning of the fuel tank selector. A factor was the rough terrain.NTSB CHI97FA025Accident · 3 fatalField investigationFinal reportEnstrom F28F · Gutherie, ILthe pilot's inadequate preflight preparation and not maintaining control of the helicopter during its rearward flight. A factor was the pilot's over-confidence in his personal ability.NTSB CHI96LA312Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Urbana, ILthe pilot's failure to maintain airspeed. A factor was the diverted attention of the pilot.NTSB CHI96LA310Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Galesburg, ILfailure of the pilot to maintain clearance from trees that protruded into the field that he was spraying.NTSB CHI96FA237Accident · 1 fatalField investigationFinal reportPiper PA-12 · Roselle, ILthe pilot's improper decision to perform a go-around, while there was restricted rudder movement and the banner was still attached to the airplane, which resulted in a loss of airspeed and an inadvertent stall. Factors relating to the accident were: the…NTSB CHI96LA188Accident · 1 fatalLimited investigationFinal reportGray Miniplane DSA-1-G · Astoria, ILthe pilot's failure to maintain clearance with the terrain while performing an aerobatic maneuver.NTSB CHI96FA005Accident · 1 fatalField investigationFinal reportBlatter-Pitts S2S · Waukegan, ILthe pilot's failure to maintain airplane control during the aerobatic maneuver. Factors associated with the accident were: an improper weight and balance with a center of gravity aft of the rear limit, the pilot's overconfidence in his personal ability, and…NTSB CHI95FA191Accident · 1 fatalField investigationFinal reportChampion 8KCAB · Frankfort, ILthe pilot-in-command's overconfidence in his personal ability in attempting to teach aerobatics, his lack of experience as a flight instructor, and allowing the airplane to get into a position where its never exceed speed and design stress limits were…NTSB CHI95FA123Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Schaumburg, ILThe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his attempt to perform an apparent aerobatic maneuver at an altitude that was insufficient to assure recovery.NTSB CHI94LA314Accident · No injuriesLimited investigationFinal reportCessna 188B · Oakdale, ILmisalignment of the number one connecting rod during major overhaul. Factors were the subsequent scoring and fatigue failure of the crankshaft.NTSB CHI94LA292Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Clifton, ILthe pilots failure to keep visual contact with and to avoid unmarked powerlines adjacent to the crop field he was spraying.NTSB CHI94LA189Accident · 1 fatalLimited investigationFinal reportWaco UPF-7 · Good Hope, ILFailure of the pilot to maintain control of the aircraft, while maneuvering. A factor related to the accident was: the pilot's impairment due to use of a prescription drug that was not approved for use while flying.NTSB CHI94LA161Accident · No injuriesLimited investigationFinal reportBell 206B · Winnebago, ILa wire strike due to failure to maintain proper altitude, and improper visual lookout by the pilot-in-command.NTSB CHI94FA140Accident · 1 fatalField investigationFinal reportVavra, Martin A. Rebel 300 · Wonderlake, ILFatigue and catastrophic failure of the main wing spar resulting from the designer's excessive, unverified estimate of the strength of the spar cap material and the manufacturer's failure to attain the specified strength during the production process.NTSB CHI93LA347Accident · 1 fatalLimited investigationFinal reportWells Pitts S-2-S · Bloomington, ILthe pilot in command continued the aerobatic maneuver too long to effect a safe level off.NTSB CHI93DEE05Accident · Serious injuriesFinal reportWeatherly 620 · Mendota, ILThe pilot-in-command's failure to maintain clearance fom powerlines during an aerial application manuever.NTSB CHI93DEE03Accident · Serious injuriesFinal reportMaxair MU532 · Fox Lake, ILthe failure of the pilot to maintain the necessary altitude above the terrain.NTSB CHI93FA238Accident · 3 fatalField investigationFinal reportBeech 58 · Beardstown, ILthe pilot-in-command's continued VFR flight into IMC and his failure to maintain control of the airplane. Factors were the fog, drizzle, and an abrupt maneuver by the pilot-in-command.NTSB CHI92LA154Accident · 1 fatalLimited investigationFinal reportCessna 150H · Robinson, ILPoor judgement by the pilot in intentionally proceeding to the airport in instrument meteorological conditions. The weather conditions were a factor.NTSB CHI92DEV01Accident · Serious injuriesFinal reportQuickie Quickie 1 · Carmi, ILAn engine bearing seizure and a premature forced landing flare.NTSB CHI91LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Freeburg, ILImproper use of the mixture control by the pic/cfi. A factor related to the accident was inadequate friction on the mixture control lever.NTSB CHI91LA233Accident · 1 fatalLimited investigationFinal reportCessna 172P · Lansing, ILThe pilot's inadvertent stall/spin during low altitude maneuvers. Related factors are ground personnel's inadequate traffic advisory, and the pilot's abrupt pull up.NTSB CHI91LA205Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Savoy, ILThe pilot's failure to maintain tail rotor clearance from the ground. A related factor is the pilot's lack of total experience in helicopters.NTSB CHI91DEE06Accident · No injuriesFinal reportRobinson R22B · Mineral, ILFailure of the pilot to maintain clearance from the power line.NTSB CHI91LA154Accident · No injuriesLimited investigationFinal reportEnstrom F28 · Hampshire, ILAircraft control was not maintained when the aircraft encountered an uncotrolled descent by the pilot. Remedial action by the pilot was inadequate. A factor related to the acident was lack of total experience in type of aircraft by the pilot.NTSB CHI91IA120Incident · No injuriesIncident investigationFinal reportCessna 172RG · West Chicago, ILFailure of the splined shaft on the right main landing gear pivot assembly. A factor related to the incident was inadequate design of the landing gear pivot assembly.NTSB CHI91DEE03Accident · Minor injuriesFinal reportAir Command Gyrocopter · Lansing, ILThe pilot's delayed pullup. A factor in the accident was the pilot's exessive rate of descent during the spiral maneuver.NTSB CHI91DEE01Accident · 1 fatalFinal reportPitts Special S1-S · Dekalb, ILThe pilot's attempt to perform aerobatic maneuvers at low altitude.