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 SEA75DYA51Accident · No injuriesClosedCallair A-9 · Glenns Ferry, IDJun 29, 1975 · N3555G · Destroyed NTSB SEA75DYA52Accident · No injuriesClosedEnstrom F-28A1 · Boise, IDJun 23, 1975 · N9077 · Substantial damage NTSB SEA75FYG44Accident · Serious injuriesClosedErco 415-C · Priest River, IDJun 21, 1975 · N99752 · Substantial damage NTSB SEA7KFYA50Accident · Serious injuriesClosedPiper PA-22 · Blackfoot, IDJun 11, 1975 · N2602P · Substantial damage NTSB SEA75FYA49Accident · No injuriesClosedCessna 150 · Firth, IDJun 10, 1975 · N22281 · Substantial damage NTSB SEA75FYA48Accident · No injuriesClosedHelicom Comutr · Arco, IDJun 8, 1975 · N8425 · Substantial damage NTSB SEA7KDYG46Accident · No injuriesClosedCessna 337 · Mackey Bar, IDJun 7, 1975 · N55CS · Substantial damage NTSB SEA76DYA46Accident · Minor injuriesClosedPiper PA-22 · Burley, IDJun 2, 1975 · N3413Z · Substantial damage NTSB SEA7KDYA45Accident · No injuriesClosedCessna 177 · Idaho City, IDMay 31, 1975 · N34553 · Substantial damage NTSB SEA75DYA44Accident · No injuriesClosedCessna A188B · Fairfield, IDMay 22, 1975 · N9845G · Substantial damage NTSB SEA75DYA42Accident · No injuriesClosedHughes 269A1A · Burley, IDMay 18, 1975 · N8859F · Substantial damage NTSB SEA75AS041Accident · 2 fatalClosedStinson 108-2 · Gimlet, IDMay 17, 1975 · N9632K · Destroyed NTSB SEA75DYA43Accident · No injuriesClosedPiper PA-18 · Paul, IDMay 16, 1975 · N5771D · Substantial damage NTSB SEA75DYA41Accident · No injuriesClosedCessna 150 · Mountain Home, IDMay 12, 1975 · N10517 · Substantial damage NTSB SEA7KDYA40Accident · No injuriesClosedPiper PA-12 · Homedale, IDMay 11, 1975 · N4018H · Destroyed NTSB SEA75DYA39Accident · No injuriesClosedCessna 180 · Mccall, IDMay 3, 1975 · N699HR · Substantial damage NTSB SEA75DYA38Accident · No injuriesClosedPiper PA-22 · Gooding, IDMay 3, 1975 · N4626Z · Substantial damage NTSB SEA7KFYA37Accident · No injuriesClosedBeech B24R · Carey, IDApr 29, 1975 · N2549W · Substantial damage NTSB SEA75DYG29Accident · No injuriesClosedWeatherly 201B · Genesee, IDApr 19, 1975 · N1273W · Substantial damage NTSB SEA75DYA36Accident · No injuriesClosedCessna 150 · Boise, IDApr 19, 1975 · N7815E · Substantial damage NTSB SEA75AS039Accident · 2 fatalClosedPiper PA-28 · Riddle, IDApr 17, 1975 · N40952 · Destroyed NTSB SEA75DYG35Accident · No injuriesClosedCessna TU206F · Mccall, IDApr 12, 1975 · N1912U · Substantial damage NTSB SEA75DYA35Accident · No injuriesClosedPiper PA-22 · Fairfield, IDApr 10, 1975 · N9309D · Substantial damage NTSB SEA75DYG27Accident · No injuriesClosedChampion 7GCBC · Sandpoint, IDMar 30, 1975 · N8330V · Substantial damage NTSB SEA75DYA34Accident · No injuriesClosedCessna T337 · Dubois, IDMar 18, 1975 · N11RA · Substantial damage NTSB SEA75DYG24Accident · No injuriesClosedCessna 185 · Kamiah, IDMar 15, 1975 · N70060 · Substantial damage NTSB SEA75DYA33Accident · No injuriesClosedCessna 150 · Salmon, IDMar 14, 1975 · N61087 · Substantial damage NTSB SEA75DYG23Accident · No injuriesClosedStearman E75N1 · Craigmont, IDMar 8, 1975 · N1720B · Substantial damage NTSB SEA75DYA32Accident · No injuriesClosedCessna 180 · Dubois, IDFeb 20, 1975 · N5276D · Substantial damage NTSB SEA75FYA30Accident · Serious injuriesClosedBeech G35 · Burley, IDJan 24, 1975 · N4457D · Substantial damage NTSB SEA75DYA29Accident · No injuriesClosedCessna 172 · Aberdeen, IDJan 22, 1975 · N4655L · Substantial damage NTSB SEA75FYA28Accident · No injuriesClosedHiller Acft UH-12E · Hammett, IDJan 20, 1975 · N7755 · Substantial damage NTSB SEA75FYA27Accident · Minor injuriesClosedPiper PA-32 · Hailey, IDJan 19, 1975 · N5200S · Destroyed NTSB SEA75DYG17Accident · No injuriesClosedBensen B8M · Kellogg, IDJan 10, 1975 · N2946 · Substantial damage NTSB SEA75DYA25Accident · No injuriesClosedCessna 180 · Bellevue, IDDec 8, 1974 · N2849A · Substantial damage NTSB SEA75DYG14Accident · No injuriesClosedCessna 182 · Lewiston, IDNov 28, 1974 · N3589Y · Substantial damage NTSB SEA75DYA24Accident · Minor injuriesClosedPiper PA-24 · Arco, IDNov 27, 1974 · N7985P · Substantial damage NTSB SEA75AS021Accident · 2 fatalClosedCessna 182E · Boise, IDNov 1, 1974 · N3155Y · Destroyed NTSB SEA75AS020Accident · 1 fatalClosedErco 415-C · Rogerson, IDOct 31, 1974 · N3591H · Destroyed NTSB SEA75DYA23Accident · No injuriesClosedBeech 35 · Burley, IDOct 11, 1974 · N3001V · Substantial damage NTSB SEA75AS016Accident · No injuriesClosedCessna 185E · Twin Falls, IDOct 10, 1974 · N4753Q · Substantial damage NTSB SEA75DYA22Accident · No injuriesClosedPiper PA-12 · Mccall, IDSep 20, 1974 · N3729M · Substantial damage NTSB SEA75AYA21Accident · No injuriesClosedBoeing A75N · Hailey, IDSep 18, 1974 · N48768 · Destroyed NTSB SEA75DYA20Accident · No injuriesClosedMaule M-4 · Burley, IDSep 14, 1974 · N4749T · Substantial damage NTSB SEA75DYA18Accident · No injuriesClosedPiper PA-28 · Picabo, IDSep 3, 1974 · N8575W · Substantial damage NTSB SEA75DYA17Accident · No injuriesClosedPiper PA-24 · Rockland, IDSep 2, 1974 · N8664P · Substantial damage NTSB SEA75FYA16Accident · No injuriesClosedSnow 600S2R · Marsing, IDAug 31, 1974 · N8973Q · Substantial damage NTSB SEA75DYA15Accident · Minor injuriesClosedCessna 210C · Mccall, IDAug 29, 1974 · N3669Y · Substantial damage NTSB SEA75FYA14Accident · No injuriesClosedCessna 177 · Donnelly, IDAug 25, 1974 · N29531 · Substantial damage NTSB SEA75DYA13Accident · Serious injuriesClosedPiper PA-18 · Tetonia, IDAug 21, 1974 · N6509C · Substantial damage