OpenAirDocs.org

Interpretation/understanding

Open the Markdown

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

All 10 cases8 in the probable cause
Cases
10
In the probable cause
8 (80%)
Fatal cases
2
NTSB code
02063530

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\", '02063530') 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\", '02063530'))
  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\", '02063530') 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 · 10

NTSB CEN23LA198Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Wichita, KSThe pilot’s failure to maintain a safe taxi distance from a turbine-powered airplane, resulting in an encounter of the turbine-powered airplane’s jet blast while taxiing.May 23, 2023 · N49RH · Substantial damageNTSB DCA22LA015Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer S A ERJ 170-200 LR · Miami, FLAn abrupt jerk of the airplane as the captain applied the parking brake during the tow that caused a flight attendant to fall and break her wrist.Oct 23, 2021 · N252NN · No damageNTSB CEN20CA062Accident · No injuriesData collectionFinal reportBeech 76 · St. Charles, MOThe pilot receiving instruction’s misunderstanding of the flight instructor’s instruction and the pilot's and the instructor’s insufficient use of rudder while adding power to the operating engine, which resulted in the airplane rolling left and the wing…Jan 16, 2020 · N6630D · Substantial damageNTSB ERA19TA133Accident · No injuriesClass 3Final reportCessna 650 · Sanford, FLThe pilot's failure to keep the airplane on the taxiway while taxiing at night. Contributing to the accident was a miscommunication between the flight crewmembers about the position of the airplane.Mar 14, 2019 · N220CM · Substantial damageNTSB OPS17IA010Incident · No injuriesIncident investigationFinal reportBoeing 777 · Mt. Wilson, CAThe incident was caused by the air traffic controller assigning the pilots a left turn instead of the required right turn after departure which placed the aircraft in an unsafe proximity with terrain and obstructions. Contributing to the incident was the air…Dec 16, 2016 · B-16726 · No damageNTSB DCA15CA129Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas DC 9 83(MD-83) · St Petersburg, FLevacuation of the aircraft due to reported, but unverified, aircraft condition and poor communication between Aircraft Rescue and Firefighting personnel and the flight crew.Jun 8, 2015 · N869GA · No damageNTSB 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 · DestroyedNTSB ERA12LA268Accident · No injuriesLimited investigationFinal reportHawker Beechcraft C90GTX · Caribbean Sea, A1A complete loss of engine power due to fuel exhaustion as a result of the pilot's failure to verify that sufficient fuel was onboard prior to flight. Contributing to the accident was the pilot's misreading of the fuel ticket and his improper operation of the…Apr 3, 2012 · N8116L · Substantial damageNTSB ERA11FA401Accident · 1 fatalField investigationFinal reportSlingsby Capstan Type 49B · Hollywood, MDThe glider pilot’s improper response to the “check spoilers” signal from the tow pilot. Contributing to the accident was the glider pilot’s failure to confirm that the spoilers were closed and locked before takeoff, and the glider copilot’s improper crew…Jul 15, 2011 · N7475 · Substantial damageNTSB SEA08CA129Accident · No injuriesData collectionFinal reportSchleicher ASK-21 · Tehachapi, CAThe pilot's inadequate preflight procedures and failure to check the spoiler control position, which resulted in the inadvertent deployment of the spoilers during takeoff. A contributing factor was the pilot's misinterpretation of the tow pilot's instructions.May 10, 2008 · N361KS · Substantial damage
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\", '02063530'))
  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.