# NTSB investigations, AZ: Doors

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB WPR21LA142](https://openairdocs.org/ntsb/WPR21LA142.md): Davis Dan B Lancair Evolution · Phoenix, AZ · Accident · No injuries · Class 3 · Limited · Final report · Mar 18, 2021 · N469KS · Substantial damage
  > A malfunction of the main cabin door latching mechanism for reasons that could not be determined based on the available information.
- [NTSB GAA17CA344](https://openairdocs.org/ntsb/GAA17CA344.md): Eurocopter EC130 · Peach Springs, AZ · Accident · No injuries · Data collection · Final report · May 25, 2017 · N153GC · Substantial damage
  > The ground crewman’s failure to hold onto the passenger door while the main rotor was still rotating, which resulted in the door separating from the helicopter and damaging the main rotor.
- [NTSB WPR14CA350](https://openairdocs.org/ntsb/WPR14CA350.md): Schweizer SGS 1 34 · Marana, AZ · Accident · Minor injuries · Data collection · Final report · Aug 19, 2014 · N7628 · Substantial damage
  > The pilot's failure to ensure the canopy was locked during the pre-takeoff inspection which led to the canopy opening in flight and the pilot's failure to maintain aircraft control during the subsequent landing.
- [NTSB WPR09LA075](https://openairdocs.org/ntsb/WPR09LA075.md): Czech Aircraft Works Sport Cruiser · Casa Grande, AZ · Accident · No injuries · Limited investigation · Final report · Jan 6, 2009 · N797BS · Substantial damage
  > The 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.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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."eventStateOrRegion" = 'AZ' AND c."eventCountry" = 'USA'
  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
```

This list as a web page: https://openairdocs.org/ntsb-findings/010352/cases?state=AZ

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.
