NTSB investigations, 1974

169 cases where the phase of flight was Taxi.

Cases per year

19622026
NTSB investigations, 1974 per year, 1962–2026: 6,400 cases
19626
19636
1964346
1965306
1966372
1967381
1968215
1969200
1970212
1971189
1972181
1973177
1974169
1975179
1976151
1977156
1978184
1979134
1980132
1981113
1982127
1983104
198496
198573
198670
198787
198883
198973
199074
199149
199255
199360
199451
199556
199659
199764
199865
199955
200057
200157
200262
200349
200448
200552
200651
200749
200864
200945
201041
201145
201241
201344
201433
201543
201638
201745
201850
201951
202025
202147
202252
202348
202445
202558
202650

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 = 250)
  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 LAX75FUA19Accident · No injuriesClosedCessna 172K · Avalon, CADec 31, 1974 · N84754 · Substantial damageNTSB NYC75DHA25Accident · No injuriesClosedCessna 172 · Manville, NJDec 28, 1974 · N6966A · Substantial damageNTSB IAD75DI213Accident · No injuriesClosedEnstrom F-28A · Willow Is, WVDec 24, 1974 · N9278 · Substantial damageNTSB FTW75FRD22Accident · No injuriesClosedAero Comdr 500-B · New Orleans, LADec 23, 1974 · N99JG · Substantial damageNTSB OAK75DXQ32Accident · No injuriesClosedCessna 172 · Truckee, CADec 22, 1974 · N1460V · Substantial damageNTSB MKC75FER35Accident · No injuriesClosedBeech 35 · Mankato, MNDec 16, 1974 · N2790V · Substantial damageNTSB CHI75DEG09Accident · No injuriesClosedCessna 150H · Moraine, OHDec 7, 1974 · N50250 · Substantial damageNTSB OAK75DVD36Accident · No injuriesClosedCessna 172M · Stockton, CADec 4, 1974 · N20666 · Substantial damageNTSB IAD75FIA09Accident · No injuriesClosedCessna 150E · Clinton, MDNov 29, 1974 · N3518J · Substantial damageNTSB OAK75FVW10Accident · No injuriesClosedPiper PA-28R · Las Vegas, NVNov 27, 1974 · N41998 · Substantial damageNTSB FTW75FPA15Accident · No injuriesClosedCessna 172L · Greenville, TXNov 26, 1974 · N8180M · Substantial damageNTSB MIA75DLD42Accident · No injuriesClosedLuscombe 8E · Brandon, FLNov 24, 1974 · N2721K · Substantial damageNTSB NYC75AN065Accident · No injuriesClosedBoeing 747 · Jamaica, NYNov 21, 1974 · N604US · 2 aircraft · Minor damageNTSB MKC75DCD24Accident · No injuriesClosedLockheed 12A · Osage, IANov 21, 1974 · N18137 · Substantial damageNTSB DEN75DTE35Accident · No injuriesClosedCessna 172 · Englewood, CONov 20, 1974 · N13938 · Substantial damageNTSB MKC75DCJ40Accident · Minor injuriesClosedPiper J3C-65 · Gordon, NENov 19, 1974 · N26959 · Substantial damageNTSB NYC75AN062Accident · No injuriesClosedPiper PA-23 · Philadelphia, PANov 15, 1974 · N40254 · Substantial damageNTSB MIA75KKQ23Accident · No injuriesClosedCessna 172 · Greenville, MSNov 13, 1974 · N9747 · Substantial damageNTSB OAK75FVM12Accident · No injuriesClosedN.American F-51D · Hf Moon Bay, CANov 10, 1974 · N11T · 2 aircraft · Substantial damageNTSB ANC75AA041Accident · No injuriesClosedCessna 170 · Chalkyitsik, AKNov 5, 1974 · N2231D · Substantial damageNTSB NYC75FHJ20Accident · No injuriesClosedPiper PA-28 · Mattituck, NYNov 3, 1974 · N54385 · Substantial damageNTSB CHI75AC039Accident · No injuriesClosedCessna 421B · Rockford, ILOct 31, 1974 · N396DB · Substantial damageNTSB NYC75FGM15Accident · Minor injuriesClosedBrantly B-2B · Sharon, PAOct 26, 1974 · N2280U · Substantial damageNTSB MIA75DKT19Accident · No injuriesClosedPiper PA-22 · Ft Lauderdale, FLOct 26, 1974 · N5853Z · Substantial damageNTSB NYC75DFA16Accident · No injuriesClosedNavion G · Westport, NYOct 22, 1974 · N2417T · Substantial damageNTSB FTW74FRJ18Accident · No injuriesClosedCessna 337 · Texarkana, AROct 19, 1974 · N6318F · Substantial damageNTSB FTW75DQD13Accident · No injuriesClosedPiper PA-28 · Fort Stockton, TXOct 17, 1974 · N9020W · Substantial damageNTSB MKC75DCJ33Accident · No injuriesClosedStinson 108-3 · Alliance, NEOct 16, 1974 · N4123C · Substantial damageNTSB MIA75DLD23Accident · No injuriesClosedBoeing A75N1 · Lake Placid, FLOct 15, 1974 · N5506A · Substantial damageNTSB MKC75DCJ35Accident · Minor injuriesClosedBeech E55 · Ainsworth, NEOct 12, 1974 · N9327Q · Substantial damageNTSB NYC75FHM10Accident · No injuriesClosedPiper PA-30 · Newark, NJOct 11, 1974 · N7940Y · Substantial damageNTSB SEA75AS016Accident · No injuriesClosedCessna 185E · Twin Falls, IDOct 10, 1974 · N4753Q · Substantial damageNTSB CHI75FEK14Accident · No injuriesClosedCessna A150K · Marion, OHOct 8, 1974 · N8383M · Substantial damageNTSB LAX75DUJ38Accident · No injuriesClosedCessna 177RG · Peoria, AZOct 7, 1974 · N80216 · Substantial damageNTSB NYC75FNE14Accident · No injuriesClosedCessna 195B · Danbury, CTOct 6, 1974 · N2154C · 2 aircraft · Substantial damageNTSB LAX75DUG16Accident · No injuriesClosedCessna 140 · Chino, CAOct 6, 1974 · N76098 · Substantial damageNTSB DEN75DQA16Accident · No injuriesClosedCessna 182 · Albuquerque, NMSep 30, 1974 · N19107 · Substantial damageNTSB NYC75FNC09Accident · No injuriesClosedCessna 140 · Nashua, NHSep 22, 1974 · N4006N · Substantial damageNTSB NYC75DHD13Incident · No injuriesClosedCessna 182 · N.Philadelphia, PASep 22, 1974 · N3706D · Minor damageNTSB SEA75AYI11Accident · No injuriesClosedCessna 172 · Eugene, ORSep 17, 1974 · N20981 · Substantial damageNTSB MIA75DKT13Accident · No injuriesClosedCessna 150 · Ochopee, FLSep 14, 1974 · N5345Q · Substantial damageNTSB MIA75DKJ21Incident · No injuriesClosedBeech B50 · Mobile, ALSep 14, 1974 · N9664R · Minor damageNTSB FTW75HF017Accident · No injuriesClosedBeech C-45H · Euless, TXSep 11, 1974 · N7916A · Substantial damageNTSB LAX75FUQ08Accident · No injuriesClosedCessna 172 · Agua Dulce, CASep 10, 1974 · N12586 · Substantial damageNTSB FTW75AF016Accident · No injuriesClosedBrittnorman BN-2A · Baton Rouge, LASep 10, 1974 · N80CA · Substantial damageNTSB SEA75AS013Accident · 1 fatalClosedChampion 7ECA · Seattle, WASep 9, 1974 · N5235X · No damageNTSB MIA75DKA01Accident · No injuriesClosedHelio Acft H-295 · Mayaguez, PRSep 8, 1974 · N68870 · Substantial damageNTSB LAX75DUJ26Accident · No injuriesClosedCessna 182 · Cottonwood, AZSep 6, 1974 · N5813B · Substantial damageNTSB OAK75FVG27Accident · No injuriesClosedCessna 210A · Sacramento, CASep 4, 1974 · N6615X · Substantial damageNTSB MKC75DER22Accident · No injuriesClosedAeronca 7CCM · Alexandria, MNSep 3, 1974 · N4642E · Substantial damage