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 SEA75DYA19Accident · No injuriesClosedPiper PA-25 · Idaho Falls, IDAug 17, 1974 · N7375Z · Substantial damage NTSB SEA75DYG06Accident · No injuriesClosedBoeing D75N1 · Coeur D'Alene, IDAug 12, 1974 · N19PN · Substantial damage NTSB SEA75DYA12Accident · No injuriesClosedHiller Acft UH-12 · Roberts, IDAug 12, 1974 · N3112G · Substantial damage NTSB SEA75DYA11Accident · Minor injuriesClosedCessna 182P · Rockland, IDAug 12, 1974 · N91298 · Destroyed NTSB SEA75DYA10Accident · No injuriesClosedPiper PA-23 · Hailey, IDAug 10, 1974 · N5859Y · Substantial damage NTSB SEA75DYA09Accident · No injuriesClosedBoeing A75 · Shelley, IDAug 7, 1974 · N62906 · Substantial damage NTSB SEA75AS006Accident · 2 fatalClosedBeech M24R · Boise, IDAug 1, 1974 · N2529W · 2 aircraft · Destroyed NTSB SEA75DYA07Accident · No injuriesClosedHiller Acft UH-12E · Bliss, IDJul 31, 1974 · N534S · Destroyed NTSB SEA75DYA08Accident · No injuriesClosedPiper PA-25 · Payette, IDJul 30, 1974 · N7503Z · Substantial damage NTSB SEA75DYA06Accident · No injuriesClosedCessna 180 · Heyburn, IDJul 26, 1974 · N6556A · Substantial damage NTSB SEA75FYA05Accident · Serious injuriesClosedPiper PA-28 · Arco, IDJul 25, 1974 · N8289W · Destroyed NTSB SEA75DYA04Accident · No injuriesClosedGrumman G-164A · Burley, IDJul 14, 1974 · N7365 · Substantial damage NTSB SEA75FYG01Accident · No injuriesClosedCessna 172 · Kamiah, IDJul 13, 1974 · N46447 · Substantial damage NTSB SEA75DYA02Accident · Minor injuriesClosedBeech B19 · Yellowpine, IDJul 4, 1974 · N24620 · Substantial damage NTSB SEA75DYA01Accident · No injuriesClosedCessna 180 · Burley, IDJul 3, 1974 · N9164T · Substantial damage NTSB SEA74FYA39Accident · No injuriesClosedAero Comdr A-9B · Newdale, IDJun 23, 1974 · N7686V · Substantial damage NTSB SEA74DYA41Accident · No injuriesClosedCallair A-5 · Monteview, IDJun 22, 1974 · N7589C · Substantial damage NTSB SEA74DYA38Accident · No injuriesClosedPiper PA-22 · Oakley, IDJun 20, 1974 · N6729B · Substantial damage NTSB SEA74DYA40Accident · No injuriesClosedCallair A-9 · Terreton, IDJun 17, 1974 · N3608G · Substantial damage NTSB SEA74DYA37Accident · No injuriesClosedBoeing E75 · Shoshone, IDJun 17, 1974 · N1731B · Substantial damage NTSB SEA74AS049Accident · 1 fatalClosedS.Z.D. 24-4A · Burley, IDJun 15, 1974 · N21714 · Destroyed NTSB SEA74DYA42Accident · No injuriesClosedCallair A-9B · Idaho Falls, IDJun 9, 1974 · N7680V · Substantial damage NTSB SEA74AS048Accident · 1 fatalClosedTaylorcraft DCO-65 · Viola, IDJun 9, 1974 · N50838 · Destroyed NTSB SEA74DVA36Accident · No injuriesClosedBoeing E75 · Roberts, IDJun 7, 1974 · N5307N · Substantial damage NTSB SEA74DYA35Accident · No injuriesClosedCessna 188 · Idaho Falls, IDMay 31, 1974 · N9385G · Substantial damage NTSB SEA74AS046Accident · 4 fatalClosedCessna 182R · Montpelier, IDMay 29, 1974 · N52559 · Destroyed NTSB SEA74FYA33Accident · Serious injuriesClosedPiper PA-25 · Grandview, IDMay 25, 1974 · N6602Z · Destroyed NTSB SEA74FYA32Accident · Serious injuriesClosedMooney M20A · Nampa, IDMay 25, 1974 · N6583B · Substantial damage NTSB SEA74DYA34Accident · No injuriesClosedPiper PA-25 · Dubois, IDMay 21, 1974 · N4618Y · Substantial damage NTSB SEA74DYA31Accident · No injuriesClosedPiper PA-25 · Kuna, IDMay 9, 1974 · N4484Y · Substantial damage NTSB SEA74AS043Accident · 1 fatalClosedMooney M20F · Idaho Falls, IDMay 9, 1974 · N5980Q · Substantial damage NTSB SEA74DYG36Accident · No injuriesClosedStearman A75 · Craigmont, IDMay 7, 1974 · N1720B · Substantial damage NTSB SEA74FYA30Accident · 2 fatalClosedDehavilland DHC-1B · Roberts, IDApr 29, 1974 · N713Z · Destroyed NTSB SEA74DYG32Accident · No injuriesClosedPiper PA-25 · Genesee, IDApr 27, 1974 · N7593Z · Destroyed NTSB SEA74DYG29Accident · No injuriesClosedWeatherly 201 · Nezperce, IDApr 21, 1974 · N1261W · Substantial damage NTSB LAX74DYA29Accident · Serious injuriesClosedPiper PA-28 · Twin Falls, IDApr 19, 1974 · N7063R · Minor damage NTSB SEA74DYG28Accident · No injuriesClosedCessna A188B · Nez Perce, IDApr 18, 1974 · N8080V · Substantial damage NTSB SEA74DYA28Accident · No injuriesClosedPiper PA-25 · Malad City, IDApr 15, 1974 · N7225L · Substantial damage NTSB SEA74FYA27Accident · Minor injuriesClosedBeech D50 · Burley, IDApr 9, 1974 · N4303D · Substantial damage NTSB SEA74FYA26Accident · Serious injuriesClosedPiper PA-23 · Burley, IDMar 21, 1974 · N123CK · Destroyed NTSB SEA74AS037Accident · 1 fatalClosedPiper PA-23 · Boise, IDMar 14, 1974 · N292M · Destroyed NTSB SEA74AS036Accident · 1 fatalClosedPiper PA-28 · Caldwell, IDMar 10, 1974 · N6290W · Destroyed NTSB SEA74DYA25Accident · No injuriesClosedBeech A35 · Weiser, IDMar 8, 1974 · N8708A · Substantial damage NTSB SEA74FYA23Accident · Minor injuriesClosedBell 206B · Ketchum, IDFeb 13, 1974 · N6265N · Substantial damage NTSB SEA74DYA22Accident · No injuriesClosedLuscombe 8F · Cascade, IDFeb 9, 1974 · N1391B · Substantial damage NTSB SEA74DYA24Accident · No injuriesClosedHiller Acft UH-12E · Soda Springs, IDFeb 5, 1974 · N90465 · Substantial damage NTSB SEA74DYA19Accident · No injuriesClosedCessna 182L · Bellevue, IDJan 8, 1974 · N3396R · Substantial damage NTSB SEA74DYA18Accident · No injuriesClosedPiper PA-22 · Bone, IDDec 29, 1973 · N8002D · Substantial damage NTSB SEA74DYA17Accident · No injuriesClosedBell 47G-3B · Twin Falls, IDDec 17, 1973 · N8588F · Substantial damage NTSB SEA74DYG21Accident · No injuriesClosedCessna 150 · Priest River, IDDec 2, 1973 · N7711E · Substantial damage