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 CHI65F0114Accident · No injuriesClosedMeyers 200A · Kokomo, INMar 30, 1965 · N495C · Substantial damage NTSB CHI65D0120Accident · No injuriesClosedPiper PA-28 · Fort Wayne, INMar 19, 1965 · N140SU · Substantial damage NTSB CHI65D0121Accident · No injuriesClosedBeechcraft A-55 · Rochester, INMar 11, 1965 · N9706Y · Substantial damage NTSB CHI65F0112Accident · No injuriesClosedNo American AT-6 · Michigan City, INMar 8, 1965 · N7007C · Substantial damage NTSB CHI65A0080Accident · 1 fatalClosedPiper PA-22 · Madison, INMar 8, 1965 · N3317Z · Destroyed NTSB CHI65A0078Accident · Minor injuriesClosedDouglas DC-6B · Ft Wayne, INMar 4, 1965 · N6548 · Substantial damage NTSB CHI65D0084Accident · No injuriesClosedCessna 310I · Sheridan, INMar 1, 1965 · N8087M · Substantial damage NTSB CHI65F0072Accident · No injuriesClosedCessna 180 · Warsaw, INFeb 26, 1965 · N9255T · Substantial damage NTSB CHI65F0070Accident · No injuriesClosedPiper PA-23 · La Porte, INFeb 21, 1965 · N5511Y · Substantial damage NTSB CHI65F0095Accident · Serious injuriesClosedBoeing A75N1 · Plainville, INFeb 15, 1965 · N9955H · Substantial damage NTSB CHI65F0090Accident · No injuriesClosedBeechcraft N-35 · New Albany, INFeb 14, 1965 · N1321Z · Substantial damage NTSB CHI65F0071Accident · No injuriesClosedBeechcraft 95 · Valparaiso, INFeb 14, 1965 · N8249D · Substantial damage NTSB CHI65A0074Accident · No injuriesClosedBrantly B2 · Franklin, INFeb 14, 1965 · N5933X · Substantial damage NTSB CHI65F0054Accident · No injuriesClosedCessna 210 · Hobart, INFeb 10, 1965 · N9649X · Substantial damage NTSB CHI65F0034Accident · No injuriesClosedMooney MARK20 · Woodburn, INFeb 6, 1965 · N5284B · Substantial damage NTSB CHI65F0046Accident · No injuriesClosedCessna 140 · Woodburn, INJan 30, 1965 · N1992V · Substantial damage NTSB CHI65F0002Accident · Minor injuriesClosedMooney M20D · Indianapolis, INJan 19, 1965 · N1967Y · Substantial damage NTSB CHI65D0023Accident · No injuriesClosedTaylorcraft DC065 · Flat Rock, INJan 17, 1965 · N47625 · Substantial damage NTSB CHI65F0012Accident · No injuriesClosedBeechcraft C-45G · Indianapolis, INJan 8, 1965 · N503CW · Substantial damage NTSB CHI65F0020Accident · No injuriesClosedChampion 7FC · Mishawaka, INJan 4, 1965 · N9816Y · Substantial damage NTSB UNK65X1114Accident · No injuriesClosedMaule M4 · Zionsville, INDec 24, 1964 · N4704T · Substantial damage NTSB UNK65X1062Accident · No injuriesClosedPiper PA28 · Lisbon, INDec 19, 1964 · N5788W · Substantial damage NTSB UNK65X1058Accident · Serious injuriesClosedPiper PA24 · Indianapolis, INDec 19, 1964 · N8451P · No damage NTSB UNK65X1014Accident · No injuriesClosedBeechraft F35 · Frankfort, INDec 14, 1964 · N4251B · Substantial damage NTSB UNK65X0936Accident · No injuriesClosedPiper PA22 · Windfall, INDec 6, 1964 · N5687Z · Substantial damage NTSB UNK65X0935Accident · No injuriesClosedPiper PA24 · Bedford, INDec 6, 1964 · N6863P · Substantial damage NTSB UNK65X0933Accident · No injuriesClosedPiper PA28 · Hobart, INDec 6, 1964 · N6347W · Substantial damage NTSB UNK65X0847Accident · No injuriesClosedSmith DSA1 · Linton, INNov 26, 1964 · N103R · Substantial damage NTSB UNK65X0765Accident · No injuriesClosedPiper PA24 · Michigan City, INNov 20, 1964 · N6033P · Substantial damage NTSB UNK65X0704Accident · No injuriesClosedLuscombe 8A · Elkhart, INNov 14, 1964 · N45801 · Substantial damage NTSB UNK65X0629Accident · No injuriesClosedCessna 310 · South Bend, INNov 9, 1964 · N222R · Substantial damage NTSB UNK65X0531Accident · No injuriesClosedMooney 20C · Indianapolis, INNov 2, 1964 · N6846U · Substantial damage NTSB UNK65X0521Accident · No injuriesClosedPiper PA28 · Kendallville, INNov 1, 1964 · N5788W · 2 aircraft · No damage NTSB UNK65X0466Accident · Serious injuriesClosedCessna 150 · Schneider, INOct 28, 1964 · N6235T · Destroyed NTSB UNK65X0425Accident · Minor injuriesClosedNavion A · Bloomington, INOct 25, 1964 · N91650 · Substantial damage NTSB UNK65X0373Accident · No injuriesClosedPiper PA16 · Indianapolis, INOct 22, 1964 · N5323H · Substantial damage NTSB UNK65X0349Accident · No injuriesClosedBeechcraft E35 · Ft Wayne, INOct 20, 1964 · N3231C · Substantial damage NTSB UNK65X0235Accident · Minor injuriesClosedTaylorcraft BC123 · Markle, INOct 11, 1964 · N96529 · Substantial damage NTSB UNK65X0203Accident · No injuriesClosedBellanca 1413 · Hartford City, INOct 9, 1964 · N86703 · Substantial damage NTSB UNK65X0137Accident · No injuriesClosedPiper PA28 · Hobart, INOct 4, 1964 · N7731W · Substantial damage NTSB UNK65X0127Accident · No injuriesClosedPiper PA28 · Franklin, INOct 3, 1964 · N7249W · Substantial damage NTSB UNK64X4149Accident · Serious injuriesClosedCessna 175 · Culver, INSep 25, 1964 · N7196M · Destroyed NTSB UNK64X4080Accident · Serious injuriesClosedCommonwealt H185 · Fortville, INSep 20, 1964 · N34132 · Substantial damage NTSB UNK64X4075Accident · No injuriesClosedMooney M20B · Logansport, INSep 20, 1964 · N74707 · Substantial damage NTSB UNK64X4029Incident · No injuriesClosedDouglas DC-3 · Indianapolis, INSep 18, 1964 · N21914 · No damage NTSB UNK64X3968Accident · No injuriesClosedCessna 182E · Greenfield, INSep 13, 1964 · N2860Y · Substantial damage NTSB UNK64X3893Accident · No injuriesClosedErcoupe 415C · Anderson, INSep 10, 1964 · N2700H · Substantial damage NTSB UNK64X3867Accident · No injuriesClosedBeechcraft C18 · Brownsburg, INSep 7, 1964 · N44569 · 2 aircraft · Minor damage NTSB UNK64X3862Accident · No injuriesClosedCessna 120 · South Bend, INSep 7, 1964 · N1791N · Substantial damage NTSB UNK64X3855Accident · No injuriesClosedCessna 182 · Griffith, INSep 7, 1964 · N3548U · Substantial damage