Skip to content

Ongoing NTSB investigations

13 cases where the sequence of events included Low altitude operation/event.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20242026

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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '220' 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

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\" = '220' 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" = '220' 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 ERA27LA017Accident · Minor injuriesClass 4 · LimitedInvestigation openRobinson Helicopter R44 · Kinnelon, NJOct 20, 2026 · N744CJ NTSB WPR26FA354Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172B · Royal City, WAOn September 23, 2026, about 1711 Pacific daylight time, a Cessna 172B, N44P, was substantially damaged when it was involved in an accident near Royal City, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…Sep 24, 2026 · N44P · Substantial damage NTSB WPR26LA312Accident · Serious injuriesClass 3 · LimitedPreliminary reportSchweizer G-164B · Olene, OROn August 20, 2026, about 9:32 Pacific daylight time, a Schweizer Aircraft Corp., G-164B, N7501Q, was destroyed when it was involved in an accident near Orlene, Oregon. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal…Aug 20, 2026 · N7501Q · Destroyed NTSB ANC26LA055Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18 105 · Petersville, AKJun 18, 2026 · N249T · Substantial damage NTSB ANC26LA037Accident · Serious injuriesClass 3 · LimitedPreliminary reportTundrair King · Palmer, AKOn May 5, 2026, about 1950 Alaska daylight time (AKDT), an experimental Tundrair King airplane, N62TK, was destroyed when it was involved in an accident near Palmer, Alaska. The pilot was seriously injured. The airplane was operated as a Title 14 Code of…May 6, 2026 · N62TK · Destroyed NTSB ERA26FA178Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20J · Ironton, OHOn April 17, 2026, about 1414 eastern daylight time, a Mooney M20J, N205MK, was destroyed when it was involved in an accident near Ironton, Ohio. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…Apr 17, 2026 · N205MK · Substantial damage NTSB CEN26LA148Accident · Serious injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 II · Stonewall, TXOn March 24, 2026, about 0930 central daylight time, a Robinson R44 II helicopter, N233JD, was substantially damaged when it was involved in an accident near Stonewall, Texas. The pilot and passenger were seriously injured. The helicopter was operated as a…Mar 24, 2026 · N233JD · Substantial damage NTSB WPR26FA121Accident · 1 fatalClass 3 · FieldPreliminary reportMD Helicopters 369FF · Mojave, CAOn March 9, 2026, about 1517 Pacific daylight time, an MD Helicopters 369FF, N530XX, was destroyed when it was involved in an accident near Mojave, California. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…Mar 9, 2026 · N530XX · Substantial damage NTSB WPR26FA091Accident · 2 fatalClass 3 · FieldPreliminary reportN126c CCX-1865 · Montour, IDOn January 27, 2026, about 1100 mountain standard time, an amateur-built, experimental CCX-1865 Carbon Cub, N126C, was substantially damaged when it was involved in an accident near Montour, Idaho. The pilot and pilot-rated passenger were fatally injured. The…Jan 27, 2026 · N126C · Substantial damage NTSB ERA26FA039Accident · 2 fatalClass 3 · FieldPreliminary reportJabiru USA Sport J230-SP · New Bavaria, OHOn November 14, 2025, at 1708 eastern standard time, a Jabiru USA Sport Aircraft LLC J230-SP, N755J, was substantially damaged when it was involved in an accident near New Bavaria, Ohio. The sport pilot and passenger were fatally injured. The airplane was…Nov 14, 2025 · N755J · Substantial damage NTSB WPR26FA031Accident · 4 fatalClass 3 · FieldPreliminary reportRobinson Helicopter R66 · Ekalaka, MTOn October 22, 2025, about 1830 mountain daylight time, a Robinson Helicopter Co. R66, N67GA, was substantially damaged when it was involved in an accident near Ekalaka, Montana. The pilot and 3 passengers were fatally injured. The helicopter was operated as…Oct 23, 2025 · N67GA · Substantial damage NTSB WPR25LA290Accident · Minor injuriesClass 3 · LimitedPreliminary reportEurocopter EC135 · Whittier, WAOn September 23, 2025, at 2303 Pacific daylight time, a Eurocopter EC-135 T2+, N955AL, was substantially damaged when it was involved in an accident near Whittier, Washington. The pilot and three medical crew members received minor injuries. The helicopter…Sep 24, 2025 · N955AL · Substantial damage NTSB CEN24FA287Accident · 1 fatalClass 3 · FieldPreliminary reportBell 206 · Nashua, IAOn July 29, 2024 about 1330 central standard time, a Bell 206-B3 Helicopter, N94XA, was destroyed when it was involved in an accident near Nashua, Iowa. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal Regulations Part…Jul 29, 2024 · N94XA · Substantial damage