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 UNK64X3851Accident · No injuriesClosedBellanca 14132 · Valparaiso, INSep 7, 1964 · N74388 · Substantial damage NTSB UNK64X3850Accident · No injuriesClosedMaule M4 · Ft Wayne, INSep 7, 1964 · N4709T · Substantial damage NTSB UNK64X3803Accident · 1 fatalClosedErcoupe 415C · Columbus, INSep 5, 1964 · N2120H · Substantial damage NTSB UNK64X3792Accident · No injuriesClosedPiper PA30 · Muncie, INSep 5, 1964 · N7406Y · Substantial damage NTSB UNK64X3734Accident · No injuriesClosedBeechcraft D18 · Marion, INSep 2, 1964 · N2008H · Substantial damage NTSB UNK64X3710Accident · No injuriesClosedSwift GC1B · Tipton, INAug 31, 1964 · N3208K · Substantial damage NTSB UNK64X3649Accident · No injuriesClosedNo American TF51D · Laporte, INAug 28, 1964 · N6362T · Substantial damage NTSB UNK64X3646Accident · No injuriesClosedNavion G · Rushville, INAug 28, 1964 · N1622T · Substantial damage NTSB UNK64X3624Accident · No injuriesClosedCessna 172 · Lafayette, INAug 27, 1964 · N3020U · Substantial damage NTSB UNK64X3605Accident · No injuriesClosedStinson 108-3 · Gary, INAug 26, 1964 · N6459M · Substantial damage NTSB UNK64X3570Accident · Serious injuriesClosedCessna 170A · Paoli, INAug 23, 1964 · N1374D · Destroyed NTSB UNK64X3511Accident · No injuriesClosedPiper PA28 · Noblesville, INAug 21, 1964 · N5633W · Substantial damage NTSB UNK64X3467Accident · No injuriesClosedBeechcraft H35 · Bronnsburg, INAug 19, 1964 · N5542D · Substantial damage NTSB UNK64X3447Accident · No injuriesClosedPiper PA22 · Marion, INAug 18, 1964 · N5348Z · Substantial damage NTSB UNK64X3390Accident · No injuriesClosedPiper J3 · Linn Grove, INAug 15, 1964 · N33053 · Substantial damage NTSB UNK64X3244Accident · Minor injuriesClosedBrantly B2B · Borden, INAug 6, 1964 · N2190U · Substantial damage NTSB UNK64X3199Accident · No injuriesClosedSchweizer 222E · Jefferson, INAug 3, 1964 · N8679R · Substantial damage NTSB UNK64X3184Accident · Serious injuriesClosedCessna 120 · Danville, INAug 2, 1964 · N1764V · Destroyed NTSB UNK64X3085Accident · No injuriesClosedLuscombe 11A · Indianapolis, INJul 28, 1964 · N1666B · Substantial damage NTSB UNK64X3030Accident · No injuriesClosedCessna 172 · Rushville, INJul 25, 1964 · N2390U · Substantial damage NTSB UNK64X2929Accident · No injuriesClosedCessna 172D · Washington, INJul 19, 1964 · N2723U · Substantial damage NTSB UNK64X2918Accident · No injuriesClosedAeronca 11AC · Lebanon, INJul 19, 1964 · N9736E · Substantial damage NTSB UNK64X2902Accident · No injuriesClosedPiper PA-22 · Madison, INJul 18, 1964 · N7040B · Substantial damage NTSB UNK64X2843Accident · No injuriesClosedPiper PA22 · Anderson, INJul 15, 1964 · N5542Z · Substantial damage NTSB UNK64X2780Accident · Serious injuriesClosedPiper PA11 · Sullivan, INJul 12, 1964 · N4767M · Destroyed NTSB UNK64X2758Accident · No injuriesClosedTaylorcraft BL65 · Marion, INJul 11, 1964 · N29621 · Substantial damage NTSB UNK64X2694Accident · No injuriesClosedAeronca 7AC · Ramsey, INJul 7, 1964 · N81611 · Substantial damage NTSB UNK64X2619Accident · No injuriesClosedGlobe Swift GC1B · Ligonier, INJul 3, 1964 · N78009 · Substantial damage NTSB UNK64X2561Accident · 2 fatalClosedCessna 150 · New Richmond, INJun 29, 1964 · N7806E · Destroyed NTSB UNK64X2490Accident · No injuriesClosedStearman YIS · Dunlap, INJun 26, 1964 · N15521 · Substantial damage NTSB UNK64X2460Accident · No injuriesClosedLuscombe 8A · Jeffersonvlle, INJun 24, 1964 · N2758K · Substantial damage NTSB UNK64X2449Accident · No injuriesClosedCessna 310 · Nashville, INJun 23, 1964 · N5226A · Substantial damage NTSB UNK64X2447Accident · No injuriesClosedCessna 172A · Farmersburg, INJun 23, 1964 · N6982A · Destroyed NTSB UNK64X2316Accident · Minor injuriesClosedCessna 172 · Van Buren, INJun 16, 1964 · N6498E · Substantial damage NTSB UNK64X2309Accident · 2 fatalClosedBeech 35 · Laporte, INJun 15, 1964 · N3067V · Destroyed NTSB UNK64X2243Accident · No injuriesClosedBeechcraft 23 · South Bend, INJun 12, 1964 · N2347J · Substantial damage NTSB UNK64X2118Accident · Serious injuriesClosedPiper PA22 · Angola, INJun 4, 1964 · N4568Z · Substantial damage NTSB UNK64X2088Accident · No injuriesClosedCessna 140 · Decatur, INJun 3, 1964 · N76537 · Substantial damage NTSB UNK64X2051Accident · No injuriesClosedPiper PA25 · Bass Lake, INMay 31, 1964 · N6035Z · Substantial damage NTSB UNK64X2006Accident · No injuriesClosedAeronca 7AC · Medaryville, INMay 29, 1964 · N1537E · Substantial damage NTSB UNK64X1987Accident · No injuriesClosedCessna 140 · Libertyville, INMay 28, 1964 · N2919N · Substantial damage NTSB UNK64X1981Accident · No injuriesClosedPiper PA22 · Warsaw, INMay 27, 1964 · N3822P · Destroyed NTSB UNK64X1868Accident · No injuriesClosedMaule M4 · Evansville, INMay 21, 1964 · N4716T · Substantial damage NTSB UNK64X1857Accident · No injuriesClosedAero Comm 520 · Indianapolis, INMay 20, 1964 · N4108B · Substantial damage NTSB UNK64X1763Accident · No injuriesClosedCessna 172 · Mt Vernon, INMay 14, 1964 · N5328T · Substantial damage NTSB UNK64X1758Accident · 1 fatalClosedCessna 170B · Lakeville, INMay 13, 1964 · N1806C · Destroyed NTSB UNK64X1714Accident · Serious injuriesClosedNavion NAV4 · Indianapolis, INMay 10, 1964 · N5153K · Substantial damage NTSB UNK64X1693Accident · Minor injuriesClosedNavion NAV4 · Bloomfield, INMay 10, 1964 · N8585H · Substantial damage NTSB UNK64X1690Accident · Serious injuriesClosedAeronca 7AC · Lebanon, INMay 9, 1964 · N84613 · Destroyed NTSB UNK64X1685Accident · No injuriesClosedCessna 182 · Ramsey, INMay 9, 1964 · N3688U · Substantial damage