NTSB investigations: Pratt & Whitney PT6A series, 1997
5 cases on aircraft whose registry engine model is Pratt & Whitney PT6A 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
| 1982 | 1 |
|---|---|
| 1987 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 3 |
| 1996 | 2 |
| 1997 | 5 |
| 1998 | 3 |
| 1999 | 3 |
| 2000 | 4 |
| 2001 | 4 |
| 2002 | 3 |
| 2003 | 3 |
| 2004 | 4 |
| 2005 | 3 |
| 2006 | 2 |
| 2007 | 4 |
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\") = 1997
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52032', '52034')
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 year(c."eventDate") = 1997
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52032', '52034')
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 LAX98FA013Accident · No injuriesField investigationFinal reportBeech 99-C99 · Meadview, AZThe pilot's inadequate in-flight decision, inadequate visual lookout, and his failure to maintain adequate obstacle clearance. Contributing was low altitude flight.NTSB FTW97FA285Accident · 1 fatalField investigationFinal reportAyres S2R-T15 · Oakridge, LAThe pilot's failure to maintain clearance for undetermined reasons.NTSB FTW97LA196Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Welsh, LAThe pilot's failure to maintain clearance with a moving vehicle. Factors were: the lack of runway signs and a runway safety area, and the difficulty for the pilot and driver of the vehicle to visually detect each other due to high vegetation at the edge of…NTSB MIA97GA059Accident · 1 fatalFinal reportAyres S2RHG-T65 · Guaviare, Colombiathe pilot's failure to maintain adequate altitude/clearance while maneuvering at a low altitude.NTSB FTW97LA074Accident · No injuriesLimited investigationFinal reportBeech C90A · Rio Grande City, TXThe pilot's failure to maintain clearance with the tower. Factors were the low ceilings and the pilot's diverted attention to his navigation.