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 CHI72FEA19Accident · No injuriesClosedPiper PA-28 · Indianapolis, INNov 12, 1971 · N4953L · Substantial damage NTSB CHI72FEA21Accident · No injuriesClosedCessna 310J · Monticello, INNov 8, 1971 · N3109L · Substantial damage NTSB CHI72FEA17Accident · No injuriesClosedBensen B8M · Greenwood, INOct 30, 1971 · N8609E · Substantial damage NTSB CHI72FET10Accident · No injuriesClosedHughes 269A · Griffith, INOct 26, 1971 · N8810F · Substantial damage NTSB CHI72DEA22Accident · No injuriesClosedBeech J35 · Anderson, INOct 22, 1971 · N3056C · Substantial damage NTSB CHI72FET09Accident · No injuriesClosedCessna 170 · Winamac, INOct 8, 1971 · N4412V · Substantial damage NTSB CHI72DEA16Accident · No injuriesClosedPiper PA-32 · Anderson, INOct 6, 1971 · N8620N · Substantial damage NTSB CHI72DEA14Accident · No injuriesClosedStinson 108-3 · Acton, INOct 2, 1971 · N6919M · Destroyed NTSB CHI72DEA15Accident · No injuriesClosedTaylorcraft BC12-D · Palmyra, INOct 1, 1971 · N5610M · Substantial damage NTSB CHI72FEA20Accident · No injuriesClosedCessna 210G · Laconia, INSep 26, 1971 · N5901F · Substantial damage NTSB CHI72FEA12Accident · No injuriesClosedWilson B8M · Columbus, INSep 24, 1971 · N4274 · Substantial damage NTSB CHI72FET08Accident · Minor injuriesClosedLuscombe 8A · Elkhart, INSep 16, 1971 · N71375 · Substantial damage NTSB CHI72DEA18Accident · No injuriesClosedCessna 172L · Martinsville, INSep 3, 1971 · N2427L · Substantial damage NTSB CHI72AC019Accident · 2 fatalClosedPiper PA-22 · Angola, INSep 3, 1971 · N2730P · Destroyed NTSB CHI72FEA11Accident · Serious injuriesClosedBeech B35 · Monon, INSep 1, 1971 · N5166C · Destroyed NTSB CHI72DEA13Accident · No injuriesClosedPiper PA-28 · Delphi, INAug 30, 1971 · N6018W · Substantial damage NTSB CHI72FET06Accident · Minor injuriesClosedBell 47G-2 · Laporte, INAug 18, 1971 · N2495B · Destroyed NTSB CHI72FEA10Accident · No injuriesClosedBellanca 14-13 · Whitestown, INAug 18, 1971 · N86874 · Substantial damage NTSB CHI72FET05Accident · Minor injuriesClosedTaylorcraft BC-12D · Syracuse, INAug 15, 1971 · N5242M · Substantial damage NTSB CHI72FEA09Accident · Minor injuriesClosedCessna 172K · Wolcott, INAug 15, 1971 · N7102G · Substantial damage NTSB CHI72DET04Accident · No injuriesClosedCessna 120 · Warsaw, INAug 8, 1971 · N1831V · Substantial damage NTSB CHI72FET03Accident · No injuriesClosedHughes 269B · Griffith, INAug 7, 1971 · N9559F · Substantial damage NTSB CHI72FEA04Accident · No injuriesClosedBeech V35 · Winchester, INJul 24, 1971 · N9478S · Substantial damage NTSB CHI72FET02Accident · Minor injuriesClosedBrantly 305 · Monroeville, INJul 20, 1971 · N2211U · Destroyed NTSB CHI72FEA07Accident · No injuriesClosedPiper PA-25 · Roachdale, INJul 17, 1971 · N8681L · Substantial damage NTSB CHI72FEA03Accident · Minor injuriesClosedPiper J4A · Cloverdale, INJul 9, 1971 · N25733 · Substantial damage NTSB CHI72FEA01Accident · No injuriesClosedBoeing A75N1 · Greensburg, INJul 8, 1971 · N49954 · Substantial damage NTSB CHI72DEA08Accident · No injuriesClosedCessna 140 · Lebanon, INJul 6, 1971 · N77201 · Substantial damage NTSB CHI72AC004Accident · 1 fatalClosedBeech C35 · Crown Point, INJul 6, 1971 · N5983C · Destroyed NTSB CHI72FET01Accident · No injuriesClosedAerostar 201 · Gary, INJul 5, 1971 · N9296V · Substantial damage NTSB CHI72FEA02Accident · Minor injuriesClosedPiper PA-24 · Perrysville, INJul 5, 1971 · N6756P · Substantial damage NTSB CHI71DEA40Accident · No injuriesClosedPiper PA-28 · Jeffersonvile, INJun 28, 1971 · N7285J · Substantial damage NTSB CHI71FET31Accident · Serious injuriesClosedFleet 16B · Osceola, INJun 26, 1971 · N39601 · Substantial damage NTSB CHI72DEA05Accident · No injuriesClosedBellanca 14-193 · Evansville, INJun 25, 1971 · N8853R · Substantial damage NTSB CHI71IC092Incident · No injuriesClosedDouglas DC-9 · Indianapolis, INJun 23, 1971 · N937F · Minor damage NTSB CHI71FEA39Accident · No injuriesClosedBensen B8-M · Delphi, INJun 23, 1971 · N6661 · Destroyed NTSB CHI71FET30Accident · No injuriesClosedCessna 177 · South Bend, INJun 21, 1971 · N30100 · Substantial damage NTSB CHI71AC091Accident · 2 fatalClosedPiper PA-30 · Fort Wayne, INJun 19, 1971 · XB-RIG · Destroyed NTSB CHI71AC087Accident · 2 fatalClosedChampion 7ECA · Poseyville, INJun 10, 1971 · N11097 · Destroyed NTSB CHI71DET29Accident · No injuriesClosedPiper PA-24 · Michigan City, INJun 6, 1971 · N6799J · Substantial damage NTSB CHI71AC086Accident · 2 fatalClosedCessna 182 · Lafayette, INJun 6, 1971 · N2127G · Destroyed NTSB CHI71FET28Accident · No injuriesClosedBeech 23 · Wolcottville, INJun 3, 1971 · N2325L · Substantial damage NTSB CHI71DEA38Accident · No injuriesClosedPiper PA-20 · Seymour, INMay 30, 1971 · N7430K · Substantial damage NTSB CHI71FEA37Accident · No injuriesClosedPiper PA-28 · Muncie, INMay 22, 1971 · N1692T · Substantial damage NTSB CHI71FEA36Accident · No injuriesClosedCessna 182 · Muncie, INMay 8, 1971 · N4090D · Substantial damage NTSB CHI71AC082Accident · 2 fatalClosedBeech C35 · Cloverland, INMay 7, 1971 · N606D · Destroyed NTSB CHI71DET26Accident · No injuriesClosedPiper PA-28 · Knox, INMay 3, 1971 · N5958U · Substantial damage NTSB CHI71FEA35Accident · Minor injuriesClosedChampion 402 · Greencastle, INApr 27, 1971 · N9963Y · Substantial damage NTSB CHI71AC080Accident · 1 fatalClosedBeech V35 · Elwood, INApr 27, 1971 · N2760T · Destroyed NTSB CHI71FET23Accident · No injuriesClosedPiper PA-25 · Roling Prarie, INApr 18, 1971 · N7418Z · Substantial damage