NTSB investigations: Pratt & Whitney R1340 series, FL
6 cases on aircraft whose registry engine model is Pratt & Whitney R1340 series, where the first occurrence was “In flight collision with object”. 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
| 1991 | 1 |
|---|---|
| 1993 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2003 | 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\" = 'FL' 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\" = 220))
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" = 'FL' 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" = 220))
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 MIA03LA094Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT- 401 · Fellsmere, FLThe poor in-flight planning by the pilot-in-command for his overhsooting the pull-up following a spray pass resulting in the in-flight collision with trees then terrain. Contributing to the accident was sunglare that the pilot encountered during the spray…NTSB MIA99LA160Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Orlando, FLThe pilots misjudgment of altitude during an attempted banner tow pick-up. This resulted in the banner becoming entangled around the main landing gear. The pilot made a go-around. On landing rollout the banner became entangled around a runway light, and the…NTSB MIA97LA208Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Altha, FLthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain control of the airplane.NTSB MIA95LA180Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Clewiston, FLImproper weather evaluation by the pilot in command while attempting to takeoff with a quartering tailwind associated with a nearby thunderstorm and failure of the pilot to maintain directional control.NTSB MIA93LA176Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Immokalee, FLThe pilot-in-command's failure to maintain airspeed (vs) while maneuvering resulting in a stall/mush.NTSB MIA91LA183Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Greenwood, FLThe inadequate preflight which resulted in debris in the cockpit which reduced the pilot's visual lookout. Unsuitable terrain encountered during the landing was a factor.