NTSB investigations
444 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 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, CanadaNTSB ERA22LA209Accident · Minor injuriesClass 4 · LimitedFinal reportGarlick Helicopters OH-58A+ · Oakland, FLThe pilot’s decision to continue the low-altitude aerial application flight over water conditions that degraded his depth perception, which resulted in an inadvertent collision with the water.NTSB ERA22LA204Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172A · Stockbridge, GAThe flight instructor’s delayed remedial action during an unstabilized approach, which resulted in an impact with powerlines and a subsequent loss of controlNTSB GAA22WA159Accident · 1 fatalClass 5 · ForeignCessna 172 · Coonagarabran, AustraliaNTSB ERA22LA196Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Zebulon, NCThe flight instructor’s failure to maintain directional control with a quartering tailwind.NTSB GAA22WA144Accident · 2 fatalClass 5 · ForeignBell 206 · Adaminaby, AustraliaNTSB WPR22LA141Accident · No injuriesClass 4 · LimitedFinal reportFernandes Dale R Glasair II S-FT · Saline Valley, CAThe pilot’s failure to establish a controlled descent rate during landing which resulted in the airplane touching down short of the runway.NTSB ERA22LA176Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177RG · Gaithersburg, MDThe pilot’s failure to maintain adequate airspeed while maneuvering on final approach which resulted in a high sink rate and subsequent collision with a fence.NTSB CEN22LA154Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Wade, OKThe student pilot’s failure to maintain clearance from power lines during takeoff.NTSB WPR22LA144Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · Alpine, CAThe pilot’s failure to maintain clearance from rising terrain while operating in a canyon, which resulted in an impact with terrainNTSB GAA22WA201Accident · Serious injuriesClass 5 · ForeignBell 206L-1 · Cooma, AustraliaNTSB ERA22FA149Accident · 2 fatalClass 3 · FieldFinal reportCessna 182Q · Panama City, FLThe pilot’s deviation from the final approach course during a night instrument approach with low instrument meterological conditions, which resulted in an impact with heavily wooded terrain. Contributing to the accident was the pilot’s decision to continue…NTSB GAA22WA113Accident · 1 fatalClass 5 · ForeignCessna U206G · Norseman, AustraliaNTSB GAA22WA112Accident · 14 fatalClass 5 · ForeignCessna 208B · Comoros, ComorosNTSB WPR22LA114Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 208B · Oceanside, CAThe pilot’s intentional inflight operation of the propeller in beta, which led to an aerodynamic lock, his inability to restore forward thrust, and subsequent collision with terrain.NTSB WPR22LA107Accident · No injuriesClass 4 · LimitedFinal reportRoss Jonathan RV-8 · Pinon, AZThe pilot's failure to maintain clearance from power lines during low-level flight.NTSB WPR22FA109Accident · 1 fatalClass 3 · FieldFinal reportDistar CZ D 13/15 SUN Dancer · Boulder City, NVThe pilot’s failure to maintain clearance from powerlines while maneuvering, which resulted in a wire strike and impact with terrain. Contributing to the accident was the pilot’s impairment from alcohol consumption and his use of diphenhydramine before the…NTSB GAA22WA109Accident · 1 fatalClass 5 · ForeignPiper PA-25-235 · Leongatha, AustraliaNTSB GAA22WA102Accident · 1 fatalClass 5 · ForeignCessna FA150 · Utrera, SpainNTSB GAA22WA103AccidentClass 5 · ForeignGarlick UH1H · Devonport, AustraliaNTSB CEN22LA120Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Murphysboro, ILThe pilot’s failure to maintain clearance from power lines during approach for landing.NTSB GAA22WA095Accident · 2 fatalClass 5 · ForeignCessna 172 · Region de la Araucania, Chile