NTSB investigations: Pratt & Whitney PT6A series, 1996
10 cases on aircraft whose registry engine model is Pratt & Whitney PT6A series. 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
| 1964 | 1 |
|---|---|
| 1969 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1980 | 3 |
| 1981 | 1 |
| 1982 | 2 |
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 5 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 6 |
| 1993 | 2 |
| 1994 | 9 |
| 1995 | 10 |
| 1996 | 10 |
| 1997 | 23 |
| 1998 | 14 |
| 1999 | 16 |
| 2000 | 20 |
| 2001 | 24 |
| 2002 | 28 |
| 2003 | 34 |
| 2004 | 26 |
| 2005 | 25 |
| 2006 | 21 |
| 2007 | 32 |
| 2008 | 22 |
| 2009 | 19 |
| 2010 | 18 |
| 2011 | 23 |
| 2012 | 21 |
| 2013 | 20 |
| 2014 | 20 |
| 2015 | 15 |
| 2016 | 25 |
| 2017 | 19 |
| 2018 | 15 |
| 2019 | 17 |
| 2020 | 19 |
| 2021 | 9 |
| 2022 | 12 |
| 2023 | 10 |
| 2024 | 18 |
| 2025 | 11 |
| 2026 | 8 |
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\") = 1996
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'))
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") = 1996
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'))
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 CHI97IA029Incident · No injuriesIncident investigationFinal reportBeech 1900D · Hopkensville, KYthe materials used in the new windshield, to meet new EPA requirements, were inadequate for the design.NTSB MIA97LA012Accident · Minor injuriesLimited investigationFinal reportAir Tractor 400 · Sylvester, GAWas the pilots intentional disregard for operating the engine contrary to the flight manuals for intentionally exceeding the maximum engine temperature, resulting in creep failure of one of the compressor turbine blades.NTSB MIA96LA232Accident · 1 fatalLimited investigationFinal reportAir Tractor 402 · Slocomb, ALThe pilot's failure to maintain airspeed.NTSB FTW96FA399Accident · 1 fatalField investigationFinal reportAyres S2R-T45 · Granger, TXthe pilot's inadvertent flight into adverse weather conditions, and subsequent loss of aircraft control due to spatial disorientation. Factors relating to the accident were darkness, the prevailing fog and low ceilings, the inadequate flight instruments…NTSB ATL96LA130Accident · 1 fatalLimited investigationFinal reportAir Tractor 402 · Mayersville, MSthe pilot's misjudgment of his ground speed and distance to trees during the swath run, and his delayed pull-up at the end of the swath run, which resulted in his failure to remain clear of the trees. The tail wind and location of the trees were related…NTSB LAX96LA328Accident · No injuriesLimited investigationFinal reportCessna 425 · Auburn, CAfailure of the right brake system (master cylinder O-ring seal). Factors relating to the accident were: the narrow runway, and the presence of a ditch adjacent to the runway.NTSB CHI96IA191Incident · No injuriesIncident investigationFinal reportBeech 1900 · Lansing, MIthe short in the windshield anti-ice low power braided copper lead wire caused a fire that had resulted from the manufacturer's inadequate design.NTSB ANC96LA076Accident · Minor injuriesLimited investigationFinal reportBeech 99C · Barrow, AKan in-flight collision with a bird.NTSB MIA96WA150Accident · 3 fatalForeign investigationde Havilland DHC-6-200 · Bagua, PeruNTSB NYC96LA058Accident · Minor injuriesLimited investigationFinal reportBeech 1900D · Bradford, PAthe pilot misjudged the flare during landing. Factors in the accident were: an improper recovery from a bounced landing, and the first officers lack of experience in this type operation.