Skip to content

Ongoing NTSB investigations

13 cases where the sequence of events included Fire/smoke (non-impact).

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" = '150' 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\" = '150' 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" = '150' 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 CEN27LA022Accident · Minor injuriesClass 3 · LimitedPreliminary reportConsolidated Aeronautics Lake LA-4-200 · Springfield, MOOn October 19, 2026, about 1703 central daylight time, a Consolidated Aeronautics Inc., Lake LA-4-200 airplane, N117RF, was substantially damaged when it was involved in an accident near Springfield, Missouri. The pilot and pilot-rated passenger received…Oct 19, 2026 · N117RF · Substantial damage NTSB WPR26LA270Accident · No injuriesClass 3 · LimitedPreliminary reportEnstrom F-28F · Malad City, IDOn July 21, 2026, about 0815 mountain daylight time, an Enstrom F-28F helicopter, N8624B, was substantially damaged when it was involved in an accident near Malad City, Idaho. The pilot and pilot-rated passenger were not injured. The helicopter was operated…Jul 21, 2026 · N8624B · Substantial damage NTSB WPR26LA256Accident · No injuriesClass 3 · LimitedPreliminary reportCanadair CF-5D · Mojave, CAOn July 10, 2026, about 1103 Pacific daylight time, a Canadair CF-5D, N845PS, was substantially damaged when it was involved in an accident near Mojave, California. The two pilots onboard were not injured. The airplane was operated as a Title 14 Code of…Jul 10, 2026 · N845PS · Substantial damage NTSB ERA26LA262Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28-161 · Easton, MDJun 29, 2026 · N8394D · Substantial damage NTSB DCA26LA184Incident · No injuriesClass 3 · LimitedPreliminary reportBoeing 787-9 · Los Angeles, CAOn March 2, 2026, at 1100 Pacific Standard Time, United Airlines flight 2127, a Boeing 787-9, registration N24972, powered by two General Electric GEnx™-1B76A/P2 turbofan engines, experienced a No. 1 (left) engine surge during climb from Los Angeles…Mar 2, 2026 · N24972 · No damage NTSB CEN25LA295Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 182P · Bolivar, MOOn July 28, 2025, at about 1800 central daylight time, a Cessna 182P, N8243M, was destroyed when it was involved in an accident near Bolivar, Missouri. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…Jul 28, 2025 · N8243M · Destroyed NTSB CEN25LA205Accident · No injuriesClass 3 · LimitedPreliminary reportLancair 360 · Fort Stockton, TXOn June 11, 2025, about 2145 central daylight time, a Lancair 360 airplane, N77LH, was destroyed when it was involved in an accident near Fort Stockton, Texas. The airline transport pilot was not injured. The airplane was operated as a Title 14 Code of…Jun 12, 2025 · N77LH · Destroyed NTSB DCA25FA159Accident · Minor injuriesClass 3 · FieldPreliminary reportBoeing 737-823 · Denver, COOn March 13, 2025, about 1759 mountain daylight time, American Airlines flight 1006, Boeing 737-823, N885NN, experienced engine vibrations during takeoff from Colorado Springs Airport (COS), Colorado Springs, Colorado. The flight crew continued the takeoff,…Mar 13, 2025 · N885NN · Substantial damage NTSB DCA25FA148Incident · No injuriesClass 3 · FieldPreliminary reportBoeing 767 · Newark, NJOn March 1, 2025, at 0800 eastern standard time, FedEx flight 3609, a Boeing 767-300F, powered by two General Electric CF6-80C2 turbofan engines, registration number N178FE, struck birds during initial climb after takeoff from Newark Liberty International…Mar 1, 2025 · N178FE · Minor damage NTSB WPR25LA045Accident · No injuriesClass 3 · LimitedPreliminary reportBombardier CL-600-2B16 · Jackson, WYOn November 17, 2024, about 0945 mountain standard time, a Bombardier Inc. CL-600-2B16 (Challenger 650), N247QS, was substantially damaged when it was involved in an accident near Jackson, Wyoming. The 2 pilots and 9 passengers were not injured. The airplane…Nov 17, 2024 · N247QS · Substantial damage NTSB WPR25LA025Accident · Minor injuriesClass 3 · LimitedPreliminary reportBadlands Vaquero · West Wendover, NVOn October 27, 2024, about 0915 Pacific daylight time, an experimental amateur-built Badlands Vaquero airplane, N510DH, was destroyed when it was involved in an accident near West Wendover, Nevada. The pilot sustained minor injuries. The airplane was operated…Oct 27, 2024 · N510DH · Substantial damage 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…Oct 5, 2024 · N94100 · Destroyed NTSB CEN24FA353Accident · 1 fatalClass 3 · FieldPreliminary reportHawker Beechcraft G36 · Lafayette, LAOn September 12, 2024, about 1137 central daylight time, a Hawker Beechcraft G36 airplane, N643RS, was destroyed when it was involved in an accident near Lafayette, Louisiana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…Sep 12, 2024 · N643RS · Destroyed