NTSB investigations, 2026, AL

6 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2026, AL per year, 2008–2026: 161 cases
200813
20098
20106
20118
201213
20137
201415
201514
20163
20178
201811
201910
20208
20216
20227
20239
20245
20254
20266

Latest 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 year(c.\"eventDate\") = 2026
    AND c.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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.

NTSB ERA26LA348Accident · No injuriesClass 4 · LimitedFinal reportHopwood Joseph R Zodiac · Stockton, ALA partial loss of engine power due to a missing exhaust clamp bolt and subsequent oil loss due to a damaged engine oil return line, which resulted in the pilot’s decision to perform an off-airport landing.Sep 20, 2026 · N601LL · Substantial damageNTSB ERA26FA338Accident · 1 fatalClass 3 · FieldPreliminary reportReed Julian Estill RV-4 · Albertville, ALOn September 15, 2026, about 0620 central daylight time, an experimental amateur-built RV-4, N469TW, was substantially damaged when it was involved in an accident near Albertville, Alabama. The pilot was fatally injured. The airplane was operated as a Title…Sep 15, 2026 · N469TW · Substantial damageNTSB ERA26LA190Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Enterprise, ALThe pilot’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel starvation and subsequent forced landing into trees.Apr 26, 2026 · N8432Y · Substantial damageNTSB ERA26LA185Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-160 · Lanett, ALThe pilot’s failure to maintain control of the airplane during the landing, which resulted in a runway excursion and collision with taxiway sign.Apr 22, 2026 · N5958W · Substantial damageNTSB ERA26LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Bessemer, ALThe pilot’s loss of directional control during the landing roll.Mar 27, 2026 · N3184B · Substantial damageNTSB ERA26LA101Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170 · Summerdale, ALThe pilot’s decision to abort the takeoff with insufficient runway remaining, which resulted in a runway overrun and impact with a fence post.Jan 29, 2026 · N4178V · Substantial damage