Ongoing NTSB investigations, 2024
19 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2024 | 19 |
|---|---|
| 2025 | 60 |
| 2026 | 60 |
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 year(c.\"eventDate\") = 2024
AND c.\"completionStatus\" = 'Ongoing'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' 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 year(c."eventDate") = 2024 AND c."completionStatus" = 'Ongoing' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' 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 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 ERA25FA080Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A36 · East Aurora, NYOn December 19, 2024, at 1122 eastern standard time, a Beech A36, N36WP, was destroyed when it was involved in an accident near East Aurora, New York. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ERA25FA066Accident · 1 fatalClass 3 · FieldPreliminary reportSchleicher ASW24 · Vero Beach, FLOn December 6, 2024, about 1240 eastern standard time, a Schleicher ASW 24 glider, N244RW, was substantially damaged when it was involved in an accident near Vero Beach, Florida. The pilot was fatally injured. The glider was owned by a local soaring club and…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 CEN25FA014Accident · 1 fatalClass 3 · FieldPreliminary reportRans S12 · Church Point, LAOn October 15, 2024, at 1514 central daylight time, a Rans S12S, N912RS, was involved in an accident near Church Point, Louisiana. The airline transport pilot sustained fatal injuries. The airplane was destroyed. The airplane was operated under Title 14 Code…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 ERA25LA002Accident · 1 fatalClass 3 · LimitedPreliminary reportFokker D Viii Replica · Rhinebeck, NYOn October 5, 2024, about 1456 eastern daylight time, an experimental amateur-built Coughlin Fokker D-VIII Replica, N94100, was destroyed when it was involved in an accident near Old Rhinebeck Airport (NY94), Rhinebeck, New York. The commercial pilot was…NTSB WPR25FA002Accident · 1 fatalClass 3 · FieldPreliminary reportTaylor J-2 · Roseburg, OROn October 3, 2024, about 1130 Pacific daylight time, a Taylor J-2 airplane, N19252, was substantially damaged when it was involved in an accident near Roseburg, Oregon. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA25FA001Accident · 1 fatalClass 3 · FieldPreliminary reportBeech 95 · Crystal River, FLOn October 1, 2024, about 1540 eastern daylight time, a Beech 95-B55, N5868S, was destroyed when it collided with terrain near Crystal River, Florida. The private pilot was fatally injured. The personal flight was conducted under the provisions of Title 14…NTSB WPR24FA295Accident · Serious injuriesClass 3 · FieldPreliminary reportPiper PA-24-250 · Hawthorne, CAOn September 6, 2024, at 0036 Pacific daylight time, a Piper PA-24-250, N588CP, was destroyed when it was involved in an accident near Hawthorne, California. The pilot and pilot rated passenger sustained serious injuries. The airplane was operated as a Title…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 ERA24FA326Accident · 1 fatalClass 3 · FieldPreliminary reportSchweizer 269C · West Carthage, NYOn July 27, 2024, about 1242 eastern daylight time, a Schweizer 269C-1, N61486, was substantially damaged when it was involved in an accident near West Carthage, New York. The private pilot was fatally injured. The helicopter was operated as a Title 14 Code…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 ERA24FA262Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA31 · Loudonville, NYOn June 17, 2024, at 0816 eastern daylight time, a Piper PA-31-310, Canadian registration C-GKSI, was destroyed when it was involved in an accident in Loudonville, New York. The airline transport pilot was fatally injured and one person on the ground…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…