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 CHI79IA032Incident · No injuriesClosedCessna 402 · Indianapolis, INMar 14, 1979 · N4048Q · Minor damage NTSB CHI79FET21Accident · No injuriesClosedPiper PA-28 · Laporte, INMar 9, 1979 · N55001 · Substantial damage NTSB CHI79FET19Accident · Serious injuriesClosedBellanca 17-31A · Munster, INMar 4, 1979 · N76TV · Destroyed NTSB CHI79FA029Accident · Serious injuriesClosedBeech E18S · Indianapolis, INFeb 27, 1979 · N711TL · Destroyed NTSB CHI79DET18Accident · No injuriesClosedCessna 150 · Morocco, INFeb 20, 1979 · N24318 · Substantial damage NTSB CHI79FET17Accident · No injuriesClosedCessna 421B · Fort Wayne, INFeb 15, 1979 · N41114 · Substantial damage NTSB CHI79DET16Accident · No injuriesClosedCessna 177 · Churubusco, INFeb 10, 1979 · N2605Q · Substantial damage NTSB CHI79DET14Accident · No injuriesClosedBrantly B2B · Kendallville, INFeb 5, 1979 · N2285U · Substantial damage NTSB CHI79DEX16Accident · No injuriesClosedPiper PA-28 · Lafayette, INFeb 4, 1979 · N15517 · Substantial damage NTSB CHI79FET15Accident · Minor injuriesClosedCessna 152 · Valparaiso, INFeb 3, 1979 · N757NC · Substantial damage NTSB CHI79DET12Accident · No injuriesClosedBeech 35B · Fort Wayne, INJan 29, 1979 · N8916A · Substantial damage NTSB CHI79FEX15Accident · No injuriesClosedPiper PA-23 · Crawfordsville, INJan 28, 1979 · N6901Y · Substantial damage NTSB CHI79FA023Accident · 2 fatalClosedPiper PA-28R · Memphis, INJan 19, 1979 · N1885F · Destroyed NTSB CHI79DEX14Accident · No injuriesClosedSpartan 7W · Martinsville, INJan 12, 1979 · N79DC · Substantial damage NTSB CHI79FEX13Accident · No injuriesClosedBeech B-60 · Indianapolis, INJan 2, 1979 · N23522 · Substantial damage NTSB CHI79FA022Accident · 2 fatalClosedPiper PA-28R · Grissom Afb, INDec 30, 1978 · N3712T · Destroyed NTSB CHI79FEX12Accident · No injuriesClosedCessna 152 · Bloomington, INDec 28, 1978 · N49417 · Substantial damage NTSB CHI79FET10Accident · No injuriesClosedBeech C45H · La Porte, INDec 26, 1978 · N9807Z · Substantial damage NTSB CHI79DEX10Accident · No injuriesClosedCessna 172 · Indianapolis, INDec 12, 1978 · N7349G · Minor damage NTSB CHI79FET07Accident · No injuriesClosedCessna 172M · Gary, INDec 11, 1978 · N12619 · Substantial damage NTSB CHI79FET08Accident · No injuriesClosedPiper PA-11 · Michigan City, INDec 10, 1978 · N4795H · Substantial damage NTSB CHI79FEX09Accident · No injuriesClosedBeechcraft E18S · Indianapolis, INDec 7, 1978 · N46952 · Substantial damage NTSB CHI79FEX06Accident · No injuriesClosedCessna 310Q · Marion, INDec 1, 1978 · N310AE · Substantial damage NTSB CHI79DEX11Accident · No injuriesClosedLuscombe 8A · Greenwood, INNov 30, 1978 · N71897 · Substantial damage NTSB CHI79FET11Accident · Serious injuriesClosedPiper PA-28 · Demotte, INNov 27, 1978 · N16584 · Substantial damage NTSB CHI79FET06Accident · No injuriesClosedBeechcraft E-55 · Elkhart, INNov 26, 1978 · N171D · Substantial damage NTSB CHI79FEX08Accident · No injuriesClosedCessna 180 · Franklin, INNov 18, 1978 · N3868C · Substantial damage NTSB CHI79FET05Accident · No injuriesClosedCessna 172 · South Bend, INNov 5, 1978 · N7023A · Substantial damage NTSB CHI79FET04Accident · 2 fatalClosedMonocoupe 90A · Mentone, INNov 4, 1978 · N18062 · Destroyed NTSB CHI79FEX05Accident · Minor injuriesClosedCessna 172 · Martinsville, INNov 3, 1978 · N6861A · Substantial damage NTSB CHI79DEX07Accident · No injuriesClosedCessna 320C · Portland, INNov 2, 1978 · N3166T · Substantial damage NTSB CHI79FEX04Accident · Minor injuriesClosedErco 415-D · Kirklin, INOct 28, 1978 · N93745 · Destroyed NTSB CHI79FET03Accident · No injuriesClosedBeech 99 · South Bend, INOct 25, 1978 · N447SA · Substantial damage NTSB CHI79FEX03Accident · No injuriesClosedPiper PA-31 · Indianapolis, INOct 23, 1978 · N62856 · Substantial damage NTSB CHI79FEX02Accident · 1 fatalClosedCassutt LSS · Cloverdale, INOct 22, 1978 · N7133 · Destroyed NTSB CHI79FEI02Accident · Serious injuriesClosedPiper PA-28 · South Bend, INOct 22, 1978 · N44106 · Substantial damage NTSB CHI79DET01Accident · No injuriesClosedCessna 150 · Peru, INOct 18, 1978 · N19043 · Substantial damage NTSB CHI79FA009Accident · 4 fatalClosedPiper PA-22 · Tell City, INOct 17, 1978 · N3427A · 2 aircraft · Destroyed NTSB CHI79DEX01Accident · No injuriesClosedBell 206 · Rockville, INOct 14, 1978 · N206M · Substantial damage NTSB CHI79IA005Incident · No injuriesClosedSwearingen SA226 · Lafayette, INOct 6, 1978 · N781S · Minor damage NTSB CHI78DEX42Accident · No injuriesClosedPiper PA-28 · Portland, INSep 28, 1978 · N8222W · Substantial damage NTSB CHI78FEX43Accident · Minor injuriesClosedCessna 150H · Monticello, INSep 27, 1978 · N23016 · Destroyed NTSB CHI78FEX41Accident · No injuriesClosedCessna 402 · Indianapolis, INSep 27, 1978 · N4048Q · Substantial damage NTSB CHI78FET38Accident · No injuriesClosedCessna 177 · Fort Wayne, INSep 24, 1978 · N2605Q · Substantial damage NTSB CHI78FEX40Accident · Minor injuriesClosedBell 47G2 · Waveland, INSep 23, 1978 · N8429E · Substantial damage NTSB CHI78FEX39Accident · No injuriesClosedPiper PA-38 · Indianapolis, INSep 19, 1978 · N4376E · Destroyed NTSB CHI78FA066Accident · 1 fatalClosedBrantley B-2B · Brook, INSep 11, 1978 · N2284U · Destroyed NTSB CHI78FEX38Accident · No injuriesClosedMooney M20A · Lebanon, INSep 5, 1978 · N6083X · Destroyed NTSB CHI78FEX35Accident · Serious injuriesClosedCessna 172K · Lanesville, INSep 3, 1978 · N84060 · Destroyed NTSB CHI78FET36Accident · No injuriesClosedPiper PA-28 · Lake Station, INSep 3, 1978 · N5393S · Substantial damage