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 FTW80FA014Accident · 2 fatalClosedCessna 152 · Lillian, TXNov 17, 1979 · N7611B · Destroyed NTSB FTW80DQD02Accident · No injuriesClosedCessna 150 · Fort Stockton, TXNov 17, 1979 · N6383K · Substantial damage NTSB FTW80DA016Accident · No injuriesClosedScorpion II · Bay City, TXNov 17, 1979 · NONE · Substantial damage NTSB DEN80FTM06Accident · Minor injuriesClosedPiper PA-38 · Ogden, UTNov 17, 1979 · N2440N · Substantial damage NTSB DEN80FTE08Accident · Minor injuriesClosedSkybolt Newlnd · Fort Collins, CONov 17, 1979 · N24GN · Destroyed NTSB NYC80FNE02Accident · No injuriesClosedLake LA-4 · Griswold, CTNov 16, 1979 · N1164L · Substantial damage NTSB NYC80FA010Accident · 3 fatalClosedAerostar 601P · Charlstadt, NJNov 16, 1979 · N8099J · Destroyed NTSB MKC80FA005Accident · 1 fatalClosedCessna 150D · Stet, MONov 16, 1979 · N7999Z · Destroyed NTSB MKC79FA006Accident · 1 fatalClosedPazmany PL-2 · Olathe, KSNov 16, 1979 · N72KA · Minor damage NTSB MIA80FKJ10Accident · Minor injuriesClosedPiper PA-38 · Stevenson, ALNov 16, 1979 · N2448C · Substantial damage NTSB LAX80FA014Accident · 3 fatalClosedCessna 182Q · Livermore, CANov 16, 1979 · N97430 · Destroyed NTSB LAX80FA013Accident · 2 fatalClosedPiper PA-28 · Livermore, CANov 16, 1979 · N2962C · Destroyed NTSB LAX80DVG07Accident · No injuriesClosedCessna 401 · Colusa, CANov 16, 1979 · N3184K · Substantial damage NTSB LAX80DVG06Accident · Minor injuriesClosedAero Comdr 100 · Napa, CANov 16, 1979 · N3689X · Destroyed NTSB IAD80FLJ03Accident · Serious injuriesClosedPiper PA-28 · Kenly, NCNov 16, 1979 · N5565W · Destroyed NTSB DEN80DTE06Accident · No injuriesClosedBellanca 14-19 · Center, CONov 16, 1979 · N8525R · Substantial damage NTSB DCA80AA021Accident · FatalClosedMartin 404 · Tusayan, AZNov 16, 1979 · N40438 · Destroyed NTSB CHI80FEG04Accident · No injuriesClosedBell 47G5 · Dayton, OHNov 16, 1979 · N2271W · Substantial damage NTSB CHI80FEE07Accident · No injuriesClosedPiper PA-24 · Chicago, ILNov 16, 1979 · N7058P · Substantial damage NTSB NYC80DGT02Accident · No injuriesClosedCessna 172 · Gaines, PANov 15, 1979 · N12912 · Substantial damage NTSB MKC80DCA01Accident · No injuriesClosedCessna 150L · Willow Springs, MONov 15, 1979 · N7137G · Substantial damage NTSB MIA80DLD11Accident · Minor injuriesClosedCessna 182 · Ocala, FLNov 15, 1979 · N52742 · Substantial damage NTSB MIA80DKJ13Accident · No injuriesClosedAeronca 11AC · Cottondale, ALNov 15, 1979 · N9180E · Substantial damage NTSB LAX80FVW05Accident · No injuriesClosedCessna 150B · Boulder City, NVNov 15, 1979 · N1162Y · Substantial damage NTSB IAD80FA010Accident · Serious injuriesClosedCessna 172N · Vienna, VANov 15, 1979 · N739TJ · Substantial damage NTSB ANC80FA012Accident · 1 fatalClosedPiper PA-20 · Palmer, AKNov 15, 1979 · N9710D · Substantial damage NTSB SEA80IA006Incident · No injuriesClosedBeech 99 · Yakima, WANov 14, 1979 · N8012R · Minor damage NTSB SEA80FYM05Accident · Minor injuriesClosedCessna R172E · Grass Valley, IDNov 14, 1979 · N14465 · Destroyed NTSB MKC80FCG02Accident · No injuriesClosedBeech 58 · Kansas City, MONov 14, 1979 · N7347R · Substantial damage NTSB LAX80FVD02Accident · No injuriesClosedBeech 95-55 · Livermore, CANov 14, 1979 · N1304Z · Substantial damage NTSB LAX80FUG07Accident · Minor injuriesClosedBeech D18S · Corona, CANov 14, 1979 · N8611A · Destroyed NTSB LAX80DVG05Accident · No injuriesClosedPiper PA-30 · Fair Oaks, CANov 14, 1979 · N7915Y · Substantial damage NTSB LAX80DUJ03Accident · Minor injuriesClosedPiper PA-28 · Winslow, AZNov 14, 1979 · N6332J · Substantial damage NTSB FTW80IA013Incident · No injuriesClosedAerospatle AS350D · Mansfield, TXNov 14, 1979 · N3596Z · No damage NTSB FTW80DPJ35Accident · No injuriesClosedCessna 120 · Leedey, OKNov 14, 1979 · N90085 · Substantial damage NTSB DEN80FQG02Accident · No injuriesClosedCessna 421 · Elida, NMNov 14, 1979 · N421BH · Substantial damage NTSB ANC80DA009Accident · No injuriesClosedCessna 185 · Cantwell, AKNov 14, 1979 · N2660S · Substantial damage NTSB SEA80DYE08Accident · Serious injuriesClosedPiper PA-18 · Lynnwood, WANov 13, 1979 · N4122E · Substantial damage NTSB MIA80FKA01Accident · No injuriesClosedCessna 188 · Sabana, PRNov 13, 1979 · N53374 · Substantial damage NTSB LAX80DUM05Accident · No injuriesClosedAero Comdr S2R · Calipatria, CANov 13, 1979 · N8970Q · Substantial damage NTSB DEN80DTE05Accident · No injuriesClosedCessna 185 · Greeley, CONov 13, 1979 · N4742E · Substantial damage NTSB DEN80DQA09Accident · No injuriesClosedStearman B-75 · Gallup, NMNov 13, 1979 · N55692 · Minor damage NTSB CHI80FET03Accident · No injuriesClosedCessna 172M · Mentone, INNov 13, 1979 · N5111Q · Substantial damage NTSB SEA80FA005Accident · 3 fatalClosedCessna T310R · Salem, ORNov 12, 1979 · N1316G · Destroyed NTSB LAX80DUQ04Accident · No injuriesClosedPiper PA-32 · Avalon, CANov 12, 1979 · N1555Z · Substantial damage NTSB LAX80DUJ18Accident · No injuriesClosedPiper PA-22 · Bullhead City, AZNov 12, 1979 · N9009D · Substantial damage NTSB FTW80IA012Incident · No injuriesClosedCessna 500 · Dallas, TXNov 12, 1979 · N40JF · Minor damage NTSB CHI80DEE05Accident · Minor injuriesClosedCessna 150L · Freeport, ILNov 12, 1979 · N10056 · Substantial damage NTSB UNK80X0102Accident · 1 fatalClosedPiper PA-28 · Melvin, IANov 11, 1979 · N2181D · Destroyed NTSB SEA80DYP04Accident · No injuriesClosedCessna 182 · Dixie, IDNov 11, 1979 · N8971G · Substantial damage