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 FTW80FA019Accident · 1 fatalClosedMitsubishi MU-2B · Post Oak, TXNov 26, 1979 · N234MA · Destroyed NTSB FTW80DPG05Accident · No injuriesClosedPiper PA-28 · Cherokee Vlg, ARNov 26, 1979 · N9681K · Substantial damage NTSB NYC80FGM08Accident · No injuriesClosedLake LA4200 · New Castle, PANov 25, 1979 · C-GLOV · Substantial damage NTSB MKC80FCA02Accident · Serious injuriesClosedYoung-Owens Cassut · Valles Mines, MONov 25, 1979 · N67Y · Substantial damage NTSB MKC80FA010Accident · 6 fatalClosedPiper PA-23 · Columbus, NENov 25, 1979 · N6496Y · Destroyed NTSB MKC80DER13Accident · No injuriesClosedBellanca 7ECA · St James, MNNov 25, 1979 · N41689 · Substantial damage NTSB MIA80FLA08Accident · Minor injuriesClosedPiper PA-31 · Jacksonville, FLNov 25, 1979 · N20KA · Destroyed NTSB MIA80FKG11Accident · No injuriesClosedBeech 58 · Atlanta, GANov 25, 1979 · N66839 · Substantial damage NTSB MIA80FA014Accident · 4 fatalClosedPiper PA-32R · Anniston, ALNov 25, 1979 · N5RJ · Destroyed NTSB LAX80FVD0OAccident · No injuriesClosedBellanca 7GCBC · Fremont, CANov 25, 1979 · N5518K · Substantial damage NTSB LAX80FA018Accident · 5 fatalClosedCessna 180H · Weaverville, CANov 25, 1979 · N7984V · Destroyed NTSB LAX80FA011Accident · 3 fatalClosedBeech V35B · Delta, OHNov 25, 1979 · N3949A · Destroyed NTSB LAX80DJA05Accident · No injuriesClosedCessna 152 · Hololulu, HINov 25, 1979 · N46151 · Destroyed NTSB IAD80FA014Accident · 4 fatalClosedPiper PA-32 · Davis, WVNov 25, 1979 · N3409W · Destroyed NTSB IAD80FA013Accident · 1 fatalClosedPiper PA-23 · Locust Grove, VANov 25, 1979 · N7650D · Destroyed NTSB IAD80FA012Accident · 1 fatalClosedBellanca 8KCAB · Churchton, MDNov 25, 1979 · N444HG · Destroyed NTSB FTW80IA018Incident · 1 fatalClosedLockheed L-1011 · Mineral Wells, TXNov 25, 1979 · N714DA · No damage NTSB FTW80DRA10Accident · No injuriesClosedCessna 172K · Arcola, TXNov 25, 1979 · N79573 · Substantial damage NTSB CHI80FEV10Accident · No injuriesClosedMooney M20K · Lacon, ILNov 25, 1979 · N231FD · Substantial damage NTSB CHI80FEM07Accident · No injuriesClosedSpezio CB-2 · Marne, MINov 25, 1979 · N18822 · Substantial damage NTSB CHI80FEE08Accident · Minor injuriesClosedBeech 76 · West Chicago, ILNov 25, 1979 · N6038Y · Substantial damage NTSB CHI80FA012Accident · 3 fatalClosedCessna 210L · Fort Wayne, INNov 25, 1979 · N2034S · Destroyed NTSB CHI80FA010Accident · 1 fatalClosedCessna 150 · Wilmington, OHNov 25, 1979 · N8820S · Destroyed NTSB CHI80DEV09Accident · No injuriesClosedBeech A23-19 · Pittsfield, ILNov 25, 1979 · N3618Q · Substantial damage NTSB NYC80FNE05Accident · Minor injuriesClosedSchweizer SGS233 · Terryville, CTNov 24, 1979 · N2930H · Substantial damage NTSB NYC80FHJ04Accident · Serious injuriesClosedEnstrom F28C · Oakdale, NYNov 24, 1979 · N642H · Substantial damage NTSB NYC80FGT03Accident · No injuriesClosedPiper PA-28R · Still Creek, PANov 24, 1979 · N4524T · Substantial damage NTSB MKC80FER12Accident · No injuriesClosedCessna 152 · Minneapolis, MNNov 24, 1979 · N5461B · Substantial damage NTSB MIA80RA013Accident · Serious injuriesClosedConvair 440 · Freeport, Burkina FasoNov 24, 1979 · N444JM · Substantial damage NTSB MIA80DLA07Accident · No injuriesClosedAeronca 7BCM · Tallahassee, FLNov 24, 1979 · N75369 · Substantial damage NTSB LAX80FA020Accident · 3 fatalClosedPiper PA-24 · Alturas, CANov 24, 1979 · N5664P · Destroyed NTSB LAX80FA017Accident · 3 fatalClosedCessna 182R · Napa, CANov 24, 1979 · N2681C · Destroyed NTSB LAX80DXQ11Accident · No injuriesClosedBell 47G3B1 · Mina, NVNov 24, 1979 · N11102 · Substantial damage NTSB FTW80FPJ04Accident · No injuriesClosedCessna 172K · Norman, OKNov 24, 1979 · N84907 · Substantial damage NTSB FTW80DRD03Accident · No injuriesClosedCessna 185 · Morgan City, LANov 24, 1979 · N51BC · Substantial damage NTSB CHI80FEP06Accident · No injuriesClosedCessna 172 · Portage, WINov 24, 1979 · N1468V · Substantial damage NTSB ANC80FA015Accident · 1 fatalClosedBell 47G3B1 · Farewell, AKNov 24, 1979 · N73249 · Substantial damage NTSB SEA80FYM06Accident · Minor injuriesClosedCessna 152 · Newberg, ORNov 23, 1979 · N67500 · Substantial damage NTSB SEA80FA008Accident · 2 fatalClosedNavion A · Kent, WANov 23, 1979 · N4804K · Destroyed NTSB MKC80FA009Accident · 1 fatalClosedMooney M-20J · Coffeyville, KSNov 23, 1979 · N201UP · Destroyed NTSB MKC80DCJ17Accident · No injuriesClosedCessna 185F · Lyons, NENov 23, 1979 · N80873 · Substantial damage NTSB MKC80DCJ03Accident · Minor injuriesClosedNavion B · Norfolk, NENov 23, 1979 · N5177K · Substantial damage NTSB MIA80DLD18Accident · No injuriesClosedSchweizer SGS135 · Lakeland, FLNov 23, 1979 · N34185 · Substantial damage NTSB MIA80DLD15Accident · Serious injuriesClosedJantar STD SZD-41 · Winter Haven, FLNov 23, 1979 · N60AS · Substantial damage NTSB LAX80DXQ15Accident · No injuriesClosedPiper PA-28R · Wendover, UTNov 23, 1979 · N38398 · Substantial damage NTSB LAX80DUM06Accident · No injuriesClosedBeech B35 · Yuma, AZNov 23, 1979 · N5116C · Substantial damage NTSB LAX80DUJ10Accident · No injuriesClosedCessna 182 · Scottsdale, AZNov 23, 1979 · N92844 · Substantial damage NTSB IAD80DID03Accident · No injuriesClosedPiper PA-28 · Charlottesvlle, VANov 23, 1979 · N55811 · Substantial damage NTSB FTW80DPG04Accident · Minor injuriesClosedPiper PA-12 · Pine Bluff, ARNov 23, 1979 · N2315M · Destroyed NTSB DEN80FTE09Accident · 1 fatalClosedWoody Push WAS-2 · Rocky Ford, CONov 23, 1979 · N8450 · Substantial damage