NTSB investigations, FL
7 cases where NTSB found Windows-windshield system.
Cases per year
| 2008 | 1 |
|---|---|
| 2011 | 1 |
| 2019 | 3 |
| 2021 | 1 |
| 2025 | 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.\"eventStateOrRegion\" = 'FL' 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\", '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.
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" = 'FL' 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", '010356')) 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 ERA25LA102Accident · No injuriesClass 4 · LimitedFinal reportDaniel A Robinson High 6 Berkut 540 · Orlando, FLThe pilot’s failure to verify the canopy latches were in the locked position prior to takeoff.NTSB ERA22FA036Accident · 1 fatalClass 3 · FieldFinal reportVans RV4 · Chattahoochee, FLThe 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 ERA19FA265Accident · 1 fatalClass 3 · FieldFinal reportVans RV-12 · Lady Lake, FLThe pilot's loss of pitch control due to the in-flight opening of the canopy for reasons that could not be determined.NTSB ERA19FA170Accident · 1 fatalClass 3 · FieldFinal reportPiper PA 30 · Naples, FLIncapacitation of the pilot due to a birdstrike through the windshield in front of the pilot's position, while on approach to land.NTSB ERA19LA137Accident · No injuriesClass 3 · LimitedFinal reportPilatus PC12 · Fort Lauderdale, FLImproper maintenance of the windshield, which resulted in delamination and in-flight depressurization.NTSB ERA11FA287Accident · 1 fatalField investigationFinal reportCzech Sport Piper Sport · Spring Hill, FLThe 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 ENG08IA011Incident · Minor injuriesIncident investigationFinal reportBoeing B757-200 · West Palm Beach, FLthe arcing of the windshield heat system at the upper, aft (J1) and upper, forward (J4) terminal locations on the first officer's windshield, which caused the inner pane of glass to fracture.