Skip to content

NTSB investigations, 1971, 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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 SEA72AS024Accident · Serious injuriesClosedBeech 65-B80 · Mccall, IDDec 16, 1971 · N1028C · Substantial damage NTSB SEA72AS023Accident · 3 fatalClosedPiper PA-23 · American Falls, IDDec 10, 1971 · N5006Y · Destroyed NTSB SEA72FYA21Accident · Minor injuriesClosedPiper J4A · Boise, IDDec 4, 1971 · N23199 · Destroyed NTSB SEA72DYA20Accident · No injuriesClosedCessna 175 · Rexburg, IDNov 8, 1971 · N7328M · Substantial damage NTSB SEA72FYA18Accident · Minor injuriesClosedCessna 185 · American Falls, IDNov 2, 1971 · N5895T · Destroyed NTSB SEA72FYA17Accident · No injuriesClosedAmer Avco AA-1A · Emmett, IDNov 1, 1971 · N9205L · Substantial damage NTSB SEA72DYA19Accident · No injuriesClosedCessna 182 · Challis, IDOct 31, 1971 · N3477R · Substantial damage NTSB SEA72FYA16Accident · No injuriesClosedCessna 150 · Garden City, IDOct 26, 1971 · N50775 · Substantial damage NTSB SEA72DYG17Accident · Minor injuriesClosedLake LA-4 · Coeur D'Alene, IDOct 24, 1971 · N6679L · Substantial damage NTSB SEA72DYA15Accident · No injuriesClosedChampion 7GCAA · Idaho Falls, IDOct 19, 1971 · N7559F · Substantial damage NTSB SEA72DYG16Accident · No injuriesClosedPiper PA-22 · Bovill, IDOct 11, 1971 · N3744P · Substantial damage NTSB SEA72DYA14Accident · No injuriesClosedCessna 172K · Mtn Home, IDOct 9, 1971 · N84704 · Substantial damage NTSB SEA72FYA13Accident · Minor injuriesClosedCessna 172 · Yellowpine, IDSep 13, 1971 · N5183A · Destroyed NTSB SEA72AS011Accident · 1 fatalClosedErco 415C · Boise, IDSep 11, 1971 · N413L · Destroyed NTSB SEA72FYG11Accident · 1 fatalClosedCessna 188 · Craigmont, IDSep 8, 1971 · N9738V · Destroyed NTSB SEA72DYG14Accident · Minor injuriesClosedPiper PA-28 · Coeur Dalene, IDSep 7, 1971 · N5770F · Destroyed NTSB SEA72DYG10Accident · No injuriesClosedCessna 172 · Salmon, IDSep 6, 1971 · N8538X · Substantial damage NTSB SEA72FYG08Accident · Serious injuriesClosedBellanca 14-13 · Orofino, IDAug 29, 1971 · N74450 · Substantial damage NTSB SEA72DYA10Accident · No injuriesClosedAeronca 7BCM · Boise, IDAug 27, 1971 · N6057C · Substantial damage NTSB SEA72DYA12Accident · No injuriesClosedCessna 150 · Rexburg, IDAug 23, 1971 · N22281 · Substantial damage NTSB SEA72DYA11Accident · No injuriesClosedPiper PA-18 · Burley, IDAug 21, 1971 · N8562C · Substantial damage NTSB SEA72DYG07Accident · Minor injuriesClosedCessna 175 · Mullan, IDAug 15, 1971 · N9342B · Substantial damage NTSB SEA72DYA08Accident · Serious injuriesClosedAeronca 7AC · Twin Falls, IDAug 13, 1971 · N83896 · Destroyed NTSB SEA72DYA06Accident · No injuriesClosedCessna 182 · Emmett, IDJul 31, 1971 · N2782G · Destroyed NTSB SEA72DYA04Accident · No injuriesClosedPiper PA-25 · Firth, IDJul 27, 1971 · N6054Z · Substantial damage NTSB SEA72AS003Accident · 2 fatalClosedPiper PA-22 · Mountain Home, IDJul 27, 1971 · N6924B · Destroyed NTSB SEA72DYA07Accident · No injuriesClosedHiller UH12-E · Bliss, IDJul 23, 1971 · N5345V · Substantial damage NTSB SEA72FYA03Accident · Minor injuriesClosedCallair A-9 · Parma, IDJul 20, 1971 · N7214V · Substantial damage NTSB SEA72DYA02Accident · No injuriesClosedPiper PA-12 · Wendell, IDJul 18, 1971 · N3580M · Substantial damage NTSB SEA72FYA01Accident · No injuriesClosedStinson 108-3 · Boise, IDJul 17, 1971 · N6392M · Substantial damage NTSB SEA71DYG61Accident · No injuriesClosedTaylorcraft BC12-D · Priest Lake, IDJun 27, 1971 · N44445 · Substantial damage NTSB SEA71DYA41Accident · Minor injuriesClosedPiper J-3 · Paris, IDJun 26, 1971 · N38631 · Substantial damage NTSB SEA71DYA40Accident · No injuriesClosedCessna 188 · Kimberly, IDJun 22, 1971 · N9891V · Substantial damage NTSB SEA71DYA39Accident · No injuriesClosedPiper PA-11 · Newdale, IDJun 20, 1971 · N4687M · Substantial damage NTSB SEA71DYA38Accident · No injuriesClosedPiper PA-25 · Blackfoot, IDJun 20, 1971 · N7283Z · Substantial damage NTSB SEA71DYA37Accident · No injuriesClosedCallair A-9B · Albion, IDJun 19, 1971 · N7698V · Substantial damage NTSB SEA71DYA36Accident · Serious injuriesClosedPiper PA-25 · Idaho Falls, IDJun 15, 1971 · N7118Z · Destroyed NTSB SEA71FYA35Accident · Serious injuriesClosedPiper PA-28 · Boise, IDJun 13, 1971 · N6786W · Substantial damage NTSB SEA71DYA33Accident · No injuriesClosedPiper PA-23 · Blackfoot, IDMay 28, 1971 · N1172P · Substantial damage NTSB SEA71FYA32Accident · No injuriesClosedConvair 240-14 · Buhl, IDMay 14, 1971 · N1015G · Substantial damage NTSB SEA71DYA31Accident · No injuriesClosedCessna 182L · Montpelier, IDMay 7, 1971 · N42150 · Substantial damage NTSB SEA71DXM29Accident · No injuriesClosedCessna 140 · Atomic City, IDApr 12, 1971 · N90124 · Substantial damage NTSB SEA71DXM30Accident · No injuriesClosedCessna 170B · Mc Call, IDApr 3, 1971 · N8232A · Substantial damage NTSB SEA71DXM28Accident · No injuriesClosedCessna 150 · Burley, IDMar 27, 1971 · N7368X · Substantial damage NTSB SEA71DXM27Accident · Minor injuriesClosedPiper PA-23 · Carey, IDMar 12, 1971 · N1488P · Destroyed NTSB SEA71DXM26Accident · No injuriesClosedPiper PA-28 · Burley, IDFeb 28, 1971 · N7063R · Substantial damage NTSB SEA71AS037Accident · 2 fatalClosedPiper PA-18 · St.Anthony, IDFeb 20, 1971 · N7180 · Destroyed NTSB SEA71DXM25Accident · No injuriesClosedPiper PA-32 · Preston, IDFeb 12, 1971 · N3213W · Substantial damage NTSB SEA71FYM24Accident · Serious injuriesClosedCessna 421B · Gannett, IDFeb 6, 1971 · N8025Q · Substantial damage NTSB SEA71DXM22Accident · No injuriesClosedPiper PA-18 · Stone, IDJan 27, 1971 · N1249A · Substantial damage