NTSB investigations: Pratt & Whitney R1340 series, TX
8 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 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1990 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 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 c.\"eventStateOrRegion\" = 'TX' 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')
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 c."eventStateOrRegion" = 'TX' 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')
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 DFW07LA148Accident · Serious injuriesLimited investigationFinal reportAir Tractor 301 · Lueders, TXThe pilot's failure to maintain airspeed which resulted in an inadvertent stall and subsequent impact with terrain.NTSB FTW01LA119Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Rosharon, TXthe pilot's failure to maintain aircraft control while maneuvering. Factors were the weather conditions and the muddy terrain.NTSB FTW00LA212Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-401 · Panhandle, TXThe pilot's failure to maintain airspeed, which resulted in a stall.NTSB FTW90DRA09Accident · No injuriesFinal reportGrumman G-164A · Altair, TXThe pilot's use of improper terrain for takeoff.NTSB FTW90DRG04Accident · No injuriesFinal reportAir Tractor AT-301 · Mission, TXThe pilot's failure to maintain proper clearance above the crops he was spraying. A factor was the tree induced mechanical turbulence encountered during the descending turn.NTSB FTW85LRA04Accident · Minor injuriesFinal reportRockwell S2R-600 · Rosharon, TXThe plt reported the acft contacted the ground after the left boom caught weeds during a spray run.NTSB FTW83LA432Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Bay City, TXDuring a swath run, the acft came to contact with the crop that was being sprayed. This resulted in a loss of control & the acft impacted in the field & nosed over. A small post-crash fire erupted in the eng compartment, but burned itself out shortly…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.