Skip to content

NTSB investigations, 2016

14 cases where the sequence of events included Electrical system malf/failure.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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") = 2016 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

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\") = 2016
    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") = 2016
  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 CEN17LA066Accident · Serious injuriesLimited investigationFinal reportGosselin Charles Glastar · Lee's Summit, MOPartial failure of the electric system due to a battery short, which resulted in a total loss of engine power.Dec 31, 2016 · N120CG · Substantial damage NTSB ANC17LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-300 · McGrath, AKThe failure of the nose landing gear to extend and lock due to the failure of the alternator and reduced battery power due to the cold ambient temperature, which prohibited the electrically-driven hydraulic pump from supplying adequate hydraulic pressure to…Nov 21, 2016 · N4352F · Minor damage NTSB ERA16LA299Accident · Serious injuriesLimited investigationFinal reportProgressive Aerodyne Searey · Sebring, FLA disconnected ground wire during initial climb, which degraded the fuel boost pumps’ performance and resulted in a total loss of engine power due to fuel starvation.Aug 23, 2016 · N801SR · Substantial damage NTSB WPR16LA164Accident · Minor injuriesLimited investigationFinal reportZenith CH601 · Ocean Shores, WAA reduction in electrical power, which disabled both fuel pumps and resulted in fuel starvation and a loss of engine power.Aug 12, 2016 · N619LD · Substantial damage NTSB CEN16LA356Accident · No injuriesLimited investigationFinal reportCessna P210N · Waco, TXThe failure of the right main landing gear (MLG) down-lock mechanism, which resulted in the collapse of the landing gear. The root cause of the right MLG down-lock mechanism could not be determined because the components were not available for examination.Aug 5, 2016 · N323DC · Substantial damage NTSB ERA16FA269Accident · 1 fatalField investigationFinal reportYakovlev YAK11 · West Mifflin, PAA malfunction of the electrical system, which resulted in an electrical fire in the right wing root of the airplane, which compromised the fuel system and resulted in ignition of fuel. Contributing to the accident was the routing of the electrical wiring near…Jul 25, 2016 · N5940 · Substantial damage NTSB CEN16LA270Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Weatherford, TXAn electrical system malfunction for reasons that could not be determined, and the subsequent loss of engine power due to the loss of the electrical boost pumps. Also causal was the pilot's improper emergency action following the loss of engine power due to…Jul 19, 2016 · N2644F · Substantial damage NTSB WPR16LA127Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Seattle, WAThe pilot’s failure to use the emergency procedures checklist for generator failures or for gear extension following a loss of electrical power due to the separated flag terminal of a diode in overstress, which resulted in a gear-up landing.Jun 2, 2016 · N301DM · Substantial damage NTSB DCA16WA166Incident · No injuriesForeign investigationEmbraer ERJ190 · Boston, MATransport Safety Board (TSB) of Canada has notified the NTSB of an accident involving a EMBRAER ERJ190 airplane that occurred on May 25, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the…May 25, 2016 · C-FHOS · Minor damage NTSB CEN16WA398Accident · Serious injuriesForeign investigationCirrus SR22 · Ailly-sur-Somme, FranceMay 16, 2016 · N19BV · Destroyed NTSB CEN16WA179Accident · No injuriesForeign investigationSwearingen SA 226T · Andorra, Lleida, Spain, SpainOn April 26, 2016, about 1535 hours universal coordinated time, a Swearingen SA-226T airplane, United States registration N125WG, was substantially damaged during landing at the Andorra – La Seu d'Urgell Airport (LESU); Andorra, Lleida, Spain. The airplane…Apr 26, 2016 · N125WG · Substantial damage NTSB CEN16LA167Accident · No injuriesLimited investigationFinal reportProbst Zenair 601XL · Hempstead, TXA loose output connection from the generator voltage regulator, which resulted in a loss of power to the electronic ignition system, a total loss of engine power, and a subsequent forced landing, during which the airplane impacted a sign pole.Apr 24, 2016 · C-GXLP · Substantial damage NTSB CEN16WA150Incident · No injuriesForeign investigationRobinson R22 Beta · Bern, SwitzerlandOn April 6, 2016, about 1330 Universal Coordinated Time (UTC), the crew of a Robinson R22 BETA, Swiss registration HB-ZGO, made a precautionary landing at Bern Airport (LSZB), Bern, Switzerland, after they smelled smoke. They noted the alternator had failed…Apr 6, 2016 · HB-ZGO · Minor damage NTSB ERA16LA135Accident · No injuriesLimited investigationFinal reportCessna 210L · Myrtle Beach, SCA complete loss of electrical power, which resulted from the separation of an alternator wire due to corrosion. Contributing to the accident was the failure of the emergency landing gear extension system due to a lack of hydraulic fluid, which resulted in…Mar 19, 2016 · N59196 · Substantial damage