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 CHI66F0202Accident · No injuriesClosedCessna 140 · Mooresville, INAug 14, 1965 · N3627V · Substantial damage NTSB CHI66D0176Accident · No injuriesClosedCessna 170B · Valpariso, INAug 13, 1965 · N43F · Substantial damage NTSB CHI66F0154Accident · No injuriesClosedPiper PA-22 · Indianapolis, INAug 7, 1965 · N9636D · Substantial damage NTSB CHI66F0124Accident · No injuriesClosedMooney M20D · Woodburn, INAug 5, 1965 · N6617U · Substantial damage NTSB CHI66F0188Accident · No injuriesClosedCessna 172 · Odon, INAug 4, 1965 · N8801U · Substantial damage NTSB CHI66F0194Accident · No injuriesClosedBeechcraft B95 · Culver, INAug 1, 1965 · N845B · Substantial damage NTSB CHI66F0143Accident · No injuriesClosedPiper PA-23 · South Bend, INAug 1, 1965 · N1211P · Substantial damage NTSB CHI66F0125Accident · No injuriesClosedBeechcraft M23A · Elkhart, INJul 26, 1965 · N8882M · Substantial damage NTSB CHI66F0116Accident · No injuriesClosedPiper PA-24 · Ft Wayne, INJul 26, 1965 · N6019P · Substantial damage NTSB CHI66F0140Accident · No injuriesClosedPiper PA-22 · Michigan City, INJul 25, 1965 · N4767Z · Substantial damage NTSB CHI66F0096Accident · No injuriesClosedMooney M20B · Dunkirk, INJul 25, 1965 · N74582 · Substantial damage NTSB CHI66F0156Accident · No injuriesClosedPiper PA-24 · Indianpolis, INJul 22, 1965 · N7424P · Substantial damage NTSB CHI66D0184Accident · No injuriesClosedPiper PA-23 · Renesselaer, INJul 13, 1965 · N5484Y · Substantial damage NTSB CHI66D0208Accident · No injuriesClosedBoeing A-75N1 · Indianapolis, INJul 11, 1965 · N300E · Substantial damage NTSB CHI66D0087Accident · No injuriesClosedCessna 170B · Greenfield, INJul 11, 1965 · N2738D · Substantial damage NTSB CHI66F0129Accident · Minor injuriesClosedFairchild PT-26 · Dyer, INJul 10, 1965 · N79177 · Substantial damage NTSB CHI66A0005Accident · 1 fatalClosedHughes 269B · Indianapolis, INJul 10, 1965 · N9362F · Destroyed NTSB CHI66D0122Accident · No injuriesClosedCessna 182 · Goshen, INJul 8, 1965 · N8835X · Substantial damage NTSB MKC66F0090Accident · Minor injuriesClosedPiper PA-18 · Terre Haute, INJul 7, 1965 · N5457H · Substantial damage NTSB CHI66D0097Accident · Minor injuriesClosedPiper PA-22 · Seafield, INJul 5, 1965 · N4764Z · Substantial damage NTSB CHI66D0088Accident · No injuriesClosedCessna 172 · Linton, INJul 5, 1965 · N8680U · Substantial damage NTSB CHI66F0103Accident · No injuriesClosedCessna 182 · Griffith, INJul 4, 1965 · N2140G · Substantial damage NTSB CHI66D0098Accident · No injuriesClosedPiper PA-30 · Seymour, INJun 24, 1965 · N7618Y · Substantial damage NTSB CHI66D0092Accident · Minor injuriesClosedPiper PA-22 · Monticello, INJun 23, 1965 · N3442Z · Substantial damage NTSB CHI66D0089Accident · No injuriesClosedCessna 205A · Madison, INJun 22, 1965 · N4862U · Substantial damage NTSB MKC66D0091Accident · No injuriesClosedPiper PA-12 · Valpariso, INJun 21, 1965 · N2718M · Substantial damage NTSB CHI66F0071Accident · No injuriesClosedCessna 172 · Knox, INJun 21, 1965 · N8641U · Substantial damage NTSB CHI66F0121Accident · Minor injuriesClosedPiper PA-24 · Helmsburg, INJun 19, 1965 · N6306P · Substantial damage NTSB CHI66F0076Accident · No injuriesClosedPiper PA-18 · Warsaw, INJun 19, 1965 · N339T · Substantial damage NTSB CHI66D0069Accident · No injuriesClosedCessna 140 · Clay City, INJun 16, 1965 · N2446N · Substantial damage NTSB CHI66F0057Accident · No injuriesClosedMooney M20C · Indianapolis, INJun 14, 1965 · N78989 · Substantial damage NTSB CHI66F0070Accident · No injuriesClosedErcoupe 415C · Mooresville, INJun 8, 1965 · N37117 · Substantial damage NTSB CHI66F0073Accident · Minor injuriesClosedCessna 182 · Indianapolis, INMay 31, 1965 · N2388R · Substantial damage NTSB CHI65A0098Accident · 2 fatalClosedCessna 182 · Indianapolis, INMay 31, 1965 · N3126U · Destroyed NTSB CHI66F0025Accident · No injuriesClosedCessna 172C · Ft Wayne, INMay 30, 1965 · N8442X · Substantial damage NTSB CHI66D0030Accident · Minor injuriesClosedSwift GC-1B · Linton, INMay 30, 1965 · N3291K · Destroyed NTSB CHI66F0027Accident · No injuriesClosedCessna 140 · Ramsey, INMay 29, 1965 · N76735 · Substantial damage NTSB CHI66D0135Accident · No injuriesClosedLuscombe 8F · Muncie, INMay 29, 1965 · N2173B · Substantial damage NTSB CHI65F0187Accident · No injuriesClosedCessna 210 · Fort Wayne, INMay 26, 1965 · N9537T · Substantial damage NTSB CHI66F0004Accident · No injuriesClosedAeronca 7AC · Dyer, INMay 24, 1965 · N81468 · Substantial damage NTSB CHI66F0008Accident · No injuriesClosedCessna 310 · Michigan City, INMay 20, 1965 · N1747H · Substantial damage NTSB CHI65D0167Accident · No injuriesClosedCessna 172 · Lafayette, INMay 19, 1965 · N7475A · Substantial damage NTSB CHI66F0058Accident · Minor injuriesClosedPiper PA-22 · Jeffersonville, INMay 13, 1965 · N5797Z · Substantial damage NTSB CHI65F0161Accident · Minor injuriesClosedPiper PA-28 · Hererville, INMay 1, 1965 · N7198W · Substantial damage NTSB CHI65F0191Accident · Serious injuriesClosedBeechcraft 95A · Bloomington, INApr 29, 1965 · N6141V · Substantial damage NTSB CHI65D0119Accident · No injuriesClosedCessna 182 · Richmond, INApr 17, 1965 · N2829Y · Substantial damage NTSB CHI65F0181Accident · No injuriesClosedAeronca 11-AC · Warsaw, INApr 11, 1965 · N86023 · Substantial damage NTSB CHI65D0152Accident · No injuriesClosedPiper PA-22 · Warren, INApr 11, 1965 · N5457Z · Substantial damage NTSB CHI65F0141Accident · No injuriesClosedCessna 175 · Lebanon, INApr 3, 1965 · N7416M · Substantial damage NTSB CHI65F0107Accident · No injuriesClosedBeechcraft D-18S · Crawfordsville, INApr 1, 1965 · N57G · Substantial damage