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 CHI67D0055Accident · No injuriesClosedBeech B95 · Kokomo, INJun 16, 1966 · N2048C · Substantial damage NTSB CHI66A0099Accident · 3 fatalClosedCurtis C-46 · Columbia City, INJun 16, 1966 · N10415 · 2 aircraft · Destroyed NTSB CHI67F0036Accident · Minor injuriesClosedPiper PA25 · New Carlisle, INJun 14, 1966 · N6276Z · Substantial damage NTSB CHI67F0050Accident · No injuriesClosedCessna 195B · South Bend, INJun 11, 1966 · N2164C · Substantial damage NTSB CHI67F0079Accident · Minor injuriesClosedBeech 95-A55 · Warsaw, INJun 8, 1966 · N1493G · Substantial damage NTSB CHI67D0041Accident · No injuriesClosedTaylorcraft BC12D · Portland, INJun 7, 1966 · N96999 · Substantial damage NTSB CHI67F0013Accident · Serious injuriesClosedBeech B35 · Indianapolis, INJun 4, 1966 · N5201C · Substantial damage NTSB CHI66F0793Accident · No injuriesClosedPiper PA-23 · Madison, INJun 3, 1966 · N241RV · Substantial damage NTSB CHI67F0049Accident · No injuriesClosedPiper PA-23 · Orleans, INJun 2, 1966 · N4401P · Substantial damage NTSB CHI67D0009Accident · No injuriesClosedPiper PA-28 · Richmond, INJun 2, 1966 · N7313W · Substantial damage NTSB CHI67F0020Accident · No injuriesClosedMooney M-18C · Speedway, INMay 30, 1966 · N4061 · Substantial damage NTSB CHI67D0075Accident · No injuriesClosedPiper PA-22 · Windfall, INMay 28, 1966 · N2373A · Substantial damage NTSB CHI67F0031Accident · No injuriesClosedPiper PA-12 · Windfall, INMay 27, 1966 · N2457M · Substantial damage NTSB CHI67D0019Accident · No injuriesClosedPiper PA-22 · Lake Village, INMay 23, 1966 · N9605D · Substantial damage NTSB CHI66F0775Accident · No injuriesClosedPiper PA28 · Outh Bend, INMay 23, 1966 · N6208W · Substantial damage NTSB CHI66F0774Accident · No injuriesClosedAeronca 11AC · Auburn, INMay 23, 1966 · N85772 · Substantial damage NTSB CHI67F0015Accident · Minor injuriesClosedBeech 35 · Mentone, INMay 22, 1966 · N3776N · Substantial damage NTSB CHI66F0770Accident · No injuriesClosedPiper PA-22 · Logansport, INMay 22, 1966 · N5629Z · Substantial damage NTSB CHI67D0028Accident · No injuriesClosedPiper PA-24 · Indianapolis, INMay 21, 1966 · N5044P · Substantial damage NTSB CHI66F0763Accident · No injuriesClosedPiper PA-23 · Michigan City, INMay 18, 1966 · N2189P · Substantial damage NTSB CHI66A0089Accident · 1 fatalClosedPiper PA-22 · Morocco, INMay 12, 1966 · N3208Z · Destroyed NTSB CHI66F0780Accident · No injuriesClosedPiper PA-18 · Frankilin, INMay 10, 1966 · N5466H · Substantial damage NTSB CHI66D0746Accident · No injuriesClosedCessna 172 · Angola, INApr 29, 1966 · N5999A · Substantial damage NTSB CHI66D0715Accident · No injuriesClosedCessna 195 · Peru, INApr 24, 1966 · N9302A · Substantial damage NTSB CHI66D0702Accident · No injuriesClosedPiper PA-17 · Lafayette, INApr 22, 1966 · N4495H · Substantial damage NTSB CHI66F0734Accident · No injuriesClosedCessna 172 · Kendallville, INApr 20, 1966 · N1362Y · Substantial damage NTSB CHI66F0769Accident · Serious injuriesClosedPiper PA-28 · Richmond, INApr 18, 1966 · N6507W · Substantial damage NTSB CHI66F0697Accident · No injuriesClosedPiper PA-28 · Logansport, INApr 17, 1966 · N6371W · Substantial damage NTSB CHI66F0704Accident · No injuriesClosedBeech M35 · Ft Wayne, INApr 14, 1966 · N9580R · Substantial damage NTSB CHI66D0701Accident · No injuriesClosedPiper PA-28 · Cambridge Cty, INApr 8, 1966 · N5783W · Substantial damage NTSB CHI66A0083Accident · 3 fatalClosedPiper PA-24 · Seymour, INApr 5, 1966 · N7300P · Destroyed NTSB CHI66F0629Accident · No injuriesClosedMooney M20 · Indianapolis, INMar 20, 1966 · N5279B · Substantial damage NTSB CHI66D0671Accident · Minor injuriesClosedPiper PA-22 · Linton, INMar 20, 1966 · N5004Z · Substantial damage NTSB CHI66D0637Accident · No injuriesClosedMooney M20C · Warsaw, INMar 2, 1966 · N6846U · Substantial damage NTSB CHI66D0648Accident · No injuriesClosedCessna 150 · Terre Haute, INFeb 26, 1966 · N6427F · Substantial damage NTSB CHI66D0615Accident · No injuriesClosedPiper PA-28 · Richmond, INFeb 26, 1966 · N5792W · Substantial damage NTSB CHI66D0609Accident · No injuriesClosedCessna 182A · Mitchell, INFeb 18, 1966 · N3882D · Substantial damage NTSB CHI66D0605Accident · No injuriesClosedCessna 185 · Marion, INFeb 16, 1966 · N2531Z · Substantial damage NTSB CHI66F0583Accident · No injuriesClosedPiper PA-24 · South Bend, INFeb 13, 1966 · N6051P · Substantial damage NTSB CHI66F0581Accident · No injuriesClosedBeechcraft 23 · Wabash, INFeb 13, 1966 · N2324Z · Substantial damage NTSB CHI66D0590Accident · No injuriesClosedCessna 182 · Mitchell, INFeb 12, 1966 · N3882D · Substantial damage NTSB CHI66D0638Accident · Minor injuriesClosedPiper PA-28 · Salem, INFeb 9, 1966 · N8901J · Substantial damage NTSB CHI66D0612Accident · No injuriesClosedCessna 140 · Flora, INFeb 5, 1966 · N89361 · Substantial damage NTSB CHI66D0563Accident · Minor injuriesClosedPiper PA-28 · Muncie, INJan 28, 1966 · N4563R · Substantial damage NTSB CHI66F0559Accident · No injuriesClosedCessna 310 · Fort Wayne, INJan 27, 1966 · N2609C · Substantial damage NTSB CHI66D0601Accident · No injuriesClosedBeechcraft 95-A55 · Marion, INJan 27, 1966 · N8577M · Substantial damage NTSB CHI66F0546Accident · Minor injuriesClosedCessna 310 · South Bend, INJan 19, 1966 · N653R · Substantial damage NTSB CHI66F0547Accident · No injuriesClosedBeechcraft G35 · Kendallville, INJan 18, 1966 · N312NF · Substantial damage NTSB CHI66D0529Accident · No injuriesClosedMooney M20 · Terre Haute, INJan 16, 1966 · N6523B · Substantial damage NTSB CHI66D0526Accident · No injuriesClosedGlobe 125 · Franklin, INJan 16, 1966 · N3333K · Substantial damage