NTSB investigations, 2024
12 cases where the sequence of events included Electrical system malf/failure.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 7 |
| 2010 | 7 |
| 2011 | 11 |
| 2012 | 9 |
| 2013 | 6 |
| 2014 | 8 |
| 2015 | 5 |
| 2016 | 14 |
| 2017 | 9 |
| 2018 | 12 |
| 2019 | 13 |
| 2020 | 9 |
| 2021 | 12 |
| 2022 | 11 |
| 2023 | 10 |
| 2024 | 12 |
| 2025 | 12 |
| 2026 | 5 |
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\") = 2024
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") = 2024 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 CEN25LA059Accident · No injuriesClass 3 · LimitedFinal reportCessna 182T · Pearland, TXThe AA-5 pilot’s failure to maintain separation from the 182T during approach and landing, which resulted in a ground collision during the landing roll. Contributing to the accident was the failure of the AA-5’s electrical system, which prevented the AA-5…NTSB DCA24WA310IncidentClass 5 · ForeignMcdonnell Douglas MD83 · Nueva Esparta, VenezuelaNTSB CEN24LA366Accident · No injuriesClass 3 · LimitedFinal reportCessna 172M · Ackerman, MSThe excessive airplane speed during a no-flap landing, and the pilot’s failure to attain a proper touchdown point, which resulted in a runway overrun. Contributing to the accident was the interference of the instrument panel wiring with the flight control…NTSB DCA24WA260IncidentClass 4 · ForeignBoeing 767-322 · Geneva, SwitzerlandNTSB WPR24LA265Accident · Minor injuriesClass 3 · LimitedFinal reportBell 407 · Raft River, IDThe pilot’s misdiagnosis of an erroneous engine instrument indication and his subsequent decision to enter an autorotation, which resulted in a hard landing due to degraded visual cues and low ambient light conditions. Contributing to the accident were the…NTSB ERA24LA337Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-301T · North Myrtle Beach, SCThe pilot’s failure to use the emergency landing gear extension system, resulting in a gear-up landing. Contributing to the accident was an alternator belt failure.NTSB WPR24LA230Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Reno, NVA loss of electrical power for undetermined reasons, which resulted in a partial extension of the landing gear and subsequent landing gear collapse during landing. Contributing to the accident was fuel starvation that resulted in a total loss of engine power.NTSB ERA24LA228Accident · Serious injuriesClass 3 · LimitedFinal reportSchleicher ASH 31 MI · Winter Haven, FLThe pilot’s failure to ensure that a suitable landing area was available in case the restart of the motor glider’s engine was unsuccessful. Contributing, was insufficient battery charge to extend the motor glider’s pylon assembly.NTSB WPR24LA157Accident · No injuriesClass 3 · LimitedFinal reportCessna P210 · Daggett, CAThe pilot’s failure to detect the tripped alternator circuit breaker in flight, which resulted in a drained battery that prevented the landing gear from fully extending to the down-and-locked position. Contributing to the accident was the improperly installed…NTSB WPR24LA109Accident · No injuriesClass 3 · LimitedFinal reportRaytheon B200 · Billings, MTThe pilot's improper engine start, resulting in the engine starters remaining engaged and the generators not being activated, which led to the discharge of the airplane’s battery and subsequent total electrical failure after takeoff. Contributing to the…NTSB DCA24WA093Incident · No injuriesClass 5 · ForeignBoeing 747-400 · Schiphol, NetherlandsNTSB GAA24WA092Accident · Minor injuriesClass 5 · ForeignCessna 560 · Tripoli, Libya