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 FTW80DRA14Accident · No injuriesClosedMeyers 200 · La Porte, TXDec 20, 1979 · N495C · Substantial damage NTSB FTW80DQG06Accident · No injuriesClosedCessna 152 · Sweetwater, TXDec 20, 1979 · N4727B · Substantial damage NTSB DEN80DTM08Accident · No injuriesClosedHughes 269C · Cornich, UTDec 20, 1979 · N9581F · Substantial damage NTSB SEA80FTI02Accident · Serious injuriesClosedPiper PA-32R · Chester, MTDec 19, 1979 · N2168D · Destroyed NTSB MIA80DLD29Accident · No injuriesClosedPiper PA-38 · Zephyrhills, FLDec 19, 1979 · N801JC · Substantial damage NTSB LAX80FUG15Accident · Serious injuriesClosedBell 47G3B1 · Yucaipa, CADec 19, 1979 · N7923S · Destroyed NTSB FTW80FRD14Accident · No injuriesClosedHughes 369D · Westwego, LADec 19, 1979 · N58270 · Substantial damage NTSB CHI80FEM08Accident · Minor injuriesClosedRyan ST-3KR · Holland, MIDec 19, 1979 · N47433 · Substantial damage NTSB SEA80DYA04Accident · No injuriesClosedAerosport Quail · Idaho Falls, IDDec 18, 1979 · N47075 · Substantial damage NTSB NYC80FNA06Accident · Minor injuriesClosedCessna 177RG · Mashpee, MADec 18, 1979 · N35106 · Substantial damage NTSB MIA80FLA12Accident · 1 fatalClosedNavion H · Waycross, GADec 18, 1979 · N2552T · Destroyed NTSB LAX80FVA08Accident · No injuriesClosedBeech 60 · Fresno, CADec 18, 1979 · N1873S · Substantial damage NTSB IAD80DKW03Accident · No injuriesClosedPiper PA-28 · Rockwood, TNDec 18, 1979 · N29218 · Substantial damage NTSB FTW80FA023Accident · 1 fatalClosedCessna 180K · Harvey, LADec 18, 1979 · N2594K · Substantial damage NTSB CHI80FEP08Accident · No injuriesClosedBellanca 17-30A · Viroqua, WIDec 18, 1979 · N14703 · Substantial damage NTSB SEA80DYM10Accident · No injuriesClosedAerospatle SA315B · Mill City, ORDec 17, 1979 · N55963 · Substantial damage NTSB MIA80FLD24Accident · No injuriesClosedPiper PA-30 · Vero Beach, FLDec 17, 1979 · N7737Y · Substantial damage NTSB MIA80FKJ16Accident · No injuriesClosedBeech 58 · Huntsville, ALDec 17, 1979 · N911FP · Substantial damage NTSB FTW80DRA13Accident · No injuriesClosedBeech 95-A55 · Angleton, TXDec 17, 1979 · N910TL · Substantial damage NTSB FTW80DPG08Accident · No injuriesClosedBeech 76 · Hot Springs, ARDec 17, 1979 · N6014E · Substantial damage NTSB NYC80FA015Accident · 1 fatalClosedCessna 172 · Washingtnville, NYDec 16, 1979 · N6647A · Destroyed NTSB MIA80FA019Accident · 2 fatalClosedN American P-51D · Eufaula, ALDec 16, 1979 · N7711C · Destroyed NTSB MIA80DLD21Accident · No injuriesClosedBeech 95-B55 · Ft Pierce, FLDec 16, 1979 · N8GS · Substantial damage NTSB LAX80FUJ20Accident · No injuriesClosedCessna 180J · Chandler, AZDec 16, 1979 · N91K · Substantial damage NTSB LAX80DUG12Accident · No injuriesClosedBeech E18S · Laverne, CADec 16, 1979 · N471CM · Substantial damage NTSB IAD80FA017Accident · 7 fatalClosedBeech A65 · Lexington, KYDec 16, 1979 · N154F · Destroyed NTSB CHI80FET05Accident · Serious injuriesClosedErco 415-CD · Lake Village, INDec 16, 1979 · N3857H · Substantial damage NTSB CHI80FA015Accident · 1 fatalClosedPiper PA-28 · Mansfield, OHDec 16, 1979 · N5515F · Destroyed NTSB ANC80DAG16Accident · No injuriesClosedPiper PA-11 · Montague Is, AKDec 16, 1979 · N78635 · Substantial damage NTSB NYC80FNE06Accident · No injuriesClosedPiper PA-28 · Westfield, MADec 15, 1979 · N4525F · No damage NTSB NYC80FGM09Accident · No injuriesClosedCessna 140 · Butler, PADec 15, 1979 · N90035 · Substantial damage NTSB NYC80FFA07Accident · No injuriesClosedCessna 172 · Sharon Springs, NYDec 15, 1979 · N739GE · Substantial damage NTSB MKC80FCQ07Accident · No injuriesClosedPiper PA-32 · Cedar Vale, KSDec 15, 1979 · N2162E · Substantial damage NTSB MKC80DCA05Accident · Minor injuriesClosedCessna 185F · Chesterfield, MODec 15, 1979 · N9712H · Substantial damage NTSB MIA80FA018Accident · 4 fatalClosedRaven S-55A · Davie, FLDec 15, 1979 · N64RR · Destroyed NTSB LAX80FVM09Accident · No injuriesClosedPiper J-3C · New Cuyana, CADec 15, 1979 · N71066 · Substantial damage NTSB LAX80FA025Accident · 1 fatalClosedMooney M20J · Palo Alto, CADec 15, 1979 · N201UN · Destroyed NTSB LAX80DVD06Accident · No injuriesClosedCessna 210 · Santa Rosa, CADec 15, 1979 · N6866R · Substantial damage NTSB LAX80DVA07Accident · No injuriesClosedGrumman G-164A · Lemoore, CADec 15, 1979 · N4728 · Substantial damage NTSB IAD80FIA03Accident · No injuriesClosedCessna 182F · Brandy Station, VADec 15, 1979 · N3139U · Substantial damage NTSB FTW80FRG13Accident · 1 fatalClosedErco 415-C · Troy, TXDec 15, 1979 · N93477 · Destroyed NTSB FTW80FA022Accident · 2 fatalClosedCessna A185F · Venice, LADec 15, 1979 · N1850R · Destroyed NTSB FTW80FA021Accident · 2 fatalClosedPiper PA-28 · Sonora, TXDec 15, 1979 · N57329 · Destroyed NTSB FTW80DRG12Accident · No injuriesClosedCessna 170 · Johnson City, TXDec 15, 1979 · N4153V · Substantial damage NTSB DEN80FTE13Accident · Minor injuriesClosedCessna 182 · Gunnison, CODec 15, 1979 · N2191G · Destroyed NTSB DEN80DTE15Accident · No injuriesClosedCessna 182 · Ft Collins, CODec 15, 1979 · N735JB · Substantial damage NTSB CHI80FA014Accident · 1 fatalClosedHughes 269C · West Milton, OHDec 15, 1979 · N7483F · Destroyed NTSB CHI80DEM11Accident · No injuriesClosedGrumman AA-1C · Marion, MIDec 15, 1979 · N39008 · Destroyed NTSB MKC80FCQ08Accident · No injuriesClosedPiper PA-34 · Osawatomie, KSDec 14, 1979 · N2078N · Substantial damage NTSB LAX80DVD05Accident · No injuriesClosedCessna 152 · Santa Rosa, CADec 14, 1979 · N5085B · Substantial damage