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 CHI77FA018Accident · 3 fatalClosedPiper PA-28 · Columbia City, INDec 25, 1976 · N1510J · Destroyed NTSB CHI77FEX06Accident · 1 fatalClosedCessna 150G · Patriot, INDec 15, 1976 · N2879S · Destroyed NTSB CHI76FA013Accident · 1 fatalClosedCessna 421B · Winchester, INDec 11, 1976 · N570C · Destroyed NTSB CHI77FA011Accident · 1 fatalClosedCessna 195 · Roanoke, INDec 10, 1976 · N169CB · Destroyed NTSB CHI77FET06Accident · No injuriesClosedAeronca 7AC · Remington, INDec 5, 1976 · N2421E · Substantial damage NTSB CHI77FEA05Accident · No injuriesClosedBeech 3TM · Shelbyville, INNov 19, 1976 · N1171X · Substantial damage NTSB CHI77DEA04Accident · No injuriesClosedPiper PA-28 · Jeffersonville, INNov 18, 1976 · N5599F · Substantial damage NTSB CHIMMFET05Accident · No injuriesClosedCessna 172M · Hobart, INNov 17, 1976 · N21893 · Substantial damage NTSB CHI77FEA03Accident · No injuriesClosedPiper PA-32 · Plainville, INNov 11, 1976 · N3533W · Destroyed NTSB CHI77DEA02Accident · No injuriesClosedBeech 35 · Indianapolis, INNov 7, 1976 · N802R · Substantial damage NTSB CHI77FET04Accident · Serious injuriesClosedMonarch Marske · Michigan City, INNov 6, 1976 · N6977 · Substantial damage NTSB CHI77FET03Accident · No injuriesClosedPitts Spcl S-2A · Kendallville, INOct 30, 1976 · N3186S · Substantial damage NTSB CHI77FET02Accident · Serious injuriesClosedErco 415-C · E.Syracuse, INOct 24, 1976 · N87105 · Destroyed NTSB CHI77FEA01Accident · Serious injuriesClosedBeech B35 · Indianapolis, INOct 3, 1976 · N3949N · Destroyed NTSB CHI77FET01Accident · Minor injuriesClosedBeech C23 · Culver, INOct 2, 1976 · N9165S · Substantial damage NTSB CHI77FA001Accident · 1 fatalClosedCessna 172M · Hagerstown, INOct 2, 1976 · N6945H · Destroyed NTSB CHI76AC094Accident · 1 fatalClosedCessna 182 · Perrysville, INSep 29, 1976 · N3424F · Destroyed NTSB CHI76DEA52Accident · No injuriesClosedCessna A188B · New Point, INSep 28, 1976 · N9808G · Substantial damage NTSB CHI76FEA51Accident · No injuriesClosedPiper PA-28R · Lafayette, INSep 16, 1976 · N100TC · Substantial damage NTSB CHI76FET50Accident · No injuriesClosedStinson 108-1 · Woodburn, INSep 5, 1976 · N8826K · Substantial damage NTSB CHI76FEA50Accident · No injuriesClosedCessna 195 · Lafayette, INSep 1, 1976 · N4666T · Substantial damage NTSB CHI76FEA48Accident · No injuriesClosedCessna 150L · Greenwood, INAug 21, 1976 · N6956G · Substantial damage NTSB CHI76FET48Accident · No injuriesClosedCessna 172 · Griffith, INAug 17, 1976 · N5750A · Substantial damage NTSB CHI76FET47Accident · No injuriesClosedCessna 150H · Gary, INAug 15, 1976 · N50189 · Substantial damage NTSB CHI76FET46Accident · No injuriesClosedCessna A188B · Poneto, INAug 11, 1976 · N4848R · Substantial damage NTSB CHI76FEA47Accident · No injuriesClosedCessna 310K · New Castle, INAug 8, 1976 · N7033L · Substantial damage NTSB CHI76FEA46Accident · No injuriesClosedCessna 182 · Tipton, INJul 30, 1976 · N8422S · Substantial damage NTSB CHI76AC082Accident · 1 fatalClosedPiper PA-28 · Gosport, INJul 30, 1976 · N6805W · Destroyed NTSB CHI76DETE5Accident · No injuriesClosedPiper PA-28 · Griffith, INJul 20, 1976 · N9458W · Substantial damage NTSB CHI76FEA49Accident · No injuriesClosedCessna 310D · Cutler, INJul 17, 1976 · N4440 · Substantial damage NTSB CHI76AC077Accident · 5 fatalClosedPiper PA-28 · Columbus, INJul 5, 1976 · N7915N · 2 aircraft · Destroyed NTSB CHI76DEA45Accident · No injuriesClosedPiper PA-25 · Vincennes, INJun 28, 1976 · N8674L · Substantial damage NTSB CHI76FET44Accident · No injuriesClosedErco 415-C · Lucerne, INJun 26, 1976 · N93682 · Substantial damage NTSB CHI76AC074Accident · 1 fatalClosedCommonwlth 185 · North Liberty, INJun 26, 1976 · N92991 · Substantial damage NTSB CHI76DEA44Accident · No injuriesClosedCessna A188B · Vincennes, INJun 25, 1976 · N70203 · Substantial damage NTSB UNK76X0101Accident · No injuriesClosedMooney M20C · Hobart, INJun 24, 1976 · N2583W · Substantial damage NTSB CHI76AC072Accident · No injuriesClosedPiper PA-34 · Michigan City, INJun 23, 1976 · N4968T · Substantial damage NTSB CHI76FET41Accident · No injuriesClosedAerospatle SE3160 · Medaryville, INJun 21, 1976 · N47256 · Substantial damage NTSB CHI76AC071Accident · 1 fatalClosedCessna 150K · Corunna, INJun 18, 1976 · N6112G · Destroyed NTSB CHI76FET39Accident · No injuriesClosedCessna 172 · Gary, INJun 11, 1976 · N3830L · Substantial damage NTSB CHI76AEA41Accident · Minor injuriesClosedBensen B7MC · Mooresville, INJun 10, 1976 · N12059 · Substantial damage NTSB CHI76FEA43Accident · No injuriesClosedCessna 150 · Charlestown, INJun 9, 1976 · N18171 · Substantial damage NTSB CHI76FEA39Accident · Serious injuriesClosedPiper PA-25 · Tipton, INJun 9, 1976 · N4773Y · Substantial damage NTSB CHI76FEA40Accident · No injuriesClosedCessna 182 · Greensburg, INJun 6, 1976 · N5793J · Substantial damage NTSB CHI76DET42Accident · No injuriesClosedCessna 150 · Woodburn, INJun 6, 1976 · N6044G · Substantial damage NTSB CHI76FEA38Accident · No injuriesClosedGrum Amer AA-5 · Mccordsville, INJun 4, 1976 · N9624U · Substantial damage NTSB CHI76AET38Accident · Minor injuriesClosedPiper PA-22 · Whitley, INJun 3, 1976 · N1416C · Substantial damage NTSB CHI76FET37Accident · Serious injuriesClosedPiper PA-28R · Munster, INMay 31, 1976 · N56639 · Substantial damage NTSB CHI76FET36Accident · Serious injuriesClosedAeronca 11AC · N Lake Village, INMay 31, 1976 · N3218E · Substantial damage NTSB CHI76FEA36Accident · Minor injuriesClosedCessna T210H · Indianapolis, INMay 31, 1976 · N2242R · Substantial damage