Skip to content

NTSB investigations, 1979

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") = 1979 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\") = 1979
  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") = 1979
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 MKC80DCA03Accident · No injuriesClosedEnstrom F-28A · St. Louis, MODec 2, 1979 · N4896 · Substantial damage NTSB LAX80FUJ15Accident · No injuriesClosedBeech 95-A55 · Phoenix, AZDec 2, 1979 · N1040T · Substantial damage NTSB LAX80FUJ13Accident · Minor injuriesClosedPiper PA-28 · Yuma, AZDec 2, 1979 · N1773T · Substantial damage NTSB FTW80FQG05Accident · No injuriesClosedPiper PA-31T · San Angelo, TXDec 2, 1979 · N444JW · Destroyed NTSB FTW80DPG06Accident · No injuriesClosedPitts S-1C · N.Little Rock, ARDec 2, 1979 · N77CK · Substantial damage NTSB DEN80FTE10Accident · No injuriesClosedCessna 182 · Longmont, CODec 2, 1979 · N97640 · Substantial damage NTSB ANC80FA016Accident · Serious injuriesClosedLear Jet 24 · Dutch Harbor, AKDec 2, 1979 · N300JA · Destroyed NTSB SEA80FYE09Accident · Serious injuriesClosedCessna 152 · Freeland, WADec 1, 1979 · N48129 · Substantial damage NTSB SEA80FTA04Accident · No injuriesClosedCessna 140 · Malta, MTDec 1, 1979 · N2197N · Substantial damage NTSB MKC80FTK05Accident · No injuriesClosedGrumman AA-5A · Eureka, SDDec 1, 1979 · N26289 · Substantial damage NTSB LAX80FUG09Accident · Serious injuriesClosedBellanca 17-30 · Ontario, CADec 1, 1979 · N7318V · Substantial damage NTSB LAX80DVG08Accident · No injuriesClosedPiper PA-18 · Colusa, CADec 1, 1979 · N2663A · Substantial damage NTSB LAX80DUJ17Accident · No injuriesClosedCessna 120 · Peoria, AZDec 1, 1979 · N4009N · Substantial damage NTSB LAX80DUG10Accident · No injuriesClosedPiper J-2 · El Monte, CADec 1, 1979 · N17579 · Substantial damage NTSB FTW80FPM05Accident · No injuriesClosedCessna 152 · Tulsa, OKDec 1, 1979 · N25475 · Substantial damage NTSB CHI80FA013Accident · 1 fatalClosedCessna 177 · Gary, INDec 1, 1979 · N10412 · Destroyed NTSB ANC80DAA04Accident · Minor injuriesClosedPiper PA-18 · Minto, AKDec 1, 1979 · N8918L · Substantial damage NTSB SEA80FYM07Accident · No injuriesClosedBeech 36 · Hillsboro, ORNov 30, 1979 · N7605N · Substantial damage NTSB MKC80FCD07Accident · No injuriesClosedBeech C35 · Somers, IANov 30, 1979 · N8976A · Substantial damage NTSB IAD80DKM04Accident · No injuriesClosedPiper PA-18 · Asheboro, NCNov 30, 1979 · N75PC · Substantial damage NTSB DEN80DTM07Accident · No injuriesClosedAerospatial SA316B · Provo, UTNov 30, 1979 · N2304P · Substantial damage NTSB CHI80FEE09Accident · No injuriesClosedCessna 182J · Lansing, MINov 30, 1979 · N3059F · Substantial damage NTSB ANC80FA017Accident · 1 fatalClosedCessna 180 · Goose Bay, AKNov 30, 1979 · N2694Y · Destroyed NTSB ANC80DAG17Accident · No injuriesClosedCessna 185F · Anchorage, AKNov 30, 1979 · N1725R · Substantial damage NTSB ANC80DAG15Accident · No injuriesClosedCessna 185 · Lachbuna Lk, AKNov 30, 1979 · N522VA · Substantial damage NTSB NYC80FA014Accident · 1 fatalClosedPiper PA-28 · Watsontown, PANov 29, 1979 · N2916Q · Substantial damage NTSB MIA80FA015Accident · 2 fatalClosedAmer Avco AA1-B · Melbourne, FLNov 29, 1979 · N8971L · Destroyed NTSB LAX80DVD04Accident · No injuriesClosedCessna 188 · Courtland, CANov 29, 1979 · N4722Q · Substantial damage NTSB IAD80FLQ05Accident · No injuriesClosedPiper PA-38 · Louisville, KYNov 29, 1979 · N2459G · Substantial damage NTSB FTW80FRD10Accident · No injuriesClosedSikorsky S-76A · Intracstl City, LANov 29, 1979 · N476AL · Substantial damage NTSB FTW80DRG09Accident · No injuriesClosedBell 47G-5A · Alice, TXNov 29, 1979 · N58132 · Substantial damage NTSB DEN80DTC02Accident · No injuriesClosedPiper PA-28 · Wheatland, WYNov 29, 1979 · N7549W · Substantial damage NTSB CHI80FEP07Accident · Minor injuriesClosedCessna 152 · Madison, WINov 29, 1979 · N714WL · Substantial damage NTSB CHI80FEG05Accident · No injuriesClosedPiper PA-32 · Batavia, OHNov 29, 1979 · N15588 · Substantial damage NTSB SEA80FA009Accident · 2 fatalClosedMooney M20C · Grass Valley, ORNov 28, 1979 · N7090V · Destroyed NTSB NYC80FHJ03Accident · No injuriesClosedPiper PA-28R · Flushing, NYNov 28, 1979 · N4668J · Substantial damage NTSB MKC80FCG03Accident · No injuriesClosedPiper PA-25 · Salisbury, MONov 28, 1979 · N4546Y · Substantial damage NTSB MIA80FKT17Accident · Serious injuriesClosedPiper PA-32 · Miami, FLNov 28, 1979 · N3762W · Destroyed NTSB MIA80DLD17Accident · No injuriesClosedPiper PA-18 · Okeechobee, FLNov 28, 1979 · N6734L · Substantial damage NTSB LAX80DVA05Accident · No injuriesClosedPiper PA-25 · Porterville, CANov 28, 1979 · N9640P · Substantial damage NTSB MKC80FCG07Accident · Minor injuriesClosedPiper PA-18 · Lincoln, MONov 27, 1979 · N82076 · Substantial damage NTSB LAX80FA021Accident · 2 fatalClosedCessna 152 · Flagstaff, AZNov 27, 1979 · N48835 · Destroyed NTSB FTW80DRD05Accident · No injuriesClosedAero-Comdr S2R · Vinton, LANov 27, 1979 · N4857X · Substantial damage NTSB DEN80IA010Incident · No injuriesClosedBeech 95-B55 · Albuquerque, NMNov 27, 1979 · N677K · Minor damage NTSB CHI80DEG06Accident · No injuriesClosedCessna 172N · Hillsboro, OHNov 27, 1979 · N733QJ · Substantial damage NTSB SEA80FYP05Accident · Minor injuriesClosedCessna 150E · Moses Lake, WANov 26, 1979 · N4098U · Substantial damage NTSB SEA80DYA03Accident · No injuriesClosedHiller Acft UH-12E · Stanley, IDNov 26, 1979 · N571H · Substantial damage NTSB NYC80FA013Accident · Serious injuriesClosedCessna U206G · Springbrook, PANov 26, 1979 · N732HT · Destroyed NTSB MIA80FKT16Accident · No injuriesClosedMaule M-5 · Pompano Beach, FLNov 26, 1979 · N5636B · Substantial damage NTSB LAX80DUG08Accident · No injuriesClosedLuscombe 8A · Barstow, CANov 26, 1979 · N1095K · Substantial damage