Skip to content

NTSB investigations, 1981

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") = 1981 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\") = 1981
  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") = 1981
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 ATL81FLT04Accident · Minor injuriesClosedAir Tractor AT-301 · Crenshaw, MSFeb 26, 1981 · N4433S · Substantial damage NTSB ATL81FKJ12Accident · No injuriesClosedBeech K35 · Wetumpka, ALFeb 26, 1981 · N133VW · Substantial damage NTSB ATL81FIJ04Accident · No injuriesClosedCessna 150 · Buckhannon, WVFeb 26, 1981 · N6079J · Substantial damage NTSB SEA81FA019Accident · 1 fatalClosedPiper PA-28 · Seattle, WAFeb 25, 1981 · N2258Q · Destroyed NTSB NYC81FHD13Accident · Minor injuriesClosedCessna 177RG · Philadelphia, PAFeb 25, 1981 · N34144 · Destroyed NTSB NYC81FA030Accident · 2 fatalClosedCessna 310R · North Adams, MAFeb 25, 1981 · N5489J · Destroyed NTSB MKC81FA022Accident · 2 fatalClosedAmer Avco AA-1A · Council Bluffs, IAFeb 25, 1981 · N332A · Destroyed NTSB MKC81DCG23Accident · No injuriesClosedGreat Lakes 2T-1A · Grain Valley, MOFeb 25, 1981 · N3544L · Substantial damage NTSB CHI81FEG08Accident · Minor injuriesClosedCessna 150H · Springboro, OHFeb 25, 1981 · N50199 · Substantial damage NTSB CHI81DA030Accident · No injuriesClosedPiper PA-31 · North Canton, OHFeb 25, 1981 · N74931 · Substantial damage NTSB ANC81DAG29Accident · No injuriesClosedMaule M-5 · New Stuyahok, AKFeb 25, 1981 · N5629V · Substantial damage NTSB MIA81FLA13Accident · Minor injuriesClosedBeech 65 · Tallahassee, FLFeb 24, 1981 · N4553D · Substantial damage NTSB FTW81FQG15Accident · No injuriesClosedPiper PA-36 · Goodland, TXFeb 24, 1981 · N59654 · Substantial damage NTSB FTW81DPJ10Accident · No injuriesClosedPitts S-1C · El Reno, OKFeb 24, 1981 · N19JS · Substantial damage NTSB CHI81DER19Accident · No injuriesClosedWar Corsair · Blue Earth, MNFeb 24, 1981 · N246S · Substantial damage NTSB SEA81FYE18Accident · Minor injuriesClosedCessna 172 · Seattle, WAFeb 23, 1981 · N2946E · Substantial damage NTSB LAX81DXQ12Accident · No injuriesClosedPiper PA-18 · Mammoth Lakes, CAFeb 23, 1981 · N24570 · Substantial damage NTSB FTW81DPG10Accident · No injuriesClosedGrumman G-164B · Carlisle, ARFeb 23, 1981 · N48487 · Substantial damage NTSB ATL81DKG08Accident · No injuriesClosedBeech 58P · Jenkinsburg, GAFeb 23, 1981 · N15X · Substantial damage NTSB NYC81FNE11Accident · Minor injuriesClosedCessna 150 · Princeton, MAFeb 22, 1981 · N6975F · Substantial damage NTSB NYC81FNA12Accident · Minor injuriesClosedPiper PA-28 · Chepachet, RIFeb 22, 1981 · N5248L · Destroyed NTSB NYC81FA029Accident · 4 fatalClosedMooney M20F · Montgomery Twp, NJFeb 22, 1981 · N1919T · Destroyed NTSB MKC81DCQ14Accident · No injuriesClosedPiper PA-32R · Osborne, KSFeb 22, 1981 · N6168H · Substantial damage NTSB MKC81DCD10Accident · No injuriesClosedCessna 172 · Spencer, IAFeb 22, 1981 · N7318G · Substantial damage NTSB LAX81FA050Accident · 2 fatalClosedBellanca 14-19 · Parker, AZFeb 22, 1981 · N8503R · Destroyed NTSB LAX81FA049Accident · 2 fatalClosedSikorsky S-62A · Avalon, CAFeb 22, 1981 · N324Y · Destroyed NTSB LAX81DUG14Accident · No injuriesClosedPiper PA-28 · Chino, CAFeb 22, 1981 · N4509X · Substantial damage NTSB FTW81FPD11Accident · No injuriesClosedCessna 120 · Bolivar, TXFeb 22, 1981 · N72346 · Substantial damage NTSB CHI81DER20Accident · No injuriesClosedCessna 172F · Slaton, MNFeb 22, 1981 · N5639R · Substantial damage NTSB ATL81FA050Accident · 1 fatalClosedPiper PA-28 · Statesville, NCFeb 22, 1981 · N2552U · Substantial damage NTSB ANC81DAG27Accident · No injuriesClosedPiper PA-18 · Eureka, AKFeb 22, 1981 · N2413H · Substantial damage NTSB MKC81FA021Accident · 1 fatalClosedPiper PA-22 · Lohrville, IAFeb 21, 1981 · N3402A · Destroyed NTSB MIA81FA048Accident · 2 fatalClosedCessna 177 · Lutz, FLFeb 21, 1981 · N2940X · Destroyed NTSB LAX81FVD12Accident · No injuriesClosedCessna 150 · Tracy, CAFeb 21, 1981 · N2021Z · Substantial damage NTSB LAX81FUJ40Accident · No injuriesClosedBeech C-45H · Coolidge, AZFeb 21, 1981 · N9533Z · Substantial damage NTSB LAX81DVA23Accident · No injuriesClosedHiller UH-12E · Exeter, CAFeb 21, 1981 · N90475 · Substantial damage NTSB FTW81FRG20Accident · Minor injuriesClosedCessna 172 · Austin, TXFeb 21, 1981 · N738TE · Substantial damage NTSB FTW81FRA18Accident · No injuriesClosedGrum-Amer AA5A · League Cy, TXFeb 21, 1981 · N26262 · Substantial damage NTSB FTW81DQG14Accident · No injuriesClosedPiper PA-28 · Amarillo, TXFeb 21, 1981 · N419CC · Destroyed NTSB FTW81DQA20Accident · No injuriesClosedCessna 210E · La Plata, NMFeb 21, 1981 · N4941U · Destroyed NTSB DEN81FTE22Accident · No injuriesClosedCessna 182A · Colorado Spgs, COFeb 21, 1981 · N4030D · Substantial damage NTSB CHI81FEX11Accident · No injuriesClosedErco 415-E · Carlisle, INFeb 21, 1981 · N94773 · Substantial damage NTSB ATL81FA049Accident · Minor injuriesClosedBeech A60 · Davis, WVFeb 21, 1981 · N7QP · Substantial damage NTSB ANC81DAA09Accident · No injuriesClosedLuscombe 11A · Moses Point, AKFeb 21, 1981 · N1667B · Substantial damage NTSB MKC81FCQ13Accident · Minor injuriesClosedPiper PA-28R · Agra, KSFeb 20, 1981 · N712HS · Substantial damage NTSB LAX81DVW08Accident · No injuriesClosedCessna 150B · Overton, NVFeb 20, 1981 · N102FR · Substantial damage NTSB FTW81FRJ10Accident · Minor injuriesClosedBeech C24R · Bossier City, LAFeb 20, 1981 · N5279M · Substantial damage NTSB CHI81FEX10Accident · Serious injuriesClosedCessna 182 · Indianapolis, INFeb 20, 1981 · N5362N · Destroyed NTSB CHI81FER16Accident · Minor injuriesClosedMooney M20 · Lacrescent, MNFeb 20, 1981 · N2664W · Substantial damage NTSB NYC81IA028Incident · No injuriesClosedS.N.I.A.S. Concrd · Chantilly, NYFeb 19, 1981 · F-BTSD · Minor damage