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 CHI78DET19Accident · No injuriesClosedCessna 310Q · Fort Wayne, INMar 14, 1978 · N69737 · Substantial damage NTSB CHI78FEX09Accident · No injuriesClosedCessna 150 · Zionsville, INMar 5, 1978 · N3688V · Substantial damage NTSB CHI78DEX13Accident · No injuriesClosedStinson 108-2 · Connersville, INFeb 26, 1978 · N9451K · Substantial damage NTSB CHI78FET14Accident · No injuriesClosedGrum Amer AA-1B · Fort Wayne, INFeb 18, 1978 · N8973L · Substantial damage NTSB CHI78FA020Accident · No injuriesClosedSikorsky S61L · Florence, INFeb 6, 1978 · N305V · Substantial damage NTSB CHI78FET11Accident · No injuriesClosedGrum Amer AA1-B · Fort Wayne, INFeb 5, 1978 · N9892L · Substantial damage NTSB CHI78FET09Accident · No injuriesClosedCessna T337 · Elkhart, INJan 24, 1978 · N9CT · Substantial damage NTSB CHI78FEX08Accident · No injuriesClosedCessna 421B · Columbus, INJan 21, 1978 · N8008Q · Substantial damage NTSB CHI78FET08Accident · Minor injuriesClosedPiper PA-28 · South Bend, INJan 21, 1978 · N15764 · Substantial damage NTSB CHI78FA014Accident · 1 fatalClosedBeech BE-35 · Tell City, INJan 5, 1978 · N8872A · Destroyed NTSB CHI78FET06Accident · Minor injuriesClosedCessna 172F · Fort Wayne, INDec 22, 1977 · N7860U · Substantial damage NTSB CHI78FEX07Accident · Minor injuriesClosedPiper PA-23 · St Paul, INDec 17, 1977 · N498HH · Substantial damage NTSB CHI78DEX06Accident · Serious injuriesClosedAerostar 601P · Evansville, INDec 16, 1977 · N9506Q · Minor damage NTSB DCA78AA001Accident · 29 fatalClosedDouglas DC-3 · Evansville, INDec 13, 1977 · N51071 · Destroyed NTSB CHI78FET05Accident · No injuriesClosedCessna 414 · Valparaiso, INDec 8, 1977 · N414BA · Substantial damage NTSB CHI78FET04Accident · No injuriesClosedRockwell 112TC · Gary, INDec 5, 1977 · N4649W · Substantial damage NTSB CHI78FEX05Accident · Serious injuriesClosedHughes 269B · Speedway, INDec 1, 1977 · N9556F · Substantial damage NTSB CHI78FET03Accident · Minor injuriesClosedCessna 340A · Ft Wayne, INNov 27, 1977 · N1388G · Substantial damage NTSB CHI78DEX03Accident · Serious injuriesClosedBeech 36 · Terre Haute, INNov 27, 1977 · N7981R · Substantial damage NTSB CHI78FA010Accident · 1 fatalClosedPiper PA-28R · Ladoga, INNov 19, 1977 · N3095R · Destroyed NTSB CHI788A011Accident · 5 fatalClosedBeech P35 · New Salem, INNov 17, 1977 · N9958Y · Destroyed NTSB CHI78FEX02Accident · Minor injuriesClosedBeech B95 · Indianapolis, INNov 7, 1977 · N2048C · Substantial damage NTSB CHI78DEX04Accident · No injuriesClosedCessna 150 · Noblesville, INNov 4, 1977 · N7964F · Substantial damage NTSB CHI78FA005Accident · 4 fatalClosedBeech P35 · Francesville, INOct 30, 1977 · N1555S · 2 aircraft · Destroyed NTSB CHI78FET01Accident · Minor injuriesClosedAmerican AA-1 · South Bend, INOct 22, 1977 · N5604L · Substantial damage NTSB CHI78FA003Accident · 1 fatalClosedBeech 200 · Valparaiso, INOct 19, 1977 · N17530 · Destroyed NTSB CHI78DEX01Accident · Minor injuriesClosedMoore KR-1 · Sheridan, INOct 15, 1977 · N65029 · Destroyed NTSB CHI78FA001Accident · Serious injuriesClosedBeech E18S · Plymouth, INOct 1, 1977 · N5601D · Destroyed NTSB CHI77FEX54Accident · No injuriesClosedCessna 402 · Indianapolis, INSep 29, 1977 · N8437F · Substantial damage NTSB CHI77FEX53Accident · No injuriesClosedBellanca 14-19 · Mccordsville, INSep 27, 1977 · N6555N · Substantial damage NTSB CHI77FEX51Accident · Minor injuriesClosedAcrosport 1 · Indianapolis, INSep 25, 1977 · N15HS · 2 aircraft · Substantial damage NTSB CHI77BEX52Accident · No injuriesClosedCessna 140 · Anderson, INSep 25, 1977 · N76168 · Substantial damage NTSB CHI77FA074Accident · 1 fatalClosedBeech C55 · Farmersburg, INSep 24, 1977 · N3754Q · Destroyed NTSB CHI77DEK50Accident · No injuriesClosedPiper PA-28R · Mount Vernon, INSep 22, 1977 · N32849 · Substantial damage NTSB CHI77FET34Accident · 1 fatalClosedPiper PA-22 · Fort Wayne, INSep 11, 1977 · N3213B · Destroyed NTSB CHI77DEX47Accident · Serious injuriesClosedPiccard AX6 · Wanamaker, INSep 10, 1977 · N3191 · Minor damage NTSB CHI77FEX48Accident · 1 fatalClosedBeech C45 · Richmond, INSep 4, 1977 · N4111A · Substantial damage NTSB CHI77FEX49Accident · Minor injuriesClosedMidget Mustng · Clinton, INSep 3, 1977 · N6141U · Substantial damage NTSB CHI77FEX46Accident · No injuriesClosedTomcat MK5A · Monrovia, INSep 1, 1977 · N9010T · Substantial damage NTSB CHI77FEX45Accident · No injuriesClosedCessna 421B · Sheridan, INAug 28, 1977 · N41114 · Substantial damage NTSB CHI77FET33Accident · No injuriesClosedCessna 150M · Hobart, INAug 24, 1977 · N63155 · Substantial damage NTSB CHI77EEX44Accident · No injuriesClosedMooney M20E · Greenwood, INAug 21, 1977 · N1307W · Substantial damage NTSB CHI77FEX43Accident · Serious injuriesClosedEvans VP-1 · Speedway, INAug 20, 1977 · N65209 · Substantial damage NTSB CHI77DEX42Accident · No injuriesClosedPiper PA-34 · Huntingburg, INAug 9, 1977 · N32174 · Substantial damage NTSB CHI77FET31Accident · 2 fatalClosedTurner T-40A · Valparaiso, INAug 1, 1977 · N278S · Destroyed NTSB CHI77FET28Accident · Serious injuriesClosedCallair A-9 · Winamac, INJul 28, 1977 · N7734V · Destroyed NTSB CHI77DET29Accident · No injuriesClosedBeech BE-19 · Elkhart, INJul 28, 1977 · N1914L · Substantial damage NTSB CHI77FET27Accident · Serious injuriesClosedVolksplane VP-IFD · Chesterton, INJul 27, 1977 · N16655 · Destroyed NTSB CHI77DET24Accident · No injuriesClosedCessna 150 · Milford, INJul 18, 1977 · N7306G · Substantial damage NTSB CHI77DEC45Accident · Serious injuriesClosedDouglas DC-6A · Ft.Wayne, INJul 16, 1977 · N515TY · No damage