# NTSB investigations: Doors, general

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 ERA23LA153](https://openairdocs.org/ntsb/ERA23LA153.md): Green Richard H VAN'S RV7A · Williston, FL · Accident · No injuries · Class 4 · Limited · Final report · Jan 31, 2023 · N4811E · Substantial damage
  > The hard landing and subsequent nose over during the forced landing. Contributing to the accident were the improperly secured canopy, and the distraction it created.
- [NTSB GAA18CA215](https://openairdocs.org/ntsb/GAA18CA215.md): Page Russell L Long EZ · Wakefield, VA · Accident · No injuries · Data collection · Final report · Apr 13, 2018 · N27RP · Substantial damage
  > The pilot’s failure to secure the canopy before flight, which resulted in the airplane striking a fence during the approach. Contributing to the accident was the pilot’s failure to follow the Before Takeoff checklist and In-flight Canopy Opening checklist…
- [NTSB CEN15CA011](https://openairdocs.org/ntsb/CEN15CA011.md): Beech 35-B33 · Effingham, IL · Accident · No injuries · Data collection · Final report · Oct 11, 2014 · N718CD · Substantial damage
  > The pilot's failure to lower the landing gear.
- [NTSB CEN13LA340](https://openairdocs.org/ntsb/CEN13LA340.md): Vans RV12 · Chadron, NE · Accident · Serious injuries · Limited investigation · Final report · Jun 11, 2013 · N666BE · Substantial damage
  > The pilot’s failure to properly secure the latch to the tip-up canopy before flight, which resulted in the canopy opening on takeoff and a subsequent loss of airplane control while attempting to land the airplane.
- [NTSB CEN12LA071](https://openairdocs.org/ntsb/CEN12LA071.md): Juve Richard G Zodiac CH601 HDS · Clinton, AR · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 2011 · N274 · Substantial damage
  > The inadvertent opening of the canopy during takeoff due to the improperly repaired forward canopy latch mechanism, which did not fully secure the canopy.
- [NTSB CEN11CA511](https://openairdocs.org/ntsb/CEN11CA511.md): Robinson Helicopter R44 II · Broomfield, CO · Accident · No injuries · Data collection · Final report · Jul 23, 2011 · N915BW · Substantial damage
  > A loss of control due to the pilot's diverted attention as a result of an open door.
- [NTSB ERA09CA534](https://openairdocs.org/ntsb/ERA09CA534.md): Aeromot AMT200 · Wheeling, WV · Accident · No injuries · Data collection · Final report · Sep 20, 2009 · N46068 · Substantial damage
  > The 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.
- [NTSB CEN09LA207](https://openairdocs.org/ntsb/CEN09LA207.md): Hall Steven C Lancair LE · Longmont, CO · Accident · No injuries · Limited investigation · Final report · Jan 31, 2009 · N939CB · Substantial damage
  > The 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.
- [NTSB NYC08CA151](https://openairdocs.org/ntsb/NYC08CA151.md): Piper PA-28-140 · Columbus, GA · Accident · No injuries · Data collection · Final report · Apr 3, 2008 · N1755T · Substantial damage
  > The flight instructor's improper decision to abort the takeoff after the cabin door latch opened. Contributing to the accident was the cabin door unlatching.

## 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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01035200'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/01035200/cases

---
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.