NTSB investigations, 2010

10 cases where NTSB found Windows-windshield system.

Cases per year

20082026
NTSB investigations, 2010 per year, 2008–2026: 59 cases
20083
20094
201010
20116
20122
20134
20142
20152
20164
20171
20182
20198
20202
20216
20221
20241
20251

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\") = 2010
    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"

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 CEN10CA542Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Standard Cirrus · Moriarty, NMThe inadvertent opening of the cockpit canopy for undetermined reasons.Sep 5, 2010 · N4664 · Substantial damageNTSB ERA10CA461Accident · No injuriesData collectionFinal reportYeager Lancair · McMinnville, TNThe pilot’s failure to properly latch the cockpit canopy prior to takeoff, resulting in his diverted attention and failure to maintain aircraft control.Sep 2, 2010 · N320CY · Substantial damageNTSB ANC10CA078Accident · No injuriesData collectionFinal reportCessna U206F · Aleknagik, AKA bird strike which penetrated the airplane's windscreen.Aug 27, 2010 · N35851 · Substantial damageNTSB CEN10CA481Accident · Serious injuriesData collectionFinal reportOliver A Bruce RV6-A · Trenton, MOThe canopy opening shortly after takeoff due to an inadequate repair and subsequent failure of the canopy latch, resulting in a emergency landing. Contributing to the accident was the lack of available runway remaining for the forced landing.Aug 15, 2010 · N50BU · Substantial damageNTSB CEN10LA420Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Toulin, ILA partial loss of engine power as a result of a cracked cylinder and the reduced visibility due to the oil-covered windshield.Jul 21, 2010 · N45297 · Substantial damageNTSB ENG10IA029Incident · No injuriesIncident investigationFinal reportBoeing 757 · Chantilly, VAThe ignition of the J5 power terminal located on the captain’s No. 1 windshield due to a loose electrical connection between the terminal connector lug and its respective terminal block. The loose connection resulted from a missing lock washer that allowed…May 17, 2010 · N510UA · Minor damageNTSB CEN10LA245Accident · Minor injuriesLimited investigationFinal reportGross Cozy · Pine Bluff, ARThe inadvertent opening of the cockpit canopy during cruise flight for undetermined reasons, which allowed debris to impact and damage the pusher propeller with a resulting total loss of engine power.May 9, 2010 · N144TJ · Substantial damageNTSB ANC10CA031Accident · Minor injuriesData collectionFinal reportPiper PA-31-350 · Eek, AKAn in-flight collisions with two Cackling Geese (Branta Hutchinsii).May 8, 2010 · N77HV · Substantial damageNTSB ERA10IA254Incident · No injuriesIncident investigationFinal reportPiper PA 46-350P · Owensboro, KYA failure of the pilot's side window due to undetected cracking around the lower aft portion of the storm window cutout.Apr 25, 2010 · N46PT · Minor damageNTSB ERA10IA170Incident · No injuriesIncident investigationFinal reportGulfstream American G-1159A · Farmingdale, NYProgressive cracking from an undetermined initiation source, which resulted in the failure of the No. 4 cabin window outer pane, and the subsequent foreign object ingestion to the right engine.Mar 10, 2010 · N155MM · Minor damage