NTSB investigations
9 cases where NTSB found Doors, general.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2011 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2018 | 1 |
| 2023 | 1 |
Where
Open the mapLatest 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\", '01035200')) 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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA23LA153Accident · No injuriesClass 4 · LimitedFinal reportGreen Richard H VAN'S RV7A · Williston, FLThe 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 GAA18CA215Accident · No injuriesData collectionFinal reportPage Russell L Long EZ · Wakefield, VAThe 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 CEN15CA011Accident · No injuriesData collectionFinal reportBeech 35-B33 · Effingham, ILThe pilot's failure to lower the landing gear.NTSB CEN13LA340Accident · Serious injuriesLimited investigationFinal reportVans RV12 · Chadron, NEThe 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 CEN12LA071Accident · Serious injuriesLimited investigationFinal reportJuve Richard G Zodiac CH601 HDS · Clinton, ARThe inadvertent opening of the canopy during takeoff due to the improperly repaired forward canopy latch mechanism, which did not fully secure the canopy.NTSB CEN11CA511Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Broomfield, COA loss of control due to the pilot's diverted attention as a result of an open door.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.NTSB 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.NTSB NYC08CA151Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Columbus, GAThe flight instructor's improper decision to abort the takeoff after the cabin door latch opened. Contributing to the accident was the cabin door unlatching.