NTSB investigations, 1974

556 cases where the phase of flight was Initial climb.

Cases per year

19622026
NTSB investigations, 1974 per year, 1962–2026: 20,559 cases
19623
19634
1964505
1965555
1966582
1967587
1968577
1969582
1970552
1971541
1972507
1973482
1974556
1975543
1976521
1977556
1978566
1979502
1980505
1981499
1982490
1983507
1984466
1985418
1986394
1987380
1988368
1989348
1990351
1991324
1992306
1993307
1994292
1995289
1996244
1997272
1998266
1999239
2000221
2001219
2002200
2003227
2004210
2005204
2006180
2007202
2008212
2009173
2010162
2011177
2012193
2013122
2014130
2015165
2016141
2017149
2018155
2019146
2020112
2021166
2022161
2023163
2024143
2025134
2026106

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\") = 1974
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 350)
  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 MKC75FCD30Accident · No injuriesClosedCessna 150 · Ottuma, IADec 31, 1974 · N7757F · Substantial damageNTSB LAX75FUD03Accident · No injuriesClosedCessna 172M · Snta Monica, CADec 30, 1974 · N13723 · Substantial damageNTSB ANC75AAG60Accident · Serious injuriesClosedCessna 172 · Kodiak, AKDec 29, 1974 · N46348 · Substantial damageNTSB ANC75AA047Accident · 1 fatalClosedPiper PA-18 · Anchorage, AKDec 27, 1974 · N9902D · DestroyedNTSB SEA75AS028Accident · 4 fatalClosedBrittnorman BN-2A · Riverton Hts, WADec 26, 1974 · N66HA · DestroyedNTSB FTW75DRD21Accident · No injuriesClosedPiper PA-28 · Lockport, LADec 26, 1974 · N5413S · Substantial damageNTSB MKC75FCD27Accident · Serious injuriesClosedAeronca 7AC · Graf, IADec 22, 1974 · N85697 · Substantial damageNTSB MKC75D1G16Accident · No injuriesClosedPiper J3C-65 · Esmond, NDDec 22, 1974 · N98755 · Substantial damageNTSB CHI75FEI35Accident · Minor injuriesClosedCessna 150 · Flushing, OHDec 22, 1974 · N22768 · Substantial damageNTSB MKC75FER34Accident · No injuriesClosedBeech V35 · St Paul, MNDec 20, 1974 · N2798T · Substantial damageNTSB CHI75DEP39Accident · No injuriesClosedBeech 95-B55 · Milwaukee, WIDec 19, 1974 · N7981K · Substantial damageNTSB DEN75FQA22Accident · No injuriesClosedAmer Avco AA-1A · Albuquerque, NMDec 17, 1974 · N9383L · Substantial damageNTSB MKC75FCG22Accident · No injuriesClosedCessna 182 · Lees Summit, MODec 16, 1974 · N2353R · Substantial damageNTSB DEN75FTC12Accident · Minor injuriesClosedCessna 182 · Gillette, WYDec 16, 1974 · N3087Q · Substantial damageNTSB OAK75FVM17Accident · No injuriesClosedCessna 172D · San Carlos, CADec 15, 1974 · N79893 · Substantial damageNTSB DEN75FTM11Accident · Minor injuriesClosedErco 415-C · Bountiful, UTDec 14, 1974 · N87276 · DestroyedNTSB CHI75FEI32Accident · Minor injuriesClosedCessna 150L · Alliance, OHDec 14, 1974 · N10646 · Substantial damageNTSB NYC75AN074Accident · 3 fatalClosedCessna 172 · Philipsburg, PADec 12, 1974 · N5868A · DestroyedNTSB MKC75DCQ26Accident · No injuriesClosedCessna 172 · Conway, KSDec 12, 1974 · N8857B · Substantial damageNTSB MIA75DLD43Accident · No injuriesClosedBeech C-45H · Palma Sola, FLDec 12, 1974 · N3719G · DestroyedNTSB MKC75FCD26Accident · No injuriesClosedMooney M20A · Guttenberg, IADec 11, 1974 · N6085X · Substantial damageNTSB DEN75DTE38Accident · No injuriesClosedCessna 150 · Greeley, CODec 11, 1974 · N5690G · Substantial damageNTSB CHI75FEE33Accident · 1 fatalClosedSmith Termit · Loves Park, ILDec 10, 1974 · N70LS · DestroyedNTSB SEA75DYA25Accident · No injuriesClosedCessna 180 · Bellevue, IDDec 8, 1974 · N2849A · Substantial damageNTSB OAK75AP031Accident · 2 fatalClosedAmer Avco AA1-B · Vacaville, CADec 8, 1974 · N8999L · DestroyedNTSB MKC75FCD25Accident · No injuriesClosedPiper PA-32 · Clarinda, IADec 8, 1974 · N4075W · Substantial damageNTSB NYC75FNC20Accident · Minor injuriesClosedCessna 172C · West Dover, VTDec 7, 1974 · N2024Y · Substantial damageNTSB CHI75DEK16Accident · No injuriesClosedCessna 150 · Findlay, OHDec 6, 1974 · N61150 · Substantial damageNTSB MKC75DER32Accident · No injuriesClosedPiper PA-22 · Marshall, MNDec 2, 1974 · N7222D · Substantial damageNTSB FTW75DPM11Accident · No injuriesClosedCessna 150 · Stilwell, OKDec 2, 1974 · N51408 · Substantial damageNTSB SEA75FYC13Accident · 1 fatalClosedMullan SA-11A · Mcminnville, ORDec 1, 1974 · N3304 · DestroyedNTSB MIA75FLD38Accident · No injuriesClosedCessna 140 · Merritt Isl, FLNov 29, 1974 · N77010 · Substantial damageNTSB MKC75DCQ25Accident · No injuriesClosedPiper PA-28 · St Francis, KSNov 27, 1974 · N6367J · Substantial damageNTSB NYC75FHD26Accident · Minor injuriesClosedPiper PA-23 · Ocean City, NJNov 24, 1974 · N1MV · Substantial damageNTSB FTW75FRG39Accident · Minor injuriesClosedCessna 310D · Austin, TXNov 23, 1974 · N6891T · DestroyedNTSB FTW75DRJ20Accident · No injuriesClosedGrumman G-164A · Natchitoches, LANov 22, 1974 · N7804 · Substantial damageNTSB CHI75FET11Accident · No injuriesClosedSikorsky S-52-3 · Valparaiso, INNov 22, 1974 · N54059 · Substantial damageNTSB CHI75FEC24Accident · Serious injuriesClosedPiper J3C-65 · Ypsilanti, MINov 22, 1974 · N2472C · Substantial damageNTSB NYC75FNA25Accident · No injuriesClosedCessna 150L · Millis, MANov 20, 1974 · N6635G · Substantial damageNTSB FTW75FPD19Accident · No injuriesClosedCessna 210 · Jacksboro, TXNov 19, 1974 · N93995 · Substantial damageNTSB NYC75FFS18Accident · No injuriesClosedVolksplane VP1 · Perry, NYNov 17, 1974 · N51609 · Substantial damageNTSB CHI75FEI14Accident · No injuriesClosedPiper PA-24 · Beach City, OHNov 17, 1974 · N7604P · Substantial damageNTSB OAK75DVD29Accident · No injuriesClosedWeatherly 201B · Farmington, CANov 16, 1974 · N1262W · Substantial damageNTSB ANC75FAA18Accident · No injuriesClosedHelio Acft H295 · Tanacross, AKNov 14, 1974 · N6487V · Substantial damageNTSB MIA75FLD33Accident · No injuriesClosedPiper J3C-65 · Plant City, FLNov 9, 1974 · N66061 · Substantial damageNTSB FTW75FPD16Accident · No injuriesClosedPiper PA-22 · N.Richlnd Hls, TXNov 8, 1974 · N1839P · Substantial damageNTSB DEN75FQA19Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMNov 7, 1974 · N8107N · Substantial damageNTSB MIA75FKT25Accident · No injuriesClosedCessna 188 · Naples, FLNov 6, 1974 · N4495Q · Substantial damageNTSB ANC75DAA17Accident · No injuriesClosedPiper PA-12 · Livengood, AKNov 5, 1974 · N3669M · Substantial damageNTSB FTW75FPD17Accident · 1 fatalClosedTeenie TWO · Wichita Falls, TXNov 4, 1974 · N17362 · Destroyed