Skip to content

NTSB investigations, 1978, ID

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 per year

19642026

NTSB investigations, 1978, ID per year, 1964–2026: 2,504 cases
1964	70
1965	49
1966	62
1967	64
1968	65
1969	47
1970	54
1971	57
1972	41
1973	48
1974	63
1975	56
1976	63
1977	48
1978	43
1979	56
1980	44
1981	40
1982	47
1983	41
1984	41
1985	46
1986	50
1987	25
1988	29
1989	22
1990	30
1991	30
1992	37
1993	26
1994	39
1995	35
1996	33
1997	31
1998	41
1999	46
2000	34
2001	24
2002	48
2003	52
2004	40
2005	38
2006	30
2007	40
2008	34
2009	37
2010	37
2011	33
2012	40
2013	32
2014	30
2015	27
2016	22
2017	31
2018	28
2019	33
2020	24
2021	39
2022	27
2023	29
2024	35
2025	22
2026	19

Where

Latest cases

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 AND c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA' 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
    AND c.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
  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
  AND c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA'
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 SEA79DYA06Accident · No injuriesClosedPiper PA-24 · Driggs, IDDec 18, 1978 · N5285P · Substantial damage NTSB SEA79DYP05Accident · No injuriesClosedMaule M4220C · Coeur D'Alene, IDDec 17, 1978 · N40314 · Substantial damage NTSB SEA79DYA05Accident · No injuriesClosedStinson 108-3 · Smiths Prairie, IDDec 5, 1978 · N783C · Substantial damage NTSB SEA79DYP02Accident · No injuriesClosedPiper PA-22 · Nez Perce, IDNov 1, 1978 · N3380A · Substantial damage NTSB SEA79DYP01Accident · Minor injuriesClosedCessna 172 · Elk City, IDOct 29, 1978 · N1557V · Substantial damage NTSB SEA79FA007Accident · 1 fatalClosedSchweizer SGS232 · Hailey, IDOct 28, 1978 · N5753S · Destroyed NTSB SEA79FA004Accident · No injuriesClosedPiper PA-32 · Mc Call, IDOct 20, 1978 · N55571 · Substantial damage NTSB SEA79DYA03Accident · No injuriesClosedCessna 150 · Idaho Falls, IDOct 20, 1978 · N6758S · Substantial damage NTSB SEA79DYA02Accident · Minor injuriesClosedCessna 172B · St.Anthony, IDOct 10, 1978 · N6946X · Substantial damage NTSB SEA79DYA01Accident · No injuriesClosedBellanca 7GCBC · Hailey, IDOct 10, 1978 · N36233 · Destroyed NTSB SEA78FYP54Accident · Minor injuriesClosedCessna 150 · Coeur D'Alene, IDSep 29, 1978 · N6745F · Substantial damage NTSB SEA78FYA26Accident · No injuriesClosedGrumman G-164B · Homedale, IDSep 20, 1978 · N48542 · Destroyed NTSB SEA78DYA25Accident · No injuriesClosedStinson 108-3 · Boise, IDSep 13, 1978 · N6659M · Substantial damage NTSB SEA78FA064Accident · 1 fatalClosedCessna 185F · Riggins, IDSep 11, 1978 · N80172 · Destroyed NTSB SEA78FA060Accident · 2 fatalClosedPiper J3C · Mccall, IDSep 3, 1978 · N88185 · Destroyed NTSB SEA78DYA24Accident · Minor injuriesClosedGrumman G-164A · Oakley, IDSep 1, 1978 · N7365 · Substantial damage NTSB SEA78FYA22Accident · Minor injuriesClosedCessna 177 · Homedale, IDAug 12, 1978 · N13503 · Substantial damage NTSB SEA78FYP47Accident · Serious injuriesClosedBellanca 7GCBC · Nez Perce, IDAug 11, 1978 · N2684Z · Destroyed NTSB SEA78FYA21Accident · 1 fatalClosedAir Tractor AT-300 · Idaho Falls, IDAug 11, 1978 · N4331S · Substantial damage NTSB SEA78FA054Accident · 1 fatalClosedCessna T206 · Challis, IDAug 10, 1978 · N756LV · Destroyed NTSB SEA78DYA23Accident · No injuriesClosedEnstrom 280C · Buhl, IDAug 6, 1978 · N51651 · Destroyed NTSB SEA78DYP45Accident · No injuriesClosedCessna 172 · St.Maries, IDJul 24, 1978 · N13403 · Substantial damage NTSB SEA78FYA19Accident · Serious injuriesClosedBeech S35 · Yellow Pine, IDJul 23, 1978 · N9391 · Destroyed NTSB SEA78FYA17Accident · No injuriesClosedGrumman G-164B · Burley, IDJul 19, 1978 · N6704Q · Destroyed NTSB SEA78DYA16Accident · No injuriesClosedEnstrom 280C · Boise, IDJul 19, 1978 · N123MT · Substantial damage NTSB SEA78DYP40Accident · No injuriesClosedCessna 188 · Tilma, IDJul 17, 1978 · N80770 · Substantial damage NTSB SEA78FA047Accident · 1 fatalClosedPiper PA-28R · Coeur D'Alene, IDJul 16, 1978 · N5068S · Substantial damage NTSB SEA78DYP38Accident · No injuriesClosedCessna 172 · Riggins, IDJul 11, 1978 · N73819 · Substantial damage NTSB SEA78FA040Accident · 2 fatalClosedHughes 369D · New Meadows, IDJun 29, 1978 · N8380F · Destroyed NTSB SEA78DYA14Accident · No injuriesClosedPiper PA-18 · Star, IDJun 28, 1978 · N3882Z · Substantial damage NTSB SEA78DYA13Accident · Minor injuriesClosedAero Comdr A-9B · Rigby, IDJun 21, 1978 · N8023V · Destroyed NTSB SEA78DYA12Accident · No injuriesClosedGrumman G-164A · Terreton, IDJun 19, 1978 · N8712H · Substantial damage NTSB SEA78DYA15Accident · No injuriesClosedPiper PA-18 · Rexbury, IDJun 17, 1978 · N8950C · Substantial damage NTSB SEA78FA036Accident · 1 fatalClosedCessna 182A · Featherville, IDJun 9, 1978 · N2719G · Destroyed NTSB SEA78FYA11Accident · No injuriesClosedPiper PA-28R · Hailey, IDJun 6, 1978 · N47663 · Substantial damage NTSB SEA78DYA10Accident · No injuriesClosedBell 47G3B1 · Ukon, IDJun 1, 1978 · N88929 · Substantial damage NTSB SEA78DYA09Accident · No injuriesClosedLet-Np-K L-13 · Driggs, IDJun 1, 1978 · N65378 · Substantial damage NTSB SEA78FA031Accident · 1 fatalClosedBuhl Acft LA1 · Kimberly, IDMay 21, 1978 · N12106 · Destroyed NTSB SEA78DYA07Accident · No injuriesClosedPiper PA-25 · Midvale, IDMay 8, 1978 · N6887Z · Substantial damage NTSB SEA78DYA08Accident · No injuriesClosedCessna 177RG · Burley, IDApr 30, 1978 · C-GVBG · Substantial damage NTSB SEA78FYP16Accident · Serious injuriesClosedCessna 150 · Mccall, IDApr 8, 1978 · N6203T · Substantial damage NTSB SEA78FA024Accident · No injuriesClosedLear Jet 24D · Soda Springs, IDApr 7, 1978 · N78AE · Substantial damage NTSB SEA78FYA05Accident · Serious injuriesClosedCessna A188B · Preston, IDApr 6, 1978 · N9534G · 2 aircraft · Destroyed