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 CHI77FEX41Accident · No injuriesClosedGrumman G-164A · Shelbyville, INJul 13, 1977 · N4862 · Substantial damage NTSB CHI77DEX40Accident · No injuriesClosedStearman PT-17 · Converse, INJul 13, 1977 · N52014 · Substantial damage NTSB CHI77FEX38Accident · No injuriesClosedBeech S35 · Indianapolis, INJul 12, 1977 · N2015W · Substantial damage NTSB CHI77FET22Accident · 1 fatalClosedPiper PA-28 · Huntington, INJul 8, 1977 · N8091N · Destroyed NTSB CHI77FEX36Accident · Serious injuriesClosedCessna 172M · Spencer, INJul 4, 1977 · N19798 · Destroyed NTSB CHI77DEX35Accident · No injuriesClosedBellanca 7ECA · Lebanon, INJul 1, 1977 · N8337V · Substantial damage NTSB CHI77FET21Accident · No injuriesClosedGrumman G-164B · Hanna, INJun 29, 1977 · N6648Q · Substantial damage NTSB CHI77DET19Accident · No injuriesClosedGrumman G-164A · Hebron, INJun 24, 1977 · N930X · Substantial damage NTSB CHI77FEX34Accident · No injuriesClosedCessna 310Q · W.Lafayette, INJun 16, 1977 · N69584 · Minor damage NTSB CHI77DEX33Accident · No injuriesClosedCessna 150 · Logan, INJun 14, 1977 · N3502J · Substantial damage NTSB CHI77FET18Accident · No injuriesClosedCessna 120 · Logansport, INJun 11, 1977 · N73066 · Substantial damage NTSB CHI77FET17Accident · No injuriesClosedCessna 210 · Fremont, INJun 8, 1977 · N5853F · Substantial damage NTSB CHI77DET16Accident · Minor injuriesClosedCessna 172H · Valparaiso, INJun 5, 1977 · N8262L · Substantial damage NTSB CHI77DET15Accident · No injuriesClosedPiper PA-16 · Roselawn, INJun 4, 1977 · N5631H · Substantial damage NTSB CHI77FEX32Accident · No injuriesClosedPiper PA-28 · Jeffersonville, INJun 1, 1977 · N3913T · Substantial damage NTSB CHI77DEX31Accident · No injuriesClosedCessna 172 · Boonville, INMay 29, 1977 · N9688V · Substantial damage NTSB CHI77FEX30Accident · No injuriesClosedAero Comdr 680FL · Indianapolis, INMay 28, 1977 · N277R · Substantial damage NTSB CHI77FEX29Accident · No injuriesClosedCessna 150M · Cedar Grove, INMay 22, 1977 · N6034K · Substantial damage NTSB CHI77FEX28Accident · No injuriesClosedPiper PA-25 · Westfield, INMay 19, 1977 · N7547Z · Substantial damage NTSB CHI77DET14Accident · No injuriesClosedLet-Np-K L-13 · Kendallville, INMay 15, 1977 · N2973 · Substantial damage NTSB CHI77FEX27Accident · No injuriesClosedGlobe GC-1B · Charlestown, INMay 14, 1977 · N3284K · Substantial damage NTSB CHI77FEX26Accident · No injuriesClosedJodel D11 · Tell City, INMay 14, 1977 · N4628S · Substantial damage NTSB CHI77FEX25Accident · Minor injuriesClosedCessna 172 · Indianapolis, INMay 8, 1977 · N8685B · Substantial damage NTSB CHI77FEX24Accident · Minor injuriesClosedCessna 150H · Sheridan, INMay 8, 1977 · N23396 · Substantial damage NTSB CHI77FEX23Accident · No injuriesClosedBell MK5A · Russiaville, INMay 6, 1977 · N9010T · Destroyed NTSB CHI77DEX22Accident · No injuriesClosedCessna 180H · Lafayette, INMay 1, 1977 · N9092M · Substantial damage NTSB CHI77DEX21Accident · No injuriesClosedPiper PA-28 · Lafayette, INApr 30, 1977 · N499TG · Substantial damage NTSB CHI77FEX20Accident · Serious injuriesClosedPiper PA-25 · Ramsey, INApr 29, 1977 · N7060Z · Destroyed NTSB CHI77FEE18Accident · Minor injuriesClosedHughes 269B · Indianapolis, INApr 16, 1977 · N9482F · Substantial damage NTSB CHI77FET13Accident · Serious injuriesClosedStarduster SA200 · Rensselaer, INApr 3, 1977 · N6BH · Destroyed NTSB CHI77DET12Accident · No injuriesClosedCessna 150 · Silver Lake, INApr 3, 1977 · N8807U · Substantial damage NTSB CHI77FEX19Accident · No injuriesClosedCessna 182 · Middletown, INMar 30, 1977 · N6454F · Substantial damage NTSB CHI77FET11Accident · Minor injuriesClosedBell 47G2 · Kentland, INMar 25, 1977 · N90836 · Substantial damage NTSB CHI77FEX17Accident · Minor injuriesClosedCessna 150 · Helmsburg, INMar 19, 1977 · N6TA · Substantial damage NTSB CHI77FEX16Accident · No injuriesClosedEnstrom F28A · Mitchell, INMar 19, 1977 · N9595 · Substantial damage NTSB CHI77DEX15Accident · No injuriesClosedPiper PA-28 · Monon, INMar 11, 1977 · N6295J · Substantial damage NTSB CHI77FA035Accident · 2 fatalClosedPiper PA-28 · Rochester, INMar 10, 1977 · N44798 · Destroyed NTSB CHI77FET20Accident · Minor injuriesClosedCessna 172 · Plymouth, INMar 9, 1977 · N5159F · Destroyed NTSB CHI77FA032Accident · Minor injuriesClosedEnstrom 280C · Valparaiso, INFeb 25, 1977 · N594H · Substantial damage NTSB CHI77FET09Accident · No injuriesClosedCessna 172M · Kendallville, INFeb 19, 1977 · N12989 · Substantial damage NTSB CHI77FEX14Accident · No injuriesClosedCessna 140 · Crawfordsville, INFeb 18, 1977 · N89420 · Substantial damage NTSB CHI77FEX13Accident · Minor injuriesClosedPiper PA-28R · Portland, INFeb 13, 1977 · N7670J · Substantial damage NTSB CHI77FEX11Accident · No injuriesClosedCessna 172M · Elwood, INFeb 5, 1977 · N1437U · Substantial damage NTSB CHI77DEX12Accident · No injuriesClosedPiper PA-28 · Indianapolis, INJan 31, 1977 · N6939W · Substantial damage NTSB CHI77FEX09Accident · Minor injuriesClosedCessna 182N · Tell City, INJan 29, 1977 · N92187 · Substantial damage NTSB CHI77DEX10Accident · No injuriesClosedPiper PA-34 · Terre Haute, INJan 24, 1977 · N4522T · Substantial damage NTSB CHI77FEX08Accident · No injuriesClosedCessna 182 · Mt. Vernon, INJan 19, 1977 · N9643G · Substantial damage NTSB CHI77FEX07Accident · No injuriesClosedCessna 310Q · Columbus, INJan 9, 1977 · N1250G · Substantial damage NTSB CHI77FA023Accident · 1 fatalClosedBeech K35 · Delaware Twp, INJan 9, 1977 · N6098E · Destroyed NTSB CHI77FET07Accident · No injuriesClosedPiper PA-28 · Wabash, INJan 7, 1977 · N55880 · Substantial damage