Final NTSB investigations, 2025

10 cases where the sequence of events included Birdstrike.

Cases per year

20082026
Final NTSB investigations, 2025 per year, 2008–2026: 219 cases
200810
200914
201013
20114
20127
201315
20149
20156
201610
201716
201813
201916
20203
202113
202213
202320
202418
202510
20269

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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '901' 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 ERA26LA082Accident · No injuriesClass 4 · LimitedFinal reportPiper PA44 · Pembroke Pines, FLAn in-flight collision with a bird while on approach to the destination airport.Dec 21, 2025 · N156WM · Substantial damageNTSB ERA26LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Lynchburg, VAAn in-flight collision with a bird.Nov 10, 2025 · N708LU · Substantial damageNTSB WPR26LA015Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Lathrop, CAAn inflight collision with a bird.Oct 4, 2025 · N103VK · Substantial damageNTSB ERA25LA377Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Okeechobee, FLCollision with a bird during cruise flight.Sep 27, 2025 · N8586A · Substantial damageNTSB ERA25LA360Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Linden, NJAn in-flight collision with a bird while on approach.Sep 20, 2025 · N5914V · Substantial damageNTSB CEN25LA362Accident · No injuriesClass 4 · LimitedFinal reportCessna 414 · New Braunfels, TXA in-flight collision with a bird during the descent for landing.Sep 3, 2025 · N39HC · Substantial damageNTSB CEN25LA180Accident · No injuriesClass 4 · LimitedFinal reportExcalibur Excalibur · Mountain View Airport, MOAn in-flight collision with a bird while enroute.May 18, 2025 · N4831A · Substantial damageNTSB WPR25LA113Accident · Minor injuriesClass 4 · LimitedFinal reportBeech E-55 · Van Nuys, CAAn in-flight collision with a bird during an approach to land.Mar 16, 2025 · N994WY · Substantial damageNTSB WPR25LA086Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Ramona, CAAn in-flight collision with a bird in the airport traffic pattern.Feb 2, 2025 · N5268K · Substantial damageNTSB CEN25LA070Accident · No injuriesClass 4 · LimitedFinal reportBombardier CL-600-2B19 · Stringtown, MSBird strike.Jan 3, 2025 · N438SW · Substantial damage