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 ERA24LA366Accident · Serious injuriesClass 4 · LimitedFinal reportMooney M20K · Fairmont, WVThe pilot’s failure to attain the proper touchdown point, and his delay in aborting the landing.NTSB WPR24FA288Accident · 2 fatalClass 3 · FieldPreliminary reportTextron T206H · Yellow Pine, IDOn August 29, 2024, about 1540 mountain daylight time, a Cessna T206H, N712AM, was destroyed when it was involved in an accident near Yellow Pine, Idaho. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN24FA320Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 550 · Odessa, TXOn August 20, 2024, about 0700 central daylight time, a Cessna 550 airplane, N689VP, was destroyed when it was involved in an accident near Odessa, Texas. The pilot and passenger were fatally injured. A person on the ground was seriously injured. The airplane…NTSB GAA24WA268Accident · 1 fatalClass 5 · ForeignAir Tractor AT802 · La Riola, ArgentinaNTSB GAA24WA253Accident · 1 fatalClass 5 · ForeignRobinson R-44 · Cairns, AustraliaNTSB CEN24FA304Accident · 4 fatalClass 3 · FieldPreliminary reportBeech F33 · Oklahoma City, OKOn August 6, 2024, about 1326 central daylight time, a Beechcraft F33A airplane, N8095U, was destroyed when it was involved in an accident near Oklahoma City, Oklahoma. The private pilot and the three passengers sustained fatal injuries. The airplane was…NTSB GAA24WA250Accident · 3 fatalClass 5 · ForeignBeech 95A55 · Birigui, BrazilNTSB GAA24WA233AccidentClass 5 · ForeignBell Textron Canada 505 · Dublin, IrelandNTSB ANC24LA071Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Huntsville, UTThe pilot's failure to navigate in hazy conditions, which resulted in a forced landing in a field and a collision with a pole.NTSB DCA24WA244Accident · 19 fatalClass 3 · ForeignBombardier CL600 2B19 · Kathmandu, NepalNTSB GAA24WA232Accident · 1 fatalClass 5 · ForeignEarthstar E Gull 2000 · New Brunswick, CanadaNTSB GAA24WA209AccidentClass 5 · ForeignJust SuperStol · Romsey, United KingdomNTSB DCA24WA226IncidentClass 5 · ForeignBoeing 777 · Ho Chi Minh, VietnamNTSB GAA24WA205Accident · 1 fatalClass 5 · ForeignCessna 172 · Mulgathing, AustraliaNTSB ERA24FA274Accident · 1 fatalClass 3 · FieldPreliminary reportAir Tractor AT502 · Martin, TNOn June 25, 2024, about 0820 central daylight time, an Air Tractor, Inc. AT-502A, N325RA, was substantially damaged when it was involved in an accident near Martin, Tennessee. The commercial pilot was fatally injured. The airplane was operated as a Title…NTSB GAA24WA248Accident · Minor injuriesClass 5 · ForeignEurocopter AS350 · Wawa, CanadaNTSB GAA24WA311Accident · 1 fatalClass 5 · ForeignAir Tractor AT-502 · West Wyalong, AustraliaNTSB GAA24WA185Accident · 1 fatalClass 4 · ForeignCessna 206 · Haines Junction, CanadaNTSB GAA24WA214Accident · 2 fatalClass 5 · ForeignBeech 55 · Santa Catarina, BrazilNTSB GAA24WA194Accident · No injuriesClass 3 · ForeignBell 206 · Bages, FranceNTSB GAA24WA162Accident · 3 fatalClass 5 · ForeignCessna 406 · Windhoek City, NamibiaNTSB GAA24WA145Accident · 3 fatalClass 5 · ForeignBell 206 · Meico City, MexicoNTSB GAA24WA152Accident · Minor injuriesClass 5 · ForeignCessna A188 · Zona bananera, Ciénaga - Magdalena, ColombiaNTSB ERA24LA177Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Carrabassett, METhe pilot’s failure to attain a proper touchdown point while landing in gusty wind conditions.NTSB WPR24FA119Accident · 2 fatalClass 3 · FieldPreliminary reportDaher TBM700 · Truckee, CAOn March 30, 2024, at 1837 Pacific daylight time, a Daher TBM 700 (960), N960LP, was substantially damaged when it was involved in an accident in Truckee, California. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code…NTSB GAA24WA115Accident · No injuriesClass 4 · ForeignCessna 172S · Guna, IndiaNTSB GAA24WA108AccidentClass 5 · ForeignCessna 172M · Wilson Airport, KenyaNTSB GAA24WA110Accident · 1 fatalClass 5 · ForeignZenith CH-801 · Bunberry, AustraliaNTSB ANC24LA016Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Hana, HIThe pilot’s failure to ensure the passenger’s gear was properly secured before departure.NTSB GAA24WA099AccidentClass 5 · ForeignCessna 172 · Brownlow Hill, AustraliaNTSB GAA24WA080AccidentClass 5 · ForeignRobinson R44 · Santa Luzia, BrazilNTSB 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.NTSB GAA24WA060Accident · No injuriesClass 5 · ForeignRobinson R44 · Arthur's Pass, New ZealandNTSB 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.NTSB GAA24WA068Accident · 4 fatalClass 5 · ForeignCessna 210 · Guayaibi, ParaguayNTSB GAA24WA044Accident · 1 fatalClass 4 · ForeignRobinson R66 · Ramallo, ArgentinaNTSB GAA24WA020Accident · 1 fatalClass 5 · ForeignBeech C23 · Pretoria, South AfricaNTSB 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.NTSB GAA24WA011Accident · 2 fatalClass 5 · ForeignCessna 208 · Pacencia-Yacma, BelizeNTSB ERA24LA009Accident · Minor injuriesClass 4 · LimitedFinal reportMonocoupe 90AL-115 · Myakka City, FLThe pilot’s failure to maintain adequate clearance from a fence during takeoff.NTSB GAA24WA124Accident · 4 fatalClass 5 · ForeignRobin DR400-180 · Propriano, FranceNTSB GAA24WA015Accident · 2 fatalClass 5 · ForeignCessna 172N · Merriton, AustraliaNTSB GAA24WA016Accident · No injuriesClass 5 · ForeignChristen Industries A1 · Hida Air Park, JapanNTSB CEN23LA422Accident · Minor injuriesClass 4 · LimitedFinal reportQuicksilver Sport II · Welsh, LAThe pilot’s failure to maintain sufficient altitude from obstacles during the simulated landing approach which led to a collision with a fence and a building.NTSB ANC23LA086Accident · No injuriesClass 4 · LimitedFinal reportCessna 182K · Trimble River Valley, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in the left main landing gear (MLG) tire impacting a rock, resulting in the separation of the MLG wheel, and the subsequent loss of directional control.NTSB GAA23WA269Accident · No injuriesClass 5 · ForeignBell 204B · Aratula, AustraliaNTSB GAA23WA264Accident · No injuriesClass 5 · ForeignCessna 170 · Doutor Ulysses, BrazilNTSB 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.NTSB GAA23WA255Accident · 1 fatalClass 5 · ForeignRobinson R44 · Vologda Oblast, RussiaNTSB 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.