OpenAirDocs.org

Design of document/info

Open the Markdown

NTSB finding · Organizational issues › Development › Design

All 11 cases7 in the probable cause
Cases
11
In the probable cause
7 (64%)
Fatal cases
1
NTSB code
04011020

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\", '04011020') 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\", '04011020'))
  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\", '04011020') 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 · 11

NTSB WPR19FA230Accident · No injuriesClass 3 · FieldFinal reportCessna 560XL · Oroville, CAThe pilot’s failure to release the parking brake before attempting to initiate the takeoff, which produced an unexpected retarding force and airplane nose down pitching moment. Also causal was the flight crew’s delayed decision to abort the takeoff, which…Aug 21, 2019 · N91GY · DestroyedNTSB CEN15MA290Accident · 1 fatalClass 1 · MajorFinal reportAirbus Helicopters AS350B3E · Frisco, COAirbus Helicopters' dual-hydraulic AS350 B3e helicopter's (1) preflight hydraulic check, which depleted hydraulic pressure in the tail rotor hydraulic circuit, and (2) lack of salient alerting to the pilot that hydraulic pressure was not restored before…Jul 3, 2015 · N390LG · DestroyedNTSB WPR13LA396Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Sisters, ORThe pilot's inadequate preflight fuel planning and poor decision-making, which resulted in fuel exhaustion and the subsequent loss of engine power. Contributing to the accident was the lack of documentation describing the limitations of the airplane’s fuel…Sep 2, 2013 · N102HA · Substantial damageNTSB DCA13CA035Accident · Minor injuriesData collectionFinal reportMcdonnell Douglas MD-11F · Memphis, TNthe operator's failure to provide appropriate training and documentation for ground personnel, leading the marshaller to inadvertently guide the airplane into the collision.Dec 26, 2012 · N612FE · Substantial damageNTSB ENG12IA004Incident · No injuriesIncident investigationFinal reportBombardier CL600 2C10 · Atlanta, GAThe Start Operability Bleed Valve (OBV) fuel return adapter-fitting fractured and separated in cyclic fatigue, which allowed fuel to spill onto a hot engine case that ignited the undercowl fire. The OBV fuel adapter-fitting was dropped and the damage reduced…Oct 23, 2011 · N751EV · No damageNTSB ERA11LA507Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-25 · Atlanta, GAThe improper installation of the nose landing gear strut and subsequent collapse of the nose landing gear during landing.Sep 28, 2011 · N344KL · Substantial damageNTSB ENG11IA035Incident · Minor injuriesIncident investigationFinal reportBoeing 757-232 · Atlanta, GAFuel leaking from the fuel flow transmitter that ignited on contact with the engine’s hot cases which resulted in an engine undercowl fire. The fuel leak resulted from the fuel flow transmitter end housing backing off from the main housing, creating a gap…Jun 21, 2011 · N6714Q · No damageNTSB WPR10FA384Accident · Minor injuriesField investigationFinal reportCessna 172 · Roche Harbor, WAThe pilot’s failure to attain an adequate climb airspeed due to his use of flaps for takeoff, and his selection of a runway, which resulted in an uphill, and possibly downwind, takeoff and subsequent collision with a known obstacle. Contributing to the…Aug 6, 2010 · N9730H · Substantial damageNTSB WPR10CA224Accident · No injuriesData collectionFinal reportEvolution Trikes Revo · Eleele, HIA loss of engine power as a result of fuel exhaustion due to the pilot's improper decision to continue the flight after the low fuel warning. Contributing to the accident was the typographical error in the flight manual concerning the unusable fuel quantity.Apr 19, 2010 · N98EV · Substantial damageNTSB DCA10IA021Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A319-131 · Newark, NJA mechanical failure of internal components of the right main landing gear door actuator resulting in the flight crew being unable to fully extend the right main landing gear using the normal and alternate procedures. Contributing to this incident was a…Jan 10, 2010 · N816UA · Minor damage
See all 11 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\", '04011020'))
  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.