Skip to content

NTSB investigations, 1979

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 FTW80FPJ05Accident · No injuriesClosedPiper PA-38 · Guymon, OKDec 8, 1979 · N4387E · Substantial damage NTSB FTW80DRG14Accident · No injuriesClosedCessna 305 · Fort Hood, TXDec 8, 1979 · N13025 · Substantial damage NTSB FTW80DPA04Accident · No injuriesClosedGrumman G-164 · Lott, TXDec 8, 1979 · N472Y · Substantial damage NTSB SEA80FA011Accident · 2 fatalClosedBeech V35A · Sublett, IDDec 7, 1979 · N7950R · Destroyed NTSB SEA80FA010Accident · 1 fatalClosedCessna 210 · Malad City, IDDec 7, 1979 · N9524T · Destroyed NTSB MKC80FA012Accident · No injuriesClosedAerospatle 319B · Baxter, IADec 7, 1979 · N90825 · Substantial damage NTSB LAX80FUG11Accident · Serious injuriesClosedCessna 172N · La Verne, CADec 7, 1979 · N739JX · Minor damage NTSB LAX80FUA04Accident · Minor injuriesClosedCessna 175 · Huntington Bch, CADec 7, 1979 · N7355M · Substantial damage NTSB IAD80FKM05Accident · Minor injuriesClosedStinson 108-3 · Hendersonville, NCDec 7, 1979 · N930C · Substantial damage NTSB IAD80DID04Accident · No injuriesClosedPiper PA-28 · Lynchburg, VADec 7, 1979 · N6410J · Substantial damage NTSB FTW80FRA12Accident · No injuriesClosedCessna 152 · Eagle Lake, TXDec 7, 1979 · N49190 · Destroyed NTSB FTW80FRA11Accident · Minor injuriesClosedCessna 172N · Houston, TXDec 7, 1979 · N5720E · Substantial damage NTSB FTW80FPJ06Accident · No injuriesClosedBeech J35 · Wellston, OKDec 7, 1979 · N3018C · Substantial damage NTSB FTW80DRG11Accident · No injuriesClosedEnstrom F-28C · Port Mansfield, TXDec 7, 1979 · N51759 · Substantial damage NTSB NYC80FGT04Accident · No injuriesClosedCessna 172RG · Camp Hill, PADec 6, 1979 · N6286R · Substantial damage NTSB MKC80DER15Accident · No injuriesClosedAeronca 11AC · Sacred Heart, MNDec 6, 1979 · N86113 · Substantial damage NTSB MKC80DCG05Accident · No injuriesClosedCessna 152 · Lee'S Summit, MODec 6, 1979 · N24547 · Substantial damage NTSB MIA80FKG12Accident · Minor injuriesClosedCessna 310K · Jesup, GADec 6, 1979 · N6983L · Substantial damage NTSB MIA80FA017Accident · 2 fatalClosedPiper PA-24 · Clearwater, FLDec 6, 1979 · N9095P · Destroyed NTSB LAX80FA022Accident · 2 fatalClosedBeech V35B · Show Low, AZDec 6, 1979 · N1863L · Destroyed NTSB LAX80DUJ16Accident · No injuriesClosedPiper PA-30 · Chandler, AZDec 6, 1979 · N7420Y · Substantial damage NTSB IAD80IA015Incident · No injuriesClosedBeech K35 · Washington, DCDec 6, 1979 · N3077C · Minor damage NTSB FTW80FPA03Accident · No injuriesClosedCessna 172 · Terrell, TXDec 6, 1979 · N7912B · Substantial damage NTSB CHI80FEI09Accident · No injuriesClosedPiper PA-34 · Youngstown, OHDec 6, 1979 · N29257 · Substantial damage NTSB CHI80FEE11Accident · No injuriesClosedPiper PA-30 · Chicago, ILDec 6, 1979 · N7119Y · Substantial damage NTSB ANC80FAD01Accident · No injuriesClosedCessna 185 · Wrangell, AKDec 6, 1979 · N84627 · Substantial damage NTSB ANC80DA019Accident · No injuriesClosedCessna 185 · Akiachak, AKDec 6, 1979 · N70020 · Substantial damage NTSB MIA8OFA016Accident · 2 fatalClosedPiper PA-23 · Pembroke Pines, FLDec 5, 1979 · N6883Y · Destroyed NTSB LAX80FVM08Accident · No injuriesClosedBeech H35 · San Jose, CADec 5, 1979 · N391B · Substantial damage NTSB LAX80FUQ06Accident · Minor injuriesClosedCessna 182 · Piru, CADec 5, 1979 · N7271N · Destroyed NTSB LAX80FUQ05Accident · Minor injuriesClosedCessna 182 · Valencia, CADec 5, 1979 · N92063 · Substantial damage NTSB FTW80FRD09Accident · No injuriesClosedPiper PA-32 · Cameron, LADec 5, 1979 · N321HF · Substantial damage NTSB FTW80FA020Accident · Serious injuriesClosedPiper PA-32 · Harrah, OKDec 5, 1979 · N4097R · Destroyed NTSB DEN80FTE11Accident · No injuriesClosedPiper PA-18 · Englewood, CODec 5, 1979 · N82065 · Substantial damage NTSB CHI80FEC04Accident · No injuriesClosedCessna 172F · Detroit, MIDec 5, 1979 · N8633U · Substantial damage NTSB MKC80FCQ03Accident · No injuriesClosedHughes 269C · Garden City, KSDec 4, 1979 · N7481F · Substantial damage NTSB MKC80DER14Accident · No injuriesClosedCessna 152 · Jackson, MNDec 4, 1979 · N24374 · Substantial damage NTSB FTW80DRG10Accident · No injuriesClosedCessna 150 · Llano, TXDec 4, 1979 · N704YV · Substantial damage NTSB ANC80FA020Accident · 2 fatalClosedPiper PA-18 · Grayling, AKDec 4, 1979 · N4325Z · Substantial damage NTSB ANC80DAG19Accident · No injuriesClosedPiper PA-18 · Lachbuna Lake, AKDec 4, 1979 · N2854D · Substantial damage NTSB ANC80DAG18Accident · No injuriesClosedCessna 206 · Marshall, AKDec 4, 1979 · N9575G · Substantial damage NTSB MKC80FCG06Accident · Serious injuriesClosedBeech B-95 · Leawood, KSDec 3, 1979 · N2781Y · Substantial damage NTSB LAX80FXQ10Accident · No injuriesClosedCessna 180 · Reno, NVDec 3, 1979 · N3330D · Substantial damage NTSB LAX80DUJ19Accident · Minor injuriesClosedCessna 152 · Phoenix, AZDec 3, 1979 · N25763 · Destroyed NTSB DEN80FA011Accident · 2 fatalClosedCessna 182 · Longmont, CODec 3, 1979 · N3194S · Destroyed NTSB CHI80FEV11Accident · No injuriesClosedCessna 150H · Springfield, ILDec 3, 1979 · N22931 · Substantial damage NTSB CHI80FEI08Accident · No injuriesClosedAeronca 7AC · Canfield, OHDec 3, 1979 · N81743 · Substantial damage NTSB CHI80DEC05Accident · No injuriesClosedCessna 140 · Romeo, MIDec 3, 1979 · N1788N · Substantial damage NTSB ANC80FA018Accident · 4 fatalClosedDehavnd Can DHC-6 · Nome, AKDec 3, 1979 · N8061V · Destroyed NTSB SEA80FTA03Accident · No injuriesClosedCessna 182E · Red Lodge, MTDec 2, 1979 · N3136Y · Substantial damage