Skip to content

NTSB investigations, 1977

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 FTW78FPA11Accident · No injuriesClosedPiper PA-24 · Paris, TXDec 25, 1977 · N8509P · Substantial damage NTSB ANC78DAG20Accident · No injuriesClosedPiper PA-22 · Talkeenta, AKDec 25, 1977 · N5417Z · Substantial damage NTSB ANC78DAG16Accident · No injuriesClosedCessna 180 · Anchorage, AKDec 25, 1977 · N2230C · Substantial damage NTSB NYC78FNE01Accident · No injuriesClosedGrum Amer AA5-A · Sterling, MADec 24, 1977 · N9961U · Substantial damage NTSB NYC78DNC07Accident · No injuriesClosedCessna 140 · Jaffey, NHDec 24, 1977 · N90019 · Substantial damage NTSB MIA78FKQ04Accident · Minor injuriesClosedCessna 172 · Natchez, MSDec 24, 1977 · N1097U · Substantial damage NTSB MIA78FA022Accident · 2 fatalClosedCessna 172 · Blairsville, GADec 24, 1977 · N4183L · Destroyed NTSB MIA78DA025Accident · 3 fatalClosedPiper PA-28 · Mayaguez (Atlantic Ocean)Dec 24, 1977 · N4901J · Destroyed NTSB LAX78DUM09Accident · No injuriesClosedBellanca 7KCAB · Escondido, CADec 24, 1977 · N3045G · Substantial damage NTSB IAD78FA025Accident · 2 fatalClosedCessna 206F · Sylva, NCDec 24, 1977 · N8290Q · Destroyed NTSB SEA78DYK05Accident · No injuriesClosedPiper PA-28 · Agness, ORDec 23, 1977 · N56759 · Substantial damage NTSB SEA78DTI04Accident · No injuriesClosedPiper PA-18 · Livingston, MTDec 23, 1977 · N4996P · Substantial damage NTSB NYC78DNC10Accident · No injuriesClosedPiper PA-28 · West Dover, VTDec 23, 1977 · N4495X · Substantial damage NTSB NYC78DNC06Accident · Minor injuriesClosedCessna 177 · Jaffrey, NHDec 23, 1977 · N29319 · Substantial damage NTSB NYC78DNC05Accident · No injuriesClosedCessna 172M · Nashua, NHDec 23, 1977 · N13599 · Substantial damage NTSB MKC78FA016Accident · 2 fatalClosedLuscombe 8E · Gordon, NEDec 23, 1977 · N1226K · Destroyed NTSB MIA78FA020Accident · 2 fatalClosedCessna 150 · Plantation, FLDec 23, 1977 · N10608 · Destroyed NTSB MIA78DLA14Accident · No injuriesClosedCessna 172 · St Augustine, FLDec 23, 1977 · N5143R · Substantial damage NTSB MIA78DKJ15Accident · No injuriesClosedCessna 177B · Tuscaloosa, ALDec 23, 1977 · N18643 · Substantial damage NTSB IAD78DIG04Accident · No injuriesClosedCessna 182 · Hempstead, MDDec 23, 1977 · C-FUFE · Substantial damage NTSB FTW78FPA09Accident · Minor injuriesClosedPiper PA-28 · Allen, TXDec 23, 1977 · N55285 · Destroyed NTSB FTW78DQD08Accident · 1 fatalClosedCessna 177RG · Coyanosa, TXDec 23, 1977 · CF-BTL · Destroyed NTSB FTW78DA020Accident · No injuriesClosedCessna 180 · Marsh Island, LADec 23, 1977 · N9047M · Substantial damage NTSB DEN78FQA09Accident · Minor injuriesClosedCessna T210L · Moriarty, NMDec 23, 1977 · N5114Q · Substantial damage NTSB CHI78FEI06Accident · Minor injuriesClosedCessna T337C · Akron, OHDec 23, 1977 · N99SB · Substantial damage NTSB CHI78DEE15Accident · No injuriesClosedPiper PA28 · Wheeling, ILDec 23, 1977 · N8817C · Substantial damage NTSB ANC78DA007Accident · Minor injuriesClosedCessna 207 · Iliamna, AKDec 23, 1977 · N1656U · Destroyed NTSB ANC78DA006Accident · No injuriesClosedBeech 65-A80 · Allakaket, AKDec 23, 1977 · N140RH · Substantial damage NTSB SEA78FA014Accident · 7 fatalClosedAero Cmdr 520 · Cheshire, ORDec 22, 1977 · C-GHUN · Destroyed NTSB SEA78DYK04Accident · Minor injuriesClosedHiller Acft FH1100 · Walton, ORDec 22, 1977 · N92484 · Destroyed NTSB NYC78FA019Accident · 1 fatalClosedCessna 404 · Buffalo, NYDec 22, 1977 · N404SA · Destroyed NTSB MKC78DCD10Accident · Minor injuriesClosedCessna 150 · Tipton, IADec 22, 1977 · N66055 · Substantial damage NTSB MIA78FLA11Accident · No injuriesClosedCessna 310C · Jacksonville, FLDec 22, 1977 · N1757H · Substantial damage NTSB IAD78FA024Accident · Minor injuriesClosedCessna 150 · Arlington, TNDec 22, 1977 · N6431K · 2 aircraft · Substantial damage NTSB FTW78FQD07Accident · No injuriesClosedBellanca 17-31 · Salt Flat, TXDec 22, 1977 · N8852V · Substantial damage NTSB FTW78FPJ10Accident · No injuriesClosedPiper PA-32 · Oklahoma City, OKDec 22, 1977 · N3476W · Substantial damage NTSB FTW78FA019Accident · 2 fatalClosedPiper PA-28R · Giddings, TXDec 22, 1977 · N116MM · Destroyed NTSB FTW78DPM02Accident · No injuriesClosedCessna 150 · Claremore, OKDec 22, 1977 · N9141U · Substantial damage NTSB CHI78FET06Accident · Minor injuriesClosedCessna 172F · Fort Wayne, INDec 22, 1977 · N7860U · Substantial damage NTSB CHI78FEE14Accident · No injuriesClosedBeech E18 · Chicago, ILDec 22, 1977 · N202GW · Substantial damage NTSB SEA78FYM12Accident · Minor injuriesClosedBeech A23 · Newberg, ORDec 21, 1977 · N14311 · Substantial damage NTSB OAK78FA011Accident · 1 fatalClosedCessna 172M · Orland, CADec 21, 1977 · N12699 · Destroyed NTSB MKC78FTK07Accident · No injuriesClosedPiper PA-18 · Mission Ridge, SDDec 21, 1977 · N8302P · Substantial damage NTSB MIA78FLA10Accident · No injuriesClosedLockheed L-18 · Jacksonville, FLDec 21, 1977 · N33FB · Substantial damage NTSB MIA78DKT23Accident · No injuriesClosedHiller UH-12D · Jupiter, FLDec 21, 1977 · N501AG · Destroyed NTSB LAX78FUJ19Accident · No injuriesClosedCessna 185F · Mesa, AZDec 21, 1977 · N183Z · Substantial damage NTSB FTW78FQG10Accident · Minor injuriesClosedPiper PA-18A · Sterling City, TXDec 21, 1977 · N2260A · Destroyed NTSB FTW78FPG11Accident · Minor injuriesClosedCessna 170A · Heber Springs, ARDec 21, 1977 · N9074A · Destroyed NTSB SEA78FTA08Accident · Minor injuriesClosedBell 47G3B1 · Billings, MTDec 20, 1977 · N7860S · Destroyed NTSB NYC78FA015Accident · 1 fatalClosedBeagle B206 · Greenwich, CTDec 20, 1977 · N1008B · Destroyed