NTSB investigations: Pratt & Whitney R1340 series, 1986
4 cases on aircraft whose registry engine model is Pratt & Whitney R1340 series, where the first occurrence was “Airframe/component/system failure/malfunction”. 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 | 2 |
| 1984 | 4 |
| 1985 | 4 |
| 1986 | 4 |
| 1987 | 4 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 2 |
| 1996 | 1 |
| 1998 | 4 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 4 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 2 |
| 2007 | 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\") = 1986
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\" = 130))
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") = 1986
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" = 130))
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 MIA87FA013Accident · 1 fatalField investigationFinal reportGrumman G-73 · St. CroixThe plts lost aileron control shortly after takeoff while in a left turn. The left turning tendencies of the acft could not be corrected and the acft crash landed in the carribean sea. Post crash inspection of the acft revealed the left aileron control cable…NTSB FTW86FRG20Accident · No injuriesFinal reportAir Tractor AT301 · Taylor, TXCommercial pilot of an Air Tractor AT301 enroute to base of operations at Taylor, TX executed a forced landing after experiencing severe vibration in the aircraft. Landing was made to a soft field. The aircraft nosed over during landing roll and was…NTSB SEA86LA081Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Prescott, WAThe brake locking system engaged in flight causing the right brake to lock. The aircraft nosed over on landing where a small fire erupted from fuel spillage onto the hot engine.NTSB MKC86LA061Accident · Minor injuriesLimited investigationFinal reportSchweizer G164-B · Colt, ARThis was a new acft which the owner was ferrying from the dealer to his private ag strip. The landing was made to the north on a half mile long grass strip and the wind was calm. The plt reports that the brakes were locked when the acft touched down and the…