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 MIA77FKG09Accident · No injuriesClosedPiper PA-30 · Macon, GADec 19, 1976 · N8983Y · Substantial damage NTSB MIA77DKG13Accident · No injuriesClosedGrum Amer AA-5 · Fairmont, GADec 19, 1976 · N71921 · Substantial damage NTSB LAX77DUG16Accident · No injuriesClosedPiper PA-28 · Palm Springs, CADec 19, 1976 · N33378 · Substantial damage NTSB IAD77FIG09Accident · Serious injuriesClosedCurtis MSTNG2 · Mitchelville, MDDec 19, 1976 · N2987 · Destroyed NTSB IAD77FA016Accident · 2 fatalClosedBoeing A75 · Crofton, MDDec 19, 1976 · N63806 · Substantial damage NTSB FTW77FRG19Accident · No injuriesClosedBeech D50 · San Marcos, TXDec 19, 1976 · N13011 · Destroyed NTSB DEN77FA015Accident · 3 fatalClosedGrum Amer AA-1 · Alder, CODec 19, 1976 · N5679L · Destroyed NTSB DCA77AA008Accident · Serious injuriesClosedPiper PA-28 · Baltimore, MDDec 19, 1976 · N6276J · Substantial damage NTSB CHI77FA016Accident · 1 fatalClosedErco 415-C · Palo, MIDec 19, 1976 · N99258 · Destroyed NTSB SEA77FTA05Accident · No injuriesClosedCessna 170A · Ashland, MTDec 18, 1976 · N9142A · Substantial damage NTSB OAK77FA007Accident · 4 fatalClosedBeech H-35 · Vacaville, CADec 18, 1976 · N5458D · Destroyed NTSB NYC77FGT06Accident · No injuriesClosedCessna 177B · Mifflintown, PADec 18, 1976 · N34328 · Substantial damage NTSB NYC77FGM08Accident · No injuriesClosedPiper PA-32 · Ligonier, PADec 18, 1976 · N15852 · Substantial damage NTSB NYC77FFA11Accident · Minor injuriesClosedPiper J-3 · Marlboro, NYDec 18, 1976 · N24565 · Substantial damage NTSB MKC77DTG01Accident · No injuriesClosedCessna 150 · Keene, NDDec 18, 1976 · N8563J · Substantial damage NTSB MIA77FKQ04Accident · No injuriesClosedCessna 182 · Gluckstadt, MSDec 18, 1976 · N5814B · Substantial damage NTSB LAX77FUA03Accident · No injuriesClosedBeech A35 · Avalon, CADec 18, 1976 · N304Q · Destroyed NTSB IAD77FLJ01Accident · Minor injuriesClosedPiper PA-23 · Angier, NCDec 18, 1976 · N1054P · Substantial damage NTSB IAD77FID09Accident · Minor injuriesClosedPiper PA-28 · Chesapeake, VADec 18, 1976 · N1708T · Substantial damage NTSB DEN77FTE11Accident · No injuriesClosedPiper PA-28 · Pueblo, CODec 18, 1976 · N44558 · Substantial damage NTSB DEN77FTE10Accident · No injuriesClosedPiper PA-25 · Broomfield, CODec 18, 1976 · N8749L · Substantial damage NTSB DEN77FQA07Accident · No injuriesClosedBellanca 17-30A · Albuquerque, NMDec 18, 1976 · N8797V · Substantial damage NTSB CHI77FEE08Accident · No injuriesClosedCessna 150 · Wayne, ILDec 18, 1976 · N63406 · Substantial damage NTSB ANC77DA018Accident · 2 fatalClosedCessna A185F · Nondalton, AKDec 18, 1976 · N3464Y · Destroyed NTSB SEA77FA010Accident · Serious injuriesClosedCessna TU206C · Battle Ground, WADec 17, 1976 · N21NW · Destroyed NTSB SEA77FA009Accident · No injuriesClosedHiller Acft FH1100 · Renton, WADec 17, 1976 · N8678 · Substantial damage NTSB MIA77FLA11Accident · No injuriesClosedCessna 188B · St Augustine, FLDec 17, 1976 · N53176 · Destroyed NTSB MIA77FKG11Accident · No injuriesClosedCessna U206A · Palmetto, GADec 17, 1976 · N4819F · Substantial damage NTSB LAX77FUM10Accident · Serious injuriesClosedPiper J5A · Brawley, CADec 17, 1976 · N41SB · Destroyed NTSB IAD77DKM09Accident · No injuriesClosedPiper PA-28R · Bryson City, NCDec 17, 1976 · N333T · Substantial damage NTSB FTW77FA023Accident · 2 fatalClosedPiper PA-28 · El Paso, TXDec 17, 1976 · N7379W · Destroyed NTSB DEN77DTC04Accident · No injuriesClosedPiper PA-12 · Rock Springs, WYDec 17, 1976 · N3277M · Substantial damage NTSB ANC77FA017Accident · Serious injuriesClosedBell 206L · Anchorage, AKDec 17, 1976 · N49723 · Destroyed NTSB OAK7MDJA03Accident · No injuriesClosedMurrayair MA-1 · Keaau, HIDec 16, 1976 · N306MA · Substantial damage NTSB NYC77FNC13Accident · Serious injuriesClosedPiper PA-18 · Millinocket, MEDec 16, 1976 · N1340A · Destroyed NTSB NYC77FGM06Accident · No injuriesClosedBeech C23 · Farmingdale, NYDec 16, 1976 · N2060L · Substantial damage NTSB NYC77DNC12Accident · No injuriesClosedBeech C23 · Frenchville, MEDec 16, 1976 · N2054L · Substantial damage NTSB MKC77IA008Incident · No injuriesClosedPiper PA-28 · Muscatine, IADec 16, 1976 · N6474W · 2 aircraft · Minor damage NTSB MKC77FTK04Accident · No injuriesClosedPiper PA-11 · Lake Preston, SDDec 16, 1976 · N4528M · Substantial damage NTSB MIA77FKJ10Accident · No injuriesClosedPiper PA-24 · Birmingham, ALDec 16, 1976 · N2172M · Substantial damage NTSB MIA77DLG03Accident · No injuriesClosedPiper PA-28 · Liberty, SCDec 16, 1976 · N5272T · Substantial damage NTSB LAX77DUJ21Accident · No injuriesClosedPiper PA-24 · Tucson, AZDec 16, 1976 · N8699P · Substantial damage NTSB IAD77FID08Accident · No injuriesClosedCessna 172 · Richmond, VADec 16, 1976 · N4291L · Substantial damage NTSB DCA77AA007Accident · Serious injuriesClosedConvair 880 · Miami, FLDec 16, 1976 · N5865 · Substantial damage NTSB ANC77DAG19Accident · Minor injuriesClosedCessna 180 · Soldotna, AKDec 16, 1976 · N4742Q · Substantial damage NTSB SEA77DTI05Accident · No injuriesClosedPiper PA-22 · Seeley Lake, MTDec 15, 1976 · N6928D · Substantial damage NTSB NYC77FHM06Accident · Minor injuriesClosedBeech B19 · Ramapo Valley, NYDec 15, 1976 · N1947W · Substantial damage NTSB MIA77FLD19Accident · No injuriesClosedPiper PA-32 · Lake Placid, FLDec 15, 1976 · N32038 · Substantial damage NTSB LAX77PUJ13Accident · No injuriesClosedCessna 150 · Parker, AZDec 15, 1976 · N1040M · Substantial damage NTSB LAX77FA015Accident · 1 fatalClosedPiper PA-23 · Blythe, CADec 15, 1976 · N5590Y · Destroyed