NTSB investigations, 2010
3 cases where the defining event was Electrical system malf/failure.
Cases per year
| 2008 | 9 |
|---|---|
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 6 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 5 |
| 2016 | 9 |
| 2017 | 5 |
| 2018 | 6 |
| 2019 | 13 |
| 2020 | 7 |
| 2021 | 8 |
| 2022 | 9 |
| 2023 | 8 |
| 2024 | 9 |
| 2025 | 6 |
| 2026 | 4 |
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\") = 2010
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '332')
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") = 2010 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '332') 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 WPR10LA432Accident · Minor injuriesLimited investigationFinal reportStinson JR. S · Lake Stevens, WAA total loss of engine power during cruise flight, which resulted from a magneto switch failure.NTSB WPR10CA215Accident · No injuriesData collectionFinal reportPZL-Swidnik PW-5 · Marana, AZThe pilot's inability to find thermal lift. Contributing to the accident was the failure of a computer that provided glide information and vertical speed instrumentation as a result of an improperly routed electrical cable that caused a short in the…NTSB DCA10WA095Incident · No injuriesForeign investigationBoeing 757 · Las Palmas, SpainOn February 17, 2010, at 1555 UTC, a Thompson Airways Boeing 757 experienced pilot and first officer airspeed indicator anomalies during climbout from Gran Canaria Airport (LPA), Las Palmas, Canary Islands, Spain. The event occurred during a period of…