Fatal NTSB investigations

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

Cases, newest first

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 c.\"highestInjuryLevel\" = 'Fatal'
    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 CEN25FA273Accident · 1 fatalClass 3 · FieldPreliminary reportCessna T188C · Oregon, ILOn July 22, 2025, about 0930 central daylight time, a Cessna T188C, N2802J, was substantially damaged when it was involved in an accident near Oregon, Illinois. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…Jul 22, 2025 · N2802J · Substantial damageNTSB GAA25WA205Accident · 4 fatalClass 5 · ForeignAvions Robin DR400 · Wald im Pinzgau, AustriaJul 5, 2025 · D-EHGD · DestroyedNTSB ERA25FA246Accident · 6 fatalClass 3 · FieldPreliminary reportCessna 441 · Warren, OHOn June 29, 2025, about 0654 eastern daylight time, a Cessna 441, N441LS, was destroyed when it was involved in an accident near Warren, Ohio. The airline transport pilot and five passengers were fatally injured. The airplane was operated as a Title 14 Code…Jun 29, 2025 · N441LS · Substantial damageNTSB WPR25FA190Accident · 1 fatalClass 3 · FieldPreliminary reportMD Helicopters 369E · Meeker, COOn June 25, 2025, about 1001 mountain daylight time, an MD Helicopters 369E, N411WJ, was substantially damaged when it was involved in an accident near Meeker, Colorado. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…Jun 25, 2025 · N411WJ · Substantial damageNTSB ERA25FA239Accident · 1 fatalClass 3 · FieldPreliminary reportPiper J3C-65 · Dunlap, TNOn June 24, 2025, about 18:23 central daylight time, a Piper J3C-65, N28DR, was substantially damaged when it was involved in an accident near Dunlap, Tennessee. The commercial pilot was fatally injured and the passenger was seriously injured. The airplane…Jun 24, 2025 · N28DR · Substantial damageNTSB WPR25FA182Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Billings, MTOn June 19, 2025, at 1412 mountain daylight time, a Cessna 172K airplane, N79306, was destroyed when it was involved in an accident near Billings, Montana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…Jun 19, 2025 · N79306 · Substantial damageNTSB ERA25FA230Accident · 2 fatalClass 3 · FieldFinal reportMooney M20F · Beverly, MAThe pilot’s failure to maintain control of the airplane while maneuvering to return to the airport which resulted in an aerodynamic stall. Contributing to the accident was the improperly installed No. 2 cylinder bottom spark plug by maintenance personnel,…Jun 19, 2025 · N9573M · Substantial damageNTSB GAA25WA239Accident · 1 fatalClass 3 · ForeignCessna TU206 · Vereda El Canelón, ColombiaMay 31, 2025 · HK-1925 · DestroyedNTSB ERA25FA211Accident · 1 fatalClass 3 · FieldPreliminary reportZenith Stol CH701 · Geneva, OHOn May 25, 2025, about 1007 eastern daylight time, an experimental, amateur-built Zenith STOL CH701, N514JG, was substantially damaged when it was involved in an accident near Geneva, Ohio. The pilot was fatally injured and the pilot-rated passenger sustained…May 25, 2025 · N514JG · Substantial damageNTSB CEN25FA184Accident · 2 fatalClass 3 · FieldPreliminary reportRockwell Commander 114A · Hankamer, TXOn May 24, 2025, about 1658 central daylight time (CDT), a Rockwell Commander 114A airplane, N5903N, was destroyed when it was involved in an accident near Hankamer, Texas. The private pilot and passenger were fatally injured. The airplane was operated under…May 24, 2025 · N5903N · DestroyedNTSB WPR25FA156Accident · 1 fatalClass 3 · FieldPreliminary reportDB Aerocopter AK1-3 · Prineville, OROn May 17, 2025, about 1134 pacific daylight time, a DB Aerocopter Ltd., AK1-3, N163AK, sustained substantial damage when it was involved in an accident near Prineville, Oregon. The private pilot undergoing instruction was fatally injured, and the flight…May 17, 2025 · N163AK · Substantial damageNTSB CEN25FA178Accident · 2 fatalClass 3 · FieldPreliminary reportBeech 95-B55 (T42A) · Broomfield, COOn May 17, 2025, about 1003 mountain daylight time, a Beechcraft 95-B55, was destroyed when it was involved in an accident near Broomfield, Colorado. The pilot and pilot-rated passenger sustained fatal injuries. The flight was being operated as a Title 14…May 17, 2025 · N4321Z · DestroyedNTSB ERA25FA201Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32RT · Yulee, FLThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a stall/spin at an altitude too low for recovery. Contributing to the accident was the opening of the nose baggage door and subsequent distraction of the pilot…May 10, 2025 · N30689 · DestroyedNTSB WPR25FA153Accident · 1 fatalClass 3 · FieldPreliminary reportAmerican Champion 7GCBC · Big Creek, IDOn May 9, 2025, about 0900 mountain daylight time, an American Champion Aircraft 7GCBC, N342H, was substantially damaged when it was involved in an accident near Big Creek, Idaho. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…May 9, 2025 · N342H · Substantial damageNTSB ERA25FA187Accident · 3 fatalClass 3 · FieldPreliminary reportMooney M20TN · Sparta, TNOn April 26, 2025, about 1147 central daylight time, a Mooney M20TN, N242RE, was substantially damaged when it was involved in an accident near Sparta, Tennessee. The private pilot and two passengers were fatally injured. The airplane was operated as a Title…Apr 26, 2025 · N242RE · Substantial damageNTSB ERA25FA185Accident · 1 fatalClass 3 · FieldFinal reportMX Aircraft Tech PTY MXS · Hampton, VAA counterweight plug that loosened during the accident flight, jammed the elevator, and resulted in loss of control during landing.Apr 24, 2025 · N530RH · Substantial damageNTSB GAA25WA144Accident · 1 fatalClass 5 · ForeignCessna 188 · Sangkiang Village, Papua New GuineaApr 23, 2025 · VH-SOY · DestroyedNTSB ERA25FA179Accident · 4 fatalClass 3 · FieldPreliminary reportCessna 180 · Trilla, ILOn April 19, 2025, at 1016 central daylight time, a Cessna 180G, N4679U, was destroyed when it was involved in an accident near Trilla, Illinois. The private pilot and three passengers were fatally injured. The airplane was operated under Title 14 Code of…Apr 19, 2025 · N4679U · DestroyedNTSB CEN25FA157Accident · 3 fatalClass 3 · FieldPreliminary reportCessna 180 · Fremont, NEOn April 18, 2025, about 2011 central daylight time, a Cessna 180, N2908C, was substantially damaged when it was involved in an accident near Fremont, Nebraska. The pilot and two passengers were fatally injured. The flight was conducted as a Title 14 Code of…Apr 19, 2025 · N2908C · Substantial damageNTSB CEN25FA151Accident · 1 fatalClass 3 · FieldPreliminary reportAeronca 7AC · Cape Fair, MOOn April 10, 2025, at 0904 central daylight time, an Aeronca 7AC airplane, N83952, was substantially damaged when it was involved in an accident near Cape Fair, Missouri. The pilot received serious injuries, and the passenger was fatally injured. The airplane…Apr 10, 2025 · N83952 · Substantial damageNTSB GAA25WA139Accident · 1 fatalClass 5 · ForeignCessna 150m · Northhampton, AustraliaMar 21, 2025 · VH-WWU · DestroyedNTSB ERA25FA151Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · LaFayette, GAThe pilot’s exceedance of the airplane’s critical angle of attack while landing and the flight instructor’s inadequate remedial action, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.Mar 20, 2025 · N969SS · DestroyedNTSB WPR25FA114Accident · 1 fatalClass 3 · FieldPreliminary reportBell 206B II · Mountain Home Park, WAOn March 19, 2025, at 1228 Pacific daylight time, a Bell 206B II, N23SD, was substantially damaged when it impacted electrical cables and terrain near Mountain Home Park, Washington. The commercial pilot was fatally injured. The helicopter was operated as a…Mar 19, 2025 · N23SD · Substantial damageNTSB ERA25LA145Accident · 1 fatalClass 3 · LimitedPreliminary reportWild Sky Goat · Chester, CTOn March 14, 2025, about 1515 eastern daylight time, an experimental amateur-built Wild Sky Goat light-sport aircraft, N372WS, was substantially damaged when it was involved in an accident near Chester, Connecticut. The commercial pilot sustained fatal…Mar 14, 2025 · N372WS · Substantial damageNTSB GAA25WA116Accident · 1 fatalClass 5 · ForeignCessna 152 · Voi, KenyaMar 8, 2025 · 5Y-BYQ · DestroyedNTSB WPR25FA108Accident · 1 fatalClass 3 · FieldPreliminary reportCessna A150L · Renslow, WAOn March 4, 2025, at 1555 Pacific standard time, a Cessna A150L, N6167F, was destroyed when it was involved in an accident near Renslow, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…Mar 4, 2025 · N6167F · DestroyedNTSB CEN25FA106Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV7 · Matheson, COOn March 1, 2025, about 1215 mountain daylight time, a Vans RV7 experimental airplane, N902T, was destroyed when it was involved in an accident near Matheson, Colorado. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code of…Mar 1, 2025 · N902T · Substantial damageNTSB ERA25FA120Accident · 2 fatalClass 3 · FieldPreliminary reportRockwell 112 · Covington, GAOn February 15, 2025, about 2300, a Rockwell 112, N1423J, was destroyed when it was involved in an accident near Covington, Georgia. The private pilot and one passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…Feb 16, 2025 · N1423J · DestroyedNTSB ANC25MA018Accident · 10 fatalClass 1 · MajorFinal reportTextron 208B · Nome, AKThe National Transportation Safety Board determines that the probable cause of this accident was the pilot’s inadequate airspeed management due to workload and degraded situation awareness and his improper inputs leading up to and during the aerodynamic…Feb 6, 2025 · N321BA · DestroyedNTSB GAA25WA077Accident · 1 fatalClass 5 · ForeignRobinson R44 · Pacific Ocean, EcuadorFeb 1, 2025 · HC-CQY · Substantial damageNTSB GAA25WA098Accident · 3 fatalClass 5 · ForeignRobinson R44 · Cruzilia, BrazilJan 27, 2025 · PR-TIB · Substantial damageNTSB ERA25FA103Accident · 1 fatalClass 3 · FieldPreliminary reportBeech V35B · Charlottesville, VAOn January 25, 2025, about 1235 eastern standard time, a Beech V35B, N2UZ, was destroyed when it was involved in an accident near Charlottesville, Virginia. The airline transport pilot was fatally injured. The airplane was operated as a Title 14 Code of…Jan 25, 2025 · N2UZ · DestroyedNTSB GAA25WA080Accident · 1 fatalClass 5 · ForeignCessna 188 · Canarana, BrazilJan 23, 2025 · PR-AAN · Substantial damageNTSB GAA25WA064Accident · 3 fatalClass 4 · ForeignBell Textron Canada 407 · Paredones Commune, ChileJan 19, 2025 · N622LT · DestroyedNTSB GAA25WA057Accident · 1 fatalClass 5 · ForeignThrush S2R · Santa Ines, HondurasJan 13, 2025 · HR-AZD · DestroyedNTSB ERA25FA086Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 310 · Peebles, OHOn December 30, 2024, about 1515 eastern standard time, a Cessna 310D, N6979T, was substantially damaged when it was involved in an accident near Peebles, Ohio. The commercial pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…Dec 30, 2024 · N6979T · Substantial damageNTSB GAA25WA203Accident · 7 fatalClass 5 · ForeignCessna C207 · Nayarit, MexicoDec 22, 2024 · XB-MLO · DestroyedNTSB GAA25WA048Accident · 10 fatalClass 3 · ForeignPiper PA42 · Gramado, BrazilDec 22, 2024 · PR-NDN · DestroyedNTSB GAA25WA061Accident · 2 fatalClass 5 · ForeignCessna 310 · Manicore, BrazilDec 20, 2024 · PT-JCZ · DestroyedNTSB ERA25FA082Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Cintrona, PRMaintenance personnel’s inadequate inspection of the airplane, which resulted in inflight the failure of the right aileron carry through cable due to wear, reduced effectiveness of the airplane’s ailerons, and a subsequent loss of control.Dec 20, 2024 · N22088 · DestroyedNTSB ERA25FA080Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A36 · East Aurora, NYOn December 19, 2024, at 1122 eastern standard time, a Beech A36, N36WP, was destroyed when it was involved in an accident near East Aurora, New York. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…Dec 19, 2024 · N36WP · DestroyedNTSB GAA25WA059Accident · 1 fatalClass 4 · ForeignPiper PA25 · Nova Monte, BrazilDec 12, 2024 · PR-BMJ · Substantial damageNTSB ERA25FA076Accident · 1 fatalClass 3 · FieldFinal reportCostruzioni Aeronautiche Tecnam P2008 · Greenwich, CTA total loss of engine power due to water-contaminated fuel, and the pilots’ inadequate preflight inspection. Contributing to the water contamination were the missing o-ring or packing and damage to the left fuel cap, and the undetected improperly sealed…Dec 12, 2024 · N298PM · Substantial damageNTSB ERA25FA071Accident · 1 fatalClass 3 · FieldFinal reportMagni Builder M-16 · Foley, ALThe sport pilot’s failure to maintain control of the gyroplane during initial climb, which resulted in an uncontrolled descent and collision with terrain.Dec 9, 2024 · N271BP · Substantial damageNTSB ERA25FA066Accident · 1 fatalClass 3 · FieldPreliminary reportSchleicher ASW24 · Vero Beach, FLOn December 6, 2024, about 1240 eastern standard time, a Schleicher ASW 24 glider, N244RW, was substantially damaged when it was involved in an accident near Vero Beach, Florida. The pilot was fatally injured. The glider was owned by a local soaring club and…Dec 6, 2024 · N244RW · Substantial damageNTSB GAA25WA037Accident · 1 fatalClass 5 · ForeignRobinson R44 · Maimuru, AustraliaDec 4, 2024 · VH-XIX · DestroyedNTSB GAA25WA034Accident · 1 fatalClass 5 · ForeignCessna 188 · Quirinopolis, BrazilNov 20, 2024 · PT-DRB · Substantial damageNTSB CEN25FA040Accident · 1 fatalClass 3 · FieldPreliminary reportBeech 35-B33 · Nunn, COOn November 15, 2024, about 1000 mountain standard time (MST), a Beech 35-B33, N285BW, was destroyed when it was involved in an accident near Nunn, Colorado. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…Nov 15, 2024 · N285BW · DestroyedNTSB CEN25FA034Accident · 3 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R44 II · Iowa, LAOn November 1, 2024, about 2106 central daylight time, a Robinson R-44 II helicopter, N62CD, was destroyed when it was involved in an accident near Iowa, Louisiana. The pilot and two passengers were fatally injured. The helicopter was operated as a Title 14…Nov 2, 2024 · N62CD · DestroyedNTSB GAA25WA176Accident · 1 fatalClass 5 · ForeignSocata TB 20 · Vaduleni, MoldovaOct 27, 2024 · D-EMRT · Destroyed