NTSB investigations, 1974, AZ

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19632026
NTSB investigations, 1974, AZ per year, 1963–2026: 5,131 cases
19631
1964130
1965107
1966128
1967138
1968114
1969115
1970102
1971128
1972101
1973105
1974101
1975121
1976105
1977123
1978149
1979130
1980114
1981132
1982123
1983114
198484
198578
198677
198776
198861
198979
199068
199186
199288
199368
199465
199573
199668
199771
199854
199964
200061
200163
200276
200393
200472
200581
200677
200766
200873
200974
201063
201167
201261
201354
201462
201542
201640
201750
201860
201947
202036
202144
202253
202343
202441
202545
202646

Latest cases

Query with SQL
duckdb -csv -c "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.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
  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 LAX75FUJ51Accident · No injuriesClosedHelio Acft H-295 · Carefree, AZDec 28, 1974 · N6491V · Substantial damageNTSB LAX75DUJ59Accident · No injuriesClosedCessna 182J · Tucson, AZDec 28, 1974 · N2783F · Substantial damageNTSB LAX75DUJ48Accident · No injuriesClosedCessna 150 · Phoenix, AZDec 22, 1974 · N7536G · Substantial damageNTSB LAX75FUJ47Accident · 1 fatalClosedCessna 210 · Maricopa, AZDec 17, 1974 · N711PV · DestroyedNTSB LAX75AL032Accident · Serious injuriesClosedBoeing 707 · Phoenix, AZDec 10, 1974 · N7554A · No damageNTSB LAX75DUJ46Accident · No injuriesClosedBellanca 17-30 · Show Low, AZNov 28, 1974 · N6577V · Substantial damageNTSB LAX75FUJ43Accident · No injuriesClosedPiper PA-24 · Phoenix, AZNov 16, 1974 · N8088P · Substantial damageNTSB LAX75DUJ44Accident · No injuriesClosedCessna 172 · Window Rock, AZNov 14, 1974 · N4469R · DestroyedNTSB LAX75AL025Accident · 1 fatalClosedSud Avn SA315B · Springervl, AZNov 7, 1974 · N13583 · DestroyedNTSB LAX75FUJ42Accident · Minor injuriesClosedCessna 310K · Glendale, AZNov 3, 1974 · N7059L · Substantial damageNTSB LAX75DUJ45Accident · No injuriesClosedBrantly B-2 · Mesa, AZNov 2, 1974 · N5905X · Substantial damageNTSB LAX75DUJ39Accident · Minor injuriesClosedCessna 172K · Snowflake, AZOct 31, 1974 · N78469 · DestroyedNTSB LAX75DUJ41Accident · Minor injuriesClosedCessna 182 · Sprngrville, AZOct 26, 1974 · N5706B · DestroyedNTSB LAX75AL021Accident · 2 fatalClosedCessna 172M · Fort Apache, AZOct 22, 1974 · N20673 · DestroyedNTSB LAX75FU537Accident · Serious injuriesClosedDuci Sdwndr · Peoria, AZOct 20, 1974 · N9TD · Substantial damageNTSB LAX75FUJ40Accident · No injuriesClosedCessna 170B · Casa Grande, AZOct 16, 1974 · N4509C · Substantial damageNTSB LAX75DUJ36Accident · No injuriesClosedGrumman G-164A · Roll, AZOct 15, 1974 · N5238 · DestroyedNTSB LAX75DUJ35Accident · No injuriesClosedSanders MM-1 · Phoenix, AZOct 11, 1974 · N3F · Substantial damageNTSB LAX75DUJ38Accident · No injuriesClosedCessna 177RG · Peoria, AZOct 7, 1974 · N80216 · Substantial damageNTSB LAX75DUJ34Accident · No injuriesClosedGrumman G-164 · Aguila, AZOct 3, 1974 · N11AA · DestroyedNTSB LAX75DUJ28Accident · Minor injuriesClosedStinson 108-2 · Rillito, AZSep 29, 1974 · N97595 · Substantial damageNTSB LAX75AL017Accident · 1 fatalClosedCessna 340 · Phoenix, AZSep 27, 1974 · N9950F · DestroyedNTSB LAX75DUJ30Accident · Serious injuriesClosedCessna 188 · Gadson, AZSep 26, 1974 · N9825V · Substantial damageNTSB LAX75DUJ29Accident · Minor injuriesClosedBeech S35 · Rimrock, AZSep 16, 1974 · N6162G · Substantial damageNTSB LAX75FUJ33Accident · Serious injuriesClosedCessna 182 · Phoenix, AZSep 15, 1974 · N3114Q · DestroyedNTSB LAX75FUJ32Accident · No injuriesClosedCessna 188A · Poston, AZSep 8, 1974 · N4464Q · Substantial damageNTSB LAX75DUJ26Accident · No injuriesClosedCessna 182 · Cottonwood, AZSep 6, 1974 · N5813B · Substantial damageNTSB LAX75DUJ25Accident · Serious injuriesClosedAero Comdr S-2D · Willcox, AZSep 4, 1974 · N344AA · DestroyedNTSB LAX75DUJ24Accident · Serious injuriesClosedStinson 108-3 · Grnd Canyon, AZSep 1, 1974 · N4056C · DestroyedNTSB LAX75AL011Accident · 1 fatalClosedPiper PA-22 · Theba, AZSep 1, 1974 · N6099D · Substantial damageNTSB LAX75DUJ31Accident · No injuriesClosedSchweizer SGS232 · Maricopa, AZAug 31, 1974 · N5795S · Substantial damageNTSB LAX75AL010Accident · 2 fatalClosedBeech 95-B55 · Pioneer, AZAug 29, 1974 · N9423Q · DestroyedNTSB LAX75FUJ27Accident · No injuriesClosedMooney M20C · Stanfield, AZAug 25, 1974 · N6756V · Substantial damageNTSB LAX75DUJ23Accident · Serious injuriesClosedSchweizer SGU222 · Phoenix, AZAug 24, 1974 · N2719Z · Substantial damageNTSB LAX75DUJ22Accident · No injuriesClosedGrumman G-164A · Buckeye, AZAug 24, 1974 · N4529 · Substantial damageNTSB LAX75AL008Accident · 2 fatalClosedCessna 310C · Holbrook, AZAug 19, 1974 · N627W · DestroyedNTSB LAX75FUJ21Accident · No injuriesClosedCessna A150L · Marana, AZAug 17, 1974 · N5992J · Substantial damageNTSB LAX75FUJ16Accident · 2 fatalClosedCessna 150K · New River, AZAug 14, 1974 · N5868G · DestroyedNTSB LAX75DUJ18Accident · Minor injuriesClosedCessna T206B · Nogales, AZAug 14, 1974 · N3895G · Substantial damageNTSB LAX75FUJ15Accident · No injuriesClosedCessna 210C · Phoenix, AZAug 11, 1974 · N6595X · Substantial damageNTSB LAX75FUJ20Accident · No injuriesClosedPiper PA-25 · Tucson, AZAug 9, 1974 · N9585P · Substantial damageNTSB LAX75DUJ19Accident · No injuriesClosedNaval Fcty N3N-1 · Queen Creek, AZAug 9, 1974 · N45184 · Substantial damageNTSB LAX75DUJ12Accident · No injuriesClosedErco 415-CD · Wilcox, AZAug 7, 1974 · N3386H · Substantial damageNTSB LAX75FUJ11Accident · No injuriesClosedWittman W-8 · Casa Grande, AZJul 27, 1974 · N3390G · Substantial damageNTSB LAX75DUJ17Accident · No injuriesClosedPiper PA-25 · Stanfield, AZJul 20, 1974 · N7029Z · Substantial damageNTSB LAX75DUJ13Accident · Minor injuriesClosedAero Comdr Lark · Window Rock, AZJul 20, 1974 · N3729X · Substantial damageNTSB LAX75DUJ14Accident · Serious injuriesClosedHiller Acft UH-12E · Gadsden, AZJul 19, 1974 · N62903 · Substantial damageNTSB LAX75DUJ10Accident · Minor injuriesClosedCessna 150 · Chandler, AZJul 13, 1974 · N11941 · Substantial damageNTSB LAX75FUJ09Accident · Serious injuriesClosedPiper PA-28 · Douglas, AZJul 11, 1974 · N8858N · Substantial damageNTSB LAX75FUJ06Accident · No injuriesClosedPiper PA-28 · Surprise, AZJul 11, 1974 · N7425W · Substantial damage