Skip to content

NTSB investigations, 1981

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") = 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 SEA81DYA24Accident · No injuriesClosedGrumman G-164 · Rigby, IDAug 18, 1981 · N715Y · Substantial damage NTSB NYC81FFA23Accident · No injuriesClosedGulf Amer AA-5A · Amsterdam, NYAug 18, 1981 · N26759 · Substantial damage NTSB LAX81FVM26Accident · No injuriesClosedCessna 310C · Paso Robles, CAAug 18, 1981 · N1890H · Substantial damage NTSB LAX81FA120Accident · Serious injuriesClosedCessna T207A · Tusayan, AZAug 18, 1981 · N6441H · Substantial damage NTSB FTW81FPA18Accident · No injuriesClosedRobinson R22 · Corsicana, TXAug 18, 1981 · N9037U · Substantial damage NTSB FTW81DRD37Accident · No injuriesClosedCessna 180J · Dulac, LAAug 18, 1981 · N42025 · Substantial damage NTSB DEN81FA058Accident · Minor injuriesClosedBell 206B · Escalante, UTAug 18, 1981 · N206LC · Substantial damage NTSB CHI81FEV33Accident · No injuriesClosedCessna 172I · Danville, ILAug 18, 1981 · N8416L · Substantial damage NTSB CHI81FER62Accident · No injuriesClosedStinson 108-1 · Wells, MNAug 18, 1981 · N9068K · Substantial damage NTSB CHI81FEE50Accident · Minor injuriesClosedCessna 152 · Chicago, ILAug 18, 1981 · N6610L · Substantial damage NTSB CHI81DEM38Accident · No injuriesClosedCessna 150 · Mcbain, MIAug 18, 1981 · N7983R · Substantial damage NTSB SEA81FYA23Accident · No injuriesClosedPiper PA-25 · Caldwell, IDAug 17, 1981 · N7435Z · Substantial damage NTSB NYC81FGM25Accident · Minor injuriesClosedBeech 23 · Irwin, PAAug 17, 1981 · N2358J · Substantial damage NTSB MKC81FCD36Accident · Minor injuriesClosedPietenpol Aircmp · Blakesburg, IAAug 17, 1981 · N12939 · Substantial damage NTSB MIA81AA106Accident · Minor injuriesClosedBoeing 727 · Ft.Lauderdale, FLAug 17, 1981 · N4742 · Substantial damage NTSB LAX81FVW16Accident · Minor injuriesClosedErco 415-D · Indian Springs, NVAug 17, 1981 · N99848 · Substantial damage NTSB LAX81DXQ32Accident · Serious injuriesClosedGlasfugel H301 · Truckee, CAAug 17, 1981 · N9515 · Destroyed NTSB LAX81AA119Accident · 1 fatalClosedPiper PA-28R · San Jose, CAAug 17, 1981 · N15611 · 2 aircraft · Destroyed NTSB FTW81DQD31Accident · No injuriesClosedCessna 188 · Presidio, TXAug 17, 1981 · N6111G · Substantial damage NTSB CHI81FER61Accident · Serious injuriesClosedPiper PA-25 · Fairmont, MNAug 17, 1981 · N6643Z · Substantial damage NTSB ANC81IA097Incident · No injuriesClosedPiper PA-34 · Tooksok Bay, AKAug 17, 1981 · N31941 · Minor damage NTSB ANC81FAA26Accident · No injuriesClosedPiper PA-18 · Kotzebue, AKAug 17, 1981 · N5976D · Substantial damage NTSB ANC81FA101Accident · 4 fatalClosedCessna 180H · Missing AircraftAug 17, 1981 · N3424Y · Destroyed NTSB ANC81DAG87Accident · No injuriesClosedBellanca 7AC · Iliamna, AKAug 17, 1981 · N3116E · Substantial damage NTSB ANC81DAG67Accident · No injuriesClosedPiper PA-18 · Glennallen, AKAug 17, 1981 · N13KW · Destroyed NTSB SEA81FYP35Accident · No injuriesClosedNavion · Spangle, WAAug 16, 1981 · N91104 · Substantial damage NTSB MKC81FCD35Accident · No injuriesClosedAeronca 7AC · Blakesburg, IAAug 16, 1981 · N84486 · Substantial damage NTSB MKC81FCD33Accident · No injuriesClosedPiper PA-25 · Clear Lake, IAAug 16, 1981 · N4844Y · Substantial damage NTSB MIA81FA105Accident · 4 fatalClosedAero Comdr 680FL · St.Croix, VIAug 16, 1981 · N6600M · Destroyed NTSB LAX81FVD40Accident · 1 fatalClosedMinatre KR-2 · Tracy, CAAug 16, 1981 · N23WM · Destroyed NTSB FTW81FQG53Accident · No injuriesClosedVarieze 01 · Lubbock, TXAug 16, 1981 · N247EZ · Destroyed NTSB FTW81FPA15Accident · Minor injuriesClosedBellanca 7KCAB · Bonham, TXAug 16, 1981 · N86702 · Destroyed NTSB FTW81FA132Accident · 2 fatalClosedPiper PA-32R · Mount Hermon, LAAug 16, 1981 · N304FW · Destroyed NTSB FTW81DQD32Accident · No injuriesClosedBoeing B75N1 · El Paso, TXAug 16, 1981 · N9912H · Substantial damage NTSB DEN81FTM38Accident · Minor injuriesClosedCessna 172 · Spring City, UTAug 16, 1981 · N64518 · Substantial damage NTSB DEN81FTK22Accident · No injuriesClosedPiper PA-18 · Stratford, SDAug 16, 1981 · N4191Z · Substantial damage NTSB CHI81FEV31Accident · No injuriesClosedCessna 421 · Springfield, ILAug 16, 1981 · N14TC · Substantial damage NTSB CHI81FEM85Accident · No injuriesClosedLuscombe 8E · Gladwin, MIAug 16, 1981 · N2052K · Substantial damage NTSB ATL81FLG21Accident · No injuriesClosedStarduster TWO · Blue Ridge, SCAug 16, 1981 · N600S · Substantial damage NTSB ATL81DKJ32Accident · Serious injuriesClosedPiper PA-32 · Tuscaloosa, ALAug 16, 1981 · N4529X · Destroyed NTSB ANC81DAG66Accident · Serious injuriesClosedBellanca 7GCAA · Sterling, AKAug 16, 1981 · N57653 · Substantial damage NTSB ANC81DAA25Accident · No injuriesClosedPiper PA-18 · Fairbanks, AKAug 16, 1981 · N5087Y · Substantial damage NTSB NYC81FFA21Accident · No injuriesClosedLake LA-4 · Lake George, NYAug 15, 1981 · N65723 · Substantial damage NTSB MIA81FKT88Accident · Minor injuriesClosedLake LA-4 · Tavernier, FLAug 15, 1981 · N11481 · Destroyed NTSB FTW81FRA53Accident · No injuriesClosedVultee BT-13A · Friendswood, TXAug 15, 1981 · N67208 · Substantial damage NTSB FTW81FRA51Accident · Serious injuriesClosedEaa Biplane P-2 · Baytown, TXAug 15, 1981 · N8WG · Substantial damage NTSB FTW81FA131Accident · Minor injuriesClosedBell 206L-1 · Mesquite, TXAug 15, 1981 · N3887W · Substantial damage NTSB FTW81DRD38Accident · No injuriesClosedCessna A188B · Labbadiville, LAAug 15, 1981 · N4952R · Substantial damage NTSB FTW81DQG54Accident · No injuriesClosedHeadwind Main · Canyon, TXAug 15, 1981 · N30123 · Substantial damage NTSB FTW81DQG52Accident · No injuriesClosedCessna 188 · Panhandle, TXAug 15, 1981 · N3568Q · Substantial damage