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 NYC81FGT03Accident · Minor injuriesClosedCessna 172 · Palmyra, PAMay 31, 1981 · N8422X · Substantial damage NTSB MKC81FCQ35Accident · Minor injuriesClosedStinson 108-2 · Valley Center, KSMay 31, 1981 · N97899 · Substantial damage NTSB MKC81DCQ37Accident · No injuriesClosedCessna 172L · Sublette, KSMay 31, 1981 · N7855G · Substantial damage NTSB MKC81DCQ36Accident · No injuriesClosedCessna A188-B · Murdock, KSMay 31, 1981 · N731WP · Destroyed NTSB MKC81DCA14Accident · No injuriesClosedCessna 337G · Holcomb, MOMay 31, 1981 · N53555 · Substantial damage NTSB MIA81FKT49Accident · No injuriesClosedPiper PA-18 · Opalocka, FLMay 31, 1981 · N197T · Substantial damage NTSB LAX81FA095Accident · 2 fatalClosedPiper PA-18 · Holtville, CAMay 31, 1981 · N4711A · Destroyed NTSB FTW81FPD26Accident · 1 fatalClosedEaa Biplane BR-1 · Brownwood, TXMay 31, 1981 · N3181 · Substantial damage NTSB FTW81FPD25Accident · Minor injuriesClosedCessna 152 · Lewisville, TXMay 31, 1981 · N48586 · Substantial damage NTSB FTW81FA098Accident · 1 fatalClosedAerospatial AS-350 · Cameron, LAMay 31, 1981 · N3607G · Destroyed NTSB FTW81DQG32Accident · No injuriesClosedPiper PA-28 · Big Spring, TXMay 31, 1981 · N47849 · Substantial damage NTSB DEN81FTE42Accident · No injuriesClosedCessna 150 · La Junta, COMay 31, 1981 · N8713S · Substantial damage NTSB DEN81FA038Accident · 2 fatalClosedCessna 182 · Mandaree, NDMay 31, 1981 · N3458S · Destroyed NTSB CHI81FEV20Accident · Serious injuriesClosedRodgers Soneri · Moweaqua, ILMay 31, 1981 · N6CR · Substantial damage NTSB CHI81FER39Accident · Serious injuriesClosedPiper PA-25 · Lake Elmo, MNMay 31, 1981 · N6140Z · Destroyed NTSB CHI81FEM18Accident · No injuriesClosedCessna 170B · Lowell, MIMay 31, 1981 · N2836C · Substantial damage NTSB CHI81FEM17Accident · No injuriesClosedCessna 152 · Shepard, MIMay 31, 1981 · N5108L · Substantial damage NTSB CHI81FEI19Accident · No injuriesClosedPitts S-1E · Medina, OHMay 31, 1981 · N45WA · Substantial damage NTSB CHI81FA061Accident · 1 fatalClosedBeech T-34B · New Castle, INMay 31, 1981 · N74195 · Destroyed NTSB MKC81FCQ38Accident · No injuriesClosedCessna 180 · Mankato, KSMay 30, 1981 · N9305C · Substantial damage NTSB LAX81FA094Accident · 1 fatalClosedCessna 170A · Homeland, CAMay 30, 1981 · N1305D · Destroyed NTSB LAX81DVM23Accident · No injuriesClosedCessna 182 · Santa Cruz, CAMay 30, 1981 · N4838N · Substantial damage NTSB LAX81DVD28Accident · No injuriesClosedHiller Acft UH-12E · Orleans, CAMay 30, 1981 · N62409 · Substantial damage NTSB LAX81DUQ23Accident · No injuriesClosedSikorsky S-58 · Tehachapi, CAMay 30, 1981 · N8294 · Substantial damage NTSB FTW81FQG34Accident · No injuriesClosedPiper PA-34 · Amarillo, TXMay 30, 1981 · N33099 · Substantial damage NTSB FTW81DPG36Accident · No injuriesClosedGrumman G-164 · Hughes, ARMay 30, 1981 · N11KQ · Destroyed NTSB DEN81FTG10Accident · No injuriesClosedGrumman G-164A · Edinberg, NDMay 30, 1981 · N958X · Substantial damage NTSB DEN81FTE41Accident · No injuriesClosedGrumman AA-5A · Bennett, COMay 30, 1981 · N26872 · Substantial damage NTSB DEN81FTE40Accident · Minor injuriesClosedSchweizer 134 · Colorado Spgs, COMay 30, 1981 · N7676 · Substantial damage NTSB CHI81FEE37Accident · No injuriesClosedCessna 172P · Plainfield, ILMay 30, 1981 · N53015 · Substantial damage NTSB CHI81FEC26Accident · Serious injuriesClosedPiper PA-28 · Bad Axe, MIMay 30, 1981 · N4996F · Destroyed NTSB ANC81DAG38Accident · No injuriesClosedCessna 182A · Willow, AKMay 30, 1981 · N3840D · Substantial damage NTSB SEA82FYE30Accident · No injuriesClosedHelio H-391B · Bellingham, WAMay 29, 1981 · N316HW · Substantial damage NTSB SEA81FYM25Accident · No injuriesClosedHiller Acft UH-12E · Milton-Freewtr, ORMay 29, 1981 · N99575 · Substantial damage NTSB NYC81IA051Incident · No injuriesClosedSwearingen SA226 · Newark, NJMay 29, 1981 · N105UR · 2 aircraft · Minor damage NTSB NYC81FNA16Accident · Minor injuriesClosedCessna 172N · Cranston, RIMay 29, 1981 · N3543E · Substantial damage NTSB NYC81FA052Accident · 2 fatalClosedBell 206B · Montrose, NYMay 29, 1981 · N1087S · Destroyed NTSB MIA81DKJ09Accident · No injuriesClosedPiper PA-38 · Panama City, FLMay 29, 1981 · N2379G · Substantial damage NTSB LAX81FJA11Accident · No injuriesClosedStinson 108 · Kaunakakai, HIMay 29, 1981 · N97726 · Substantial damage NTSB LAX81FA093Accident · 6 fatalClosedSikorsky S-55 · Beaumont, CAMay 29, 1981 · N874 · Destroyed NTSB LAX81DVA42Accident · No injuriesClosedPiper PA-28 · Coalinga, CAMay 29, 1981 · N2376T · Substantial damage NTSB FTW81DRA38Accident · No injuriesClosedRockwell S2R · Ganado, TXMay 29, 1981 · N4937X · Destroyed NTSB FTW81DRA37Accident · No injuriesClosedCessna 172 · Houston, TXMay 29, 1981 · N73562 · Substantial damage NTSB FTW81DPG30Accident · No injuriesClosedGrumman G-164A · Hughes, ARMay 29, 1981 · N8911H · Substantial damage NTSB CHI81FER40Accident · No injuriesClosedCessna A188B · Leroy, MNMay 29, 1981 · N4797Q · Substantial damage NTSB CHI81FEI18Accident · No injuriesClosedGrumman G-164A · Vanlue, OHMay 29, 1981 · N6540 · Substantial damage NTSB CHI81DEE36Accident · No injuriesClosedGrum-Amer AA-5A · Morris, ILMay 29, 1981 · N9682U · Substantial damage NTSB ATL81FLT09Accident · Minor injuriesClosedCessna 150 · Bolivar, TNMay 29, 1981 · N6789G · Substantial damage NTSB ATL81FKG20Accident · No injuriesClosedCessna 421 · Statesboro, GAMay 29, 1981 · N76ES · Substantial damage NTSB SEA81DYP20Accident · No injuriesClosedPiper PA-28 · Lucille, IDMay 28, 1981 · N38421 · Substantial damage