NTSB investigations: Pratt & Whitney Canada PT6A-60A, 2000
3 cases on aircraft whose registry engine model is Pratt & Whitney Canada PT6A-60A. 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
| 1966 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 2 |
| 1972 | 3 |
| 1973 | 1 |
| 1975 | 2 |
| 1976 | 1 |
| 1977 | 2 |
| 1978 | 4 |
| 1979 | 5 |
| 1980 | 3 |
| 1981 | 2 |
| 1983 | 3 |
| 1984 | 1 |
| 1985 | 5 |
| 1986 | 7 |
| 1987 | 6 |
| 1988 | 6 |
| 1989 | 9 |
| 1990 | 1 |
| 1991 | 8 |
| 1992 | 4 |
| 1993 | 6 |
| 1994 | 3 |
| 1995 | 6 |
| 1996 | 6 |
| 1997 | 5 |
| 1998 | 6 |
| 1999 | 3 |
| 2000 | 3 |
| 2001 | 9 |
| 2002 | 7 |
| 2003 | 4 |
| 2004 | 9 |
| 2005 | 11 |
| 2006 | 2 |
| 2007 | 4 |
| 2008 | 9 |
| 2009 | 7 |
| 2010 | 5 |
| 2011 | 4 |
| 2012 | 4 |
| 2013 | 4 |
| 2014 | 4 |
| 2015 | 2 |
| 2016 | 8 |
| 2017 | 6 |
| 2018 | 6 |
| 2019 | 3 |
| 2020 | 2 |
| 2021 | 5 |
| 2022 | 4 |
| 2023 | 7 |
| 2024 | 5 |
| 2025 | 8 |
| 2026 | 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\") = 2000
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52043', '51999'))
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") = 2000
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52043', '51999'))
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 IAD01FA015Accident · No injuriesField investigationFinal reportBeech F90 · Lynchburg, VAImproper rigging of both propeller assemblies by maintenance personnel, which resulted in the inadvertent feathering of both propellers after takeoff. Factors included a lack of rigging experience in airplane make and model by maintenance personnel, unclear…NTSB MIA00FA229Accident · 1 fatalField investigationFinal reportde Havilland DHC-6-200 · Raleigh, NCthe pilot's continued VFR flight into IMC conditions, by failing to maintain altitude, and descending from VFR conditions into IMC, which resulted in him subsequently impacting with trees. Factors in this accident were: reduced visibility due to dark night…NTSB MIA00IA164Incident · No injuriesIncident investigationFinal reportBeech 1900C · Fort Lauderdale, FLThe failure of the first officer to comply with procedures and directives for his failure to assure that the forward airstair door was closed and locked. A contributing factor in the incident was the inoperative annunciation system of the forward airstair…