Skip to content

Ongoing NTSB investigations

19 cases where the defining event was Ground collision.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20252026

Where

Latest cases

Query with SQL

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" = '200') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = '200')
  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" = '200')
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 ERA27LA024Accident · No injuriesClass 4 · LimitedInvestigation openAeronca 7AC · Waynesville, OHOct 22, 2026 · N2808E · Substantial damage NTSB ERA27FA004Accident · 1 fatalClass 3 · FieldInvestigation openHughes 269B · Lahmansville, WVOct 6, 2026 · N9390F NTSB ERA26LA361Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28-161 · Sarasota, FLSep 26, 2026 · N636FT · Substantial damage NTSB ERA26LA344Accident · No injuriesClass 3 · LimitedPreliminary reportAerospatiale SA 315 · Workmore, GAOn September 18, 2026, at 1604 eastern daylight time, an Aerospatiale SA315B helicopter, N238HA was substantially damaged when it was involved in an accident near Workmore, Georgia. The pilot was not injured. The helicopter was operated as a Title 14 Code of…Sep 18, 2026 · N238HA · Substantial damage NTSB CEN26LA316Accident · No injuriesClass 3 · LimitedPreliminary reportBeech 99 · Belleville, MIOn September 10, 2026, about 1545 eastern daylight time, a Beech 99 airplane, N799CZ, and a Diamond DA20 airplane, N84VV were involved in a ground collision accident at the Willow Run Airport, Belleville, Michigan. N799CZ received minor damage and N84VV…Sep 10, 2026 · N799CZ · 2 aircraft · Minor damage NTSB WPR26LA310Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172P · Gulfport, MSAug 21, 2026 · N5384K · Substantial damage NTSB WPR26LA299Accident · No injuriesClass 4 · LimitedInvestigation openJonker Sailplanes JS3 · Tehachapi, CAAug 8, 2026 · N9172T · 2 aircraft · Substantial damage NTSB WPR26LA274Accident · Serious injuriesClass 3 · LimitedPreliminary reportDehavilland DHC-3 · Eastsound, WAOn July 23, 2026, about 1720 Pacific daylight time, a De Havilland DHC-3 Otter airplane, N709KA, was substantially damaged when it was involved in an accident near Eastsound, Washington. The pilot and two passengers were seriously injured, and eight…Jul 24, 2026 · N709KA · Destroyed NTSB ERA26LA256Accident · No injuriesClass 4 · LimitedInvestigation openEmbraer Executive EMB-500 · Morrisville, NCJul 1, 2026 · N356N · Substantial damage NTSB ERA26LA226Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA44 · Opa-locka, FLJun 2, 2026 · N156WM · Substantial damage NTSB ANC26LA040Accident · No injuriesClass 4 · LimitedInvestigation openDouglas DC3C · Anchorage, AKMay 8, 2026 · N115U · Substantial damage NTSB DCA26LA150Accident · Minor injuriesClass 3 · LimitedInvestigation openBoeing 737-824 · Denver, COMar 6, 2026 · N27213 · Substantial damage NTSB CEN26LA103Accident · No injuriesClass 3 · LimitedPreliminary reportBeech V35B · Odessa, TXOn February 1, 2026, about 1430 central standard time, a Beech V35B, N9AB, and a Piper PA28-140, N6780W, were substantially damaged when they were involved in an accident near Odessa, Texas. None of the occupants, 2 in each airplane, were injured. Both…Feb 1, 2026 · N95AB · 2 aircraft · Substantial damage NTSB CEN26LA096Accident · No injuriesClass 3 · LimitedPreliminary reportHonda HA-420 · Amarillo, TXOn January 16, 2026, at 1154 central standard time, a Honda HA-420 airplane, N949LL, was substantially damaged when it was involved in an accident near Amarillo, Texas. The airline transport pilot and four passengers were uninjured. The airplane was operated…Jan 16, 2026 · N949LL · Substantial damage NTSB ANC26LA009Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-31-310 · Anchorage, AKJan 12, 2026 · N669CW · Substantial damage NTSB CEN26LA045Accident · No injuriesClass 3 · LimitedPreliminary reportCessna TU206F · Muscatine, IAOn November 12, 2025, about 14:10 central standard time, a Cessna TU206F, N37EW, and a Hawker Beechcraft Corp B300, N545KA, were substantially damaged when they were involved in an accident at Muscatine Regional Airport (MUT), Muscatine, Iowa. The pilot and…Nov 12, 2025 · N37EW · 2 aircraft · Substantial damage NTSB WPR26LA047Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172S · Lancaster, CAOn November 9, 2025, about 1205 Pacific daylight time, a Cessna 172S, N5199J, sustained substantial damage when it was involved in an accident near Lancaster, California. The pilot and passengers were not injured. The airplane was operated as a Title 14 Code…Nov 9, 2025 · N5199J · Substantial damage NTSB DCA26FA001Accident · Minor injuriesClass 3 · FieldPreliminary reportBombardier CL-600-2D24 · New York, NYOn October 1, 2025, about 2156 eastern daylight time (EDT), Endeavor Air dba Delta Connection flight 5155, a Mitsubishi Heavy Industries (MHI) RJ CL-600-2D24 (CRJ-900), N902XJ, collided with Endeavor Air dba Delta Connection flight 5047, a MHI RJ CL-600-2D24…Oct 2, 2025 · N902XJ · 2 aircraft · Minor damage NTSB WPR25FA214Accident · 3 fatalClass 3 · FieldPreliminary reportPiper PA-28-180 · West Yellowstone, MTOn July 17, 2025, about 2358 mountain daylight time, a Piper PA-28-180, N7186W, was substantially damaged when it was involved in an accident near West Yellowstone, Montana. The pilot and two pilot rated passengers were fatally injured. The airplane was…Jul 18, 2025 · N7186W · Substantial damage