Ongoing NTSB investigations, IN
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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.
Cases per year
| 2025 | 7 |
|---|---|
| 2026 | 6 |
Where
Open the mapLatest cases
Query with SQL
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'
AND c.\"completionStatus\" = 'Ongoing'
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' AND c."completionStatus" = 'Ongoing' 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 CEN27LA021Accident · 1 fatalClass 3 · LimitedInvestigation openPiper J3C-65 · Boonville, INNTSB CEN27LA010Accident · No injuriesClass 4 · LimitedInvestigation openMooney M20F · Anderson, INNTSB CEN27LA002Accident · Minor injuriesClass 4 · LimitedInvestigation openPost Thorp T-18 · Brazil, INNTSB CEN26LA333Accident · No injuriesClass 3 · LimitedPreliminary reportFairchild 24H · Indianapolis, INOn September 26, 2026, about 1430 central daylight time, a Fairchild 24H, N16902, was substantially damaged when it was involved in an accident near Indianapolis, Indiana. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code…NTSB CEN26LA322Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172M · Hanover, INOn September 16, 2026, about 1905 eastern daylight time, a Cessna 172M airplane, N9909Q, was substantially damaged when it was involved in an accident near Hanover, Indiana. The pilot and passenger sustained minor injuries. The airplane was operated as a…NTSB ANC26LA090Accident · No injuriesClass 4 · LimitedInvestigation openRepublic RC-3 · Evansville, INNTSB CEN26FA034Accident · 1 fatalClass 3 · FieldPreliminary reportFunk B85C · Anderson, INOn November 4, 2025, about 12:45 eastern standard time, a Funk B85C airplane, N24157 was destroyed when it was involved in an accident near Anderson, Indiana. The pilot was fatally injured. The airplane was operated under the provisions of Title 14 Code of…NTSB CEN26LA008Accident · Serious injuriesClass 3 · LimitedPreliminary reportLancair 320 · Huron, INOn October 4, 2025, about 2130 central daylight time, a Lancair 320 airplane, N431M, was destroyed when it was involved in an accident near Huron, Indiana. The pilot was seriously injured. The airplane was operated under Title 14 Code of Federal Regulations…NTSB CEN25LA379Accident · Serious injuriesClass 3 · LimitedPreliminary reportPegasus Quantum 15 · Bedford, INOn September 13, 2025, at 1625 eastern daylight time, a Pegasus Quantum 15 weight-shift controlled aircraft, N36TJ, sustained substantial damage when it was involved in an accident near Bedford, Indiana. The pilot received serious injuries. The airplane was…NTSB CEN25LA323Accident · No injuriesClass 3 · LimitedPreliminary reportGrumman American Avn. G-164B · Fowler, INOn August 15, 2025, about 1910 eastern daylight time, a Grumman American Avn. Corp. G-164-B airplane, N7015N, was substantially damaged when it was involved in an accident near Fowler, Indiana. The pilot was not injured. The airplane was operated under Title…NTSB CEN25FA296Accident · 1 fatalClass 3 · FieldPreliminary reportHelms Richard Lancair IVP · Greenwood, INOn July 30, 2025, at 1046 eastern daylight time, a Lancair IVP airplane, N49BX, was destroyed when it was involved in an accident near Greenwood, Indiana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB CEN25LA181Accident · Serious injuriesClass 3 · LimitedPreliminary reportGrumman TBM-3 · Terre Haute, INOn May 15, 2025, about 1339 eastern daylight time, a Grumman TBM-3 airplane, N420GP, was substantially damaged when it was involved in an accident near Terre Haute, Indiana. The pilot sustained serious injuries, and the pilot-rated passenger sustained minor…NTSB CEN25LA175Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA 46-350P · Greenwood, INOn May 11, 2025, about 1231 central daylight time, a Piper PA46-350P, N253MA, sustained substantial damage when it was involved in an accident near Greenwood, Indiana. The pilot and passenger received serious injuries. The airplane was operated as a Title 14…