NTSB investigations: Pratt & Whitney R1340 series, 2007
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\") = 2007
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") = 2007
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 LAX08CA034Accident · Serious injuriesData collectionFinal reportAir Tractor AT-401 · Soledad, CAThe pilot's failure to maintain an adequate clearance from mountainous terrain while maneuvering during an aerial application mission. Contributing to the accident was the pilot's diverted attention inside the cockpit.NTSB NYC07LA219Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-2 · Virginia Beach, VAThe pilot's inability to maintain control of the airplane due to physiological incapacitation. Contributing to the accident was the failure of the Federal Aviation Administration to deny or restrict the pilot's medical certification, and the pilot's improper…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 CHI07LA162Accident · 1 fatalLimited investigationFinal reportAero Commander S2R · Watford City, NDThe agricultural pilot's failure to maintain clearance from the terrain while maneuvering to avoid power lines. The power lines were a contributing factor in the accident.NTSB DFW07CA081Accident · No injuriesData collectionFinal reportGulfstream-Schweizer G-164B · Arcola, MSThe pilot's failure to maintain clearance from trees while maneuvering during aerial application.