Skip to content

NTSB investigations, IN

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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" = 'IN' 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\" = 'IN' 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" = 'IN' 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 CHI76AC064Accident · 2 fatalClosedPiper PA-28 · W.Terre Haute, INMay 28, 1976 · N6331R · Destroyed NTSB CHI76AC063Accident · 1 fatalClosedCessna 310H · Richland City, INMay 27, 1976 · N1075Q · Destroyed NTSB CHI76FET35Accident · No injuriesClosedPiper PA-28 · Fort Wayne, INMay 22, 1976 · N9236W · Substantial damage NTSB CHI76FEA35Accident · Minor injuriesClosedBell 47G-2 · Monticello, INMay 22, 1976 · N9238Z · Substantial damage NTSB CHI76DEA37Accident · No injuriesClosedCessna 182 · Jeffersonville, INMay 22, 1976 · N3138S · Substantial damage NTSB CHI76FEA34Accident · 1 fatalClosedPiper PA-25 · Columbus, INMay 20, 1976 · N8599L · Destroyed NTSB CHI76FET33Accident · No injuriesClosedHughes 269C · Hebron, INMay 15, 1976 · N9653F · Substantial damage NTSB CHI76DEA33Accident · No injuriesClosedPiper PA-28 · Freedom, INMay 9, 1976 · N9290J · Substantial damage NTSB CHI76DEA31Accident · No injuriesClosedPiper PA-28 · Salem, INMay 2, 1976 · N9305K · Substantial damage NTSB CHI76FEA32Accident · No injuriesClosedCessna 140 · Cambridge City, INApr 27, 1976 · N4020N · Substantial damage NTSB CHI76FEA30Accident · No injuriesClosedCessna 150L · Bloomington, INApr 27, 1976 · N19318 · Substantial damage NTSB CHI76DET31Accident · No injuriesClosedPiper PA-28 · Demotte, INApr 22, 1976 · N4349T · Substantial damage NTSB CHI76FETO/Accident · No injuriesClosedPiper PA-36 · Wolflake, INMar 15, 1976 · N44088 · Substantial damage NTSB CHI76FEA29Accident · No injuriesClosedCessna 210J · Anderson, INMar 12, 1976 · N3396S · Substantial damage NTSB CHI76FEA28Accident · Minor injuriesClosedAeronca 7FC · Lebanon, INMar 11, 1976 · N8951R · Substantial damage NTSB CHI76AC053Accident · 3 fatalClosedFairchild 24W-40 · Albany, INMar 9, 1976 · N25388 · Destroyed NTSB CHI76DET29Accident · No injuriesClosedGrumman G-164 · Ft Wayne, INFeb 26, 1976 · N655U · Substantial damage NTSB CHI76FET28Accident · No injuriesClosedAeronca 65-CA · Michigan City, INFeb 17, 1976 · N31850 · Substantial damage NTSB CHI76AC049Accident · 3 fatalClosedPiper PA-22 · Lebanon, INFeb 16, 1976 · N3501Z · Destroyed NTSB CHI76FEA26Accident · No injuriesClosedCessna 175A · Glendale, INFeb 13, 1976 · N6966E · Substantial damage NTSB CHI76DET27Accident · No injuriesClosedCessna 172I · Kentland, INFeb 12, 1976 · N46182 · Substantial damage NTSB CHI76DEA27Accident · No injuriesClosedCessna 172 · Kokomo, INFeb 9, 1976 · N4104F · Destroyed NTSB CHI76FEA25Accident · 1 fatalClosedSaltzman BD-5B · Evansville, INFeb 8, 1976 · N617PS · Destroyed NTSB CHI76FET26Accident · No injuriesClosedCessna 150L · Goshen, INFeb 7, 1976 · N19209 · Substantial damage NTSB CHI76FEA24Accident · Serious injuriesClosedCessna 150F · Sheridan, INFeb 7, 1976 · N81385 · Substantial damage NTSB CHI76FEA23Accident · No injuriesClosedPiper PA-22 · Nashville, INJan 31, 1976 · N7821D · Destroyed NTSB CHI76AC046Accident · Minor injuriesClosedGrumman G-1159 · Marion, INJan 27, 1976 · N30RP · Substantial damage NTSB CHI76FEA22Accident · Minor injuriesClosedSwearingen SA26AT · Indianapolis, INJan 8, 1976 · N1969K · Substantial damage NTSB CHI76FET25Accident · No injuriesClosedCessna 150M · Fort Wayne, INDec 24, 1975 · N45540 · Substantial damage NTSB CHI76FET24Accident · Serious injuriesClosedCessna 210B · Fort Wayne, INDec 24, 1975 · N9590X · Substantial damage NTSB CHI76DEA21Accident · No injuriesClosedPiper PA-28 · Zionsville, INDec 22, 1975 · N1334T · Substantial damage NTSB CHI76AC040Accident · 2 fatalClosedPiper PA-30 · Monrovia, INDec 20, 1975 · N7785Y · Destroyed NTSB CHI76FEA19Accident · Serious injuriesClosedCessna 170B · Lebanon, INDec 17, 1975 · N8198H · Substantial damage NTSB CHI76FEA20Accident · Serious injuriesClosedPiper PA-23 · Tennyson, INDec 16, 1975 · N4115P · Destroyed NTSB CHI76FEA16Accident · No injuriesClosedPiper PA-22 · Indianapolis, INNov 28, 1975 · N4440A · Substantial damage NTSB CHI76AC036Accident · Minor injuriesClosedBeech E18S · Fort Wayne, INNov 24, 1975 · N14VH · Substantial damage NTSB CHI76FET21Accident · No injuriesClosedCessna 140 · Peru, INNov 23, 1975 · N2300N · Substantial damage NTSB CHI76FEA17Accident · No injuriesClosedCessna 172 · Carthage, INNov 23, 1975 · N8441U · Substantial damage NTSB CHI76DET22Accident · No injuriesClosedLake LA-4 · Angola, INNov 23, 1975 · N2036L · Substantial damage NTSB CHI76FET23Accident · No injuriesClosedBeech A36 · Valparaiso, INNov 21, 1975 · N36BP · Substantial damage NTSB CHI76FEA18Accident · No injuriesClosedCessna T337G · Bloomington, INNov 21, 1975 · N3CU · Substantial damage NTSB CHI76DEA15Accident · No injuriesClosedCessna 140 · Reynolds, INNov 15, 1975 · N4000N · Substantial damage NTSB CHI76AC035Accident · 2 fatalClosedCessna 210 · Lynnville, INNov 6, 1975 · N7422E · Destroyed NTSB CHI76FET20Accident · No injuriesClosedAero Comdr 500B · New Haven, INNov 2, 1975 · N6210X · Substantial damage NTSB MIA76FET19Accident · No injuriesClosedCessna 150 · Lake Village, INOct 30, 1975 · N45DB · Substantial damage NTSB CHI76FEA14Accident · No injuriesClosedMooney M20A · Tennyson, INOct 18, 1975 · N1086B · Substantial damage NTSB CHI76FEA13Accident · Serious injuriesClosedPiper PA-28 · Attica, INOct 17, 1975 · N7739W · Substantial damage NTSB CHI76DEA12Accident · No injuriesClosedPiper PA-28 · Versailles, INOct 11, 1975 · N5539U · Substantial damage NTSB CHI76DEA11Accident · Minor injuriesClosedStarduster S-A300 · Sheridan, INOct 11, 1975 · N9738 · Substantial damage NTSB CHI76FET18Accident · No injuriesClosedCessna 150L · Schneider, INOct 10, 1975 · N6818G · Substantial damage