NTSB investigations: Pratt & Whitney R1340 series, 1985, AR
5 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
| 1966 | 1 |
|---|---|
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 3 |
| 1975 | 14 |
| 1976 | 8 |
| 1977 | 9 |
| 1978 | 8 |
| 1979 | 12 |
| 1980 | 9 |
| 1981 | 10 |
| 1982 | 5 |
| 1983 | 2 |
| 1984 | 12 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 3 |
| 1988 | 13 |
| 1989 | 5 |
| 1990 | 8 |
| 1991 | 4 |
| 1992 | 7 |
| 1993 | 7 |
| 1994 | 7 |
| 1995 | 6 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 3 |
| 1999 | 2 |
| 2000 | 1 |
| 2002 | 1 |
| 2004 | 2 |
| 2005 | 4 |
| 2006 | 1 |
| 2007 | 4 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 4 |
| 2011 | 4 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2023 | 1 |
| 2024 | 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\" = 'AR' 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" = 'AR' 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 MKC85LA151Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Paragould, ARThe acft was being used in aerial application of ordram when engine failed. A hard landing resulted during the forced landing in an open fld. Investigation revealed the float needle seat ass'y backed out of the threads in the main body of the carburetor FAR…NTSB MKC85LA123Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paragould, ARPilot was seeding rice when the engine failed. Pilot attempted forced landing on gravel road and impacted a utility pole before touchdown. Acft destroyed by impact and post impact fire. The reason for the engine failure could not be determined.NTSB MKC85LA125Accident · No injuriesLimited investigationFinal reportSnow AT301 · Marianna, ARAfter departing the ag strip the plt rptd a vibrating engine which shook violently until finally quitting. The plt responded with an emergency landing attempt to a plowed bean field. The acft impacted the soft terrain at a high rate of speed where the acft…NTSB MKC85LA107Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Harrisburg, ARPlt reports that the lt wing of N4017N hit a dike in a ricefield while he was making a trim swath. There were no indications of equipment malfunction.NTSB MKC85LA068Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Bradley, ARThe plt said that after liftoff the acft encountered a gust of wind and the acft swerved off the airstrip into rough terrain.