Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 SEA78FYA03Accident · No injuriesClosedCessna 180 · Aberdeen, IDDec 11, 1977 · N67178 · Substantial damage NTSB SEA78FA011Accident · 2 fatalClosedPiper PA-32 · Pocatello, IDNov 29, 1977 · N41861 · Substantial damage NTSB SEA78FA010Accident · 2 fatalClosedCessna 210E · Moscow, IDNov 27, 1977 · N2369F · Destroyed NTSB SEA78DYA02Accident · No injuriesClosedChampion 7GC · Mudlake, IDOct 7, 1977 · N9876Y · Destroyed NTSB SEA78FYA01Accident · Serious injuriesClosedPiper PA-22 · Murphy, IDOct 5, 1977 · N9700D · Destroyed NTSB SEA78FA002Accident · 2 fatalClosedBellanca 7GCBC · Lowman, IDOct 4, 1977 · N57429 · Destroyed NTSB SEA77DYA37Accident · No injuriesClosedLuscombe T8F · Hailey, IDSep 22, 1977 · N2231B · Substantial damage NTSB SEA77DYA36Accident · No injuriesClosedCessna 180J · Dubois, IDSep 20, 1977 · N46683 · Substantial damage NTSB SEA77FYA34Accident · Serious injuriesClosedPiper PA-25 · Marsing, IDAug 19, 1977 · N4734Y · Substantial damage NTSB SEA77DYP44Accident · No injuriesClosedPiper J3-65 · Athol, IDAug 18, 1977 · N50503 · Substantial damage NTSB SEA77DYA33Accident · No injuriesClosedCessna 172 · Challis, IDAug 13, 1977 · N7596G · Substantial damage NTSB SEA77FYP37Accident · No injuriesClosedBeech AT-11 · Athol, IDAug 7, 1977 · N501 · Substantial damage NTSB SEA77FA045Accident · 1 fatalClosedCessna 182Q · Elk City, IDJul 29, 1977 · N182DM · Destroyed NTSB SEA77DYA32Accident · No injuriesClosedHughes 269C · Malta, IDJul 26, 1977 · N7456F · Destroyed NTSB SEA77FA043Accident · 5 fatalClosedPiper PA-32R · Bernard Creek, IDJul 25, 1977 · N9228K · Destroyed NTSB SEA77FYA28Accident · 1 fatalClosedHughes 369HS · American Falls, IDJul 9, 1977 · N9224F · Destroyed NTSB SEA77DYA30Accident · No injuriesClosedCallair A9B · Rigby, IDJul 9, 1977 · N7704V · Substantial damage NTSB SEA77DYA27Accident · No injuriesClosedHughes 269C · Gooding, IDJul 5, 1977 · N7432F · Destroyed NTSB SEA77FYA26Accident · 2 fatalClosedPiper PA-18 · Picabo, IDJul 4, 1977 · N1880P · Destroyed NTSB SEA77DYA25Accident · No injuriesClosedCessna 182H · Idaho City, IDJun 16, 1977 · N2447X · Substantial damage NTSB SEA77DYA24Accident · No injuriesClosedHiller Acft UH-12E · Blackfoot, IDJun 6, 1977 · N143HA · Substantial damage NTSB SEA77FYA21Accident · No injuriesClosedPiper PA-28 · Nampa, IDJun 5, 1977 · N8410R · Substantial damage NTSB SEA77FYA20Accident · Serious injuriesClosedPiper PA-22 · American Falls, IDJun 4, 1977 · N8002D · Substantial damage NTSB SEA77DYA23Accident · No injuriesClosedPiper PA-12 · Marsing, IDJun 4, 1977 · N4018H · Substantial damage NTSB SEA77FA036Accident · 2 fatalClosedPiper PA-22 · Horseshoe Bend, IDMay 30, 1977 · N8993C · Destroyed NTSB SEA77DYA22Accident · No injuriesClosedSchleicher KA-6 · Geneva, IDMay 30, 1977 · N9759Z · Substantial damage NTSB SEA77DYA19Accident · No injuriesClosedCessna 150F · Cambridge, IDMay 28, 1977 · N7031F · Substantial damage NTSB SEA77FA031Accident · 2 fatalClosedCessna 182 · Orofino, IDMay 4, 1977 · N4052D · Destroyed NTSB SEA77DYA18Accident · No injuriesClosedCessna 182 · Challis, IDMay 1, 1977 · N3158Y · Substantial damage NTSB SEA77DYA17Accident · No injuriesClosedPorterfield LP65 · American Falls, IDApr 27, 1977 · N27206 · Substantial damage NTSB SEA77DYP28Accident · Serious injuriesClosedAeronca 7AC · Athol, IDApr 24, 1977 · N1363E · Substantial damage NTSB SEA77DYP22Accident · No injuriesClosedCessna 180 · Sandpoint, IDApr 20, 1977 · N180JF · Substantial damage NTSB SEA77DA028Accident · Serious injuriesClosedCessna 180H · Mccall, IDApr 14, 1977 · N4781U · Destroyed NTSB SEA77FA026Accident · 2 fatalClosedCessna 180 · Newdale, IDApr 10, 1977 · N2974A · Destroyed NTSB SEA77FYP21Accident · No injuriesClosedCessna 182D · Kingston, IDApr 3, 1977 · N8712X · Substantial damage NTSB SEA77DYA16Accident · Minor injuriesClosedAero Comdr 500B · Twin Falls, IDApr 2, 1977 · N223LH · Destroyed NTSB SEA77FYA15Accident · No injuriesClosedCessna 150L · Boise, IDMar 21, 1977 · N1215Q · Substantial damage NTSB SEA77DA022Accident · Minor injuriesClosedCessna TU206F · Warren, IDMar 21, 1977 · N1912U · Substantial damage NTSB SEA77FYA14Accident · No injuriesClosedPiper PA-28 · Emmett, IDMar 20, 1977 · N4388X · Substantial damage NTSB SEA77FA021Accident · 2 fatalClosedGrum Amer AA-5 · Clifton, IDMar 19, 1977 · N7198L · Destroyed NTSB SEA77DYA13Accident · No injuriesClosedTaylorcraft BC12D · American Falls, IDMar 15, 1977 · N44280 · Substantial damage NTSB SEA77DYA12Accident · Minor injuriesClosedCessna 421B · Soda Springs, IDFeb 23, 1977 · N3380Q · Substantial damage NTSB SEA77FYA10Accident · Serious injuriesClosedCessna 185 · Rexburg, IDFeb 20, 1977 · N412AM · Substantial damage NTSB SEA77DYA11Accident · Minor injuriesClosedCessna 172 · Boise, IDFeb 20, 1977 · N80691 · Substantial damage NTSB SEA77FA018Accident · 3 fatalClosedPiper PA-28 · Carey, IDFeb 10, 1977 · N937CC · Destroyed NTSB SEA77DYP18Accident · No injuriesClosedBellanca 7ECA · Orofino, IDFeb 5, 1977 · N4141Y · Substantial damage NTSB SEA77FYA09Accident · Serious injuriesClosedBell 214B1 · Salmon, IDJan 26, 1977 · N225RM · Substantial damage NTSB SEA77DYP16Accident · No injuriesClosedCessna 421A · Sandpoint, IDJan 12, 1977 · N421MF · Substantial damage