Final NTSB investigations, 2023

20 cases where the sequence of events included Birdstrike.

Cases per year

20082026
Final NTSB investigations, 2023 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\") = 2023
    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 DCA24LA330IncidentClass 2 · LimitedFinal reportBoeing 737-8 · Kenner, LAA partial loss of engine power due to bird ingestion in the No. 1 (left) engine, which resulted in the activation of the load reduction device to prevent vibration. The load reduction device activation resulted in smoke and fumes entering the cockpit.Dec 20, 2023 · N8830Q · Minor damageNTSB DCA24LA051Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737 · St. Louis, MOA bird strike during climbout.Dec 19, 2023 · N8514F · Substantial damageNTSB ERA24LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Newport News, VAAn inflight collision with a bird during initial climb.Dec 11, 2023 · N733QJ · Substantial damageNTSB WPR24LA049Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Watsonville, CAAn in-flight collision with a bird while in the initial climb.Nov 29, 2023 · N6212F · Substantial damageNTSB ERA24LA061Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Manassas, VAAn in-flight collision with a bird during initial climb.Nov 29, 2023 · N999VC · Substantial damageNTSB CEN24LA054Accident · No injuriesClass 4 · LimitedFinal reportCessna 560XL · Council Bluffs, IAAn in-flight collision with a bird during decent.Nov 26, 2023 · N475CW · Substantial damageNTSB CEN24LA053Accident · Minor injuriesClass 4 · LimitedFinal reportAirbus Helicopters Deutschland EC135T3 · Dodge Center, MNAn in-flight collision with a flock of birds.Nov 22, 2023 · N423NM · Substantial damageNTSB CEN24LA035Accident · No injuriesClass 4 · LimitedFinal reportGrassman Timothy B RV-14A · Houston, TXThe bird strike to the airplane’s vertical stabilizer during an approach for landing.Nov 3, 2023 · N5875G · Substantial damageNTSB CEN24LA017Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · Mitchell, INThe inflight collision with a bird while in cruise flight.Oct 17, 2023 · N490AE · Substantial damageNTSB CEN24LA025Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Riesel, TXAn in-flight collision with a bird.Oct 6, 2023 · N2444H · Substantial damageNTSB CEN23LA394Accident · Minor injuriesClass 4 · LimitedFinal reportTextron 172S · Englewood, COAn in-flight collision with multiple geese during initial climb.Sep 2, 2023 · N20818 · Substantial damageNTSB CEN23LA387Accident · No injuriesClass 4 · LimitedFinal reportBeech 200 · Henderson, KYAn in-flight collision with a bird shortly after takeoff.Aug 30, 2023 · N313CT · Substantial damageNTSB CEN23LA384Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · West Lafayette, INAn in-flight collision with a bird during initial climb.Aug 26, 2023 · N767PA · Substantial damageNTSB CEN23LA379Accident · No injuriesClass 4 · LimitedFinal reportBeech S35 · Houston, TXAn in-flight collision with a bird.Aug 16, 2023 · N5874J · Substantial damageNTSB ERA23LA305Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Gray, GAAn in-flight collision with a bird.Jul 11, 2023 · N271MG · Substantial damageNTSB ERA23LA303Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-201 · Macon, GAAn inflight collision with a bird.Jun 24, 2023 · N285MG · Substantial damageNTSB ERA23LA257Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 402 · Charlotte Amalie, CBAn in-flight collision with a bird while entering the traffic pattern.Jun 4, 2023 · N7037E · Minor damageNTSB CEN23LA203Accident · No injuriesClass 4 · LimitedFinal reportNanchang CJ6 · Windsor, COAn inflight collision with a bird while on initial climb.May 25, 2023 · N443LM · Substantial damageNTSB CEN23LA207Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-5 · Fort Worth, TXAn in-flight collision with a bird.May 23, 2023 · N1972G · Substantial damageNTSB CEN23LA131Accident · No injuriesClass 4 · LimitedFinal reportBeech E-55 · Tomball, TXAn inflight collision with a bird.Mar 6, 2023 · N101BM · Substantial damage