Skip to content

NTSB investigations, 1978

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") = 1978 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\") = 1978
  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") = 1978
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 MIA78DKJ93Accident · Minor injuriesClosedErco 415-C · Cragford, ALSep 24, 1978 · N3100H · Substantial damage NTSB LAX78FUK09Accident · Serious injuriesClosedEnstrom 280C · Kingman, AZSep 24, 1978 · N665H · Destroyed NTSB LAX78FA079Accident · 2 fatalClosedCessna 182M · Santa Barbara, CASep 24, 1978 · N71182 · Destroyed NTSB FTW78FA084Accident · Serious injuriesClosedGrumman G-159 · Houston, TXSep 24, 1978 · N91G · Destroyed NTSB DEN78DTM23Accident · No injuriesClosedCessna 180 · Hite, UTSep 24, 1978 · N9177C · Substantial damage NTSB CHI78FET38Accident · No injuriesClosedCessna 177 · Fort Wayne, INSep 24, 1978 · N2605Q · Substantial damage NTSB OAK78DVM49Accident · No injuriesClosedBenson B8M · Watsonville, CASep 23, 1978 · N1450 · Substantial damage NTSB NYC79FGM01Accident · Minor injuriesClosedDuster BU-18 · Eighty Four, PASep 23, 1978 · N12DQ · Substantial damage NTSB NYC78FHJ22Accident · Minor injuriesClosedCessna 172 · Islip, NYSep 23, 1978 · N9892Q · Substantial damage NTSB NYC78FHA39Accident · 1 fatalClosedBlanik L-3 · Pittstown, NJSep 23, 1978 · N90861 · Destroyed NTSB NYC78FHA37Accident · 1 fatalClosedSoneria II · Pipersville, PASep 23, 1978 · N81915 · Substantial damage NTSB NYC78DHA36Accident · No injuriesClosedBeech 23 · Warrington, PASep 23, 1978 · N23987 · Substantial damage NTSB MKC78FCG69Accident · Serious injuriesClosedCessna 172 · Gravois Mills, MOSep 23, 1978 · N70395 · Substantial damage NTSB MKC78DER94Accident · Minor injuriesClosedGrumman AA-5 · Milaca, MNSep 23, 1978 · N5824L · Substantial damage NTSB LAX78DUG56Accident · No injuriesClosedCessna 182M · El Monte, CASep 23, 1978 · N70833 · Substantial damage NTSB IAD78PIJ20Accident · No injuriesClosedPiper PA-32R · Wise, VASep 23, 1978 · N43941 · Substantial damage NTSB IAD78FLQ36Accident · No injuriesClosedCessna T210M · Owensboro, KYSep 23, 1978 · N732KP · Substantial damage NTSB IAD78FIA19Accident · 1 fatalClosedPiper PA-28 · Indian Head, MDSep 23, 1978 · N5179F · Destroyed NTSB FTW78FA085Accident · 7 fatalClosedAero Comdr 500 · Laredo, TXSep 23, 1978 · N6244B · Destroyed NTSB FTW78DQG52Accident · No injuriesClosedBeech 95B55 · Amarillo, TXSep 23, 1978 · N443T · Substantial damage NTSB DEN78FTF01Accident · No injuriesClosedCessna T337 · Calhan, COSep 23, 1978 · N47789 · Substantial damage NTSB CHI78FEX40Accident · Minor injuriesClosedBell 47G2 · Waveland, INSep 23, 1978 · N8429E · Substantial damage NTSB CHI78FEG18Accident · No injuriesClosedAeronca 11AC · Lebanon, OHSep 23, 1978 · N9636E · Substantial damage NTSB CHI78FEG17Accident · No injuriesClosedCessna 150 · Germantown, OHSep 23, 1978 · N19244 · Destroyed NTSB ANC79DAG32Accident · No injuriesClosedNavion NA-1 · Naknek, AKSep 23, 1978 · N4586K · Substantial damage NTSB OAK78FVA86Accident · Serious injuriesClosedCessna 188 · Mendota, CASep 22, 1978 · N4913Q · Destroyed NTSB OAK78FA057Accident · 2 fatalClosedPiper PA-28 · Concord, CASep 22, 1978 · N36762 · 2 aircraft · Destroyed NTSB NYC78FGM52Accident · Minor injuriesClosedPiper J-3 · Somerset, PASep 22, 1978 · N6720H · Substantial damage NTSB MKC78FCG70Accident · Minor injuriesClosedCessna 172 · Higginsville, MOSep 22, 1978 · N737LX · Substantial damage NTSB MKC78DER98Accident · No injuriesClosedCessna 172 · Warren, MNSep 22, 1978 · N8976B · Substantial damage NTSB MKC78DCG68Accident · No injuriesClosedCessna 170B · Grain Valley, MOSep 22, 1978 · N3542C · Substantial damage NTSB MIA78FA126Accident · 2 fatalClosedCessna 337G · Atlanta, GASep 22, 1978 · N1309L · Destroyed NTSB MIA78DKQ41Accident · No injuriesClosedCessna 152 · Tylertown, MSSep 22, 1978 · N66946 · Substantial damage NTSB CHI78FCA03Accident · No injuriesClosedCessna 150M · Cahokia, ILSep 22, 1978 · N714LV · Substantial damage NTSB ANC79DAG01Accident · Minor injuriesClosedPiper PA-18 · Lake Louise, AKSep 22, 1978 · N12316 · Substantial damage NTSB ANC78FAA39Accident · No injuriesClosedMaule M-5 · Kotzbue, AKSep 22, 1978 · N372X · Substantial damage NTSB ANC78FA080Accident · Serious injuriesClosedCessna 170-A · Anchorage, AKSep 22, 1978 · N9780A · Substantial damage NTSB OAK78FVM48Accident · Serious injuriesClosedBellanca 7KCAB · Half Moon Bay, CASep 21, 1978 · N7682S · Substantial damage NTSB NYC78FHA38Accident · No injuriesClosedCessna 206 · Prospectville, PASep 21, 1978 · N1872N · Substantial damage NTSB MIA78FKQ39Accident · Serious injuriesClosedCessna 188B · Inverness, MSSep 21, 1978 · N4783Q · Destroyed NTSB MIA78FA128Accident · 4 fatalClosedDouglas DC-3 · Missing AircraftSep 21, 1978 · N407D · Destroyed NTSB MIA78DLD78Accident · Serious injuriesClosedCessna 172 · Sanibel Is, FLSep 21, 1978 · N5030R · Substantial damage NTSB LAX78IA078Incident · No injuriesClosedCessna 402B · Phoenix, AZSep 21, 1978 · N98685 · Minor damage NTSB DEN78FQA59Accident · No injuriesClosedCessna 152 · Albuquerque, NMSep 21, 1978 · N24916 · Substantial damage NTSB ANC79DAG09Accident · Minor injuriesClosedPiper PA-11 · Kenai, AKSep 21, 1978 · N4883M · Substantial damage NTSB SEA78FYK24Accident · 1 fatalClosedCallair B-1A · Glide, ORSep 20, 1978 · N7269V · Substantial damage NTSB SEA78FYA26Accident · No injuriesClosedGrumman G-164B · Homedale, IDSep 20, 1978 · N48542 · Destroyed NTSB OAK78DVG83Accident · No injuriesClosedGrumman G-164B · Robbins, CASep 20, 1978 · N6725K · Substantial damage NTSB NYC78FNE35Accident · No injuriesClosedPiper PA-28 · Northampton, MASep 20, 1978 · N56694 · 2 aircraft · Substantial damage NTSB NYC78FHA35Accident · No injuriesClosedCessna 150 · Rock Hill, NJSep 20, 1978 · N63615 · Substantial damage