Skip to content

NTSB investigations, IN

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" = '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 CHI81FA064Accident · 2 fatalClosedBrantley B2B · Chesterton, INJun 10, 1981 · N2276U · Destroyed NTSB CHI81FEX15Accident · Serious injuriesClosedSmith Mini DSA-1 · Kokomo, INJun 7, 1981 · N1307 · Destroyed NTSB CHI81FET07Accident · Minor injuriesClosedPDQ 2-D · Ligonier, INJun 7, 1981 · N2282V · Substantial damage NTSB CHI81FA061Accident · 1 fatalClosedBeech T-34B · New Castle, INMay 31, 1981 · N74195 · Destroyed NTSB CHI81FA057Accident · 1 fatalClosedAero Comdr 560 · Walkerton, INMay 24, 1981 · N272GD · Destroyed NTSB CHI81FEX14Accident · No injuriesClosedPitts S-1C · Indianapolis, INMay 2, 1981 · N10FH · Substantial damage NTSB CHI81FA046Accident · 2 fatalClosedBellanca 7KCAB · Lafayette, INApr 12, 1981 · N36334 · Destroyed NTSB CHI81FET06Accident · No injuriesClosedLake LA-4 · Laporte, INApr 9, 1981 · N2892P · Substantial damage NTSB CHI81FEX13Accident · No injuriesClosedCessna 172 · Marion, INApr 5, 1981 · N4104F · Substantial damage NTSB CHI81FEX12Accident · No injuriesClosedPiper PA-28 · Portland, INMar 23, 1981 · N4143J · Substantial damage NTSB CHI81DEX07Accident · No injuriesClosedCessna 172G · Clarksville, INMar 15, 1981 · N4415L · Substantial damage NTSB CHI81FEX11Accident · No injuriesClosedErco 415-E · Carlisle, INFeb 21, 1981 · N94773 · Substantial damage NTSB CHI81FEX10Accident · Serious injuriesClosedCessna 182 · Indianapolis, INFeb 20, 1981 · N5362N · Destroyed NTSB CHI81FA028Accident · 1 fatalClosedPiper PA-28R · Fort Wayne, INFeb 18, 1981 · N7496J · Destroyed NTSB CHI81FA027Accident · 1 fatalClosedPiper PA-32 · Loganspopt, INFeb 18, 1981 · N4341F · Destroyed NTSB CHI81IA025CaseClosedSwearingen SA226 · Indianapolis, INFeb 13, 1981 · N325BA NTSB CHI81FET04Accident · No injuriesClosedMitsubishi MU-2B · Wabash, INJan 21, 1981 · N770MA · Substantial damage NTSB CHI81FET03Accident · No injuriesClosedPiper PA-28 · Michigan City, INJan 18, 1981 · N9943W · Substantial damage NTSB CHI81DEX09Accident · No injuriesClosedCessna 152 · Columbus, INJan 2, 1981 · N4691L · Substantial damage NTSB CHI81FA016Accident · 2 fatalClosedPiper PA-28R · Elkhart, INDec 31, 1980 · N8708E · Destroyed NTSB CHI81FEX06Accident · Serious injuriesClosedCessna 150H · Kokomo, INDec 7, 1980 · N6475S · Destroyed NTSB CHI81FA011Accident · 4 fatalClosedBeech E90 · Michigan City, INDec 7, 1980 · N2181L · Destroyed NTSB CHI81FA009Accident · 3 fatalClosedCessna 210H · Hagerstown, INDec 5, 1980 · N5951F · Destroyed NTSB CHI81FA007Accident · Serious injuriesClosedBeech V35A · Pimento, INNov 18, 1980 · N2532A · Destroyed NTSB CHI81FEX05Accident · No injuriesClosedCessna 152 · Noblesville, INNov 6, 1980 · N69178 · Substantial damage NTSB CHI81FET02Accident · No injuriesClosedCessna 150 · Griffin, INNov 1, 1980 · N1744Q · Substantial damage NTSB CHI81DEX04Accident · No injuriesClosedBell 206B · Kokomo, INOct 25, 1980 · N98HH · Substantial damage NTSB CHI81FEX03Accident · Minor injuriesClosedBeech F33A · Indianapolis, INOct 24, 1980 · N3133W · Substantial damage NTSB CHI81DEX02Accident · Minor injuriesClosedPitts S-1C · Centerton, INOct 23, 1980 · N10RY · Substantial damage NTSB CHI81FET01Accident · No injuriesClosedCessna 172 · Gary, INOct 19, 1980 · N6445D · Substantial damage NTSB CHI81FEX01Accident · No injuriesClosedCessna 170 · Pendleton, INOct 1, 1980 · N4240V · Substantial damage NTSB CHI80FEX37Accident · 1 fatalClosedPietenpol GN-1 · Marion, INSep 28, 1980 · N4933 · Destroyed NTSB CHI80DET03Accident · No injuriesClosedBede BD-5B · Goshen, INSep 23, 1980 · N78MJ · Substantial damage NTSB CHI80DET30Accident · No injuriesClosedCessna R182 · Roanoke, INSep 22, 1980 · N3132C · Substantial damage NTSB CHI80FEX35Accident · No injuriesClosedBell 47G-4 · Carmel, INSep 17, 1980 · N12PE · Substantial damage NTSB CHI81FET29Accident · No injuriesClosedBellanca 7ECA · Gary, INSep 13, 1980 · N90915 · Substantial damage NTSB CHI80FEX34Accident · Minor injuriesClosedGrumman AA-5A · Jeffersonville, INSep 12, 1980 · N9895U · Substantial damage NTSB CHI80FEX36Accident · No injuriesClosedCessna 172M · Brownsburg, INSep 9, 1980 · N20095 · Substantial damage NTSB CHI80DEX33Accident · No injuriesClosedBeech E18S · Columbus, INAug 30, 1980 · N666X · Substantial damage NTSB CHI80FET27Accident · 1 fatalClosedDi Stasi Bowers · Ligonier, INAug 25, 1980 · N3392 · Substantial damage NTSB CHI80FEX31Accident · No injuriesClosedHiller Acft UH-12E · Milan, INAug 19, 1980 · N492HS · Substantial damage NTSB CHI80FET26Accident · No injuriesClosedPiper PA-32R · Syracuse, INAug 18, 1980 · N1321H · Substantial damage NTSB CHI80DEX30Accident · No injuriesClosedGrumman AA-1B · Mooresville, INAug 17, 1980 · N89631 · Substantial damage NTSB CHI80DEX32Accident · No injuriesClosedTaylorcraft F19 · Deer Creek, INAug 16, 1980 · N3728T · Substantial damage NTSB CHI80FET25Accident · No injuriesClosedBeech A-35 · Hobart, INAug 15, 1980 · N8654A · Substantial damage NTSB CHI80FET24Accident · No injuriesClosedGrumman G-164 · Howe, INAug 15, 1980 · N48348 · Substantial damage NTSB CHI80FET23Accident · Minor injuriesClosedCessna 172M · Woodburn, INAug 10, 1980 · N9050H · Substantial damage NTSB CHI80FA062Accident · 1 fatalClosedCessna 150 · Mishawaka, INAug 8, 1980 · N3118J · Destroyed NTSB CHI80FEX29Accident · No injuriesClosedHiller Acft UH-12E · Elrod, INAug 6, 1980 · N62421 · Substantial damage NTSB CHI80DA061Accident · 1 fatalClosedAeronca C-3 · Luray, INAug 1, 1980 · N16291 · Substantial damage