Skip to content

NTSB investigations, 1980

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") = 1980 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\") = 1980
  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") = 1980
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 NYC81FGM08Accident · No injuriesClosedCessna 172H · New Cumberland, WVDec 10, 1980 · N8237L · Substantial damage NTSB MKC81FCG18Accident · No injuriesClosedPiper PA-31 · Springfield, MODec 10, 1980 · N450GC · Substantial damage NTSB MKC81FA010Accident · No injuriesClosedSwearingen SA226T · Kansas City, KSDec 10, 1980 · N11RM · Substantial damage NTSB MIA81FKT15Accident · No injuriesClosedCessna 172N · Miami, FLDec 10, 1980 · N2235E · Substantial damage NTSB LAX81FA031Accident · No injuriesClosedBeech 65-88 · Goleta, CADec 10, 1980 · N884S · Substantial damage NTSB LAX81DVG08Accident · No injuriesClosedPiper PA-12 · Lincoln, CADec 10, 1980 · N4218M · Substantial damage NTSB ATL81FA026Accident · 1 fatalClosedMooney M20J · New Carrollton, MDDec 10, 1980 · N3739H · Destroyed NTSB SEA81FYM11Accident · No injuriesClosedCessna 182P · Orchards, WADec 9, 1980 · N21413 · Substantial damage NTSB NYC81FFA08Accident · Serious injuriesClosedCessna 182 · Greene, NYDec 9, 1980 · N2677R · Destroyed NTSB MIA81FLA08Accident · Minor injuriesClosedJaguar NSBP-1 · St Augustine, FLDec 9, 1980 · N67SC · Substantial damage NTSB ATL81FA025Accident · 1 fatalClosedCessna 152 · Ft Adams, MSDec 9, 1980 · N5331M · Destroyed NTSB ATL81DLJ03Accident · Serious injuriesClosedCessna 182G · Apex, NCDec 9, 1980 · N2116R · No damage NTSB ANC81DAG15Accident · No injuriesClosedCessna 180 · Whittier, AKDec 9, 1980 · N4575B · Substantial damage NTSB LAX81FUJ13Accident · No injuriesClosedCessna 150 · Chandler, AZDec 8, 1980 · N9154U · Substantial damage NTSB LAX81DXQ05CaseClosedPiper PA-32 · So.Lake Tahoe, CADec 8, 1980 · N31872 NTSB CHI81DER08Accident · No injuriesClosedBeech 23 · Alexandria, MNDec 8, 1980 · N2370Z · Substantial damage NTSB CHI81DEE11Accident · No injuriesClosedCessna 414 · Wheeling, ILDec 8, 1980 · N18SM · Substantial damage NTSB SEA81DYM10Accident · Serious injuriesClosedStinson L-5 · Philomath, ORDec 7, 1980 · N68842 · Substantial damage NTSB SEA81DYK03Accident · No injuriesClosedPiper PA-34 · Sutherlin, ORDec 7, 1980 · N2924C · Substantial damage NTSB NYC81FNE05Accident · Minor injuriesClosedPiper J-3 · Coventry, CTDec 7, 1980 · N92654 · Substantial damage NTSB NYC81FHJ05Accident · No injuriesClosedCessna 150 · Ronkonkomoa, NYDec 7, 1980 · N714CM · Substantial damage NTSB NYC81FA016Accident · 4 fatalClosedPiper PA-28R · Jamaica, NYDec 7, 1980 · N29242 · Destroyed NTSB MIA81FLA07Accident · No injuriesClosedLuscombe 8A · Macclenny, FLDec 7, 1980 · N45503 · Substantial damage NTSB MIA81DLD12Accident · No injuriesClosedCessna 210 · Stuart, FLDec 7, 1980 · N761PX · Destroyed NTSB LAX81FJA04Accident · Serious injuriesClosedCessna 182H · Haleiwa, HIDec 7, 1980 · N1965X · Substantial damage NTSB DCA81IA004Incident · No injuriesClosedLear Jet 25 · Childress, TXDec 7, 1980 · N509G · No damage NTSB CHI81FEX06Accident · Serious injuriesClosedCessna 150H · Kokomo, INDec 7, 1980 · N6475S · Destroyed NTSB CHI81FA011Accident · 4 fatalClosedBeech E90 · Michigan City, INDec 7, 1980 · N2181L · Destroyed NTSB ATL81FID05Accident · No injuriesClosedCessna 172 · Tangier Island, VADec 7, 1980 · N5456K · Substantial damage NTSB ATL81DKM01Accident · No injuriesClosedBaby GR LKS 1 · Greensboro, NCDec 7, 1980 · N66JM · Substantial damage NTSB NYC81FHD09Accident · No injuriesClosedDehavilland DHC-1 · Ocean City, NJDec 6, 1980 · N65237 · Destroyed NTSB MIA81FLD18Accident · 1 fatalClosedKnight Twst 01 · Winter Haven, FLDec 6, 1980 · N10KT · Destroyed NTSB CHI81FA010Accident · 5 fatalClosedMitsubishi MU-2 · Ramsey, MNDec 6, 1980 · N969MA · Destroyed NTSB ATL81FLQ07Accident · Minor injuriesClosedPiper PA-23 · Louisville, KYDec 6, 1980 · N2116P · Destroyed NTSB ATL81FLJ01Accident · No injuriesClosedCessna 152 · Fort Bragg, NCDec 6, 1980 · N24327 · Substantial damage NTSB ATL81FID04Accident · No injuriesClosedBeech C23 · Chester, VADec 6, 1980 · N5401M · Substantial damage NTSB ATL81DLJ02Accident · No injuriesClosedBensen B8M · Spring Lake, NCDec 6, 1980 · N8053Y · Substantial damage NTSB ANC81DAG13Accident · Minor injuriesClosedMaule M-5 · Anchorage, AKDec 6, 1980 · N62003 · Destroyed NTSB ANC81DAA07Accident · Serious injuriesClosedCessna T210G · Ruby, AKDec 6, 1980 · N6890R · Destroyed NTSB MKC81FCA05Accident · Serious injuriesClosedPiper PA-36 · Hayti, MODec 5, 1980 · N55713 · Destroyed NTSB MIA81FLD17Accident · Serious injuriesClosedCessna 182A · Orlando, FLDec 5, 1980 · N2056G · Destroyed NTSB LAX81FXQ04Accident · Serious injuriesClosedPiper PA-32 · Carson City, NVDec 5, 1980 · N3587W · Destroyed NTSB LAX81DVA15Accident · No injuriesClosedBoeing A75N-1 · Lemoore, CADec 5, 1980 · N62630 · Substantial damage NTSB LAX81DVA14Accident · No injuriesClosedCessna 188 · Huron, CADec 5, 1980 · N9335R · Substantial damage NTSB DEN81FTE09Accident · No injuriesClosedSchweizer SGS1 · Colorado Sprgs, CODec 5, 1980 · N65912 · Substantial damage NTSB DEN81FTE08Accident · No injuriesClosedCessna 177RG · Boulder, CODec 5, 1980 · N2702V · Substantial damage NTSB CHI81FA009Accident · 3 fatalClosedCessna 210H · Hagerstown, INDec 5, 1980 · N5951F · Destroyed NTSB MKC81FCJ04Accident · No injuriesClosedCessna 182 · Albion, NEDec 4, 1980 · N2506R · Destroyed NTSB MIA81DLA06Accident · No injuriesClosedMooney M20C · Bunnell, FLDec 4, 1980 · N3603H · Substantial damage NTSB LAX81FVA13Accident · 1 fatalClosedAero Comdr S2R · Huron, CADec 4, 1980 · N5536X · Destroyed