NTSB investigations
449 cases where the defining event was 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.\"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 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 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.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.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.NTSB DCA23WA393Incident · No injuriesClass 5 · ForeignBoeing 767 · São Tomé, São Tomé & PríncipeNTSB GAA23WA223Accident · 3 fatalClass 5 · ForeignCessna 650 · Veracruz, MexicoNTSB GAA23WA215Accident · 4 fatalClass 5 · ForeignRobinson R44 · Swakopmund, NamibiaNTSB 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.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.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.NTSB GAA23WA193Accident · 1 fatalClass 5 · ForeignBell 47 · Sainte-Marthe, FranceNTSB 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.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.NTSB GAA23WA180Accident · 1 fatalClass 5 · ForeignRobinson R22 · Buchanan, AustraliaNTSB GAA23WA274Accident · 1 fatalClass 5 · ForeignDB 6R · Ombersley Court, Worcestershire, United KingdomNTSB ERA23LA295Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206B · Sandersville, GAThe pilot’s failure to maintain clearance of trees during landing, which resulted in a tail rotor contact with tree limbs and a subsequent loss of control.NTSB GAA23WA183Accident · 1 fatalClass 5 · ForeignAir Tractor AT802 · Ngodwana, South AfricaNTSB 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.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.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.NTSB CEN23LA207Accident · No injuriesClass 4 · LimitedFinal reportAmerican AA-5 · Fort Worth, TXAn inflight collision with a bird.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.NTSB GAA23WA149Accident · No injuriesClass 5 · ForeignRobinson R66 · Konakovo, RussiaNTSB 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.NTSB GAA23WA150Accident · Serious injuriesClass 5 · ForeignCessna 182 · Langley Regional, CanadaNTSB GAA23WA141Accident · 1 fatalClass 5 · ForeignRobinson R44 · Middlemount, AustraliaNTSB GAA23WA108Accident · 1 fatalClass 5 · ForeignGrumman G164 · Comercial, UruguayNTSB CEN23LA143Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Hillsboro, MOThe pilot’s failure to maintain clearance from trees during final approach to landing.NTSB GAA23WA090Accident · 2 fatalClass 5 · ForeignAir Tractor AT402 · Fazenda Juína, Juína - MT, BrazilNTSB 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.NTSB GAA23WA072Accident · 2 fatalClass 4 · ForeignRobinson R44 · Vargem Alta, BrazilNTSB 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…NTSB GAA23WA065Accident · Minor injuriesClass 4 · ForeignPiper PA32R · Isla Martin Garcia, ArgentinaNTSB ANC23LA018Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-180 · Glennallen, AKThe pilot’s failure to maintain airspeed during a drag maneuver, which resulted in an overrun and subsequent impact with terrain.NTSB GAA23WA056Accident · 1 fatalClass 5 · ForeignAero Eli Servizi Yoyo · Lesna Jania, PolandNTSB GAA23WA051Accident · 2 fatalClass 5 · ForeignCessna 210N · Bulman, AustraliaNTSB WPR23LA063Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · La Sal, UTThe pilot’s failure to maintain clearance from terrain during a toe-in landing to sloping terrain which resulted in a loss of helicopter control.NTSB GAA23WA039Accident · 5 fatalClass 5 · ForeignCenterpoint Aerospace S-58T · Yang Yang, South KoreaNTSB GAA23WA032Accident · Serious injuriesClass 5 · ForeignRobinson R44 · Richmond, AustraliaNTSB CEN23LA053Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Searcy, ARThe pilot’s failure to maintain clearance from the electrical box while repositioning.NTSB WPR23LA032Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · Salt Lake City, UTThe pilot’s inadvertent attempt to takeoff on a left side of runway, rather than the centerline of runway, which resulted in a collision with runway edge lights during the night time takeoff.NTSB DCA23WA062Occurrence · No injuriesClass 5 · ForeignDouglas DC3 · Balikpapan, IndonesiaNTSB GAA23WA025Accident · 1 fatalClass 3 · ForeignBell UH-1 · San Clemente, ChileNTSB ERA23FA045Accident · 2 fatalClass 3 · FieldFinal reportBearhawk Patrol · Hanover Township, PAThe pilot’s decision to unlatch his seatbelt during flight, which allowed him to exit the airplane and impact the tail, resulting in a loss of control and impact with terrain.NTSB GAA23WA012Accident · 1 fatalClass 5 · ForeignThrush S2R-T660 · Sierra Segundera, SpainNTSB GAA23WA008Accident · Serious injuriesClass 5 · ForeignMooney M20J · Luskintyre, AustraliaNTSB GAA23WA003Accident · 2 fatalClass 5 · ForeignRobinson R22 · Cunderdin, AustraliaNTSB GAA22WA302Accident · 2 fatalClass 5 · ForeignRobinson R44 · Joyabaj, GuatemalaNTSB GAA22WA301Accident · 2 fatalClass 5 · ForeignWagaero Sportsman · Champais, Quebec, CanadaNTSB ERA22LA409Accident · No injuriesClass 4 · LimitedFinal reportCessna 182N · Blairstown, NJThe pilot’s decision to cross the taxiway at an unsuitable location.NTSB WPR22LA321Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Twin Bridges, MTThe student pilot’s failure to maintain airplane control during an aborted landing, and the flight instructor’s delayed remedial action.