NTSB investigations, 2015

9 cases where NTSB found Doors.

Cases per year

20082026
NTSB investigations, 2015 per year, 2008–2026: 112 cases
200812
200911
201011
20117
20127
20135
20147
20159
20169
20176
20184
20192
20202
20215
20224
20232
20244
20253
20262

Latest 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 year(c.\"eventDate\") = 2015
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010352'))
  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.

NTSB ERA16LA078Accident · Serious injuriesLimited investigationFinal reportPiper PA-46 · Corinth, MSThe pilot's inadequate preflight inspection and his subsequent failure to maintain airplane control, which resulted in an access door opening after takeoff, and the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.Dec 24, 2015 · N891CR · Substantial damageNTSB ERA16FA064Accident · 3 fatalField investigationFinal reportBeech A36 · Farmington, PAThe pilot's failure to maintain control of the airplane after a cabin door came open in flight, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's misuse of…Dec 11, 2015 · N72054 · DestroyedNTSB GAA16CA060Accident · No injuriesData collectionFinal reportBeech 56 · Hudson, COThe pilot's failure to maintain directional control during the landing. Contributing to the accident was the distraction of the open cabin door.Nov 22, 2015 · N12WB · Substantial damageNTSB WPR16LA023Accident · No injuriesLimited investigationFinal reportThorp T 18 · Independence, ORA separation of the canopy mechanism during flight, which resulted in the pilot’s precautionary landing and the airplane’s subsequent collision with a fence post.Nov 6, 2015 · N1488 · Substantial damageNTSB GAA15CA295Accident · No injuriesData collectionFinal reportBeech V35B · Houston, TXThe pilot's failure to properly secure the cabin door prior to takeoff, resulting in the door opening during takeoff, an aborted takeoff, runway overrun, and collision with terrain.Sep 30, 2015 · N800JT · Substantial damageNTSB CEN15FA386Accident · 1 fatalField investigationFinal reportBarrow Ted A ONE Easy · Battle Creek, MIThe pilot’s loss of airplane control due to his diverted attention to the canopy opening in flight.Aug 28, 2015 · N227TB · DestroyedNTSB ERA15LA292Accident · No injuriesLimited investigationFinal reportIsrael Aircraft Industries 1125 Westwind Astra · Baltimore, MDThe flight crew's failure to visually ensure that the cabin door locking pin was in place before takeoff.Jul 24, 2015 · N765A · Substantial damageNTSB ERA15FA245Accident · 1 fatalField investigationFinal reportCzech Sport Piper Sport · Holly Ridge, NCThe pilot’s failure to maintain airplane control after the cockpit canopy opened during initial climb. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.Jun 21, 2015 · N35EP · Substantial damageNTSB ERA15LA130Accident · Serious injuriesLimited investigationFinal reportRobertson James F Velocity STD/RG E · Sebastian, FLThe pilot’s loss of airplane control after takeoff, which resulted in collision with terrain. Contributing to the accident was the pilot’s failure to properly secure the cabin door and trim the airplane for takeoff, which resulted in the cabin door opening…Feb 13, 2015 · N112TH · Substantial damage