NTSB investigations: Pratt & Whitney Canada PW118, CA
5 cases on aircraft whose registry engine model is Pratt & Whitney Canada PW118. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1995 | 1 |
|---|---|
| 1996 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2010 | 1 |
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 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"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 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" DESCRun 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 WPR10IA135Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120ER · Los Angeles, CAThe 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 LAX00IA106Incident · No injuriesIncident investigationFinal reportEmbraer 120 · Fresno, CAMoisture contamination of the elevator trim actuator units resulting in their failure to operate at below freezing temperaturesNTSB LAX97FA189Accident · No injuriesField investigationFinal reportEmbraer EMB-120 · San Diego, CAThe 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 LAX97IA056Incident · Minor injuriesIncident investigationFinal reportEmbraer EMB-120ER · Los Angeles, CAa laser light source of unknown origin, directed toward the aircraft, as it was approaching to land.NTSB LAX95LA255Accident · No injuriesLimited investigationFinal reportEmbraer EMB-120 RT · Los Angeles, CAthe 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.