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 CHI68F0157Accident · No injuriesClosedCessna 172C · Greenwood, INAug 13, 1967 · N1642Y · Substantial damage NTSB CHI68F0231Accident · No injuriesClosedPiper PA-28 · Muncie, INAug 12, 1967 · N9770W · Substantial damage NTSB CHI68D0232Accident · Minor injuriesClosedCessna 210 · Greencastle, INAug 12, 1967 · N9490T · Substantial damage NTSB CHI68F0141Accident · Minor injuriesClosedErco 415-C · Greencastle.Ind, INAug 6, 1967 · N99406 · Destroyed NTSB CHI68F0280Accident · No injuriesClosedPiper PA-28 · Angola, INAug 4, 1967 · N8769W · Substantial damage NTSB CHI68D0294Accident · No injuriesClosedLuscombe 8E · Servia, INJul 30, 1967 · N2450K · Substantial damage NTSB CHI68D0184Accident · No injuriesClosedPiper PA-28 · Greenwood, INJul 30, 1967 · N6485R · Substantial damage NTSB CHI68F0210Accident · No injuriesClosedBeech 35 · Granger, INJul 26, 1967 · N764D · Substantial damage NTSB CHI68F0150Accident · No injuriesClosedCessna 172E · Hobart, INJul 20, 1967 · N7727U · Substantial damage NTSB CHI68D0186Accident · No injuriesClosedCessna 120 · Lebanon, INJul 18, 1967 · N2357N · Substantial damage NTSB CHI68D0183Accident · No injuriesClosedCessna 182 · Noblesville, INJul 5, 1967 · N8416S · Substantial damage NTSB CHI68F0217Accident · No injuriesClosedMooney M20E · South Bend, INJul 3, 1967 · N3463X · Substantial damage NTSB CHI68F0218Accident · Minor injuriesClosedBeech D18S · Goshen, INJul 1, 1967 · N35X · Destroyed NTSB CHI68D0160Accident · No injuriesClosedStinson 108 · Hobart, INJun 30, 1967 · N9788K · Substantial damage NTSB CHI68F0179Accident · Serious injuriesClosedPiper PA-15 · Terre Haute, INJun 29, 1967 · N4303H · Substantial damage NTSB CHI68D0064Accident · No injuriesClosedBellanca 14-19 · Elberfeld, INJun 27, 1967 · N8853R · Substantial damage NTSB CHI68D0080Accident · No injuriesClosedPiper PA-22 · Indianapolis, INJun 26, 1967 · N3322A · Substantial damage NTSB CHI68F0050Accident · No injuriesClosedCessna 310 · Warsaw, INJun 23, 1967 · N2609C · Substantial damage NTSB CHI68D0020Accident · No injuriesClosedSnow 600S-2 · Rensselaer, INJun 23, 1967 · N1791S · Substantial damage NTSB CHI68F0142Accident · Minor injuriesClosedErco 415-C · Hartford City, INJun 22, 1967 · N87153 · Substantial damage NTSB CHI68F0098Accident · No injuriesClosedCessna 210F · Hobert, INJun 22, 1967 · N210J · Substantial damage NTSB CHI67A0136Accident · 3 fatalClosedPiper PA-24 · Madison, INJun 21, 1967 · N7895P · Destroyed NTSB CHI68F0099Accident · Serious injuriesClosedPiper PA-25 · La Porte, INJun 19, 1967 · N7543Z · Destroyed NTSB CHI68F0023Accident · No injuriesClosedCessna 182 · Knox, INJun 14, 1967 · N2504R · Substantial damage NTSB CHI68F0021Accident · No injuriesClosedBeech V35 · Rensselaer, INJun 14, 1967 · N9577Q · Substantial damage NTSB CHI68D0104Accident · No injuriesClosedPiper PA-28 · Greencastle, INJun 12, 1967 · N6807W · Substantial damage NTSB CHI68D0088Accident · No injuriesClosedPiper PA-28 · Richmond, INJun 11, 1967 · N6706W · Substantial damage NTSB CHI67F0673Accident · No injuriesClosedCessna 172 · Franklin, INJun 6, 1967 · N3920F · Substantial damage NTSB CHI68D0034Accident · No injuriesClosedBeech A23 · Auburn, INJun 4, 1967 · N1433L · Substantial damage NTSB CHI68F0062Accident · No injuriesClosedGoodyear GZ-19A · Dunreith, INJun 2, 1967 · N4A · Substantial damage NTSB CHI68D0084Accident · No injuriesClosedAeronca 11AC · Windfall, INMay 30, 1967 · N9454E · Substantial damage NTSB CHI68F0089Accident · No injuriesClosedBeech E18S · Evansville, INMay 28, 1967 · N965FT · Substantial damage NTSB CHI68D0067Accident · No injuriesClosedPiper PA-12 · Evansville, INMay 28, 1967 · N2952M · Substantial damage NTSB CHI68D0035Accident · No injuriesClosedPiper PA-28 · French Lick, INMay 27, 1967 · N6354R · Substantial damage NTSB CHI68D0014Accident · No injuriesClosedStinson 108-1 · Scottsburg, INMay 26, 1967 · N8361K · Substantial damage NTSB CHI68D0065Accident · No injuriesClosedPiper PA-28 · Lafayette, INMay 25, 1967 · N483P · Substantial damage NTSB CHI67D0013Accident · No injuriesClosedPiper PA-22 · Indianapolis, INMay 25, 1967 · N3732A · Substantial damage NTSB CHI67F0656Accident · Serious injuriesClosedPiper PA-28 · Ft.Wayne, INMay 24, 1967 · N9080J · Substantial damage NTSB CHI67F0063Accident · Minor injuriesClosedAeronca 7AC · English, INMay 21, 1967 · N1225E · Substantial damage NTSB CHI67F0680Accident · Minor injuriesClosedCessna 182 · Indianapolis, INMay 20, 1967 · N5735B · Substantial damage NTSB CHI67F0632Accident · No injuriesClosedBeech N35 · Lapel, INMay 17, 1967 · N1241Z · Substantial damage NTSB CHI67A0126Accident · 6 fatalClosedCessna 320 · Aurora, INMay 16, 1967 · N3324Q · Destroyed NTSB CHI67A0124Accident · 4 fatalClosedPiper PA-24 · Covington, INMay 13, 1967 · N6536P · Destroyed NTSB CHI67A0123Accident · No injuriesClosedLockheed 18 · Indianapolis, INMay 11, 1967 · N20M · Substantial damage NTSB CHI67D0649Accident · No injuriesClosedPiper PA-22 · Hartford City, INMay 3, 1967 · N2355A · Substantial damage NTSB CHI67D0644Accident · No injuriesClosedPiper PA-23 · Bloomington, INMay 3, 1967 · N4644P · Substantial damage NTSB CHI67F0628Accident · No injuriesClosedCessna 182 · Mishawaka, INMay 1, 1967 · N3368U · Substantial damage NTSB CHI67D0645Accident · No injuriesClosedCessna 172 · Otterbein, INMay 1, 1967 · N6335E · Substantial damage NTSB CHI67D0633Accident · No injuriesClosedPiper PA-24 · Washington, INApr 29, 1967 · N6674P · Substantial damage NTSB CHI67F0624Accident · No injuriesClosedCessna 150F · Fort Wayne, INApr 28, 1967 · N8394G · Substantial damage