Skip to content

NTSB investigations, 1974

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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
  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.

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
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB ANC75AA048Accident · No injuriesClosedSud Aviatn SA341G · Coldfoot, AKDec 28, 1974 · N18842 · Substantial damage NTSB OAK75AP027Accident · 6 fatalClosedPiper PA-32 · Hlf Moon By, CADec 27, 1974 · N7705J · Destroyed NTSB MIA75DKT50Accident · Minor injuriesClosedCessna 210D · Sanabel Isl, FLDec 27, 1974 · N3764Y · Substantial damage NTSB LAX75FUG24Accident · Serious injuriesClosedAeronca 7BCM · Elsinore, CADec 27, 1974 · N82757 · Destroyed NTSB CHI75AC046Accident · 3 fatalClosedNa Rockwell 265-60 · Lancaster, OHDec 27, 1974 · N920G · Destroyed NTSB ANC75AA047Accident · 1 fatalClosedPiper PA-18 · Anchorage, AKDec 27, 1974 · N9902D · Destroyed NTSB SEA75AS028Accident · 4 fatalClosedBrittnorman BN-2A · Riverton Hts, WADec 26, 1974 · N66HA · Destroyed NTSB OAK75DVD28Accident · Minor injuriesClosedCessna 182 · Santa Rosa, CADec 26, 1974 · N182CT · Substantial damage NTSB NYC75FNA28Accident · No injuriesClosedPiper PA-28 · Norwood, MADec 26, 1974 · N635FL · Substantial damage NTSB NYC75DHD28Accident · No injuriesClosedPiper PA-32 · West Chester, PADec 26, 1974 · N56982 · Substantial damage NTSB MIA75AM039Accident · No injuriesClosedGrumman G-73 · Miami, FLDec 26, 1974 · N7306 · Substantial damage NTSB FTW75DRD21Accident · No injuriesClosedPiper PA-28 · Lockport, LADec 26, 1974 · N5413S · Substantial damage NTSB CHI75FEC30Accident · No injuriesClosedMaule M4220C · Ann Arbor, MIDec 26, 1974 · N51161 · Substantial damage NTSB CHI75DEE34Accident · No injuriesClosedCessna 150L · Morris, ILDec 26, 1974 · N18042 · Substantial damage NTSB OAK75FVG42Accident · No injuriesClosedCessna 150 · Chico, CADec 25, 1974 · N3315J · Destroyed NTSB MIA75DLD44Accident · Minor injuriesClosedBeech B50 · Tampa, FLDec 25, 1974 · N4862T · Substantial damage NTSB IAD75FLJ16Accident · Minor injuriesClosedCessna 150L · Burlington, NCDec 25, 1974 · N5274Q · Substantial damage NTSB FTW75FPM09Accident · No injuriesClosedPiper PA-24 · Tulsa, OKDec 25, 1974 · N5008P · Substantial damage NTSB FTW75DPD21Accident · No injuriesClosedBellanca 7GCBC · Cross Plains, TXDec 25, 1974 · N9182L · Substantial damage NTSB CHI75DEC29Accident · No injuriesClosedMcculloch J2 · Otisville, MIDec 25, 1974 · N4384 · Substantial damage NTSB ANC75DAG62Accident · No injuriesClosedCessna 120 · Kodiak, AKDec 25, 1974 · N77429 · Substantial damage NTSB MKC75AK033Accident · 3 fatalClosedPiper PA-28 · Swedeborg, MODec 24, 1974 · N6698J · Substantial damage NTSB IAD75DI213Accident · No injuriesClosedEnstrom F-28A · Willow Is, WVDec 24, 1974 · N9278 · Substantial damage NTSB DEN75FTE42Accident · Minor injuriesClosedAmer Avco AA5 · Ward, CODec 24, 1974 · CF-FGZ · Destroyed NTSB DEN75AD035Accident · 1 fatalClosedCessna 182B · Naturita, CODec 24, 1974 · N2493G · Destroyed NTSB CHI75FEE36Accident · No injuriesClosedTemco D16A · Hebron, ILDec 24, 1974 · N719T · Substantial damage NTSB CHI75DEP38Accident · No injuriesClosedCessna 150H · Wilmot, WIDec 24, 1974 · N50169 · Substantial damage NTSB NYC75FHD27Accident · Minor injuriesClosedErco 415-C · West Chester, PADec 23, 1974 · N99907 · Substantial damage NTSB NYC75AN075Accident · Minor injuriesClosedCessna 182 · Vinalhaven, MEDec 23, 1974 · N8818T · Substantial damage NTSB MKC75FCG25Accident · No injuriesClosedAero Comdr 560 · Lees Summit, MODec 23, 1974 · N2730B · Substantial damage NTSB MKC75FCG24Accident · Minor injuriesClosedBeech P35 · Leawood, KSDec 23, 1974 · N1582S · Substantial damage NTSB MIA75AM038Accident · 1 fatalClosedPiper PA-24 · Mobile, ALDec 23, 1974 · N9168P · Destroyed NTSB FTW75FRD22Accident · No injuriesClosedAero Comdr 500-B · New Orleans, LADec 23, 1974 · N99JG · Substantial damage NTSB FTW75AF043Accident · 3 fatalClosedBeech 35 · Vidor, TXDec 23, 1974 · N80463 · Destroyed NTSB CHI75FEI34Accident · No injuriesClosedCessna 172M · Bowlng Green, OHDec 23, 1974 · N1691V · Substantial damage NTSB CHI75DEE37Accident · No injuriesClosedPiper PA-23 · Monee, ILDec 23, 1974 · N2207P · Substantial damage NTSB CHI75DEE35Accident · No injuriesClosedCessna 150 · Richton Park, ILDec 23, 1974 · N7137F · Substantial damage NTSB OAK75DXQ32Accident · No injuriesClosedCessna 172 · Truckee, CADec 22, 1974 · N1460V · Substantial damage NTSB OAK75AP026Accident · 8 fatalClosedCessna 414 · Chester, CADec 22, 1974 · N414ZM · Destroyed NTSB MKC75FCD27Accident · Serious injuriesClosedAeronca 7AC · Graf, IADec 22, 1974 · N85697 · Substantial damage NTSB MKC75D1G16Accident · No injuriesClosedPiper J3C-65 · Esmond, NDDec 22, 1974 · N98755 · Substantial damage NTSB MIA75FKT36Accident · 1 fatalClosedBoeing B75N1 · Florida City, FLDec 22, 1974 · N9826H · Substantial damage NTSB MIA75DKT35Accident · No injuriesClosedCessna 172L · Hollywood, FLDec 22, 1974 · N4393Q · Substantial damage NTSB LAX75DUJ48Accident · No injuriesClosedCessna 150 · Phoenix, AZDec 22, 1974 · N7536G · Substantial damage NTSB CHI75FEI36Accident · Minor injuriesClosedPiper PA-32 · Akron, OHDec 22, 1974 · N56754 · Substantial damage NTSB CHI75FEI35Accident · Minor injuriesClosedCessna 150 · Flushing, OHDec 22, 1974 · N22768 · Substantial damage NTSB OAK75FVW11Accident · No injuriesClosedMooney M20C · Las Vegas, NVDec 21, 1974 · N6563U · Substantial damage NTSB OAK75DXQ31Accident · Minor injuriesClosedCessna 182 · Mammoth Lks, CADec 21, 1974 · N3408U · Substantial damage NTSB OAK75AP025Accident · 1 fatalClosedBell 47G3B1 · Auburn, CADec 21, 1974 · N409RG · Destroyed NTSB NYC75FHM13Accident · Minor injuriesClosedAvion Mudry CAP10B · Verbank, NYDec 21, 1974 · N80DE · Destroyed