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 SEA79FYA18Accident · 1 fatalClosedCessna 188 · Aberdeen, IDJun 29, 1979 · N8225G · Destroyed NTSB SEA79FYA16Accident · Serious injuriesClosedCessna T210L · Hailey, IDJun 11, 1979 · N5102Q · Substantial damage NTSB SEA79DYA14Accident · Minor injuriesClosedCessna 150 · Salmon, IDJun 10, 1979 · N2269J · Destroyed NTSB SEA79DYA15Accident · No injuriesClosedCessna 190 · Mccall, IDJun 9, 1979 · N9851A · Substantial damage NTSB SEA79FYP24Accident · 1 fatalClosedBoeing B75N1 · Kamiah, IDMay 25, 1979 · N65573 · Destroyed NTSB SEA79DYA13Accident · Minor injuriesClosedCessna 180 · Driggs, IDMay 25, 1979 · N224H · Substantial damage NTSB SEA79FA036Accident · Serious injuriesClosedCessna 172K · St Maries, IDMay 23, 1979 · N7503G · Destroyed NTSB SEA79FA035Accident · 4 fatalClosedHughes 369HS · St Maries, IDMay 21, 1979 · N922MB · Destroyed NTSB SEA79DYA12Accident · No injuriesClosedHughes 269B · Gooding, IDMay 12, 1979 · N9497F · Destroyed NTSB SEA79DYA11Accident · Minor injuriesClosedAir Tractor AT-301 · Rigby, IDMay 7, 1979 · N4331S · Destroyed NTSB SEA79FA037Accident · 2 fatalClosedCessna 172N · Challis, IDMay 5, 1979 · C-GYVP · Substantial damage NTSB SEA79FYP16Accident · Serious injuriesClosedPiper PA-25 · Orofino, IDMay 3, 1979 · N6534Z · Destroyed NTSB SEA79DYP13Accident · No injuriesClosedBellanca 8GCBC · Troy, IDApr 20, 1979 · N2685Z · Substantial damage NTSB SEA79FA030Accident · 1 fatalClosedCessna 175A · Paris, IDApr 4, 1979 · N8040T · Destroyed NTSB SEA79FTI11Accident · No injuriesClosedHiller Acft UH-12E · St Joe Nat Fst, IDMar 31, 1979 · N87893 · Substantial damage NTSB SEA79DYP07Accident · No injuriesClosedStinson 108-1 · Pritchard, IDMar 30, 1979 · N8229K · Substantial damage NTSB SEA79DYA10Accident · No injuriesClosedCessna 206 · Picabo, IDMar 28, 1979 · N2535X · Substantial damage NTSB SEA79FA027Accident · No injuriesClosedCessna T210C · Malta, IDMar 26, 1979 · N30914 · Substantial damage NTSB SEA79FA026Accident · 3 fatalClosedPiper PA-22 · Spencer, IDMar 16, 1979 · N4740A · Destroyed NTSB SEA79DYA09Accident · No injuriesClosedMaule M5210C · Hailey, IDMar 12, 1979 · N348X · Substantial damage NTSB SEA79DYP10Accident · No injuriesClosedCessna 185 · Cottonwood, IDFeb 5, 1979 · N80337 · Substantial damage NTSB SEA79DYP09Accident · No injuriesClosedCessna 182K · Kamiah, IDFeb 1, 1979 · N66449 · Substantial damage NTSB SEA79DYA08Accident · No injuriesClosedAmer Avco AA1-C · Rexburg, IDJan 22, 1979 · N9526U · Substantial damage NTSB SEA79FYA07Accident · 1 fatalClosedPitts S-2A · Montpelier, IDJan 17, 1979 · N79DG · Destroyed NTSB SEA79DYA06Accident · No injuriesClosedPiper PA-24 · Driggs, IDDec 18, 1978 · N5285P · Substantial damage NTSB SEA79DYP05Accident · No injuriesClosedMaule M4220C · Coeur D'Alene, IDDec 17, 1978 · N40314 · Substantial damage NTSB SEA79DYA05Accident · No injuriesClosedStinson 108-3 · Smiths Prairie, IDDec 5, 1978 · N783C · Substantial damage NTSB SEA79DYP02Accident · No injuriesClosedPiper PA-22 · Nez Perce, IDNov 1, 1978 · N3380A · Substantial damage NTSB SEA79DYP01Accident · Minor injuriesClosedCessna 172 · Elk City, IDOct 29, 1978 · N1557V · Substantial damage NTSB SEA79FA007Accident · 1 fatalClosedSchweizer SGS232 · Hailey, IDOct 28, 1978 · N5753S · Destroyed NTSB SEA79FA004Accident · No injuriesClosedPiper PA-32 · Mc Call, IDOct 20, 1978 · N55571 · Substantial damage NTSB SEA79DYA03Accident · No injuriesClosedCessna 150 · Idaho Falls, IDOct 20, 1978 · N6758S · Substantial damage NTSB SEA79DYA02Accident · Minor injuriesClosedCessna 172B · St.Anthony, IDOct 10, 1978 · N6946X · Substantial damage NTSB SEA79DYA01Accident · No injuriesClosedBellanca 7GCBC · Hailey, IDOct 10, 1978 · N36233 · Destroyed NTSB SEA78FYP54Accident · Minor injuriesClosedCessna 150 · Coeur D'Alene, IDSep 29, 1978 · N6745F · Substantial damage NTSB SEA78FYA26Accident · No injuriesClosedGrumman G-164B · Homedale, IDSep 20, 1978 · N48542 · Destroyed NTSB SEA78DYA25Accident · No injuriesClosedStinson 108-3 · Boise, IDSep 13, 1978 · N6659M · Substantial damage NTSB SEA78FA064Accident · 1 fatalClosedCessna 185F · Riggins, IDSep 11, 1978 · N80172 · Destroyed NTSB SEA78FA060Accident · 2 fatalClosedPiper J3C · Mccall, IDSep 3, 1978 · N88185 · Destroyed NTSB SEA78DYA24Accident · Minor injuriesClosedGrumman G-164A · Oakley, IDSep 1, 1978 · N7365 · Substantial damage NTSB SEA78FYA22Accident · Minor injuriesClosedCessna 177 · Homedale, IDAug 12, 1978 · N13503 · Substantial damage NTSB SEA78FYP47Accident · Serious injuriesClosedBellanca 7GCBC · Nez Perce, IDAug 11, 1978 · N2684Z · Destroyed NTSB SEA78FYA21Accident · 1 fatalClosedAir Tractor AT-300 · Idaho Falls, IDAug 11, 1978 · N4331S · Substantial damage NTSB SEA78FA054Accident · 1 fatalClosedCessna T206 · Challis, IDAug 10, 1978 · N756LV · Destroyed NTSB SEA78DYA23Accident · No injuriesClosedEnstrom 280C · Buhl, IDAug 6, 1978 · N51651 · Destroyed NTSB SEA78DYP45Accident · No injuriesClosedCessna 172 · St.Maries, IDJul 24, 1978 · N13403 · Substantial damage NTSB SEA78FYA19Accident · Serious injuriesClosedBeech S35 · Yellow Pine, IDJul 23, 1978 · N9391 · Destroyed NTSB SEA78FYA17Accident · No injuriesClosedGrumman G-164B · Burley, IDJul 19, 1978 · N6704Q · Destroyed NTSB SEA78DYA16Accident · No injuriesClosedEnstrom 280C · Boise, IDJul 19, 1978 · N123MT · Substantial damage NTSB SEA78DYP40Accident · No injuriesClosedCessna 188 · Tilma, IDJul 17, 1978 · N80770 · Substantial damage