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 CEN15LA028Accident · 1 fatalLimited investigationFinal reportHuebbe Sonex HB · Plainview, ILThe loss of engine power during cruise flight due to a fatigue fracture of the crankshaft, which resulted in a forced landing on unsuitable terrain.Oct 26, 2014 · N244HB · Substantial damageNTSB CEN15CA033Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Quincy, ILThe pilot's improper fuel management, which resulted in the total loss of power to both engines due to fuel exhaustion and the subsequent forced landing in a field. Also causal to the accident was the pilot's decision to use the slower emergency hand-pump to…Oct 26, 2014 · N62791 · Substantial damageNTSB CEN15FA009Accident · 3 fatalField investigationFinal reportRaytheon 58 · Palos Hills, ILThe pilot's loss of airplane control due to spatial disorientation while operating in night, instrument meteorological conditions.Oct 13, 2014 · N31EW · DestroyedNTSB CEN15LA021Accident · No injuriesLimited investigationFinal reportRaytheon 58 · Dixon, ILThe pilots’ improper decision to continue flight in icing conditions after the deicing boots could not shed accumulated ice, which resulted in a temporary loss of airplane control.Oct 4, 2014 · N345PG · Substantial damageNTSB CEN14FA522Accident · 1 fatalField investigationFinal reportCessna T337G · Plano, ILThe pilot’s failure to recognize the airplane’s low altitude and arrest the airplane’s descent on approach to the airport in dark night conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s degraded night…Sep 29, 2014 · N37E · Substantial damageNTSB CEN14LA309Accident · No injuriesLimited investigationFinal reportSchumacher Challenger II · St. Joesph, ILThe total loss of engine power due to a lack of lubrication following the in-flight failure of the mechanical oil injection pump. Contributing to the accident was the temporary obscuration of the pilot's forward visibility due to sun glare during the forced…Jun 21, 2014 · N441MS · Substantial damageNTSB CEN14CA124Accident · Minor injuriesData collectionFinal reportCessna R182 · Mt. Morris, ILThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate pre-flight planning and decision-making.Jan 25, 2014 · N6359T · Substantial damageNTSB CEN14IA121Incident · No injuriesIncident investigationFinal reportCessna 680 · Wheeling, ILThe disconnection of the left elevator trim driveshaft from the trim actuator due to the elevator trim tab drive pin becoming dislodged, which resulted in full nose-down elevator trim.Jan 12, 2014 · N531RC · No damageNTSB CEN13LA536Accident · Minor injuriesLimited investigationFinal reportSweet Wayne A Bushby Mustang II · Woodstock, ILThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.Sep 8, 2013 · N54WS · Substantial damageNTSB CEN13LA398Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctls · Sandwich, ILThe pilot’s failure to recognize the formation of carburetor ice during cruise descent and apply carburetor heat, which resulted in the total loss of engine power.Jul 7, 2013 · N549LS · Substantial damageNTSB CEN13LA103Accident · Serious injuriesLimited investigationFinal reportAuman JL T-51 · Dekalb, ILThe improper engine overhaul by the airplane kit manufacturer, which resulted in a catastrophic engine failure.Dec 11, 2012 · N512JA · Substantial damageNTSB CEN13FA096Accident · 3 fatalField investigationFinal reportMBB BK 117 A-3 · Compton, ILThe inadvertent encounter with inclement weather, including snow, freezing rain, and reduced visibility conditions, which led to the pilot’s spatial disorientation and loss of aircraft control.Dec 11, 2012 · N911BK · Substantial damageNTSB CEN12LA632Accident · No injuriesLimited investigationFinal reportBruce M Barrett Stolp Starlet SA500 · Shelbyville, ILAn abrupt, complete loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Sep 13, 2012 · N935B · Substantial damageNTSB CEN12LA470Accident · Minor injuriesLimited investigationFinal reportYamokoski William Glastar · Chicago, ILFailure of the automotive engine's reduction gearbox while in cruise flight.Jul 22, 2012 · N4970Y · Substantial damageNTSB CEN12LA455Accident · No injuriesLimited investigationFinal reportCessna 175A · Shelby, ILThe loss of engine power due to oil starvation for reasons that could not be determined because engine examinations revealed no malfunctions or failures that would have led to oil starvation.Jul 17, 2012 · N7003E · Substantial damageNTSB CEN12FA395Accident · 1 fatalField investigationFinal reportNappi Tito C Lancair 235M · Monroe Center, ILThe in-flight fire for a reason that could not be determined due to extensive damage from the fire.Jun 26, 2012 · N18TN · Substantial damageNTSB CEN12IA377Incident · No injuriesIncident investigationFinal reportPiper PA-28R-200 · Lacon, ILThe propeller blade’s failure due to a fatigue crack that originated from a surface gouge that resulted from foreign object damage to the propeller blade that occurred at an unknown time.Jun 18, 2012 · N4350T · Minor damageNTSB CEN12FA083Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Crystal Lake, ILThe noninstrument-rated pilot's decision to continue flight in instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control of the airplane.Nov 26, 2011 · N223CD · Substantial damageNTSB CEN12IA050Incident · No injuriesIncident investigationFinal reportNusbaum Vaquero · Hebron, ILThe pilot’s operation of the airplane with known medical conditions and his subsequent heart attack during the flight.Nov 1, 2011 · N30CY · No damageNTSB CEN11IA649Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Chicago, ILThe infiltration of moisture into the windshield heating layer that induced arcing in the heating system that subsequently cracked the windshield.Sep 17, 2011 · C-FGYL · Minor damageNTSB CEN11LA656Accident · No injuriesLimited investigationFinal reportQuicksilver GT400 · Bolingbrook, ILThe loss of engine power for reasons that could not be determined during postaccident examination of the engine or airframe.Sep 10, 2011 · N2590A · Substantial damageNTSB CEN11LA544Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT802 · Ullin, ILThe loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.Jul 22, 2011 · N396LA · Substantial damageNTSB CEN11FA425Accident · 1 fatalField investigationFinal reportCessna T210L · Romeoville, ILA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.Jun 26, 2011 · N732BX · Substantial damageNTSB CEN11LA413Accident · No injuriesLimited investigationFinal reportCessna 172N · Bedford Park, ILA loss of engine power due to a fractured push rod precipitated by a stuck exhaust valve.Jun 18, 2011 · N172NT · Substantial damageNTSB CEN11CA387Accident · No injuriesData collectionFinal reportBeech B200 · Waukegan, ILThe lightning strike during an en route descent.Jun 10, 2011 · N23WS · Substantial damageNTSB CEN11FA227Accident · No injuriesField investigationFinal reportLancair LC41-550FG · Carbondale, ILThe fatigue fracture and subsequent failure of the No. 2 cylinder exhaust valve during cruise flight, which resulted in a total loss of engine power.Mar 11, 2011 · N521RT · Substantial damageNTSB CEN10CA452Accident · No injuriesData collectionFinal reportMaule MX-7-180A · Pittsfield, ILThe pilot's loss of directional control during a precautionary off-field landing that he performed after encountering deteriorating weather conditions.Jul 30, 2010 · N17MX · Substantial damageNTSB CEN10CA398Accident · No injuriesData collectionFinal reportBradshaw Quicksilver MX II · Newark, ILA total loss of engine power during cruise when the ignition switch vibrated into the "off" position, leading to the airplane's impact with a ditch during the off-field landing.Jul 1, 2010 · N4469N · Substantial damageNTSB CEN10LA220Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-82(MD-82) · Chicago, ILThe flight attendant's loss of balance resulting in a fall and a broken wrist.Apr 17, 2010 · N461AA · No damageNTSB CEN10LA218Accident · Serious injuriesLimited investigationFinal reportSaab-Scania Saab 340B · Bradley, ILThe flightcrew's encounter with convectively induced turbulence associated with a convective cloud during the flight.Apr 6, 2010 · N437XJ · No damageNTSB CEN10FA108Accident · 2 fatalField investigationFinal reportSmith Aerostar 601P · Sugar Grove, ILThe pilot's spatial disorientation and subsequent failure to maintain airplane control.Jan 24, 2010 · N222AQ · DestroyedNTSB CEN10CA092Accident · Minor injuriesData collectionFinal reportCessna 150L · Brownstown, ILA total loss of engine power due to fuel exhaustion as a result of the student pilot becoming lost/disoriented in flight.Jan 5, 2010 · N10401 · Substantial damageNTSB CEN10CA067Accident · No injuriesData collectionFinal reportCessna 182 · Carmi, ILA total loss of engine power due to fuel starvation as a result of the pilot's failure to assure that the fuel tank filler cap was secured prior to flight.Dec 4, 2009 · C-GZYU · Substantial damageNTSB CEN09LA494Accident · No injuriesLimited investigationFinal reportCrisman Flightstar Iisc · Malta, ILThe loss of engine power due to the separation of the flywheel, resulting in a high-cycle fatigue fracture of the crankshaft following takeoff, which resulted in a forced landing on an agricultural field.Jul 24, 2009 · N5008E · Substantial damageNTSB CEN09CA410Accident · No injuriesData collectionFinal reportCessna 150 · Bloomington, ILThe complete loss of engine power as a result of fuel exhaustion due to the pilot's inadequate preflight.Jul 3, 2009 · N8319J · Substantial damageNTSB CEN09IA618Incident · No injuriesIncident investigationFinal reportBell 230 · Peoria, ILThe loss of the number one hydraulic system fluid and hydraulic pressure during cruise due to the failure of the bolts that secure the hydraulic pump's cover.Jul 1, 2009 · N880SF · No damageNTSB CEN09LA285Accident · Serious injuriesLimited investigationFinal reportRockwell International 112A · Metropolis, ILA total loss of engine power for undetermined reasons.May 10, 2009 · N1348J · Substantial damageNTSB CEN09MA019Accident · 4 fatalMajor investigationFinal reportBell 222 · Aurora, ILThe pilot's failure to maintain clearance from the 734-foot-tall lighted tower during the visual night flight due to inadequate preflight planning, insufficient altitude, and a flight route too low to clear the tower. Contributing to the accident was the air…Oct 16, 2008 · N992AA · DestroyedNTSB CHI08IA292Incident · No injuriesIncident investigationFinal reportBoeing 757-223 · Chicago, ILThe failure of an electrical relay due to eroded contacts and the flight crew's decision to continue a flight that was operating on battery power.Sep 22, 2008 · N197AN · Minor damageNTSB CHI08IA200Incident · No injuriesIncident investigationFinal reportEclipse EA500 · Rockford, ILThe improper installation of the forward edge of the left-hand wing-to-body panel, causing the fairing to separate from the airplane during an in-flight encounter with light turbulence. Contributing to the event was the use of small-head screws and grommets…Jul 17, 2008 · N875NA · Minor damageNTSB CHI08CA177Accident · No injuriesData collectionFinal reportRobinson R44 II · Ottawa, ILThe pilot's failure to maintain clearance from the power transmission lines. Contributing to the accident was the unmarked power transmission lines.Jul 4, 2008 · N31138 · Substantial damageNTSB CHI08LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Watseka, ILThe loss of engine power for undetermined reasons.Jun 22, 2008 · N6144J · Substantial damageNTSB CHI08LA158Accident · 1 fatalLimited investigationFinal reportMaggs Lancair 4P · Alhambra, ILThe pilot's decision to continue the flight into an area of known thunderstorm activity and the in-flight structural failure of the airplane.Jun 6, 2008 · N241DM · Substantial damageNTSB CHI08CA112Accident · No injuriesData collectionFinal reportPierson RV-6 · Newark, ILThe partial loss of engine power due to the fracture of the number 4 exhaust valve, and the pilot's decision to shut-down the engine without sufficient altitude to ensure a safe glide path to the runway. Contributing to the accident was the barbed wire fence…Apr 20, 2008 · N606JP · Substantial damageNTSB CHI08CA087Accident · No injuriesData collectionFinal reportCessna 140 · Poplar Grove, ILThe left wing skin "fabric patch" separated from the wing ribs and spars for an undetermined reason.Feb 23, 2008 · N3527V · Substantial damageNTSB CHI08IA085Incident · No injuriesIncident investigationFinal reportHawker Beechcraft 99 · Moline, ILThe arcing of the resistor and silicone controlled rectifier in the flap control circuit.Feb 19, 2008 · N118SF · Minor damageNTSB NYC07IA199Incident · No injuriesIncident investigationFinal reportPiper PA-32R-301T · Alton, ILThe component manufacturer's inadequate fabrication of the transient voltage suppressor.Aug 15, 2007 · N3120T · Minor damageNTSB CHI07CA276Accident · No injuriesData collectionFinal reportGolden Eagle Chief · Hindsboro, ILThe loss of engine power due to the number seven cylinder's separation during cruise and the crops encountered during the forced landing leading to the airplane nosing over.Aug 10, 2007 · N68N · Substantial damageNTSB CHI07LA240Accident · No injuriesLimited investigationFinal reportAircoupe F-1A · Greenwood, ILThe loss of engine power due to carburetor icing, which resulted in the pilot having to perform a forced landing to unsuitable terrain. Factors contributing to the accident were the carburetor icing conditions and the broken carbuerator heat lever.Jul 30, 2007 · N3041G · Substantial damageNTSB CHI07CA227Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Prophetstown, ILThe pilot's failure to accurately monitor fuel consumption during flight, which resulted in a loss of engine power due to fuel starvation/exhaustion. A contributing factor was the cornfield encountered during the forced landing.Jul 23, 2007 · N628JP · Substantial damage