# NTSB investigations: Pratt & Whitney Canada PW118, CA

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 WPR10IA135](https://openairdocs.org/ntsb/WPR10IA135.md): Embraer EMB-120ER · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Feb 16, 2010 · N226SW · Minor damage
  > The flight crew’s failure to maintain clearance from the jet bridge during taxi. Contributing to the incident was the ramp marshaller's diverted attention and failure to signal the flight crew to stop at the correct position.
- [NTSB LAX00IA106](https://openairdocs.org/ntsb/LAX00IA106.md): Embraer 120 · Fresno, CA · Incident · No injuries · Incident investigation · Final report · Feb 21, 2000 · N566SW · No damage
  > Moisture contamination of the elevator trim actuator units resulting in their failure to operate at below freezing temperatures
- [NTSB LAX97FA189](https://openairdocs.org/ntsb/LAX97FA189.md): Embraer EMB-120 · San Diego, CA · Accident · No injuries · Field investigation · Final report · May 21, 1997 · N198SW · Substantial damage
  > The failure of maintenance personnel to allow adequate time for the engine oil to drain back into the engine oil reservoir prior to adding additional oil, thereby overfilling the reservoir, which resulted in an engine fire and subsequent damage to hydraulic…
- [NTSB LAX97IA056](https://openairdocs.org/ntsb/LAX97IA056.md): Embraer EMB-120ER · Los Angeles, CA · Incident · Minor injuries · Incident investigation · Final report · Nov 30, 1996 · N291SW · No damage
  > a laser light source of unknown origin, directed toward the aircraft, as it was approaching to land.
- [NTSB LAX95LA255](https://openairdocs.org/ntsb/LAX95LA255.md): Embraer EMB-120 RT · Los Angeles, CA · Accident · No injuries · Limited investigation · Final report · Jul 18, 1995 · N268UE · Substantial damage
  > the captain's decision to taxi across a non-movement aircraft parking area instead of using the designated taxi lane to exit the ramp. A factor in the accident was the dark night environmental lighting conditions.

## 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" = 'CA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52116'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=52116&state=CA

---
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.