Skip to content

NTSB investigations, 1979

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 LAX80FVM10Accident · No injuriesClosedBeech 65-90 · Monterey, CADec 23, 1979 · N700S · Substantial damage NTSB LAX80FVD07Accident · Minor injuriesClosedBeech B24R · Cloverdale, CADec 23, 1979 · N6991R · Destroyed NTSB LAX80DUG14Accident · Serious injuriesClosedCessna 182 · Needles, CADec 23, 1979 · N52315 · Substantial damage NTSB LAX80DA028Accident · No injuriesClosedCessna 172N · Elko, NVDec 23, 1979 · N738JL · 2 aircraft · Substantial damage NTSB FTW80DRJ08Accident · No injuriesClosedPiper PA-28 · Lufkin, TXDec 23, 1979 · N32639 · Substantial damage NTSB FTW80DRA15Accident · No injuriesClosedBeech 95-55 · Houston, TXDec 23, 1979 · N2155L · Substantial damage NTSB FTW80DQG07Accident · No injuriesClosedCessna 172 · Spearman, TXDec 23, 1979 · N2662U · Substantial damage NTSB DEN80FTC03Accident · Minor injuriesClosedBeech B95A · Rock Springs, WYDec 23, 1979 · N6DM · Destroyed NTSB DEN80FA014Accident · 1 fatalClosedPiper PA-23 · Grand Lake, CODec 23, 1979 · N2013P · Substantial damage NTSB SEA80FYE10Accident · Minor injuriesClosedHughes 369D · Mt.Vernon, WADec 22, 1979 · N8303F · Substantial damage NTSB MKC80FCD09Accident · No injuriesClosedCessna 177RG · Greenfield, IADec 22, 1979 · N52195 · Substantial damage NTSB MKC80FA016Accident · 1 fatalClosedCessna 150G · Anthony, KSDec 22, 1979 · N8409J · Destroyed NTSB MKC80DTK07Accident · Serious injuriesClosedRaven RX-7 · Chancellor, SDDec 22, 1979 · N2910R · No damage NTSB MIA80FA022Accident · 4 fatalClosedBeech E18S · Orlando, FLDec 22, 1979 · N198B · Destroyed NTSB LAX80FA031Accident · 2 fatalClosedBellanca 8KCAB · San Fernando, CADec 22, 1979 · N5032K · Substantial damage NTSB LAX80DJA07Accident · Minor injuriesClosedGrum Amer AA-5A · Honolulu, HIDec 22, 1979 · N9796U · Destroyed NTSB FTW80FPD07Accident · No injuriesClosedCessna 120 · Lawn, TXDec 22, 1979 · N44BM · Substantial damage NTSB FTW80FA028Accident · 2 fatalClosedBeech 65-90 · Leeville, LADec 22, 1979 · N724N · Destroyed NTSB DEN80FA013Accident · 1 fatalClosedRockwell 500B · Santa Fe, NMDec 22, 1979 · N6194X · Destroyed NTSB DEN80DQD04Accident · No injuriesClosedCessna 210 · Animas, NMDec 22, 1979 · N761JE · Substantial damage NTSB UNK80X0103Accident · No injuriesClosedBeech A23 · Pocahontas, ARDec 21, 1979 · N5678S · Substantial damage NTSB SEA80FTA06Accident · No injuriesClosedCessna 210M · Glendive, MTDec 21, 1979 · N8197M · Substantial damage NTSB SEA80DYA05Accident · No injuriesClosedMooney M20E · Burley, IDDec 21, 1979 · N1306W · Substantial damage NTSB NYC80FNC05Accident · Serious injuriesClosedCessna 180 · Turner, MEDec 21, 1979 · N6417X · Substantial damage NTSB MKC80FA015Accident · 1 fatalClosedCessna 152 · Olathe, KSDec 21, 1979 · N25494 · Destroyed NTSB MKC80DCQ09Accident · No injuriesClosedCessna 210 · Hutchinson, KSDec 21, 1979 · N5470C · Substantial damage NTSB MIA80FA021Accident · 5 fatalClosedPiper PA-32 · Woodbine, GADec 21, 1979 · N3802W · Destroyed NTSB MIA80DKJ14Accident · No injuriesClosedCessna 152 · Huntsville, ALDec 21, 1979 · N67340 · Substantial damage NTSB MIA80DA023Accident · 4 fatalClosedPiper PA-23 · Missing AircraftDec 21, 1979 · N1435P · Destroyed NTSB LAX80FA027Accident · 5 fatalClosedCessna 172M · Lebec, CADec 21, 1979 · N6714H · Destroyed NTSB IAD80DLQ06Accident · No injuriesClosedCessna 172F · Corbin, KYDec 21, 1979 · N8820U · Substantial damage NTSB FTW80FA027Accident · 1 fatalClosedCessna 172H · Moshiem, TXDec 21, 1979 · N1792F · Destroyed NTSB FTW80FA026Accident · 2 fatalClosedCessna 182E · Comfort, TXDec 21, 1979 · N2853Y · Destroyed NTSB FTW80FA025Accident · 1 fatalClosedCessna 182 · Story, ARDec 21, 1979 · N5393B · Destroyed NTSB FTW80FA024Accident · 4 fatalClosedCessna 421B · Locust Grove, ARDec 21, 1979 · N5428J · Destroyed NTSB DEN80FQA12Accident · Serious injuriesClosedCessna 177B · Vaughn, NMDec 21, 1979 · N16239 · Destroyed NTSB DEN80FA012Accident · 2 fatalClosedMitsubishi MU-2B · Provo, UTDec 21, 1979 · N200BR · Destroyed NTSB CHI80IEP10Accident · No injuriesClosedMooney M20J · Waterloo, WIDec 21, 1979 · N201UW · Substantial damage NTSB CHI80FEC07Accident · No injuriesClosedPiper PA-28 · Owosso, MIDec 21, 1979 · N36700 · Substantial damage NTSB CHI80FA016Accident · 2 fatalClosedCessna 172K · Edwardsville, ILDec 21, 1979 · N736UL · Destroyed NTSB CHI80DA018Accident · 2 fatalClosedBeech B58 · Taylorville, ILDec 21, 1979 · N2058X · Destroyed NTSB CHI80DA017Accident · 2 fatalClosedCessna 310R · Green Bay, WIDec 21, 1979 · N78ST · Destroyed NTSB ANC80IA021Incident · No injuriesClosedCessna 207A · Bethel, AKDec 21, 1979 · N7605U · No damage NTSB ANC80DAG20Accident · No injuriesClosedPiper PA-18 · King Salmon, AKDec 21, 1979 · N4368Z · Substantial damage NTSB SEA80FTA05Accident · No injuriesClosedPiper PA-22 · Laurel, MTDec 20, 1979 · N7403D · Substantial damage NTSB MKC80DCQ08Accident · No injuriesClosedCessna 170B · Kingman, KSDec 20, 1979 · N3050A · Substantial damage NTSB MIA80FLD22Accident · No injuriesClosedPiper PA-28 · Tampa, FLDec 20, 1979 · N16EC · Substantial damage NTSB LAX80FA114Accident · 2 fatalClosedPiper PA-32R · Safford, AZDec 20, 1979 · N9877K · Destroyed NTSB LAX80DXQ12Accident · Minor injuriesClosedCessna T2101 · Yerington, NVDec 20, 1979 · N2227S · Substantial damage NTSB FTW80FRG15Accident · Minor injuriesClosedPiper PA-32 · Encinal, TXDec 20, 1979 · N607LJ · Destroyed