Skip to content

NTSB investigations, 1977

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") = 1977 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\") = 1977
  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") = 1977
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 MKC78DCQ10Accident · No injuriesClosedPiper PA-28 · Leoti, KSDec 20, 1977 · N4692R · Substantial damage NTSB IAD78FA023Accident · No injuriesClosedHamilton E18S · Covington, KYDec 20, 1977 · N342T · Substantial damage NTSB OAK78FXQ06Accident · Minor injuriesClosedPiper PA23 · Truckee, CADec 19, 1977 · N2206P · Substantial damage NTSB OAK78FVM07Accident · No injuriesClosedPiper PA-31 · San Francisco, CADec 19, 1977 · N59721 · Substantial damage NTSB NYC78DNC11Accident · No injuriesClosedCessna 172M · Harbor, MEDec 19, 1977 · N13144 · Substantial damage NTSB MKC78FER17Accident · No injuriesClosedCessna 150M · St Paul, MNDec 19, 1977 · N8747U · Substantial damage NTSB MIA78FA016Accident · 5 fatalClosedBrittnorman BN-2A · Vieques, PRDec 19, 1977 · N862JA · Destroyed NTSB LAX78DUM08Accident · No injuriesClosedPiper PA-24 · Santee, CADec 19, 1977 · N8155P · Substantial damage NTSB ANC78FA005Accident · 2 fatalClosedHiller Acft FH1100 · Anchor Point, AKDec 19, 1977 · N18845 · Destroyed NTSB SEA78DYM11Accident · No injuriesClosedCessna 152 · Dayton, ORDec 18, 1977 · N757JM · Substantial damage NTSB SEA78DTI03Accident · No injuriesClosedCessna 170 · Browning, MTDec 18, 1977 · N5414C · Substantial damage NTSB OAK78FA010Accident · 1 fatalClosedCessna U206 · Little River, CADec 18, 1977 · N29275 · Destroyed NTSB MIA78DLD18Accident · No injuriesClosedPiper PA-18 · Ft Pierce, FLDec 18, 1977 · N13921 · Substantial damage NTSB LAX78FUG07Accident · No injuriesClosedBellanca 8GCBC · Elsinore, CADec 18, 1977 · N88049 · Substantial damage NTSB IAD78DLJ04Accident · No injuriesClosedAeronca 7AC · Watha, NCDec 18, 1977 · N2406E · Substantial damage NTSB FTW78FRA11Accident · 1 fatalClosedLuscombe 8A · Pearland, TXDec 18, 1977 · N1285K · 2 aircraft · Destroyed NTSB FTW78FPD11Accident · No injuriesClosedRyan Navion · Denton, TXDec 18, 1977 · N4181K · Substantial damage NTSB FTW78DRG20Accident · Minor injuriesClosedGrum-Amer AA-1B · West Realitos, TXDec 18, 1977 · N1605R · Substantial damage NTSB FTW78DRG19Accident · No injuriesClosedCessna 172 · San Saba, TXDec 18, 1977 · N75594 · Substantial damage NTSB DCA78AA005Accident · 3 fatalClosedDouglas DC-8F · Kaysville, UTDec 18, 1977 · N8047U · Destroyed NTSB CHI78FEI05Accident · No injuriesClosedPiper PA-18 · Smithville, OHDec 18, 1977 · N46891 · Substantial damage NTSB SEA78FTA09Accident · No injuriesClosedCessna 150 · Peerless, MTDec 17, 1977 · N61067 · Substantial damage NTSB OAK78FJA01Accident · Minor injuriesClosedBeech C45G · Honolulu, HIDec 17, 1977 · N2874G · Destroyed NTSB MKC78IA015Incident · No injuriesClosedCessna 402 · Rolla, MODec 17, 1977 · N3295Q · Minor damage NTSB MKC78DCQ09Accident · No injuriesClosedCessna 172N · Wichita, KSDec 17, 1977 · N738KL · Substantial damage NTSB MIA78AF019Accident · 1 fatalClosedCessna 150 · Dauphin Island, ALDec 17, 1977 · N6589T · Destroyed NTSB LAX78FA013Accident · 2 fatalClosedPiper PA-30 · Van Nuys, CADec 17, 1977 · N922JS · Substantial damage NTSB LAX78FA012Accident · Minor injuriesClosedPiper PA-32 · Hesperia, CADec 17, 1977 · N3977W · Destroyed NTSB DEN78FQA08Accident · Minor injuriesClosedPiper PA-22 · Albuquerque, NMDec 17, 1977 · N1745P · Substantial damage NTSB CHI78FEX07Accident · Minor injuriesClosedPiper PA-23 · St Paul, INDec 17, 1977 · N498HH · Substantial damage NTSB CHI78FEE11Accident · No injuriesClosedBeech E18S · Chicago, ILDec 17, 1977 · N3131W · Substantial damage NTSB CHI78FA012Accident · 1 fatalClosedCessna U206F · Garrettsville, OHDec 17, 1977 · N1045V · Destroyed NTSB SEA78FA013Accident · 1 fatalClosedCessna 152 · Quincy, WADec 16, 1977 · N757TC · Destroyed NTSB MKC78FA014Accident · 1 fatalClosedPiper PA-28R · Waukon, IADec 16, 1977 · N44988 · Destroyed NTSB MKC78DCJ07Accident · Minor injuriesClosedMooney M10 · Emerson, NEDec 16, 1977 · N9525V · Substantial damage NTSB MIA78FKT22Accident · Serious injuriesClosedCessna 401 · W.Palm Beach, FLDec 16, 1977 · N80BW · Destroyed NTSB MIA78FKJI4Accident · No injuriesClosedCessna 421C · Bay Minette, ALDec 16, 1977 · N8305G · Substantial damage NTSB MIA78DA023Accident · 1 fatalClosedPiper PA-31 · Kingston (Atlantic Ocean)Dec 16, 1977 · N483LC · Destroyed NTSB DEN78FA016Accident · 2 fatalClosedLake LA-4 · Albuquerque, NMDec 16, 1977 · N6011V · Destroyed NTSB CHI78FEM06Accident · No injuriesClosedCessna 177 · Birch Run, MIDec 16, 1977 · N30275 · Substantial damage NTSB CHI78DEX06Accident · Serious injuriesClosedAerostar 601P · Evansville, INDec 16, 1977 · N9506Q · Minor damage NTSB SEA78DYP06Accident · No injuriesClosedCessna 172 · Pasco, WADec 15, 1977 · N9021H · Substantial damage NTSB OAK78FVM06Accident · Minor injuriesClosedBell 206B · San Jose, CADec 15, 1977 · N90226 · Substantial damage NTSB NYC78FFA12Accident · No injuriesClosedCessna 310 · Hudson, NYDec 15, 1977 · N1731G · Substantial damage NTSB MIA78FA015Accident · 1 fatalClosedPiper PA-18 · Jeffersonville, GADec 15, 1977 · N4890P · Destroyed NTSB LAX78FUD02Accident · No injuriesClosedHughes 369D · Los Angeles, CADec 15, 1977 · N8676F · Substantial damage NTSB OAK78FA009Accident · No injuriesClosedPiper PA-31 · Lake Tahoe, CADec 14, 1977 · N66895 · Substantial damage NTSB NYC78FA014Accident · No injuriesClosedLearjet 35 · Groton, CTDec 14, 1977 · N971H · Substantial damage NTSB MKC78FA013Accident · 2 fatalClosedPiper PA-34 · Davenport, IADec 14, 1977 · N1634H · Destroyed NTSB MIA78DKT21Accident · No injuriesClosedGrumman G-164B · Clewiston, FLDec 14, 1977 · N6771Q · Destroyed