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 CHI72AC103Accident · Serious injuriesClosedBoeing 727 · Gary, INJun 28, 1972 · N54336 · No damage NTSB CHI72FET35Accident · No injuriesClosedCessna 206 · Rochester, INJun 16, 1972 · N5265U · Substantial damage NTSB CHI73FET04Accident · No injuriesClosedCessna 150 · Valparaiso, INJun 10, 1972 · N6608T · Substantial damage NTSB CHI72FET34Accident · Minor injuriesClosedDowner RC-3 · Ligonier, INJun 3, 1972 · N6097K · Substantial damage NTSB CHI72FET33Accident · 1 fatalClosedCessna 188A · South Bend, INJun 3, 1972 · N9936G · Substantial damage NTSB CHI72DEA47Accident · No injuriesClosedBeech A23 · Huntingburg, INJun 3, 1972 · N5666S · Substantial damage NTSB CHI72FEA46Accident · No injuriesClosedBell 47D-1 · Haubstadt, INJun 1, 1972 · N3087G · Destroyed NTSB CHI72FET32Accident · No injuriesClosedCessna 182F · Logansport, INMay 31, 1972 · N3210U · Substantial damage NTSB CHI72FET30Accident · No injuriesClosedLuscombe 8A · Auburn, INMay 29, 1972 · N71898 · Substantial damage NTSB CHI72FEA45Accident · No injuriesClosedCessna 150B · Rockville, INMay 29, 1972 · N7269X · Destroyed NTSB CHI72DET31Accident · No injuriesClosedPiper PA-28 · South Bend, INMay 28, 1972 · N576FL · Substantial damage NTSB CHI72DEA44Accident · No injuriesClosedCessna 140 · W.Lafayette, INMay 24, 1972 · N77130 · Substantial damage NTSB CHI72FEA40Accident · Minor injuriesClosedPiper PA-28 · Lafayette, INMay 23, 1972 · N286P · Substantial damage NTSB CHI72FET29Accident · Minor injuriesClosedPiper PA-28R · Mentone, INMay 21, 1972 · N9346N · Substantial damage NTSB CHI72FET27Accident · Serious injuriesClosedPiper PA-25 · Mishawaka, INMay 21, 1972 · N4687Y · Destroyed NTSB CHI72AC093Accident · 1 fatalClosedCessna 150F · Fort Wayne, INMay 17, 1972 · N8310G · Destroyed NTSB CHI72DET26Accident · No injuriesClosedPiper PA-28 · Syracuse, INMay 16, 1972 · N8733W · Substantial damage NTSB CHI72FEA41Accident · No injuriesClosedPiper PA-22 · Muncie, INMay 9, 1972 · N7220D · Substantial damage NTSB CHI72DEA42Accident · No injuriesClosedPiper PA-28 · Perrysville, INMay 7, 1972 · N1895T · Substantial damage NTSB CHI72AC087Accident · 2 fatalClosedCessna 175A · Boonville, INMay 7, 1972 · N6857E · Destroyed NTSB CHI72FEA38Accident · No injuriesClosedPiper PA-28 · Indianapolis, INMay 4, 1972 · N22EC · Substantial damage NTSB CHI72FEA42Accident · Minor injuriesClosedPiper PA-32 · Crawfordsvile, INMay 2, 1972 · N3459W · Substantial damage NTSB CHI72FEA39Accident · No injuriesClosedRyan ST-3KR · Lafayette, INApr 22, 1972 · N47368 · Substantial damage NTSB CHI72DET24Accident · No injuriesClosedAlon A-2 · Mentone, INApr 16, 1972 · N6557Q · Substantial damage NTSB CHI72FEA37Accident · Serious injuriesClosedCessna 172 · Greenfield, INApr 5, 1972 · N3924L · Destroyed NTSB CHI72FEA36Accident · Serious injuriesClosedCessna 150 · Greencastle, INMar 24, 1972 · N4140U · Destroyed NTSB CHI72DET20Accident · No injuriesClosedLuscombe 8A · Auburn, INMar 19, 1972 · N71823 · Substantial damage NTSB CHI72FET18Accident · Serious injuriesClosedCessna 172 · Elkhart, INMar 12, 1972 · N5632A · Destroyed NTSB CHI72FET17Accident · No injuriesClosedRobertson 172F · Hobart, INMar 5, 1972 · N8444U · Substantial damage NTSB CHI72DEA35Accident · No injuriesClosedCessna 177B · Connersville, INMar 5, 1972 · N34158 · Substantial damage NTSB CHI72FEA34Accident · No injuriesClosedCessna 150H · Terre Haute, INMar 3, 1972 · N23238 · Substantial damage NTSB CHI72FET22Accident · Serious injuriesClosedPiper PA-28 · Crown Point, INMar 2, 1972 · N20LA · Substantial damage NTSB CHI72DEA31Accident · No injuriesClosedCessna 150 · Columbus, INFeb 28, 1972 · N50758 · Substantial damage NTSB CHI72FEA30Accident · No injuriesClosedPiper PA-23 · Kokomo, INFeb 27, 1972 · N1325P · Destroyed NTSB CHI72DEA33Accident · No injuriesClosedCessna 172I · Greentown, INFeb 26, 1972 · N46139 · Substantial damage NTSB CHI72FET19Accident · No injuriesClosedSwearingen SA26AT · Valparaiso, INFeb 25, 1972 · N4257X · Substantial damage NTSB CHI72FET16Accident · No injuriesClosedBeech 65-90 · Elkhart, INFeb 23, 1972 · N11ER · Substantial damage NTSB CHI72FET14Accident · Minor injuriesClosedCessna 150H · South Bend, INFeb 22, 1972 · N7240S · Destroyed NTSB CHI72DEA32Accident · No injuriesClosedCessna 411 · Brownsburg, INFeb 19, 1972 · N7324U · Substantial damage NTSB CHI72FEA29Accident · Minor injuriesClosedCessna 320 · Franklin, INFeb 12, 1972 · N5776X · Destroyed NTSB CHI72DEA28Accident · No injuriesClosedCessna 310 · Evansville, INFeb 3, 1972 · N3082L · Substantial damage NTSB CHI72FET12Accident · No injuriesClosedPiper PA-28 · Peru, INJan 28, 1972 · N5169S · Substantial damage NTSB CHI72AC058Accident · 2 fatalClosedCessna 182H · Brazil, INJan 9, 1972 · N8351S · Destroyed NTSB CHI72DEA27Accident · No injuriesClosedCessna 150 · Lebanon, INJan 8, 1972 · N8098F · Substantial damage NTSB CHI72DEA26Accident · No injuriesClosedCessna 182 · New Castle, INJan 1, 1972 · N5158D · Substantial damage NTSB CHI72FEA25Accident · No injuriesClosedCessna 172 · Greencastle, INDec 20, 1971 · N46374 · Substantial damage NTSB CHI72AC052Accident · 1 fatalClosedPiper PA-22 · Evansville, INDec 16, 1971 · N8641C · Destroyed NTSB CHI72DEA24Accident · No injuriesClosedCessna 172 · Martinsville, INDec 11, 1971 · N7613G · Substantial damage NTSB CHI72FET11Accident · Serious injuriesClosedCessna 175 · Auburn, INDec 4, 1971 · N7627M · Substantial damage NTSB CHI72FEA23Accident · Minor injuriesClosedCessna 150 · Pittsboro, INNov 26, 1971 · N5988G · Substantial damage