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 CHI74FET19Accident · No injuriesClosedMeyers 200D · Hammond, INMay 28, 1974 · N239M · Substantial damage NTSB CHI74FEA41Accident · No injuriesClosedGrumman G-164A · Madison, INMay 24, 1974 · N9830 · Substantial damage NTSB CHI74AC093Accident · 1 fatalClosedCessna T337G · Frankfort, INMay 24, 1974 · N165 · Destroyed NTSB CHI74FEA40Accident · No injuriesClosedErco 415-C · Greenfield, INMay 21, 1974 · N99326 · Substantial damage NTSB CHI74FEA39Accident · No injuriesClosedCessna 150L · Lebanon, INMay 20, 1974 · N10795 · Substantial damage NTSB CHI74DEA37Accident · No injuriesClosedAeronca 0-58B · Crawfordsvl, INMay 14, 1974 · N47125 · Substantial damage NTSB CHI74AC088Accident · 2 fatalClosedGlobe GC-1B · Huntington, INMay 13, 1974 · N3260K · Destroyed NTSB CHI74DEA36Accident · No injuriesClosedAmer Avco AA-1B · English, INMay 2, 1974 · N8880L · Substantial damage NTSB CHI74FEA35Accident · No injuriesClosedCessna 172 · New Castle, INApr 12, 1974 · N46139 · Substantial damage NTSB MKC74AK057Accident · Serious injuriesClosedBoeing 727-31 · Terre Haute, INApr 1, 1974 · N833TW · No damage NTSB CHI74FEA34Accident · Serious injuriesClosedCessna 210J · Lafayette, INMar 30, 1974 · N3348S · Substantial damage NTSB CHI74FEA33Accident · No injuriesClosedPiper PA-24 · W Lafayette, INMar 23, 1974 · N5568P · Substantial damage NTSB CHI74DEA38Accident · No injuriesClosedPitts S-1S · New Castle, INMar 23, 1974 · N3R · Substantial damage NTSB CHI74DEA32Accident · No injuriesClosedCessna 182 · Indianapolis, INMar 20, 1974 · N8416S · Substantial damage NTSB CHI74AC076Accident · 6 fatalClosedBeech 95-B55 · Ellettsville, INMar 11, 1974 · N3031W · Destroyed NTSB CHI74DEA31Accident · Serious injuriesClosedCessna 150 · Bloomington, INMar 2, 1974 · N5747G · No damage NTSB CHI74DEA30Accident · No injuriesClosedCessna 175 · Lafayette, INFeb 28, 1974 · N6883E · Substantial damage NTSB UNK74X0102Accident · 1 fatalClosedPiper PA-22 · Wilkinson, INFeb 23, 1974 · N3642Z · Destroyed NTSB CHI74FEA29Accident · Minor injuriesClosedAero Comdr 520-48 · Oxford, INFeb 23, 1974 · N144X · Substantial damage NTSB NYC74AN072Accident · 1 fatalClosedCessna U206 · Monon, INFeb 22, 1974 · N71992 · Destroyed NTSB CHI74FEA27Accident · No injuriesClosedMooney M20E · Tunnelton, INFeb 15, 1974 · N2620W · Substantial damage NTSB CHIMJAC070Accident · 1 fatalClosedCessna 337C · Kokomo, INFeb 13, 1974 · N2622S · Destroyed NTSB CHI74FEA26Accident · Serious injuriesClosedPiper PA-28 · Indianapolis, INFeb 3, 1974 · N22EC · Destroyed NTSB CHI74AC060Accident · No injuriesClosedBoeing 707 · Indianapolis, INJan 17, 1974 · N791TW · Substantial damage NTSB CHI74DEA25Accident · No injuriesClosedBeech V35 · Indianapolis, INJan 14, 1974 · N4856J · Substantial damage NTSB CHI74AC058Accident · Minor injuriesClosedCessna 310P · Fort Wayne, INJan 11, 1974 · N5915M · Substantial damage NTSB CHI74AC057Accident · Minor injuriesClosedPiper PA-23 · Kokomo, INJan 10, 1974 · N6764Y · Substantial damage NTSB CHI74AC056Accident · No injuriesClosedGrumman G-1159 · Michigan City, INJan 7, 1974 · N9300 · Substantial damage NTSB CHI74FEA23Accident · No injuriesClosedCessna 310N · Terre Haute, INJan 6, 1974 · N4159Q · Substantial damage NTSB CHI74DEA24Accident · No injuriesClosedCessna 172 · Shelbyville, INJan 1, 1974 · N20026 · Substantial damage NTSB CHI74FET16Accident · Serious injuriesClosedPiper PA-24 · Fort Wayne, INDec 27, 1973 · N8074D · Destroyed NTSB CHI74AC051Accident · 2 fatalClosedBeech 95-C55 · Rochester, INDec 19, 1973 · N6299V · Destroyed NTSB CHI74DET15Accident · No injuriesClosedBeech A35 · Logansport, INDec 9, 1973 · N708B · Destroyed NTSB CHI74DEA22Accident · No injuriesClosedPiper PA-22 · Francisco, INDec 1, 1973 · N4698Z · Substantial damage NTSB CHI74DEA21Accident · No injuriesClosedPiper PA-28R · Madison, INNov 23, 1973 · N9482N · Substantial damage NTSB CHI74AC042Accident · 5 fatalClosedCessna 421 · Plymouth, INNov 14, 1973 · N550T · Destroyed NTSB CHI74FEA20Accident · No injuriesClosedPiper PA-22 · Monroe City, INNov 12, 1973 · N4919Z · Substantial damage NTSB CHI74DEA19Accident · No injuriesClosedCessna 172 · Terre Haute, INNov 7, 1973 · N4423Q · Substantial damage NTSB CHI74FET11Accident · Serious injuriesClosedCessna 150 · Michigan City, INNov 2, 1973 · N6987G · Substantial damage NTSB CHI74DEA18Accident · Minor injuriesClosedCessna 150 · Brazil, INOct 27, 1973 · N4027J · Substantial damage NTSB CHI74FET12Accident · No injuriesClosedPiper PA-34 · Osceola, INOct 26, 1973 · N55145 · Substantial damage NTSB CHI74FEA17Accident · Minor injuriesClosedPiper PA-23 · Terre Haute, INOct 26, 1973 · N1365P · Destroyed NTSB CHI74FEA16Accident · Minor injuriesClosedCessna 172F · Lafayette, INOct 19, 1973 · N8509U · Substantial damage NTSB CHI74FEA15Accident · 1 fatalClosedCorbin B-ACE · Franklin, INOct 9, 1973 · N10BA · Destroyed NTSB CHI74AC027Accident · Minor injuriesClosedLockheed 1049H · Gary, INSep 24, 1973 · N566E · Substantial damage NTSB CHI74FEA14Accident · Serious injuriesClosedTeenie TWO · Monticello, INSep 23, 1973 · N99151 · Destroyed NTSB CHI74DET10Accident · Minor injuriesClosedCessna 172 · Peru, INSep 23, 1973 · N1617F · Substantial damage NTSB CHI74DEA13Accident · No injuriesClosedBell 47G-2A · Veedersburg, INSep 16, 1973 · N7579 · Substantial damage NTSB CHI74FET09Accident · No injuriesClosedCessna 182F · Elkhart, INSep 7, 1973 · N3260U · Substantial damage NTSB CHI74FET08Accident · Serious injuriesClosedCessna 182P · Valparaiso, INSep 5, 1973 · N58509 · Destroyed