OpenAirDocs.org

Physical workspace

Open the Markdown

NTSB finding section · Environmental issues › Task environment

All 70 cases45 in the probable cause
Cases
70
In the probable cause
45 (64%)
Fatal cases
15
NTSB code
030410

NTSB has coded findings and defining events since 2008. Earlier cases used its older occurrence and cause codes, so they aren’t counted here.

When and where

In green, cases where NTSB made it part of the probable cause; in gray, a factor or other finding. Findings are coded with the final report, often a year or more after the event, so the latest years are incomplete.

Cases per year

2008In the probable causeFactor only2026

Where

Open the map
Query with SQL
duckdb -csv -c "SELECT year(c.\"eventDate\") AS year, count(DISTINCT f.case_mkey) AS cases,
    count(DISTINCT f.case_mkey) FILTER (WHERE f.\"inProbableCause\") AS in_probable_cause
  FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = f.case_mkey
  WHERE starts_with(f.\"findingCode\", '030410') AND c.\"eventDate\" >= DATE '2000-01-01'
  GROUP BY 1
  ORDER BY 1"

Prints the counts as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

Subsections · 10

Query with SQL
duckdb -csv -c "SELECT left(f.\"findingCode\", 8) AS code, max(f.\"tier4Name\") AS name,
    count(DISTINCT f.case_mkey) AS cases,
    count(DISTINCT f.case_mkey) FILTER (WHERE f.\"inProbableCause\") AS in_probable_cause
  FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f
  WHERE starts_with(f.\"findingCode\", '030410') AND f.\"findingCode\" GLOB '[0-9][0-9]*'
  GROUP BY 1
  ORDER BY cases DESC, code"

Prints the counts as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

In the same cases

Defining events
Aircraft models

Aircraft matched to the registry by N-number and date.

Other findings
Query with SQL
duckdb -csv -c "WITH matched AS (SELECT DISTINCT case_mkey, aircrafts_position FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' WHERE starts_with(\"findingCode\", '030410'))
  SELECT * FROM (
  SELECT 'Defining event' AS kind, e.\"tier2Number\" AS code, max(e.\"eventTier2Name\") AS name, count(DISTINCT f.case_mkey) AS cases
  FROM matched f JOIN 'https://openairdocs.org/data/latest/ntsb_events.parquet' e ON e.case_mkey = f.case_mkey AND e.aircrafts_position = f.aircrafts_position AND e.\"isDefiningEvent\"
  WHERE e.\"tier2Number\" <> ''
  GROUP BY ALL
  UNION ALL
  SELECT 'Aircraft model', a.aircraft_model_code, any_value(concat_ws(' ', m.manufacturer, m.model)), count(DISTINCT f.case_mkey)
  FROM matched f JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = f.case_mkey AND a.position = f.aircrafts_position
  LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = a.aircraft_model_code
  WHERE a.aircraft_model_code IS NOT NULL
  GROUP BY ALL
  UNION ALL
  SELECT 'Other finding', left(g.\"findingCode\", 8), max(g.\"tier4Name\"), count(DISTINCT g.case_mkey)
  FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' g
  WHERE g.case_mkey IN (SELECT case_mkey FROM matched) AND NOT starts_with(g.\"findingCode\", '030410') AND g.\"findingCode\" GLOB '[0-9][0-9]*'
  GROUP BY ALL
  )
  QUALIFY row_number() OVER (PARTITION BY kind ORDER BY cases DESC) <= 10
  ORDER BY kind, cases DESC"

Prints the counts as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

Newest cases · 70

NTSB WPR26LA059Accident · No injuriesClass 4 · LimitedFinal reportWaco RNF · Phoenix, AZThe biplane pilot’s failure to maintain adequate clearance from the low-wing airplane while taxiing.Dec 14, 2025 · N110Y · 2 aircraft · Substantial damageNTSB DCA25LA308Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Canada BD500 · Denver, COUnidentified burned debris in an aft galley oven, which generated smoke and odor in the cabin and led to an air turnback and subsequent evacuation, during which a serious injury occurred.Aug 31, 2025 · C-GYLQ · No damageNTSB CEN25LA316Accident · Serious injuriesClass 4 · LimitedFinal reportXag P100 PRO · Depew, IAThe pilot’s failure to maintain clearance from the unmanned aircraft system during takeoff.Aug 12, 2025 · N467GE · Substantial damageNTSB DCA25LA185Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Houston, TXSerious Injury to a flight attendant sustained during an evacuation.Apr 17, 2025 · N7724A · No damageNTSB CEN24LA137Accident · No injuriesClass 3 · LimitedFinal reportEnstrom Helicopter 280C · Port Lavaca, TXThe pilot’s improper manual engine mixture management which resulted in a loss of power. Contributing to the accident was the mechanic’s improper setting of the idle mixture adjustment and the pilot’s decision to take off with a known mechanical deficiency.Mar 16, 2024 · N280WR · Substantial damageNTSB CEN24LA097Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Kenosha, WIThe pilot’s failure to maintain control of the helicopter while landing.Jan 21, 2024 · N8350M · Substantial damageNTSB CEN23FA315Accident · 1 fatalClass 3 · FieldFinal reportCessna 150 · Houston, TXThe student pilot’s loss of airplane control in dark night conditions.Jul 23, 2023 · N17043 · Substantial damageNTSB CEN23LA202Accident · No injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Wright, LAThe pilot's decision to takeoff with the airplane overloaded which resulted in the airplane settling and subsequently impacting terrain.May 25, 2023 · N6699Q · Substantial damageNTSB DCA23LA114Accident · No injuriesClass 4 · LimitedFinal reportBombardier CL-600-2D24 · New York, NYITA Airways flight crew's incorrect evaluation of the clearance between their airplane and another airplane stopped on an adjoining taxiway.Jan 2, 2023 · N928XJ · 2 aircraft · Substantial damageNTSB CEN22FA331Accident · 2 fatalClass 3 · FieldFinal reportColumbia Helicopters CH-47D · North Fork, IDThe failure of the flight crew to properly secure a company-issued iPad, leading to its migration into and jamming of the copilot’s left pedal, preventing the pilot from arresting a left yaw, and resulting in a loss of control.Jul 21, 2022 · N388RA · Destroyed
See all 70 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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030410'))
  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.