Ongoing NTSB investigations
36 cases where the sequence of events included Collision during takeoff/land.
Cases per year
| 2025 | 12 |
|---|---|
| 2026 | 24 |
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '490' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '490' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN27LA021Accident · 1 fatalClass 3 · LimitedInvestigation openPiper J3C-65 · Boonville, INNTSB WPR27LA004Accident · No injuriesClass 4 · LimitedInvestigation openHead Balloons AX8-88B · Albuquerque, NMNTSB CEN27LA003Accident · No injuriesClass 3 · LimitedInvestigation openSocata TB 9 Tampico · Loveland, CONTSB CEN27LA002Accident · Minor injuriesClass 4 · LimitedInvestigation openPost Thorp T-18 · Brazil, INNTSB WPR27LA009Accident · Serious injuriesLimited investigationInvestigation openCessna 172N · Knights Landing, CANTSB ERA26LA362Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28-140 · Canon, GANTSB WPR26LA361Accident · No injuriesClass 4 · LimitedInvestigation openCessna U206G · Stony River, AKNTSB WPR26LA353Accident · Serious injuriesClass 4 · LimitedInvestigation openCessna 182P · Warren, IDNTSB WPR26LA349Accident · Minor injuriesClass 4 · LimitedInvestigation openCameron Balloons US A-400 · Angwin, CANTSB ANC26FA091Accident · 4 fatalClass 3 · FieldPreliminary reportPiper PA-24-260 · Seldovia, AKOn August 26, 2026 about 1317 Alaska daylight time, a Piper PA-24-260 airplane, N9485P, was substantially damaged when it was involved in an accident near Seldovia, Alaska. The pilot and three passengers were fatally injured. The airplane was operated as a…NTSB ERA26FA310Accident · 1 fatalClass 3 · FieldPreliminary reportDiamond Aircraft Ind DA20-A1 · Bristol, MEOn August 20, 2026, about 1300 eastern daylight time, a Diamond Aircraft Ind Inc DA20-A1, N83RF, was substantially damaged when it was involved in an accident near Bristol, Maine. The pilot was fatally injured, and the pilot-rated passenger sustained minor…NTSB WPR26LA307Accident · Serious injuriesClass 4 · LimitedInvestigation openCirrus Design SF50 · Driggs, IDNTSB WPR26LA296Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 180 · La Center, WAOn August 10, 2026, about 12:55 Pacific daylight time, a Cessna 180, N180DT, was substantially damaged when it was involved in an accident near La Center, Washington. The flight instructor and pilot receiving instruction were seriously injured. The flight was…NTSB ANC26LA082Accident · Minor injuriesClass 4 · LimitedInvestigation openRobinson Helicopter R44 · Macedonia, IANTSB ANC26LA076Accident · No injuriesClass 4 · LimitedInvestigation openCessna 180K · Anchorage, AKNTSB ERA26LA258Accident · Serious injuriesClass 3 · LimitedPreliminary reportPortzline Joan M Flight Star II SC · Mulberry, FLOn July 4, 2026, about 1121 eastern daylight time, an experimental amateur-built Flight Star II SC airplane, N432JP, was substantially damaged when it was involved in an accident near Mulberry, Florida. The private pilot and a passenger were seriously…NTSB CEN26LA239Accident · No injuriesClass 4 · LimitedInvestigation openCessna T206H · Ava, MONTSB ERA26FA241Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 177RG · Morrison, TNOn June 17, 2026, about 1215 central daylight time, a Cessna 177RG, N7637V, was substantially damaged when it was involved in an accident near Morrison, Tennessee. The pilot and pilot-rated passenger were fatally injured. The airplane was operated as a Title…NTSB ANC26LA048Accident · No injuriesClass 4 · LimitedInvestigation openHelio H-295 · Fairbanks, AKNTSB ANC26LA043Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18A 150 · Tyonek, AKNTSB WPR26LA149Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna T-41B · Fort Mohave, AZOn April 7, 2026, about 1300 mountain standard time, a Cessna T-41B, N39ND, was substantially damaged when it was involved in an accident near Fort Mohave, Arizona. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14 Code…NTSB CEN26FA114Accident · 2 fatalClass 3 · FieldPreliminary reportBeech A36 · Murchison, TXOn February 11, 2026, about 1726 central standard time, a Beech A36 airplane, N3215U, sustained substantial damage when it was involved in an accident near Murchison, Texas. The pilot and the pilot-rated passenger sustained fatal injuries. The airplane was…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…NTSB CEN26FA098Accident · 6 fatalClass 2 · FieldPreliminary reportBombardier CL-600-2B16 · Bangor, MEOn January 25, 2026, at 1944 eastern standard time (EST), a Bombardier CL-600-2B16 (Challenger 650) airplane, N10KJ, sustained substantial damage when it was involved in an accident near Bangor, Maine. The pilot, copilot, and 4 passengers were fatally…NTSB ERA26LA056Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-24-180 · South Brooksville, FLOn November 24, 2025, about 1427 eastern standard time, a Piper PA-24-180, N8328P, was substantially damaged during a forced landing near South Brooksville, Florida. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code…NTSB DCA26MA024Accident · 14 fatalClass 1 · MajorPreliminary reportMcdonnell Douglas MD-11F · Louisville, KYOn November 4, 2025, about 1714 eastern standard time (EST), United Parcel Service (UPS) flight 2976, a Boeing (McDonnell-Douglas) MD-11F airplane, N259UP, was destroyed after it impacted the ground shortly after takeoff from runway 17R at Louisville Muhammad…NTSB ERA26LA024Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Somerville, TNOn October 24, 2025, about 1815 central daylight time, a Piper PA-28-140, N3905F, was substantially damaged when it was involved in an accident at Fayette County Airport (FYE), Somerville, Tennessee. The pilot sustained minor injuries. The airplane was…NTSB WPR25LA274Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-23-160 · Santa Teresa, NMOn September 6, 2025, about 1925 mountain daylight time, a Piper PA-23-160, N4085P, was substantially damaged when it was involved in an accident near Santa Teresa, New Mexico. The pilot sustained serious injuries. The airplane was operated as a Title 14 Code…NTSB WPR25LA260Accident · No injuriesClass 3 · LimitedPreliminary reportBell Textron Canada 407 · Lincoln, MTOn August 26, 2025, at about 0100 mountain daylight time, a Bell 407 GTX, N38AJ, was substantially damaged when it was involved in an accident near Lincoln, Montana. The pilot and two passengers were not injured. The helicopter was operated as a Title 14,…NTSB ERA25FA280Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28-181 · Block Island, RIOn July 30, 2025, about 1210 eastern daylight time, a Piper PA-28-181, N961DA, was substantially damaged when it was involved in an accident near Block Island, Rhode Island. The pilot sustained serious injuries, one passenger received minor injuries, and one…NTSB WPR25LA217Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna TR182 · Tuba City, AZOn July 17, 2025, about 1447 mountain standard time, a Cessna TR182, N182KC, was substantially damaged when it was involved in an accident near Tuba City, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB CEN25LA250Accident · No injuriesClass 3 · LimitedPreliminary reportGame Composites GB1 Gamebird · Tarkio, MOOn July 12, 2025, about 0830 central daylight time, a Game Composites GB-1 Gamebird airplane, N588AF, was substantially damaged, and a Vans RV-8, N931KZ, sustained minor damage, when they were involved in an accident near the Gould Peterson Municipal Airport…NTSB WPR25LA204Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech A36 · Coolin, IDOn July 8, 2025, about 1840 Pacific daylight time, a Beech A36, N41VH, was substantially damaged when it was involved in an accident near Coolin, Idaho. The pilot and passenger sustained minor injuries. The airplane was operated under Title 14 Code of Federal…NTSB CEN25FA216Accident · 2 fatalClass 3 · FieldPreliminary reportMurphy Aircraft Manufacturing Moose · Montrose, COOn June 23, 2025, about 1021 mountain daylight time, a Murphy Aircraft Manufacturing Limited Moose airplane, N250MK, was destroyed when it was involved in an accident near Montrose, Colorado. The pilot and the pilot-rated passenger sustained fatal injuries.…NTSB ERA25LA222Accident · Serious injuriesClass 3 · LimitedPreliminary reportDehavilland DHC-6 Twin Otter · Tullahoma, TNOn June 8, 2025, about 1220 central daylight time, a DeHavilland DHC-6 Twin Otter, N166DH, was involved in an accident near Tullahoma, Tennessee. The commercial pilot and five passengers were seriously injured, and 15 passengers were not injured. The flight…NTSB ERA25LA145Accident · 1 fatalClass 3 · LimitedPreliminary reportWild Sky Goat · Chester, CTOn March 14, 2025, about 1515 eastern daylight time, an experimental amateur-built Wild Sky Goat light-sport aircraft, N372WS, was substantially damaged when it was involved in an accident near Chester, Connecticut. The commercial pilot sustained fatal…