NTSB investigations, 1978, AL

22 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 1978, AL per year, 1962–2026: 748 cases
19621
196426
196538
196636
196733
196837
196929
197042
197130
197236
197324
197425
197521
197631
197727
197822
197914
198021
198112
198213
198311
19846
198510
19863
198711
19885
19895
19901
19915
19927
19934
19944
19954
19967
19973
19984
19994
20005
20017
200210
20036
20043
20057
20063
20079
20089
20096
20102
20112
20129
20131
20146
20156
20164
20173
20185
20193
20204
20212
20226
20232
20243
20255
20268

Latest cases

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 year(c.\"eventDate\") = 1978
    AND c.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 550)
  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 MIA79DKJ17Accident · No injuriesClosedBeech 23 · Montgomery, ALDec 18, 1978 · N2219L · Substantial damageNTSB MIA79DKJ05Accident · No injuriesClosedCessna 152T · Dothan, ALOct 16, 1978 · N757TM · Substantial damageNTSB MIA79DKJ02Accident · No injuriesClosedAero Comdr S2R · Scottsboro, ALOct 6, 1978 · N8515V · Substantial damageNTSB MIA78FKJ95Accident · Minor injuriesClosedPiper PA-28R · Huntsville, ALSep 28, 1978 · N16369 · Substantial damageNTSB MIA78DKJ93Accident · Minor injuriesClosedErco 415-C · Cragford, ALSep 24, 1978 · N3100H · Substantial damageNTSB MIA78DKJ88Accident · No injuriesClosedBellanca 7ECA · Huntsville, ALSep 10, 1978 · N5524K · Substantial damageNTSB MIA78FKJ87Accident · No injuriesClosedBeech E55 · Montgomery, ALSep 5, 1978 · N3620A · Substantial damageNTSB MIA78DKJ83Accident · No injuriesClosedCessna 150 · Pell City, ALAug 26, 1978 · N6581S · Substantial damageNTSB MIA78DKJ73Accident · No injuriesClosedCessna 150 · Vincent, ALAug 6, 1978 · N8390J · Substantial damageNTSB MIA78DKJ61Accident · No injuriesClosedAeronca L3 · Ozark, ALJul 18, 1978 · N46748 · Substantial damageNTSB MIA78DKJ56Accident · No injuriesClosedBeech 23 · Montgomery, ALJul 7, 1978 · N2219L · Substantial damageNTSB MIA78FKJ54Accident · No injuriesClosedMaule M-4 · Brewton, ALJun 24, 1978 · N4130C · Substantial damageNTSB MIA78FKJ41Accident · No injuriesClosedBeech D95A · Montgomery, ALMay 31, 1978 · N8965M · Substantial damageNTSB MIA78DKJ36Accident · No injuriesClosedCessna 182 · Tuscaloosa, ALMay 20, 1978 · N52587 · Substantial damageNTSB MIA78FA079Incident · No injuriesClosedSwearingen 226-TC · Muscle Shoals, ALMay 8, 1978 · N70A · Minor damageNTSB MIA78DKJ34Accident · No injuriesClosedCessna 182 · Gadsden, ALApr 29, 1978 · N8787T · Substantial damageNTSB MIA78DKJ31Accident · No injuriesClosedCessna 177 · Alabaster, ALApr 9, 1978 · N13484 · Substantial damageNTSB MIA78DKJ30Accident · Minor injuriesClosedBellanca 7KCAB · Wetumpka, ALApr 9, 1978 · N1131E · DestroyedNTSB MIA78FKJ29Accident · No injuriesClosedEnstrom 280C · Smith Lake, ALApr 4, 1978 · N660H · DestroyedNTSB MIA78FKJ28Accident · No injuriesClosedBeech H18 · Birmingham, ALMar 29, 1978 · N787Q · Substantial damageNTSB MIA780KJ23Accident · No injuriesClosedPiper PA-18A · Ashland, ALFeb 25, 1978 · N9776D · Substantial damageNTSB MIA78DKJ20Accident · No injuriesClosedCessna 150 · Jacksonville, ALJan 31, 1978 · N714LQ · Substantial damage