Skip to content

NTSB investigations, 1979

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 LAX80DUJ24Accident · No injuriesClosedCessna 172M · Window Rock, AZDec 14, 1979 · N841JW · Substantial damage NTSB IAD80FA016Accident · 1 fatalClosedPiper PA-23 · Knoxville, TNDec 14, 1979 · N3242P · Destroyed NTSB DEN80FTE14Accident · Minor injuriesClosedCessna R172K · Montrose, CODec 14, 1979 · N736LR · Substantial damage NTSB CHI80DEE12Accident · No injuriesClosedCessna 172N · Schaumburg, ILDec 14, 1979 · N4870D · Substantial damage NTSB MKC80DCQ06Accident · No injuriesClosedCessna 182 · Glasco, KSDec 13, 1979 · N5113D · Substantial damage NTSB MIA80DLA11Accident · Minor injuriesClosedCessna 152 · Tallahassee, FLDec 13, 1979 · N24243 · Substantial damage NTSB DEN80FTE12Accident · 2 fatalClosedDelta Dyke · Broomfield, CODec 13, 1979 · N99DD · Substantial damage NTSB MIA80FKG14Accident · Minor injuriesClosedAeronca 11AC · Fitzgerald, GADec 12, 1979 · N9552E · Substantial damage NTSB LAX80FUD03Accident · No injuriesClosedCessna 441 · Los Angeles, CADec 12, 1979 · N26226 · Substantial damage NTSB LAX80DVA06Accident · No injuriesClosedEnstrom F-28A · Woodlake, CADec 12, 1979 · N521H · Substantial damage NTSB LAX80DUJ41Accident · No injuriesClosedCessna 150 · Sedona, AZDec 12, 1979 · N3575L · Substantial damage NTSB IAD80FIG03Accident · No injuriesClosedPiper PA-28 · Edgewater, MDDec 12, 1979 · N8132R · Substantial damage NTSB IAD80DID05Accident · Minor injuriesClosedPiper PA-28 · Lexington, VADec 12, 1979 · N5059S · Substantial damage NTSB DEN80FTE07Accident · No injuriesClosedCessna 310K · Longmont, CODec 12, 1979 · N7058L · Substantial damage NTSB SEA80FAMS1Accident · 4 fatalClosedPiper PA-24 · Missing AircraftDec 11, 1979 · N6171P · Destroyed NTSB SEA80FA047Accident · 4 fatalClosedPiper PA-24 · White Pass, WADec 11, 1979 · N6171P · Destroyed NTSB NYC80DHD08Accident · No injuriesClosedCessna 152 · Toms River, NJDec 11, 1979 · N48470 · Substantial damage NTSB MKC80FA014Accident · 1 fatalClosedCessna 182S · Womack, MODec 11, 1979 · N3594U · Destroyed NTSB MKC80FA013Accident · No injuriesClosedPiper PA-31 · Lee'S Summit, MODec 11, 1979 · N7511L · Substantial damage NTSB MIA80FKT08Accident · No injuriesClosedCessna 177RG · Boca Raton, FLDec 11, 1979 · N2010Q · Substantial damage NTSB IAD80FLT03Accident · No injuriesClosedCessna 172 · Collierville, TNDec 11, 1979 · N1184U · Substantial damage NTSB DEN80FTM05Accident · No injuriesClosedBeech 60 · Salt Lake City, UTDec 11, 1979 · N156WC · Substantial damage NTSB ANC80FAD02Accident · No injuriesClosedInterstate S1B2 · Sitka, AKDec 11, 1979 · N56AT · Substantial damage NTSB SEA80FYM09Accident · Serious injuriesClosedCessna 150G · Aloha, ORDec 10, 1979 · N4825X · Substantial damage NTSB MIA80FLD19Accident · No injuriesClosedCessna 210D · Titusville, FLDec 10, 1979 · N5FD · Substantial damage NTSB MIA79FLA10Accident · No injuriesClosedBell 206B · Sea Island, GADec 10, 1979 · N59530 · Substantial damage NTSB LAX80FUA05Accident · Serious injuriesClosedPiper PA-28 · Avalon, CADec 10, 1979 · N8432C · Destroyed NTSB LAX80DVG09Accident · No injuriesClosedCessna 172 · Sacramento, CADec 10, 1979 · N8173L · Substantial damage NTSB DEN80FQA11Incident · No injuriesClosedCessna 402A · Albuquerque, NMDec 10, 1979 · N4514Q · Minor damage NTSB SEA80FYP06Accident · Serious injuriesClosedCessna 305A · Sandpoint, IDDec 9, 1979 · N5264G · Substantial damage NTSB SEA80FA014Accident · 2 fatalClosedCessna 182 · Idaho Falls, IDDec 9, 1979 · N470PP · Destroyed NTSB NYC80FHJ05Accident · No injuriesClosedGrum Amer AA1B · Shirley, NYDec 9, 1979 · N1360R · Substantial damage NTSB MKC80FTK06Accident · No injuriesClosedBeech A23 · Tea, SDDec 9, 1979 · N3580R · Substantial damage NTSB MKC80FCQ05Accident · Minor injuriesClosedCessna 150G · Onaga, KSDec 9, 1979 · N3165X · Substantial damage NTSB MKC80FCQ04Accident · Minor injuriesClosedPiper PA-28 · Dodge City, KSDec 9, 1979 · N5298S · Substantial damage NTSB MKC80FCD08Accident · No injuriesClosedCessna 150 · Maquoketa, IADec 9, 1979 · N16129 · Substantial damage NTSB MKC80DCJ04Accident · No injuriesClosedCessna 172 · Harrison, NEDec 9, 1979 · N3799R · Substantial damage NTSB MKC80DCA04Accident · Serious injuriesClosedAdams,Md A55 · Ballwin, MODec 9, 1979 · N1060N · Minor damage NTSB MIA80FKA02Accident · No injuriesClosedCessna 172 · Mona Island, PRDec 9, 1979 · N737ME · Substantial damage NTSB MIA80DLD20Accident · No injuriesClosedBeech C33 · Ocala, FLDec 9, 1979 · N5869S · Substantial damage NTSB LAX80FVM13Accident · No injuriesClosedPiper PA-38 · Sn Luis Obspo, CADec 9, 1979 · N2456L · Substantial damage NTSB LAX80FA024Accident · 1 fatalClosedAerostar 601P · Bishop, CADec 9, 1979 · N600WW · Destroyed NTSB LAX80FA023Accident · 3 fatalClosedCessna 172M · Huntington Bch, CADec 9, 1979 · N20647 · Destroyed NTSB FTW80FRD11Accident · Serious injuriesClosedCessna 421B · Lafayette, LADec 9, 1979 · N5970M · Substantial damage NTSB DEN80DQG03Accident · No injuriesClosedCessna 206 · Hobbs, NMDec 9, 1979 · N735VE · Substantial damage NTSB SEA80FA013Accident · 1 fatalClosedCessna T210M · Pasco, WADec 8, 1979 · N732QJ · Destroyed NTSB SEA80FA012Accident · 2 fatalClosedAeronca 65-CA · Mountain Home, IDDec 8, 1979 · N31929 · Substantial damage NTSB NYC80DNA05Accident · No injuriesClosedCessna 172K · Bedford, MADec 8, 1979 · N79883 · Substantial damage NTSB MIA80FKG13Accident · Serious injuriesClosedCessna T337F · Athens, GADec 8, 1979 · N1119M · Substantial damage NTSB LAX80DVG10Accident · No injuriesClosedLuscombe 8A · Fort Bidwell, CADec 8, 1979 · N1186K · Substantial damage