NTSB investigations, 2009

11 cases where NTSB found Doors.

Cases per year

20082026
NTSB investigations, 2009 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\") = 2009
    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 ERA09CA534Accident · No injuriesData collectionFinal reportAeromot AMT200 · Wheeling, WVThe pilot’s failure to maintain directional control during the landing. Contributing to the accident was the pilot's failure to properly secure the canopy latch which resulted in an in-flight canopy opening.Sep 20, 2009 · N46068 · Substantial damageNTSB ANC09LA088Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot’s decision to make an abrupt and steep low altitude turn just after takeoff, while attempting to return to his departure airport, resulting in an aerodynamic stall and loss of aircraft control. Contributing to the accident was the pilot’s failure to…Aug 25, 2009 · N6073V · Substantial damageNTSB CEN09CA470Accident · No injuriesData collectionFinal reportRaytheon C90A · Bismarck, NDThe cabin entry door inadvertently opening during initial climb.Jul 23, 2009 · N405DD · Substantial damageNTSB CEN09CA386Accident · No injuriesData collectionFinal reportHubbell Prescott Pusher · Ashville, OHA partial loss of engine power due to propeller damage from being struck by the cabin-entry door, which inadvertently opened and departed the airframe for undetermined reasons during flight.Jun 24, 2009 · N19PP · Substantial damageNTSB CEN09CA337Accident · No injuriesData collectionFinal reportCarillon John C Zodiac CH6 · Clinton, ARThe pilot's failure to maintain control of the aircraft during takeoff. Contributing to the accident was his failure to secure a wing fuel panel prior to departure.Jun 4, 2009 · N9093Y · Substantial damageNTSB ANC09CA048Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Birchwood, AKThe failure of maintenance personnel to properly maintain the cargo door latch, resulting in an in-flight opening and separation of the cargo door, and substantial damage to the horizontal stabilator when it was struck by remnants of the cargo door.May 16, 2009 · N8374T · Substantial damageNTSB WPR09LA218Accident · No injuriesLimited investigationFinal reportWeinberg RV-6 · Sparks, NVThe pilot's failure to follow the pre-takeoff checklist that resulted in the canopy opening during takeoff, which created a distraction, and his failure to maintain aircraft control during landing.Apr 26, 2009 · N690V · Substantial damageNTSB WPR09IA187Incident · No injuriesIncident investigationFinal reportLiberty Aerospace Liberty XL-2 · Camarillo, CAThe cruise flight separation of the canopy door. Contributing to the incident was the pilot's failure to ensure that the left side door was securely closed prior to takeoff.Apr 5, 2009 · N519XL · Minor damageNTSB WPR09CA120Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Lincoln, CAThe pilot's failure to extend the landing gear for landing. Contributing to the accident was the pilot's diverted attention due to an open door and the airport's pilot activated runway lights turning off.Feb 20, 2009 · N8816P · Substantial damageNTSB CEN09LA207Accident · No injuriesLimited investigationFinal reportHall Steven C Lancair LE · Longmont, COThe pilot's failure to maintain aircraft pitch control resulting in the airplane impacting the terrain. Contributing to the accident were the pilot's failure to ensure the canopy was fully locked prior to takeoff and the canopy oscillations in flight.Jan 31, 2009 · N939CB · Substantial damageNTSB WPR09LA075Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Sport Cruiser · Casa Grande, AZThe pilot's failure to ensure that the canopy was latched prior to takeoff. Contributing to the accident was the inadequate guidance in the Pilot Operating Handbook regarding canopy procedures.Jan 6, 2009 · N797BS · Substantial damage