Skip to content

NTSB investigations, 1978

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") = 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 FTW79DRD07Accident · No injuriesClosedCessna 152 · New Orleans, LANov 4, 1978 · N757SS · Substantial damage NTSB CHI79FEV03Accident · 1 fatalClosedStarduster TOO · Nhenderson, ILNov 4, 1978 · N762RD · Destroyed NTSB CHI79FET04Accident · 2 fatalClosedMonocoupe 90A · Mentone, INNov 4, 1978 · N18062 · Destroyed NTSB ANC79FA013Accident · No injuriesClosedHawker-Sdly DH-125 · Anchorage, AKNov 4, 1978 · N600JA · Substantial damage NTSB UNK79X0100Accident · No injuriesClosedCessna 182 · Grand Bahama, Burkina FasoNov 3, 1978 · N7057S · Destroyed NTSB NYC79FHM02Accident · No injuriesClosedCessa 182J · Tuxedo, NYNov 3, 1978 · N2617F · Substantial damage NTSB MKC79DCQ02Accident · Minor injuriesClosedPiper PA-28 · Palco, KSNov 3, 1978 · N8411C · Substantial damage NTSB MIA79FA010Accident · 1 fatalClosedPiper PA-31 · Missing AircraftNov 3, 1978 · N59912 · Destroyed NTSB MIA79FA008Accident · No injuriesClosedCessna 421B · Miami, FLNov 3, 1978 · N391E · Substantial damage NTSB LAX79FUQ06Accident · Minor injuriesClosedCessna 172I · Santa Barbara, CANov 3, 1978 · N46016 · Substantial damage NTSB LAX79DUG04Accident · No injuriesClosedCessna 182 · Apple Valley, CANov 3, 1978 · N7345S · Substantial damage NTSB FTW79DPJ02Accident · No injuriesClosedCessna 152 · Tonkawa, OKNov 3, 1978 · N714WX · Substantial damage NTSB CHI79FEX05Accident · Minor injuriesClosedCessna 172 · Martinsville, INNov 3, 1978 · N6861A · Substantial damage NTSB CHI79FEC05Accident · No injuriesClosedBeechcraft D-18S · Flint, MINov 3, 1978 · N80369 · Destroyed NTSB ANC79DAG20Accident · No injuriesClosedBellanca 7GCBC · Mc Grath, AKNov 3, 1978 · N31282 · Substantial damage NTSB ANC79DA014Accident · No injuriesClosedLear Jet 24D · Dutch Harbor, AKNov 3, 1978 · N455JA · Substantial damage NTSB SEA79FA009Accident · 3 fatalClosedCessna P210 · Toutle, WANov 2, 1978 · N3686P · Destroyed NTSB SEA79DYM04Accident · No injuriesClosedSoloy UH12E · Molalla, ORNov 2, 1978 · N5381V · Substantial damage NTSB NYC79FA007Accident · 2 fatalClosedCessna 172 · Marcy, NYNov 2, 1978 · N46037 · Substantial damage NTSB MKC79DER02Accident · No injuriesClosedBeech C35 · Pipestone, MNNov 2, 1978 · N5877C · Substantial damage NTSB MIA79FLD14Accident · No injuriesClosedCessna C-182R · Avon Park, FLNov 2, 1978 · N3206C · Substantial damage NTSB MIA79DLD13Accident · Minor injuriesClosedCessna 150 · Plymouth, FLNov 2, 1978 · N18059 · Destroyed NTSB MIA79DLD12Accident · No injuriesClosedBellanca 17-30A · Orlando, FLNov 2, 1978 · N39832 · Substantial damage NTSB FTW79FA009Accident · 2 fatalClosedAeronca 7EC · Richmond, LANov 2, 1978 · N4378C · Destroyed NTSB CHI79DEX07Accident · No injuriesClosedCessna 320C · Portland, INNov 2, 1978 · N3166T · Substantial damage NTSB SEA79DYP02Accident · No injuriesClosedPiper PA-22 · Nez Perce, IDNov 1, 1978 · N3380A · Substantial damage NTSB SEA79DYM05Accident · No injuriesClosedCessna 172 · Portland, ORNov 1, 1978 · N737BZ · Substantial damage NTSB OAK79FA009Accident · 3 fatalClosedMooney M20J · Capay, CANov 1, 1978 · N201WQ · Destroyed NTSB OAK79FA008Accident · 1 fatalClosedCessna T-210L · Dayton, NVNov 1, 1978 · N777FT · Destroyed NTSB OAK79FA007Accident · 2 fatalClosedBellanca 7ECA · San Jose, CANov 1, 1978 · N57642 · Destroyed NTSB OAK78FA051Accident · 2 fatalClosedBellanca 8KCAB · Truckee, CANov 1, 1978 · N4180Y · Destroyed NTSB MKC79DA005Accident · No injuriesClosedBarnes AX-7 · Overland Park, KSNov 1, 1978 · N2482H · Substantial damage NTSB MIA79DLA06Accident · No injuriesClosedCessna 150J · Jacksonville, FLNov 1, 1978 · N60537 · Substantial damage NTSB SEA79FA008Accident · 1 fatalClosedCessna 150H · Swan Lake, MTOct 31, 1978 · N7056S · Destroyed NTSB OAK79DVA08Accident · No injuriesClosedRockwell S2R · Firebaugh, CAOct 31, 1978 · N5556X · Substantial damage NTSB OAK79DJA03Accident · No injuriesClosedMurrayair MA1B · Honokaa, HIOct 31, 1978 · N305MA · Substantial damage NTSB MKC79FTG01Accident · No injuriesClosedCessna 152 · Grand Forks, NDOct 31, 1978 · N757SH · Substantial damage NTSB MIA79FLD06Accident · No injuriesClosedPiper PA-30 · Ft Pierce, FLOct 31, 1978 · N7708Y · Substantial damage NTSB CHI79FEG02Accident · No injuriesClosedBeech 58 · Cincinnati, OHOct 31, 1978 · N788CF · Substantial damage NTSB CHI79FEC02Accident · No injuriesClosedMitsubishi MU2B20 · Ypsilanti, MIOct 31, 1978 · N13EW · Substantial damage NTSB ANC79DA015Accident · 3 fatalClosedGrumman G-44A · Cordova, AKOct 31, 1978 · N444W · Destroyed NTSB OAK79DVD04Accident · No injuriesClosedCessna 210C · Willits, CAOct 30, 1978 · N3663Y · Substantial damage NTSB NYC79FHA04Accident · No injuriesClosedAnderson AK-1 · Warminister, PAOct 30, 1978 · N21W · Substantial damage NTSB NYC79FFJ03Accident · Minor injuriesClosedGrumman G-164B · Wolcott, NYOct 30, 1978 · N48724 · Substantial damage NTSB MIA79FA007Accident · 2 fatalClosedPiper PA-34 · Titusville, FLOct 30, 1978 · N1058U · Destroyed NTSB MIA79FA006Accident · No injuriesClosedDouglas DC-3 · Opa Locka, FLOct 30, 1978 · N95KT · Substantial damage NTSB MIA79FA005Accident · 3 fatalClosedBeech 95 · Madison, ALOct 30, 1978 · N2753Y · Destroyed NTSB MIA79DLD10Accident · No injuriesClosedCessna 182 · Plymouth, FLOct 30, 1978 · N9568Z · Substantial damage NTSB LAX79FUJ10Accident · Serious injuriesClosedCessna 182 · Buckeye, AZOct 30, 1978 · N1800M · Substantial damage NTSB LAX79FA010Accident · 2 fatalClosedPiper PA-32 · Mojave, CAOct 30, 1978 · N400EW · Destroyed