NTSB investigations: Pratt & Whitney R1340 series, 1985, AZ
3 cases on aircraft whose registry engine model is Pratt & Whitney R1340 series. 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
| 1964 | 1 |
|---|---|
| 1965 | 1 |
| 1967 | 2 |
| 1969 | 1 |
| 1971 | 2 |
| 1973 | 1 |
| 1974 | 2 |
| 1976 | 2 |
| 1977 | 3 |
| 1978 | 1 |
| 1980 | 3 |
| 1981 | 2 |
| 1982 | 2 |
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 3 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 1 |
| 1995 | 1 |
| 2001 | 2 |
| 2016 | 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.\"eventStateOrRegion\" = 'AZ' 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 ('52016'))
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."eventStateOrRegion" = 'AZ' 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 ('52016'))
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 LAX85LA374Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Williams Afb, AZAfter making his first swath run,during the hours of darkness,the pilot became disorented and flew into an area with tall electrical transmission lines. He descended into trees beneath the lines in his attempt to miss them.NTSB LAX85LA360Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Tolleson, AZAccording to the pilot,the engine lost partial power while in cruise flt. He selected a cotton field in which to make a precautionary lng. The aircraft over shot the intended landing area and impacted a utility pole. The collision ruptured the fuel system and…NTSB LAX85LA340Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Tucson, AZThe tailwheel equipped acft nosed over after the plt lost iirecitional control during lndg. There were no reports of mechanical difficulties or weather facotrs to be considered in the area of cause. The plts flt experience is unknown since repeated attempts…