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 CHI73AC073Accident · 2 fatalClosedCessna 150 · Rockville, INFeb 24, 1973 · N6474S · Destroyed NTSB CHI73FEE27Accident · No injuriesClosedCessna 182 · Frankfort, INFeb 5, 1973 · N9135G · Substantial damage NTSB CHI73AC069Accident · 1 fatalClosedMooney M20A · Henryville, INFeb 5, 1973 · N6081X · Destroyed NTSB CHI73FEA26Accident · Minor injuriesClosedPiper PA-32 · Connersville, INFeb 3, 1973 · N5546J · Substantial damage NTSB CHI73FEA24Accident · Serious injuriesClosedBeech A45 · Muncie, INJan 29, 1973 · N34WW · Destroyed NTSB CHI73FEA22Accident · Minor injuriesClosedPiper J3C-65 · Terre Haute, INJan 25, 1973 · N92343 · Destroyed NTSB CHI73FEA25Accident · No injuriesClosedMitsubishi MU-2B · Noblesville, INJan 12, 1973 · N555C · Substantial damage NTSB CHI73FEA23Accident · Minor injuriesClosedCessna 210G · Chrisney, INDec 28, 1972 · N5864F · Substantial damage NTSB CHI73AC060Accident · 2 fatalClosedPiper PA-28 · Paragon, INDec 25, 1972 · N8885N · Destroyed NTSB CHI73FEA21Accident · Serious injuriesClosedBellanca 17-30A · Marion, INDec 22, 1972 · N8243R · Destroyed NTSB CHI73FET12Accident · No injuriesClosedBeech 35-B33 · South Bend, INDec 4, 1972 · N8948M · Substantial damage NTSB CHI73DET11Incident · Minor injuriesClosedPiper PA-28 · Culver, INDec 3, 1972 · N673FL · Minor damage NTSB CHI73DEA29Accident · No injuriesClosedCessna 336 · Greenwood, INNov 16, 1972 · N1702Z · Substantial damage NTSB CHI73ACO48Accident · No injuriesClosedCessna 310A · Lafayette, INNov 16, 1972 · N347P · 2 aircraft · Substantial damage NTSB CHI73FET10Accident · Minor injuriesClosedPiper PA-28 · Ft Wayne, INNov 6, 1972 · N4683T · 2 aircraft · Substantial damage NTSB CHI73DEA20Accident · Serious injuriesClosedPiper PA-32 · Muncie, INNov 5, 1972 · N5588J · Substantial damage NTSB CHI73FET09Accident · No injuriesClosedHughes 269A · Gary, INNov 1, 1972 · N8790F · Substantial damage NTSB CHI73DEA19Accident · No injuriesClosedPiper PA-30 · Franklin, INOct 27, 1972 · N8461Y · Substantial damage NTSB CHI73FET07Accident · Serious injuriesClosedCessna 172G · Howe, INOct 15, 1972 · N4490L · Substantial damage NTSB CHI73DEA18Accident · No injuriesClosedCessna 150 · Greencastle, INOct 14, 1972 · N60602 · Substantial damage NTSB CHI73AC038Accident · 3 fatalClosedBeech 95-B55 · Danville, INOct 8, 1972 · N9285Q · Destroyed NTSB CHI73DEA16Accident · No injuriesClosedPiper PA-22 · New Point, INSep 30, 1972 · N6085D · Substantial damage NTSB CHI73DEA15Accident · No injuriesClosedErco 415-C · Greentown, INSep 21, 1972 · N93498 · Substantial damage NTSB CHI73FEA17Accident · No injuriesClosedCessna 150G · Jeffersonvile, INSep 19, 1972 · N4070J · Substantial damage NTSB CHI73FEA12Accident · Minor injuriesClosedCessna A188 · Ellettsville, INSep 13, 1972 · N21718 · Destroyed NTSB CHI73DEA13Accident · No injuriesClosedCessna 140 · Evansville, INSep 10, 1972 · N2174V · Substantial damage NTSB CHI73DEA11Accident · Minor injuriesClosedPiper PA-28 · Mccordsville, INSep 10, 1972 · N1225T · Substantial damage NTSB CHI73FEA14Accident · No injuriesClosedCessna 182 · Tipton, INSep 9, 1972 · N6284A · Substantial damage NTSB CHI73FEA09Accident · Minor injuriesClosedPiper PA-28 · Danville, INAug 30, 1972 · N6541J · Destroyed NTSB CHI73DEA08Accident · No injuriesClosedPiper PA-28 · W.Lafayette, INAug 25, 1972 · N553PA · Substantial damage NTSB CHI73AC027Accident · 1 fatalClosedCessna 150H · Grovertown, INAug 25, 1972 · N22402 · Destroyed NTSB CHI73AC025Accident · 1 fatalClosedCessna 172 · Martinsville, INAug 24, 1972 · N5745A · Destroyed NTSB CHI73FEA06Accident · No injuriesClosedPiper PA-32 · Kokomo, INAug 23, 1972 · N3209W · Substantial damage NTSB CHI73FEA07Accident · Minor injuriesClosedAmer Avco AA1 · W.Lafayette, INAug 22, 1972 · N6115L · Substantial damage NTSB CHI73FEA05Accident · Serious injuriesClosedRyan ST-3KR · Shelbyville, INAug 18, 1972 · N46706 · Minor damage NTSB CHI73AC018Accident · 5 fatalClosedCessna 182M · Brownsburg, INAug 15, 1972 · N92004 · Destroyed NTSB CHI73AC013Accident · 1 fatalClosedChampion 7ECA · Mccordsville, INAug 7, 1972 · N1623G · Destroyed NTSB CHI73AC012Accident · 3 fatalClosedPiper PA-24 · Nappanee, INAug 7, 1972 · N6378P · Destroyed NTSB CHI73DEA10Accident · No injuriesClosedAmer Avco AA-5 · Bedford, INAug 5, 1972 · N5839L · Substantial damage NTSB CHI72FEA04Accident · Minor injuriesClosedMooney M-20C · Watson, INAug 2, 1972 · N9289V · Substantial damage NTSB CHI73DET03Accident · No injuriesClosedBeech 23 · Crown Point, INJul 25, 1972 · N2324L · Substantial damage NTSB CHI73FEE09Accident · No injuriesClosedBellanca 17-30 · Gary, INJul 24, 1972 · N7394V · Substantial damage NTSB CHI73FEA03Accident · Minor injuriesClosedPiper PA-24 · Seymour, INJul 24, 1972 · N5156P · Destroyed NTSB CHI73FEA02Accident · No injuriesClosedPiper PA-28 · Ramsey, INJul 15, 1972 · N6361J · Substantial damage NTSB CHI73AC004Accident · 4 fatalClosedPiper PA-24 · Kewanna, INJul 15, 1972 · N5491P · Destroyed NTSB CHI73FET01Accident · No injuriesClosedCessna 150K · Valparaiso, INJul 11, 1972 · N5979G · Substantial damage NTSB CHI73AC003Accident · 1 fatalClosedPiper PA-23 · Knox, INJul 7, 1972 · N4241P · Destroyed NTSB CHI73DEA01Accident · No injuriesClosedCessna 182 · Indianapolis, INJul 3, 1972 · N8416S · Substantial damage NTSB CHI73FET02Accident · No injuriesClosedCessna 150J · South Bend, INJul 2, 1972 · N1014M · Substantial damage NTSB CHI72DEA49Accident · Minor injuriesClosedChampion 7ECA · Connersville, INJun 30, 1972 · N9042L · Substantial damage