Skip to content

NTSB investigations, ID

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 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 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 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 SEA76DYA32Accident · Minor injuriesClosedPiper PA-25 · Georgetown, IDJun 28, 1976 · N6342Z · Destroyed NTSB SEA76FYA29Accident · Serious injuriesClosedLaister LK-10B · Howe, IDJun 27, 1976 · N24189 · Substantial damage NTSB SEA76FYA28Accident · Serious injuriesClosedTaylorcraft BC12-D · Mountain Home, IDJun 23, 1976 · N36430 · Substantial damage NTSB SEA76DYG69Accident · No injuriesClosedHiller Acft UH-12E · Nezperce, IDJun 17, 1976 · N5944V · Substantial damage NTSB SEA76DYA27Accident · No injuriesClosedPiper PA-20 · Council, IDJun 15, 1976 · N1018Z · Substantial damage NTSB SEA76DYA26Accident · No injuriesClosedHiller Acft UH-12E · Rupert, IDJun 10, 1976 · N68021 · Destroyed NTSB SEA76DYA30Accident · No injuriesClosedBeech D95A · Rexburg, IDJun 7, 1976 · N499G · Substantial damage NTSB SEA76DYA25Accident · No injuriesClosedGrumman G-164A · Hamer, IDJun 5, 1976 · N7863 · Substantial damage NTSB SEA76DYG35Accident · No injuriesClosedBoeing B75N1 · Nezperce, IDJun 4, 1976 · N65573 · Substantial damage NTSB SEA76AS051Accident · 4 fatalClosedStinson 108-1 · Burley, IDMay 23, 1976 · N8480K · Destroyed NTSB SEA76AS049Accident · 2 fatalClosedCessna 172K · Weiser, IDMay 21, 1976 · N7148G · Destroyed NTSB SEA76FYA24Accident · No injuriesClosedBell 47G3B1 · Burley, IDMay 17, 1976 · N47042 · Substantial damage NTSB SEA76FYG48Accident · Serious injuriesClosedEnstrom F-28A · White Bird, IDApr 23, 1976 · N715BP · Destroyed NTSB SEA76DYG47Accident · Minor injuriesClosedHiller Acft UH-12E · Worley, IDApr 22, 1976 · N101EH · Substantial damage NTSB SEA76DYG43Accident · No injuriesClosedGrumman G-164A · Genesee, IDApr 13, 1976 · N7372 · Substantial damage NTSB SEA76DYG42Accident · No injuriesClosedGrumman G-164A · Nezperce, IDApr 9, 1976 · N29SK · Substantial damage NTSB SEA76DYA23Accident · No injuriesClosedCessna 180 · Pocatello, IDApr 1, 1976 · N2925C · Substantial damage NTSB SEA76AS038Accident · 1 fatalClosedCessna 182H · Gimlet, IDMar 20, 1976 · N2300X · Destroyed NTSB SEA76DYG33Accident · No injuriesClosedCessna 185 · Grangeville, IDFeb 22, 1976 · N4146C · Substantial damage NTSB SEA76DYA20Accident · No injuriesClosedBeech A60 · Hailey, IDFeb 16, 1976 · N362DB · Substantial damage NTSB SEA76AS036Accident · Serious injuriesClosedBoeing 727 · Boise, IDFeb 16, 1976 · N7629U · No damage NTSB SEA76DYA18Accident · Serious injuriesClosedGrum Amer AA-5B · Mccall, IDFeb 8, 1976 · N74307 · Destroyed NTSB SEA76AYA19Accident · Serious injuriesClosedCessna 172 · Preston, IDFeb 8, 1976 · N5925R · Substantial damage NTSB SEA76FYA17Accident · No injuriesClosedAero Comdr 560E · Hailey, IDJan 29, 1976 · N560E · Substantial damage NTSB SEA76DYA22Accident · No injuriesClosedPiper PA-18 · Idaho Falls, IDJan 25, 1976 · N3707A · Substantial damage NTSB SEA76AS035Accident · 1 fatalClosedCessna T210J · St.Anthony, IDJan 25, 1976 · N2292R · Destroyed NTSB SEA76AS034Accident · 3 fatalClosedBellanca 17-30 · Orofino, IDJan 15, 1976 · N7385V · Destroyed NTSB SEA76DYA15Accident · Minor injuriesClosedCessna 150J · Lowman, IDJan 2, 1976 · N51149 · Substantial damage NTSB SEA76FYG25Accident · Minor injuriesClosedNa Rockwell 112 · Sandpoint, IDDec 19, 1975 · N1078J · Substantial damage NTSB SEA76DYG24Accident · No injuriesClosedCessna 182 · Orofino, IDNov 25, 1975 · N3069Q · Substantial damage NTSB SEA75DYG22Accident · No injuriesClosedBell 47G3B2 · Sandpoint, IDOct 24, 1975 · N4070J · Destroyed NTSB SEA76FYA14Accident · Minor injuriesClosedCessna 182G · Marsing, IDOct 8, 1975 · N2479R · Substantial damage NTSB SEA76DYA13Accident · No injuriesClosedCessna 170B · Mccall, IDSep 9, 1975 · N3476D · Substantial damage NTSB SEA76DYG10Accident · No injuriesClosedCessna 172 · Deary, IDAug 24, 1975 · N3925R · Substantial damage NTSB SEA76AS011Accident · 5 fatalClosedBeech 95-C55 · Murphy, IDAug 19, 1975 · N2066W · Destroyed NTSB SEA76AS009Accident · Minor injuriesClosedBell 206B · Indian Creek, IDAug 8, 1975 · N1428W · Substantial damage NTSB SEA76DYA12Accident · No injuriesClosedCessna 175 · Yellow Pine, IDAug 5, 1975 · N6990F · Substantial damage NTSB SEA76DYG06Accident · No injuriesClosedPiper PA-20 · Coeur D'Alene, IDAug 2, 1975 · N1018Z · Substantial damage NTSB SEA76DYA10Accident · No injuriesClosedCessna 150 · Jerome, IDAug 2, 1975 · N7820F · Destroyed NTSB SEA76DYA11Accident · No injuriesClosedRiley Super 340 · Boise, IDAug 1, 1975 · N1597G · Substantial damage NTSB SEA76FYA09Accident · Serious injuriesClosedBoeing PT-17 · Idaho Falls, IDJul 31, 1975 · N62906 · Destroyed NTSB SEA76DYA08Accident · No injuriesClosedPiper PA-20 · Mccall, IDJul 27, 1975 · N2698A · Substantial damage NTSB SEA76FYA07Accident · No injuriesClosedChampion 7GCAA · Boise, IDJul 26, 1975 · N8305V · Substantial damage NTSB SEA76FYA06Accident · 1 fatalClosedPiper PA-25 · Fruitland, IDJul 23, 1975 · N7592Z · Destroyed NTSB SEA76FYA05Accident · Minor injuriesClosedSikorsky S-61L · Garden Valley, IDJul 22, 1975 · N301Y · Substantial damage NTSB SEA76DYA03Accident · No injuriesClosedStinson 108-3 · Idaho Falls, IDJul 13, 1975 · N511C · Substantial damage NTSB SEA76DYA02Accident · Minor injuriesClosedPiper PA-18 · Ketchum, IDJul 8, 1975 · N1370A · Substantial damage NTSB SEA76AYA01Accident · Minor injuriesClosedVolksplane VP-2 · Boise, IDJul 5, 1975 · N48196 · Substantial damage NTSB SEA76DYA04Accident · No injuriesClosedGrumman G-164 · Rupert, IDJul 2, 1975 · N6397 · Substantial damage NTSB SEA75DYG47Accident · No injuriesClosedGrumman G-164A · Deary, IDJun 29, 1975 · N5286 · Substantial damage