NTSB investigations, 2025, AL

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

Cases per year

20082026
NTSB investigations, 2025, 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\") = 2025
    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 ERA26LA085Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Luft UND Raumfah G103 Twin Astir Trai · Brownsboro, ALThe flight instructor’s failure to properly lock the rear canopy prior to flight, which led to the canopy opening during aerotow at low altitude, and a subsequent off-airport landing in a corn field.Nov 26, 2025 · N103T · Substantial damageNTSB ERA26LA001Accident · Minor injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Talladega, ALOn October 2, 2025, at 1126 central daylight time, a Cirrus SR22, N812SE, was substantially damaged when it was involved in an accident near Talladega, Alabama. The commercial pilot sustained minor injuries, and the two passengers were not injured. The…Oct 2, 2025 · N812SE · Substantial damageNTSB ERA25LA313Accident · Serious injuriesClass 3 · LimitedPreliminary reportRaytheon A36 · Gulf Shores, ALOn August 24, 2025, about 1500 eastern daylight time, a Raytheon Aircraft Company A36, N855DC, was substantially damaged when it was involved in an accident near Gulf Shores, Alabama. The pilot and passenger were seriously injured. The airplane was operated…Aug 24, 2025 · N855DC · Substantial damageNTSB ERA25LA225Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 150J · Elberta, ALOn June 1, 2025, at about 1200 central daylight time, a Cessna 150J, N150FJ, was substantially damaged when it was involved in an accident near Elberta, Alabama. The pilot and the pilot- rated passenger were not injured. The airplane was operated under as a…Jun 1, 2025 · N150FJ · Substantial damage