Skip to content

NTSB investigations, 1976

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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") = 1976 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\") = 1976
  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") = 1976
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 LAX77DVM04Accident · Minor injuriesClosedPiper PA-28 · Paso Robles, CADec 27, 1976 · N440FL · Substantial damage NTSB FTW77DPG12Accident · No injuriesClosedThorp T-18 · Dumas, ARDec 27, 1976 · N18TM · Substantial damage NTSB CHI77FEP12Accident · Serious injuriesClosedPiper PA-30A · Madison, WIDec 27, 1976 · N7184Y · Destroyed NTSB NYC77IA024Incident · No injuriesClosedDouglas DC-10 · Jamicia, NYDec 26, 1976 · XA-DUG · Minor damage NTSB NYC77FHM07Accident · 1 fatalClosedBeech M35 · Flanders, NJDec 26, 1976 · N9573R · Substantial damage NTSB LAX77FUG20Accident · No injuriesClosedKR 1 · Chino, CADec 26, 1976 · N65117 · Substantial damage NTSB LAX77FA016Accident · 1 fatalClosedErco 415-C · Murrieta, CADec 26, 1976 · N87406 · Destroyed NTSB DEN77FQA08Accident · Minor injuriesClosedPiper PA-28 · Albuquerque, NMDec 26, 1976 · N7585R · Substantial damage NTSB DEN77FA014Accident · 2 fatalClosedBellanca 7GCBC · Clovis, NMDec 26, 1976 · N86942 · Destroyed NTSB NYC77FGT05Accident · No injuriesClosedCessna 150 · Philipsburg, PADec 25, 1976 · N3788J · Destroyed NTSB MKC77FA009Accident · 2 fatalClosedPiper PA-28R · Kadoka, SDDec 25, 1976 · N2943R · Destroyed NTSB MKC77DCQ12Accident · No injuriesClosedCessna 172 · Alma, KSDec 25, 1976 · N3563S · Substantial damage NTSB MKC77DCQ11Accident · Minor injuriesClosedCessna 150 · Emporia, KSDec 25, 1976 · N6306K · Substantial damage NTSB MIA77FA020Accident · 3 fatalClosedBeech B95A · Panacea, FLDec 25, 1976 · N22RL · Destroyed NTSB CHI77FA018Accident · 3 fatalClosedPiper PA-28 · Columbia City, INDec 25, 1976 · N1510J · Destroyed NTSB MKC77DER11Accident · No injuriesClosedCessna 150 · Austin, MNDec 24, 1976 · N50313 · Substantial damage NTSB MKC77DER10Accident · No injuriesClosedCessna 180 · White Bear Lk, MNDec 24, 1976 · N9105C · Substantial damage NTSB MIA77DLD20Accident · No injuriesClosedCessna 150 · Vero Beach, FLDec 24, 1976 · N18594 · Substantial damage NTSB MIA77DKG10Accident · No injuriesClosedCessna 150F · Elberton, GADec 24, 1976 · N7804F · Substantial damage NTSB IAD77DID10Accident · No injuriesClosedCessna 150 · Emporia, VADec 24, 1976 · N6260G · Substantial damage NTSB FTW77FRD04Accident · Serious injuriesClosedPiper PA-22 · Port Sulphur, LADec 24, 1976 · N644A · Substantial damage NTSB FTW77DPG13Accident · No injuriesClosedCessna 150 · Mt.Home, ARDec 24, 1976 · N66094 · Substantial damage NTSB CHI77FEP13Accident · No injuriesClosedPiper PA-28 · Cable, WIDec 24, 1976 · N210KB · Substantial damage NTSB ANC77DAD02Accident · No injuriesClosedCessna 180 · Juneau, AKDec 24, 1976 · N3449Y · Substantial damage NTSB FTW77FA024Accident · 1 fatalClosedBeech :50 · Mcallen, TXDec 23, 1976 · N30AM · Destroyed NTSB FTW77DPG14Accident · No injuriesClosedCessna 150 · El Dorado, ARDec 23, 1976 · N8430J · Substantial damage NTSB CHI77FA017Accident · 1 fatalClosedPiper PA-23 · North Royalton, OHDec 23, 1976 · N2264P · Destroyed NTSB OAK77FA009Accident · 1 fatalClosedCessna 172M · Empire, NVDec 22, 1976 · N12364 · Destroyed NTSB MKC77FCA06Accident · No injuriesClosedCessna 172K · Fenton, MODec 22, 1976 · N46694 · Substantial damage NTSB IAD77DLQ04Accident · Minor injuriesClosedCessna 150 · Trenton, KYDec 22, 1976 · N11269 · Destroyed NTSB IAD77DKW10Accident · Minor injuriesClosedErco 415CD · Rockwood, TNDec 22, 1976 · N94706 · Substantial damage NTSB FTW77FRG20Accident · No injuriesClosedLake LA-4 · San Antonio, TXDec 22, 1976 · N2036L · Substantial damage NTSB FTW77FPD06Accident · Minor injuriesClosedCessna 172 · Henrietta, TXDec 22, 1976 · N6972A · Substantial damage NTSB FTW77DRG21Accident · Minor injuriesClosedCessna 150 · Mason, TXDec 22, 1976 · N4808X · Substantial damage NTSB CHI77FEI07Accident · No injuriesClosedPiper PA-30 · North Benton, OHDec 22, 1976 · N8084Y · Substantial damage NTSB NYC77FHJ08Accident · No injuriesClosedCessna 182 · White Plains, NYDec 21, 1976 · N71520 · Substantial damage NTSB NYC77FA023Accident · Serious injuriesClosedConvair 580 · Bradford, PADec 21, 1976 · N5811 · No damage NTSB NYC77FA022Accident · 2 fatalClosedPiper PA-23 · Danvers, MADec 21, 1976 · N66HR · Destroyed NTSB LAX77FUQ13Accident · Minor injuriesClosedCessna 177B · Burbank, CADec 21, 1976 · N34100 · Substantial damage NTSB LAX77DUJ15Accident · No injuriesClosedCessna 120 · Salome, AZDec 21, 1976 · N120Y · Substantial damage NTSB IAD77DIA07Accident · No injuriesClosedCessna 172 · Chantilly, VADec 21, 1976 · N64094 · Substantial damage NTSB FTW77FQG06Accident · No injuriesClosedN. American TB-25N · Vega, TXDec 21, 1976 · N3680G · Substantial damage NTSB CHI77DEP11Accident · No injuriesClosedPiper PA-22 · West Bend, WIDec 21, 1976 · N5835Z · Substantial damage NTSB SEA77DYP15Accident · No injuriesClosedCessna 170B · Lewiston, IDDec 20, 1976 · N2392D · Substantial damage NTSB NYC77FHA09Accident · Minor injuriesClosedPiper PA-28 · Claussville, PADec 20, 1976 · N75269 · Substantial damage NTSB NYC77FGM07Accident · No injuriesClosedCessna 340 · Belle Vernon, PADec 20, 1976 · N1388G · Substantial damage NTSB SEA77FYC11Accident · No injuriesClosedCessna 310B · Orchards, WADec 19, 1976 · N5455A · Substantial damage NTSB OAK77FVG16Accident · Serious injuriesClosedGrum Amer AA1A · Willows, CADec 19, 1976 · N6321L · Substantial damage NTSB OAK77FA008Accident · 2 fatalClosedCessna 150G · Escalon, CADec 19, 1976 · N2630J · Destroyed NTSB MIA77FKG12Accident · Serious injuriesClosedPiper J3 · Greensboro, GADec 19, 1976 · N42595 · Destroyed