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 ANC22LA016Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Skwenta, AKThe pilot’s failure to maintain adequate clearance from a tree while landing.NTSB GAA22WA056Accident · 1 fatalClass 5 · ForeignAmateur Built D11 · South Mackay, AustraliaNTSB GAA22WA052Accident · 1 fatalClass 5 · ForeignPiper 25-260 · Vereda Aparco, Ibague, ColombiaNTSB GAA22WA050Accident · 9 fatalClass 5 · ForeignGulfstream GIV · Santo Domingo, Dominican RepublicNTSB CEN22FA073Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 407 · LaPlace, LAThe pilot’s failure to maintain clearance from power lines. Contributing to the accident was the pilot’s decision to fly in instrument conditions.NTSB GAA22WA040AccidentClass 5 · ForeignAir Tractor AT-400 · Bulyeroi, AustraliaNTSB GAA22WA038Accident · 2 fatalClass 5 · ForeignMurphy Rebel · Wasbush, CanadaNTSB DCA22WA057IncidentClass 5 · ForeignCanadair CRJ-900 · San Diego, CANTSB DCA22WA034IncidentClass 5 · ForeignBoeing 737 · Maringá, BrazilNTSB ERA22FA051Accident · 1 fatalClass 3 · FieldFinal reportIssitt Greg Sonex · Malone, FLAn in-flight collision with a tree for reasons that could not be determined.NTSB WPR22LA031Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Covelo, CAA passenger’s unsecured object departed the cabin resulted in a collision with the tail rotor drive shaft.NTSB GAA22WA012AccidentClass 5 · ForeignRobinson R44 · Buchen-Sturzenhardt, GermanyNTSB GAA22WA089Accident · 8 fatalClass 4 · ForeignPilatus PC12 · San Donato, ItalyNTSB GAA22WA001Accident · 3 fatalClass 5 · ForeignRobinson R44 · Lytkarino, RussiaNTSB GAA21WA250Accident · 1 fatalClass 5 · ForeignCessna T206 · La Pajarera, MexicoNTSB GAA21WA225Accident · 1 fatalClass 5 · ForeignPiper J3C · Mauricie, CanadaNTSB GAA21WA180Accident · 2 fatalClass 5 · ForeignPiper PA28 · Contrada Coccaro Fasano, ItalyNTSB ERA21LA292Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Princeton, KYThe pilot’s inadequate preflight planning in that he failed to accurately determine the takeoff weight of the helicopter, which resulted in exceeding the helicopter’s maximum weight capability.NTSB WPR21FA270Accident · 2 fatalClass 3 · FieldFinal reportCessna 421C · Monterey, CAThe pilot’s failure to maintain airplane control due to spatial disorientation during an instrument departure procedure in instrument meteorological conditions which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of…NTSB ANC21LA057Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2-L-20 · Coffman Cove, AKThe pilot’s impact with a buoy on takeoff which resulted in a nose-over.NTSB GAA21WA210AccidentClass 5 · ForeignCessna 172 · Beirut, LebanonNTSB GAA21WA172Accident · 3 fatalClass 5 · ForeignDouglas DC3 · Restrepo, ColombiaNTSB WPR21LA252Accident · No injuriesClass 4 · LimitedFinal reportSilverLight AR-1 · Lakeside, ORThe pilot’s inadequate decision to continue the takeoff after sufficient airspeed was not attained and his failure to maintain aircraft control while maneuvering to avoid obstructions, which resulted in a collision with the ground.NTSB GAA21WA167Accident · Minor injuriesClass 5 · ForeignCessna 152 · Lima, PeruNTSB WPR21LA240Accident · No injuriesClass 4 · LimitedFinal reportCessna T206 · Apple Valley, CAThe pilot's distraction due to adjusting the radio while taxing at night, which resulted in a taxiway excursion and subsequent impact with terrain.NTSB GAA21WA154Accident · Serious injuriesClass 5 · ForeignPiper PA-32-300 · Moorabbin Aerodrome, AustraliaNTSB GAA21WA145Accident · 1 fatalClass 5 · ForeignRobinson R44 · Eidanger, NorwayNTSB DCA21WA159Accident · No injuriesClass 5 · ForeignBoeing 737 · Derbyshire, United KingdomNTSB GAA21WA141Accident · No injuriesClass 5 · ForeignBell 407 · Siaya County, KenyaNTSB GAA21WA130Accident · 1 fatalClass 5 · ForeignCessna 188A · Inmediaciones Municipio Paz de Ariporo, Casanare, ColombiaNTSB GAA21WA133Accident · 1 fatalClass 5 · ForeignRobinson R22 · Hay South, AustraliaNTSB GAA21WA132AccidentClass 5 · ForeignCessna 210 · Itaituba, BrazilNTSB GAA21WA104Accident · 2 fatalClass 5 · ForeignRobinson R22 · Durban, South AfricaNTSB WPR21LA191Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic S A N-500 · Phoenix, AZThe pilot’s inability to maintain control after the balloon's encounter with an unexpected wind gust, which resulted in a collision with a tree.NTSB GAA21WA100Accident · 4 fatalClass 5 · ForeignBell 206 · Rio Bravo, GuatemalaNTSB GAA21WA089Accident · 1 fatalClass 5 · ForeignVans RV7A · Columbia, AustraliaNTSB GAA21WA081Accident · 2 fatalClass 5 · ForeignCessna 172 · Canberra, AustraliaNTSB GAA21WA201AccidentClass 5 · ForeignRobinson R44 · Hertzog Ville, South AfricaNTSB ERA21LA172Accident · Minor injuriesClass 4 · LimitedFinal reportPhantom Aeronautics Phantom II · McBee, SCThe pilot's failure to maintain adequate clearance from trees while maneuvering in the traffic pattern.NTSB GAA21WA059Accident · No injuriesClass 4 · ForeignBeech 200 · Nairobi, KenyaNTSB CEN21LA158Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150H · Paris, TXThe pilot’s decision to takeoff with known obstacles on the runway and his subsequent failure to avoid the windsock on takeoff.NTSB GAA21WA038Accident · 1 fatalClass 5 · ForeignRobinson R22 · Bollena, ItalyNTSB ERA21LA138Accident · Serious injuriesClass 3 · LimitedFinal reportDassault Mirage F1 B · Panama City, FLNose landing gear contact with a raised aircraft arresting system during takeoff, which damaged components of the nose wheel steering system and resulted in an uncommanded left turn and loss of directional control.NTSB GAA21WA048Accident · No injuriesClass 5 · ForeignRobinson R66 · Khvoyninsky District, RussiaNTSB DCA21WA086Accident · No injuriesClass 5 · ForeignBoeing 737 · Vijayawada, IndiaNTSB CEN21LA128Accident · No injuriesClass 4 · LimitedFinal reportAgustawestland Philadelphia AW119MKII · Alexandria, MNThe helicopter’s impact with an object on departure that could not be determined.NTSB GAA21WA021AccidentClass 5 · ForeignRobinson R22 · Hughenden, AustraliaNTSB GAA21WA018Accident · 2 fatalClass 4 · ForeignBell 206B · Courchevel, FranceNTSB GAA21WA015Accident · 1 fatalClass 5 · ForeignAir Tractor AT402 · Hoopstad, South AfricaNTSB GAA21WA029Accident · 1 fatalClass 5 · ForeignBell 206 · Wolseley, South Africa