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 SEA73DYA12Accident · No injuriesClosedPiper PA-25 · Amer Falls, IDSep 9, 1972 · N4736Y · Substantial damage NTSB SEA73FYA11Accident · 1 fatalClosedPiper PA-25 · St. Anthony, IDSep 8, 1972 · N8567L · Destroyed NTSB SEA73DYA09Accident · Minor injuriesClosedCessna 205 · Blackfoot, IDSep 4, 1972 · N1843Z · Substantial damage NTSB SEA73DYG17Accident · No injuriesClosedMooney M20-C · Priest Lake, IDAug 28, 1972 · N9345V · Substantial damage NTSB SEA73DYA08Accident · No injuriesClosedAeronca 11AC · Rupert, IDAug 18, 1972 · N86363 · Substantial damage NTSB SEA73DYA07Accident · No injuriesClosedCallair A-9 · Hamer, IDAug 18, 1972 · N9668Z · Substantial damage NTSB SEA73FYA06Accident · Serious injuriesClosedPiper PA-25 · Menan, IDAug 13, 1972 · N6054Z · Destroyed NTSB SEA73DYA05Accident · Serious injuriesClosedBell 47G · Murtaugh, IDAug 6, 1972 · N1071Z · Substantial damage NTSB SEA73DYA03Accident · Serious injuriesClosedCessna 172 · Ketchum, IDJul 29, 1972 · N7006G · Destroyed NTSB SEA73DYA02Accident · No injuriesClosedPiper PA-25 · Terreton, IDJul 24, 1972 · N7844Z · Substantial damage NTSB SEA73FYG01Accident · No injuriesClosedPiper PA-28R · St.Maries, IDJul 9, 1972 · N3887T · Substantial damage NTSB SEA73DYA01Accident · No injuriesClosedBoeing B75N1 · Idaho Falls, IDJul 9, 1972 · N5132N · Substantial damage NTSB SEA72DYA42Accident · No injuriesClosedCessna 150 · Dubois, IDJun 30, 1972 · N50907 · Substantial damage NTSB SEA72DYA41Accident · No injuriesClosedPiper PA-12 · Middleton, IDJun 28, 1972 · N4401M · Substantial damage NTSB SEA72AS054Accident · No injuriesClosedPiper PA-28 · Blackfoot, IDJun 17, 1972 · N8775N · Substantial damage NTSB SEA72DYA39Accident · No injuriesClosedCessna 172 · Fort Hall, IDJun 8, 1972 · N6135E · Destroyed NTSB SEA72DYA38Accident · No injuriesClosedCessna 170A · Cambridge, IDJun 7, 1972 · N9513A · Destroyed NTSB SEA72DYA36Accident · No injuriesClosedCessna 305A · Twin Falls, IDJun 4, 1972 · N5239G · Substantial damage NTSB SEA72FYG39Accident · No injuriesClosedPiper PA-25 · Troy, IDMay 23, 1972 · N7436Z · Substantial damage NTSB SEA72DYA35Accident · No injuriesClosedHiller Acft UH-12E · Dubois, IDMay 17, 1972 · N90465 · Substantial damage NTSB SEA72FYA33Accident · Serious injuriesClosedPiper PA-25 · Oakley, IDMay 15, 1972 · N8707L · Destroyed NTSB SEA72DYA32Accident · No injuriesClosedBoeing E75 · Driggs, IDMay 6, 1972 · N5307N · Substantial damage NTSB SEA72DYG34Accident · Minor injuriesClosedCessna 188 · Cameron, IDApr 24, 1972 · N3557Q · Substantial damage NTSB SEA72DYA30Accident · Minor injuriesClosedBeech C-18S · Blackfoot, IDApr 20, 1972 · N4289A · Substantial damage NTSB SEA72DYG33Accident · No injuriesClosedKaman K-600 · Worley, IDApr 19, 1972 · N5181Q · Substantial damage NTSB SEA72DYA29Accident · No injuriesClosedHughes 269C · Soda Springs, IDApr 9, 1972 · N9620F · Substantial damage NTSB SEA72AS043Accident · No injuriesClosedPiper PA-25 · St.Anthony, IDMar 31, 1972 · N8567L · Substantial damage NTSB SEA72DYA28Accident · No injuriesClosedPiper PA-25 · Preston, IDMar 27, 1972 · N6820Z · Substantial damage NTSB SEA72D!A27Accident · No injuriesClosedPiper PA-18 · Irwin, IDMar 23, 1972 · N4716A · Substantial damage NTSB SEA72FYA26Accident · No injuriesClosedPiper PA-28 · Caldwell, IDMar 9, 1972 · N9340J · Substantial damage NTSB SEA72FYA24Accident · Serious injuriesClosedBeech V35 · Ketchum, IDFeb 26, 1972 · N843BW · Substantial damage NTSB SEA72AS033Accident · 5 fatalClosedBeech 65-B80 · Fairfield, IDFeb 20, 1972 · N1027C · Destroyed NTSB SEA72AS031Accident · 1 fatalClosedChampion 7GCBC · Holbrook, IDFeb 13, 1972 · N7520F · Destroyed NTSB SEA72AS034Accident · 2 fatalClosedCessna 182H · Lowman, IDFeb 11, 1972 · CF-SZT · Destroyed NTSB SEA72DYA23Accident · No injuriesClosedTaylorcraft DCO-65 · Boise, IDFeb 5, 1972 · N49122 · Substantial damage NTSB SEA72DYG25Accident · No injuriesClosedCessna 140 · Lewiston, IDJan 15, 1972 · N89336 · Destroyed NTSB SEA72AS024Accident · Serious injuriesClosedBeech 65-B80 · Mccall, IDDec 16, 1971 · N1028C · Substantial damage NTSB SEA72AS023Accident · 3 fatalClosedPiper PA-23 · American Falls, IDDec 10, 1971 · N5006Y · Destroyed NTSB SEA72FYA21Accident · Minor injuriesClosedPiper J4A · Boise, IDDec 4, 1971 · N23199 · Destroyed NTSB SEA72DYA20Accident · No injuriesClosedCessna 175 · Rexburg, IDNov 8, 1971 · N7328M · Substantial damage NTSB SEA72FYA18Accident · Minor injuriesClosedCessna 185 · American Falls, IDNov 2, 1971 · N5895T · Destroyed NTSB SEA72FYA17Accident · No injuriesClosedAmer Avco AA-1A · Emmett, IDNov 1, 1971 · N9205L · Substantial damage NTSB SEA72DYA19Accident · No injuriesClosedCessna 182 · Challis, IDOct 31, 1971 · N3477R · Substantial damage NTSB SEA72FYA16Accident · No injuriesClosedCessna 150 · Garden City, IDOct 26, 1971 · N50775 · Substantial damage NTSB SEA72DYG17Accident · Minor injuriesClosedLake LA-4 · Coeur D'Alene, IDOct 24, 1971 · N6679L · Substantial damage NTSB SEA72DYA15Accident · No injuriesClosedChampion 7GCAA · Idaho Falls, IDOct 19, 1971 · N7559F · Substantial damage NTSB SEA72DYG16Accident · No injuriesClosedPiper PA-22 · Bovill, IDOct 11, 1971 · N3744P · Substantial damage NTSB SEA72DYA14Accident · No injuriesClosedCessna 172K · Mtn Home, IDOct 9, 1971 · N84704 · Substantial damage NTSB SEA72FYA13Accident · Minor injuriesClosedCessna 172 · Yellowpine, IDSep 13, 1971 · N5183A · Destroyed NTSB SEA72AS011Accident · 1 fatalClosedErco 415C · Boise, IDSep 11, 1971 · N413L · Destroyed