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 CHI80FA009Accident · Minor injuriesClosedCessna T210L · Galesburg, ILNov 23, 1979 · N22434 · Substantial damage NTSB ANC80FA014Accident · No injuriesClosedScottish TP SR2 · Anchorage, AKNov 23, 1979 · N9965F · Substantial damage NTSB MIA80DLD16Accident · No injuriesClosedCessna 210 · Ft.Myers, FLNov 22, 1979 · N2188S · Substantial damage NTSB MIA80DLD14Accident · No injuriesClosedPiper PA-28 · New Pt Richey, FLNov 22, 1979 · N3623M · Substantial damage NTSB MIA80DKJ12Accident · No injuriesClosedCessna 182 · Grove Hill, ALNov 22, 1979 · N170AC · Substantial damage NTSB LAX80FVW06Accident · No injuriesClosedPiper PA-24 · Henderson, NCNov 22, 1979 · N8462P · Substantial damage NTSB LAX80FA019Accident · 4 fatalClosedCessna 172RG · Lassen Peak, CANov 22, 1979 · N4760R · Destroyed NTSB LAX80DUM07Accident · Serious injuriesClosedAero Comdr 100 · Santee, CANov 22, 1979 · N4084X · Substantial damage NTSB LAX80DUJ12Accident · No injuriesClosedLear 35 · Douglas, AZNov 22, 1979 · XA-ELU · Substantial damage NTSB CHI80FEV07Accident · 1 fatalClosedAmerican AA-1B · Charleston, ILNov 22, 1979 · N6245L · Destroyed NTSB CHI80FET04Accident · No injuriesClosedPiper PA-32 · Laporte, INNov 22, 1979 · N44503 · Substantial damage NTSB SEA80FA007Accident · 2 fatalClosedCessna T210M · Yakima, WANov 21, 1979 · N321TT · Substantial damage NTSB NYC80FHM04Accident · No injuriesClosedPiper PA-31 · Teterboro, NJNov 21, 1979 · N6569L · Substantial damage NTSB NYC80FFA06Accident · No injuriesClosedCessna 180K · Utica, NYNov 21, 1979 · N2597K · Substantial damage NTSB MKC80FA007Accident · 1 fatalClosedCessna 210 · Mountain View, MONov 21, 1979 · N732EH · Destroyed NTSB MIA80FLG03Accident · Minor injuriesClosedBellanca 17-31A · Isle Of Palms, SCNov 21, 1979 · N8857V · Substantial damage NTSB MIA80FKG10Accident · No injuriesClosedCessna 182 · Dawson, GANov 21, 1979 · N738CE · Substantial damage NTSB IAD80FLJ05Accident · 1 fatalClosedPiper PA-38 · Aventon, NCNov 21, 1979 · N9310T · Destroyed NTSB MKC80FA008Accident · 1 fatalClosedAmer Avco AA1-A · New Boston, MONov 20, 1979 · N9387L · Destroyed NTSB MKC80DER11Accident · No injuriesClosedPiper PA-22 · Middle River, MNNov 20, 1979 · N5035Z · Substantial damage NTSB LAX80FA016Accident · 1 fatalClosedPiper PA-28 · Santa Barbara, CANov 20, 1979 · N9042K · Destroyed NTSB ANC80DA013Accident · No injuriesClosedCessna 206 · Gold King Crk, AKNov 20, 1979 · N206JP · Substantial damage NTSB NYC80FNE03|NYC80FNE04Accident · No injuriesClosedCessna 172M · Stratford, CTNov 19, 1979 · N13660 · 2 aircraft · Substantial damage NTSB MIA80FLD12Accident · Serious injuriesClosedCessna 172 · Titusville, FLNov 19, 1979 · N7338E · Substantial damage NTSB MIA80FA012Accident · 2 fatalClosedDouglas C-54D · Mccormick, SCNov 19, 1979 · N8060C · Destroyed NTSB MIA80DA020Accident · 1 fatalClosedBeech D50B · Missing AircraftNov 19, 1979 · N1706 · Destroyed NTSB LAX80FXQ05Accident · No injuriesClosedCessna 210 · Beckwourth, CANov 19, 1979 · N78MC · Substantial damage NTSB FTW80IA017Incident · No injuriesClosedCessna U206 · Centerville, TXNov 19, 1979 · N222LS · No damage NTSB FTW80FPM03Accident · 1 fatalClosedBenson B8M · Sand Springs, OKNov 19, 1979 · N6933 · Destroyed NTSB DEN80FA009Accident · 2 fatalClosedCessna 500 · Castle Rock, CONov 19, 1979 · N555AJ · Destroyed NTSB CHI80FEV08Accident · No injuriesClosedPiper PA-28R · Girard, ILNov 19, 1979 · N853 · Substantial damage NTSB ANC80FA003Accident · No injuriesClosedCessna 185 · Barrow, AKNov 19, 1979 · N4711Q · Substantial damage NTSB NYC80FA012Accident · Minor injuriesClosedBeech 99 · Bangor, MENov 18, 1979 · N983MA · Substantial damage NTSB MIA80FLD23Accident · No injuriesClosedBellanca 7GCBC · Tampa, FLNov 18, 1979 · N5045G · Substantial damage NTSB MIA80FA010Accident · 2 fatalClosedErco 415-C · Bishopville, SCNov 18, 1979 · N99484 · Destroyed NTSB LAX80FA015Accident · No injuriesClosedCessna 152 · Bakersfield, CANov 18, 1979 · N24906 · 2 aircraft · Substantial damage NTSB LAX80DUG13Accident · No injuriesClosedCessna 310J · Banning, CANov 18, 1979 · N3103L · Substantial damage NTSB LAX80DJA04Accident · No injuriesClosedCessna 152 · Honolulu, HINov 18, 1979 · N89774 · Substantial damage NTSB IAD80FIG02Accident · No injuriesClosedPiper PA-28 · Grasonville, MDNov 18, 1979 · N2889G · Substantial damage NTSB FTW80DA015Accident · 1 fatalClosedCessna 210 · El Paso, TXNov 18, 1979 · N732ZR · Minor damage NTSB DEN80DQD03Accident · No injuriesClosedBeech A36 · Deming, NMNov 18, 1979 · N130T · Substantial damage NTSB DCA80AA007Accident · 3 fatalClosedLockheed 188C · Salt Lake City, UTNov 18, 1979 · N859U · Destroyed NTSB CHI80FEK05Accident · No injuriesClosedCessna 170A · Columbus, OHNov 18, 1979 · N9032A · Substantial damage NTSB CHI80FEI07Accident · Minor injuriesClosedCessna 150 · Ravenna, OHNov 18, 1979 · N63252 · 2 aircraft · Substantial damage NTSB NYC80FNC04Accident · No injuriesClosedPiper PA-28 · Bennington, VTNov 17, 1979 · N8118V · Substantial damage NTSB NYC80FGM07Accident · No injuriesClosedBeech A-23 · Latrobe, PANov 17, 1979 · N6919Q · Substantial damage NTSB NYC80FA011Accident · 3 fatalClosedCessna 337G · Bennington, VTNov 17, 1979 · N53560 · Destroyed NTSB MKC80FCJ02Accident · Minor injuriesClosedCessna 150J · Nebraska City, NENov 17, 1979 · N50467 · Substantial damage NTSB MIA80DLD13Accident · Serious injuriesClosedBalloon WKS KS-7 · Plant City, FLNov 17, 1979 · N41JB · Minor damage NTSB IAD80FLJ04Accident · No injuriesClosedCessna 150G · Knightdale, NCNov 17, 1979 · N2268J · Substantial damage