NTSB investigations, 2022
72 cases where the defining event was Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 54 |
|---|---|
| 2009 | 20 |
| 2010 | 39 |
| 2011 | 5 |
| 2016 | 1 |
| 2018 | 1 |
| 2019 | 8 |
| 2020 | 13 |
| 2021 | 52 |
| 2022 | 72 |
| 2023 | 48 |
| 2024 | 55 |
| 2025 | 61 |
| 2026 | 15 |
Where
Open the mapLatest 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\") = 2022
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") = 2022 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 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.NTSB GAA22WA275Accident · 3 fatalClass 5 · ForeignCessna R182 · Amberly, AustraliaNTSB ERA22FA387Accident · 2 fatalClass 3 · FieldFinal reportSea & Sky Krucker Cygnet · Emily, MNThe pilot’s operation of the weight-shift control aircraft over its design gross weight and his decision to take off with the engine operating at less than the specified takeoff rpm, which resulted in degraded takeoff and climb performance. Contributing to…NTSB CEN22LA395Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Prue, OKThe pilot’s failure to maintain clearance from power lines during intentional low-level maneuvering.NTSB CEN22LA394Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Liberty, MOThe flight instructor’s improper decision to take off without adequate airspeed which resulted in degraded performance and a collision with trees.NTSB ERA22FA383Accident · 2 fatalClass 3 · FieldFinal reportBell 206B · Whiteside, TNThe pilot’s failure to maintain clearance from the powerlines.NTSB WPR22LA305Accident · No injuriesClass 4 · LimitedFinal reportHughes Helicopters 369E · Ely, NVThe pilot’s failure to maintain clearance from terrain while maneuvering at a low altitude.NTSB GAA22WA255Accident · 2 fatalClass 5 · ForeignPiper PA28 · Nipigon, CanadaNTSB GAA22WA261Accident · 1 fatalClass 5 · ForeignRobinson R22 · Albosaggia, ItalyNTSB GAA22WA245Accident · 1 fatalClass 5 · ForeignPiper PA11 · Aeródromo Chañar Ladeado, Santa Fe, ArgentinaNTSB ERA22LA356Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182C · Holly Ridge, NCThe pilot’s failure to maintain clearance of powerlines on final approach.NTSB CEN22LA365Accident · No injuriesClass 4 · LimitedFinal reportUltramagic M56C · Indianola, IAThe pilot’s failure to maintain adequate clearance from powerlines.NTSB GAA22WA313Accident · Serious injuriesClass 5 · ForeignPiper PA25 · Trinidad, ColombiaNTSB CEN22LA371Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-T65 · Wyman / Washington, IAThe pilot not maintaining sufficient altitude to clear an obstruction during the aerial application flight.NTSB GAA22WA235Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Tiquisate, GuatemalaNTSB GAA22WA234Accident · No injuriesClass 5 · ForeignCessna F150 · Gödöllo, HungaryNTSB GAA22WA232Accident · 1 fatalClass 5 · ForeignChampion 7GCBC · Trois Riviere, Quebec, CanadaNTSB ERA22LA433Accident · No injuriesClass 4 · LimitedFinal reportEaster William C M-1 · Okeechobee, FLThe premature placement of an airport runway closure marker short of the runway, which resulted in the airplane’s collision with the marker during the landing approach. Contributing was the pilot’s inability to see the marker due the nose-high attitude of the…NTSB ANC22LA060Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft F21 · Kenai, AKThe pilot’s failure to maintain adequate distance from a tree while landing.NTSB GAA22WA299Accident · 2 fatalClass 5 · ForeignBlackshape BS115 · Zwarte Meer, NetherlandsNTSB ERA22LA289Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Palmyra, PAThe pilot’s failure to maintain a proper glide path to the runway.NTSB ERA22LA290Accident · No injuriesClass 4 · LimitedFinal reportSchweizer 300 C · Boonville, NCThe helicopter’s impact with a non-biological object, which resulted in substantial damage to a main rotor blade.NTSB ERA22LA284Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-180C · Scottsboro, ALThe pilot’s failure to maintain directional during an aborted landing, which resulted in a runway excursion and collision with two parked trailers.NTSB ERA22FA279Accident · 6 fatalClass 1 · FieldFinal reportBell UH-1B · Amherstdale, WVthe operator’s failure to adequately inspect the former military turbine powered helicopter, which allowed an engine issue to progress and result in a loss of engine power and a subsequent loss of control after the helicopter struck powerlines during a forced…NTSB WPR22LA212Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A-1B · Big Creek, IDThe pilot's failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and collision with fencing.NTSB WPR22LA208Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Fort Duchesne, UTThe pilot’s decision to takeoff from an unimproved surface which resulted in a collision with an object and the airplane nosing over.NTSB GAA22WA204Accident · 1 fatalClass 5 · ForeignBell 412 · Timika, IndonesiaNTSB WPR22FA198Accident · 1 fatalClass 3 · FieldFinal reportBeech 77 · Hemet, CAThe student pilot’s failure to maintain clearance from a cinderblock wall while performing a go-around.NTSB ERA22FA262Accident · 2 fatalClass 3 · FieldFinal reportEnstrom F28 · Greenville, OHAn impact with terrain for undetermined reasons.NTSB GAA22WA199Accident · 3 fatalClass 5 · ForeignBell 206 · Currais Novos, BrazilNTSB ERA22LA250Accident · No injuriesClass 4 · LimitedFinal reportCessna 340 · St. Petersburg-Clearwater, FLThe pilot’s inability to stop the airplane on the available runway, which resulted in a runway excursion and collision with an airport perimeter fence.NTSB GAA22WA298Accident · 5 fatalClass 5 · ForeignRobin D140 · Grenoble, FranceNTSB GAA22WA184AccidentClass 5 · ForeignRans S6-ES · Hampshire, United KingdomNTSB GAA22WA185Accident · 1 fatalClass 5 · ForeignSikorsky S61N · Tongyeong-si, KiribatiNTSB GAA22WA171Accident · 4 fatalClass 5 · ForeignPiper PA28 · Sioux Lookout Ontario, Canada