# Fatal NTSB investigations: Windows-windshield system

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 ERA22FA036](https://openairdocs.org/ntsb/ERA22FA036.md): Vans RV4 · Chattahoochee, FL · Accident · 1 fatal · Class 3 · Field · Final report · Oct 31, 2021 · N479JJ · Destroyed
  > The pilot’s failure to properly secure the canopy before takeoff, allowing the canopy to open and then separate in flight, which resulted in the pilot’s failure to maintain control of the airplane for reasons that could not be determined based on the…
- [NTSB ERA19FA265](https://openairdocs.org/ntsb/ERA19FA265.md): Vans RV-12 · Lady Lake, FL · Accident · 1 fatal · Class 3 · Field · Final report · Sep 6, 2019 · N767FS · Destroyed
  > The pilot's loss of pitch control due to the in-flight opening of the canopy for reasons that could not be determined.
- [NTSB ERA19FA170](https://openairdocs.org/ntsb/ERA19FA170.md): Piper PA 30 · Naples, FL · Accident · 1 fatal · Class 3 · Field · Final report · May 11, 2019 · N7650Y · Destroyed
  > Incapacitation of the pilot due to a birdstrike through the windshield in front of the pilot's position, while on approach to land.
- [NTSB WPR18FA131](https://openairdocs.org/ntsb/WPR18FA131.md): American Air Racing Thunder Mustang · Reno, NV · Accident · 1 fatal · Field investigation · Final report · May 2, 2018 · N352BT · Substantial damage
  > The pilot's failure to properly secure the engine coolant pump pulley during recent maintenance, which resulted in a loss of the engine's lubrication, cooling, and propeller control systems, and a forced landing, during which the airplane nosed over.…
- [NTSB DCA18MA142](https://openairdocs.org/ntsb/DCA18MA142.md): Boeing 737 7H4 · Philadelphia, PA · Accident · 1 fatal · Class 1 · Major · Final report · Apr 17, 2018 · N772SW · Substantial damage
  > A low-cycle fatigue crack in the dovetail of fan blade No. 13, which resulted in the fan blade separating in flight and impacting the engine fan case at a location that was critical to the structural integrity and performance of the fan cowl structure. This…
- [NTSB CEN17FA045](https://openairdocs.org/ntsb/CEN17FA045.md): Cessna 340 · Fargo, ND · Accident · 1 fatal · Field investigation · Final report · Dec 1, 2016 · N123KK · Destroyed
  > The loose fuel fitting on the combustion heater that leaked a lean fuel-air mixture into the nose baggage compartment. The mixture was most likely ignited by the combustion heater, blowing off the nose baggage compartment doors and starting an in-flight fire.
- [NTSB CEN14FA306](https://openairdocs.org/ntsb/CEN14FA306.md): Brumwell RV-6 · Sauk Rapids, MN · Accident · 2 fatal · Field investigation · Final report · Jun 21, 2014 · N135BB · Destroyed
  > The pilot’s loss of pitch control due to the in-flight opening of the canopy during cruise flight for reasons that could not be determined because fire damage precluded examination of the airplane’s canopy and systems.
- [NTSB ERA11FA287](https://openairdocs.org/ntsb/ERA11FA287.md): Czech Sport Piper Sport · Spring Hill, FL · Accident · 1 fatal · Field investigation · Final report · May 7, 2011 · N420PS · Substantial damage
  > The pilot's inadvertent application of control inputs that resulted in rapid, right-rolling, negative g-forces during night cruise flight and his subsequent ejection from the airplane. Contributing to the accident was the pilot's decision to fly at night in…
- [NTSB CEN09MA117](https://openairdocs.org/ntsb/CEN09MA117.md): Sikorsky S-76C · Morgan City, LA · Accident · 8 fatal · Major investigation · Final report · Jan 4, 2009 · N748P · Destroyed
  > (1) the sudden loss of power to both engines that resulted from impact with a bird (red-tailed hawk), which fractured the windshield and interfered with engine fuel controls, and (2) the subsequent disorientation of the flight crewmembers, which left them…

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

This list as a web page: https://openairdocs.org/ntsb-findings/010356/cases?fatal=1

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