Skip to content

Ongoing NTSB investigations, IA

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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20242026

Where

Latest cases

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" = 'IA' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Ongoing' 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\" = 'IA' 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" = 'IA' 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 CEN27LA027Accident · No injuriesLimited investigationInvestigation openRudolph Gary Legacy · Belle Plaine, IAOct 22, 2026 · N84V NTSB CEN27LA019Accident · Minor injuriesClass 3 · LimitedInvestigation openPiper PA-28-235 · Cedar Rapids, IAOct 18, 2026 · N8759W NTSB CEN26LA309Accident · No injuriesClass 4 · LimitedInvestigation openMooney M20E · West Branch, IASep 2, 2026 · N55GA · Substantial damage NTSB WPR26LA317Accident · No injuriesClass 4 · LimitedInvestigation openBoeing A75N1(PT17) · Cedar Rapids, IAAug 25, 2026 · N48188 · Substantial damage NTSB ANC26LA082Accident · Minor injuriesClass 4 · LimitedInvestigation openRobinson Helicopter R44 · Macedonia, IAAug 9, 2026 · N197HL · Substantial damage NTSB CEN26LA276Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 II · Bennett, IAOn August 2, 2026, about 1318 central daylight time, a Robinson Helicopter Company R44 II helicopter, N26KL, was substantially damaged when it was involved in an accident near Bennett, Iowa. The pilot was not injured. The helicopter was operated as a Title 14…Aug 2, 2026 · N26KL · Substantial damage NTSB CEN26LA271Accident · No injuriesClass 3 · LimitedPreliminary reportBeech V35 · Carroll, IAOn July 24, 2026, about 1550 central daylight time, a Beech V35 airplane, N3707Q, was substantially damaged when it was involved in an accident near Carroll, Iowa. The pilot was not injured. The flight was operated under the provisions of Title 14 Code of…Jul 24, 2026 · N3707Q · Substantial damage NTSB CEN26FA267Accident · 1 fatalClass 3 · FieldPreliminary reportZenith Zodiak 601 HDS · Sioux City, IAOn July 24, 2026, about 1422 central daylight time, a Zenith Zodiac 601HDS experimental airplane, N27601, was destroyed when it was involved in an accident near Sioux City, Iowa. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…Jul 24, 2026 · N27601 · Destroyed NTSB CEN26LA259Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 · Adair, IAOn July 18, 2026, about 1440 central daylight time, a Robinson Helicopter Company R44, N484AT, was substantially damaged when it was involved in an accident near Adair, Iowa. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal…Jul 18, 2026 · N484AT · Substantial damage NTSB CEN26LA100Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA 46-350P · Sioux City, IAOn January 24, 2026, about 0712 central daylight time, a Piper PA-46-350P airplane, N91MK, was substantially damaged when it was involved in an accident near Sioux City, Iowa. The pilot and passenger were uninjured. The airplane was operated as a Title 14…Jan 24, 2026 · N91MK · Substantial damage NTSB CEN26LA045Accident · No injuriesClass 3 · LimitedPreliminary reportCessna TU206F · Muscatine, IAOn November 12, 2025, about 14:10 central standard time, a Cessna TU206F, N37EW, and a Hawker Beechcraft Corp B300, N545KA, were substantially damaged when they were involved in an accident at Muscatine Regional Airport (MUT), Muscatine, Iowa. The pilot and…Nov 12, 2025 · N37EW · 2 aircraft · Substantial damage NTSB ANC26LA020Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 182Q · Mapleton, IAOn October 29, 2025, at about 1200 Central daylight time, a Cessna 182Q, N735ZD, was substantially damaged when it was involved in an accident near Mapleton, Iowa. The pilot and three passengers were not injured. The airplane was operated as a Title 14 Code…Oct 29, 2025 · N735ZD · Substantial damage NTSB CEN26LA009Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 182RG · Cottonville, IAOn October 3, 2025, about 1720 central daylight time, a Cessna 182RG airplane, N4609S, was substantially damaged when it was involved in an accident near Cottonville, Iowa. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…Oct 3, 2025 · N4609S · Substantial damage NTSB ANC25FA086Accident · 1 fatalClass 3 · FieldPreliminary reportNorth American T-28B · Monticello, IAOn August 11, 2025, about 1505 Central daylight time, a North American T-28B airplane, N28XT, was substantially damaged when it was involved in an accident near Monticello, Iowa. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…Aug 11, 2025 · N28XT · Substantial damage NTSB CEN25LA297Accident · Serious injuriesClass 3 · LimitedPreliminary reportAyres S2R · Akron, IAOn July 28, 2025, about 1537 central daylight time, an Ayres Corporation S2R-T34 airplane, N524SL, sustained substantial damage when it was involved in an accident near Akron, Iowa. The pilot sustained serious injuries. The airplane was operated as a Title 14…Jul 28, 2025 · N524SL · Substantial damage NTSB CEN25LA277Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R66 · Maynard, IAOn July 22, 2025, about 1400 central daylight time, a Robinson Helicopter Company R66 helicopter, N88911, was substantially damaged when it was involved in an accident near Maynard, Iowa. The pilot was uninjured. The helicopter was operated under Title 14…Jul 22, 2025 · N88911 · Substantial damage NTSB CEN24FA287Accident · 1 fatalClass 3 · FieldPreliminary reportBell 206 · Nashua, IAOn July 29, 2024 about 1330 central standard time, a Bell 206-B3 Helicopter, N94XA, was destroyed when it was involved in an accident near Nashua, Iowa. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal Regulations Part…Jul 29, 2024 · N94XA · Substantial damage