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 CHI80FEX28Accident · No injuriesClosedGrumman AA-5A · Indianapolis, INJul 25, 1980 · N26774 · Substantial damage NTSB CHI80FET22Accident · No injuriesClosedPiper PA-28 · Peru, INJul 23, 1980 · N44245 · Substantial damage NTSB CHI80FEX25Accident · No injuriesClosedCessna 150F · Jeffersonville, INJul 20, 1980 · N7988F · Substantial damage NTSB CHI80FET21Accident · 1 fatalClosedFaulkner MS-1 · Ft Wayne, INJul 20, 1980 · N23AS · Destroyed NTSB CHI80FEX27Accident · No injuriesClosedSchweizer SGS126 · Lafayette, INJul 17, 1980 · N10356 · Substantial damage NTSB CHI80FEX26Accident · No injuriesClosedBeech C-23 · Martinsville, INJul 17, 1980 · N1917L · Substantial damage NTSB CHI80FET20Accident · No injuriesClosedAeronca 65C · Ft.Wayne, INJul 15, 1980 · N23547 · Substantial damage NTSB CHI80DEX24Accident · No injuriesClosedAeronca 7AC · Morristown, INJul 13, 1980 · N3687E · Substantial damage NTSB CHI80DEX23Accident · No injuriesClosedCessna 188B · Saluda, INJul 11, 1980 · N9621G · Substantial damage NTSB CHI80DEX22Accident · Minor injuriesClosedCessna 140A · E Enterprise, INJul 7, 1980 · N3547V · Substantial damage NTSB DCA80AA020Accident · 3 fatalClosedLockheed 1049H · Columbus, INJun 22, 1980 · N74CA · Destroyed NTSB CHI80FEX21Accident · Minor injuriesClosedRand KR-1 · Sheridan, INJun 12, 1980 · N9999A · Destroyed NTSB CHI80FEX20Accident · No injuriesClosedCessna 172M · Bloomington, INJun 12, 1980 · N61548 · Substantial damage NTSB CHI80FA046Accident · No injuriesClosedDouglas DC-6 · Indianapolis, INJun 10, 1980 · N111AS · Substantial damage NTSB CHI80FA045Accident · 1 fatalClosedPiper PA32RT · South Bend, INJun 6, 1980 · N36839 · Destroyed NTSB CHI80FEX19Accident · Minor injuriesClosedBeech B-19 · Frankfort, INMay 28, 1980 · N1994W · Substantial damage NTSB CHI80FEX17Accident · 1 fatalClosedGR Lakes X2T-1T · Lizton, INMay 10, 1980 · N6187L · Destroyed NTSB CHI80FEX16Accident · No injuriesClosedCessna 320E · Indianapolis, INMay 10, 1980 · N2JF · Substantial damage NTSB CHI80DA037Accident · 1 fatalClosedCessna 172 · Nappanee, INMay 10, 1980 · N3912F · Destroyed NTSB CHI80FET18Accident · 1 fatalClosedPitts S-1S · Fort Wayne, INMay 4, 1980 · N75KS · Destroyed NTSB CHI80FET17Accident · No injuriesClosedBeech G35 · Syracuse, INMay 3, 1980 · N4411D · Substantial damage NTSB CHI80FEX15Accident · Minor injuriesClosedPiper PA-28R · Franklin, INApr 26, 1980 · N3174R · Substantial damage NTSB CHI80FEX14Accident · No injuriesClosedGrumman AA-1C · Mt Comfort, INApr 26, 1980 · N9926U · Substantial damage NTSB CHI80FEX13Accident · No injuriesClosedCessna 177RG · Greenwood, INApr 22, 1980 · N35891 · Destroyed NTSB CHI80FEX12Accident · No injuriesClosedHugo Craft 01 · Indianapolis, INApr 21, 1980 · N8GH · Substantial damage NTSB CHI80FET16Accident · No injuriesClosedCessna 337G · Bremen, INApr 20, 1980 · N53499 · Substantial damage NTSB CHI80FEX11Accident · Minor injuriesClosedCessna 172 · Mooresville, INApr 19, 1980 · N7186G · Destroyed NTSB CHI80FET15Accident · No injuriesClosedPiper PA32RT · New Haven, INApr 19, 1980 · N36754 · Substantial damage NTSB CHI80FET14Accident · Minor injuriesClosedPiper PA-23 · Kendallville, INApr 18, 1980 · N3406P · Destroyed NTSB CHI80DEX10Accident · No injuriesClosedAmerican AA5A · Mccordsville, INApr 13, 1980 · N26742 · Substantial damage NTSB CHI80FEX09Accident · Serious injuriesClosedBeech J50 · Columbus, INApr 11, 1980 · N95A · Destroyed NTSB CHI80DEX08Accident · No injuriesClosedCessna 172 · Brazil, INApr 7, 1980 · N739UQ · Substantial damage NTSB CHI80FEX07Accident · Serious injuriesClosedCessna A188B · Madison, INApr 2, 1980 · N9808G · Destroyed NTSB CHI80DEX06Accident · No injuriesClosedPiper PA-31 · W Lafayette, INMar 28, 1980 · N719P · Substantial damage NTSB CHI80DET13Accident · No injuriesClosedCessna 152 · Francesville, INMar 22, 1980 · N67995 · Substantial damage NTSB CHI80FA029Accident · No injuriesClosedCessna 421B · Terre Haute, INMar 20, 1980 · N8216Q · Substantial damage NTSB CHI80FET12Accident · No injuriesClosedPiper PA-31 · Michigan City, INMar 13, 1980 · N746CE · Substantial damage NTSB CHI80FA028Accident · 3 fatalClosedCessna 310H · Indianapolis, INMar 13, 1980 · N1065Q · Destroyed NTSB CHI80FEX05Accident · No injuriesClosedCessna 172 · Greencastle, INMar 11, 1980 · N3256L · Substantial damage NTSB CHI80FET11Accident · No injuriesClosedCessna 210A · Gary, INMar 4, 1980 · N9420X · Substantial damage NTSB CHI80FA027Accident · 1 fatalClosedCessna 172XP · Indianapolis, INFeb 26, 1980 · N758HQ · Destroyed NTSB CHI80FA026Accident · 4 fatalClosedPiper PA-32 · Ft Wayne, INFeb 22, 1980 · N200BF · Destroyed NTSB CHI80FET09Accident · No injuriesClosedCessna 310Q · Kendallville, INFeb 15, 1980 · N55QS · Substantial damage NTSB CHI80FEX04Accident · 1 fatalClosedCessna 182F · Greenwood, INFeb 12, 1980 · N3591Y · No damage NTSB CHI80FET06Accident · No injuriesClosedBeech 76 · South Bend, INJan 6, 1980 · N23842 · Substantial damage NTSB CHI80FEX03Accident · Minor injuriesClosedBeech B35 · Fairmount, INDec 30, 1979 · N8811A · Substantial damage NTSB CHI80FET05Accident · Serious injuriesClosedErco 415-CD · Lake Village, INDec 16, 1979 · N3857H · Substantial damage NTSB CHI80FA013Accident · 1 fatalClosedCessna 177 · Gary, INDec 1, 1979 · N10412 · Destroyed NTSB CHI80FA012Accident · 3 fatalClosedCessna 210L · Fort Wayne, INNov 25, 1979 · N2034S · Destroyed NTSB CHI80FET04Accident · No injuriesClosedPiper PA-32 · Laporte, INNov 22, 1979 · N44503 · Substantial damage