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 CHI76AC031Accident · Serious injuriesClosedGrum Amer AA1-B · Roachdale, INOct 9, 1975 · N9924L · Destroyed NTSB CHI76DET32Accident · No injuriesClosedPiper PA-18 · Valparaiso, INOct 4, 1975 · N269T · Substantial damage NTSB CHI76FET16Accident · No injuriesClosedGrum Amer AA5 · Roanoke, INOct 1, 1975 · N1334R · Substantial damage NTSB CHI76FEA08Accident · Minor injuriesClosedGrum Amer AA1B · Eden, INSep 27, 1975 · N8893L · Substantial damage NTSB CHI76DET15Accident · Minor injuriesClosedPiper PA-28 · Syracuse, INSep 23, 1975 · N4782T · Substantial damage NTSB CHI76DEA09Accident · No injuriesClosedAmer Avco AA1-A · Anderson, INSep 20, 1975 · N9288L · Substantial damage NTSB CHI76FET14Accident · Minor injuriesClosedCessna A188B · Nappanee, INSep 8, 1975 · N86547 · Substantial damage NTSB CHI76FEA10Accident · No injuriesClosedWoody Pushr WAS-2 · Holton, INSep 7, 1975 · N411BZ · Substantial damage NTSB CHI76DET12Accident · Minor injuriesClosedPiper PA-28 · Hanna, INAug 28, 1975 · N7325W · Substantial damage NTSB CHI76DET11Accident · No injuriesClosedCallair A9 · Kewanna, INAug 28, 1975 · N7734V · Substantial damage NTSB CHI76FET13Accident · No injuriesClosedPiper PA-25 · Wawaka, INAug 27, 1975 · N7748Z · Substantial damage NTSB CHI76FET09Accident · Serious injuriesClosedCessna 150L · New Elliott, INAug 21, 1975 · N66014 · Substantial damage NTSB CHI76FET07Accident · Minor injuriesClosedPiper PA-28 · Lacrosse, INAug 18, 1975 · N33002 · Substantial damage NTSB CHI76FET06Accident · No injuriesClosedCessna 172D · Valparaiso, INAug 16, 1975 · N2910U · Destroyed NTSB CHI76AC014Accident · 5 fatalClosedPiper PA-32 · Fort Wayne, INAug 15, 1975 · N3821W · Destroyed NTSB MKC76AK038Accident · Serious injuriesClosedBoeing 707 · Bloomington, INAug 13, 1975 · N6726 · No damage NTSB CHI76DEA07Accident · No injuriesClosedPiper PA-28 · Madison, INAug 12, 1975 · N15569 · Substantial damage NTSB CHI76DEA06Accident · No injuriesClosedLuscombe 8F · Vallonia, INAug 12, 1975 · N1115B · Substantial damage NTSB CHI76FET05Accident · No injuriesClosedPiper PA-16 · Lake Village, INAug 9, 1975 · N5298H · Substantial damage NTSB CHI76DET10Accident · No injuriesClosedAlon A2 · Logansport, INAug 9, 1975 · N5491E · Substantial damage NTSB CHI76FET04Accident · No injuriesClosedCreamer TWO · Wabash, INAug 8, 1975 · N16AS · Substantial damage NTSB CHI7LDEA05Accident · No injuriesClosedCessna 170B · New Castle, INAug 4, 1975 · N2857C · Substantial damage NTSB CHI76DET03Accident · No injuriesClosedPiper PA-28 · Auburn, INAug 4, 1975 · N5219T · Substantial damage NTSB CHI76AC009Accident · 1 fatalClosedPitts S-1S · New Castle, INAug 2, 1975 · N3R · Destroyed NTSB CHI76AC006Accident · 2 fatalClosedAero Comdr 500A · Valparaiso, INJul 28, 1975 · N78378 · Destroyed NTSB CHI76FEA04Accident · Minor injuriesClosedPiper PA-28 · Indianapolis, INJul 26, 1975 · N1874T · Substantial damage NTSB CHI76DEM04Accident · No injuriesClosedBell 206B · Hillsdale, INJul 24, 1975 · N59449 · Substantial damage NTSB CHI76DET08Accident · No injuriesClosedCessna 185 · New Carlisle, INJul 20, 1975 · N1092F · Substantial damage NTSB CHI76DET02Accident · No injuriesClosedPiper PA-15 · Kendallville, INJul 12, 1975 · N4544H · Substantial damage NTSB CHI76FEA02Accident · Minor injuriesClosedBellanca 7KCAB · Danville, INJul 8, 1975 · N7536F · Substantial damage NTSB CHI76FEA01Accident · 1 fatalClosedSidewinder Burrow · Noblesville, INJul 3, 1975 · N18851 · Destroyed NTSB CHI76AC001Accident · Minor injuriesClosedGates Lear 25B · Oston, INJul 3, 1975 · N428JX · Destroyed NTSB CHI76FET01Accident · Minor injuriesClosedPiper PA-28 · Roselawn, INJul 2, 1975 · N1795T · Substantial damage NTSB CHI75FET23Accident · No injuriesClosedCessna 150 · Peru, INJun 27, 1975 · N23020 · Substantial damage NTSB CHI75AC098Accident · 2 fatalClosedPiper PA-28R · Jeffersonville, INJun 27, 1975 · N3927T · Destroyed NTSB CHI75DEA25Accident · No injuriesClosedBeech 24R · Muncie, INJun 25, 1975 · N6978R · Substantial damage NTSB CHI75DEA24Accident · Serious injuriesClosedPiper PA-22 · Muncie, INJun 24, 1975 · N7636D · Substantial damage NTSB CHI75FET22Accident · No injuriesClosedLuscombe 8E · Elkhart, INJun 22, 1975 · N1202K · 2 aircraft · Substantial damage NTSB CHI75DET21Accident · No injuriesClosedBeech M35 · Goshen, INJun 13, 1975 · N9356Y · Substantial damage NTSB CHI75FEA23Accident · Serious injuriesClosedPiper PA-36 · Vincennes, INJun 7, 1975 · N56590 · Destroyed NTSB CHI75DEA22Accident · No injuriesClosedCessna 150 · Indianapolis, INJun 5, 1975 · N21923 · Substantial damage NTSB CHI75AC092Accident · 1 fatalClosedPiper PA-22 · Port Isabel, INJun 3, 1975 · N3578V · Destroyed NTSB CHI75DET20Accident · Minor injuriesClosedAdams SIDE-W · Columbia City, INMay 18, 1975 · N17A · Substantial damage NTSB CHI75FET19Accident · Minor injuriesClosedCessna 120 · Topeka, INMay 15, 1975 · N73058 · Substantial damage NTSB CHI75AC087Accident · Serious injuriesClosedGrum Amer AA-5 · Elwood, INMay 15, 1975 · N1332R · 2 aircraft · Substantial damage NTSB CHI75FEA21Accident · No injuriesClosedTownsend 47G2 · Earl Park, INMay 11, 1975 · N90836 · Destroyed NTSB CHI75DET18Accident · No injuriesClosedCessna 177 · Angola, INMay 4, 1975 · N33857 · Substantial damage NTSB CHI75FEA19Accident · Serious injuriesClosedAerostar Ranger · Paoli, INApr 26, 1975 · N6738N · Substantial damage NTSB CHI75DEA18Accident · Minor injuriesClosedCessna 150H · Jeffersonville, INApr 16, 1975 · N22374 · Substantial damage NTSB CHI75FET17Accident · No injuriesClosedCessna 182K · Syracuse, INApr 8, 1975 · N2787Q · Substantial damage