NTSB investigations: Pratt & Whitney R1340 series, 1982
5 cases on aircraft whose registry engine model is Pratt & Whitney R1340 series, where the first occurrence was “In flight collision with terrain/water”. 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 | 5 |
|---|---|
| 1983 | 3 |
| 1984 | 5 |
| 1985 | 4 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 4 |
| 1991 | 5 |
| 1992 | 4 |
| 1993 | 1 |
| 1994 | 4 |
| 1995 | 3 |
| 1996 | 1 |
| 1997 | 3 |
| 1998 | 1 |
| 1999 | 4 |
| 2000 | 1 |
| 2001 | 3 |
| 2002 | 2 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 5 |
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\") = 1982
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\" = 230))
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") = 1982
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" = 230))
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 FTW82DA238Accident · No injuriesFinal reportRockwell Intl S-2R · Eudora, ARSince the aircraft had not flown for two months, the pilot was on a flight to check the systems before flying for hire. The pilot flew over an unpopulated area of the Mississippi river with clear water in the spray tanks. He stated that while he as spraying…NTSB SEA82DA083Accident · Minor injuriesFinal reportGrumman G-164A · Dayton, WAThe pilot had just returned to the area after picking up a load of di-syston. Another ag aircraft had been spraying in an adjacent field. The pilot circled and looked for the other aircraft, but did not see it. He stated that he checked the smoke to determine…NTSB FTW82DA205Accident · No injuriesFinal reportGrumman G-164A · Angleton, TXWhile concentrating on his flagger, the pilot misjudged his altitude and allowed the aircraft to collide with a levee. The pilot then dumped his load and made an emergency landing, during which time, the aircraft nosed over.NTSB FTW82DA172Accident · No injuriesFinal reportGrumman G164B · Marvell, ARDuring an aerial application process the pilot allowed the aircraft to collide with a rice levy. The aircraft was destroyed and there were no injuries to the pilot.NTSB FTW82DA089Accident · No injuriesFinal reportRockwell S-2R · Oberlin, LAAs the pilot was completing a spray run, he started to close the hopper, but it felt to him that the handle had broken. He looked inside the cockpit momentarily. When he looked back outside, the aircraft had begun a descent. It was too close to the ground to…