Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 SEA80DYA05Accident · No injuriesClosedMooney M20E · Burley, IDDec 21, 1979 · N1306W · Substantial damage NTSB SEA80DYA04Accident · No injuriesClosedAerosport Quail · Idaho Falls, IDDec 18, 1979 · N47075 · Substantial damage NTSB SEA80FYP06Accident · Serious injuriesClosedCessna 305A · Sandpoint, IDDec 9, 1979 · N5264G · Substantial damage NTSB SEA80FA014Accident · 2 fatalClosedCessna 182 · Idaho Falls, IDDec 9, 1979 · N470PP · Destroyed NTSB SEA80FA012Accident · 2 fatalClosedAeronca 65-CA · Mountain Home, IDDec 8, 1979 · N31929 · Substantial damage NTSB SEA80FA011Accident · 2 fatalClosedBeech V35A · Sublett, IDDec 7, 1979 · N7950R · Destroyed NTSB SEA80FA010Accident · 1 fatalClosedCessna 210 · Malad City, IDDec 7, 1979 · N9524T · Destroyed NTSB SEA80DYA03Accident · No injuriesClosedHiller Acft UH-12E · Stanley, IDNov 26, 1979 · N571H · Substantial damage NTSB SEA80FYM05Accident · Minor injuriesClosedCessna R172E · Grass Valley, IDNov 14, 1979 · N14465 · Destroyed NTSB SEA80DYP04Accident · No injuriesClosedCessna 182 · Dixie, IDNov 11, 1979 · N8971G · Substantial damage NTSB SEA80DYA02Accident · No injuriesClosedAmer Avco AA1-C · Rexburg, IDOct 17, 1979 · N9526U · Substantial damage NTSB SEA80FA003Accident · 1 fatalClosedCessna 182L · Macks Inn, IDOct 15, 1979 · N42641 · Destroyed NTSB SEA80FA002Accident · 2 fatalClosedAerospatial SA315B · Swan Valley, IDOct 8, 1979 · N219RM · Destroyed NTSB SEA80FYP01Accident · No injuriesClosedCessna 182C · Lewiston, IDOct 2, 1979 · N8489T · No damage NTSB SEA79FA061Accident · 2 fatalClosedBellanca 7KCAB · Athol, IDSep 30, 1979 · N8884 · Destroyed NTSB SEA79FYP44Accident · Serious injuriesClosedBellanca 7GCAA · Clearwater, IDSep 29, 1979 · N5186T · Destroyed NTSB SEA79DYA32Accident · No injuriesClosedCessna 180K · Mountain Home, IDSep 23, 1979 · N63595 · Substantial damage NTSB SEA79DYA31Accident · No injuriesClosedCessna 182 · Bancroft, IDSep 19, 1979 · N1909M · Substantial damage NTSB SEA79DYA28Accident · No injuriesClosedCessna 150 · Prairie, IDSep 3, 1979 · N704BL · Substantial damage NTSB SEA79DYA30Accident · Serious injuriesClosedCallair A-9 · Grandview, IDSep 2, 1979 · N7223V · Destroyed NTSB SEA79DYA29Accident · No injuriesClosedCessna 152 · Burley, IDSep 1, 1979 · N757FG · Substantial damage NTSB SEA79DYA26Accident · No injuriesClosedCessna R172K · Rexburg, IDAug 30, 1979 · N58BD · Substantial damage NTSB SEA79DYA24Accident · No injuriesClosedCessna T210 · Forney, IDAug 18, 1979 · N73HK · Substantial damage NTSB SEA79FYP41Accident · No injuriesClosedBeech 95-B55 · Sandpoint, IDAug 15, 1979 · N6220V · Substantial damage NTSB SEA79DYA27Accident · No injuriesClosedAir Tractor AT-301 · Newdale, IDAug 10, 1979 · N8791S · Substantial damage NTSB SEA79FA049Accident · 6 fatalClosedCessna T210M · Pistol Creek, IDAug 4, 1979 · N6286B · Destroyed NTSB SEA79FYA22Accident · 1 fatalClosedCallair A-9 · Mt.Home, IDAug 1, 1979 · N7205V · Destroyed NTSB SEA79FYA21Accident · Minor injuriesClosedCallair A-9 · Hammett, IDJul 24, 1979 · N8286H · Destroyed NTSB SEA79DYP36Accident · No injuriesClosedCessna 185 · Slate Creek, IDJul 16, 1979 · N9899X · Substantial damage NTSB SEA79FA046Accident · 1 fatalClosedPiper PA-38 · Bellevue, IDJul 14, 1979 · N9320T · Destroyed NTSB SEA79FA044Accident · Serious injuriesClosedCessna 182G · Challis, IDJul 10, 1979 · N3158Y · Destroyed NTSB SEA79DYP32Accident · Serious injuriesClosedGrumman G-164A · Lewiston, IDJul 3, 1979 · N25SK · Substantial damage NTSB SEA79FYA18Accident · 1 fatalClosedCessna 188 · Aberdeen, IDJun 29, 1979 · N8225G · Destroyed NTSB SEA79FYA16Accident · Serious injuriesClosedCessna T210L · Hailey, IDJun 11, 1979 · N5102Q · Substantial damage NTSB SEA79DYA14Accident · Minor injuriesClosedCessna 150 · Salmon, IDJun 10, 1979 · N2269J · Destroyed NTSB SEA79DYA15Accident · No injuriesClosedCessna 190 · Mccall, IDJun 9, 1979 · N9851A · Substantial damage NTSB SEA79FYP24Accident · 1 fatalClosedBoeing B75N1 · Kamiah, IDMay 25, 1979 · N65573 · Destroyed NTSB SEA79DYA13Accident · Minor injuriesClosedCessna 180 · Driggs, IDMay 25, 1979 · N224H · Substantial damage NTSB SEA79FA036Accident · Serious injuriesClosedCessna 172K · St Maries, IDMay 23, 1979 · N7503G · Destroyed NTSB SEA79FA035Accident · 4 fatalClosedHughes 369HS · St Maries, IDMay 21, 1979 · N922MB · Destroyed NTSB SEA79DYA12Accident · No injuriesClosedHughes 269B · Gooding, IDMay 12, 1979 · N9497F · Destroyed NTSB SEA79DYA11Accident · Minor injuriesClosedAir Tractor AT-301 · Rigby, IDMay 7, 1979 · N4331S · Destroyed NTSB SEA79FA037Accident · 2 fatalClosedCessna 172N · Challis, IDMay 5, 1979 · C-GYVP · Substantial damage NTSB SEA79FYP16Accident · Serious injuriesClosedPiper PA-25 · Orofino, IDMay 3, 1979 · N6534Z · Destroyed NTSB SEA79DYP13Accident · No injuriesClosedBellanca 8GCBC · Troy, IDApr 20, 1979 · N2685Z · Substantial damage NTSB SEA79FA030Accident · 1 fatalClosedCessna 175A · Paris, IDApr 4, 1979 · N8040T · Destroyed NTSB SEA79FTI11Accident · No injuriesClosedHiller Acft UH-12E · St Joe Nat Fst, IDMar 31, 1979 · N87893 · Substantial damage NTSB SEA79DYP07Accident · No injuriesClosedStinson 108-1 · Pritchard, IDMar 30, 1979 · N8229K · Substantial damage NTSB SEA79DYA10Accident · No injuriesClosedCessna 206 · Picabo, IDMar 28, 1979 · N2535X · Substantial damage NTSB SEA79FA027Accident · No injuriesClosedCessna T210C · Malta, IDMar 26, 1979 · N30914 · Substantial damage