Final NTSB investigations, 2011
10 cases where the sequence of events included Electrical system malf/failure.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 7 |
| 2010 | 6 |
| 2011 | 10 |
| 2012 | 8 |
| 2013 | 5 |
| 2014 | 8 |
| 2015 | 5 |
| 2016 | 10 |
| 2017 | 8 |
| 2018 | 10 |
| 2019 | 8 |
| 2020 | 6 |
| 2021 | 7 |
| 2022 | 5 |
| 2023 | 4 |
| 2024 | 8 |
| 2025 | 4 |
| 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '332' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '332' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN12LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Eau Claire, WIThe pilot’s disorientation during a night flight, which resulted in an off-airport landing, and his inadequate directional control during the landing roll. Contributing to the accident was the loss of the airplane’s electrical system power.NTSB ERA12CA028Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Culpeper, VAThe pilot's inadequate knowledge of the airplane's emergency gear extension procedures, which resulted in his failure to successfully perform a manual extension of the landing gear.NTSB ERA11LA502Accident · Serious injuriesLimited investigationFinal reportCessna P210N · South Deerfield, MAThe failure of the electrical system due to an alternator failure during flight in instrument meteorological conditions, and the pilot’s inadequate preflight inspection and failure to use the approved checklist for the dual alternator system. Contributing to…NTSB WPR11LA378Accident · No injuriesLimited investigationFinal reportCessna 210L · Seattle, WAA loss of electrical power while on final approach due to a depleted battery, which resulted in an intentional gear-up emergency landing.NTSB ERA11LA421Accident · No injuriesLimited investigationFinal reportCessna 172S · Lincoln Park, NJThe pilot’s improper touchdown point, resulting in a runway overrun and collision with a guardrail.NTSB WPR11FA248Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Astoria, ORThe student pilot’s failure to maintain adequate airspeed while maneuvering for landing, which resulted in a stall/spin. Contributing to the accident were the pilot's distraction and anxiety from a reported failure of the airplane's electrical system.NTSB ERA11CA255Accident · No injuriesData collectionFinal reportBeech F33A · Ocala, FLThe pilot's improper flare which resulted in a hard landing. Contributing to the accident was the pilot's distracted attention due to the electrical system failure.NTSB CEN11LA311Accident · No injuriesLimited investigationFinal reportMooney M20K · New Orleans, LAA loss of electrical and engine power for undetermined reasons.NTSB DCA11IA040Incident · No injuriesIncident investigationFinal reportAirbus A320 · New Orleans, LAthe captain's failure to properly recognize and manage the abnormal condition, resulting in it escalating to an in-flight emergency.NTSB CEN11LA186Accident · Minor injuriesLimited investigationFinal reportGadbois Eugene W Apex CROSS-5 · Lago Vista, TXThe simultaneous loss of engine and electrical power after takeoff for undetermined reasons.