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 SEA74DYA16Accident · No injuriesClosedCessna 150F · Rexburg, IDNov 30, 1973 · N8292F · Substantial damage NTSB SEA74DYA15Accident · No injuriesClosedCessna 210 · Bellevue, IDNov 4, 1973 · N9507X · Substantial damage NTSB SEA74AS002Accident · 4 fatalClosedAmer Avco AA5 · Shelley, IDOct 27, 1973 · N9267L · Destroyed NTSB SEA74FYA14Accident · Minor injuriesClosedPiper PA-22 · Boise, IDOct 17, 1973 · N996A · Substantial damage NTSB SEA74FYA13Accident · No injuriesClosedBell 47G-3B · Marsing, IDOct 15, 1973 · N73230 · Destroyed NTSB SEA74DYA12Accident · Serious injuriesClosedBell 47G-3B · New Meadows, IDOct 2, 1973 · N73909 · Destroyed NTSB SEA74DYA11Accident · No injuriesClosedGrumman G-164A · Idaho Falls, IDSep 10, 1973 · N7369 · Destroyed NTSB SEA74FYG15Accident · Serious injuriesClosedCessna 182P · Dixie, IDSep 9, 1973 · N9386G · Substantial damage NTSB SEA74AS014Accident · 4 fatalClosedPiper PA-28 · Idaho Cty, IDSep 9, 1973 · N1742T · Destroyed NTSB SEA74DYA10Accident · No injuriesClosedCessna 140 · Preston, IDAug 30, 1973 · N76057 · Substantial damage NTSB SEA74DYG11Accident · No injuriesClosedBellanca 14-193 · Orofino, IDAug 26, 1973 · N74450 · Substantial damage NTSB SEA74DVA09Accident · No injuriesClosedHiller UH-12E · S.Glenns Ferry, IDAug 26, 1973 · N7755 · Substantial damage NTSB SEA74AS007Accident · 4 fatalClosedCessna 182 · Salmon, IDAug 19, 1973 · N3280U · Destroyed NTSB SEA74DYA08Accident · No injuriesClosedPiper PA-18A · Mud Lake, IDAug 13, 1973 · N3707A · Substantial damage NTSB SEA74FYG09Accident · Serious injuriesClosedPiper PA-28 · St.Maries, IDAug 12, 1973 · N2198T · Destroyed NTSB DEN74AD007Accident · 1 fatalClosedCessna 172L · Preston, IDAug 11, 1973 · N7725G · Substantial damage NTSB SEA74FYA07Accident · Serious injuriesClosedPiper PA-25 · Goshen, IDAug 2, 1973 · N8586L · Destroyed NTSB SEA74DYG07Accident · No injuriesClosedBell 47G3B · Orofino, IDAug 1, 1973 · N73249 · Substantial damage NTSB SEA74DYA05Accident · No injuriesClosedPiper PA-25 · Nampa, IDJul 30, 1973 · N6748Z · Substantial damage NTSB SEA74FYA03Accident · No injuriesClosedDouglas B-26B · Idaho Falls, IDJul 10, 1973 · N5426E · Substantial damage NTSB SEA74FYA02Accident · Minor injuriesClosedAero Comdr 600S2R · Homedale, IDJul 7, 1973 · N5553X · Substantial damage NTSB SEA74FYA01Accident · 1 fatalClosedSchleicher ASW-15 · Eagle, IDJul 7, 1973 · N88JM · Destroyed NTSB SEA73DYA36Accident · No injuriesClosedBeech A35 · Stanley, IDJun 26, 1973 · N590B · Substantial damage NTSB SEA73DYA35Accident · No injuriesClosedCessna 180C · Burley, IDJun 23, 1973 · N6406X · Substantial damage NTSB SEA73DYA34Accident · No injuriesClosedCessna 172 · Preston, IDJun 23, 1973 · N2508L · Substantial damage NTSB SEA73AS039Accident · No injuriesClosedBeech 95-B55 · Hailey, IDJun 23, 1973 · N332N · Substantial damage NTSB SEA73DYA33Accident · No injuriesClosedCessna 180 · Boise, IDJun 22, 1973 · N4700U · Substantial damage NTSB SEA73DYA32Accident · No injuriesClosedPiper PA-25 · Mountain Home, IDJun 16, 1973 · N6836Z · Destroyed NTSB SEA73DYA31Accident · No injuriesClosedGrumman G-164 · Idaho Falls, IDJun 12, 1973 · N745Y · Destroyed NTSB SEA73DYA30Accident · No injuriesClosedPiper PA-24 · American Falls, IDJun 9, 1973 · N944P · Substantial damage NTSB SEA73FYA27Accident · No injuriesClosedPiper PA-20 · Caldwell, IDMay 22, 1973 · N69F · Substantial damage NTSB SEA73DYA25Accident · No injuriesClosedMooney M20E · American Falls, IDMay 13, 1973 · N5614Q · Substantial damage NTSB SEA73DYA24Accident · Minor injuriesClosedCessna 150F · Pine, IDMay 13, 1973 · N6478F · Destroyed NTSB SEA73DYA28Accident · No injuriesClosedBeech J35 · Cascade, IDMay 11, 1973 · N3005C · Substantial damage NTSB SEA73DYA23Accident · No injuriesClosedCessna U206A · Star, IDMay 3, 1973 · N8069Z · Substantial damage NTSB SEA73DYA22Accident · No injuriesClosedBoeing E75 · Roberts, IDMay 2, 1973 · N5307N · Substantial damage NTSB SEA73DYG32Accident · No injuriesClosedPiper PA-18 · Doumecy, IDApr 18, 1973 · N7574P · Substantial damage NTSB SEA73DYA20Accident · No injuriesClosedCessna 210 · Burley, IDApr 6, 1973 · N9666T · Substantial damage NTSB SEA73AS028Accident · 1 fatalClosedPiper PA-32 · Rogerson, IDApr 1, 1973 · N1208T · Destroyed NTSB SEA73DYA19Accident · No injuriesClosedDehavilland DH114 · Hailey, IDFeb 25, 1973 · N509FW · Substantial damage NTSB SEA73DYA18Accident · Serious injuriesClosedPiper PA-18 · Weston, IDFeb 24, 1973 · N13951 · Destroyed NTSB SEA73FYA17Accident · No injuriesClosedPiper PA-28 · Jerome, IDFeb 19, 1973 · N9488W · Substantial damage NTSB SEA73DYA16Accident · Minor injuriesClosedStinson 108-3 · New Meadows, IDFeb 3, 1973 · N771C · Substantial damage NTSB SEA73AS020Accident · 1 fatalClosedCessna 170B · Headquarters, IDJan 27, 1973 · N3181F · Destroyed NTSB SEA73FYG22Accident · Minor injuriesClosedCessna 120 · Sandpoint, IDJan 23, 1973 · N2074V · Destroyed NTSB SEA73FYA15Accident · No injuriesClosedCessna 182P · Gooding, IDDec 26, 1972 · N20785 · Substantial damage NTSB SEA73AS036Accident · 5 fatalClosedPiper PA-24 · Malad City, IDDec 17, 1972 · N5774P · Destroyed NTSB SEA73AS016Accident · 1 fatalClosedCessna 206D · Kamian, IDNov 29, 1972 · N8768Z · Destroyed NTSB SEA73DYA14Accident · No injuriesClosedErco 415C · Boise, IDOct 14, 1972 · N94057 · Substantial damage NTSB SEA73FYA13Accident · Serious injuriesClosedBeech 35-A33 · Hailey, IDOct 3, 1972 · N9403Y · Substantial damage