NTSB investigations: Pratt & Whitney R1340 series, 1985
4 cases on aircraft whose registry engine model is Pratt & Whitney R1340 series, where the first occurrence was “Loss of engine power(partial) - mech failure/malf”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 7 |
| 1985 | 4 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 3 |
| 1990 | 5 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 6 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 3 |
| 1998 | 2 |
| 2000 | 2 |
| 2001 | 2 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2007 | 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 year(c.\"eventDate\") = 1985
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52016')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 352))
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") = 1985
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52016')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 352))
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 CHI85LA373Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Irwin, OHAt an alt of aprx 20 ft AGL after takeoff, the #1 cylinder failed. A straight ahead landing was made in a corn field during which the acft was destroyed. The eng had under gone a major overhaul 197 hrs prior to this accident.NTSB CHI85LA360Accident · No injuriesLimited investigationFinal reportSchweizer G164A "450" · Constantine, MIThe acft nosed over during a forced landing in a corn fld. The plt stated that at 30 ft AGL during his second swath run the eng backfired and lost pwr. He attempted to dump the load however, the acft continued to loose alt and the forced landing resulted.…NTSB FTW85LA294Accident · No injuriesLimited investigationFinal reportNorth American AT-6 · Port Isabel, TXThe acft was substantially damaged when it undershot the runway and cartwheeled during an emergency landing following an engine failure in the traffic pattern. The plt reported that initial examination of the engine revealed that initial examination of the…NTSB LAX85LA250Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Colusa, CADuring an ag flight, the eng began to severly backfire & lose power. The plt attempted to make a forced ldg on the nearby duster airstrip but had insufficient altitude to be properly aligned with the rwy. The acft overan the edge of the end disclosed that its…