Ongoing NTSB investigations
39 cases where the defining event was Collision with terr/obj (non-CFIT).
Cases per year
| 2024 | 10 |
|---|---|
| 2025 | 25 |
| 2026 | 4 |
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 c.\"completionStatus\" = 'Ongoing'
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 c."completionStatus" = 'Ongoing' 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 WPR26LA164Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 172S · Pacoima, CAOn April 20, 2026, about 1107 Pacific daylight time, a Cessna 172S airplane, N2126F, sustained substantial damage when it was involved in an accident near Whiteman Airport (WHP), Pacoima, California. The pilot was seriously injured. The airplane was operated…NTSB CEN26LA137Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-12 · Lockhart, TXOn March 7, 2026, about 1323 central standard time, a Piper PA-12, N2511M, was substantially damaged when it was involved in an accident near Lockhart, Texas. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB WPR26FA097Accident · 1 fatalClass 3 · FieldPreliminary reportSocata TB21 · Prescott, AZOn February 4, 2026, about 1950 mountain standard time, a Socata TB21, N967WM, was destroyed when it was involved in an accident near Prescott, Arizona. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB WPR26FA074Accident · 4 fatalClass 3 · FieldPreliminary reportMD Helicopters 369FF · Superior, AZOn January 2, 2026, at about 1100 mountain standard time, an MD Helicopters MD369FF helicopter, N3502P, was substantially damaged when it impacted a highline/slackline near Superior, Arizona. The pilot and three passengers were fatally injured. The helicopter…NTSB WPR26FA069Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-32-260 · Rio Linda, CAOn December 24, 2025, at approximately 1230 Pacific standard time, a Piper PA-32-260, N2785Q, was substantially damaged when it was involved in an accident near Rio Linda, California. The pilot sustained serious injuries, and the pilot-rated passenger was…NTSB CEN26LA032Accident · Serious injuriesClass 3 · LimitedPreliminary reportJust Highlander · Delta, COOn November 2, 2025, about 1630 mountain standard time, an experimental amateur-built Just Highlander airplane, N622SC, was substantially damaged when it was involved in an accident near Delta, Colorado. The flight instructor and student pilot were seriously…NTSB CEN26LA024Accident · Serious injuriesClass 3 · LimitedPreliminary reportVans RV8 · McKinney, TXOn October 17, 2025, at 0921 central daylight time, an amateur-built RV-8 airplane, N3545W, was substantially damaged when it was involved in an accident near McKinney, Texas. The pilot was seriously injured. The airplane was operated as a Title 14 Code of…NTSB WPR26LA002Incident · No injuriesClass 3 · LimitedPreliminary reportAmazon.Com Services MK30 · Tolleson, AZOn October 1, 2025, about 0958 mountain standard time, an Amazon.Com Services LLC, MK30, N791PA, was substantially damaged when it was involved in an incident near Tolleson, Arizona. There were no injuries. The unmanned aircraft system (UAS) was operated as a…NTSB WPR26LA001IncidentClass 3 · LimitedPreliminary reportAmazon.Com Services MK30 · Tolleson, AZOn October 1, 2025, about 0949 mountain standard time, an Amazon.Com Services LLC, MK30, N579PA, was substantially damaged when it was involved in an incident near Tolleson, Arizona. There were no injuries. The unmanned aircraft system (UAS) was operated as a…NTSB WPR25LA295Accident · No injuriesClass 3 · LimitedPreliminary reportSiai-Marchetti SF260B · Billings, MTOn September 26, 2025, about 1040 mountain daylight time, a SIAI-MARCHETTI SF 260B, N272C, was substantially damaged when it was involved in an accident near Billings, Montana. The pilot and passenger were not injured. The airplane was operated as a Title 14…NTSB WPR25FA294Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172F · Battle Ground, WAOn September 26, 2025, about 1306, Pacific daylight time a Cessna 172F, N8219U, was destroyed when it was involved in an accident near Battle Ground, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA25LA361Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172K · Salisbury, CTOn September 20, 2025, about 1733 eastern daylight time, a Cessna 172K, N78938, was substantially damaged when it was involved in an accident near Salisbury, Connecticut. The flight instructor and pilot receiving instruction sustained minor injuries. The…NTSB WPR25LA276Accident · No injuriesClass 3 · LimitedPreliminary reportSchieber Cedric H CH801 · Jackpot, NVOn September 11, 2025, about 0905 Pacific daylight time, an experimental amateur-built Zenith CH801, N801CS, was substantially damaged when it was involved in an accident near Jackpot, Navada. The pilot and three passengers were not injured. The airplane was…NTSB WPR25FA252Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-7A · West Glacier, MTOn August 12, 2025, about 1457 mountain daylight time, an experimental amateur-built Vans RV-7A N30SG, was substantially damaged when it was involved in an accident near West Glacier, Montana. The pilot was fatally injured. The airplane was operated as a…NTSB WPR25LA249Accident · No injuriesClass 3 · LimitedPreliminary reportAmerican Eurocopter AS350B3 · Las Cruces, NMOn August 8, 2025, about 1946 mountain daylight time, an Airbus AS350 B3, N279AM, was substantially damaged when it was involved in an accident near Las Cruces, New Mexico. The pilot, two crew members and a passenger were not injured. The helicopter was…NTSB CEN25FA289Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-22-150 · New Underwood, SDOn July 28, 2025, about 0604 mountain daylight time, a Piper PA-22-150 airplane, N9642D, was substantially damaged when it was involved in an accident near New Underwood, South Dakota. The pilot was seriously injured and the passenger sustained fatal…NTSB CEN25FA273Accident · 1 fatalClass 3 · FieldPreliminary reportCessna T188C · Oregon, ILOn July 22, 2025, about 0930 central daylight time, a Cessna T188C, N2802J, was substantially damaged when it was involved in an accident near Oregon, Illinois. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB WPR25FA190Accident · 1 fatalClass 3 · FieldPreliminary reportMD Helicopters 369E · Meeker, COOn June 25, 2025, about 1001 mountain daylight time, an MD Helicopters 369E, N411WJ, was substantially damaged when it was involved in an accident near Meeker, Colorado. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…NTSB ERA25FA239Accident · 1 fatalClass 3 · FieldPreliminary reportPiper J3C-65 · Dunlap, TNOn June 24, 2025, about 18:23 central daylight time, a Piper J3C-65, N28DR, was substantially damaged when it was involved in an accident near Dunlap, Tennessee. The commercial pilot was fatally injured and the passenger was seriously injured. The airplane…NTSB ERA25FA211Accident · 1 fatalClass 3 · FieldPreliminary reportZenith Stol CH701 · Geneva, OHOn May 25, 2025, about 1007 eastern daylight time, an experimental, amateur-built Zenith STOL CH701, N514JG, was substantially damaged when it was involved in an accident near Geneva, Ohio. The pilot was fatally injured and the pilot-rated passenger sustained…NTSB WPR25FA156Accident · 1 fatalClass 3 · FieldPreliminary reportDB Aerocopter AK1-3 · Prineville, OROn May 17, 2025, about 1134 pacific daylight time, a DB Aerocopter Ltd., AK1-3, N163AK, sustained substantial damage when it was involved in an accident near Prineville, Oregon. The private pilot undergoing instruction was fatally injured, and the flight…NTSB WPR25FA153Accident · 1 fatalClass 3 · FieldPreliminary reportAmerican Champion 7GCBC · Big Creek, IDOn May 9, 2025, about 0900 mountain daylight time, an American Champion Aircraft 7GCBC, N342H, was substantially damaged when it was involved in an accident near Big Creek, Idaho. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB ERA25FA179Accident · 4 fatalClass 3 · FieldPreliminary reportCessna 180 · Trilla, ILOn April 19, 2025, at 1016 central daylight time, a Cessna 180G, N4679U, was destroyed when it was involved in an accident near Trilla, Illinois. The private pilot and three passengers were fatally injured. The airplane was operated under Title 14 Code of…NTSB CEN25FA157Accident · 3 fatalClass 3 · FieldPreliminary reportCessna 180 · Fremont, NEOn April 18, 2025, about 2011 central daylight time, a Cessna 180, N2908C, was substantially damaged when it was involved in an accident near Fremont, Nebraska. The pilot and two passengers were fatally injured. The flight was conducted as a Title 14 Code of…NTSB CEN25FA151Accident · 1 fatalClass 3 · FieldPreliminary reportAeronca 7AC · Cape Fair, MOOn April 10, 2025, at 0904 central daylight time, an Aeronca 7AC airplane, N83952, was substantially damaged when it was involved in an accident near Cape Fair, Missouri. The pilot received serious injuries, and the passenger was fatally injured. The airplane…NTSB WPR25FA114Accident · 1 fatalClass 3 · FieldPreliminary reportBell 206B II · Mountain Home Park, WAOn March 19, 2025, at 1228 Pacific daylight time, a Bell 206B II, N23SD, was substantially damaged when it impacted electrical cables and terrain near Mountain Home Park, Washington. The commercial pilot was fatally injured. The helicopter was operated as a…NTSB WPR25FA108Accident · 1 fatalClass 3 · FieldPreliminary reportCessna A150L · Renslow, WAOn March 4, 2025, at 1555 Pacific standard time, a Cessna A150L, N6167F, was destroyed when it was involved in an accident near Renslow, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB CEN25FA106Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV7 · Matheson, COOn March 1, 2025, about 1215 mountain daylight time, a Vans RV7 experimental airplane, N902T, was destroyed when it was involved in an accident near Matheson, Colorado. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code of…NTSB ERA25LA088Accident · No injuriesClass 3 · LimitedPreliminary reportBeech A36 · Naples, FLOn January 1, 2025, at 0120 eastern standard time, a Beech A36, N8163F, was substantially damaged when it was involved in an accident at Naples Municipal Airport (APF), Naples, Florida. The private pilot and three passengers were not injured. The flight was…NTSB ERA25FA086Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 310 · Peebles, OHOn December 30, 2024, about 1515 eastern standard time, a Cessna 310D, N6979T, was substantially damaged when it was involved in an accident near Peebles, Ohio. The commercial pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN25FA040Accident · 1 fatalClass 3 · FieldPreliminary reportBeech 35-B33 · Nunn, COOn November 15, 2024, about 1000 mountain standard time (MST), a Beech 35-B33, N285BW, was destroyed when it was involved in an accident near Nunn, Colorado. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB CEN25FA034Accident · 3 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R44 II · Iowa, LAOn November 1, 2024, about 2106 central daylight time, a Robinson R-44 II helicopter, N62CD, was destroyed when it was involved in an accident near Iowa, Louisiana. The pilot and two passengers were fatally injured. The helicopter was operated as a Title 14…NTSB WPR25LA008Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-36-285 · Marana, AZOn October 8, 2024, about 0745 mountain standard time, a Piper PA-36-285, N9928P, was substantially damaged when it was involved in an accident near Marana, Arizona. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA25FA005Accident · 3 fatalClass 3 · FieldPreliminary reportBell 206L-3 · Owenton, KYOn October 7, 2024, at 1730 eastern daylight time, a Bell 206L3+, N230AE, was destroyed when it was involved in an accident in Owenton, Kentucky. The pilot, a flight nurse, and a flight medic were fatally injured. The helicopter was operated by Air Evac Life…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 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 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 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…