NTSB investigations, UT

192 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\" = 'UT' 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 DEN78DTM05Accident · No injuriesClosedCessna 150 · Fremont, UTOct 30, 1977 · N50512 · DestroyedNTSB DEN76FTM05Accident · Minor injuriesClosedCessna T210L · Bullfrog Basin, UTOct 13, 1976 · N210V · DestroyedNTSB DEN76DTM35Accident · No injuriesClosedCessna 188B · New Castle, UTMay 14, 1976 · N9278R · Substantial damageNTSB DEN76DTM22Accident · No injuriesClosedStinson 108-2 · Bryce Canyon, UTMar 13, 1976 · N9698K · Substantial damageNTSB DEN75DTM19Accident · No injuriesClosedCessna 180B · Orangeville, UTJun 16, 1975 · N5063E · Substantial damageNTSB DEN75DTM10Accident · No injuriesClosedPiper PA-28 · Provo, UTJan 13, 1975 · N4971T · Substantial damageNTSB DEN75ATM08Accident · No injuriesClosedBell 47G-3B · Kamas, UTDec 16, 1974 · N73218 · Substantial damageNTSB DEN75DTM07Accident · No injuriesClosedCessna 170B · Morgan, UTDec 7, 1974 · N8227A · Substantial damageNTSB DEN73AD056Accident · 5 fatalClosedCessna 310 · Provo, UTJun 27, 1973 · N7714H · DestroyedNTSB DEN73DTM23Accident · Minor injuriesClosedCessna 170B · Bryce Canyon, UTMar 19, 1973 · N8017A · Substantial damageNTSB DEN73DTM11Accident · Minor injuriesClosedCessna T210-H · St George, UTSep 25, 1972 · N2242R · Substantial damageNTSB DEN72DTM19Accident · No injuriesClosedPiper PA-18 · Laketown, UTJun 14, 1972 · N8268P · Substantial damageNTSB DEN72DTM12Accident · No injuriesClosedCessna 180 · Ibapah, UTMar 18, 1972 · N2393C · Substantial damageNTSB DEN72DTM03Accident · No injuriesClosedChampion 7KCAB · Lehi, UTJul 30, 1971 · N5101X · DestroyedNTSB DEN71FTM31Accident · Minor injuriesClosedAero Comdr 100 · Granger, UTJun 17, 1971 · N2947T · Substantial damageNTSB DEN71DTM30Accident · No injuriesClosedCessna 182E · Fillmore, UTMay 27, 1971 · N3257Y · Substantial damageNTSB DEN71DTM27Accident · No injuriesClosedCessna 150 · Logan, UTMay 24, 1971 · N50511 · Substantial damageNTSB DEN71DXT11Accident · No injuriesClosedPiper PA-20 · Ogden, UTOct 3, 1970 · N2186A · Substantial damageNTSB DEN71DXT01Accident · No injuriesClosedPiper PA-18 · Fielding, UTJul 4, 1970 · N1249A · Substantial damageNTSB DEN70DXT09Accident · No injuriesClosedPiper PA-12 · Salt Lake City, UTMay 6, 1970 · N3505M · Substantial damageNTSB DEN70F0056Accident · Minor injuriesClosedCessna 310J · Cedar City, UTAug 14, 1969 · N146F · Substantial damageNTSB DEN69F0146Accident · Minor injuriesClosedErco 415-C · Salt Lake City, UTDec 8, 1968 · N87436 · Substantial damageNTSB DEN69F0033Accident · No injuriesClosedCessna 172 · Salt Lake City, UTJul 8, 1968 · N2590Y · Substantial damageNTSB DEN69F0044Accident · No injuriesClosedCessna 172 · Ogden, UTJun 25, 1968 · N9882T · Substantial damageNTSB DEN68D0191Accident · No injuriesClosedCessna 172 · Richfield, UTDec 30, 1967 · N8267X · Substantial damageNTSB DEN68D0192Accident · No injuriesClosedCessna 182 · Spanish Fork, UTDec 27, 1967 · N7245E · Substantial damageNTSB DEN68D0167Accident · No injuriesClosedPiper PA-28 · Provo, UTNov 24, 1967 · N7411R · Substantial damageNTSB DEN68F0106Accident · No injuriesClosedCessna 180 · Salt Lake City, UTAug 20, 1967 · N4693B · Substantial damageNTSB DEN68A0009Accident · No injuriesClosedCessna 185 · Myton, UTJul 23, 1967 · N4028Y · Substantial damageNTSB DEN68F0013Accident · No injuriesClosedSchleicher K8 · Heber City, UTJun 17, 1967 · N91274 · Substantial damageNTSB DEN67D0145Accident · No injuriesClosedCessna 310B · Bluff, UTOct 22, 1966 · N6622B · Substantial damageNTSB DEN67F0100Accident · No injuriesClosedHelio H-295 · Salt Lake City, UTSep 5, 1966 · N6302V · Substantial damageNTSB DEN67D0002Accident · No injuriesClosedCessna 150 · Provo, UTJun 5, 1966 · N8654S · Substantial damageNTSB DEN66F0332Accident · No injuriesClosedBellanca 14-13 · Mexican Hat, UTMay 15, 1966 · N86825 · Substantial damageNTSB DEN66F0265Accident · No injuriesClosedCessna 172 · Kearns, UTMar 24, 1966 · N8307B · Substantial damageNTSB DEN66F0165Accident · No injuriesClosedBeechcraft E35 · Woods Cross, UTNov 13, 1965 · N7335B · Substantial damageNTSB DEN66A0025Accident · Minor injuriesClosedBell 47G3B1 · Salt Lake City, UTOct 5, 1965 · N8537F · DestroyedNTSB DEN66D0109Accident · No injuriesClosedBeechcraft K-35 · Veyo, UTSep 16, 1965 · N524T · Substantial damageNTSB DEN65F0016Accident · No injuriesClosedLuscombe 8A · Bryce Canyon, UTFeb 22, 1965 · N20687 · Substantial damageNTSB DEN65F0009Accident · Minor injuriesClosedCessna 172 · Monument Vally, UTJan 31, 1965 · N3741S · DestroyedNTSB UNK65X0193Accident · No injuriesClosedPiper PA20 · Woods Cross, UTOct 8, 1964 · N7783K · Substantial damageNTSB UNK64X0614Accident · No injuriesClosedCessna 210B · Price, UTFeb 19, 1964 · N9766X · Substantial damage