# NTSB investigations, NJ: Electrical power system

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ERA11LA421](https://openairdocs.org/ntsb/ERA11LA421.md): Cessna 172S · Lincoln Park, NJ · Accident · No injuries · Limited investigation · Final report · Jul 23, 2011 · N869BC · Substantial damage
  > The pilot’s improper touchdown point, resulting in a runway overrun and collision with a guardrail.
- [NTSB DCA10IA021](https://openairdocs.org/ntsb/DCA10IA021.md): Airbus Industrie A319-131 · Newark, NJ · Incident · Minor injuries · Incident investigation · Final report · Jan 10, 2010 · N816UA · Minor damage
  > A mechanical failure of internal components of the right main landing gear door actuator resulting in the flight crew being unable to fully extend the right main landing gear using the normal and alternate procedures. Contributing to this incident was a…
- [NTSB DCA08IA033](https://openairdocs.org/ntsb/DCA08IA033.md): Airbus A320 · Newark, NJ · Incident · No injuries · Incident investigation · Final report · Jan 25, 2008 · N462UA · No damage
  > a fault in the airplane's AC 1 electrical bus that caused a number of other electrical busses on the aircraft to lose power.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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 c."eventStateOrRegion" = 'NJ' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010224'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/010224/cases?state=NJ

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.
