NTSB investigations, 2012
6 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\") = 2012
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") = 2012 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 WPR13LA060Accident · No injuriesLimited investigationFinal reportPiper PA30 · Phoenix, AZThe pilot's failure to properly inhibit the landing gear transmission motor consistent with the emergency landing gear extension procedure, which precluded the full extension of the landing gear. Contributing to the accident was the airplane's electrical…NTSB WPR12LA402Accident · Serious injuriesLimited investigationFinal reportHansen HANSEN-VANS RV-6 · Lemolo Lake, ORAn overvoltage event due to the failure of the automotive voltage regulator, which resulted in electrical anomalies and smoke in the cockpit and a subsequent forced off-airport landing.NTSB DCA12WA127Incident · No injuriesForeign investigationBoeing 747-400 · London, United KingdomThe United Kingdom's Air Accidents Investigations Branch (AAIB), has notified the NTSB of an accident involving a Boeing 747-400 that occurred on August 17, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB CEN12LA389Accident · No injuriesLimited investigationFinal reportHoyle Fighter Escort Wings · Pueblo, COAn internal failure of one of the electrical system’s two batteries combined with the inadequate electrical system design, which resulted in a total loss of engine power.NTSB ERA12FA280Accident · 1 fatalField investigationFinal reportManzitto Michael A Mwlancair 235 · Hudson, KYThe pilot's decision to operate the airplane with known electrical system problems, which resulted in the in-flight failure of the electrical wiring interconnect system, loss of electrical power, and subsequent fuel starvation and loss of engine power.NTSB CEN12LA220Accident · No injuriesLimited investigationFinal reportCirrus Design SR22T · Addison, TXMaintenance personnel’s improper maintenance, which resulted in the incorrect wiring of the No. 1 alternator and a subsequent electrical system fire during taxi. Contributing to the accident was the airplane manufacturer's inadequate maintenance documentation…