Skip to content

NTSB investigations, 2023

48 cases where the defining event was Collision with terr/obj (non-CFIT).

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '470') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '470')
  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.

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."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '470')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB WPR24LA069Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Whitefish, MTThe failure of the airport authorities to renew the airport closure NOTAM for the airport. Contributing to the accident, was the pilot’s inability to see the runway closure sign.Dec 23, 2023 · N43415 · Substantial damage NTSB GAA24WA060Accident · No injuriesClass 5 · ForeignRobinson R44 · Arthur's Pass, New ZealandDec 19, 2023 · ZK-HGX · Substantial damage NTSB ERA24LA057Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Social Circle, GAAn encounter with a downdraft while maneuvering at low altitude, which resulted in a collision with a fence.Dec 5, 2023 · N53AA · Substantial damage NTSB GAA24WA068Accident · 4 fatalClass 5 · ForeignCessna 210 · Guayaibi, ParaguayDec 2, 2023 · ZP-BDN · Destroyed NTSB GAA24WA044Accident · 1 fatalClass 4 · ForeignRobinson R66 · Ramallo, ArgentinaNov 26, 2023 · LV-FQJ · Substantial damage NTSB GAA24WA020Accident · 1 fatalClass 5 · ForeignBeech C23 · Pretoria, South AfricaOct 21, 2023 · ZK-JKE · Substantial damage NTSB WPR24LA021Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · The Dalles, ORThe pilot’s encounter with severe turbulence at night which resulted in an extended downwind and collision with wires during the base turn.Oct 20, 2023 · N6308Q · Substantial damage NTSB GAA24WA011Accident · 2 fatalClass 5 · ForeignCessna 208 · Pacencia-Yacma, BelizeOct 16, 2023 · V3-HIN · Destroyed NTSB ERA24LA009Accident · Minor injuriesClass 4 · LimitedFinal reportMonocoupe 90AL-115 · Myakka City, FLThe pilot’s failure to maintain adequate clearance from a fence during takeoff.Oct 14, 2023 · N87621 · Substantial damage NTSB GAA24WA124Accident · 4 fatalClass 5 · ForeignRobin DR400-180 · Propriano, FranceOct 12, 2023 · F-GIKS · Destroyed NTSB GAA24WA015Accident · 2 fatalClass 5 · ForeignCessna 172N · Merriton, AustraliaOct 8, 2023 · VH-RSB NTSB GAA24WA016Accident · No injuriesClass 5 · ForeignChristen Industries A1 · Hida Air Park, JapanOct 7, 2023 · JA4083 · Substantial damage NTSB GAA23WA269Accident · No injuriesClass 5 · ForeignBell 204B · Aratula, AustraliaSep 20, 2023 · VH-EQW · Destroyed NTSB GAA23WA264Accident · No injuriesClass 5 · ForeignCessna 170 · Doutor Ulysses, BrazilSep 17, 2023 · PP-DSX · Substantial damage NTSB ANC23LA081Accident · Serious injuriesClass 4 · LimitedFinal reportPiper/Gerbi Charles R PA 18-150 · Juneau, AKThe student pilot’s failure to maintain altitude after the airplane encountered a downdraft while maneuvering over an area of hilly terrain.Sep 11, 2023 · N4900C · Substantial damage NTSB GAA23WA255Accident · 1 fatalClass 5 · ForeignRobinson R44 · Vologda Oblast, RussiaSep 10, 2023 · RA-05823 · Substantial damage NTSB ERA23LA364Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Norwood, MAThe pilot’s failure to fly an appropriate glide path during the landing approach, which resulted in a collision with approach lights and the ground short of the intended runway.Sep 7, 2023 · N400RW · Substantial damage NTSB ERA23LA389Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Baltimore, MDThe pilot’s failure to maintain control of the airplane during the aborted landing, which resulted in a collision with a taxiway light.Sep 3, 2023 · N74TR · Substantial damage NTSB WPR23LA311Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Miles City, MTThe pilot's failure to maintain control of the airplane while landing on unimproved terrain.Aug 11, 2023 · N3609K · Substantial damage NTSB ERA23FA321Accident · 1 fatalClass 3 · FieldFinal reportKolb Firestar · McAlpin, FLA collision with trees during takeoff for reasons that could not be determined based on available information.Aug 3, 2023 · Unreg · Substantial damage NTSB DCA23WA393Incident · No injuriesClass 5 · ForeignBoeing 767 · São Tomé, São Tomé & PríncipeJul 29, 2023 · CS-TST · Minor damage NTSB GAA23WA223Accident · 3 fatalClass 5 · ForeignCessna 650 · Veracruz, MexicoJul 28, 2023 · XB-VFJ · Destroyed NTSB GAA23WA215Accident · 4 fatalClass 5 · ForeignRobinson R44 · Swakopmund, NamibiaJul 17, 2023 · ZS-HLG · Destroyed NTSB CEN23LA309Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Princeton, TXThe student pilot’s decision to attempt a takeoff from an unimproved field which resulted in an impact with an obstacle.Jul 16, 2023 · N41317 · Substantial damage NTSB ANC23LA050Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Matanuska Glacier, AKThe airplane’s encounter with downdrafts resulting in decreased performance insufficient to outclimb rising terrain.Jul 13, 2023 · N460JC · Substantial damage NTSB WPR23LA274Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Long Beach, CAThe student pilot’s failure to maintain directional control during landing and the subsequent go-around, which resulted in impact with a hangar.Jul 10, 2023 · N3307E · Substantial damage NTSB GAA23WA193Accident · 1 fatalClass 5 · ForeignBell 47 · Sainte-Marthe, FranceJul 4, 2023 · F-GKTR · Destroyed NTSB CEN23LA272Accident · Serious injuriesClass 4 · LimitedFinal reportSix Chuter SR7 XL · Chetek, WIThe pilot’s failure to maintain aircraft control during initial climb which resulted in an impact with a pole, trees, and terrain.Jul 2, 2023 · N6365A · Substantial damage NTSB ANC23LA049Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18 · Beluga, AKThe pilot's selection of an unsuitable takeoff site, resulting in a collision with brush-covered terrain.Jul 1, 2023 · N15XX · Substantial damage NTSB GAA23WA180Accident · 1 fatalClass 5 · ForeignRobinson R22 · Buchanan, AustraliaJun 27, 2023 · vh-PSDC · Substantial damage NTSB GAA23WA274Accident · 1 fatalClass 5 · ForeignDB 6R · Ombersley Court, Worcestershire, United KingdomJun 25, 2023 · G-CMFS · Substantial damage NTSB GAA23WA183Accident · 1 fatalClass 5 · ForeignAir Tractor AT802 · Ngodwana, South AfricaJun 21, 2023 · ZS-TFH · Substantial damage NTSB WPR23LA231Accident · Minor injuriesClass 4 · LimitedFinal reportJohnson Gary L Fisher Horizon 1 · Chelan, WAThe pilot’s improper selection of a touchdown point and delayed recognition, which resulted in an impact with an obstacle.Jun 12, 2023 · N88GJ · Substantial damage NTSB WPR23LA362Accident · No injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Minden, NVThe pilot’s failure to maintain directional control during the landing roll, resulting in an impact with a taxiway sign.Jun 3, 2023 · N438BA · Substantial damage NTSB CEN23LA202Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Wright, LAThe pilot's decision to takeoff with the airplane overloaded which resulted in the airplane settling and subsequently impacting terrain.May 25, 2023 · N6699Q · Substantial damage NTSB DCA23LA290AccidentClass 4 · LimitedFinal reportGeneral Atomics MQ-9 Block 1 · Elgin, AZThe pilot’s loss of situational awareness, resulting in the UAS’s controlled flight into terrain.May 15, 2023 · N31EJ · Destroyed NTSB GAA23WA149Accident · No injuriesClass 5 · ForeignRobinson R66 · Konakovo, RussiaMay 13, 2023 · RA-07372 · Destroyed NTSB ERA23LA229Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · South Bethlehem, NYThe pilot’s improper decision to attempt an intersection takeoff in a tailwind when the full runway in the opposite, headwind direction was available.May 11, 2023 · N1596E · Substantial damage NTSB GAA23WA150Accident · Serious injuriesClass 5 · ForeignCessna 182 · Langley Regional, CanadaMay 2, 2023 · C-GIDY · Substantial damage NTSB GAA23WA141Accident · 1 fatalClass 5 · ForeignRobinson R44 · Middlemount, AustraliaApr 4, 2023 · VH-WLH · Destroyed NTSB GAA23WA108Accident · 1 fatalClass 5 · ForeignGrumman G164 · Comercial, UruguayMar 27, 2023 · CX-BTI-R · Substantial damage NTSB CEN23LA143Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Hillsboro, MOThe pilot’s failure to maintain clearance from trees during final approach to landing.Mar 25, 2023 · N43272 · Substantial damage NTSB GAA23WA090Accident · 2 fatalClass 5 · ForeignAir Tractor AT402 · Fazenda Juína, Juína - MT, BrazilMar 3, 2023 · PS-JCB · Substantial damage NTSB CEN23LA119Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Martinsville, INThe pilot’s inadequate weather evaluation and failure to abort the takeoff that resulted in an impact with terrain.Feb 23, 2023 · N1700T · Substantial damage NTSB GAA23WA072Accident · 2 fatalClass 4 · ForeignRobinson R44 · Vargem Alta, BrazilFeb 9, 2023 · PR-PLF · Substantial damage NTSB CEN23LA097Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172L · Cleveland, TXThe pilot’s decision to attempt the night flight under visual flight rules when instrument meteorological conditions prevailed resulting in the airplane striking trees while on final approach. Contributing to the accident were the unserviceable runway lights…Jan 29, 2023 · N621EW · Substantial damage NTSB GAA23WA065Accident · Minor injuriesClass 4 · ForeignPiper PA32R · Isla Martin Garcia, ArgentinaJan 15, 2023 · LV-HJQ · Destroyed NTSB GAA23WA056Accident · 1 fatalClass 5 · ForeignAero Eli Servizi Yoyo · Lesna Jania, PolandJan 10, 2023 · SP HEYO · Destroyed