NTSB investigations, 2011
8 cases where NTSB found Glare.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 9 |
| 2010 | 7 |
| 2011 | 8 |
| 2012 | 6 |
| 2013 | 5 |
| 2014 | 6 |
| 2015 | 5 |
| 2016 | 7 |
| 2017 | 7 |
| 2018 | 6 |
| 2019 | 5 |
| 2020 | 5 |
| 2021 | 3 |
| 2022 | 9 |
| 2023 | 1 |
| 2024 | 6 |
| 2025 | 5 |
| 2026 | 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 year(c.\"eventDate\") = 2011
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03036030'))
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 year(c."eventDate") = 2011 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03036030')) 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 WPR12FA067Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Phoenix, AZThe pilot's failure to maintain adequate separation behind a corporate jet, which resulted in an encounter with wake turbulence and a subsequent loss of control.NTSB ERA12CA035Accident · Serious injuriesData collectionFinal reportAmerican Champion 7AC · Berkley, MAThe pilot did not maintain clearance from a tree during the final approach in solar glare conditions.NTSB ANC12CA003Accident · No injuriesData collectionFinal reportPiper PA-18 · Skwentna, AKThe pilot's inadequate clearance from a tree during an off-airport landing.NTSB CEN12FA010Accident · 1 fatalField investigationFinal reportBrinkerhuff Gerald G Q200 · Holland, MIThe pilot failed to maintain sufficient altitude during the landing approach, which resulted in the airplane contacting an approach light. Contributing to the accident was the setting sun, which most likely obscured the pilot’s vision.NTSB WPR11CA397Accident · Minor injuriesData collectionFinal reportCessna 170B · Jefferson, ORThe pilot's failure to maintain clearance from power transmission lines during the landing approach into the sun.NTSB ERA11IA436Incident · No injuriesIncident investigationFinal reportBell 206 · Relience, TNInadvertent contact with wires due to the lack of visual cues regarding their presence and the low angle of the sun, which was directly in the takeoff path.NTSB CEN11CA497Accident · No injuriesData collectionFinal reportGrumman Schweizer G-164A · North English, IAThe pilot's improper flare which resulted in a hard landing.NTSB ERA11CA226Accident · No injuriesData collectionFinal reportCessna U206C · Bridgeport, CTThe pilot's delayed decision to perform a go-around which resulted in a hard landing.