NTSB investigations: Pratt & Whitney R1340 series, 1983, LA
6 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 |
| 1966 | 1 |
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 3 |
| 1970 | 3 |
| 1972 | 2 |
| 1973 | 3 |
| 1974 | 2 |
| 1975 | 6 |
| 1976 | 2 |
| 1977 | 5 |
| 1978 | 4 |
| 1979 | 5 |
| 1980 | 2 |
| 1981 | 2 |
| 1982 | 4 |
| 1983 | 6 |
| 1984 | 5 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 4 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 3 |
| 1999 | 1 |
| 2000 | 4 |
| 2001 | 1 |
| 2002 | 4 |
| 2003 | 2 |
| 2004 | 4 |
| 2005 | 2 |
| 2007 | 1 |
| 2008 | 3 |
| 2009 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 2 |
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\") = 1983
AND c.\"eventStateOrRegion\" = 'LA' 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") = 1983
AND c."eventStateOrRegion" = 'LA' 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 FTW83LA446Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Napoleonville, LAThe acft dragged a wing in the sugarcane crop during a start of a swath run. According to the operator the plt was looking at a map as he approached the run. After the wing dragged the acft yawed 90 degrees and settled into the crop. The engine and right main…NTSB FTW83LA402Accident · No injuriesLimited investigationFinal reportGrumman G-164B · North Lacassine, LAThe plt reported that during the landing, the left wing struck tall grass at the side of the strip & the acft swerved to the left. He tried to correct the situation by applying right braking action, but his braking was ineffective on wet grass. Subsequently,…NTSB FTW83LA366Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Jennings, LAThe acft nosed over during a forced landing after the engine quit shortly after takeoff. The main landing gear mired in soft plowed earth and the acft nosed over during landing. The takeoff gross weight was 5290 lbs. After the accident the engine tear down…NTSB FTW83LA267Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Kinder, LAThe acft collided with a tree and a levee during takeoff. The plt said the wind had shifted before or during takeoff andthe acft at rotation felt as if it stalled. The acft failed to clear a small tree and then was forced into a levee. The acft nosed over…NTSB FTW83LA239Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hayes, LAThe acft ran off the rt side of the rwy and collided with a dirt embankment drng lndg roll. Brake fluid was found on the l main gear following the accd. Investigation revealed the source of the leak to be a popped o-ring in the brake actuating cylinder.NTSB FTW83LA209Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Cheneyville, LAAccording to the operator, the brakes failed during landing causing the acft to ground loop off of the rwy. He also stated that postcrash investigation revealed a broken brake line on the right brake which he suspects was an act of sabotage by an unknown…