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 CHI68A0105Accident · No injuriesClosedPiper PA-28 · Michigan City, INJun 11, 1968 · N9561J · Substantial damage NTSB CHI68F0769Accident · No injuriesClosedBeech B35 · Hobart, INJun 3, 1968 · N8779A · Substantial damage NTSB CHI69F0017Accident · Serious injuriesClosedErcoupe 415-C · Lafayette, INJun 2, 1968 · N3253H · Substantial damage NTSB CHI68F0777Accident · No injuriesClosedPiper PA-30 · Elkhart, INMay 27, 1968 · N525PG · Substantial damage NTSB CHI68F0766Accident · No injuriesClosedBeech 23 · Elkhart, INMay 25, 1968 · N2325L · Substantial damage NTSB CHI68A0100Accident · 2 fatalClosedPiper PA-28 · Richmond, INMay 12, 1968 · N5181L · Destroyed NTSB CHI68F0757Accident · No injuriesClosedPiper PA-24 · Michigan City, INMay 5, 1968 · N5959P · Substantial damage NTSB CHI68F0747Accident · No injuriesClosedCessna 172 · Gary, INMay 2, 1968 · N7028A · Substantial damage NTSB CHI68F0734Accident · No injuriesClosedBeech V35 · Mitchell, INMay 1, 1968 · N7871L · Substantial damage NTSB CHI68D0708Accident · Minor injuriesClosedCessna 172 · Salem, INMay 1, 1968 · N8333X · Destroyed NTSB CHI69D0031Accident · No injuriesClosedPiper PA-31 · Ft.Wayne, INApr 29, 1968 · N721ZC · Substantial damage NTSB CHI68F0760Accident · Minor injuriesClosedCallair A-2 · New Haven, INApr 28, 1968 · N33351 · Substantial damage NTSB CHI68F0761Accident · No injuriesClosedPiper PA-28 · Warsaw, INApr 21, 1968 · N3644K · Substantial damage NTSB CHI68D0750Accident · No injuriesClosedCessna 182 · Columbia City, INApr 21, 1968 · N3847D · Substantial damage NTSB CHI68A0091Accident · 1 fatalClosedBeech 35 · Gary, INApr 19, 1968 · N3057V · Destroyed NTSB CHI68F0719Accident · No injuriesClosedBeech C50 · Gary, INApr 16, 1968 · N4901B · Substantial damage NTSB CHI68A0088Accident · No injuriesClosedLockheed PV-1 · Valparaiso, INApr 15, 1968 · N340 · Substantial damage NTSB CHI68F0717Accident · No injuriesClosedPiper J5A · Valparaiso, INApr 12, 1968 · N41180 · Substantial damage NTSB CHI68D0741Accident · No injuriesClosedCessna 182 · Winchester, INApr 12, 1968 · N2086X · Substantial damage NTSB CHI68D0687Accident · No injuriesClosedCessna 150 · Bloomington, INApr 10, 1968 · N6267S · Substantial damage NTSB CHI68D0682Accident · No injuriesClosedPiper PA-22 · Monon, INApr 6, 1968 · N7028B · Substantial damage NTSB CHI68F0718Accident · No injuriesClosedPiper PA-28 · Logansport, INMar 25, 1968 · N4188J · Substantial damage NTSB CHI68F0644Accident · No injuriesClosedCessna 172G · Fort Wayne, INMar 25, 1968 · N4323L · Substantial damage NTSB CHI68F0655Accident · No injuriesClosedCessna 150F · Plymouth, INMar 24, 1968 · N6561F · Substantial damage NTSB CHI68F0679Accident · No injuriesClosedPiper PA-22 · Decatur, INMar 23, 1968 · N8942D · Substantial damage NTSB CHI68A0084Accident · Minor injuriesClosedConvair 440 · Evansville, INMar 20, 1968 · N4820C · Substantial damage NTSB CHI68D0650Accident · No injuriesClosedBeech K35 · Indianapolis, INMar 11, 1968 · N816R · Substantial damage NTSB CHI68D0627Accident · No injuriesClosedPiper PA-22 · W.Lafayette, INMar 11, 1968 · N5662Z · Substantial damage NTSB CHI68F0641Accident · No injuriesClosedLuscombe 8A · Gary, INMar 10, 1968 · N71435 · Substantial damage NTSB CHI68F0615Accident · Minor injuriesClosedPiper PA-28 · Orleans, INMar 7, 1968 · N3237W · Destroyed NTSB CHI68F0636Accident · No injuriesClosedCessna 140 · Goshen, INMar 1, 1968 · N76043 · Substantial damage NTSB CHI68D0619Accident · No injuriesClosedPiper PA-22 · Muncie, INMar 1, 1968 · N7109B · Substantial damage NTSB CHI68A0076Accident · 1 fatalClosedPiper PA-22 · Nineveh, INFeb 25, 1968 · N7116B · Destroyed NTSB CHI68D0616Accident · No injuriesClosedPiper PA-28 · Lafayette, INFeb 24, 1968 · N8537W · Substantial damage NTSB CHI68A0074Accident · 2 fatalClosedPiper PA-28 · Ranklin, INFeb 18, 1968 · N9516W · 2 aircraft · Destroyed NTSB CHI68F0590Accident · No injuriesClosedErco 415-D · Speedway, INFeb 15, 1968 · N9980 · Substantial damage NTSB CHI68D0626Accident · No injuriesClosedPiper PA-28 · Sunman, INFeb 14, 1968 · N8777W · Substantial damage NTSB CHI68A0071Accident · No injuriesClosedBeech D18 · Washington, INFeb 14, 1968 · N3721 · Substantial damage NTSB CHI68F0614Accident · Serious injuriesClosedCessna 140 · Terre Haute, INFeb 8, 1968 · N76407 · Substantial damage NTSB CHI68F0592Accident · No injuriesClosedChampion 7ECA · Gary, INFeb 6, 1968 · N5140T · Substantial damage NTSB CHI68F0593Accident · No injuriesClosedCessna 337B · Auburn, INFeb 5, 1968 · N5441S · Substantial damage NTSB CHI68D0591Accident · No injuriesClosedPiper PA-28 · Franklin, INFeb 4, 1968 · N3883K · Substantial damage NTSB CHI68A0067Accident · 2 fatalClosedAeronca 7DC · Lanesville, INFeb 3, 1968 · N1133E · Destroyed NTSB CHI68F0589Accident · No injuriesClosedAero Comdr 500 · Columbus, INJan 30, 1968 · N22000 · Substantial damage NTSB CHI68D0569Accident · No injuriesClosedPiper PA-22 · French Lick, INJan 26, 1968 · N5140Z · Substantial damage NTSB CHI68A0064Accident · 2 fatalClosedCessna 172 · Liberty, INJan 21, 1968 · N4142F · Destroyed NTSB CHI68D0565Accident · No injuriesClosedPiper PA-32 · Warsaw, INJan 19, 1968 · N3536W · Substantial damage NTSB CHI68D0534Accident · No injuriesClosedPiper PA-28 · Noblesville, INJan 19, 1968 · N5810W · Substantial damage NTSB CHI68D0552Accident · No injuriesClosedPiper J3C-65 · Greenwood, INJan 18, 1968 · N92012 · Substantial damage NTSB CHI68F0554Accident · No injuriesClosedCessna 150 · Elkhart, INJan 16, 1968 · N6718F · Substantial damage