OpenAirDocs.org

Communication (personnel), general

Open the Markdown

NTSB finding · Personnel issues › Task performance › Communication (personnel)

All 17 cases11 in the probable cause
Cases
17
In the probable cause
11 (65%)
Fatal cases
4
NTSB code
02063500

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\", '02063500') 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.

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\", '02063500'))
  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\", '02063500') 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 · 17

NTSB CEN26LA260Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Emerson, IAThe failure of the pilot to verify the loading hose had been disconnected before taking off and the failure of the loader to disconnect the fuel hose from the helicopter.Jul 20, 2026 · N224RH · Substantial damageNTSB CEN20CA100Accident · Minor injuriesData collectionFinal reportCommander 114 · Coldwater, MIThe flight instructor’s inadequate communication with the pilot under review about his intention to simulate a single-engine failure and his subsequent exceedance of the airplane’s critical angle of attack when the pilot did not respond as expected, which…Feb 22, 2020 · N374JW · Substantial damageNTSB WPR19TA110Accident · Serious injuriesClass 3Final reportKubicek BB100 · St. Helena, CAThe balloon pilot's encounter with unforecasted wind, which resulted in his decision to land in unsuitable terrain and a subsequent hard landing. Contributing to the severity of passenger injury was the pilot’s failure to provide a proper safety briefing.Apr 14, 2019 · N355WC · Minor damageNTSB ERA18LA109Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Palatka, FLBoth pilots’ and the flight instructor’s failure to identify, see, and avoid the other airplane, which resulted in a midair collision.Mar 16, 2018 · N486DA · 2 aircraft · Substantial damageNTSB ERA18LA091Accident · Serious injuriesLimited investigationFinal reportHughes 369 · San Juan, PRThe helicopter pilot's improper decision to use an open-end grapple, instead of an A-frame attachment, to lift and move a ladder with a lineman on it and the lineman's improper decision to be lifted on a ladder via an open-end grapple, which were contrary to…Jan 11, 2018 · N571HH · No damageNTSB CEN17LA121Accident · No injuriesLimited investigationFinal reportBeech C90A · Rattan, OKThe loss of electrical power due to the pilot’s inadvertent selection of the engine start switches and the subsequent fuel exhaustion to the left engine as the pilot attempted to locate visual meteorological conditions. Contributing to the accident were the…Feb 14, 2017 · N1551C · Substantial damageNTSB GAA16CA527Accident · No injuriesData collectionFinal reportSwearingen SA226 · Farmingdale, NYThe pilot-in-command’s failure to extend the landing gear before landing and his failure to use the Before Landing checklist. Contributing to the accident was the pilots’ failure to maintain a sterile cockpit during landing.Jun 20, 2016 · N127WD · Substantial damageNTSB ERA16FA133Accident · 2 fatalField investigationFinal reportCessna 340 · Tampa, FLThe intentional low altitude maneuvering during takeoff in response to a near-miss with an airplane departing from a converging runway, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.Mar 18, 2016 · N6239X · DestroyedNTSB ERA14FA192Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Hugheston, WVThe pilot's loss of airplane control while operating in instrument flight rules conditions.Apr 11, 2014 · N39965 · DestroyedNTSB ERA13FA105Accident · 3 fatalField investigationFinal reportBeech H35 · Palm Coast, FLA total loss of engine power after the failure of the No. 4 connecting rod due to oil starvation, which resulted in a subsequent forced landing. Contributing to the accident was the pilot’s failure to clearly state that the aircraft had lost all power and the…Jan 4, 2013 · N375B · Destroyed
See all 17 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\", '02063500'))
  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.