NTSB investigations: Pratt & Whitney R1340 series, 1988
5 cases on aircraft whose registry engine model is Pratt & Whitney R1340 series, where the first occurrence was “Loss of control - on ground/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 | 2 |
|---|---|
| 1983 | 5 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 3 |
| 1988 | 5 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 1 |
| 1996 | 5 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 7 |
| 2000 | 4 |
| 2001 | 1 |
| 2002 | 3 |
| 2003 | 6 |
| 2004 | 6 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 2 |
Where
Latest 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\") = 1988
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\" = 260))
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") = 1988
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" = 260))
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 ATL89LA008Accident · Serious injuriesLimited investigationFinal reportNorth American T-6G · West Jefferson, NCDuring a landing attempt, the pilot lost directional control and veered off the right side of runway 27. The pilot reported applying opposite braking with negative results. The airplane examination failed to disclose any system problem.NTSB MKC88LA158Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Humphrey, ARWhile attempting to land on a narrow dirt road bordered by crops, the plt said he contacted the high vegetation on the right side. The acft began to veer to the right. The plt attempted to steer to the left and veered off the roadway into a ditch and nosed…NTSB MKC88LA116Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cotton Plant, ARThe pilot did not adequately secure the aircraft prior to hand-propping the engine. The engine started and resulted in the aircraft taxiing without a pilot at the controls. The pilot-less aircraft impacted a utility pole causing substantial damage.NTSB ANC88LA066Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-3 · Eagle, AKThe pilot was attempting to land a heavily loaded De Havilland otter (DHC-3) on a gravel strip in rural Alaska. Upon touchdown, the pilot reported that the airplane veered slightly to the right. He unlocked the tail wheel centering device and attempted to…NTSB CHI88LA106Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Eden Prairie, MNWhile on an aircraft familiarization for purpose of check out, the pilot encountered a gusty crosswind on landing and failed to maintain aircraft control. The instructor pilot took over the controls, but was unable to regain directional control, and the…