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 CHI82DA274Accident · No injuriesFinal reportCessna 188B · Loami, ILThe pilot was taking off on the first flight of the day with a reported load of 1080 lbs of wheat seed. During the takeoff, there was a direct crosswind of 6 KTS and the temperature and dew point were 78 and 68 deg, respectively. After using about 3/4 of the…Jul 24, 1982 · N4970Q · DestroyedNTSB CHI82DA155Accident · No injuriesFinal reportCessna 180 · Aurora, ILOn takeoff the aircraft veered off the side of the runway and struck a drainage ditch. The pilot reported a gust of wind caught the aircraft.May 8, 1982 · N9388C · Substantial damageNTSB CHI82DA151Accident · No injuriesFinal reportCessna 172A · Cissno Park, ILDuring takeoff on runway 09, the aircraft veered to the left. The pilot closed the throttle, but was unable to stop before the left wheel went into soft soil on the north side of the runway. Gusty winds from the south picked up the tail and gently rolled the…May 5, 1982 · N7709T · Substantial damageNTSB CHI82DA109Accident · No injuriesFinal reportCessna 180 · Nokomis, ILDuring takeoff from a soft sod field the aircraft started gradually turning to the left. The pilot applied full right rudder then reduced power before the aircraft nosed over on its back.Apr 1, 1982 · N4936A · Substantial damageNTSB CHI82IA108Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Chicago, ILThe aircraft veered left at slow speed but the veer was corrected. At 60 KTS the aircraft veered again and was not corrected. Aircraft left runway and damaged props. Service bulletin SA-226 no. 103 dated 01/20/82 states that limits be placed on use of nose…Mar 31, 1982 · N62Z · Minor damageNTSB CHI82DA066Accident · No injuriesFinal reportCessna 152 · Plainfield, ILThe student pilot stated that during takeoff roll the aircraft began to drift left. Right rudder did not correct the drift and the left wheel contacted snow on the side of the runway causing drag on the aircraft. The aircraft nosed over as it departed the…Feb 21, 1982 · N6112Q · Substantial damageNTSB CHI82DA052Accident · No injuriesFinal reportPiper PA-28-151 · Monee, ILThe pilot began his takeoff at the approach end of runway 27. He stated that the aircraft rolled straight for 700 ft, then at about 55 mph (lift-off speed), the plane veered left into a snowbank. The runway was 35 ft wide and was reported to have had frozen…Feb 15, 1982 · N56979 · Substantial damageNTSB CHI82DA023Accident · No injuriesFinal reportCessna 152 · Peoria, ILReportedly, the student tookoff without his instructor's appproval. He initiated a takeoff roll on runway 35 with the wind from 230 degrees at 11 knots. He stated that the wind shifted and caught him from behind as he was about to lift off. Directional…Jan 8, 1982 · N6265P · Substantial damageNTSB CHI81IA099Incident · No injuriesClosedCessna 152 · Romeoville, ILSep 12, 1981 · N4837P · Minor damageNTSB CHI81PEE51Accident · No injuriesClosedBeech A45 · Glenview, ILJul 31, 1981 · N3483F · Substantial damageNTSB CHI81DCA08Accident · No injuriesClosedPiper PA-25 · Belleville, ILJun 28, 1981 · N7753Z · Substantial damageNTSB CHI81FEE40Accident · No injuriesClosedMooney M20F · West Chicago, ILJun 15, 1981 · N9209V · Substantial damageNTSB CHI81DA050Accident · No injuriesClosedCessna 340A · Robinson, ILApr 22, 1981 · N4155A · 2 aircraft · Substantial damageNTSB CHI81FEV08Accident · No injuriesClosedCessna 177RG · Meyer, ILDec 28, 1980 · N7818V · Substantial damageNTSB CHI80DEE57Accident · No injuriesClosedBLN Works FF-7 · Rock Island, ILSep 30, 1980 · N1532B · Substantial damageNTSB CHI80FEV40Accident · Serious injuriesClosedBensen B8M · St. Joseph, ILSep 28, 1980 · N30087 · Substantial damageNTSB CHI80FEE51Accident · No injuriesClosedBeech G18S · Lansing, ILSep 17, 1980 · N9400Y · Substantial damageNTSB CHI80FEV38Accident · Minor injuriesClosedJeanies Teenie · Shelbyville, ILSep 14, 1980 · N3774C · Substantial damageNTSB CHI80DEE43Accident · No injuriesClosedCessna 172N · Rockford, ILAug 14, 1980 · N6205F · DestroyedNTSB CHI80FEV29Accident · No injuriesClosedStinson 108-3 · Chester, ILJul 27, 1980 · N4066C · Substantial damageNTSB CHI80FA056Accident · No injuriesClosedCessna 310R · Galesburg, ILJul 15, 1980 · N87497 · Substantial damageNTSB CHI80DEE29Accident · No injuriesClosedCessna 172N · Belvidere, ILJun 22, 1980 · N4770J · Substantial damageNTSB CHI80DEE27Accident · No injuriesClosedCessna 152 · Wheeling, ILJun 11, 1980 · N4609B · Substantial damageNTSB CHI80FEE17Accident · No injuriesClosedSikorsky S-58 · Chicago, ILMar 2, 1980 · N4388S · DestroyedNTSB CHI80AA024Accident · 2 fatalClosedFalcon 10 · Chicago, ILJan 30, 1980 · N253K · DestroyedNTSB CHI79DEE82Accident · No injuriesClosedCessna 337 · Peru, ILSep 27, 1979 · N110RL · Substantial damageNTSB CHI79DEE77Accident · No injuriesClosedBeech C35 · Chicago, ILAug 22, 1979 · N692D · Substantial damageNTSB CHI79FEE70Accident · No injuriesClosedScorpion TOO · Rockford, ILJul 23, 1979 · N36JB · Substantial damageNTSB CHI79FEV25Accident · No injuriesClosedPiper PA-32 · Tremont, ILJul 14, 1979 · N3849W · Substantial damageNTSB CHI79FEV21Accident · No injuriesClosedHughes 269B · Flanagan, ILMay 19, 1979 · N9323F · Substantial damageNTSB CHI79FEE50Accident · Minor injuriesClosedCessna 172N · Lansing, ILApr 28, 1979 · N733YX · Substantial damageNTSB CHI79FEV18Accident · Minor injuriesClosedCessna A188B · Effingham, ILApr 20, 1979 · N8904G · Substantial damageNTSB CHI79IA042Incident · Minor injuriesClosedBoeing 707 · Chicago, ILApr 10, 1979 · N8413 · No damageNTSB CHI79FEE38Accident · No injuriesClosedCessna 210 · Crestwood, ILMar 13, 1979 · N9617T · Substantial damageNTSB CHI79FEV14Accident · No injuriesClosedCessna 150 · Lincoln, ILMar 12, 1979 · N19358 · Substantial damageNTSB CHI79FEE40Accident · No injuriesClosedSwearingen SA26T · West Chicago, ILFeb 24, 1979 · N211CC · Substantial damageNTSB CHI79DEE41Accident · No injuriesClosedGrumman AA1C · Plainfield, ILFeb 10, 1979 · N9520U · Substantial damageNTSB CHI79DEE37Accident · No injuriesClosedCessna 172 · Schaumburg, ILFeb 10, 1979 · N738ZZ · Substantial damageNTSB CHI79FEV10Accident · No injuriesClosedBeech E18-S · Springfield, ILJan 27, 1979 · N521GP · Substantial damageNTSB CHI79DEE35Accident · No injuriesClosedCessna 150 · Spring Valley, ILJan 22, 1979 · N3089S · Substantial damageNTSB CHI79DEE14Accident · No injuriesClosedCessna 401A · Chicago, ILDec 6, 1978 · N622DG · Substantial damageNTSB CHI79DEE28Accident · No injuriesClosedCessna 152 · Sugar Grove, ILDec 2, 1978 · N68750 · Substantial damageNTSB CHI79DEE11Accident · No injuriesClosedBeech A-55 · Ottawa, ILNov 5, 1978 · N323E · Substantial damageNTSB CHI79FEV02Accident · No injuriesClosedCessna 152 · Jacksonville, ILOct 18, 1978 · N757UJ · Substantial damageNTSB CHI79FEE01Accident · No injuriesClosedPiper PA-28 · Elgin, ILOct 3, 1978 · N44553 · Substantial damageNTSB CHI78FA067Accident · No injuriesClosedBeech 18T · Chicago, ILSep 13, 1978 · N12VT · Substantial damageNTSB CHI79FEE62Accident · No injuriesClosedCessna 172 · Dwight, ILAug 9, 1978 · N9200H · Substantial damageNTSB CHI78FEV42Accident · No injuriesClosedHughes 269A · Williamsfield, ILJul 10, 1978 · N8774F · Substantial damageNTSB CHI78FEE38Accident · No injuriesClosedBeech G-18 · Dekalb, ILMay 23, 1978 · N8087 · Substantial damageNTSB CHI78DEV20Accident · No injuriesClosedCessna 150 · Carbondale, ILMar 6, 1978 · N66009 · Substantial damage