Skip to content

NTSB investigations, ID

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 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 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