NTSB investigations, IL

901 cases where the phase of flight was Enroute.

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 = 400)
  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 CHI84LA222Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Kankakee, ILAfter departing the arpt, the plt elected to practice emergency procedures. He shut down & feathered the left eng about 4 mi south of the arpt at 4000 ft MSL. He then tried to restart the eng, but reported that the battery did not have enough pwr to turn the…Jun 4, 1984 · N1700W · Substantial damageNTSB CHI84FA194Accident · Minor injuriesField investigationFinal reportBeech A36 · Schaumburg, ILThe plt reported that he lost partial engine power during climb and decided to return to the arpt. He said the engine changed power output when he used the electric fuel pump but he left it off. During final approach, not having declared an emergency, he had…May 15, 1984 · N9451Q · Substantial damageNTSB ATL84IA160Incident · No injuriesIncident investigationFinal reportDouglas DC-9-32 · Mount Vernon, ILKansas city ARTCC (zkc) had cleared ozark flt 709 (a DC-9, N923L) to cruise at FL270. While proceeding ese near the edgeof the zkc area, the DC-9 converged on zorro 11 (a flt of 3 F-4'S). The F-4'S had been cleared by indianaplolis ARTCC (zid) to proceed…May 4, 1984 · N923L · No damageNTSB DCA84AA002Accident · 10 fatalFinal reportHawker Siddeley HS-748-2A · Pinckneyville, ILAbout 1.5 min after departing springfield, IL, the fltcrew reported a slight electrical problem, but they continued on course. About 33 min later & a few min before the acft should have reached its destination, the acft crashed. Impact occurred while the acft…Oct 12, 1983 · N748LL · DestroyedNTSB CHI83FA441Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Bethany, ILPrior to this flt, the plt had contacted a fss & inquired about the wx. He was advised that VFR flt to terre haute, IN, was not recommended. He took off at about 1830 CDT. The plt again contacted the fss & inquired about the wx at burlington, IA &…Sep 26, 1983 · N8236U · DestroyedNTSB CHI83FA440Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Raymond, ILDuring a wx briefing at 1433 CDT, the plt was advised to expect 500 ft ceilings, 2 mi visibilities, rain showers & thunderstorms. He then took off from bismark, MO with no flt plan. Reportedly, wx was encountered during the flt which deteriorated as he…Sep 25, 1983 · N3184 · DestroyedNTSB CHI83LA430Accident · No injuriesLimited investigationFinal reportCessna U206F · Garden Prairie, ILWhile en route, the fuel pressure dropped, and subsequently, the eng lost power completely. During a landing in a corn field, the acft was damaged. An investigation revealed that the fuel line had separated at the flow divider. Reportedly, the eng had been…Sep 18, 1983 · N8449Q · Substantial damageNTSB CHI83FA428Accident · Minor injuriesField investigationFinal reportSikorsky S-76A · Chicago, ILWhile cruising at 2000 ft MSL & 150 KTS, the crew heard a loud noise, and simultaneously, the helicopter yawed aprx 30 to 40 deg to the right & pitched nose down. The aircrew began an autorotation & activated the emergency floats. The helicopter continued in…Sep 14, 1983 · N521AC · DestroyedNTSB CHI83LA415Accident · No injuriesLimited investigationFinal reportCessna 150G · Paris, ILThe student plt was on his 1st solo x-country flt. On the 1st leg of the flt, he became disoriented, experienced fuel exhaustion & landed in a soybean field. During the landing, the acft nosed over when the gear encountered the tall beans. The student…Sep 5, 1983 · N6227S · Substantial damageNTSB CHI83LA398Accident · No injuriesLimited investigationFinal reportStewart Headwind · New Douglas, ILDuring flt, the eng lost power & the plt was unable to get a restart. While making a forced landing in a plowed field, the main gear collapsed & the acft nosed over. Later, after the acft was uprighted, the eng was started & was operated to 1300 RPM. Prop…Aug 30, 1983 · N64MF · Substantial damageNTSB CHI83FU009Accident · 1 fatalFinal reportWeedhopper B · St. Joseph, ILThe ultralight vehicle collided with the ground after the left wing folded up at about 1000 ft AGL. Witnesses said the ultralight was traveling east when the wing collapsed or folded back. Reportedly, it pitched up & the right wing tip went up. The vehicle…Aug 21, 1983 · UNREG · DestroyedNTSB CHI83LA375Accident · No injuriesLimited investigationFinal reportQuickie Q2 · Decatur, ILThe acft made a hard landing and broke the front canard after bouncing on touchdown and dragging the left wing. The pilot had been informed by the tower that black smoke was coming out of the engine. This turned out to be from an excessively rich mixture. The…Aug 9, 1983 · N7QA · Substantial damageNTSB CHI83LA374Accident · No injuriesLimited investigationFinal reportCessna 150 · Springfield, ILThe acft made a forced landing in a corn field and nosed down after the engine stopped during flt. During pre-flt the pilot had looked in the tanks and measured the amount of fuel with the tie cap chain. He thought he had enough fuel for the flt even though…Aug 9, 1983 · N3400V · Substantial damageNTSB CHI83FA334Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Dwight, ILThe acft crashed in a corn field during a heavy rainstorm while on a cross country flight. The pilot had logged 4 hour of simulated instrument time and was not instrument rated.Aug 4, 1983 · N2876X · DestroyedNTSB CHI83LA308Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Chandlerville, ILThe acft made a forced landing after losing power at 1500 ft the pilot said the engine ran rough, oil pressure went to zero and the engine stopped. This pilot had been forced to land the same acft 3 days earlier when the engine lost power during takeoff.…Jul 10, 1983 · N6952J · Substantial damageNTSB CHI83LA292Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Wheeler, ILThe plt reported that while he was returning for another load of chemicals, the eng missed a couple of times, then smoothed out for about 1 min. After that, the eng missed again, then quit while the helicopter was at aprx 150 ft AGL. The plt chose to clear…Jul 5, 1983 · N7069J · Substantial damageNTSB CHI83FA213Accident · 1 fatalField investigationFinal reportMooney M-20-J-201 · Bloomington, ILPrior to the accident, a witness heard the acft, then saw it for a short time thru an opening in the clouds. In his opinion, it was heading directly into a thunderstorm, which concerned him. He said that rain was falling, and about 10 min later, the…May 13, 1983 · N201GG · DestroyedNTSB CHI83LA186Accident · No injuriesLimited investigationFinal reportAerosport Scamp · Edwardsville, ILThe plt was on a test flt in a homebuilt acft with only 3.7 hrs total flt time. While in a full power climb from 1000 to 2000 ft AGL, he noticed black smoke coming from the left exhaust stacks. The power was reduced to a cruise setting, and reportedly, there…Apr 24, 1983 · N15RV · Substantial damageNTSB CHI83FA161Accident · 2 fatalField investigationFinal reportCessna 182 · Coulterville, ILDuring a wx briefing before takeoff, the non-instrument rated plt was advised that VFR flt was not recommended. However, he departed sheboygan, WI at aprx 1500 CST with no flt plan. At dusk, witnesses (near the crash site) heard the acft maneuvering. One…Apr 9, 1983 · N92734 · DestroyedNTSB CHI83FA135Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Danvers, ILThe aircraft crashed at night during IMC weather conditions on the return portion of a cross-country. The pilot had checked the weather outbound, but there was no record of a briefing for the return flight. The outbound flt was in early dusk. The return was…Mar 13, 1983 · N82026 · DestroyedNTSB CHI83LA121Accident · No injuriesLimited investigationFinal reportCessna 172 · Galesburg, ILThe plt stated that during cruise, the engine started to run rough. He applied carburetor heat & initiated emergency procedure, and then engine power was restored. However, a short time later, power was lost again. During a forced landing in an open field,…Feb 25, 1983 · N738HH · Substantial damageNTSB CHI83LA095Accident · No injuriesLimited investigationFinal reportCessna 140 · Richview, ILThe acft collised with a ditch and nosed over during a forced landing after the engine stopped in cruise flt. The pilot said he checked the carburetor heat on the ground but did not use it in the air. After the landing the engine was inspected and no…Jan 29, 1983 · N2377V · Substantial damageNTSB CHI83FA089Accident · No injuriesField investigationFinal reportCessna 172 · Rockford, ILThe acft collided into the 2nd floor of a building while making an ILS approach to runway 36 at Rockford, IL. The weather was IMC. An IFR flight plan was filed. A pilot weather briefing was not given. The pilot was instrument rated. An approach was attempted…Jan 24, 1983 · N61558 · DestroyedNTSB CHI83LA084Accident · No injuriesLimited investigationFinal reportCessna 182 · Wheaton, ILWhile in cruise flight at 2500' AGL the carburetor ice warning light came on. The pilot applied carburetor heat and the light went out. After the light went out the pilot returned the heat to 'off.' The pilot repeated the above sequence and when the light…Jan 16, 1983 · N3318F · Substantial damageNTSB CHI83LA078Accident · No injuriesLimited investigationFinal reportMooney M20A · Ashkum, ILThe pilot made a precautionary landing in a plowed field during a ferry flight because of lowering ceiling and darkness,during the landing the gear collapsed from overload. The pilot was delayed in his departure for maintenance and service. Increasing clouds…Jan 9, 1983 · N8343E · Substantial damageNTSB CHI83LA025Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lansing, ILThe acft had a complete electrical failure & the plt made an emergency landing at Lansing. The plt was unable to lower the flap, & after encountering ground fog landed long, bounced, & ground looped to avoid running off the end of the rwy. Invest of the elect…Oct 25, 1982 · N23388 · Substantial damageNTSB CHI83FA022Accident · 1 fatalField investigationFinal reportCessna R182 · Lemont, ILThe pilot took off at 0642 CDT, and at 0645, he reported level at 4000 ft MSL. At 0659:08, he preported that he was encountering icing conditions and requested a climb to 6000 ft. at 0700:16, after changing from TRACON to center frequency, he was cleared as…Oct 20, 1982 · N736NA · DestroyedNTSB CHI83LA010Accident · No injuriesLimited investigationFinal reportBenson B8M · Sandwich, ILThe aircraft was being flown by a person with no pilot rating and no student or medical certificate. After takeoff, he circled the airport and flew over the edge of a lake. Reportedly, the engine suddenly lost power while he was about 300 ft above the…Oct 5, 1982 · N26063 · DestroyedNTSB CHI82DA367Accident · No injuriesFinal reportCessna 207 · Bedford Park, ILPilot made forced landing at night in railroad yard. Engine had loose fuel line.Sep 27, 1982 · N1728U · Substantial damageNTSB CHI82DA356Accident · Minor injuriesFinal reportCessna 172M · Brimfield, ILThe pilot reported that about 30 minutes after takeoff, a partial loss of power was experienced and was accompanied by the sounds of metal-to-metal contact. He headed toward an airport about 12 miles away, but shortly thereafter, total engine failure…Sep 18, 1982 · N9871Q · Substantial damageNTSB CHI82DA343Accident · No injuriesFinal reportCessna 310A · Wheeling, ILThe pilot could not get the gear down green light to come on. Several checks made including a fly-by and a advisory that the gear appeared down. During the landing roll the right gear collapsed. Examination of the landing gear system revealed a bent righthand…Sep 4, 1982 · N301DG · Substantial damageNTSB CHI82DA315Accident · No injuriesFinal reportPiper PA-38 · New Haven, ILThe pilot reported that before departing on a routine pipe line patrol, he obtained a weather briefing. After about 30 minutes of flight, the visibility began to decrease due to ground fog. The pilot elected to land on a gravel road. During the landing roll,…Jul 30, 1982 · N25814 · Substantial damageNTSB CHI82DA280Accident · Minor injuriesFinal reportSIAI Marchetti S.205-22/R · Carrollton, ILThe aircraft engine failed inflight and during the forced landing on a road the aircraft collided with posts. An investigation showed that a #4 connecting rodcap attaching bolt had failed.Jul 29, 1982 · N956W · Substantial damageNTSB CHI82FA266Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Hartsburg, ILAt 1223 CDT the plt contacted peoria approach control & requested radar vectors to the Mt. Hawley arpt located just northof the peoria arpt. At 1227 CDT he stated the weather was getting bad & he would like to fly to the logan county arpt. One witness stated…Jul 22, 1982 · N7304W · DestroyedNTSB CHI82DA235Accident · Minor injuriesFinal reportGrumman American AA-1C · Danville, ILThe student pilot stated that at 3000 ft, 14 NM north of the Danville VOR, the engine began vibrating. The engine lost power and the pilot was forced to land in a bean field approximately 4 miles north of the Danville airport. Engine examination revealed the…Jul 5, 1982 · N9830U · DestroyedNTSB CHI82DA237Accident · No injuriesFinal reportWaco UPF-7 · Popular Grove, ILThe pilot experienced severe engine vibration during cruise flight. The pilot performed an emergency landing in a field. Because of the length of the field the pilot landed hard and the left main gear collapsed. The separated gear struck and fractured the…Jul 4, 1982 · N39714 · Substantial damageNTSB CHI82DA185Accident · No injuriesFinal reportHughes 369D · Fairbury, ILDuring flight, the N2 and nr suddenly accelerated to 110 percent. The pilot eventually shut down the engine and made an autorotation. An open field was selected for a landing site; however, it was muddy with standing water. The pilot decided on a full stop…May 26, 1982 · N8348F · Substantial damageNTSB CHI82DA180Accident · No injuriesFinal reportPiper PA-28 · Harrisburg, ILDuring a weather briefing, the pilot was advised that there were thunderstorms in the area of his destination at about 1415 CDT, he departed for a two hour flight. After flying over weather most of the way and overflying an airport (hulman regional), he…May 21, 1982 · N2314F · Substantial damageNTSB CHI82DA171Accident · Minor injuriesFinal reportBell 47G-5 · Sublette, ILPrior to this flight, the helicopter had been flown about 1 hr from roselle to Sublette, IL, then it was flown another 1/2 hr to survey the area to be sprayed. About 10 minutes after departing to spray, the engine lost power. The pilot started an autorotative…May 17, 1982 · N7841S · Substantial damageNTSB CHI82FA168Accident · Serious injuriesField investigationFinal reportPiper PA-22 · Joilet, ILWhen the aircraft was about 1 1/2 miles from the destination, a fire started on the left side of the floorboard against the firewall. The pilot turned off the electrical system, and before landing, shut off the fuel selector. After landing, the occupants…May 16, 1982 · N3723Z · DestroyedNTSB CHI82DA101Accident · Minor injuriesFinal reportCessna 150 · West Chicago, ILThe student and an instructor had previously flown this aircraft to recertify the student for solo flight. After the dual flight, the student had some problem with obtaining fuel and took off without refueling. While flying at night, the student became lost.…Mar 25, 1982 · N9239U · Substantial damageNTSB CHI82DA097Accident · No injuriesFinal reportCessna 150 · Wheeling, ILThe student pilot departed Wheeling, IL on a cross-country flight to dubuque, IA; oshkosh, WI and return. The pilot refueled with 17.7 gallons of 100 octane low-lead gasoline at dubuque, but did not refuel at oshkosh. Near milwaukee, he noted that the right…Mar 24, 1982 · N714KR · Substantial damageNTSB CHI82DA046Accident · Minor injuriesFinal reportCessna 150 · Altamont, ILAbout five to ten minutes after takeoff at night, the engine began to lose power and then suddenly stopped. Pilot elected to land in a light colored area that was surrounded by darker areas. During the approach, the aircraft struck a tree which damaged the…Feb 14, 1982 · N9447U · Substantial damageNTSB CHI82IA026Incident · No injuriesIncident investigationFinal reportLockheed L-1011 · Chicago, ILThe aircraft had departed boston on a scheduled flight with the #1 generator placarded inoperative and noted in the minimum equipment list. En route to los angeles, CA at FL 350, about 80 mi northeast of bay city, MN., the crew noted a simultaneous loss of #2…Jan 13, 1982 · N31031 · No damageNTSB CHI81FEE08Accident · No injuriesClosedPiper PA-28 · Rochelle, ILDec 15, 1981 · N5395T · Substantial damageNTSB CHI82FEE07Accident · No injuriesClosedCessna 172N · Kankakee, ILNov 27, 1981 · N5605J · Substantial damageNTSB CHI82FEE06Accident · No injuriesClosedCessna 172RG · Fox Lake, ILNov 15, 1981 · N5359R · Substantial damageNTSB CHI82DEV03Accident · No injuriesClosedBeech B19 · Savoy, ILOct 23, 1981 · N5112R · Substantial damageNTSB CHI82FA006Incident · Minor injuriesClosedShorts SD3-30 · Dixon, ILOct 18, 1981 · N331MV · Minor damageNTSB CHI82FA002Accident · 1 fatalClosedBeech B95A · Bedford Park, ILOct 12, 1981 · N8286D · Destroyed